Project Manager System
Resume:
M elody Borman H icks
P roject H istory
Alabama’s Department of Mental Health Data Warehouse
S tate of Alabama
Project Manager, GDH Government Consulting
August 2013 – present
• Elicit and document business, functional, security, and technical requirements
for scanned patient record repository in SharePoint 2010 environment
• Write and execute SQL queries in SQL Server environment
• Elicit and document business, functional, security, and technical requirements
for data warehouse implementation in M icrosoft SQL Server / SharePoint 2010
environment
• Create and manage external content types and lists in SharePoint 2010
• Design and develop Access database for exception reporting
• Create and manage operational planning, capacity planning, and change
management documentation for project
• Direct and monitor efforts of project resources
• Maintain r isks and issues log for project
• Maintain work breakdown structure (WBS) / task list for project
• Elicit and document requirements for patient records repository in SharePoint
• Prepare user guides for and t rain users in SharePoint applications / topics
Vermont’s Child Support Enforcement System – Feasibility Study
State of Vermont
Subject Mat ter Expert, Capital Technology Partners
August 2013 – February 2013
• Elicited and documented existing and to-be business processes
• Performed and documented gap analysis to determine system needs and
potential improvements.
• Provided Child Support Enforcement subject matter expertise to feasibility
s tudy effort
• Elicited and documented business requirements for new statewide child support
enforcement system
• Performed cost / benefit analysis of new system options
M elody Borman H icks
South Carolina’s Child Support Enforcement System
State of South Carolina
Business Analyst / Data Analyst, Capital Technology Partners
May 2013 – July 2013
• Created data mapping spreadsheets, defining business rules for data
t ransformation from source to target databases.
• Wrote and executed SQL queries in SQL Server environment.
• Researched and resolved conversion issues utilizing Quality Center and JI IRA
• Provided Child Support Enforcement subject matter expertise to conversion
effort
• Assisted in conversion testing efforts
• Reverse engineered business requirements from existing mapping rules
I ndiana’s Child Support Enforcement System
State of Indiana
Senior Business Analyst, Deloitte Consulting
December 2012 – May 2013
• Created Business Process Models using IndustryPrint (IP) software of to-be
p rocesses for new automated child support system.
• Created Use Case and system Service specifications of to-be processes for new
automated child support system.
• Participated in Requirements Joint Application Development (RJAD) sessions
w ith State and County stakeholders.
• Acted as interim team lead, providing weekly status reports and direction to
teammates
Pennsylvania’s Automated Child Support Enforcement System (PACSES)
Commonwealth of Pennsylvania
Subject Mat ter Expert, M indteck, Inc.
J une 2010 – November 2012
• Provided Tier-2 support to county Domestic Relations Sections for
Pennsylvania’s Child Support Enforcement System.
• Created and modified user documentation to reflect system changes.
Page 3 of 9
• Reviewed all project documentation.
• Validated Cognos report data (all data warehouse reports) and functionality for
u pgrade (Version 10)
• Created Access databases and SQL queries for manipulation of data warehouse
data
Arkansas’s Child Support Enforcement System
State of Arkansas
Business Analyst, Protech Solutions
September 2009 - May 2010
• Performed business and technical analysis on multiple system modification
p rojects to support the State’s automated child support enforcement system
• Created functional requirements documentation (use cases, f lowcharts, business
p rocess f lows)
• Created functional test plans and review system test results
• Documented existing system processes and perform gap analyses
• Modified and tested HT M L form templates
• Acted as financial system subject matter expert
Project Server 2007 Implementation
South Mississippi Electric Power Association
Senior Business/Technical Analyst, Comframe Software, Inc.
June 2009 – September 2009
• Performed configuration services for Project Server 2007 implementation
• Conducted Project Server planning sessions with core Project Server team
• Configured Project Server implementation to meet planning specifications
Business I ntelligence Implementation Project
Assurant Solutions
Senior Business/Technical Analyst, Comframe Software, Inc.
March 2009 – June 2009
• Performed business and data analysis tasks on business intelligence
i mplementation project
M elody Borman H icks
• Reverse engineered existing call center reports, including source-to-target data
mapping and data profiling tasks
• Created user requirements document for data warehouse generation of existing
reports
• Created specification documents for existing Excel reports, Access databases,
and Oracle views
• Created User Acceptance criteria and test plans
• Created conceptual model and participated in creation of logical and physical
models
Multiple Automotive Manufacturing Projects
Honda Manufacturing of Alabama
Project Manager / Senior Business/Technical Analyst, Comframe Software, Inc.
October 2008 – March 2009
• Performed business analysis and project management tasks on multiple projects
i n fast-paced manufacturing environment
• Managed project resources and timelines on assigned automotive manufacturing
p rojects
• Elicited and documented existing and to-be business processes on assigned
p rojects
• Ut ilized Business Objects for creation of business reports
Medical I maging Project
Emageon
Senior Business/Technical Analyst, Comframe Software, Inc.
January 2008 – September 2008
• Performed business analysis tasks on project to integrate existing medical
i maging applications via a services-oriented architecture
• Elicited and documented existing and to-be business processes
• Generated use case documentation and UM L models based on documented
p rocesses
Page 5 of 9
Service-Oriented Architecture Implementation
Sungard
Senior Business/Technical Analyst, Comframe Software, Inc.
September 2006 – December 2007
• Performed business and technical analysis tasks on project to implement
services-oriented architecture
• Elicited and documented existing and to-be business process f lows for client
• Elicited and documented business and functional requirements for client-specific
i mplementation of new Services Oriented Architecture (SOA) product for financial
services sector
• Created data dictionary for client-specific implementation of SOA product
• Coordinated with other client project teams to ensure compatibili ty of solutions
• Configured and loaded data for client-specific implementation of SOA product,
i ncluding analysis of database data elements and relationships of terminology engine
(TE) and t ransaction m anagement system (TMS)
• Configured, authored, and deployed business rules for client-specific
i mplementation of SOA product within business rules management system (BRMS)
• Unit-tested data configurations and rules deployment, reporting and t racking
any issues
Alabama Child Support Enforcement System
Alabama Department of Human Resources – Child Support Enforcement
IV-D Project Manager
March 2004 – September 2006
• Performed project management, functional analysis, supervisory, and
development tasks for a State government agency, focused on maintenance of a legacy
child support computer system
• Supervised five (5) to seven (7) functional analysts, both State and contract staff
• Assigned business resources to projects as needed
• Prepared and delivered presentations to county various audience levels, from
u pper management to County staff
• Prepared and delivered performance appraisals for State staff
• Elicited and documented business and functional requirements for upcoming
p rojects
M elody Borman H icks
• Designed, developed, coded, and maintained Access database application for
t racking of bankruptcy cases (extensive coding in VBA)
• Designed, developed, coded, and maintained Access database application for
counties’ self assessment reviews (extensive coding in VBA)
• Designed, developed, coded, and maintained Access database application to
serve as repository for Affidavits of Paternity provided by hospitals (coding in VBA)
• Developed and executed SPUFIs (SQL Processing Using File Input) to provide
counties with reports
Alabama Child Support Enforcement System
Alabama Department of Human Resources – Child Support Partnership
Functional Analyst
June 2003 – February 2004
• Oversaw Federal Test Deck generation and results review (financial system
S ME)
• Formulated and compiled documentation regarding certification objectives for
submission to the Federal Office of Child Support Enforcement (OCSE)
• Coordinated preparation of presentation for certification by OCSE
• Developed business and functional requirements for upcoming projects
• Designed, developed, coded and maintained issues-t racking database in Access
(coding in VBA)
• Assisted in implementation of PRWORA distr ibution changes within Alabama’s
Location, Enforcement, and Collection System (ALECS)
• Created Acceptance/System Test plans as needed
Texas Child Support Enforcement System
Office of the Attorney General, State Office, Austin TX
Program Specialist, Project Manager & Business Analyst
September 2001 – May 2003
• Support Order and Financial System Subject-Mat ter Expert.
• Support Order System Test Lead for PRWORA project.
• Created Business Requirements Definitions (BRDs) for Business Init iatives
Section.
Page 7 of 9
• Performed project management functions for business improvement projects,
i ncluding planning, scheduling, and testing oversight.
• Created and executed User Acceptance Test plans.
• Created user guides for system functionalities.
• Documented system processes using M icrosoft Visio
• Assisted in implementation of PRWORA distr ibution changes.
Texas Child Support Enforcement
Office of the Attorney General, Region 7 Field Office, Bryan, Texas
Program Specialist, Project Manager & Business Analyst
March 1998 – September 2001
• Entered or approved all child support orders on Texas Child Support
E nforcement System
• Reviewed previously entered support orders for accuracy to take corrective
action as needed
• Researched financial issues in child support system and corrected as needed
• Reviewed and managed all out-of-state and out-of-country child support orders
• Conducted t raining sessions for office staff regarding financial issues
• Generated ad hoc reports using M icrosoft Access, created macros to automate
system tasks
•
Education & P rofessional Development
• I nternational I nstitute of Business Analysis – Member
• Continuing Education
Roadmap to Excellence: Foundation for Requirements, Development and
M anagement
Being a BA Series – Technical Excellence
Int roduction to Business Analysis
• Texas A&M University
Pursued Master of Science in Management Information Systems, Fall 2001 - Spring
2002
Coursework and Skills:
o Systems Analysis – System Architect software
o Software Project Management
o Programming in Visual Basic 6
M elody Borman H icks
o Statistics for Managers
• University of Houston
Bachelor of Science granted December 1997, cum laude
Major: Political Science; M inors: Psychology and English
Honors:
o Outstanding Freshman Honors Student
o Golden Key National Honor Society
o National Merit Finalist scholarship recipient
o Robert C. Byrd scholarship recipient
Certifications
• Certified Business Analyst P rofessional (CBAP®)
• M icrosoft Certified Technology Specialist
M icrosoft Forefront Client and Server – Configuration
M icrosoft Office Project 2007, Managing Projects
M icrosoft Office Communications Server 2007, Configuration
Business Desktop Deployment with the BDD
M icrosoft Windows Vista: Configuration
M icrosoft Windows Mobile 5.0: Configuration
M icrosoft Office Live Communications Server 2005
M icrosoft Office SharePoint Server 2007 Application Development
Windows Server 2003 Hosting, Configuration and Management
Biztalk® Server 2006: Custom Applications
M icrosoft Windows SharePoint Services 3.0: Configuration
M icrosoft Office SharePoint Server 2007: Configuration
• M icrosoft Certified I nformation Technology P rofessional
Enterprise Project Management with M icrosoft Office Project Server 2007
Contact I nformation
2680 County Road 85
Deatsville, AL 36022
*********@*****.***
Page 9 of 9
Contact this candidate