Docstoc

SR. ETL AND BUSINESS INTELLIGENCE _LEAD DEVELOPER_ARCHITECT

Document Sample
SR. ETL AND BUSINESS INTELLIGENCE _LEAD DEVELOPER_ARCHITECT Powered By Docstoc
					        SR. ETL AND BUSINESS INTELLIGENCE LEAD DEVELOPER/ARCHITECT

        Please click here to hire this person or to receive similar resumes

SUMMARY:

      Over 9+ years of experience in Business Intelligence, Data Integration (ETL) and Data warehouse
       domain.
      Provided Techno-functional guidance as a Data Architect for fortune 50 clients in designing and
       developing the next generation Analytics for the benefit of new and existing businesses domains.
      Ivy League education from India can provide a boost and a blend of new ideas to the Key process Areas of
       the business and its vision. Excellent in presentation and communication skills
      Project Management, Requirements Gathering, Off shoring, Deadline Negotiation; Working on complex
       design problems; Resource planning and work allocation; Mentoring new team members; Perform peer
       reviews and Developing, Reviewing and delivering final solutions.
      Expertise in Management of complete Project life cycle. Completed more than 5 end-end
       implementations.
      Lead a team of over 6 resources for over 4 years. Also done Offshore/Onsite Co-ordination for over 6
       Years.
      Received spot recognition for Outstanding Achievement and excellent team work in January 2005.
      Placed at 2nd position in the training batch of 120 new hires at India’s number one software services
       company.

DOMAIN KNOWLEDGE:

      Functional Expert on Business Domains like Insurance, Investments, Credit Cards, Public Safety and
       Advertising.
      Financial Domain areas include Assets management, Fixed Income products, Portfolio Accounting and
       Management (PAM), Derivatives, Real Estates, Securities, Supply Chain and Accounting Data. (6 + Years
       )

DATAWAREHOUSE SKILLS

      9+ years Experience in Business Requirement Analysis, Application Design, Data Modeling,
       Development and Implementation of Data warehousing and Database business systems using
       Informatica, SAP Business Objects, SAP Data Integrator XI, Data Modeling, Oracle, and PL/SQL on Unix
       and Windows platforms.
      Data warehouse building and have created various star schemas and denormalized datamarts. Involved
       in Design and implementation of several data warehouse including Logical and Physical Data model
       Design.
      Fine-tuning and setting up ETL and BI environments with respect to attributes i.e. efficiency,
       performance etc.
      Strategies and setting up Procedures to Extract, Transform & Load (ETL) data from Operational & Legacy
       Systems to the Data Warehouse by Using Informatica/Data Integrator.
      Design & documentation of Multi-Dimensional Data Models. 6+ Years experience in modeling star
       schema, Fact and Dimension Tables and star schema design.
      End to End implementation of several Dashboards and Daily scoreboards.
      Test plans, analyzed QA test plans, monitored defect tracking procedures and test metrics

CORE TECHNICAL SKILLS

      Expert (SME) on all the Technical areas including installation of the SAP Business Objects XI 3.1 and 5x/6x
       OLAP reporting and Data services (Data Integrator) XI 3.1 ETL mapping creation.
         SR. ETL AND BUSINESS INTELLIGENCE LEAD DEVELOPER/ARCHITECT

       Functional areas of SAP BO Desktop Intelligence, Central Management Console, Designer, Performance
        Management, Dashboard Manager, Strategy Builder, WEBI, Crystal Reports 2008, Xcelsius 2008 and SAP
        Dataservices XI 3.1 (Data Integrator).
       Expert (SME) on Informatica 8.x/7.x/6.x/5.x/4.x, (Power Mart /Power Center) including installation,
        Oracle 10g/9i/8i, DB Artisan, Oracle utilities & tools (Export, Import, SQL*loader, PL/SQL, TOAD,
        Procedure Builder), Unix Shell Scripts, Sybase etc in Windows and Unix environments.
       Data Quality expert and attributes cleansing and address cleansing. Non-standard data within specified
        guidelines to comply with a Master Data Management especially address, person records.
       Designing addresses Geocoding, The process for spatial reference to address data nationally and
        internationally
       Expertise in Migration and Conversion of SAP Business Objects and Informatica.
       Technical Training completed on RDBMS databases i.e. Oracle 10g, Sqlserver and teradata.
       Third Party tools SQL Plus, TOAD, MS office, Visio, Erwin 3x/4x, ER Studio and Power Point.
       Functional training completed across various tools of Datawarehouse (Cognos, teradata, Web Focus).
       Coding using SQL, SQL*Plus, PL/SQL, Procedures/Functions, Triggers, Packages. Perl, Unix Shell Scripting.

EDUCATION:


Institute of Technology,                Bachelor of Chemical Engineering and             September 1997- April 2001
Banaras Hindu University, India         Technology
IIT-JEE AIR 1893

PROFESSIONAL & TECHNICAL CERTIFICATIONS

       Certified Six Sigma Green Belt.
       Trained and experienced for Project Leadership by No.1 technical consultancy Company.
       Trained and experienced for Technical quality management by No.1 technical consultancy Company.




          Please click here to hire this person or to receive similar resumes

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:10/21/2011
language:English
pages:2