SUMMARY:

• 6 years of IT experience in Design, Development, Testing, Production Support, Data Integration, Reporting and Data Warehouse Implementations in Financial and Pharmaceutical Domains
• 5 years of ETL (Extract Transform Load) Data Warehouse/Data Integration experience using Informatica Power center 9.6.1/8.6.1 (Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gantt Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, and Shortcuts), Informatica Power Exchange, Performance Tuning, Error Handling, and Implementation of Informatica Best Practices
• Experienced in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using OBIEE 11g
• Expert in Data warehousing concepts such as Dimensional modeling, Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snowflake schemas, Data marts, FACT, and Dimensions tables
• Experience in Relational Databases like Oracle, SQL, PL/SQL, Sybase, DB2, Indexes, Sub Queries, and Performance Tuning
• Experience in Unix Shell Scripting and ETL Process Automation using Shell Programming and Informatica Power Center
• Skilled in project coordination and completion, with strict emphasis in meeting deadlines. Able to prioritize workload and handle multiple assignments efficiently
• Strong and effective analytical, presentation and communication skills. Excellent and quick learner

TECHNICAL SKILLS:

ETL Informatica: Informatica Power center 9.6.1/8.6.1, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Mapplets, Mappings, Workflows, Sessions

Databases: Oracle 10g, Sybase,DB2,Teradata,SQL, PL/SQL

Job Scheduling: Informatica Scheduler, Control M, AUTOSYS

Languages: SQL, PL/SQL, C, COBOL, Shell scripting

Database Tools: TOAD, SQL developer

Reporting Tools: OBIEE 11 g, Tableau 9

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

ETL Informatica /OBIEE Developer

Responsibilities:

• Actively participated in requirement gatherings and followed up with data modeling and testing teams for the SDLC process
• Efficiently converted the business requirements into technical specifications for ETL process using Informatica Power center and Informatica Power exchange
• Designed and developed complex mappings to handle complex business logic using various transformations and other power center tools like Power Exchange
• Resolved source data issues working with System owners and refining transformation rules
• Made sure that the code deployment and release processes are properly done interacting with DBA
• Majorly responsible for change request and defect resolution process from start to end with ITIL best practices
• Effectively performed and documented impact analysis of the business requirement changes to save rework
• Provided production support for issues encountered due to production changes
• Used UNIX scripts to perform sanity checks like data files availability, check header/trailer records, FTP
• Successfully implemented Change Requests with ITIL best Practices
• Using most of the features created AUTOSYS JILs for scheduling and automating the Informatica jobs
• Extensively used various Informatica components like parameters, variables
• Involved in RPD development and create BI reports, dashboards in OBIEE
• Designed and Developed various analytical reports from multiple data sources
• Extensively used SQL, PL/SQL for resolving queries from business
• Actively helped DBAs to prepare SQL scripts for the requirement changes
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Collaborated with onshore and offshore technical partners to design and implement the required data integration solutions
• Wrote and maintained unit tests and QA Reviews

Environment: Informatica Power Center 9.6.1, Power Exchange, Oracle 10g,OBIEE 11g, Unix, Putty, SQL, PL/SQL, SQL Developer, SVN, AUTOSYS Scheduling, Windows XP.

ETL Informatica Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for converting Functional Requirements into Technical Specifications and Mapping Design Documents
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Sybase, Flat Files and Loaded into Target Oracle Database
• Involved in developing the repository layers and dashboards for reporting
• Worked on Informatica Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer
• Utilized Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override for Incremental extraction
• Implemented Data Cleansing, Data Validation, and Data Conversion
• Responsible for best practices like naming conventions, tuning of the mappings, and sessions
• Used Update Strategy to insert, delete, update and reject the items based on the requirement
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations
• Developed Re usable Transformations, and Re Usable Mapplets
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning
• Prepared SQL scripts for DBA activities
• Developed Pl/SQL Procedures for rebuild indexes
• Responsible for implementing change requests with ITIL best Practices
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Worked with the Scheduling team to implement the dependencies across workflows, scripts, and oracle PL/SQL procedures
• Worked with the BI Team for providing and troubleshooting data issues for reports
• Developed and enhanced Unix Scripts for the automation process

Environment: Informatica Power Center 8.6.1, Oracle 11 g, OBIEE 11g, SQL Server, flat files, Control M, UNIX

Mainframe/Informatica Developer

Responsibilities:

• Worked efficiently as a developer in the baseline part of the project including major upgrades, rate load process set-ups
• Executed the change requests involving code changes perfectly with exact impact analysis documentation considering all cases
• Used Informatica Power Center for ETL Implementation
• Resolved business queries using SQL
• Worked as lights-on developer for maintenance type of Service requests provided by Aetna within specified period of time
• Monitored daily jobs involved in smooth functioning of the system using Informatica workflows monitor
• Clarified the requirements and analyzing new requests properly based on corresponding screens and tables
• Responsible for the defect prevention activities in the team by holding regular DP meetings and updating the practices accordingly
• Coordinated QA testing with other developers for scheduled releases of application.
• Liaised with senior management and clients to facilitate and expedite resolution of daily issues
• Created Training module about project process for new members and prepared books of knowledge for future help in the project
• Prepared Design documents for impacted elements, JCLs, PROCs, Copybooks, etc.
• Prepared Unit Test scripts for all the new and modified elements of the projects
• Reviewed test case scenarios with business for timely sign-off

Environment: Informatica Power center, SQL,PL/SQL, Oracle, IBM3090, COBOL, DB2, JCL, FILEAID, QMF, SPUFI, ENDEVOR