Informatica Cbse
Resume:
Shoaib Hasan
**************@*****.***
Snr. Informatica Developer, Data Architect, ETL Architect
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