SUMMARY:

• 13+ years of IT experience into Business Intelligence/Data warehousing and developing, leading highly effective teams on key customer accounts across Banking, Retail, Insurance, Telecom and Finance domains.
• Have good understanding of BAL and Geneva Billing systems.
• More than 2 years of experience in BI apps environment.
• A consistent performer with a proven track record of providing the services for the company in time and as per the levels of workflow.
• Keen communicator and team leader with good problem solving and analytical abilities.
• Aggressive in acquiring new skills, ability to excel under pressure, innovative and self - motivated.
• Completed Being Agile Aware Confidential certification.
• Member of Confidential recruitment team.

TECHNICAL EXPERIENCE:

• Strong understanding of Data Warehousing Life Cycle.
• Hands on experience in using ETL tools. (Informatica Power Centre and Informatica Power mart and Ab Initio)
• Currently working on Informatica 10.2.0 version.
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables and process mapping using the top-down and bottom-up approach.
• Have understanding of Business Intelligence.
• Understanding of Oracle PL/SQL programming.
• In depth knowledge of Oracle Business Intelligence Enterprise edition.
• Installation of OBIEE 10.1.3.4.1 , Informatica, DAC and BI APPS on Linux/Windows Environments.

TECHNICAL SKILLS

Languages: C, C++, SQL, PL/SQL.

Database servers: TOAD, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, MySQL server and MSSql server.

ETL TOOLS: Informatica versions 5.1, 6.2, 8.6.0, 8.6.1, 9.0.1, 9.5.1, 9.6.1 and 10.2.0, Ab Initio.

OLAP/Reporting Tools: Cognos, Business Objects.

BI apps: Informatica 9.0.1, DAC 10.1.3.4.1 and OBIEE.

Operating System: Windows 7, Windows 2003, 2008, XP and Unix.

Scheduler: Autosys and DAC (Data Warehouse Administration Console)

Domain Knowledge: Banking, Investment Banking, Retail, Insurance, Telecom and Finance domains.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Technology Lead

Environment: Database: Oracle

ETL Tool : Informatica 9.6.1, Informatica 10.2.0

Operating system: Unix

Scheduling tool: Autosys

Release Management: SLM

Responsibilities:

• Leading a team of 6 members in the role of Technology Lead.
• Actively working on 24*7 support and enhancement related project that has Informatica as ETL tool, UNIX as OS and Oracle as the database.
• Gather requirements from Client/Onsite.
• Analyse the High Level Design and Technical Specification Documents.
• Worked on Requirements analysis, Design, development, Quality Assurance and Operations support.
• Resolving technical and design issues.
• Successfully implemented CG initiatives like SLM (Solution life cycle management) for automated releases, PAS (Platform Access Standardization) and Power Center upgrade to 10.2.0 version from 9.6.1 version.
• Closely working with Business users during the month-end batches and provides timely updates in terms of status of the batches (as they get executed continuously for 2 days) as these are very critical to the Business for reporting purpose.
• Actively participating in the DR (Disaster Events) that take place over the weekends in every year.
• Update Business whenever there is any delay in the batches (for any reason) and plan accordingly so that there should not be much impact to Business.
• Provides spontaneous response to the queries posted by business users and supporting teams.
• Provide impact analysis for all the supporting applications whenever there any enhancements planned.
• Single point of contact for SIT/UAT and Performance testing phases.
• Single point of contact for all the deployments to Production.
• Worked on production related documentation (KBAs) for recurring Production incidents.
• Given expert solution to the users for problems in Informatica.
• Working on releases through SLM (Solution life cycle management).

Confidential

Informatica Technology Lead

Environment: Database: Oracle

ETL Tool : Informatica 9.5.1

Operating system: Unix

Scheduling tool: Control-M

Responsibilities:

• Gather requirements from Client/Onsite.
• Leading a team of 8 members at Offshore.
• Resolving all environmental issues like Informatica upgrade from and helping CM team in sync up of database between DEV-SIT-PROD.
• Analysed the High Level Design and Technical Specification Documents.
• Worked on Requirements analysis, Design, development, Quality Assurance and Operations support.
• Assigning the tasks to the team members and help them in developing the code and unit testing.
• Reviewing the code before delivering it to the client/onsite.
• Resolving technical and design issues.
• Documentation of various standards, best practices & review process documents to be used as guidelines.
• Single point of contact for SIT/UAT and Performance testing phases.
• Single point of contact for all the deployments.
• Worked on production related documentation.
• Given Knowledge transfer to Application support Group.
• Given expert solution to the users for problems in Informatica.
• Mentored new team members with continuous knowledge transfer.

Confidential

Informatica Technology Lead/Onsite Co-ordinator

Environment: Database: Oracle

ETL Tool : Informatica 9.5.1

Operating system: Unix

Responsibilities:

• As an Onsite Co-ordinator I have interacted with different teams, SMEs, process & system owners to clarify the requirements.
• Also ensured to complete SIT, UAT and performance testing process.
• Contributing to the system architecture design.
• Setting up the infrastructure in co-ordination with client infrastructure team.
• Analysed the High Level Design and Technical Specification Documents.
• Requirements analysis, Design, development, Quality Assurance and Operations support.
• Reviewing the code before delivering it to the client.
• Documentation of various standards, best practices & review process documents to be used as guidelines.
• Created Cyber Ark account for Informatica and dlepriv and dleread accounts for UNIX as per RBS best practice.

Confidential

Informatica Technology Lead

Environment: Database: Oracle

ETL Tool : Informatica9.0.1

Responsibilities:

• Gather requirements from Client/Onsite.
• Leading a team of 16 members at Offshore.
• Analysed the High Level Design and Technical Specification Documents.
• Requirements analysis, Design, development, Quality Assurance and Operations support.
• Developed several Mappings and Mapplet using corresponding Source, Targets and Transformations.
• Extensively worked on transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Expertise in tuning the mappings and sessions to optimize the performance.
• Preparing unit test cases and documentation.
• Preparing Mapping specs and Test specs documentation.
• Reviewing the code before delivering it to the client/onsite.
• Documentation of various standards, best practices & review process documents to be used as guidelines.

Confidential

Informatica ETL Code Designer, DAC implementation and Team Lead

Environment: Database: Microsoft SQL server 2008

ETL Tool: Informatica9.0.1

Scheduler Tool: DAC 10.1.3.4.1 (Data Warehouse Administration Console)

Responsibilities:

• Gather requirements from Client/Onsite.
• Extract the data from different source systems like JDE8.0,JDE9.0 and flat files and loading into warehouse.
• Building mappings according to OBIEE standards.
• Designed the project in such a way that there are total 5 phases
• Created sessions and workflows following OBIEE standards both for Full and Incremental loads.
• Unit testing and data validations.
• Helping the team in resolving the technical/non-technical issues.
• At DAC level, I have scheduled the EP’s as per the client specifications after creating the tasks, assembling ‘subject areas’ and building the ‘Execution plans’.
• Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
• Prepared documents like Technical design document and Data mapping document.
• Reports will be generated using OBI reporting tool.

Confidential

Informatica ETL Code Designer, DAC implementation and Team Lead

Environment: Database : Oracle 9i

ETL Tool : Informatica9.0.1

Scheduler Tool: DAC 10.1.3.4.1 (Data Warehouse Administration Console)

Responsibilities:

• Gather requirements from Client/Onsite.
• Building mappings according to OBIEE standards.
• Designed the project in such a way that there are 2 phases, SDE and SIL, as per the BI standards at Informatica level
• Created sessions and workflows following OBIEE standards both for Full and Incremental loads.
• Unit testing and data validations.
• Helping the team in resolving the technical/non-technical issues.
• At DAC level, I have scheduled the EP’s as per the client specifications after creating the tasks, assembling ‘subject areas’ and building the ‘Execution plans’.
• Prepared documents like Technical design document and Data mapping document.
• Reports will be generated using OBI reporting tool.