Paul Manning Email & Phone Number

Atlanta

• Designed multiple systems that replaced manual processes. These systems took disparate files from clients and transformed the data for consumption by multiple integrated systems. The systems reduced the business workforce by 10 resources and reduced customer data integration time by 99%. Every file is processed within an hour of receipt. Build in data quality and traceability by including logging and auditing as part of the system. (Penthao and MoveIt)• Managed a team of 5 offshore data engineers and collaborated with project and program management on project priorities, timelines, estimations and requirements. • Worked as a change agent directly with CTO and Senior Leadership Team on system design and data analysis to solve for new data regulations and contract requirements (CPRA, CCRA, Home Depot and State of Georgia).• Created AWS pipelines using Airflow, Kafka, Elastic Search, Pyspark, Greenplum, and S3 to maintain data warehouse.• Established and Maintained Pentaho as the company standard ETL platform supporting 10,000 running jobs daily. With 99.9% availability. Responsible for all planning and testing of platform upgrades and patches.• Established and Maintained MoveIt as the company standard File Exchange platform supporting internal and external automated file movement (90,000 files/day). Responsible for all planning and testing of platform upgrades and patches.• Created coding standards, system integration patterns, reusable objects to increase developer velocity and improve customer integration experience.

• Architected, built, and executed ETLs to update car dealer site inventory with data from third party sites. This allowed car dealers to include Discounts, Miles Per Gallon and average cost to operate for the vehicles in their inventory automatically.• Mentored 6 developers, enforced standards and best practices through design and code reviews.• Developed ETL code to parse clickstream for analysis and reports for a new product.• Performed data analysis to identify issues. Architected and built ETL code for the issues.

Provide Informatica consulting Services

Lead a team of employee, contractor and off-shore resources that perform ETL design and development task. Responsible for all ETL work. Complete resource assignments. Approve weekly Clarity Timesheets. Track and Manage production issues until resolved. Review all ETL designs. Perform Code review on all ETL code. Reduced the cycle run time by 4 hours. Manage the Informatica Upgrade project. Create and enforce Informatica Development Standards. Create and enforce ETL Development Standards. Enforce Scripting Development Standards. Enforce PL/SQL Development Standards. Create and maintain the ETL trouble ticket process. Member of the Production Support rotation team. Create and maintain time-off schedule for ETL team. Responsible for reviewing and recommending new tools. Work with the Internal Audit Team to verify that the ETL team is compliant.

Responsible for entire data warehouse estimation process. Responsible for demand forecasts. Responsible for all designs, data models, and data dictionaries that are produced by the architecture team. Responsible for accepting requirements from the analyst group. Responsible for code review for each project. Responsible for standards, procedures and processes for the entire development life cycle of a project. Responsible for review of new software and software versions. Also responsible for incorporating the new features into our standards and processes. Responsible for running hardware and software upgrades. Responsible for making sure that the existing hardware and software supports future needs. With the majority of our development team being offshore I have gone to India to perform knowledge transfer. One of my roles is also defect management, I make sure that what was labeled a defect was really a defect and scheduled the defect into future releases.

Develop architecture for Enterprise Data Warehouse and Data Marts using Erwin/Model Mart. Develop Informatica mappings to move data from Source systems and populate the Enterprise Data Warehouse. Develop Informatica mappings to move data from Enterprise Data Warehouse to Data Marts. Create data feeds from Enterprise Data Warehouse and Data Marts. Informatica mappings include Sources and Targets of following types: Sybase, Oracle, XML, and flat files. Write documentation to support the mappings and the data feeds. Write Korn Shell scripts to move flat files to loading/pickup area via ftp, secure FTP, and Secure Copy. Architect and create reports using Microstrategy. Create Templates for Data Warehouse Documentation. Train new developers in Informatica, ERWIN, and Star Methodology. Create project estimates based upon the Accenture Estimate Model. Provide production support on an as needed basis. Train power users and managers so they understand the data they are reporting.

Wrote application software in PowerBuilder. Wrote PowerBuilder services to be used by all applications. Responsible for keeping corporate layer of the PFC up to date with the current version of PowerBuilder. Tested all applications with new versions of PowerBuilder when they were released. Wrote user and developer documentation. Provided user support when needed.

Wrote application software in PowerBuilder. Supported all internal software and hardware for 50 users. Performed Novell, Unix, HP-UX, Windows NT system administration. Performed daily backups for 2 Novell servers, 2 Unix servers and 1 NT server.

Provide first line user support for all general mainframe questions (TSO/ISPF, ROSCOE, and JCL). Provide support for all platforms and versions of SAS. Provide CDC users with technical information in support of mainframe and PC applications. Prepare statistical reports, product materials and presentations as applicable for the CDC. Convene technical and/or liaison meetings with CDC contact or designated users on a periodic or applicable basis. Assist with the development of user documentation.

Bs, Management Information Systems

Education record