SUMMARY

• 9+ years of software experience in System Analysis, Application Design, Development, Implementation and ETL, Reporting for Data Warehousing.
• Proven Experience in Full Life Cycle Implementation of Data warehouses.
• Experienced in requirements gathering, project estimating, planning design, build, maintenance, report design, user navigation design, testing and implementation.
• Worked with Dimensional modeling, Data migration, ETL process for Data warehouse. Skilled in Data Modeling using Star Schema and Snowflake Schema.
• Expertise in ETL process using Informatica Power Center Designer, Workflow manager, Workflow monitor, Informatica server and Repository Manager.
• Responsible for all activities related to teh Development, Implementation, Administration and Support of ETL processes for large - scale data warehouses using Power Center.
• Experienced in creating technical specification documents like Detail design, Migration, Small Project Specification and Test case documents.
• Created mapplets for re-usability across data marts in different mappings and worked on developing UNIX scripts for data cleansing and data archiving.
• Hands on experience in tuning mappings, identifying and resolving bottlenecks in various levels like sources, targets, mappings, transformations and sessions.
• Experienced in creating mappings, mapplets, workflows and worklets and also Partition teh sessions using Informatica.
• Created various Oracle database objects like Indexes, Stored procedures, Materialized views, Synonyms and functions for Data Import/Export.
• Provided production support including error handling, system enhancements and fine tuning for performance improvement and also Skilled in Root cause Analysis and problem solving skills.
• Experience in various features of Erwin like Forward Engineering and Reverse Engineering. Highly Skilled with teh Integration on of various data sources like Oracle, UDB, SQL Server, Flat Files, XML files, and IBM Mainframe COBOL files.
• Generated Business Objects Reports using teh universe as teh main Data provider and writing teh complex queries including Sub queries, Unions, Intersect and Aliases.
• Experienced in creating Stored Procedures and Triggers using Oracle PL/SQL.
• Skilled in Tuning of SQL, Unit Test, System Integration Test and UAT.
• Tested teh data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• TEMPEffective Team Player with excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS

RDBMS: Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Plus, SQL*Loader SQL Server 2000/2003/2005, DB2 UDB 9.5/ 8.1/7.1

ETL Tools: Informatica Power Center 8.6.0/8.5/7.1.3/6.2.1

BI Tools: Business Objects XIR2/6.5/5.1, Micro Strategy 8.0

Operating System: UNIX-AIX, Windows NT/ 2000/2003/2007/ XP

Languages: SQL, PL/SQL, Shell Scripting, C, Visual Basic 6.0

Scheduling Tools: Autosys, Tidal, Informatica Scheduling, TWS

Modeling Tools: Erwin 4.1, MS Visio

Data Modeling: Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables, Logical and Physical Data Modeling

Other Tools: WinSQL, PL/SQL Developer, AQT, Quest Central for DB2, Toad, SQL Developer, iSQL*Plus, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Springfield, Illinois

Sr. ETL/Informatica Developer

Responsibilities:

• Extensively worked on gathering requirements from teh end users and also worked on analyzing teh source data to implement them in Informatica mappings and in Teradata utilities.
• Worked on Expansion Project which was covered with Patient’s data, Children data, Hospital’s data from different projects ICARE, Discharge data, DHS Cornerstone.
• Experienced in creating ER diagrams via Erwin for OLTP environment and worked on Dimensional modeling in designing fact and dimension tables for Data warehouse.
• Extensively worked on Teradata utilities which are Multi Load, Fast Load, Fast Export to load teh Expansion Project detailed data into Teradata tables which were made available to users.
• Worked on modifying teh existing Teradata multi load scripts and Developed Teradata fast load, fast export scripts.
• Worked on fixed width and delimited flat files to export teh Medicare and Medicaid detailed data to Mainframe through Informatica by using FTP.
• Developed Informatica mappings based on business requirements using various transformations Dynamic Lookup, connected and unconnected lookups, Filter, Stored procedure, Update Strategy, Joiner, Aggregator, Expression, Router, Sequence generator, Normalizer in teh mappings.
• Fine tuned teh mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for teh better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Extensively involved in testing by writing some QA test cases, for testing teh target data against source data.

Environment: Informatica Power Center 9.1.0(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations), Teradata, Teradata SQL Assistant 12.0, SQL Server 2008 R2, UNIX AIX 5.3.

Confidential, Columbus, Ohio

ETL/Informatica Developer

Responsibilities:

• Involved in gathering requirements from teh end users and also worked on analyzing teh source data to implement them in Informatica mappings.
• Worked on converting PL/SQL scripts into Informatica Dimension tables and Fact tables.
• Extensively worked on tuning teh existing functions in PL/SQL script, developed and fine-tuned stored procedures.
• Worked on implementing profiling tables, bridge tables to maintain teh relationships between fact table and dimension tables.
• Extensively worked on creating Technical specification documents, Mapping documents, detailed Design Documents and also worked on Gap analysis to find out teh differences in Informatica mappings compared with PL/SQL scripts.
• Created mappings employing various transformations Filter, Joiner, Lookup, Router, SQL overrides etc. to load data from multiple databases into Warehouses.
• Implemented changes in slowly changing Dimension (Type1, 2 & 3) tables.
• Developed mapping parameters and variables to support SQL override.
• Used application development tools like SQL Developer (Oracle) to develop SQL queries and stored procedures.
• Implemented Kimball’s methodology in data modeling star schemas to populate dimension and fact tables.
• Extensively involved in testing by writing some QA procedures, for testing teh target data against source data.
• Involved in Unit testing, User Acceptance Testing to check whether teh data loads into target are accurate, which was extracted from different source systems according to teh user requirements.

Environment: Informatica Power Center 8.6.1(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), Oracle 10g, PL/SQL, MS Visio, SQL Developer, Windows 2003/2007, UNIX AIX 5.3.

Confidential, Auburn Hills, MI

ETL/Informatica Developer

Responsibilities:

• Created functional specifications, Small Project Specification document and Detailed Design Document by analyzing teh project Requirements Definition Documents.
• Designed and developed teh Informatica Mappings to extract data from various file source systems to oracle target MDM warehouse.
• Studied Session Log Files, Thread Statistics, Performance Statistics File and Reject files to understand teh root cause of data rejection and to pinpoint performance deadlocks.
• Responsible for developing, support and maintenance for teh ETL processes using Informatica Power Center.
• Used Parameter files to override mapping parameter, mapping Variables, Workflow Variables, Application connection object Name, Relational Connection Names and $Param-Session Parameters.
• Expert in using teh Informatica Debugger and teh Debugger expression editor to evaluate complex expressions to understand teh bugs in teh code.
• Worked and developed efficient Auditing and Error Handling Methodologies for OLTP environment implementations.
• Created Test cases for Unit Test, System Integration Test and UAT to check teh data quality and data Integrity.
• Worked on Perl scripts library to automate teh activities like start, stop, and abort teh Informatica workflows by using PMCMD command in it.
• Developed workflow tasks objects like reusable Email, Event wait, Command, Decision tasks.
• Worked on Tivoli Workload scheduler to schedule teh workflows in production environment and used file watcher to watch for teh file on SFT server.

Environment: Informatica Power Center 8.6.1(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), Oracle 10g, Flat Files, CSV files, XML files, PL/SQL, Erwin 6.1, IBM Tivoli Workload scheduler, MS Visio, SQL Developer, iSQL*Plus, TOAD, Windows 2003/2007, UNIX AIX 5.3.

Confidential, Charlotte, NC

Sr. ETL/Informatica Developer

Responsibilities:

• Gatheird requirements from teh end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in teh Data Warehouse Data modeling based on teh client requirement.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on teh requirement document provided by teh business users.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on teh logic, developed various mappings & mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in teh mapping.
• Created UNIX scripts to automate teh activities like start, stop, and abort teh informatica workflows by using PMCMD command in it.
• Fine tuned teh mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for teh better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Provided production support including error handling and validation of mappings.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Created Test cases for Unit Test, System Integration Test and UAT to check teh data.
• Responsible for migrating teh folders or mappings and sessions from development to test environment and Created Migration Documents to move teh code from one Environment to other Environment.
• Proactive team player with teh demonstrated ability to multi-task and prioritize in a fast-paced professional environment.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2000, Flat Files, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), Erwin 6.1, Microsoft Visual Studio Team System/Team Foundation Server (TFS), Tidal, MS Visio, SQL Developer, iSQL*Plus, TOAD, Windows 2003/2007, UNIX AIX 5.3.

Confidential, Atlanta, GA

ETL/ Informatica developer

Responsibilities:

• Trouble shooting mappings during data loading into all testing Schemas.
• Developed Informatica mappings based on business requirements using various transformations Dynamic Lookup, connected and unconnected lookups, Filter, Stored procedure, Update Strategy, Joiner, Aggregator, Expression, Router, Sequence generator, Normalizer in teh mappings.
• Documented teh entire process. Documentation included mapping document, unit testing document and system testing document among others.
• Conducted System Testing, Unit testing and scheduled Informatica jobs. Involved in production support for Informatica.
• Worked on capturing slowly changing dimensions and consolidated key processes.
• Used various Oracle Index techniques like B*tree, Bitmap index to improve teh query performance and created scripts to update teh table statistics for better explain plan.
• Created UNIX scripts to automate teh activities like start, stop, and abort teh informatica workflows by using PMCMD command in it.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Done teh documentation work for all teh deliverables weekly wise and took responsibility to complete teh given task on time.

Environment: Informatica Power Center 7.1, IBM DB2, control center, Unix Shell Scripts, SQL, PL/SQL, Windows NT, Erwin 6.1, Autosys, Clear Case, Microsoft Visio, Business Objects 6.5.1.

Confidential, Warren, NJ

Sr.Informatica/ETL Developer

Responsibilities:

• Involved in translating business requirements to integrate into existing data mart design.
• Extensively used ETL to load data from different relational databases and flat files.
• Debugged teh mappings extensively, hard coding teh test data ids to test teh logics going instance by instance.
• Performed various transformations, aggregations and ranking routines on teh data to be stored in teh application reporting mart.
• Handle teh Migration process from Development, Test and Production Environments.
• Implemented Type 2 slowly changing dimensions to maintain dimension history and tuned teh Mappings for Optimum Performance.
• Developed workflow sequences to control teh execution sequence of various jobs and to email support personnel.
• Involved in unit testing and documenting teh jobs and work flows.
• Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
• Created various UNIX shell scripts for Job automation of data loads.
• Created mappings, which include teh Error Handling Logic being implemented to create an error, ok flags and an error message depending on teh source data and teh lookup outputs.

Environment: Informatica Power Center 7.1.3, Business Objects 6.5, Oracle 8i/9i, SQL Server 2000, COBOL Files, SQL, PL/SQL (Stored Procedure, Trigger, Packages), Flat Files, CSV files, Erwin, SQL Navigator, TOAD, MS Visio, Windows 2000, UNIX AIX 5.1.

Confidential, Charlotte, NC

ETL/Informatica Developer

Responsibilities:

• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Involved in designing teh procedures for getting teh data from various systems to Data Warehousing system. Teh data was standardized to store various Business Units in tables. Responsible for studying teh existing data warehouse which is in PL/SQL and also working on PL/SQL packages, stored procedures, triggers and functions.
• Used Extraction Transformation and Loading to transfer teh data to teh target Database
• Used various transformations like Aggregator, Expression, Lookup, Rank, Update Strategy, Stored procedure and Sequence Generator.
• Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.
• Knowledge of slowly changing dimension tables and fact tables.
• Involved in Performance tuning for better performance.
• Responsible for Creating workflows and worklets. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.

Environment: InformaticaPower Center 6.x/7.x, Oracle 9i/8i, DB2, Perl, Shell Scripting, SQL, PL/SQL, TOAD, Business Objects, and Sun Solaris UNIX, Windows XP

Confidential, Eden Prairie, MN

Sr. ETL/Informatica Developer

Responsibilities:

• Involved in design and development of ETL process full data warehouse life cycle
• Extracted teh Data from different sources systems like Sybase, Oracle, DB2, and flat files and loaded them into Oracle database.
• Performance tuning on sources, targets, mappings, sessions and SQL queries in teh transformations to improve teh daily load performance
• Created reusable transformations and mapplets based on teh business rules to easy teh development process and responsible for document teh changes.
• Created Dynamic lookup transformation to increase teh session performance.
• Created Oracle Stored Procedure to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Used oracle explain plan feature to identify teh query execution cost and tuned teh queries based on teh oracle optimize plan for good query performance.
• Used various Oracle Index techniques like B*tree, bitmap index to improve teh query performance and created scripts to update teh table statistics for better explain plan.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Created Test cases for Unit Test, System Integration Test and UAT to check teh data quality and integrity.
• Responsible for migrating teh folders or mappings and sessions from development to QA and to production environment.

Environment: Informatica Power Center 6.2 (Designer, Server Manager, Repository Manager), Business Objects 5.1, Oracle 9i, SQL Server 2000, DB2 V7.1, Erwin 4.0, TOAD,SQL, PL/SQL, Oracle Loader, UNIX AIX, Windows 2000.

Confidential 

Application Developer

Responsibilities:

• Developed forms, PL/SQL programs for integrated fleet management and Inventory control system.
• Developed reports, which increased productivity by 50%.
• Developed PL/SQL program to generate Purchase requisition/Purchase order for parts whose inventory TEMPhas fallen below teh re-order level.
• Wrote scope and requirement documents after discussion with customers.
• Assisted with software design of teh project.
• Wrote triggers and stored procedures for various activities using PL/SQL.
• Involved in building, debugging and running forms.
• Responsible for creating reports using Crystal Report based on teh user requirements.

Environment: Visual Basic 6, Oracle 8, Crystal Report 8.