PROFILE SUMMARY:

• 10 Years’ experience in Data warehousing - BI domain with Strong techno functional background (h1b ready)
• 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
• 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 Confidential for evaluation of Informatica Analyzer reporting tool
• 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:

• 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
• 5+ Years’ Experience as lead (onsite/offshore), Architect, Manager.

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

PROFESSIONAL EXPERIENCE:

Confidential

Offshore lead

Database: Oracle 11 g

Tools: OBIA, OBIEE, INFORMATICA, DAC, EBS ( Financials, Projects)

O/s: Windows.

Responsibilities:

• 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

Offshore lead

Database: Oracle 11 g

Tools: OBIA, OBIEE, INFORMATICA, DAC, JDE (Financials)

O/s: Sun Solaris.

Responsibilities:

• Working on Project Plan, Estimation, High Level design
• Designing the staffing plan and coordinating with Clients and Source System teams
• Identifying KPI’s for Confidential, 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

Offshore Lead/ Technical Architect

Database: Oracle 10 g

Tools: Informatica 8.5

O/s: Confidential -UX .

Responsibilities:

• 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 on Informatica suite of products to the development team

Confidential

Senior Developer/ETL lead

Database: Oracle 10 g

Tools: Informatica 8.5

O/s: Confidential -UX .

Responsibilities:

• Working as a Senior ETL developer
• Working as Onsite ETL team lead.

Confidential, Washington, DC.

ETL Architect /Onsite Coordinator

Database: Oracle 10 g

Tools: Informatica 8.5

O/s: Confidential -UX .

Responsibilities:

• 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

Data Supply Architect /Onsite Coordinator

Database: Oracle 10 g

Tools: Informatica 8.5, Cognos 8

O/s: Linux.

Responsibilities:

• 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

Technical leader (ETL)

Database: Oracle 10 g

Tools: Informatica 8.1, WEBI, BO XI

O/s: Sun Solaris .

Responsibilities:

• 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 s for knowledge transition to Support team after successful implementation.

Confidential

Technical Leader/Release Coordinator

Database: Oracle 10 g

Tools: Informatica 7.1, WEBI, BO XI

O/s: UX .

Responsibilities:

• Designing/Implementation of the job tables logging mechanism for Controlling and logging the ETL process and getting the approval of clients on proposed design
• Installation /Environmental Setup of informatica on development server
• Assisting (in) and validating the ETL development efforts by team members as per the Universe specifications provided
• Creating ETL for Fact table load
• Also part of BO XI universe validations /enhancements ( as per end user’s requirements) and development of sample WEBI reports as per the specifications (provided on spreadsheet).

Confidential

Team member/ Team leader

Languages: Pl/SQL

Database: Oracle 9i, Shell Scripts

Tools: Informatica 7.1

Responsibilities:

• Development of Informatica Mappings for Confidential region (v2 2 2).
• Work with business to develop informatica mappings to populate data elements as per specifications received( 70+ mappings).
• Development/Enhancement of shell scripts to invoke the above ETL update configuration tables provide error logging.
• Maintain coherence in development standards across Indian and Chinese team suggest /implement common practices
• Revisions and re works as required for new releases (v3 1).
• Required documentation for Support operations team to take over and maintain the application.

Confidential

Team member

Languages: Pl/SQL

Database: Oracle 9i

Tools: Informatica 6.2, Business objects, BCA, Maestro, TIDAL

O/s: Windows 2003 Prof.

Responsibilities:

• User request regarding BCA scheduling changes, Business objects and Informatica workflows
• Change Management moving code from development to integration and production
• L3 Oracle DBA support activities like monitoring tablespace, executing scripts, Killing long running sessions, loading data by SQL LOADER
• Production monitoring of schedules

Confidential

Team Lead (offshore)

Languages: Pl/SQL

Database: Oracle 9i

Tools: Informatica 6.2, Business objects, Dollar Universe

O/s: Windows 2003 Prof.

Responsibilities:

• Development /enhancement of Informatica Mappings for addition of new matrices identified in Dimension tables.
• Implement Changes in BO - Universe to accommodate the new objects added.
• Preparation of test Cases, Unit Testing, Historical load of the data.
• Tuning of slow running queries in Pl/Sql packages used to populate Fact Tables.
• Handling Client communication
• Response to Client queries, Support to Confidential Data warehouse Duty team in migration of the code to production
• Assist offshore QA team in testing of the ETL

Confidential

Team Member

Languages: Pl/SQL

Database: Oracle 9i

Tools: Informatica

O/s: Windows 2003 Prof.

Responsibilities:

• Development of Informatica Mappings
• Performance tuning of PL/SQL packages for bookings.
• Preparation of test Cases, Unit Testing, Historical load of the data
• Handling Client communication
• Response to Client queries, Support to Confidential Data warehouse Duty team in migration of the code to production
• Address post production issues