SUMMARY:

• Worked remotely and face to face with Stakeholders to improve the quality of products and services being delivered.
• Elicited business requirements from business users and/or technical design
• Used judgment and creativity and sound technical knowledge to obtain and recommend solutions
• Elicited business requirements, and created use cases for development of system
• Developed MS Access databases that imported, and manipulated the data, and exported data in MS Excel spreadsheets.
• Developed complex reporting tools in MS Access which compiled data into single location.
• Organized and implemented a Motor Analysis and Auditing Program for Chrysler to improve the financial expect of the department.
• Developed an MS Access database to analyze data and assist management in formulating a national motor initiative.
• Team participant of documenting technical design for over 6,000 MS Access databases
• Ensured that all requirements, testing plan, source code, and completion documentation was prepared and appropriately distributed and archived.
• Migrate several databases into one for Confidential
• Perform reverse engineering for analyzing programming components and database design
• Analyze user developed applications (UDA) i.e. MS Access, Excel, csv, and txt.
• Extrapolate business requirements from business users and /or technical design
• Used judgment and creativity and sound technical knowledge to obtain and recommend solutions
• Developed a UDA Reengineering database for tracking and assessing all Tools within the Advantage team radar
• Attended weekly WebEx, and conference meeting with the Business System Development team (BSD) to exchange skills, ideas and to brainstorm what’s next going forward
• Responsible for enhancements and customer support for over 100 different MS Access databases which covered over 25 of Ford Business Centers remotely.

TECHNICAL SKILLS:

• CaseComplete
• IBM PC
• MS Access Developer
• MS Excel
• MS Outlook
• SQL
• VBA
• Windows

PROFESSIONAL EXPERIENCE:

Confidential, Warren, MI

Data Analyst

• Performed reverse engineering for analyzing programming components and database design
• Elicited business requirements, and created use cases for development of system
• Validated Business Process Modeling
• Developed Process Flow Diagram
• Developed Business Process Documentation
• Created Activity Descriptions
• Created Exceptions
• Defined Roles and Responsibilities
• Defined Business Rules
• Developed MS Access audit database providing stats for analyzing employees’ performances
• Attended weekly meetings to brainstorm what’s next going forward
• Migrated several databases into one
• Pulled data from server within the SAS Enterprise platform
• Performed weekly, monthly and yearly analytics reporting
• Transfer files via SFTP
• Managed and monitored employee’s performances

Environment: MS Access, VBA, SharePoint, MS Excel, SAS Enterprise, SFTP

Confidential, Dearborn, MI

Developer/Business Analyst

• Performed reverse engineering for analyzing programming components and database design
• Responsible for enhancements and customer support for over 100 different MS Access databases which covered over 25 of Ford Business Centers remotely.
• Developed MS Access databases that imported, and manipulated the data, and exported data into MS Excel spreadsheets.
• Developed complex reporting tools in MS Access which compiled data into single location.
• Designed professional forms and reports within Access from pre - defined business requirements.
• Analyzed, and pulled data from database, while working within a SQL Server database environment.
• Worked remotely with Stakeholders to improve the quality of products and services being delivered.
• Ensured that all requirements, testing plan, source code, and completion documentation was prepared and appropriately distributed and archived.
• Communicated technical issues to non-technical users and translate end-user requirements into workable technical specifications which has been key to conversion in our department.
• Collaborated with team members in analyzing requirements to ensure precise plans and identified solutions and to meet the needs and expectations of all users.

Environment: MS Access, VBA, SharePoint, MS Excel, SAS Enterprise

Confidential,Detroit, MI

Business Analyst/MS Access Developer

• Elicited business requirements, and created use cases for development of system
• Validated Business Process Modeling
• Developed Process Flow Diagram
• Developed Business Process Documentation
• Created Activity Descriptions
• Created Exceptions
• Defined Roles and Responsibilities
• Defined Business Rules
• Developed MS Access databases that imported, and manipulated the data, and exported data in MS Excel spreadsheets.
• Performed reverse engineering for analyzing programming components and database design
• Implemented the mean, median, mode or range.
• Analyzed, and pulled data from database, while working within SAS Enterprise environment.
• Stakeholders to improve the quality of products and services being delivered.
• Ensured that all requirements, testing plan, source code, and completion documentation was prepared and appropriately distributed and archived.
• Elicited business requirements, and created use cases for development of system
• Involved in the development of project plans and often provided project management skills when these skills were not available in other project participants.
• Conducted various workshops, and created and managed internal process documentation and presentations.

Environment: MS Access, VBA, SharePoint, MS Excel, SAS Enterprise

Confidential,Southfield,MI

Project Coordinator/Analyst

• Project Coordinator and Analyst, and developed a Microsoft Access database to track employees benefit for the Medicare Coordinator of Benefit Federal Government Project.
• Provided, and developed Access Database capable of handling future federal government auditing.
• Developed MS Access databases that imported, and manipulated the data, and exported data in MS Excel spreadsheets.
• Developed complex reporting tools in MS Access, and created Access databases which compiled data into single location.
• Analyzed, and pulled data from database, utilizing SQL, and linking spreadsheets.
• Ensured that all requirements, testing plan, source code, and completion documentation was prepared and appropriately distributed and archived.

Environment: MS Access, MS Excel, MS Office Suite, SAS Enterprise

Confidential,Warren Trucks,MI

Business Technician

• Developed MS Access databases that imported, and manipulated the data, and exported data in MS Excel spreadsheets.
• Developed complex reporting tools within Access databases which compiled data into single location.
• Organized and implemented a Motor Analysis and Auditing Program for Chrysler to help in the financial expect of the department.
• Developed an MS Access database to analyze data and assist management in formulating a national motor initiative.
• Ensured that all requirements, testing plan, source code, and completion documentation was prepared and appropriately distributed and archived.