SR DATA/SYSTEMS ANALYST (MAR 2016 – PRESENT)Supporting Information Analytics and Reporting Services (IARS) on the Information Warehouse (IW) Team by being a team member on an agile project to create new reporting solutions for current manually pieced together reports.• Created report requirements by analyzing SAS code for complex Collections reports.• Created mapping documents and rules for new data mart fact tables using Collections and Recovery systems data in IW.• Created test cases for new fact tables, Cognos framework and Cognos reports.• Performed SIT/UAT testing for new fact tables, Cognos framework and Cognos reports.• Analyzed multiple new data sources (SAM BK and iRepo) to help design a solution to bring the data into the Warehouse.SR DATA/SYSTEMS ANALYST (FEB 2014 – MAR 2016)Supported Loss Mitigations Applications, Collections and Recovery by becoming an integral part of the team as the Recovery system moved from the mainframe to SQL Server/.Net technology. • Supported the Debt Manager (DM) to Recovery Project (DMR) by learning the Credit Bureau Reporting requirements, business processes and Shaw Recovery capabilities. Responsible for custom code to handle Ally requirements the COTS product did not have incorporated.• Helped create and manage the 1099 extract process in the new Shaw Recovery system. • Created IDDs, Context diagrams and Sequence diagrams for Credit bureau and other technical work streams for Recovery.• Supported data cleanup efforts from the migration off DM to Recovery where there were missed requirements by writing SQL stored procedures.• Wrote SQL Stored Procedures to automate Recovery manual business processes.• Completed “AS IS” requirements for current Collection interfaces to help facilitate mapping for the next version of Collections, SQL Server/.net platform.• Creating mapping documentation for current Collection interfaces to the CARS tables fields to help facilitate Alfa mapping exercises.

I supported HR IT with its program initiative to convert the current HR applications over to ADP Advantage Suite.• Supported the data conversion activities by mapping the current fields used in PeopleSoft to the ADP suite field values.• Reviewed the current standard reports and adhoc reports generated in PeopleSoft to identify fits and gaps in the ADP Advantage Suite delivered reports and functionality.• Helped to define and design the data architecture for archiving the data that will not be converted to the new systems. • Helped to define and design the architecture for reporting from the archived data.

I supported GM HR for Cognos 8 reporting and problem resolution for PeopleSoft 9.1 by acting as the liaison between GM IT and GM HR.• Created change controls and tickets for issues within Cognos 8 reporting environment and PeopleSoft. • Reviewed functional and technical specifications provided by third party vendors to ensure they meet the business requirement. • Created test cases and performing User Acceptance Testing for Cognos 8 and PeopleSoft changes.• Created adhoc reports using Report Studio for U.S and Global HR business users to help run the business and track metrics.• Trained the business users in Cognos 8, Report Studio and database design for Cognos 8 to ensure that users understand the new reporting environment and structure. • Identified, participated and tested vendor related issues pertaining to both the Cognos 8 reporting environment and the PeopleSoft HR customizations to reveal and correct data reporting and HR anomalies because the Reporting and PeopleSoft upgrades.

I led the data team’s efforts during GM UAW negotiations for adhoc requests and report writing. I provided HR data expertise and project management capability within a multi platform and multi system environment utilizing contract resources.• Served as the liaison between the data team, GM Labor Relations and the UAW to ensure timely communication between all parties. • Trained team resources, both in the Cognos 8 and Payroll mainframe environments.• Managed the workload of an eight person data team to drive timely delivery of reports requests.. • Utilized Cognos 8 to create, review and test ad-hoc report requests that were distributed to GM negotiators and the UAW which contained data vital to the labor negotiations.

I provided subject matter expertise (SME) to General Motors HR and Labor Relations for the PeopleSoft and Cognos upgrade projects. Served as the liaison between GM IT and GM HR for the projects.• Managed the Labor Relations partnership with GM IT to help design the new Cognos reporting environment by providing Labor Relations’ insight and perception of the existing reporting environments.• Interpreted business requirements into functional specifications for GM IT and its vendors which assisted with a smoother transition to the upgraded environment. • Assisting with the PeopleSoft upgrade project by providing hourly HR business process expertise for migrating some of the data to already delivered PeopleSoft functionality.• Developed Cognos 8 reports from current standard Impromptu reports and from user adhoc reports. • Defined creative solutions to migrate the current hourly HR data into the new table structure to ensure continued functionality of hourly HR.• Leaded the effort to streamline the systems used by HR personnel to update hourly personnel information.• Developed functional and technical specifications for Cognos standard reports based on business requirements. • Created test cases and test data for the upgrade projects to assure that the proper levels of testing were achieved for the customizations in the HR environment. • Participated in stakeholder meetings to plan strategies necessary for the PeopleSoft project and Cognos projects to meet the tight deadlines because the two projects were competing for the same pool of resources.• Performed User Acceptance Testing for Cognos 8 framework models to ensure the environments would be acceptable for the user community.

Responsible for providing subject matter expertise (SME) to GM IS&S for PeopleSoft HR projects which were a result of the 2007 UAW Negotiations.• Worked with GM IS&S and Labor Relations to define the projects that stemmed from the new UAW contract so that all projects and the requirements were solutioned correctly.• Performed project management role to ensure the projects followed the GM standard process set.• Worked with application support vendors by providing subject matter expertise for the development of new PeopleSoft online panels, reports, processes and batch programs.• Supported GM Labor Relations staff by creating, maintaining and modifying Cognos queries that are used to help with decision making and statistics.

Responsible for duties related to GM UAW Negotiations Data Team.• Acted as customer interface between the data team and GM Labor Relations to ensure timely communication between GM, UAW and the data team that ensured that the data reports were completed in the time frame that was needed. • Used Cognos/Impromptu to create/review/and test ad-hoc report requests that were distributed to GM Negotiators and the UAW containing data vital to the labor negotiations.• Created and maintained Project Workbook for GM so that all reports and the report designs would be available as a reference on an as needed basis by GM in the future.• Trained team in resources, both in the Cognos and Payroll mainframe environments so that the data team would be able to provide the best data reports to GM for analysis and negotiations for the contract. • Created ad-hoc reports for usage by GM Labor Relations to support Special Attrition Programs so that they would have statistical data on how many employees were accepting a buyout package.

Performed project management functions following a standard process set designed for SSN Remediation.• Created templates and processes for SSN Remediation Project at a plant application level to ensure consistent solutions across multiple plants and plant specific applications. • Provided workload management function for COE team to effectively utilize resources and allocations. • Provided data analysis for home grown GM plant level applications so that all usages of SSN were identified correctly. • Trained team members with process for SSN elimination to ensure that governmental requirements were adhered to for SSN elimination. • Developed/implemented/tested solutions for elimination of SSN usage.

Supported GM IS&S and GM Labor Relations by providing subject matter expertise for GM HR data clean-up efforts. • Identified data issues and anomalies within the PeopleSoft HR space that resulted with better data accuracy within GM HR. • Defined solutions to resolve data integrity issues.• Created Cognos queries to support GM Labor Relations staff.

Assisted with the Fidelity transition project on the Layoff Benefits Support Team. This project is a multi-vender project with EDS being a Tier II supplier of Fidelity.• Developed Cobol/IMS programs to extract legacy HR data for the new HR tables in the Layoff Benefits System.• Developed Test Data for Integration testing. • Interfaced with GM and Fidelity to execute test plan. • Provided extensive customer interfacing with vendors and GM to ensure quality integration and system testing within the multi-vendor environment and application base.• Analyzed test results to identify defects to help determine which vender was responsible.

Provided Third Level support for HR users on the PeopleSoft Cognos Impromptu ad-hoc reporting solution in a Citrix environment. Assisted user with ‘how to’ type of questions. Developed standard reports for production in the PeopleSoft Cognos Environment.• Provided extensive Customer Interfacing with the Cognos user community that helped train users with the newly implemented reporting environment. • Defined requirements for standard reports to be written in PeopleSoft Cognos Impromptu based off the legacy production reports.• Defined technical specifications for standard reports.• Worked with IBM to write standard reports and follow the IBM process for creating and implementing the reports.

Supported mainframe HR systems, both hourly and salary personnel systems. Utilized seven years of technical and business knowledge to identify, respond to, and solve business issues for the purpose of assisting GM and Delphi customers achieve leadership in the marketplace through world-class personnel systems. Worked on a variety of projects: • 2003 Negotiations Report Writing using Cognos Impromptu and Focus.• Annual hourly rate increases coordinating the business side with the GM customer to ensure that 150,000 employee record updates occur correctly.• System Life Cycle Subject Matter Expert (SLC SME) working with project teams to help achieve CMM Level 3. This included helping to write some of the process sets.• Year 2000 project coordinating with the GM and Delphi plants to ensure their successful conversion.• Consultant for Delphi’s HR conversion off the legacy system