SUMMARY

• Around 12 + Years of extensive experience in development and support of SQL Server and Oracle based Data warehousing and Decision Support Systems dealing with large and complex databases.
• 10 + Years of strong experience in development and implementation of Data Warehousing, Database, Data Modeling, Analysis, Design, enhancements and support of business applications using Oracle, SQL, PL/SQL, SQL Loader, DB2, Microsoft SQL Server and DTS.
• 9 + Years of Strong experience in the Design, Administration, Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center 9.1.0/8.1.1/7.1.3/6.2.1 (Designer, Workflow Manager, Workflow Monitor), and PowerConnect.
• 4 + Years of experience as ETL Architect, Data Architect and Application Administrator.
• 6 + Years of Data Modeling and BI Modeling experience. Expert working knowledge of Dimensional and Relational modeling.
• Strong experience in Financial, Insurance and Utility Domains.
• Ability to work on Multiple Projects in a fast paced environment
• Experience with good understanding of the concepts and handling Repository Manager, Designer and Informatica Server Manager.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental loads using Informatica mappings and workflows to provide data for Data Warehouse.
• Experienced in environments requiring direct customer interaction during specifications, design, development and product implementation phases.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Developed and worked with mappings which include transformations like Web Services Consumer, XML PARSER, XML GENERATOR, Expression, Normalizer, Joiner, Router, Aggregator, Update strategy and Lookup (Connected and Unconnected) and others.
• Experience in Application Design, Data Extraction, Data Acquisition, Data Mining, Data Modeling, Development, Implementations and Testing of Data warehousing and Database business systems.
• Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling, ERWIN 4.x/3.x.
• Resolved production issues. Used features like Pre - Session/Post-Session commands/sql for fine tuning of Databases/Data marts, Mappings, Sessions, Various Parameters in oracle and Informatica to get optimal performance.
• Expertise in developing and running Transformations, Mappings, Sessions/tasks, Workflows, Worklets and Batch processes on Informatica server.
• Emphasized on Performance of Mapping Optimizations in Informatica.
• Automation and scheduling of Informatica jobs using Perl Scripts, UNIX shell scripting (CRONTAB) and AUTOSYS and CYBERMATION ESP.
• Exclusive knowledge in Identification of User requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
• Extensively worked on creating Test plans, Test cases and involved in Unit testing, System testing, Integration testing and Functional testing.
• Experienced in using the Oracle SQL* Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Expertise in developing SQL and PL/SQL codes through various Packages, Stored Procedures, Functions and Triggers to implement the business logics of database in Oracle.
• Expert in Performance Tuning of application code at the database level.
• Experience in creating mapping specifications for ETL.
• Extensively worked on Business Objects 6.x Designer, Reporter, and in Supervisor.
• Oracle and SQL Server DBA activities include Creation & Maintenance of Database, Database backup and restore, scheduling, Import & Export, user creations and granting permissions.

TECHNICAL SKILLS

ETL Tools: Informatica 6.x/7.x/8.x/9.1.0, Oracle Warehouse Builder (OWB), SQL Server Integration Services (SSIS).

Business Intelligence: Business Objects 6.1/6.5, Crystal Reports

Programming: SQL, PL/SQL, PERL, C, C++, Java, VB, UNIX Shell Scripting

Web Technologies: ASP, ASP.NET, JSP, Cold Fusion, Perl, HTML, DHTML, XML, UML, Java Script, VB Script, Visual InterDev, Visual Source Safe, Cold Fusion Studio

Data Modeling Tools: ERWin 3.5/4.0.

Databases: Oracle 7.x/8i/9i/10g, MS SQL Server 7.0/2000/2005/2008 , DB2, MySQL, MS Access, Oracle APEX 3.0, Query Analyzer, Enterprise Manager, SQL Server Management Studio, Microsoft DTS, SQL* Loader, Import/Export, TOAD 7.x/9.1

Operating Systems: Windows 95/NT/2000/XP, UNIX, Linux

Web Servers: Apache Web Server, PWS, IIS

Job Scheduling: AUTOSYS, CYBERMATION ESP 2.0, Perl scripts and UNIX shell scripting (CRONTAB)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL Architect / Data Architect / ETL Developer

Environment: Informatica Power center 9.1.0, Oracle 10g, Microsoft SQL Server 2008, TOAD, Cybermation ESP 2.0

Responsibilities:

• Requirement gathering and Business Analysis.
• Designing the ETL Strategy and Architecture of the Project.
• ETL and Data Architecture, data modeling and environment set up
• Creation and maintenance of Informatica users and privileges.
• Responsible in managing tasks and deadlines for the ETL team
• Point of contact on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.
• Interacting with the client on various forums to clarify any queries regarding the functionality and appropriate access required etc.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Development of Logical and Physical data models that capture current state/future state data elements and data flows using Erwin 4.0.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Generating test cases for Unit, SIT, QA and User Acceptance.

Confidential, Charlotte, NC

ETL Architect / Data Architect

Environment: Informatica Power center 9.1.0, Oracle 11g, DB2, Microsoft SQL Server 2008, TOAD, Cybermation ESP 2.0

Responsibilities:

• Involved in overall ETL and Database Architecture, Database design, Database and ETL sizing Estimates
• Designed ETL process as Informatica architect
• Understanding existing Interfaces and Identifying ETL scope
• Reviewed the existing database to propose necessary changes.
• Responsible for logical and physical modeling per business requirements using Erwin.
• Responsible for physical modeling per database and performance requirements.
• Responsible for oversight of the Data Architecture and Data models.
• Worked closely with Data Services group to standardize naming conventions.
• Creating ETL environment, setup folders, AD groups and process Id's
• Requirement gathering, Business Analysis and documentation Functional, Technical, Integration Documents, low level and high level design documents .
• Worked with the Business analysts for requirements gathering and business analysis.
• Requirement gatherings with the Internal Users and sending requirements to Source System Vendor.

Confidential, Charlotte, NC

ETL Architect / Data Architect / Data Modeler / ETL Developer

Environment: Informatica Power center 9.1.0, Microsoft SQL Server 2008, Cybermation ESP 2.0

Responsibilities:

• Participated in the requirement Gathering sessions with the Business users
• Requirements analysis and identification of ETL scope
• Designed ETL process as Informatica architect
• Creation of design documents and mapping specifications.
• Created the Conceptual, Logical and Physical Data Model for staging and ODS.
• Designed the process flow between the source system, ODS and data warehouse
• Identified the source system data required in the data warehouse environment to meet the Business current and potentially future need for reporting.
• Designed and created ETL for daily and conversion load.
• Creation of transformations, mappings, mapplets, sessions, worklets, workflows in Informatica PowerCenter.
• Involved in Performance tuning of mappings and Code Review.
• Worked on several transformations and created and monitored execution of sessions and workflows
• Involved in ETL performance optimization
• Migration of the Sessions, Workflows, Mappings and other objects from Development to Production by Exporting/Importing as XML files and by using Duke inbuilt migration tool from Development to Systest to QA and to Production
• Creation and Execution of .test cases and User acceptance testing
• Scheduling the ETL using Cybermation

Confidential, Charlotte, NC

ETL Architect / ETL Developer

Environment: Informatica Power center 9.1.0, Oracle 11g, Microsoft SQL Server 2008, SQL Server Management Studio, TOAD, Cybermation ESP 2.0

Responsibilities:

• Assisted with ETL strategy planning.
• Responsible for data cleansing and data profiling before initiation of migration process.
• Used Informatica Profiler to profile the data in the source system.
• Responsible for creating mappings for tables using Informatica PowerCenter.
• Responsible for creating mapplets, sessions, workflows, transformations in Informatica PowerCenter.
• Scheduled workflows and monitored them during the test as well as final migration.
• Participated in peer review sessions to ensure conformity between the Data Management & Data Migration teams.
• Designed Data Flow Models for better communicate the design to the business users.
• Analyzing source data sets to capture Meta Data, Data Formats and Data Types
• Also responsible for creating, documenting and maintaining the metadata.
• Responsible for conducting Brainstorming sessions with the clients to review Logical and Physical models.
• Reviewed the existing database to propose necessary changes.
• Interacted with the business team to clarify the requirements
• Responsible for oversight of the Data Architecture and Data models.
• Maintain security and data integrity of the database
• Scheduling the ETL using Cybermation

Confidential, Charlotte, NC

ETL Architect / ETL Developer

Environment: Informatica Power center 9.1.0 (ETL), CSV Files, Microsoft SQL Server 2008, SQL Server Management Studio, Cybermation ESP 2.0

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed the Data models for Data mart. Created Logical and Physical Data models using Erwin
• Designed ETL process as Informatica architect
• Designing functional specifications and technical specifications
• Created Informatica ETL code from functional and technical specs.
• Designed and Installed test scripts for ETL code.
• Designed and created Perl Scripts, FTP scripts for moving source files to Informatica file share
• Documented all ETL code with proper changes.
• Created testing plans and testing scripts.

Confidential, Charlotte, NC

ETL Architect / ETL Developer

Environment: Informatica Power center 9.0.1 (ETL), Oracle 10g, Microsoft SQL Server 2005, SQL Server Management Studio, DB2, TOAD, Cybermation ESP 2.0

Responsibilities:

• Requirement gathering and Business Analysis.
• Identifying ETL scope and designing ETL process.
• Support data extraction, cleansing, aggregation, reorganization, transformation, and load operations.
• Developed Perl Scripts to extract source files from Business file share to Informatica file share and transfer the exception files back to Business file share.
• Designed and created FTP scripts for moving source files to Informatica file share
• Generated Exception files for Error handling.
• Creating Cybermation applications for scheduling Informatica workflows.
• Responsible for Documenting processes and procedures required for support
• Created Test Plan and Test Strategy using the design documents.

Confidential, Charlotte, NC

ETL Architect / Data Architect

Environment: Informatica Power center 8.6.1 (ETL), CSV files, Microsoft SQL Server 2005, SQL Server Management Studio, Cybermation ESP 2.0

Responsibilities:

• Requirement gathering and Business Analysis.
• Involved in Data Profiling and Analysis
• Identified gaps in the Requirements and proposed alternative implementation approaches
• Involved in Data Mapping between Source and Target Systems
• Involved in the Detailed Design doc Preparation
• Identifying ETL scope and designing ETL process.
• Access data from multiple operational data sources, CSV files, re-map source data into a common format, Filter data and calculate derived values, aggregates, load cleansed data to the target SQL Server database.
• Designed and created Perl Scripts, SFTP scripts for moving source files to Informatica file share
• Responsible for Unit, Integration, Performance and System Testing and raising the defects in QC tool.
• Involved in Unit, System Testing and User Acceptance Testing to check the data loading into the target, which was extracted from different source systems according to the user requirements.
• Architected, designed and developed Logical and Physical models for Staging and Target databases using Erwin 4.0.
• Created Test plan, testing strategy and test cases using the requirements and design documents

Confidential, Charlotte, NC

ETL Architect / Data Architect / Application Administrator

Environment: Informatica Power center 8.6.1 (ETL), Oracle 10g, Microsoft SQL Server 2005, SQL Server Management Studio, DB2, TOAD, Cybermation ESP 2.0

Responsibilities:

• Participated in the requirement Gathering sessions with the Business users
• Identifying ETL scope and designing ETL process.
• Designed and Created ETL mapping standards and procedures.
• Worked on Informatica Templates to standardize the design and migration process and maintain consistency across different teams.
• Creation and maintenance of Informatica Users, Folders and Privileges.
• Migration of changes, enhancements, upgrades, etc. through the various environments.
• Deployment of Informatica Mappings/Sessions/Workflows into Production environment.
• Created documents and manuals for Informatica upgrades, Configuration, Migration procedures ETL Architecture and Naming Standards.
• Provide technical expertise in all aspects of administrative data processing.
• Performed gap analysis between the current state and future data warehouse environment identifying data gaps and quality issues recommended potential solutions.
• Customized the design of the Data warehouse according to the Business requirements
• Involved in the Designing the Overall Architecture, Database design /Database and ETL sizing Estimates
• Maintains Technical Standards and Organizational policies for the Database design, Data storage, Data retrieval
• Created the Conceptual, Logical and Physical Data Model designing the Fact and Dimension tables
• Involved in Data Mapping between Source and Target Systems
• Lead a Team of ETL and Reporting Developers and co-coordinated onsite /offshore activities
• Responsible for analyzing, architecting, designing and developing ETL strategies and processes, writing ETL specifications for Informatica development/administration understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Designed and translated business requirements into technical ETL design
• Scheduling the sessions to extract, transform and load data in to ODS and data warehouse on Business requirements.
• Responsible for monitoring batch execution job schedules.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.

Confidential, Charlotte, NC

ETL Architect / ETL Developer

Environment: Informatica Power center 8.6.1 (ETL), Oracle 10g, Microsoft SQL Server 2005, SQL Server Management Studio, DB2, TOAD, Cybermation ESP 2.0

Responsibilities:

• Creation and Maintenance of Informatica users and privileges.
• Created Groups, roles, privileges and assigned them to each user group
• Migration of Informatica Mappings, Sessions, Workflows from Dev to SysTest to QA to Prod environments.
• Extensively worked on Informatica Mappings/Session/Workflows to extract data from ECOM and Customer Hub to Oracle Outage Management System.
• Maintain data in reference data tables.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Responsible for Unit, Integration, Performance and Regression Testing of ETL environment and raising the defects in QC tool.
• Developed reusable Mapplets and Transformations
• Designed and Executed Customized views.
• Scheduling and Loading data process and monitoring the ETL Process.
• Created Test plan, testing strategy and test cases using the requirements and design documents
• Actively involved in the Production support and also transferred knowledge to the other support teams.

Confidential, Charlotte, NC

Sr. ETL Consultant

Environment: Informatica Power center 8.1.1 (ETL), Oracle 10g, Microsoft SQL Server 2005, SQL Server Management Studio, DB2, TOAD, Cybermation ESP 2.0

Responsibilities:

• Mapped the requirements and process flows to create Technical Design Specs.
• Creation of Mapping specifications using various transformations to suit the business user requirements and business rules to load data from Source to the Target systems.
• Worked on ETL to move newly published MSDS Numbers and Vendor Information to the Maximo Hub and MSDS Numbers to the VMSDS CMDTY (DB2) table for legacy compatibility.
• Developed ETL to load MSDS Numbers / Commodity Numbers from MEDB (Passport 4 & Peoplesoft) to the ETRAC STAGING database.
• Developed ETL to load MSDS Numbers / Catalog ID's from Passport 8 to the ETRAC STAGING database.
• Developed ETL to load MSDS Numbers / Item Numbers from Maximo to the ETRAC STAGING database.
• Developed ETL that pulls UTC data from the Nuclear Asset Suite database and submits the data to the ETRAC integration web service 200 records at a time for upload to ESS.
• Developed ETL that pulls catalog and purchasing description data from the MSDS Chemical Inventory Balance table in the ETRAC STAGE database and submits the data to the ETRAC integration web service 200 records at a time for upload to ESS.
• Developed ETL that pulls Chemical Inventory data from the MSDS Chemical Inventory Balance table in the ETRAC STAGE database and submits the data to the ETRAC integration web service 200 records at a time for upload to ESS.
• Involved in source system analysis and identification of key data issues.
• Designed, developed, and deployed Informatica mappings using various transformations to suit the business user requirements.
• Extensively used various types of transformations like Web Services Consumer, XML PARSER, XML GENERATOR, Expression, Normalizer, Joiner, Router, Aggregator, Update strategy and Lookup (Connected and Unconnected) to load the data.
• Migration of ETLs from DEV to SYSTEST to QA to PRODUCTION.
• Creation, configuring, scheduling and running of workflows using Perl scripts, Informatica scheduler and Cybermation ESP.
• Performance Tuning of Informatica Mappings and Sessions.
• Responsible for testing and implementing new releases.

Confidential, Carlsbad, CA

ETL Architect / Data Architect / ETL Developer

Environment: Informatica Power center 8.1.1 (ETL), Oracle 10g, PL/SQL, TOAD. Erwin 4.0

Responsibilities:

• Interacting with business users to analyze the Project requirements.
• Mapped the requirements and process flows to create Technical Design Specs.
• Involved in the design and development of Member Data Mart, Prospect Data Mart and Agreement and Revenue Data Marts.
• Involved in source system analysis and identification of key data issues.
• Prepared logical/physical diagram of DW, in Erwin.
• Responsible for data integration/migration from various source systems into a Data Warehouse environment.
• Involved in generating data warehouse extracts for Acxiom.
• Designed, developed, and deployed Informatica mappings using various transformations to suit the business user requirements.
• Creation, configuring, scheduling and running of Sessions.
• Extracting member enrollment and transaction processing data from various sources into data warehouse for generating Audit and EasyPay reports.
• Performance Tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.
• Responsible for testing and implementing new releases.
• Created PL/SQL packages, procedures and functions to implement the business logic and for history fix.
• Tuning the SQL/PLSQL queries.

Confidential, San Jose, CA

Sr. ETL Consultant

Environment: Informatica Power center 8.1.0 (ETL), Oracle 9i/10g, PL/SQL, TOAD.

Responsibilities:

• Supported migration from Informatica 7.1.3 to Informatica 8.1.0.
• Post upgrade support and issue resolution.
• Interacting with business users to analyze the Project requirements.
• Involved in the development of Data Warehouse.
• Creation of Mappings specifications using various transformations to suit the business user requirements and business rules to load data from Oracle and flat file sources.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from source systems like Flat files, Oracle and loading to Oracle target Data Warehouse.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions.
• Creation, configuring, scheduling and running of Sessions.
• Checked the disk space and purged/moved Informatica logs, this also includes truncating the workflow logs through Repository Manager.
• Worked with Metadata reporter to generate ETL execution statistics in Dev, QA and Prod.
• Post Production support to monitor execution of all ETL jobs.
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update strategy, Lookup (Connected and Unconnected) to load the data.
• Created PL/SQL packages, procedures and functions.
• Tuning the SQL/PLSQL queries.

Confidential, Chicago, IL

Sr. ETL Consultant

Environment: Informatica Power center 7.1.3 (ETL), Oracle 9i, PL/SQL, Microsoft SQL Server 2005, Business Objects 6.5, TOAD, Erwin 4.0., SQL Server Management Studio

Responsibilities:

• Involved with the Architecture team to develop a template for different kinds of ETL extractions.
• Responsible for ETL work from legacy mainframe data using Informatica and PL/SQL.
• Supported multiple repositories in Prod, Dev and QA.
• Created Users in Informatica using Repository Manager. Worked extensively on Repository Manager.
• Created folders and provided access to required users, groups for ETL development.
• ETL Backup and restore with import and export.
• Migration of ETLs from Dev to QA to Production.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Used the command line program pmcmd to communicate with the Informatica Server and for executing the workflow and tasks.
• Interacting with business users to analyze the Project requirements.
• Creation of Mappings specifications using various transformations to suit the business user requirements and business rules to load data from Oracle and flat file sources.
• Involved in the design and development of Data Warehouse.
• Tuned and tested the Jobs to perform better using different logics to provide maximum efficiency.
• Tuning the SQL/PLSQL queries
• Creation, configuring, scheduling and running of Sessions.
• Post Production support to monitor all ETL jobs.

Confidential, Carmel, IN

Informatica Administrator & Developer

Environment: Informatica Power center 7.1 (ETL), Oracle 9i, PL/SQL, Microsoft SQL Server 2000, Query Analyzer, Business Objects 6.1, TOAD, Erwin 3.5.

Responsibilities:

• Worked as Informatica Administrator and Developer for pursuing primary responsibilities of the ETL tool and providing services to the client.
• As Informatica Administrator supported multiple repositories in Prod, Dev and QA.
• Processed daily requests for creating user permissions, Object/Folder migration to Production Repositories, creating new DB connections & Backup - Restore Informatica repositories.
• Worked on parameterization of Source, Target & lookup DB Connection values.
• Configured the Repositories.
• Worked for the maintenance of the Informatica production and non production Repositories.
• Created folder/application and also built mappings, sessions & workflows.
• Migration of ETLs from Dev to QA to Production.
• ETL Backup and restore with import and export.
• Post Production Support.
• Design and development of Data Warehouse.
• Prepared logical/physical diagram of DW, in Erwin
• Designing and optimizing the Mapping.
• Creation of the various transformations is implemented through Informatica Designer.
• Configuring and Scheduling Sessions in Server Manager.
• Configuring Informatica Server for loading of data.
• Involved in the development of Packages, PL/SQL stored procedures and functions.
• Tuning the SQL/PLSQL queries.
• Designed the Universe in Business Objects Designer.
• Designed the Reports using Business Objects.

Confidential, Carmel, IN

Software Engineer

Environment: ASP, HTML, Java Script, Oracle 9i.

Responsibilities:

• Involved in the gathering system requirements, analysis, design and development.
• Involved in the database and application design of the modules, setting up database schemas, tables, indexes, views, synonyms, constraints and other database objects.
• Preparation of SRS, SDD and coding JSP pages
• Involved in design, coding and testing of the application.