OBJECTIVE

• Director/Architect/Manger specialized in Data integration, data modeling, ETL, data warehousing and Data lakes leaveraging Big data with cloud platforms is seeking a challenging and interesting position allowing to complement and contribute 20 years of proven skills in the most effective manner.

SUMMARY

• Over 20 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).
• 6 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

• 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, Pentaho Data Integration 7.x, Confidential .
• Erwin 8.0, DB Designer 4.0, Data Architect 9.5, Power Designer 16.5
• Ralph Kimball, Bill Inmon, Star and Snowflake
• Impromptu 6.0, Power Play Business Objects 5.1
• Oracle (7.3-11g), Teradata 13, Sql Server, UDB2 5.0, DB2, NeoviewNetezza, Snowflake.
• MVS, Sun Solaris 8.0, Windows 95/98/NT/2000, Linux
• C, C++, Java, Cobol, PL/SQL, Shell & Awk scripting, PGP 6.0
• FastLoad, Mload, bteq, SQL*Loader, Toad, Dbvisualizer 7.1.2
• Test Director 5.0, Win Runner 5.0, Quality Center 9.2
• Visual Cafe 3.0, Visual Age 3.0, Front Page 2000
• Command Center, Exceed 6.2, Queryman 5.11, Extra Client, Qmf
• Control - M, CA unicenter
• Change Management PVCS Tracker 6.0, Perforce, Git, Jira
• App. Serves Jboss 4.0, Weblogic 7.0
• Power Builder 4.0, Forms 4.5, Oracle Report Writer 2.5
• Cloudera, HDFS, Pig, Solr, Impala, Hbase, AWS, S3

PROFESSIONAL EXPERIENCE

Head of Solutions - Director

Confidential, Sunnyvale, CA

Responsibilities:

• Confidential is next gen data integration platform with Spark and kafka engine.
• Confidential helps customers integrate, unify, cleanse and build data integration solutions for their Enterprize.
• Confidential allows customers to build integration pipelines using stream and self-service with next generation ingestion engine.
• As Director and Head of Solutions, I lead solution architecture to address data integration challenges of our customers to enable IT and business organizationto success.
• I also lead and enable Pre & Post sales, Professional service and Support groups.

Environment: Confidential, Hadoop(HDFS), Linux, Sqlserver 2010, AWS, Azure, S3, Snowflake.

Sr. Data Expert/Ingestion Manager

Confidential

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 7.x, Hadoop(HDFS), CDH 5, Linux, Sqlserver 2010, Pig, Solr, Impala, Hbase, AWS, S3, Confidential

Sr. Technical Architect

Confidential

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

Sr. Consultant

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

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