Chad Johnson Email & Phone Number

Dallas, TX, US

Chicago, IL, US

• Lead data projects and create solutions that involve complex data manipulation to increase efficiency by 30-50%.
• Train team members to use ETL error handling with proper standards to create efficient packages which makes troubleshooting less time consuming.
• Create and maintain customized PowerApps applications that increases business productivity.
• Automate 60+ reports using SSIS and PowerBI.
• Perform 70+ Ad-Hoc reports using SQL and Microsoft Excel.
• Develop 10+ PowerBI reports which allows users to visualize real-time data on demand and also allows users to request additional data as needed.

Baton Rouge, LA, US

• Executed the Informatica upgrade from Informatica 10.4 to 10.5.1 and installed Informatica 10.5.1 Hotfix to new servers.
• Standardized day to day operations which freed 15-20% of time throughout the day to complete other project work.
• Updated the Informatica Developer Guide, the Informatica OSP, the ICEDQ OSP, and created SLA for deployments.
• Headed the operation to implement devised standards for our Production and Non-Production environments to insure security standards and best practices.
• Revitalized monitoring of Informatica systems by initializing alerts to ensure 100% availability for Production Environments.
• Reviewed logs to determine root cause and gather information from other IT areas to prevent downtime and reduce incidents.

Baton Rouge, LA, US

• Led the initiative of moving Biztalk packages to Informatica DIH and Informatica DX.
• Provided documentation on how to use Informatica Scripts for 50+ developers.
• Managed day to day Informatica tasks, 25+ requests on a weekly basis.
• Reviewed ETL design documents and coordinated with developers to maintain correct organizational standards.
• Decreased the technical debt associated to servers and Active Directory groups by 100% by identifying, investigating, and deleting all servers and groups that were not being used.
• Evaluated and diagnosed issues; improved issues by coordinating with appropriate peer teams and escalating to other areas of IT when necessary.

Baton Rouge, LA, US

• Converted 50+ Reports from SAP Crystal Reports to SSRS.
• Created SSRS reports for business users that increased efficiency by 50%.
• Performed installation, configured, administrated, and tuning of software application software (Informatica and SSRS).
• Coordinated and administered 100% of Software Configuration Management (SCM) activities including defect tracking, configuration identification, change management, status accounting, and verification.
• Provided technical support and troubleshooting assistance on software application related issues for 100's of users.
• Ran software builds to track and control changes and analyze potential build problems to reduce incidents.

Baton Rouge, LA, US

• Collaborated with the Integration Architect and Sr. Integration Specialist in refining information architectures and complex data models as well as the modification and implementation of database integration solutions.
• Developed 4 data integration solutions using ETL tools such as SSIS and Informatica PowerCenter.
• Assisted the Integration Architect and Sr. Integration Specialist in analyzing and operationalizing ETL/Data integration requirements and utilizes such requirement plans to create integration solutions.
• Captured and monitored metrics to help ensure adherence to Service Level Agreements (SLA).

Baton Rouge, Louisiana, US

• Fielded incoming help requests from end users via both telephone and e-mail in a courteous manner to 10+ users daily.
• Recorded, tracked, and documented the help desk request problem-solving process, including all successful and unsuccessful decisions made, and actions taken, through to final resolution.
• Performed hands-on fixes at the desktop level, including installing and upgrading software, installing hardware, implementing file backups, and configuring systems and applications for 100's of devices.
• Evaluated documented resolutions and analyzed trends for ways to prevent future problems.
• Provided technical support of information systems and telecommunication systems as needed by staying up to date with needs from the company.

New Orleans, LA, US

• Troubleshot and repaired Department of Health and Hospitals computers for 200+ users.
• Imaged computers using Dell Kace k2000.
• Managed user and computer accounts in Active Directory.
• Scanned and removed malicious software from 100's of computers/laptops.
• Wiped computers to Department of Defense standards.
• Collaborated with a team to meet IT goals such as increasing response time to issues from 3 days to 1 day.