SUMMARY:

• Senior Data expert/Architect/Manger specialized in Data integration, data modeling, ETL and data warehousing implementation is seeking a challenging and interesting position allowing to complement and contribute 19 years of proven skills in the most effective manner.
• Over 19 years IT experience in data integration, data warehousing, data modeling and ETL implementation.
• About 16 years of Data warehousing experience using Informatica PowerMart 4.5 - 7.1, Informatica Power Center (1.7 - 9.0.1).
• 3 years of Big data integration experience with Cloud based Supply chain Product management solution
• 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.
• 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.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter (1.7-9.1), Power Exchange (neoview &teradata), Informatica Powercenter RT, Informatica B2B - Data Exchange9.1, Informatica B2B Data Transformation 9.1, SSIS - 2008, BIxpress, Pentaho Data Integration 6.x.

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, Git, Jira

App. Serves: Jboss 4.0, Weblogic 7.0

Frontend Tools: Power Builder 4.0, Forms 4.5, Oracle Report Writer 2.5

Big Data Tool: Cloudera, HDFS, Pig, Solr, Impala, Hbase, AWS, S3

PROFESSIONAL EXPERIENCE:

Sr. Data Expert/Ingestion Manager

Confidential, Charlotte, NC

Responsibilities:

• Involved in ETL design, development, implementation, Performance tuning and Production support using Pentaho Data Integration and Hadoop(HDFS).
• Worked on loading Supply chain data into HDFS, Hbase, Solr and Impala.
• Provided after hour support and fixed production issues on a timely manner.
• Manage Ingestion team - Customer Onboarding, Support Proof of value, Design Integration architecture.

Environment: Pentaho Data Integration 6.x, Hadoop(HDFS), CDH 5, Linux, Sqlserver 2010, Pig, Solr, Impala, Hbase, AWS, S3

Sr. Technical Architect

Confidential, Charlotte, NC

Responsibilities:

• 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, Philadelphia, PA

Consultant

Responsibilities:

• 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, Atlanta, GA

Responsibilities:

• 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, Atlanta, GA

Responsibilities:

• 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, Atlanta, GA

Responsibilities:

• 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, Atlanta, GA

Responsibilities:

• 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, Atlanta, GA0

Responsibilities:

• 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 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, Atlanta, GA

Responsibilities:

• 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, Atlanta, GA

Responsibilities:

• 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, Atlanta, GA

Responsibilities:

• 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, Atlanta, GA

Responsibilities:

• 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, Columbus, OH

Responsibilities:

• 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, Cincinnati, OH

Responsibilities:

• 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, Columbus, OH

Responsibilities:

• 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, Cincinnati, OH

Team Lead

Responsibilities:

• 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, Columbus, OH

Responsibilities:

• 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, Columbus, OH

Responsibilities:

• Worked on following data warehouse projects -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, Columbus, OH

Responsibilities:

• 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.

Analyst Programmer

Confidential

Responsibilities:

• 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.
• 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