Profile Summary:

10 Years' experience in Data warehousing BI domain with Strong techno functional background h1b ready

Technical Expertise:

• ETL- involved in Designing Solutions, Tuning ETL, Effort estimation, Part of 3 end to end Datawarehouse Implementation. Involved in enhancement of 2 OBIA solutions based in JD Edwards and EBS respectively
• Reporting- OBIEE 11g Involved in RPD Configuration/design /Development enhancement related to Financials/SCM/projects modules. Worked on BO XI R1 , 6.5, Involved in design .Part of pilot project is Satyam for evaluation of Informatica Analyzer reporting tool
• DBMS/Data Architecture Hands on all versions of Oracle 8 onwards , OCP 9i DBA with hands on SQL tuning, PL SQL Development and performance tuning, Data modelling Star Schema, Project experience in Sybase , Teradata , Neo view.

Functional Expertise:

• Post Graduate Diploma in Banking from ICFAI.
• FSI Financial Services Industry Level 1 Certification Project experience in AP, AR, GL modules configuration/implementation, Designed BI solution for Investment Mutual fund industry.
• Project experience in Pharma , Retail , Oil Energy Domain

Management Expertise:

• 5 Years' Experience as lead onsite/offshore , Architect, Manager.
• ETL architect on HP GDAS first Latin American engagement.
• Certified PMP.

Skill Summary:

• Major Skills: OBIA, DW BI Architecture concepts, Informatica, PL SQL, Data modeling. Effort Estimation
• Minor Skills: Oracle DBA, Business Objects, Teradata, Neoview, JD Edwards Financials .
• Domain Knowledge: Investment Banking, Pharma and health care

Key Achievements:

• POB Pat on The back Award for year 2004 /5 ,2005/6 as a Part of Satyam Computers
• Best Internal faculty within GDC comprising around 100 associates in Satyam computers
• Roll of honour from Satyam learning Centre as a recognition to the efforts contributed towards training and workforce development activities
• E Award from H.P. for Leadership and Commitment exhibited
• E Award from H.P. for contributions awards successful implementation of AZC application Phase I .
• Applause Award ,Team terrific Award Deloitte Consulting

Projects Profile

Confidential

Contribution

Working on Project Plan , Estimation , High Level design

• Designing the staffing plan and coordinating with Clients and Source System teams
• Identifying KPI's for SWN , Analyzing the gaps in default product provided and design /impact of customizations required to bridge the gaps around data Supply EBS and Data delivery OBIEE , Supervising validating and implementing the solution with Offshore developers
• Provide technical leadership/consultancy to the development team and ensure timely and quality delivery
• Provide technical leadership, complete ownership for problem diagnosis and resolution for ETL related issues
• Provide inputs for the development and implementation of 'Data Quality' Testing strategy
• Knowledge transfer on Customized final application to product

Confidential

Contribution

Working on Project Plan , Estimation , High Level design

• Designing the staffing plan and coordinating with Clients and Source System teams
• Identifying KPI's for Land o Lakes , Analyzing the gaps in default product provided and design /impact of customizations required to bridge the gaps around data Supply JDE and Data delivery OBIEE , Supervising validating and implementing the solution with Offshore developers
• Provide technical leadership/consultancy to the development team and ensure timely and quality delivery
• Provide technical leadership, complete ownership for problem diagnosis and resolution for ETL related issues
• Provide inputs for the development and implementation of 'Data Quality' Testing strategy
• Knowledge transfer on Customized final application to product

Confidential

Contribution

• Working on Project Plan , Estimation , High Level design
• Functional lead
• Provide technical leadership/consultancy to the development team and ensure timely and quality delivery
• Provide technical leadership, complete ownership for problem diagnosis and resolution for ETL related issues
• Provide inputs for the development and implementation of 'Data Quality' Testing strategy
• Knowledge transfer and training on Informatica suite of products to the development team

Confidential

Contribution

Working as a Senior ETL developer

Working as Onsite ETL team lead.

Confidential

Contribution

• Design Data HLD, DLD and other design documents. Work with Clients on getting sign off on all these documents.
• Effort estimation
• Involved in Data Model reviews, Project Scope discussions Pros /Cons
• Participate in business user interviews to understand the Source systems .
• Defining and prioritization of deliverables as per agreed time lines.
• Offshore Coordination to resolve delivery related issues.
• Code reviews and review of Unit test cases results by offshore.

Confidential

Contribution

• Interview source system subject matter experts from a ETL perspective and work on Data integration strategy for data from various source systems.
• Design Data supply documents, ETL templates, ETL process, BRD Relevant to Tech architecture .
• Participate in business user interviews to understand the Source systems .
• Participated in data modeling only ER modeling
• Defining and prioritization of deliverables as per agreed time lines.
• Client status meetings for briefings on adherence to project schedules.

Confidential

Contribution

Handling ETL issues and deliverables as ETL lead

• Code review for Offshore
• Client communication and helping the team with delivery issues.
• Handled responsibilities of a DBA as a make shift arrangement during QA phase of the project.
• Conducting trainings for knowledge transition to Support team after successful implementation.