SUMMARY:

• Around 10 Years IT Industry Experience with full system development life cycle.
• 5 years’ experience in Data Warehousing.
• Extensive experience in Informatica, MS SQL server 2005/2008, SYBASE, Teradata, SQL server reporting, Informatica data integration, data mart, star schema, OLTP, OLAP, dimensional modeling, RDBMS, T - SQL, SQL, Business Objects XI R2.
• Strong experience in ETL tool Informatica Powercenter 6/ 7.1.4/8.5.1 /8.6/9.0.1/9.1/9.5
• Experience in Oracle 7.3/8/8i/9i/10g/11g and development tools like PL/SQL HTML, JavaScript, XML
• Project experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing, Production support and Documentation
• Extensive experience in ETL projects with Data integration, conversion.
• Knowledge of Informatica CDC.
• Highly knowledgeable in providing end to end ETL solutions by collaborating with various teams across the organization.
• Ability to learn things quickly, open to new technologies.
• Excellent communication skills
• Worked with various industry Clients like Commercial banking, Financial, Printing, Retail, Telecom.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008, SYBASE, Oracle 8i/8.x /7.x/9i/10g, Teradata 12.0.0.10

Development Tools: Business Intelligent 2005/2008, MS SQL Server Reporting, Embarcadero Rapid 7.5/ 7.5.5, SQL, PL/SQL, XQuery, XPath,, XSLT, Teradata SQL assistant 12.0, TOAD, Business Objects 6.5.1/XI R2

ETL Tools: Informatica Powercenter 6/ 7.1.4/8.5.1 /8.6/9.1

Languages: XML, JavaScript, Java, JDBC, C, C++, HTML, .NET

Operating Systems: DOS, Windows95, Windows XP, Windows NT, UNIX

Application Software s: MS Office 2000(Word, Excel, PowerPoint), MS Access

Version Control Systems: Tortoise SVN Subversion Control

EMPLOYMENT HISTORY:

Confidential, Irving, TX

Sr ETl/ Informatica Developer

• Analysis, development of client medical claims data.

• Develop mappings, workflows for data extract for various data coming for claims
• Develop prestaging and reformatting of data using ETL informatica.
• Work with BA’s, DBA’s to understand data coming and to load into the stage area.
• Build automation track.
• Develop script to build tables in DB2
• Build harvest package to move code into the production.
• Maintain the track to keep all team members in loop.
• Worked on dupe check process and calc total to avoid duplicates and make sure client claims and providers data to avoid mismatch in the billing and payments.

Environment: Informatica Powercenter9.5, Linux, DB2, Tivioli, CA harvest, Track plus, Service now

Confidential, Irving, TX

Informatica Developer

Responsibilities:

• Analysis, development of client marketing data.

• Develop data extracts and procedures to support internal and client (external) business analytics
• Developed complex mapping, used various transformations - Sequence generator, Router, Normalizer, Filter, Lookup, Expression etc.
• Worked closely with DBA’s for database model changes and for new data models
• Work closely with QA and release management teams on planning, configuration, change and version management
• Assist users by answering their questions about system functionality, listening to and addressing areas of concern
• Understanding the needs of the client
• Understanding of Target base’s business and client specific needs
• Ensure development procedures are carried out in efficient manner
• Maintain project timelines and owning engineering tasks
• Based on business requirements, review and/or develop detailed technical requirements and specifications. Identify missing details in the business requirements and engage the appropriate resource(s) for clarification.
• Develop mapping and data processing procedures to import data from various data sources and populate the client database
• Review and/or develop unit test cases and ensure successful test completion before delivery of code to QA team. Unit tests should be thorough and cover all functions dealing with business logic and data layouts.
• Coordinate with QA team to ensure quality deliverables. This includes delivering bug fixes, documentation, and appropriate dependency information with every release.
• Consistently check work into repository to guarantee safety of code artifacts as well as to minimize code dependency impact to other team members
• Multi-task through project execution and prioritize accordingly, ensuring project deadlines are met and deliverables are completed in a timely fashion
• Coordinate with the transition from project completion to ongoing production and production support

Environment: Informatica Powercenter 9.1, Oracle 11g, Unix

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Analyze and evaluate detailed business and technical requirements.

• Designed and developed Informatica mappings to extract data from the staging area to populate 3NF tables.
• Used various transformations source qualifier, update strategy, filter, lookup etc.
• Performed impact analysis for various enhancement requests to find out the systems/programs that could be potentially issues.
• Set up workflows, sessions, connections, parameter files.
• Involved in analysis of data, worked on data profiling.
• Created Sessions, Workflows, Post Session email task and also performed various workflow monitoring and scheduling tasks.
• Data analysis to ensure data quality in DW.
• Worked on unit testing to make sure source and target data are in sync
• Performed testing for various sample data.
• Involved in peer review, KT sessions.
• Involved in offshore coordination.

Environment: Informatica Powercenter9.5, Teradata, Teradata SQL assistant 13, SQL Server 2008, Unix, SQL, AS/400.

Confidential, Dallas, TX

ETL developer

Responsibilities:

• Designed and developed complex Informatica mappings to extract data from the staging area and build the EDW using Source Qualifier, Expression, Filter, Sequence Generator, Router, Joiner and Lookup transformations.

• Performed Unit testing and documented the results in the testing documents both in development and Integration environments.
• Troubleshooting issues in the production environment and help in resolving issues in the same. Used debugging tools to debug the flow of data and found the exact issues where expected data was not populated correctly.
• Performed impact analysis for various enhancement requests to find out the systems/programs that could be potentially affected by proposed change(s).
• Involved in analysis to ensure data is correct, identify the correct source of data.
• Created Sessions, Workflows, Post Session email task and also performed various workflow monitoring and scheduling tasks.
• Wrote complex SQL, stored procedures in Oracle.
• Data analysis to ensure data quality in DW.
• Involved in analysis to make sure source and target data are in sync and no failures during data migration.
• Performed testing for various sample data.
• Involved in offshore coordination.

Environment: Informatica 9.0.1, Oracle SQL, Teradata, Teradata SQL assistant 12.0, Toad, SharePoint, SQL, Unix.

Confidential, Ft. Worth, TX

Informatica developer

Responsibilities:

• Analysis and integration of legacy asset data to Asset Hub for business reporting.

• Involved in analysis of legacy data from different databases.
• Requirement gathering from users.
• Involved in design and ETL development.
• Involved in creating mapping, session, workflows.
• Create XML file using Informatica ETL.
• Peer design review and documentation of the ETL process.
• MQ series analysis to setup MQ between Informatica and asset hub.

Environment: Informatica Powercenter8.6/9.0.1, SQL, XML, MQ Series, SharePoint, Unix.

Confidential, Dallas,TX

Informatica developer

Responsibilities:

• Involved in Data Analysis and integration of data from Wachovia to Confidential .

• Date integration from Online Payables to Payment Manager
• Data analysis of wholesale customer’s data migration.
• Involved in customer data migration from merger bank and third party vendor.
• Create mapping, sessions, workflows using Informatica.
• Worked on various file formats - TAB delimited, CSV, Comma delimited, Fixed length.
• Involved in weekly discussion with vendor to resolve the gaps and issues with data we were receiving.
• Involved in gathering requirements, mapping data from various file formats.
• Created various check setup forms using standard and dynamic check templates.
• Worked on Unix to move files to SharePoint.

Environment: Informatica 8.5.1, SQL, XML, WebMethods7.1.2, Ultraedit 16.30.0.1003, SharePoint, Unix.

Confidential, Milwaukee, WI

Data Warehouse Analyst

Responsibilities:

• Design and develop store procedures, tables, views and functions; implement best practices to maintain optimal performance.

• Analysis and integration of data from various legacy systems. Development of complex reports using SSRS. Integration and replication of data to build data marts and data models.
• Involved in creating nightly batch process using Informatica to transfer data from legacy system to SQL Server data warehouse.
• Worked on various business reports using Microsoft business intelligent reporting. Used different functionality of SSRS like sub reporting, drill trough reporting, links, interactive sorting etc.
• Developed complex reports using multiple data providers, user defined objects, charts and synchronized queries.
• Created dimensions and measure objects according to business requirements.
• Generated effective reports using formulae, sections, breaks, alerters and filters.
• Developed complex warehousing report to track down the skid inventory like age of a skid in the warehouse. Involved gathering requirement, design, and development of the report. Involved day to day interaction with the user to gather requirement. Involved in unit testing and assisted users with acceptance testing.
• Involved to rollout internal Data Warehouse audit dashboard report. Added functionality to acknowledge the known issues and set a fix date in the future to keep the dashboard as an accurate reflection of status of our process.
• Developed various dashboard reports for analysis of sales growth and invoice details.
• Created different stored procedure, views, wrote complex queries.
• Created complex mappings in Informatica to clean data from source and transfer it to Data warehouse.
• Handled the Informatica server bounce back in case of any database down time or any issue.
• Handled business reports security access requests from business users.
• Automated the process to send the raw paper data to user which needs correction. This was getting done manually 4 times in a month initially. Created complex stored procedure for automation which get call through Informatica and email the appropriate data to user if needs to fix and update the status of the process accordingly.
• Conducted peer design and code reviews and extensive documentation of standards, best practices and ETL procedures.
• Handled various support issues calls from business users. Provided on call support to production system to resolve any issues.
• Production support by 24x7 pager rotations on weekly basis
• Involved in various analysis of reports and tables.

Environment: SQL Server 2005/ 2008, SQL Server Reporting, Business Intelligent Visual Studio 2005/2008, SYBASE, Embarcadero Rapid 7.5.5, Informatica Powercenter 7.1.4/8.5.1, Tortoise SVN Subversion Control

Confidential, West Palm Beach, FL

ETL Developer / Analyst

Responsibilities:

• Worked on Smart Insert, Update, delete mappings using Informatica. Worked on one-time scrub method to back populate table.

• Run ETL processes utilizing parse batch scripts, SQL and DOS Command.
• Involved in unit testing, integration testing and system testing.
• Worked with DBA’s and system support personnel in elevating and automating successful code in production.
• Created different stored procedure, views, wrote complex queries.
• Handled various server support issues like server restart.
• Handled various support issues calls from business users. Provided on call support to production system to resolve any issues.
• Production support 24x7 pager rotations on weekly basis.
• ETL developer and analyst on a full-lifecycle.
• Responsible for developing mappings, workflows using Informatica.
• Worked within a team to contribute to the successful delivery of a software system that the business could use to make daily business decisions.
• Primarily responsible for ETL of existing Legacy database into SQL server.
• Developed business reports for analysis purpose using SQL server report.
• Developed stored procedures to load data and create indexes, triggers, and tables.
• Wrote UNIX shell scripts for loading data.
• Integration and replication of data to build data marts and data models.
• Analysis of data to migrate it to Data marts.

Environment: SQL Server 2000, SSRS, SYBASE, Informatica 6