Manager Developer

NEETU SHARMA

Email : **************@*****.***

Location: Los Angeles, California

Contact: +1-208-***-****.

PROFESSIONAL SUMMARY

9+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing using ETL Informatica Power Center Development and Administration, Oracle Database Development and Reporting technologies.

Expertise in working with Informatica Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities.

Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.

Involved Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De Normalization Concepts in different database modeling techniques like Object Oriented Design and Modeling, Database Design and Modeling, etc.

Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.

Well Experienced in doing Error Handling and Troubleshooting using various log files.

Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.

Expertise in Administration tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PROD environments, managing Users, Groups, associated privileges, code page setups and performing backups of the repository.

Experience in Informatica Power Center 8.x/9.x System Administration.

Code deployment and Code sync between various environments.

Experience in Setup of Workflow and scheduling Load Jobs, monitoring and restart in case of hung state

Expertise in Installation, configuration, upgrade and migration of Informatica Power Center and other related products.

Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command line language.

Expertize in Root Cause analysis for ETL job failures/Data issues performance tuning and troubleshooting issues

Scheduling and Monitoring Informatica repository backups and Creating new repositories from scratch, backup and restore.

Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, synonyms.

Extensively worked with Oracle PL/SQL Stored Procedures, Triggers, Functions, and Packages and also involved in Query Optimization.

Has working knowledge of Hadoop Ecosystem (Pig & Hive), HDFS and Map Reduce.

Proficiency in designing and developing reports using ACTUATE BIRT & Microstrategy reporting tool as per the client’s requirements.

Provide technical and functional support and knowledge transfer to team members as well as new members of the project.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/8.1/7.2

Databases: Oracle 11g/10g/9i, Teradata.

Programming: Oracle PL/SQL, HTML, C, C++

Database Tools: TOAD

Scheduler: Control-M

Big Data Ecosystems- Hadoop, Map Reduce, HDFS, HBase, Hive, Pig, Sqoop, Oozie.

OS: Linux, AIX, Windows 2003/2005/2008/2012.

BI Tools: Actuate 8 & 9, Actuate BIRT.

Other Tools: MS Word, MS PowerPoint, MS Excel

WORK EXPERIENCE

Client Time Warner

Role: Informatica Administrator

Duration &

Location: Sep 2013 – Dec 2016(Los Angeles CA)

Roles & Responsibilities:

Responsible for Installation, configuration and Administration of Informatica Power Center 9.1.

Experience in creating Deployment Groups and Applying Labels.

Deployment of Informatica Mappings/Sessions/Workflows into Production environment ensuring code sync up in DEV/UAT/PROD environments.

Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using Control-M.

Managing the DEV/QA/UAT/PROD environments.

Support development teams with performance tuning and troubleshooting issues

Made several Informatica best practice documents and uploaded in the project shared drive.

Gave Informatica learning sessions to new members in the team and guided them in case of any issues.

Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed.

Scheduling jobs through Control M for monthly and daily job cycles.

Worked on tuning mapping by optimizing the SQL overrides, Lookup caches and various other transformations like aggregator, router, filter etc.

Direct interaction with the clients at onsite to understand the business requirement and conduct meeting with the business to have a clear picture of the development.

Co-ordination with the offshore - onsite team to make them aware of the business requirements.

Attend daily meeting with the offshore team to give a proper handover of the EOD business activity.

Client NXP Semiconductors

Role: Informatica Developer

Duration &

Location: Jun 2012 –Aug 2013(San Jose, USA)

Roles & Responsibilities:

*Proposed design of ETL jobs and create the high level and low level documents for the load

*Worked on PL SQL procedures.

*Involved in Unit testing, System testing to check whether the data loaded into the target table was accurate which was extracted from the source systems according to the user document.

*Created Mapplet, reusable transformations and used them in different mappings.

*Responsible for creating and modifying the PL/SQL procedures, functions according to the business requirement.

*Prepared ETL mapping Documents for every mapping for smooth transfer of the project from development to testing environment and then to production environment.

Company: Tata Consultancy Services

Client: Aviva Plc

Role: Informatica Developer

Duration &

Location: June 2011 – May 2012(Norwich, UK)

Roles & Responsibilities:

*Responsible in gathering Requirements and IT review. Interacted with Business Users in the design of technical specification documents.

*Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.

*Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.

*Worked on Push Down Optimization to optimize Oracle loads.

*Worked on Teradata database and developed Views, tables.

*Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.

*Extensively worked on Informatica Performance tunning to find potential bottlenecks in the Source, Informatica and Target systems.

*Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 8.6.

*Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

*Written documentation to describe program development, logic, coding, testing, changes and corrections.

*Prepared ETL mapping specification document.

*Assisted Testing team in creating test plan and test cases.

*Designed and documented ETL standards document.

*Conducted code reviews developed by my team mates before moving the code into QA.

Company CGI Information System

Client: Deutsche Bank

Role: Informatica, PL SQL & Report Developer

Duration

&Location: Jun2010– May 2011 (New Jersey, USA)

Roles & Responsibilities:

*Direct interaction with the client onsite to understand the requirement and gather the information required for the implementation.

*Coordinating with the offshore team and passing the right information.

*Involved in end to end design, development and complete deployment of the Informatica jobs and reports.

*Proper testing of the jobs after migration to Production.

*Developed mappings, sessions and workflows in Informatica Power Center.

*Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

*Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

*Extensively used workflow variables, mapping parameters and mapping variables.

*Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

*Implemented Informatica recommendations, methodologies and best practices.

*Performed Unit testing, System testing of Informatica mappings.

*Proper documentation was done to describe the program development, logic, coding, testing, changes and corrections. Prepared the Low Level documents/mapping documents for the tasks assigned to me.

*Tuned performance of existing SQL statements and PL/SQL code.

*Performed code review for the offshore team.

Company CGI Information System

Client: Deutsche Bank

Role: Informatica Developer, Reporting Developer

Duration &

Location: Jun 2007 – May 2010(Bangalore, India)

Roles & Responsibilities:

*Involved in the process of creating mappings and workflows as per the business requirement for Geneva/ GFC source.

*Developed Unix scripts to process source files like tar and txt.

*Design the Report Template for the clients based in the requirements.

*Developed the reports using Actuate reporting tools 8/9/10.

*Involved in Informatica upgrade from 7.1 to 8.1.

*Reviewing and testing the mappings. Develop test cases documents for the same.

*Writing Stored procedure to fetch the data from the table and display it on the actuate reports as mentioned in the business requirement document.

*Created reports using Actuate reporting tool with the data loaded through Informatica and sending the reports to clients as mentioned in the specification document.

*Ability to translate user requirement into a query or report.

*Implemented views, procedures, functions, packages and triggers in PL/SQL to extract the data from the target tables and display on the actuate reports.

AWARDS & RECOGNITION

Key contributor award in CGI information system.

Star of the month award in TCS.

EDUCATION

Master in Computer Application (MCA) from Kalinga Institute of Industrial Technology (KIIT) University, India 2007.

Bachelor in Computer Application (BCA) from Indira Gandhi National Open University (IGNOU), India 2004.

Contact this candidate