SUMMARY

• 7 years of IT Experience in Data Warehousing, Database Design and ETL Processes in the Test and Production environments of various business domains like finance, Banking, and health care industries.
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large - scale Data warehouses using Informatica Power Center.
• Worked extensively on ETL process using Informatica Power Center 9.x/8.x/7.x.
• SQL database experience in a high transaction and multi server production environment.
• Experienced with Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE) tools for Data Analyst / Developer.
• Utilized Informatica IDQ (Data Analyst, Developer) for dataprofiling and matching/removing duplicate data, fixing the bad data and fixing NULL values.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience in Database Development, Data Warehousing, Design and Technical Management.
• Good understanding indatabaseanddata warehousingconcepts (OLTP & OLAP).
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions and at database.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
• SQL Server 2008/2005 RDBMS database development including T-SQL programming.
• Extracted data from File Sources, Relational Sources, XML and COBOL sources using Informatica PowerCenter.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Worked extensively on ETL process using IBM Cognos Data Manager and Pentaho Kettle.
• Worked on OLAP Data warehouse, Model, Design and Implementation
• Experience in upgrading from Informatica Powercenter 8.1 to Informatica Powercenter 9.1.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server performance.
• Used Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files.
• Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• In-depth understanding of Data Warehousing and Business Intelligence concept
• Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
• Designed, tested, and deployed plans using IDQ 8.5
• Good knowledge of Master Data Management concepts.
• Responsible for interacting with business partners to identify information needs and business requirements for Reports.
• Good Knowledge of Kimball and Inmon data warehouse design approaches and considerations
• Good understanding of dimensional models, slowly changing dimensions, star & snowflake schemas.

TECHNICAL SKILLS

Databases: Oracle 10g/9i/11i/R12, DB2, SQL server 7.0/2000/2005/2008, MS Access 2000/2005, Teradata

Languages: Transact- SQL, PL/SQL,HTML, C, C#, PERL

Operating Systems: Windows NT/98/2000/XP/Vista/2003, Linux, Unix, MS-DOS, Sun Solaris.

OLAP/Reporting Tools: SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS), Share Point MOSS 2007, Business Objects 6.x, Cognos Framework Manager

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, Informatica Power Center 9.x/8.x/7.x, Informatica Data Quality Suite 8.5, Cognos Data Manager, Pentaho Kettle

Data Modeling Tools: Microsoft Visio 2000/2003

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Web Technologies: MS FrontPage, MS Outlook Express, FTP, TCP/IP, LAN,PHP

Other Tools: Microsoft Office, MS Visio, Visual Basic 6

PROFESSIONAL EXPERIENCE

Confidential, Utica, NY

ETL Informatica Developer

Responsibilities:

• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
• Deliver new systems functionality supporting corporate business objectives.
• Translate requirements and high-level design into detailed functional design specifications.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Used ERStudio to analyze and optimize database and data warehouse structure.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
• Used Autosys scheduler to schedule and run Informatica workflows.

Environment: Informatica 9.5, Oracle 11g, UNIX, PL/SQL, Oracle 11g, Embarcadero ERStudio Data Architect, TOAD, Autosys, Putty.

Confidential, Framingham, MA

ETL Developer

Responsibilities:

• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
• Deliver new systems functionality supporting corporate business objectives.
• Translate requirements and high-level design into detailed functional design specifications.
• Wrote stored procedures, functions, and database triggers in SQL Server 2008.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Used ERStudio to analyze and optimize database and data warehouse structure.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
• Facilitate/lead design reviews of functional design with other members of the technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications.
• Provide SME level guidance to Development and Application support teams during development and deployment phases.

Environment: Informatica 9.1, SSIS, SQL Server 2008, PL/SQL, Transact SQL, Oracle 11g, Embarcadero ERStudio Data Architect, TOAD.

Confidential, Dublin, OH

ETL Informatica Developer

Responsibilities:

• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed various Ad-hoc mappings for various business needs.
• Installing Informatica Powercenter 9.1 and migrating the old processes and codes from previously existent Informatica Powercenter 8.1.
• Responsible for developing, Testing, support and maintenance for the ETL processes using Informatica Power Center 9.1.
• Responsible for development of robust and reliable solutions requiring low maintenance, thorough testing of solutions
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts using Cognos 8 BI Data Manager.
• Delivering metadata to Cognos Framework Manager, to model the target data warehouse and data repositories used in Cognos Business Intelligence.
• Creating and scheduling jobstreams in Cognos Data Manager to automate the Data Load processes to target Data warehouse.
• Designed the process to write failed and rejected rows into flat files and tables using Cognos Data Manager.
• Developed UNIX shell scripts for scheduling sessions in Informatica.
• Wrote stored procedures, functions, and database triggers in SQL Server 2008.
• Extensively used SSIS FTP tasks for data transfers from FTP servers to SQL Server.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Assisted in documenting business requirements for data warehousing and integration needs.
• Worked extensively with Oracle Applications R12 and Oracle Applications 11.0.3
• Retrofitted PL/SQL scripts, functions and procedures from Oracle 11.0.3 into the R12 world.
• Experienced in using the UTL File package in PL/SQL, to develop oracle concurrent request scripts for writing tables into MS Excel Worksheet.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Developed stored procedures using PL/SQL.
• Developed data transfer and transformation tasks using Pentaho Kettle.

Environment: Informatica Power Center 9.1/8.1, IBM Cognos 8 BI Data Manager, SSIS, Pentaho Kettle, SQL Server 2008, PL/SQL, Transact SQL, Oracle EBS R12, Oracle Applications 11.0.3, Windows XP.

Confidential, Jacksonville, FL

ETL Informatica Developer

Responsibilities:

• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML. Developed various Ad-hoc mappings for various business needs.
• Designed, tested, and deployed plans using Informatica Data Quality Suite 8.5
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Experience in using Normalizer transformation for normalizing the XML source data.
• Extensively used XML transformation to generate target XML files.
• Developed Scripts to automate the Data Load processes to target Data warehouse.
• Worked extensively with Oracle Data Integrator ODI and Oracle Warehouse Builder OWB
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Involved with the Architecture group to develop ETL metadata strategies and Informatica objects reuse policies. Developed reusable Informatica Mapplet’s and Transformations.
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Involved in production support activities with Installation and Configuration of Informatica Power Center 8.6.
• Analyzed, Designed and Implemented the ETL architecture and generated OLAP reports.
• Used Informatica Workflow Monitor to monitor and control jobs.
• Accomplished data movement process that load data from DB2 into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, and MULTILOAD.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Created BTEQ and multiload scripts to load Teradata tables.
• Worked extensively with Teradata utilities (MLOAD, TPUMP and FAST LOAD) to load data.
• Wrote stored procedures, functions, and database triggers. Created database triggers on tables to generate surrogate keys.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Installation, Configuration and Deployment of Informatica 8.6 with Informatica GRID option.
• Assisted in documenting business requirements for data warehousing and integration needs.

Environment: Informatica Power Center 8.6, Informatica Data Quality Suite 8.5, Teradata V2R6, Oracle 10g, DB2, TOAD, Erwin 3.5.2, PL/SQL, WINCVS, Windows XP, UNIX, Sun Solaris

Confidential, Albany, NY

ETL Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
• Developed Transformation logic and created various Complex Mappings and Mapplets using the designer.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various sources and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time.
• Monitored Workflows and Sessions.

Environment: Informatica Power center 7.1, Oracle9i, SQL and Windows XP.