We provide IT Staff Augmentation Services!

Offshore Lead Resume

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

Hire Now