PROFESSIONAL SUMMARY:

• Over 7 years of experience in Data Warehouse Applications using ETL tool like Informatica Power Center 9.X/8.X/7.X/6.X with Informatica cloud, Informatica Power Exchange, Informatica Data Quality (IDQ), Business Objects
• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes
• Strong logical and physical data modeling skills, physical database design, relational models, star schema and snow - flake schema
• Responsible for all activities related to the design, development, implementation and support of ETL process for large scale data warehouses
• Experience with complex Informatica mappings using transformations like Expression, Aggregator, Router, Joiner, Rank, Sorter, Stored Procedure, Java, SQL, XML, Lookups, Normalizer, Sequence Generator and Update Strategy
• Experience in creating Informatica Sessions, Workflows, and Worklets by using the Workflow Manager tools like Task Developer, Worklet
• Experience in Partitioning, Performance Tuning and Optimization of ETL Jobs and mappings
• Experience in integration of various data sources like Oracle, Sybase, SQL Server, Teradata, Flat Files into staging area
• Strong Experience in Oracle 11g/10g/9i/8i/8.0/7.x, Sybase, MS SQL Server 2008/2005/2000, Teradata, SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored Procedures, Triggers
• Implemented various Audit Controls to reconcile the data between Source and Target systems
• Experience in Java, UNIX Shell Scripting, Perl Scripting, and Job Scheduling on Multiple platforms like Windows NT/2000/2003, SunOS, HP-UX, IBM-AIX
• Involved in full Software Development Life Cycle (SDLC) of application software on multiple platforms including system study, analysis, design, development, unit integration, acceptance testing and implementation

TECHNICAL SKILLS:

ETL ToolsInformatica: PowerCenter 9.X/8.X/7.X/6.X, Informatica cloud, Teradata Tools & Utilities (TTU V2R5/V2R6/8.0/12.0) - BTEQ, MLoad, FastExport, FastLoad, TPT, Tpump, Data Stage 6.x/7.x, DataStage

BI Tools: Siebel Analytics/Oracle Business Intelligence, Business Objects

Database: Oracle 11g/10g/9i/8i/, Teradata V2R5/V2R6/12.0/13.0, Sybase, MS-SQL Server 2000/2005/2008, MS-Access

Data Modeling Tools: CA Erwin 7.3.9, ER/Studio Data Architect, Microsoft Visio Professional 2003/2007

Database Client Tools: TOAD, SQL Developer, Oracle SQL Plus, Oracle SQL Loader, SQLDBX

Programming Language: C, C++, Visual Basic 6.0, VC++, Java, C#, PL/SQL

IDE: Visual Studio 6.0, Visual Studio .NET, RAD, Eclipse

Web Technologies: ASP, VB.Net, ASP.Net, JSP, HTML, DHTML, XMLJavaScript, VbScript, Perl, PHP, Dream weaver MX, Front Page 2000

Operating Systems: WindowsXP/NT/2000/2003, IBM-AIX, HP-UNIX, Sun Solaris, RHEL

Other Tools: TWS (Tivoli Workload Scheduler), DAC, Cron Tab, Putty, SSH

PROFESSIONAL EXPERIENCE:

Confidential, MI

Sr. Informatica Developer

Responsibilities:

• Responsible for analyzing and translation of the business requirements into functional and technical designs
• Worked on multiple components in parallel like Referral Management, Membership, Case Management, Vendor Management in Care Advance Project and multiple PITAS in FARE (FACETS Analytical Reporting Environment)
• Provided mentorship and transferred knowledge on the processes to developers, users and testing teams
• Provided technical subject matter expertise and mentorship on various subject areas like Billing, Membership, Claims, Capitation, Provider
• Created design documents and process flows as per standards
• Created various complex mappings to load data from files, VSAM files and various other databases
• Create mappings to load Dimension, History and Fact & Aggregate tables using various transformations like Expression, Aggregator, Normalizer, Java, SQL, Filter, Router, Update Strategy, Lookup, Joiner, XML, Stored Procedure, Rank, Sequence generator, Sorter
• Implemented Slowly Changing Dimensions (SCD) of Type 1 & Type 2
• Used Pre & Post SQL in sessions to create & drop indexes
• Generated XML files using Oracle Stored procedure and Informatica
• Created and modified the stored procedures, functions, packages
• Used SQL hints and indexes to improve SQL performance
• Extensively used Java Transformations to perform data inserts using web services & retrieve data from LDAP
• Extensively used Java to develop functionalities like sending Outlook calendar invites to Outlook, Batch PDF letter printing using Java, and few Web Applications
• Provided Production On-Call Support for batch processing on a rotation basis
• Identified the Bottle necks in Informatica mappings & Sessions for better performance. Tuned the Queries in the databases
• Created reports for Business using SSRS & BO XI R2

Environment: Informatica 9.1/8.5/8.1, Power Exchange, Informatica Data Quality (IDQ), Oracle 11g/10g, MS SQL Server 2008, Sybase, ER/Studio Data Architect, TWS 8.3, PVCS 8.1.3/SCM, BO XI R/2, SSRS, SQL Developer, JAVA, JBoss, SOAP, WSDL, Humming Bird, Care Advance, FACETS, UNIX

Confidential, NY

Sr. Informatica Developer

Responsibilities:

• Complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Enterprise Data Warehouse with production support
• Participation in project meetings/design groups as a team member with other Data Analysts in preparing Analysis reports and project development reports according to industry regulations
• Code, implement and unit test the application based on the technical requirements
• Provide support for the system once it is deployed and running in production environment
• Document all the phases of the application development and follow the coding standards to improve the maintenance of the application
• Create ETL mappings to extract data from multiple legacy systems. Transform and load the data into the Enterprise Data Warehouse using Informatica Power Center
• Extensively used various using transformations like Router, Aggregator, Sorter, Rank, Joiner, Stored Procedure, Update Strategy, Expression, Normalizer, Sequence generator and Union
• Design and develop new database objects like tables, procedures, functions, indexes, and views using Oracle 10g
• Understand business challenges and translate them into process/technical solutions. Creations of documents related to the ETL process
• Set up batches and workflow sessions to run these mappings. Assist in designing Informatica mappings and data model structural changes
• Troubleshoot problems by checking session logs and used debugger for complex problem troubleshooting
• Used Informatica/UNIX to send mails to Users and Support team upon failure or success of the jobs with appropriate message
• Wrote Shell Wrapper Scripts for automating ETL jobs
• Created reports to suit the client’s requirements
• Involved in Performance tuning for ETL mappings & SQL queries

Environment: Informatica 9.0.1, Oracle 10g/11g, SQL developer, Windows XP, IBM AIX, TWS (Tivoli Workload Scheduler)

Confidential, TX

Informatica Developer

Responsibilities

• Involved in the analysis and designing of the data warehouse system requirements
• Created the Physical and Logical data model for various Projects using CA Erwin
• Created the mappings using transformations such as the Source qualifier, Joiner, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy
• Implemented Slowly Changing Dimensions, Semantic Layer, Change Data Capture (CDC)
• Created Mappings to generate Surrogate Keys for various subject areas.
• Develop and execute load scripts using Teradata client utilities MultiLoad, BTEQ, TPUMP, TPT, FastExport, and FastLoad
• Assisted in estimating the size of the tables used by the applications
• Performance tuning which includes query optimization, space management, collects stats etc.
• Involved in High-level Design documentation and ETL design documentation
• Perform code review with the developers and fine-tune the code for performance improvement
• Provided Red Hat Support for the projects involved
• Automated few scripts to send alerts for UV/ET rejections, Long running Informatica Jobs
• Design and Develop Data Quality Controls between Source and Target
• Involved in the design and development of Metadata Engine
• Involved in code migrations from Development to QA to Production
• Wrote Shell Wrapper Scripts for automating ETL jobs

Environment: Informatica 7.1.4/8.1/8.5, Teradata V2R5/V2R6/V12, Teradata Tools and Utilities (Mload, BTEQ, Tpump, TPT, FastExport, FastLoad), Teradata SQL Assistant, Tivoli Workload Scheduler, OBIEE 10.1.3, Business Objects 6, Oracle 9i/10g, CA Erwin 7.3, Toad, Golden Gate, Connect Direct, Crontab, SunOS, HP-UX

Confidential

Informatica/Oracle Developer

Responsibilities:

• Understanding the Business Requirement Document & Technical Design Document and created the mappings accordingly
• Created mappings using different transformations like Source qualifier, Joiner, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy
• Loaded Flat Files into the database using Informatica
• Involved in writing SQL stored procedures to access data from Oracle 9i
• Created Triggers, Stored Procedures, Package, Functions, Tables, Indexes, Rules in Oracle
• Coordinate with clients as needed for on-going system support and troubleshooting.
• Created various Shell scripts

Environment: Informatica Power Center 7.1, 8.1, Oracle 9i/10g, PL/SQL, SQL Developer, TOAD, UNIX Shell Scripting