SUMMARY:

• I’m a detailed oriented IT professional looking for an analyst position to utilize all my prior experiences and to continue to develop my skills in the IT industry.
• I have multiple years of experience in writing requirements, system test planning, system test execution, system configuration, and data conversions.

TECHNICAL SKILLS:

• Proficient in Microsoft Office (Word, Excel, PowerPoint, Outlook, Access)
• DB2, Access, and Microsoft SQL Server database experience
• Risk Management
• Business requirement gathering
• Customer Service/Vendor Relations
• SDLC
• Quality Assurance
• Coaching/Training

PROFESSIONAL EXPERIENCE:

Confidential

Data analyst

Responsibilities:

• Designed, developed, tested, and managed database systems used for local utility company's residential and commercial energy optimization programs.
• Completed a large data conversion involving millions of customer accounts for the commercial energy optimization program database.
• Implemented database updates to account for the utility moving to a completely new system. This included writing requirement documentation, database configuration, test planning, and test execution.
• Transmitted a monthly SOAP XML submission with product installs and energy savings to the utility.
• Designed and developed custom reports for monitoring program performance metrics and program status.
• Performed data collection for analysis and collaboration with utility to facilitate process improvements.
• Prepared daily, weekly, monthly, and quarterly data reports for distribution.

Advance auto parts

Responsibilities:

• Led inventory processes to ensure inventory accuracy greater than 95% including completing cycle counts, manage back stock inventory, and verify weekly warehouse deliveries.
• Utilized web and desktop applications to meet customer needs.
• Managed shipment of commercial deliveries utilizing Advance’s electronic delivery board system.
• Provided business support to upper management in data analysis and report building.

IT analyst

Responsibilities:

• Managed the software upgrade to the kennel’s Kennel Connection software. Led the process to configure the data shown on the invoices. Trained the staff on software upgrade impacts to grooming and boarding scheduling and invoice updates.
• Performed analysis and debugged issues/defects encountered with the kennel’s software.
• Utilized web and desktop applications to meet customer needs.
• Created reports for ownership to assist in strategic planning and business analysis.

Systems analyst

Responsibilities:

• Managed the work of multiple setup configuration analysts in order to ensure achievement of goals and objectives for numerous projects automating defined benefit plans including implementing 6 new populations to the already existing functionality for an ongoing client team with multiple benefit services. Communicated project status and issues to multiple teams and/or vendors involved in any given project which includes both technical and non - technical audiences.
• Implemented a formal SDLC process for an ongoing client team to ensure proper procedures and controls were in place to successfully complete any given projects or defect resolution including the setup of excel templates to organize future project assignments into task/subtasks to better define responsibilities and accountabilities of current and future project work.
• Converted client requirements into analysis artifacts and for designing test plans for 50+ projects. This included delivering clear analysis, test plans, and Standard Operating Procedures (SOPs) which accurately reflect the technical capabilities of the TBA system and address the requirements of the client.
• Used my own analysis for coding functionality for events and/or production defects.
• Maintained baseline requirement documents in order to ensure client met internal standards for keeping client team requirements accurate.
• Worked on numerous projects supporting the base team which impacted all client teams. For one of the projects, I found major issues regarding tax information not being sent correctly to the vendor.
• Led client team in requirement planning, coding, and testing to implement changes to the non-qualified plans to comply with Internal Revenue Code section 409a.

Business analyst

Responsibilities:

• Implemented administration of defined benefit plans for two Fortune 500 pharmaceutical companies to the Hewitt Total Benefits Administration (TBA) system by analyzing the client’s defined benefit plan requirements in order to prepare and execute test plans against GUI and the web.
• Created and delivered training to over 50 customer service representatives in order to utilize the technology to administer benefits to the participants of the plan.
• Led a data conversion for a population of about 5000 participants. This included creating documentation for the mapping of the data, communicating with the client to ensure all data elements properly made it to the system, performing all test planning and testing, and monitoring project progress.
• Worked with client team’s trust vendor in order to ensure the millions of dollars in monthly pension payments processed correctly.
• Discovered a mistake which saved the company over a million dollars while verifying production PCSs (Personalized Communication Statements).
• Created multiple flow diagrams based on client requirements for various life event processes.