SUMMARY:

• About 7 years of IT experience as Informatica Developer and in SQL development.
• Experience in Requirement Gathering and Analysis, System Design and Development phases of Software Development Life Cycle (SDLC).
• Strong experience in Data Warehousing experience using Informatica Power Center/PowerMart.
• Worked with integration of Informatica with cloud technologies like Salesforce and strong knowledge in Salesforce API’s like workbench and data loader.
• Strong in working with Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations.
• Implemented Slowly changing dimension types I, II &III methodologies on various dimensions to maintain history data in the data warehouse.
• Designed and developed change data capture solutions (CDC) in data warehouse environment, which captures changes from daily feeds to maintain history data.
• Used various transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc to implement complex logic in ETL mappings.
• Database experience using MS SQLServer 2008/2005/2000 , Oracle 10g/9i/8i/8.x/7.x.
• Database: Using Oracle 11i/10g/9i, SQL, PL/SQL, SQL*Plus, Teradata TD13/TD12, SQL Server 2008/2005. Proficient in working with PL/SQL to write stored procedures and triggers. Expertise in WinSQL, TOAD (Tool for Oracle Application Developers).
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Extensive experience in using Informatica for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Experience in debugging and performance tuning of mappings and sessions
• Sound knowledge of the Healthcare, Insurance, Banking and Financial services industry
• Worked with Business Analysts to understand business requirements and converting them to technical specifications.
• Strong experience on Data Analysis, Development and Testing and Production implementation.
• Strong working experience in Data Warehousing concepts, Star Schema and Snowflake Schema methodologies.
• Experienced in coding using SQL, PL/SQL stored procedures/functions, triggers and packages.
• Excellent Team player with strong Analytical and Logical skills, Good communications skills.
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
• Extensive knowledge in Data Quality in using of Informatica.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9x/8x/7x/6x, Informatica PowerMart7x/6x.Informatica PowerExchange 7.x/8.x, Repository Admin console,Repository Manager, Designer, Workflow Manager, workflow Monitor.

Databases: Oracle11x/10g/9i,Sybase12.0/11.x/10, DB2 UDB8.0/7.0/6.0,MS SQL Server 2008/2005/2000 /7.0/6.5,MSAccess2003/2000.

BI Tools: Cognos8.4/7.1/6.0 (Impromptu, Power Play, Transformer),DAC, OBIEE,Business Objects XiR3/XiR 2/6.0/5.1/5.0 , Crystal Reports 4.0/6.0.

Data Modeling: ERWIN 4.x/3.x, Ralph - Kimball Methodology, Bill-Inmon Methodology,Star Schema, Snow Flake Schema, Extended Star Schema,Physical And Logical Modeling, Dimension Data Modeling,Fact Tables, Dimension Tables, Normalization, De-normalization

Programming: C, C++, Visual Basic, Unix Shell Scripting, SQL, and PL/SQL, HTML,XML.

Environment: Windows XP/2000/98, Win NT, UNIX(SunSolaris10, HP,AIX Linux),MS-Dos

Other Tools: SQL*Plus, Toad, SQL Navigator, Putty, Ms-Office.MS VISIO, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Informatica Developer

Responsibilities:

• Created Dimension Tables and Fact Tables based on the warehouse design.
• Involved in creating Logical and Physical design of databases using Erwin.
• Participated in build of the Data Warehouse, which includes theDesign of Data mart using Star Schema.
• Created ETL detail design document and ETL standards document.
• Created Repository using Informatica Power Center - Repository Manager.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created necessary Repositories to handle the metadata in the ETL process
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Created reusable transformations and Mappletsand used them in mappings.
• Worked on SQL queries and tuned them to improve performance.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Performed data manipulation using basic functions and Informatica Transformations.
• Developed various reports using Cross Tab, Master Detail and different charts including Line, Column, Area, and Pie Charts for analysis.
• Modified Universes and generated reports using Business Objects.
• Designed & developed reports, Drilldown reports using Business Objects Reporter.
• Designed reports with Slice and Dice & Drill down operations.

Environment: Informatica PowerCenter 9.5.4, Oracle 11g, SQL Server, ERWin 3.5, OBIEE 11g, UNIX (AIX), Windows NT

Confidential, Pennington, NJ

Informatica Developer Lead

Responsibilities:

• Worked as a Business analyst, Responsible in gathering Requirements and IT review. Interacted with Business Users in the design of technical specification documents.
• Involved in creating logical and physical data models using MS Visio based on business requirements.
• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, ODS, SQL Server, etc. into the Staging table and then to the target database Oracle.
• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.
• Re-designed ETL mappings to improve data quality.
• Used Korn-Shell Scripting to automate the loading process.
• Created Stored procedure transformations to populate targets based on business requirements.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity.
• Developed the pre &post session shell scripts, which will create the parameter file dynamically.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensive use of Persistent cache to reduce session processing time.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Within specified time, projects are delivered making sure all the requirements gathering, business analysis and designing of the data marts.
• Project and Version management using PVCS Version Manager.
• Involved in Unit and Integration testing of Mappings and sessions.
• Developed Schedules for daily and weekly batches using Unix Maestro.
• Prepared ETL mapping specification document.
• Assisted Testing team in creating test plan and test cases.
• Involved in creating multi-dimensional universe and reports in Business Objects Environment.
• Used BRIO reporting tool to generate reports. And also created and run BRIO SQR Programs.
• Designed and developed ad-hoc and customized reports using Cognos 8.
• Created Informatica mappings with PL/SQLProcedures/Functions and triggers in T-SQL to build business rules to load data.

Environment: Informatica Power Center 9.5, Oracle 11i, MS SQL Server 2008, MS Visio, Toad,Power exchange 9.5, Business objects XiR3,ERWIN 4.2, Control-M.

Confidential, Newark, NJ

Informatica Developer

Responsibilities:

• Developed mappings using the mappings specs and process flow, used Joiners, aggregators, update strategy, Lookup, sorter, router, transaction control transformations in mappings
• Created multiple ETL mini flows to provide business with monthly, quarterly and yearly reports well ahead of regular schedules.
• Creating various specialized reports by using SQL for data manipulation.
• Done extensive testing and wrote queries in SQL to ensure the data accuracy and authenticity.
• In-depth knowledge of all the kinds of workflow tasks and Repository management
• Able to Handle shell scripts and stored procedures from Informatica.
• Well experienced in data warehouse, data migration and data conversions.
• Has good experience in designing Logical and Physical data models for different database applications using the ER Studio.
• Debugging the code and created error log package to record all the bad records along with error codes and error message.
• Strong technical hands on experience in creating and maintaining database objects like tables, views, materialized views, indexes, sequences, synonyms and database links and performing DML operations using insert, update and delete statements.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Scheduling the sessions toextract, transformandloaddata in to warehouse database, based on Business requirements.
• Utilized SQL*Loader to load flat files into database tables.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Ability to handle the data transformations as per requirements
• Involved in different phase of testing like User Acceptance Testing, Unit testing.
• Involved in writing Test cases and performing data validation and process testing for application moving into production.

Environment: Informatica, SQL Server, Oracle 11g, Salesforce, DB2,SQL, PL/SQL, TUnix, Linux, FTP, SFTP, SSH Tectia, ER Studio

Confidential, Seattle, WA

ETL Developer/Analyst

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked closely with end users and business analysts for requirement gathering and analysis.
• Responsible for data analysis.
• Design the Data Mart model with Erwin using Star Schema methodology.
• Extracted data from various internal systems which comprises of details of HR, Project, Time, Trade, Expense, Banker statements and compliance.
• Extracted from various external sources which comprises of details of deals, mergers and acquisition, Securities, bonds and instruments.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Designed Logical flowcharts, sequence diagrams, state diagrams, data flow diagrams and screen decks.
• Research Sources and identify necessary Business Components for Analysis.
• Worked on Dimensional modeling to design and develop Star schemas by identifying the facts and dimension.
• Designed logical models (relationship, cardinality, attributes, and Candidate keys) as per business requirements using ERwin 4.0 Data Modeler.
• Created the (ER) Entity Relationship diagrams& maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Worked on Dimension/Fact tables to implement the business rules and get required results.
• Developed Informatica Mappings, Mapplets, Sessions and Workflows as per client’s standards.
• Prepared design specifications for Informatica mappings.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Managed the QA, UAT as well as Production release by actively documenting the steps as well as coordinating for the complete process along with subsequent Bug resolution process as well as support for the same.
• Involved in Informatica configuration changes for ETL deployment.
• Developed PL/SQL scripts, stored procedures and triggers in Oracle.
• Designed data models for the investment bank data system using ERWin data modeler and Oracle 9i.
• Developed shell scripts for data retrieval and ETL processes.
• Developed and scheduled Autosys jobs by creating and deploying different JIL files.

Environment: InformaticaPowerCenter 7.1.2, Oracle 9i, Autosys, ERWIN 4.0, Windows 98, UNIX (Solaris),MS SQL Server, Oracle 8i, SQL, PL/SQL, SQL*PLUS, SQL*Loader, TOAD, Import/Export Utilities, Shell Scripts.

Confidential

Data warehousing developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Created Repository using Repository Manager.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Tuned the mappings to increase its efficiency and performance.
• Used Informatica Workflow Manager to create workflows
• Workflow Monitor was used to monitor and run workflows
• Involved in production support which also includes trouble shooting of connectivity issues.

Environment: Informatica PowerCenter 5.1/6.2, Oracle 8i, UNIX, TOAD, SQL * Loader, Windows NT.