SUMMARY:

• Technically competent Oracle Certified Associate (OCA), 9+ years of extensive experience in Information Systems with a strong emphasis in ETL development.
• Informatica: Data Warehousing experience using Informatica Power Center 9.6.1/9.5.1 ,Informatica Developer, Informatica Analyst, ETL, Data mart OLAP, OLTP, Autosys, Control M.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files
• Implementing Complex mapping such as Slowly Changing Dimension (SCD’s).
• Worked on Performance Tuning on the SQL query and Informatica jobs as part of performance improvement.
• Oracle Data Integrator (ODI): ELT experience using ODI 11g/12c, Oracle PL/SQL, Unix Shell script
• Team Lead ODI experience in designing and developing Variables Procedures, Functions, Interfaces, Packages, Load Plans, worked with Knowledge Modules (LKM, CKM, IKM).
• Oracle PL/SQL: Develop PL/SQL procedures, functions, packages for the new user requirements.
• Data Analysis: Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Data Modeling: Dimensional Data Modeling experience on Data modeling, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data mart, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Data Cleansing: Data Cleansing experience using Informatica, UNIX Shell Scripting and SQL coding.
• Methodologies: Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Databases: Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2005, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer, Greenplum.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.6.1/9.5.1 , Power Mart 6.2/5.x/4.7, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Data mart, OLAP, OLTP, Mapplet, Transformations, Autosys, SQL*Plus, SQL*Loader, ODI (Oracle Data Integrator) 11.7

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, Visio.

Databases: Oracle 11g/10g/9i/8i, IBM DB2 UDB 8.0/7.0,Greenplum,MS SQL Server 2005, MS Access.

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Unix Shell Scripting

Environment: IBM AIX, MS DOS, Win NT, Red Hat Linux, Infogix

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

ETL Lead/Developer

Responsibilities:

• Extensively worked on understanding the business requirements and designing Catalyst mappings.
• Conducted impact assessment and determine size of effort based on requirements.
• Designed ETL mappings and lineage documents.
• Defined and implemented ETL development standards and procedures.
• Troubleshoot and implement existing code.
• Analyzed all errors generated by Informatica session Logs and fixed those errors in data collection.
• Generated and supported SQL scripts for SIT and UAT.
• Designed restart-ability through ETL processes.
• Implement automation, audit and alert strategies throughout ETL processes.
• Creating and Designing source to target mapping document.
• Assisted in designing and implementation of data warehouse solutions along with data integration and analysis.
• Implemented procedures for suggestion and implementation of ETL processes and architecture enhancements.
• Coordinated with Guidewire front end teams for estimation and translation of client and business requirements into specific systems.
• Multiple data checkouts to match the real data and final loaded data in Analytical layer to maintain data consistency.

Environment: Informatica 9.6, ORACLE 10, Greenplum, Sql developer, UNIX, Autosys, Infogix

Confidential

ETL Developer

Responsibilities:

• Analysis, design, Coding and testing of the components developed in ODI.
• Developed functional and Technical Design documents and lead the team while gathering, analyzing, and documenting technical requirements from the functional requirements
• Worked on procedures/interfaces/packages/load plans in ODI for all the components coding and testing. Used Informatica Power Center for extraction, transformation and loading of data in the data warehouse.
• Created Informatica Mappings with different transformations including Source Analyzer, Lookup(connected/unconnected), Filter, Expression, Rank, Aggregator, Router, etc.
• Monitored workflows and tasks using Informatica Power Center Work flow Manager.
• Created reusable transformations and mapplets to use in multiple mappings.
• Performance tuning of the existing jobs in Informatica.
• Creation of new tables to meet the new requirements.
• Created multiple UNIX shell scripts to alert the support team proactively for any issues.
• Overall version management for release.
• Overall documentation for customer database.
• Integrate and communicate with Client for technical and business requirements
• Code changes done in PL/SQL packages and procedures according to the new requirement.
• Documenting all the changes and the design.

Environment: ODI 11.7, Informatica Powercenter 9.6.1 and Oracle PL/SQL, Unix

Confidential

ETL/Oracle PL/SQL Developer

Responsibilities:

• Analyze the legacy Datamart application to understand the requirements.
• Do the gap analysis between the legacy application and the current requirements.
• Worked on Data modeling and complete DB restructuring for Dictionary exchange project in Confidential .
• XML message parsing through Oracle PL/SQL packages into Oracle database.
• Responsible for managing the Test Case Document (TCD) by writing various test cases on the development.
• Involved in Optimizing and Performance tuning logic on mappings to increase the efficiency
• Used shell scripts for automating the execution of maps.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Environment: Oracle PL/SQL, Oracle ODI and Unix Shell script.

Confidential

Batch Module Leader

Responsibilities:

• Feasibility and impact analysis of Options introduction in CDTS.
• Review of Architectural changes such as Post trade and Business Continuity Plan.
• Defect Log Management for Host End Migration to Post Trade Machine.
• Team Building and Knowledge transfer as a Team Lead of Batches module and Currency Derivative System.
• Troubleshooting Activities as a TST (Trouble Shooting Team) Member and a TST Lead.
• Code migration From Dev environment to Test Environment.
• Generating the exceptional data to staging tables for maintain Parameter tables by user.
• Optimization and Performance evaluation for Host End Migration to V-Series, V6308 Machine and other major releases.
• Overall version Manager of the release.
• Time estimation and resource management as a Team Lead of Batches module and Currency Derivative System.

Environment: PL1, Unix Shell script, Appletree db