We provide IT Staff Augmentation Services!

Head Of Solutions - Director Resume

Sunnyvale, CA

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

Hire Now