Jody Baldwin

• Created a historical data mart utilizing Microsoft SQL Server Integration Services to gather data and Microsoft Reporting Services to present web based reports to the end users.
• Utilized Microsoft SQL Server SSIS to gather data from 10 Nortel Symposiums, 3 Aspect eWFM systems, and 12 Witness Systems into a centralized Operational Data Store.
•  Designed and developed a Line of Business Administration tool to be utilized by Symon’s Vista product to provide browser based real-time statistics. The tool allowed skillsets and teams to be mapped to lines of business.

• Gathered requirements from leadership team to produce KPI Reports from production manufacturing systems.
• Consolidated data from multiple productions systems into a centralized data mart used to produce KPI Reports.

• Redesigned corporate intranet utilizing ASP and MySQL creating a dynamic data driven site replacing the static site.
• Designed a Time sheet entry website for exempt and hourly office staff to be utilized to track hours worked and vacation. Employees were able to access reports to show available PTO and hours worked.
• Utilized Crystal Reports to develop needed MIS reports, incorporating them into the redesigned corporate intranet.
• Designed and developed a data warehouse utilizing SQL Server DTS to provide a central repository for all MIS related data.

Coordinated application design and analysis including specifications, development, training, implementation and
reporting activities.

• Designed and developed client server applications used to track physician and information necessary to make informed business decisions.
• Developed database solution to track surveys completed for each provider in physician network replacing a manual intensive process.

Provided consulting services to one of the nation’s top 10 issuers of credit cards.

• Provided application discovery services to determine project deliverables and establish target completion dates to gauge success.
• All deliverables completed according to Statement of Work defined during discovery.
• Made recommendations for future enhancements to the application to increase performance and security.

• Designed and developed reporting solution that combined data from Kana, Webline, Enterprise Interaction Center and Octane providing a consolidated view of agent and contact center performance.
• Provided database and reporting application development to the nation’s second largest soft drink company in their direct sales contact center.
• Heavy participation in the discovery process, resulting in requirements necessary to successfully proceed with application development using tools such as Microsoft Access, SQL, VBA and Crystal Reports.

• Provided project management and application development services to the 3rd largest U.S. automotive manufacturer in their financial contact center.
• Developed a multi-site historical reporting application for a large financial services company that included individual site performance reports and consolidated multi-site reports. Reports were also available by individual, team, and site.
• Performed all aspects of customer engagements, including requirements discovery, time estimates, creation of statement of work, application development, testing, and customer acceptance.
• Provided report design and development training to a large national long distance carrier.