Shoaib Hasan

adl2gu@r.postjobfree.com

Snr. Informatica Developer, Data Architect, ETL Architect

+1-704-***-****

LinkedInPROFILE:- https://www.linkedin.com/in/shoaib-hasan-aaa0b420/

Summary

Technically astute Lead Engineer with 12.11 years of experience across Power/Utilities sector, Banking, Insurance & Telecommunications. Senior Informatica developer employed with Randstad Technologies; accented with the latest trends and techniques of the field & determined to carve a successful career in the field of Data Analysis.

Astute knowledge in designing the Database for process data maintaining the normal forms.

Worked as ETL architect to develop the new ETL’s to follow the best practices for processing data in optimal way.

Worked as Data architect to develop new Enterprise Data Warehouse from scratch.

Technical expertise on Informatica Power Centre (8.x, 9.x, 10.x), Informatica Power Exchange and Informatica Data Quality (IDQ), Talend Open Studio.

Certified Talend Data Integration v7 Developer.

Technical expertise on building Enterprise Data warehouse (EDW) from scratch.

Good exposure to Informatica administrative tasks like ETL Migrations.

Excellent knowledge and understanding of databases like MS-SQL and Oracle.

Sound Knowledge in client-side scripting like JavaScript, Unix Shell Scripting, Perl Scripting.

Exposure to Scheduling tools like ESP Cybermation, Autosys, Informatica Workflow Scheduler.

Familiar with integration of Informatica with IBM MQ for data read and write.

Hands on experience in Unit testing, Integration testing, Functional testing, UAT and Dress Rehearsal.

Knowledge of functional areas with expertise in Project Management Life Cycle for various platforms including Project Scoping, Requirement Analysis & Technical Specifications, Effort Estimates, Risk Management, Resource Management.

Excellent knowledge of waterfall and Agile methodologies. ICAgile certified with Accenture.

Knowledge of Scrum Processes in Agile methodologies.

Excellent problem solving, troubleshooting and analytic capabilities.

Adept at client interaction and leading teams while embracing accountability and delivering high quality results.

Experience Summary

Mitchell Martin Inc Feb 2021 – Present

Randstad Technologies April 2019 – Jan 2021

Compunnel Software Group Inc April 2018 – April 2019

Accenture Services Ltd May 2008 – April 2018

Educational Qualification

Bachelor Of Technology, College Of Technology, G.B.P.U.A.T. Pantnagar 2003 - 2007

Technical Skills

Environment Exposure : Linux, Unix, Microsoft Windows 7/Server

Tools : Informatica Power Center (8.x, 9.x, 10.x), Informatica Power Exchange, Talend Open Studio, SSMS, Toad, Toad for SQL Server, SOAP UI, Web Services, WINSCP, Bitbucket, Putty

Script & Frameworks : JavaScript, Perl Script, Shell Script

Database : Oracle, MS-SQL, Teradata

Automation Tools : Autosys, CA Workload Automation, Informatica workflow Scheduler

Methodologies : Waterfall and Agile

Professional Experience

Project #1 : Integration and HUB Analytics

Client : Bank of America

Duration : Feb 2021 – Present

Environment : Informatica Power Centre, Oracle, Teradata, Bitbucket, Autosys, JIRA, Ansible, Unix Scripting.

Role : Senior Informatica Developer

Team Size : 3

The Bank of America Corporation is an American multinational investment bank and financial services holding company headquartered in Charlotte, North Carolina.

It is the second largest banking institution in the United States, after JPMorgan Chase, and the eighth largest bank in the world. Bank of America is one of the Big Four banking institutions of the United States.[4] It services approximately 10.73% of all American bank deposits.

Project Responsibilities:

• Working as Senior Informatica developer for developing ETL's to transform data from various external System to Bank of America deposits domain.

• Worked on solutions for enhancing the slow running ETL’s by applying multiple performance fixes to ETL’s and tables.

• Meeting with different project stakeholders and providing them update on progress being done including Duke top management.

• Revalidation of estimates and delivery dates as per issues being reported.

• Active interaction and daily status meeting with the onshore/offshore team to provide progress update and work being done.

• Address any data quality issues and gaps in the requirements during the build phase and escalate them towards the resolution.

• Troubleshoot any data quality issues and implement enhancement/bug fixes.

• Assist in providing estimates and ensuring the work-load of team is balanced.

• conduct peer reviews on designs, code to ensure the quality of the deliverable is accurate.

Project #2 : Integration and HUB Analytics

Client : Duke Energy USA

Duration : April 2019 – Dec 2020

Environment : Informatica Power Centre, Informatica Power Exchange

, Maximo 7.6,

SQL Server 2017/2019, IBM MQ's,

CAWA, Perl Scripting, Java Script

Role : EDW ETL Architect/Senior Informatica Developer, Data Architect

Team Size : 6

Duke Energy is the largest electric power holding company in the United States, supplying and delivering energy to approximately 7.2 million in USA. There are multiple legacy applications like IBM Maximo, Logica ARM, MWMS, PASTA,etc., are used to cover and provide entire customized Assets Management Solution.

Project Responsibilities:

• Working as Tech Build Lead and Senior Informatica developer for developing ETL's to transform data from various System to Duke Energy system.

• Worked as ETL architect and Data Architect to develop new Interface and ETL’s.

• Worked on solutions for enhancing the slow running daily DW loads from 12 hours to 5 hours by applying multiple performance fixes to ETL’s and table’s.

• Responsible for all changes for normalizing data between Oracle (Maximo 7.6) to SQL Server for multiple reporting purposes.

• Created Stored procedures and complex functions using PL/SQL to maintain the data integrity and perform repeated functions.

• Meeting with different project stakeholders and providing them update on progress being done including Duke top management.

• Revalidation of estimates and delivery dates as per issues being reported.

• Active interaction and daily status meeting with the onshore/offshore team to provide progress update and work being done.

• Leading the ETL team with complex functional designs in the ETLs.

• Proactively plan for executing mock loads and eliminate any manual interventions during cut-over.

• Address any data quality issues and gaps in the requirements during the build phase and escalate them towards the resolution.

• Troubleshoot any data quality issues and implement enhancement/bug fixes.

• Assist in providing estimates and ensuring the work-load of team is balanced.

• conduct peer reviews on designs, code to ensure the quality of the deliverable is accurate.

• On-boarding of new resources and raising all necessary requests.

• Experienced in scheduling Informatica jobs with proper calendar, job, file dependencies for end to end EDW refreshes.

Project #3 : Datastage to Talend Migration

Client : Virginia Tech USA

Duration : Oct 2018 – April 2019

Environment: Datastage, Talend 6.4 Open Studio, Oracle, Shell Script, GIT, Bitbucket

Role: Senior Informatica Developer

Team Size: 4

Work on building and migrating code from Informatica Power Centre to Talend to process daily data load from Oracle based front end to VT data warehouse. Also enhancing the process to fix the performance issues along with creating/Testing and maintaining new ETL architecture.

Responsibilities:

• Review, tests and correct program errors; Migrating ETL code written in Informatica Power Centre to Talend for process data between multiple VT source systems to Data Warehouse.

• Incorporated knowledge of Informatica Power Centre, Talend, AWS S3 boxes, Oracle, Shell Script.

• Lead ETL Developer for developing ETL's to transform data and functionalities from

multiple vendor formats to Client data format.

• Created complex mappings using Talend pallets to process data from flat files, databases.

• Meeting with different project stakeholders and providing them update on progress being done.

• Revalidation of estimates and delivery dates as per issues being reported. Active interaction and daily status meeting with the team to provide progress update and work being done.

Project #4 : INTAKE

Client : Pacific Life USA

Duration : April 2018 – Sep 2018

Environment: Informatica PowerCenter 10.0.1, Oracle, SOAP UI, Web Services, WINSCP, Putty

Role: Senior Informatica Developer

Team Size: 4

Work on capturing details from multiple vendors/agents using ACORD – XML standards and other data formats and convert it to Pacific Life ACORD format to capture the new customer details, Insurance Agent validation, generating insurance policies and sending e-sign documents to end customers on successful acceptance of all criteria.

Responsibilities:

• Review, tests and correct program errors; Modifies database program to increase processing performance using Oracle and other related technologies. Involved in Data Modeling applications using ETL tools Informatica Powercentre, SOAP UI, Web Services, etc.

• Lead Informatica Developer for extensively working on huge ACORD standard XML’s to make

automated interfaces between new Vendor (agents) and Pacific Life.

• Incorporated knowledge of Informatica Power Centre, SOAP UI, Web Services, Oracle, SQL Server,

Putty, WINSCP.

• Lead Informatica Developer for developing ETL's to transform data and functionalities from

multiple vendor formats to Client data format.

• Created complex mappings using mapplets, Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup, Look-ups with persistent cache, SQL Update and Router transformations, user defined functions.

• Meeting with different project stakeholders and providing them update on progress being done including parent company and client. Updating the weekly progress tracker and providing ETL offload metrics to the client.

• Revalidation of estimates and delivery dates as per issues being reported. Active interaction and daily status meeting with the onshore/offshore team to provide progress update and work being done.

• Active interaction with the various stake holders, regular meetings with client.

Project #5 : ENABLE

Client : Duke Energy USA

Duration : March 2016 – April 2018

Environment : Informatica Power Centre, Informatica Power Exchange

, Informatica Data Quality (IDQ), Maximo 7.6,

SQL Server 2012/2016, IBM MQ's,

ESP Cybermation, Perl Scripting, Java Script

Role : Tech Build Lead And EDW ETL Architect/Senior Informatica Developer

Team Size : 15

Duke Energy is the largest electric power holding company in the United States, supplying and delivering energy to approximately 7.2 million in USA. There are multiple legacy applications like IBM Maximo, Logica ARM, MWMS, PASTA,etc., are used to cover and provide entire customized Assets Management Solution.

As Duke Energy merged with Progress Energy, ENABLE project was started to merge all Transmission and Distribution data between Duke and Progress to consolidate and use the finalized EAM system (Maximo).

Project Responsibilities:

• Worked as Tech Build Lead for developing ETL's to transform data from Progress System to Duke Energy system.

• Design and Implement ETLs in building new data warehouse for Duke Energy from scratch. Also working as ETL Architecture for developing the ETL's. DW uses Star Schema to store data.

• Worked as Data Architect to load data to EDW tables with maintaining all data Integrity.

• Working as Tech Build Lead for developing ETL's to Integrate Maximo 7.6 to multiple External Systems like LOGICA, Duke MyTime, PASTA and multiple towers across Duke Energy.

• Responsible for all changes for normalizing data between Oracle (Maximo 7.6) to SQL Server for multiple reporting purposes.

• Lead ETL development team to implement enhancements and fixes to ODS and data mart.

• Created complex mappings using mapplets, Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup, Look-ups with persistent cache, SQLUpdate and Router transformations, user defined functions.

• Created Stored procedures and complex functions using PL/SQL to maintain the data integrity and perform repeated functions.

• Meeting with different project stakeholders and providing them update on progress being done including Accenture LLC and Duke top management.

• Updating the weekly progress tracker and providing ETL offload metrics to the client.

• Revalidation of estimates and delivery dates as per issues being reported.

• Active interaction and daily status meeting with the onshore/offshore team to provide progress update and work being done.

• Design and build reusable components that can be used in the framework of the ETL architecture.

• Leading the ETL team with complex functional designs in the ETLs.

• SME of Power Exchange Change Data Capture process to integrate data from source systems.

• Performance tune of long running ETL mappings and implement improvements with tuning fixes.

• Proactively plan for executing mock loads and eliminate any manual interventions during cut-over.

• Address any data quality issues and gaps in the requirements during the build phase and escalate them towards the resolution.

• Troubleshoot any data quality issues and implement enhancement/bug fixes.

• Assist in providing estimates and ensuring the work-load of team is balanced.

• conduct peer reviews on designs, code to ensure the quality of the deliverable is accurate.

• On-boarding of new resources and raising all necessary requests.

• Experienced in scheduling Informatica jobs with proper calendar, job, file dependencies for end to end EDW refreshes.

Project #6 : PowerExchange Informatica CDC

Client : Duke Energy USA

Duration : Nov2015 – March 2016

Environment: Informatica PowerCenter 9.6.1, Informatica Power Exchange 9.6, Oracle, MS SQL Server 2012,

ESP Cybermation, Perl Scripting, Java Script

Role: Tech Build Lead and Senior Informatica Developer

Team Size: 6

Project #7 : Generation and Fleet Data Consolidation And IDQ Implementation

Client : Duke Energy USA

Duration : Jan 2015 – Nov 2015

Environment : Informatica Powercenter 9.1, IDQ, Oracle, SQL Server 2012, ESP Cybermation,

Perl Scripting, Java Script

Role : Tech Build Lead

Team Size : 7

Project #8 : Power Advocate

Client : Duke Energy USA

Duration : Oct 2014 – Jan 2015

Environment : Informatica PowerCenter 8.6, SQL Server 2008/2012, Oracle, ESP Cybermation, Perl Scripting,

Java Script

Role : Team Lead

Team Size: 3

Project #9 : EAM Upgrade and Production Support

Client : Duke Energy USA

Duration : April 2013 – Sept 2014

Environment: Informatica Powercenter 8.6, Flat files, Microsoft SQL Server, XML files, Oracle,

ESP Cybermation, Perl Scripting

Role : Team Lead Production Support/Team Member EAM Upgrade

Team Size: 8

Project #10 : Production Support and CUB (Catch up Backlog)

Client : Duke Energy USA

Duration : Apr 2010 – Mar 2013

Environment: Informatica Powercenter 8x, Flat files, Microsoft SQL Server 2008, XML files, Oracle,

ESP Cybermation, Perl Scripting, Autosys, Unix Shell Scripting, Putty.

Role : Team Member

Team Size: 5

Project #11 : TELSTRA

Client : Telstra Australia

Duration : Aug 2008 – Mar 2010

Environment : Informatica PowerCenter7.x, 8.x, Microsoft SQL Server, Flat Files,,Oracle, Autosys, Unix Shell Scripting, Putty.

Role : Team Member

Team Size : 3

EMPLOYMENT DETAILS

Organization

Designation

Duration

Location

Compunnel Software Group Inc

Software Developer - System Analyst

April 2018 - Present

Lynchburg VA

Accenture LLC

Software Developer - System Analyst

May’ 2008 – April 2018

Chennai/Mumbai/Charlotte (NC)

EDUCATION DETAILS

Program

Institution (Board)

Years

Bachelor of Technology (Computer Science)

College Of Technology, G. B. Pant University of Agriculture and Technology

2003-2007

CBSE (XII)

Adarsh Bal Niketan (CBSE Board)

2002

CBSE (XII)

Adarsh Bal Niketan (CBSE Board)

2000

RECOGNITIONS

Recognized by leadership multiple times for the zeal to deliver quality work and consistent impressive performance.

Guided and coached new joinersby sharing business knowledge and experience thus helping them develop technical and professional skills

Contact this candidate