Don R. Hyppolite

**Ex-contractor of American Electric Power for their ETL Informatica PowerCenter project**

**17 years of Maryland-region clients’ experience**

Summary of Experience and Qualifications

oSeasoned Informatica ETL Developer with 15 years’ experience in overall IT which includes 6 years of focus in ETL, Informatica PowerCenter, design, development, optimization, and support. Proficient in ETL best practices including error handling, log monitoring, data reconciliation, audit, and job scheduling. Hands-on in SQL, Unix shell scripts, Snowflake, data modeling, migration, and deployment of Informatica workflow, Informatica IICS, Informatica DEI, EDC 10.2.1/10.4.1, Geographical Information Systems (GIS), ArcGIS Enterprise, ArcGIS 10.x, ArcPro, FME, Python, Survey 123, Field Maps, Operations Dashboards, GPS/GNSS/Galigeo

Highlights

oSuccessfully completed 10+ ETL Informatica (PowerCenter) projects

oExpert in using Informatica PowerCenter for designing, developing, optimizing, supporting ETL mappings, mapplets, workflows, and worklets.

oExpertise in data modeling principles and data warehousing concepts

oManaged encode, test, debug, migration and deployment of Informatica workflow.

oHands-on in Shell script running workflows in Unix environment.

oProficient in extracting data from Oracle and SQL Server

oSnowflake

oADD Hint to SAP application.

oIICS Architect

oGeographical Information Systems (GIS)

oArcGIS Enterprise, ArcGIS 10.x, ArcPro, FME, Python, Survey 123, Field Maps, Operations Dashboards, GPS/GNSS

Previous Experience

Total Energy Aug 2023-Jan 2024

GIS Manager/Practice Lead for various organizations. Assisted companies in developing and maximizing their GIS footprint and investments.

Led numerous efforts in the design and development of solutions using spatial technologies such as Esri and AutoCAD

Implemented mobile and web-based geospatial solutions for engineering, field operations, business development and other corporate functions of organizations.

Built Consulting, Land Management, Operations, and technical services GIS teams to service the spatial mapping and analysis needs of various clients/stakeholders.

Established group processes and procedures to streamline work and enhance quality for multi-functional teams in the Upstream Oil and Gas industry.

Staffing manager chartered with establishing career paths, developing performance metrics, aligning staff/teams with business strategy, and ensuring staff utilizations targets were met.

Managed budgets (labor, software, hardware, vendors, etc.) for Technical Services and Land Management departments within client organizations.

Specialist in devising strategies for data migration, extraction, transformation & loading from legacy systems to new and/or updated spatial systems of record.

Identified new business opportunities as they relate to facility and pipeline data management efforts, preparing proposals, negotiating price/terms, managing client expectations.

Performed needs assessments with business units (ROW, EHS, Operations, BD, PM, etc..) to discern spatial data management needs and how best to integrate with the greater IT landscape.

Coordinated with IT organizations in large and medium sized midstream and upstream energy companies to define GIS processes and data workflows to satisfy regulatory compliance requirements.

Senior GIS Consultant responsible for initiating, planning, executing, monitoring, and delivering on a variety of GIS-based projects and analysis.

Walt Disney March 2023-Aug 2023

Create IICS connections using various cloud connectors in Informatica IICS Administrator

Installed and configured Windows Secure Agent register with IICS org.

Performed Loads into Snowflake instances using Snowflake connector in Informatica IICS for a separate project to support data analytics and insight use case.

Developed Mass Ingestion task to ingest large datasets from on-prem to Snowflake.

Build API pipeline form Interos and Thompson Reuter to Snowflake Cloud

Worked as team leader with the offshore team.

Experience integrating data to/from On-premises database and cloud-based database solution using informatica intelligent cloud service.

Worked extensively with database Mass Ingestion, files Ingestion, Data Migration, Data Cleansing, Extraction, Transformation and loading of data from Multiple Sources to Data warehouse.

Demonstrated ability in defining project goals and objectives, prioritizing task, developing project plans, and providing framework to effective communication.

Possess experience in working on concurrent projects in very demanding and high-pressure situations.

Participated in user meetings, gathered business requirements & specifications for the data warehouse design.

Current Experience

Oldcastle Building Envelop Sept 2022-Feb2023

Create IICS connections using various cloud connectors in IICS Administrator

Installed and configured Windows Secure Agent register with IICS org.

Performed Loads into Snowflake instances using Snowflake connector in IICS for a separate project to support data analytics and insight use case.

Developed Mass Ingestion task to ingest large datasets from on-prem to Snowflake.

Worked as team leader with the offshore team.

Experience integrating data to/from On-premises database and cloud-based database solution using informatica intelligent cloud service.

Experience working with cloud-based database solution including Snowflake, Surpass and Epicor

Worked extensively with database Mass Ingestion, files Ingestion, Data Migration, Data Cleansing, Extraction, Transformation and loading of data from Multiple Sources to Data warehouse.

Working with different informatica performance tuning issues like sources, target, mappings and session optimization issues and fine-tuned

Experience in creating ETL design Documents, strong experience in complex SQL packages functions, cursors, indexes, views, and materialized views.

Demonstrated ability in defining project goals and objectives, prioritizing task, developing project plans and providing framework to effective communication.

Posses experience in working on concurrent projects in very demanding and high-pressure situations.

Entergy March 2020- Jan 2022

oSupported ETL / data warehouse production, development, error handling, log monitoring, data reconciliation, audit, performance testing, and job scheduling in QA.

oWorked with data modeling principles, data warehousing concepts, and operational data staging environments.

oInvolved in data modeling and data analysis.

oResponsible for designing and creating mappings to extract data from numerous sources (Oracle/SQL Server DB’s/PostgreSQL/flat file loads) to stage in data warehouse for reporting.

oCreated new mapping designs using assorted tools in Informatica Designer, including Source analyzer, mapping designer, warehouse designer, and mapplet designer.

oInvolved in managing encodes, tests, and debugs.

oParticipated in user meetings, gathered business requirements & specifications for the data warehouse design.

oImplemented slowly changing dimension methodology for accessing the full history of accounts.

oEngaged in weekly status meetings, coordinated internal, and external reviews, as well as formal walk through among various teams.

oHave configured the Informatica BDM 10.2.1/10.4.1 and integrated with Cloudera Hadoop Frameworks.

oMonitor and troubleshoot daily production jobs and jobs fails.

oCoordinate with Various another team to resolve production.

oSAP Hana connection and hint to the SAP application programs.

oCreated customized BDM mappings/workflows for incremental using Informatica Developer and deploy them as part of an application on Data Integration service for the native execution or push down using the Blake or Spark execution engines.

oUnderstand the Integration of third-party schedulers like Autosys which will use the same command line options to call any Informatica jobs. Wrote a common shell which will take the Domain, repository, Integration service, user credentials, Folder name and workflow as parameters to run the jobs via Informatica command line pmcmd.

o

Previous Experience

Remarkable Technology Group (multiple clients) Aug 15 – March 20

Senior Informatica ETL Developer

Maryland and other client locations

oClients: American Electric Power, Cigna, Express scripts, Securian Financial, Comerica, and more

oDesigned, developed, and tested ETL mappings, mapplets, workflows, worklets using Informatica PowerCenter

oPerformed ETL development, testing, implementation, and support of integration solution.

oSupported ETL / data warehouse production, development, error handling, log monitoring, data reconciliation, audit, performance testing, and job scheduling in QA.

oWorked with data modeling principles, data warehousing concepts, and operational data staging environments.

oInvolved in data modeling and data analysis.

oOptimized performance tuning at source, target, mapping, and session level

oExtracted data from Oracle & SQL Server and used Teradata for data warehousing.

oWrote Shell script running workflows in Unix environment.

oResponsible for designing and creating mappings to extract data from numerous sources (Oracle/SQL Server DB’s/PostgreSQL/flat file loads) to stage in data warehouse for reporting.

oCreated new mapping designs using assorted tools in Informatica Designer, including Source analyzer, mapping designer, warehouse designer, and mapplet designer.

oInvolved in managing encodes, tests, and debugs.

oInstalled operating programs and procedures in coordination with computer operations/user departments/migration/deployment of Informatica workflow.

oDeveloped mappings using needed transformations in Informatica tool according to technical specifications.

oCreated worklets, workflow, and tasks to schedule the loads at demanded frequency using Workflow Manager

oCreated composite mappings that involved execution of business logic to pack data into staging area.

oResponsible for translating the user inputs into ETL design docs.

oAnalyzed existing or proposed systems, devises computer programs, systems, and related procedures to process data.

oPrepared charts & diagrams to assist in problem analysis and submits recommendations for solution.

oResponsible for program specifications, diagrams and developing coding logic flowcharts.

oWorked with Metadata Manager and business glossary to match technical data to business terms.

oDocumented programming problems and resolutions for future reference

oInvolved in all stages of the SDLC process including requirement gathering, design, development, test, production, user training, and support for production environment.

oDeveloped utile email correspondence in Workflow Manager for process exception handling.

oParticipated in user meetings, gathered business requirements & specifications for the data warehouse design.

oImplemented slowly changing dimension methodology for accessing the full history of accounts.

oEngaged in weekly status meetings, coordinated internal, and external reviews, as well as formal walk through among various teams.

oHave configured the Informatica BDM/BDQ/EIC/IDL 10.2.1/10.4.1 and integrated with Cloudera Hadoop Frameworks.

oCreated customized BDM mappings/workflows for incremental using Informatica Developer and deploy them as part of an application on Data Integration service for the native execution or push down using the Blake or Spark execution engines.

oAssist developers in debugging since now the logs are scattered on BDM between the Native servers and on the Yarn - Spark and Blaze have different set of logs in different directories configured which is a pre-requisite for Informatica Big Data Products.

oUnderstand the Integration of Third-party schedulers like Autosys which will use the same command line options to call any Informatica jobs. Wrote a common shell which will take the Domain, repository, Integration service, user credentials, Folder name and workflow as parameters to run the jobs via Informatica command line pmcmd.

o

Previous Experience

Giant Food Group Corp (10+ years)

ETL Informatica Developer / IT Inventory Control Manager

Jessup, MD

oDesigned, developed, and tested ETL mappings, mapplets, workflows, worklets using Informatica PowerCenter

oResponsible for designing ETL solution to automate loads based on client requirement.

oDeveloped Informatica sessions using Informatica Workflow Manager to run PowerCenter mapping/mapplets.

oResponsible for building data warehouse staging and target tables for data loads.

oEstablished procedures and controls to assure the accuracy of over ten million dollars of inventory daily.

oPrepared and monitored the operational budgets.

oSupervised staff of more than 200 people of diverse backgrounds.

oFormulated/executed pioneering order supply and tracking inventory control procedure.

oProvided necessary actions for recruitment, training, and evaluation of newly appointed personnel.

oEnsured essential inventory, accounting, purchasing rules/regulations were followed, and provided as well as monthly analytical reports.

System Experience

oInformatica PowerCenter 8.1, 9.0, 10.4.1/Informatica DEI, EDC/Access/Word/Excel/PowerPoint/MS Project/Outlook/Data Management/SQL Script Generation/SQL Querying/Structured Query Language (SQL)/Oracle/TOAD/MySQL/Windows 7/Windows 8/ETL/Oracle/Snowflake /ServiceNow EBS/Maximo/Mainframe/PL-SQL/EDI/Unix/Python/Hive/BDM/SAP HANA/ Informatica IICS/ARCGIS Esri Application/Galigeo

Education

Bowie State University, Bowie, MD

Bachelor of Mathematics

2005

References

(Upon request)

Contact this candidate