Sign in

Engineer Project

New Delhi, Delhi, India
April 10, 2018

Contact this candidate


Ashfaq Shaik



Over 10 years of extensive experience in requirements gathering and analysis, design, development, testing and validation in Information Systems, data bases, data warehousing (DW), EDW and Business intelligence(BI) space.

Over 4 years of experience as Tech Key leading small to medium teams on Data Warehouse/Data Migration/Data Integration projects with Offshore/Onsite model.

Experience in working with Agile/Waterfall project process.

Extensive experience in Full Life Cycle Implementation of Data warehouses i.e. analysis, design, development, support and implementation of Data Mart / Data Warehouse applications using Informatica PowerCenter, Power Exchange, Informatica Cloud, Informatica Data Quality(IDQ) like Designer, Workflow manager, Workflow monitor, Repository manager, Data Maps, Mapplets, Analyst tool, Developer tool, Scheduling. knowledge on Informatica Master Data Management(MDM)).

Experience in implementation of End-to-End Projects Involving Data Migration from legacy systems and Data Integrations to the Ecommerce application.

Involved in all phases of SDLC process including requirement gathering, design, development, testing,

Deployment & support activities.

Experience with Client handling on Business requirements, UAT and Post Go-Live support.

Experience in implementation of end to end data quality project using Informatica Data Quality (IDQ) integrating with Powercenter.

Done table profiling & join profiling to identify data anomalies, create rules, rule specs and generated reference tables & content files out of profile results.

Worked on Data Profiling, Data Cleansing, Data Standardization, Match Merge in IDQ tool.

Created complex mappings for data load, reusable rules & mapplets for data Cleansing and Standardization data in IDQ and IDQ workflows and applications to run them.

Experience in working on Data Analyst and Developer in IDQ.

Experience leading and managing small and medium sized Data warehousing and Business intelligence engagements and mentoring junior or associate consultants in both onshore and offshore model.

Experience creating ETL mappings, mapplets, sessions, workflows, Performance, error handling, supporting Production system and scheduling ETL in Informatica to Integrate various data sources like Oracle, DB2, SQL Server, Flat Files, XML files.

Strong experience in implementing manual change data capture and delete detection functionality in data warehouse.

Strong experience in Informatica administration like installations, configurations, Folder, Users, Migrations, Deployments on Informatica PowerCenter (9.x/8.x/7.x) in windows and Linux environment.

Experience in Scheduling Informatica jobs in CA Scheduling tool.

Strong experience in Business Intelligence technologies like Business Objects Web Intelligence, Desktop Intelligence, Universe design and Qlikview Reporting.

Experience in Dimensional Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling using Erwin.

Strong Data cleansing, Data quality, Data archiving and Data/Code Migration experience using SQL and Informatica.

Extensive working experience in RDBMS like Oracle 11g/10g/9i, MS-SQL Server, SQL, PL/SQL.

Good experience in UNIX writing shell scripts, performance tuning on database and Job Scheduling.

Skilled in Unit Test, System Integration Test and UAT (preparing test plan, test cases, validation, etc.)

Experience in preparing Project documents like Mapping document (source to target), Technical Specifications, Requirements documentation, Installation documents, Test/QA documentation and migrations documents.

Ability to meet deadlines and handle pressure coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.


Domains: Insurance, Supply chain Management, Telecom

RDBMS: Netezza, Oracle 11g/10g/9i/8i, SQL Server 2005/2000, Mainframe DB2 UDB 8.1, AS400, Sybase

File Type: Flat files, XML

Version Control: GitHub, IBM Urban Code Deployment, CA Harvest.

ETL Tools: Informatica PowerCenter 10.2/9.6.1/8.6.1/7.1, Power Exchange 9.6.1, Informatica Developer tool 9.6, Informatica Cloud

DB Tools: TOAD, SQL * PLUS, SQL * LOADER, AQT, Import and Export, Oracle SQL Developer.

Scheduling Tools: CA Automation tool

Reporting Tools: SAP Business Objects Enterprise XI, Desktop Intelligence, Web Intelligence, Universe Designer, Qlikview

Dimensional Data Modeling / Tools: Star Schema Modeling, Snow-Flake Schema Modeling, Logical and Physical Data Modeling, Erwin

ERP: SAP, Oracle EBS

Languages: PL/SQL, SQL, UNIX Shell Scripting

Operating Systems: Windows NT/95/2000/XP/2003/2007, Unix-AIX, Linux

Other Tools/Software: HP QC ALM 12.2, Microsoft Office 2010 (Excel, PowerPoint), WINSCP, PUTTY, FileZilla, FTP, SFTP, SCP, Telnet, Oracle Developer, Service Now, Microsoft Vision.

Trainings Attended

Training in PL\SQL, Oracle.

Certified CCNA.

Certification training in Bigdata Hadoop from Edureka.

Informatica MDM tool training.

Qlikview Reporting Tool training.

CA Automation tool


Bachelor’s Engineering Degree in Computer Science

Client: Nationwide Insurance, Columbus, OH.

Nov 2016 – Current

Senior Informatica Developer/ Project Tech key

Domain: Insurance

Area: Data Warehouse/ Web application.

Platform: Linux 3.10.0(OS & File Storage)

Systems: IBM Netezza, Oracle Database 12c Enterprise Edition Release, XML files

Tools: Informatica Power Center 9.6.1/10.2.0, Oracle Toad 11.6, AQT V10.0, HP QC ALM 12.2

Version Tools: GitHub, IBM UCD, CA Harvest, IBM words request, CA scheduling Tool.

Project Methodology: Agile

Project Description:

RADS ETL Build Team (Reporting & Data Service) is a critical ETL team for Nationwide Finance IT which involves with handling multiple projects for Nationwide Finance providing data for reporting services and Web Applications.


The RADS Staging processing of ELITE TRANSFORMERS Data Warehouse files and is a tool used by Nationwide Financial Production Assurance (NFAES) to provide continuing support of that infrastructure.

This product outlines the roles of the respective parties and providers used by Nationwide Financial Company and I&O and detail the equipment, configurations and procedures that pertain to the infrastructure housed at the I&O data centers. This project involves with generating monthly and daily XML files for different Agents i.e., Broker Deals, Investment Agents, RIA Agents, Advisory Services, Trust Agents & Self Agents to DPIM system from the source system as AIMS database.


Working as Project Tech key / Sr. Developer for the project delivery involving all SDLC process.

Participated in Design review meetings with Business Analyst, Data Analyst and Architect’s.

Establish and enforce technical standards for deliverable of projects.

Have done SHOW and TELL sessions with Business on the UAT and handled END to END deliverables.

Working with Informatica Powercenter 9.6/10.2 to create XML files from oracle Database using XML generators and different Informatica transformations.

Involved in Code Review for the project.

Involved and Lead the team with Dev, Beta, UAT and Production support process.

Working with GitHub for Version control and RFC process for production deployment in Service Now.

Created multiple Shell scripts for Parameterizing the Informatica job run and Scheduling the job run through CA Scheduling tool.

Created shell scripts for Data Quality checks.

Project 2: Exchange Traded Funds (ETF)/IMG Web & Marketing Nationwide Financial

Nationwide Investment Management Group (IMG) is in the process of launching Exchange Traded Funds (ETF) products; regulatory requirements for ETFs have developed a need for daily data and monthly updates from US bank and Morning Star.


Worked as Project Tech key/Sr. Developer for the project delivery involving all SDLC process.

Participated in Design review meetings with Project Troika team, Business Analyst and Architect’s.

Collaborated with multiple teams within Nationwide in successful deliver of the project.

Establish and enforce technical standards for deliverable of projects.

Worked with Informatica Powercenter 9.6 to load data from XML and Netezza database to cppf oracle Database using XML parsers and different Informatica transformations.

Implemented complex SCD type mappings to perform data load.

Created File Acquisition shell scripts along with Data Quality checks.

Created Informatica Deployment group for handling higher environment movement.

Involved and Lead the team with Dev, Beta, UAT and Production support process.

Worked with GitHub, CA Harvest tool for Version control and RFC process for production deployment in Service Now.

Created and verified multiple Shell scripts for Parameterizing the Informatica job runs and Scheduling the job run through CA Scheduling tool.

Received appreciation from Nationwide CEO for successful launch of the new product and setting Nationwide into new portfolio.


Client: Terex Corporation, Oklahoma City, OK May 2015– Nov 2016

Lead Developer (BI/DW/Data/Business)

Domain: Supply Chain Management

Area: Data Migration, Data Integration, Reporting

Platform: Windows

Systems: Mainframe AS400, Oracle EBS, SQL Server, SAGE Application, QlikView Reporting,

Tools: Informatica Power Center 9.6.1, Power Exchange 9.6, Informatica Cloud, Informatica IDQ 9.6, SQL SERVER 2012, Oracle 11g

Project Methodology: WaterFall

Project Description:

Implementing Inventory Organizations in Oracle EBS for North Bend & Southaven in US and Roosendaal in Netherlands

Data migration using Informatica for data extraction and data transformation; using existing data migration tools for loading into Oracle EBS system. Migration is categorized into two sub divisions; US region and Europe region

Development, Configuration and testing of approximately 31 Interfaces from/to Oracle EBS and other applications

Integrating Oracle EBS with 3rd party systems using Dell Boomi middleware for ‘Real Time’ interfaces and an ETL (Extract-Transform-Load) approach using Informatica for ‘Batch’ interfaces

Batch Integration using Informatica is performed for two systems namely –e-commerce and Winscope

Parts distribution business at locations North Bend (WA), Southaven (MS) and Roosendaal (Netherlands) needs to be brought under Terex’s global trading (TGG) instance of Oracle EBS 11i.

Implementation of data load from Terex Management System to BASWARE Application.


Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, and development team members, subject-matter experts, Business Analyst and stakeholders to understand the business and data requirements.

Created mock-ups, prototypes, wireframes, technical design documents, business (user) requirements documents, test documents, etc. to deliver DW/BI solutions.

Working as Lead Developer at onsite handling 6 developers with Onsite-Offshore Model

Develop data model design for extracting Business Data from Legacy systems and loading to ERP system

Design Data Integrations & Data Migration from Oracle ERP systems to Terex Ecommerce Sites & Winscope Planning application using Informatica Powcenter, Informatica Cloud, Power Exchange & Informatica IDQ tool. Also, involved to formulate Business Reports using QlikView Reporting tool.

Data profiling and extraction of insights from data, using exact matching, deduplication, fuzzy logic, and other techniques to review data for accuracy.

Integrating IDQ mapping with Powercenter for Data Migration project involving Migration of data and cleansing.

Develop solution architecture for ETL and Migration & Integrations

Manage current and future needs in data design and content.

Resolve semantic discrepancies in data definitions that arise among multiple sources and projects

Gain consensus among users on common business data definitions

Determine the optimal approach for obtaining data from diverse source system platforms and moving it

Establish and enforce technical standards for deliverables of projects

Evaluate and recommend tools for project improvement.

Scheduling of Jobs from CA Automation Tool.

End-to-End implementation of project for Terex Critical Business segment AWP within tight timelines, receiving great appreciation from the client for Integrating & Delivering their complex and challenging Business needs thus helping L&T to get new projects and growing presence.

Client: INGRAM MICRO, Irvine, CA April 2012 to May 2015

Role: Sr. ETL Developer & Offshore Lead

Domain: Supply Chain Management

Area: DWH, Data Marts, Reporting

Platform: UNIX

Systems: Mainframe DB2, Flat Files, Sybase, Netazza, XML files

Tools: Informatica Power Center, Unix Shell Scripts, SQL SERVER 2008, Toad, SAP BO

Project Description:

The client, Ingram Micro, is a US Fortune 500 company and the world’s largest Technology distributor providing sales, marketing and logistics services.

Project activities include 24/7 Production support, Identifying the bugs and implementing fixes in production.

Developing scripts and jobs to automate the system process and Integration of third party APIs

Planning and Estimation of new enhancements for the existing applications

oDetailed Job Duties: -

To provide 24 x 7 technical supports for problems and change requests reported in adherence to Service Level Agreement.

Working as Lead in the project with 9 resources which support production, Enhancement and Migration activities

Monitoring, assigning day-to-day activities of project

Handling the incidents and user queries as defined in Incident Management process in adherence to SLA.

Involved in Senior Review meetings on Project deliverables and Estimations.

As part of Lead for Enhancement team for Ingram, involved in gathering information and analyze business requirements to prepare work estimation, designing and coding the new SE projects.

Worked on Informatica Designer tools like Source Analyzer, Target Designer, Mapping Designer and Mapplet Designer

Conducted weekly status calls with business users, SME’s, Data Analysts and DMO and with other development teams to understand their requirements about routine maintenance, downtime, code migrations, enhancements, change requests, etc.

Managed and led the offshore team & onshore team to deliver DW/ETL business solutions within the agreed SLA's.

Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, development team members, subject-matter experts and stakeholders to communicate their perspectives with each other, resolve any issues.

Prepared and managed time/cost/resource estimates needed for projects (SOW / WO).

Defined scope, goals and deliverables (that support business goals) by collaborating with senior management and stakeholders.

Effectively communicated project expectations to team members and stakeholders in a timely and clear fashion.

Delegated tasks and responsibilities, led, managed and mentored a team of 6 at offshore.

Designed/architected ETL solutions (using ETL tools and SQL) to create and support business metrics.

Performed Data analysis and Data Profiling using SQL queries and tools before and after designing ETL solutions.

Assigned and tracked incidents (in HPSM) to Analysts, Developers, DBA’s, etc. to deliver and deploy DW solutions

Had written shell Scripts for Processing Jobs.

Had been involved with BO reports.

To coordinate with client and offshore team for effective execution of production support activities.

Client: AT&T Mar 2011 to Apr 2012

Role: Technical Associate(ETL)

Domain: Telecom

Area: DWH, Data Marts

Project Description:

Build and support of DWH for wireless products for AT&T

Job Duties:

•Developed Informatica mappings, mapplets, sessions, workflows and worklets to load data from sources using transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update, Sorter, Lookup, Aggregator, Joiner, SQL, etc.

•Implemented Type 1, Type 2 and Type 3 slowly changing dimensions (SCD), parameter files using Informatica Powercenter.

•Performed source system data (Oracle EBS, SQL Server) profiling to cleanse the data before loading in the ODS and DM.

•Performed testing and validation of the BI/ETL solutions using test strategy, test plan, test cases (negative, positive), test results.

•Involved in the Data Warehouse Data Modeling based on the client requirement.

•Created basic reports and supported changes to OBIEE data models by making appropriate changes to.

•Performed Informatica repository trouble shooting, creation, Backup/ Restore, Informatica repository health and 24/7 ETL Job support.

•Worked extensively on resolving support tickets, defects, bugs, data issues, job failures, etc. of the DW/BI solution.

Client: BRITISH TELECOM Mar 2010 to Feb 2011

Role: Technical Associate

Domain: Telecom

Project Description:

Data Analysis of P&G S3 Source System.

Job Duties:

•Understand the business requirements and source data.

•Created mappings with heterogeneous sources like flat files and Oracle databases and modeled target tables in Oracle DWH as required.

•Extensively worked on Informatica Designer tools like Source Analyzer, Target Designer, Mapping Designer and Mapplet Designer.

•Used the transformations like Source qualifier, Router, Filter, Sequence Generators and Expression as per the Business requirement to create the mappings.

•Tuned the Informatica mappings and the database SQL for better performance of the application.

•Performed Unit Testing of the mappings/sessions/workflows.

•Developed mapping to load data in slowly changing dimensions Update Else Insert and updated the flag columns whenever a record is inserted or updated to identify the current record.

Contact this candidate