Objective

Senior Data warehouse Architect specialized in Data modeling, ETL , data integration and data warehousing implementation is seeking a challenging and interesting position as ETL Architect or Data Architect allowing to complement and contribute 16 years of proven skills in the most effective manner.

Profile

• Over 16 years IT experience in data integration, data warehousing, data modeling and ETL implementation.
• About 13 years of Data warehousing experience using Informatica PowerMart 4.5 7.1 , Informatica Power Center 1.7 - 9.0.1 .
• Expert in Informatica and database performance tuning and handling large volume of data.
• Designed and implemented Informatica Power Center RT to process real time xml messages.
• Extensive experience with following databases Oracle 7-11g , Teradata 13 , Sqlserver, DB2, UDB 5.0 and Neoview.
• Ability to approach engagements as partnerships, demonstrate leadership and take ownership.
• Reputation for reliability and consistent delivery of results.
• Specialized in finding custom solutions to fit the specific functional and cultural needs of the business.
• Installed, configured, upgraded and administrated Informatica Power Center in unix, linux and NT operating system.
• Extensive data warehousing experience in Banking, Investment, manufacturing, Energy trading, Retail and Telecommunication industry.
• Expert in architecting and implementing strategic ETL solutions.
• Effective communicator adept in delivering superior customer service and bridging the business and technical communities.
• Proactive and result-oriented leader proficient in mentoring and leading teams to exemplary performance.
• Informatica Chapter leader for Atlanta, GA 2005 - 2009

Skills Summary

• ETL Tools Informatica PowerCenter 1.7-9.1 , Power Exchange neoview
• teradata , Informatica Powercenter RT, Informatica B2B Data Exchange
• 9.1, Informatica B2B Data Transformation 9.1, SSIS 2008, BIxpress.
• Data Modeling Tools Erwin 8.0, DB Designer 4.0, Data Architect 9.5, Power Designer 16.5
• Methodologies Ralph Kimball, Bill Inmon, Star and Snowflake
• BI Tools Impromptu 6.0, Power Play Business Objects 5.1
• Databases Oracle 7.3-11g , Teradata 13, Sql Server, UDB2 5.0, DB2, Neoview,
• Netezza.
• Oper. System MVS, Sun Solaris 8.0, Windows 95/98/NT/2000, Linux.
• Languages C, C , Java, Cobol, PL/SQL, Shell Awk scripting, PGP 6.0
• DB Tools FastLoad, Mload, bteq, SQL Loader, Toad, Dbvisualizer 7.1.2
• QA Tools Test Director 5.0, Win Runner 5.0, Quality Center 9.2
• Web Tools Visual Cafe 3.0, Visual Age 3.0, Front Page 2000
• Mainframe Tools Command Center, Exceed 6.2, Queryman 5.11, Extra Client, Qmf
• Scheduling Tools Control M, CA unicenter
• Change Management PVCS Tracker 6.0, Perforce
• IDE's Visual Caf 3.0, Visual Age 3.0,
• App. Serves Jboss 4.0, Weblogic 7.0
• Frontend Tools Power Builder 4.0, Forms 4.5, Oracle Report Writer 2.5

Professional Experience

Sr. Technical Architect

Confidential

• As a Enfathom consultant worked for HCA on their Customer ROI project to integrate thirteen Patient and Physician contact centers data by Standardizing marketing transactions, establishing patient and physician master data to realize Customer ROI. Developed matching and weighting process for direct and indirect revenue from service line and customer service transactions. Customer ROI helps physicians and hospitals to grow their business and manage their patient's experience throughout the enterprise.
• As a Lead Architect involved in design of Customer ROI.
• Performed Data analysis, Data modeling and ETL Design.
• Environment: DM Express 7.9.0, Teradata 13, Unix, Power Designer 16.5, Sqlserver 2010, Saleforce

Confidential

• As a Enfathom consultant worked for Comcast on their social media dash board project to present a unified and cohesive story of the social media activities across multiple social media sources.
• As a Lead Architect involved in design of social media dash board.
• Performed Data analysis, Data modeling and ETL Design.

Environment: Informatica 8.6, Teradata, Unix, ER Studio Data Architect 9.5

Confidential

As a Enfathom consultant worked for Department of Education on their data integration project CACDS .

• As a Lead Architect involved in ETL design, development and testing.
• Performed Data analysis, Data modeling and setup ETL environment.
• Implemented bi-directional SOA services to receive Student MDM data.

Environment: SSIS 2008, Erwin 8.0, BIxpress, BIdocumentor., SQL SERVER, Win 2000

Confidential

• As a Enfathom consultant worked for Auto Trader on their Dealer Scorecard project.
• Involved in ETL design, development and testing.
• Created Shell script to automate file processing.

Environment: Informatica PowerCenter 9.1, Oracle 10g, Netezza, Aginity Workbench, Putty

Sr. Consultant Team Lead

Confidential

• As a Brick House consultant worked for Daugherty Business solution on the data conversion and data integration project RPM with GPC.
• As ETL Lead involved in ETL design, development and testing.
• Installation and configuration of Informatica Powercenter, Web Hub, Model Repository and other utilities.
• Developed coding, peer review and migration standards.
• Installation and configuration of Informatica Powercenter, Web Hub, Model Repository, Analyst and other utilities.

Environment: Informatica PowerCenter 9.1 , Oracle 10g, Linux, Putty, and Sql developer.

ETL Lead Team Lead

Confidential

• RIM is the producer of BlackBerry products and the Enterprise data warehouse tracks device usage, sales and activation data received from around the world.
• Involved in ETL design, development, implementation, Performance tuning and Production support using Informatica 8.6.1 with oracle, Neoview and teradata databases.
• Worked on following data warehouse projects Relay, Cerebro, Tesla, Bes, BW verizon and other data integration projects.
• Provided supervision and technical oversight for all data warehousing projects and leadership to team of twelve.
• Developed coding, peer review and migration standards.
• Performed informatica administration, performance tuning and code migration. 16 informatica servers .
• Installation and configuration of Informatica Powercenter, Power Exchange neoview teradata , and other utilities.
• Worked with multi tera-byte database 100TB neoview teradata .
• Provided after hour support and fixed production issues on a timely manner.
• Created shell script to dynamically generate aggregation sql and load summarize data in neoview.
• Performed project evaluation, estimation and resource assignment of data warehouse projects.

Environment: Informatica PowerCenter 8.6.1 , Power Exchange for Neoview, Power Exchange for Teradata, Informatica Grid, Informatica SAP BW service, Oracle 10g, Linux, Toad, Teradata 13, Neoview, Dbvisualizer, Putty, Sql developer and Perforce

Senior Consultant

Confidential

• As a Pyramid consultant worked for IHG on their data integration project Magic, Hr data mart and Global sales data mart.
• Involved in ETL design, development and testing using informatica.
• Contributed to technical troubleshooting, problem solving and coded debugging.
• Provided after hour support and fixed production issues on a timely manner.
• Recommended data warehouse enhancements and optimizations for support integration.
• Provided design for real-time membership application data integration.
• Created shell scripts to use bteq to load data in Teradata.

Environment: Informatica PowerCenter 7.2 8.6 , Oracle 10g, Unix, Toad, Teradata, Putty, bteq, mload.

Senior Consultant

Confidential

• As a Peak consultant worked for Cox communication on Reliability Reporting project to predict the reliability of equipments.
• Performed Data modeling, ETL developer for Reliability Reporting project Phase 1 II.
• Designed a scalable and reliable dimensional model to track 30 million equipments movement history for 20 years.
• Performed ETL design, development, testing, tuning and database tuning.
• Provided database size estimation for initial, yearly and for 5 years.
• Created shell scripts to extract data from reliability data mart for application integration.
• Collaborated with DBA's to ensure that ETL jobs, database, network and data movement process are monitored and managed.

Environment: Informatica PowerCenter 7.2 8.6 , Oracle 10g, Linux, Toad, Putty, DB Designer 4.0

Lead Senior Software Systems Engineer

Confidential

• As a Saic consultant worked for CDC on BioSense project to provide federal, state and local officials with up-to-the minute views of suspect illness trends and probable disease cases.
• Involved in ETL design, development and testing using informatica.
• Architected ETL solution to process xml message from weblogic queues using informatica RT.
• Performed informatica upgrade from 7.2 NT/sqlserver to 8.5 unix/oracle
• Performed installation, configuration of informatica RTand Jboss Reporting service.
• Involved in project release evaluation, estimation and production support.

Environment: Informatica PowerCenter RT 7.2 8.5 , Sqlserver 2000, NT, Rhapsody, weblogic , Oracle 10g, Toad, Unix, Jboss

Senior Consultant

Confidential

• As a Pyramid consultant worked for Cgi-Ams on Bellsouth mass market data warehouse project.
• Performed performance tuning on informatica jobs and database objects.
• Performed production support for Informatica and Business Objects.
• Performed ETL bug fixes.

Environment: Informatica PowerCenter 6.2.2, Oracle 8.x - 9i, Sun Solaris 2.6, Win 2000, Shell Scripts, Erwin 4.0, PVCS, Putty, Toad, Business Objects 6.5

Senior Data Architect Team Lead

Confidential

• Mirant is an energy company that produces, sells electricity and energy trading. Endur is the energy trading application and EDW snapshot the trading position twice a day to provide position on commodity trading.
• Involved in Data modeling, ETL design, development, implementation, Performance tuning and Production support using Informatica.
• Worked on following data warehouse projects Endur Data mart, MRS data mart, Energy analysis data mart, collateral data mart projects.
• Provided supervision and technical oversight for all data warehousing projects and leadership to ETL team.
• Performed project evaluation, estimation and resource assignment of data warehouse projects.
• Developed coding, peer review and migration standards.
• Performed informatica administration, performance tuning and code migration.
• Performed informatica upgrade from 5.1 to 6.22.
• Provided after hour support and fixed production issues on a timely manner.
• Created shell script to automate load snapshot and file processing.
• Worked with multi tera-byte data

Environment: Informatica PowerCenter 6.2.2, Oracle 8.x - 9i, Sun Solaris 2.6, Win 2000, Shell Scripts, Erwin 4.0, PVCS, Putty, Toad.

Senior Consultant

Confidential

• As a Covansys consultant worked for BMW financial services on the Atomic POC project.
• Involved in proof of concept effort to implement Informatica PowerCenter 6.0 Sql Server
• Performed Data analysis, Design, Development and setup ETL environment.

Environment: Informatica PowerCenter 6.0, SQL SERVER, Win 2000

Confidential

• As a Covansys consultant worked for Ge Aircraft Engine on the Sale cost Data warehouse project.
• Performed Dimensional data model review.
• Performed Data Analysis, Design data structures for staging and ETL control.
• Involved in ETL design, development, implementation and Performance tuning.
• Created ETL solution to receive data weekly and monthly from seven different source systems.
• Created Shell scripts to preprocess source feeds.
• Integrated ETL load with Power Play refresh.

Environment: Informatica PowerCenter 5.1, impromptu 6.0, Power Play 6.0, Oracle 8i, Sun Solaris 2.6, Win 2000, Unix, Erwin, Shell Scripts

Confidential

• As a Covansys consultant worked for Victoria secrets on the Financial system project.
• Involved in data integration People soft, mainframe and other distributed systems.
• Created ETL solution to integrate People soft G/L and A/P systems in Financial data mart Teradata
• Provided ETL solutions for Allocation, Catalogue Accounting, Return Reserve and Gross Margin subject areas.
• Created shell scripts to schedule informatica jobs using scheduler Control-M

Environment: Informatica PowerMart 5.1, Teradata 4.2, Sun OS 5.7, Win NT, Shell Script, Control-M, Queryman 5.11, WinDDI 4.1.1, Exceed 6.2, Mvs OS/390, Extra Client, mload

Confidential

• As a Covansys consultant worked for Ge Aircraft Engine on the Digital cockpit Data Mart project.
• Involved in ETL design, development and implementation.
• Provided Technical oversight for all Data warehousing projects.
• Performed installation and configuration of informatica.
• Created ETL frame work to collect load statistics and error processing.
• Created shell script to perform informatica administration and trigger informatica jobs.
• Performed Informatica upgrade from PowerCenter 1.6.2 to 5.1.

• Integrated ETL load with Power Play refresh.
• Performed informatica administration and migration.

Environment: Informatica PowerCenter 5.1, impromptu 6.0, Oracle 8i, Sun Solaris 2.6, Win 95, Unix, Erwin

Confidential

• As a Covansys consultant worked for State Teachers Retirement System of Ohio on the Investment Data mart project.
• Created ETL solution to receive data from mainframe.
• Involved in Design, Develop, Implementation and Performance tuning of ETL process
• Generated ETL documentation from metadata manger and published it over the intranet.
• Created and published ETL design document, Production batch support and migration procedures.
• Created web pages and Servlets for Web users to launch Informatica batches and view the session logs.

• Integrated ETL load with Power Play refresh.
• Created shell script to informatica administration and workflow execution.
• Performed Informatica upgrade from PowerCenter 4.6.1 to 4.7.2

Environment:: Informatica PowerCenter 4.7.2, impromptu 6.0, UDB 5.0, Novel 4.01, NT4.0, Command Center, Extra client, Mvs, Qmf, Jrun, FrontPage 2000, Visual Caf 3.0

Confidential

• As a Covansys consultant worked for Cendant Corporation on their data warehousing projects.
• Worked on following data warehouse projects Membership-Financial integration, Financial Transaction Controller, Financial Data store.
• Created shell script to decrypt incoming feeds and encrypt PGP sensitive columns before loading.

• Created ETL frame work to collect load statistics and error processing.
• Performed Design Review for ETL.
• Involved in Design, Develop, Implementation and Performance tuning of ETL process

Environment: Informatica 4.6, Reports 3.0, Oracle 8.0.5, Test Director 5.0, pl/sql, Sun Solaris 2.7, Novel 4.0.1, NT 4.0 workstation, PGP 6.0, shell, awk.

Confidential

• As a Covansys consultant worked for Bank One on Blue Note project.
• Performed Corporate banking application testing on multiple browsers.
• Involved in writing test scripts in Test Director
• Prepared Test Data for Automation, Functional testing, integration testing and vendor release acceptance testing.
• Performed functional testing on corporate banking for Global Administration, CWM Administration and Customer Set-up.
• Performed Load testing using Win Runner.

Environment: Netscape 4.0.6, IE 5.0, Test Director 5.0, Win Runner 5.0, PVCS Tracker 6.0, Sun Solaris 2.5, Windows 95, Lotus Notes, DB2 5.2.0, Novel 4.0.1, NT 4.0.

Confidential

• As a SIC consultant worked for MBF Finance on the migration of banking system to client/server project.
• Provided ISO9000 standard detail Functional Requirements, technical Design and design documentation.
• Create shell scripts to download files from Mainframe via DW3300 data transfer machine.
• Involved in batch coding using C, UCT, syncort and shell scripting.
• Product Roll-out and Implementation for following modules Saving, Fixed deposit and Loan
• Scheduled batch programs via CA unicenter.
• Production supervisor for batch processing.
• Provided supervision, technical oversight and leadership to development team.
• Performed project evaluation, estimation and resource assignment.
• Performed Unit/System/Performance and Integration Testing
• Product Roll-out and Implementation.
• Managed production support team.

Environment: Oracle 7.3, Power Builder 4.0, Oracle Report Writer 2.5, Uct, Tuxedo 5.0, Udt, Sun Solaris, C, Sql Loader, Sql Plus, Pl/Sql