SUMMARY

• Data warehouse/ ETL resource with more than 14 years of experience in design, development, testing and supporting complex Enterprise data warehouse projects in AWS,Oracle, SQL Server, Netezza& DB2 environments.
• Worked on many technologies like SSIS, Talend, SAP BODS, Informatica, IBM DataStage, Oracle 19c, DB2, MS Access, MS SQL Server, Netezza, Business Objects, Xcelsius, Cognos11x, Hyperion Essbase, Oracle DRM, Java, C++, XML,SAS Data Integration Studio, Python programming, Text analytics, Kafka, Kibana, Spark.

PROFESSIONAL EXPERIENCE

Confidential, Plano TX

ETL Consultant

Responsibilities:

• Design, development& support of Enterprise content management project which delivers 360 degree of XO customers. Also supporting other EDW projects using Informatica, IBM Datastage, Oracle, Netezza, &Unix env.
• Design, development & support of Enterprise content management project integrating data from multiple applications
• Used Informatica Power Center to integrate data across Seibel, Oracle, SQL Server databases and flat files.
• Analysis of existing ETL design and make enhancements as per new requirements.
• Support business groups for new enhancements and debug data issues to provide accurate customer data.
• Worked on workflow management for new ETL codes using Python programming.
• Was involved with team to process real time data/ data streams using Kafka, Spark and built Kibana dashboards.
• Have worked with many application functionalities like, Mapping Designer, Mapplet Designer, Informatica Repository Manager, Metadata manager and Informatica Workflow Manager.
• Developed various medium to complex mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations
• Designed many Informatica mappings to load teh data according to functional requirements.
• Worked on Informatica jobs to automate real time & daily incremental nightly load of OLTP data.
• Worked on Informatica performance tuning and optimization
• Also working on a ETL project supporting XO infrastructure using IBM Datastage 9.1 application.
• Development and implemented Parallel jobs using IBM info sphere Data stage
• Implemented multi - node declaration using configuration files (APT Config file) for performance enhancement
• Debug, test and fix teh transformation logic applied in teh parallel jobs
• Used teh ETL Data Stage Director to schedule and running teh jobs, testing and debugging its components & monitoring performance statistics
• Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data
• Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter
• Designed and developed teh UNIX shell scripts for teh automation of ETL jobs

Confidential, Dallas, TX

ETL Consultant

Responsibilities:

• Responsible for design, development, implementation, administration of Sales Data Warehouse and working on integrating sales data across different POS systems.
• Working with a role of data analystand ETL developer using Informatica IDQ & Powercenter.
• Analysis and enhancements of ETL mappings to integrate data across different sources(Cobol,flat files, SQL Server, Oracle).
• Redesign existing Netezza stored procedures with Informatica mappings.
• Delivering full system including data extraction, transformation and presentation layers in Cognos.
• Used Informatica IDQ tool for data cleansing/standardization for data coming from different sources.
• Supporting Cognos reporting queries, assisting users to build reports and troubleshooting for any data issues.
• Designed and developed teh UNIX shell scripts for teh automation of ETL jobs
• Production Support for nightly ETL jobs

Confidential, Jacksonville, FL

Sr. Software Engineer

Responsibilities:

• Served as project lead in teh completion of 8+ medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
• Used Informatica Power Center 9.5 for extraction, transformation and load (ETL) of data in teh data warehouse.
• Have worked with many application functionalities like, Mapping Designer, Mapplet Designer, Informatica Repository Manager, Metadata manager and Informatica Workflow Manager.
• Developed various medium to complex mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Extensively used Informatica debugger to figure out teh problems in mappings.
• Have used TOAD for SQL Developer as interface for analysis and development with Oracle database.
• Developed PL/SQL stored procedures for database updates and to create teh necessary indexes in teh target tables.
• Worked on database partitioning to assist faster ETL jobs and query performance on large tables.
• Worked on building Hyperion Essbase cubes and data perpetration to support it.
• Have good noledge on drilldown and drill thru reports with Hyperion Essbase application.
• Also worked as backup resource for Hyperion Essbase administration.
• Have worked on Oracle DRM(Data Relation Management) tool to develop hierarchy management process.
• Migrated many SQL Server DTS packages into SSIS and Informatica mappings.
• Since last 3 years also working as SAS 9.3 platform administrator and different SAS tools.
• Have worked on SAS Data Integration Studio 5.x for Commercial project.
• Have worked on SAS Financial Management tool.
• Designed and implementeda close to real time Business Objects reporting dashboard on foreign device utilization by Confidential thus saving around $3M every year.
• Lead legacy migration/conversion projects into Oracleusing Informatica as part of modernization.
• Successfully implemented Car accounting project in Oracle ware house giving users faster & more access to data replacing focus reporting which limited reporting capabilities.
• Worked with DBA’s to develop and test storage strategies and disaster-recovery plan for large database, delivering solution dat guaranteed recovery performance and high availability.
• Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions.
• Managed technical team for production support and maintenance of financial Hyperion Essbase cubes and Essbase financial planning applications.
• Project and team management, part of primary responsibilities to ensure adherence to SLAand prompt resolution of issues.