SUMMARY:

• During my years in IT I have been an MS Access/VBA/VB programmer, instructor, report writer, business analyst and project manager. I have extensive experience conducting meetings and encouraging users and management to discuss the needs of a product for the purpose of documenting that information including business intelligence in various ways. I have managed and documented up to 13 projects at the same time. Occasionally for different applications and most of the time for large ERP’s.

TECHNICAL SKILLS:

SOFTSKILLS: Conducting JAD sessions (CEO s to users), Gathering Requirements, Testing, UAT, Creating User Manuals, Database Mapping, Gap Analysis, User, Data Mining, ERP Systems, SOX Audits, UML RUP, Supervisor/Manager.

SOFTWARE SKILLS: MS Word MS Excel MS Powerpoint MS Access 2.0 - 2016 Snag It MS Project Various CRMs (Dynamics, Front Range, Act, Online) Visio SharePoint ERoom (Documentum) SQL/PL SQL Visual Basic Applications (VBA) Crystal Reports Visual Basic 6.0 Confluence/Jira Gathering Requirements Testing Working with Mgmt and users CRM (import, export, update, UI, etc) Creating Use Cases Database Mapping Leading Requirement Gathering Meetings End Users Gap Analysis Data Mining Visio diagrams (swim lanes, network diagrams, etc) Agile Methodology

PROFESSIONAL EXPERIENCE:

BUSINSS ANALYST/PROJECT MANAGER

Confidential, Burbank, CA

Responsibilities:

• Gathering requirements from stakeholders to create documentation for an AS400 system including requirements, use case and technical specifications.
• Using Confluence and Jira for tracking projects and creating documentation.
• Working with the QA team for clarification for testing projects before roll out.
• Working with development staff to solidify system capabilities before presenting requirements, etc to users/stakeholders.

BUSINESS ANALYST/CRM MANAGER

Confidential, Encino, CA

Responsibilities:

• Customize Dynamics Fields, screens and reports for marketing and project management.
• Work with API’s to upload analytics and responses from outside marketing firms like Mailchimp.
• Create Gap Analysis for migrating MS Dynamics from version 4.0 to 2011.
• Manage and customize an MS Dynamics database, including creating new fields/screens and implementation.
• Cleaning up information in the database - contact information, software they purchased, software versions, etc.
• Creating documentation for already existing custom software to provide to co-branded partners.
• Creating user manuals for extensive calendaring/docketing software supplied to attorney firms.

BUSINESS ANALYST/CRM CONSULTANT

Confidential

Responsibilities:

• Gather business requirements for a manufacturing firm in Torrance.
• Present Cost Benefits Analysis on several CRMs that would meet their Customer Support needs.
• Consult with CRM vendors (Salesforce, Microsoft Dynamics, Sugar and Goldmine) to clarify features, platforms and capabilities of the various software(s).
• Provide recommendation/demonstrations and answer questions for the manufacturing firm to help them decide on the best Customer Support software for their needs.

BUSINESS ANALYST/ACCESS PROGRAMMER

Confidential, Encino, CA

Responsibilities:

• Gap Analysis of current product in order to migrate it from FoxPro to MS Access 2010.
• Creating a customized MS Access 2010 database to replace the FoxPro database, including contact, invoicing, customer and employee forms and reports.
• Sscrubbing and migrating the data to Access.
• Create security to protect sensitive financial information.
• Automate the twice monthly invoicing, including; methods to record and track payment of invoices, monthly contracting amounts, customer complaints, all supplies used and any extras done by the crews.
• Create macros and VBA code for proper form and report performance.

BUSINESS ANALYST

Confidential (Century City, CA)

Responsibilities:

• Conduct JAD sessions with users and executive stakeholders to determine issues and document the requirements using use cases and UML modeling.
• Updating and creating use cases for improvements, enhancements and bug fixes to new ERP.
• Providing documentation and responding to requirements from Price Waterhouse for the yearly SOX audit.
• Monitoring bugs, determining which to include in releases along with the enhancements/fixes.
• Running weekly tests of the financial month-end process to ensure a smooth process and proper reporting.
• Test all fixes/enhancements before a release and work with the programmers to revisit any needed issues.
• Test fixes after a release and work with users to determine that issues have been resolved.
• Work with stakeholders/user for UAT after the release and .

BUSINESS ANALYST/PROJECT MANAGER

Confidential

Responsibilities:

• Supporting local realtors and mortgage offices creating web pages in Publisher and setting up internet marketing.
• Working with third party vendor to implement a SQL based data warehouse for business intelligence purposes.
• Facilitate automation (API, FTP) of marketing data from the company’s web analytics partners (Ebay, Yahoo, etc).

PROJECT MANAGER/BUSINESS ANALYST

Confidential (West LA, CA)

Responsibilities:

• Interacting with Confidential and MySpace to implement an IVR system that allowed users to upload their own songs to their cell phones and MySpace page. (IVR recognized copyrighted songs so they could not be uploaded)
• Work with PMO group to ascertain resources and generate a project plan.
• Design project plan/timeline utilizing MS Project.
• Review documentation with Quality Assurance and Development teams to determine LOE.
• Generate business requirements and use cases utilizing best practices and UML.
• Use Mercury Quality Center to track enhancements/defects and assign tasks to the appropriate programming resource.
• Manage the processing of mobile phones through the profiling process (R&D, content assignment, applications, etc).
• Mentor Analysts in creating, reviewing and redefining existing documentation.

PROJECT MANAGER/BUSINESS ANALYST

Confidential (Los Angeles, CA)

Responsibilities:

• Manage implementation of upgrades to Oracle based financial software.
• Write requirements/use cases for an ecommerce website.
• Document Project Authorization, Project Plan and Lessons Learned for the company’s JAVA, .Net, and C++ web applications.
• Working with business units, developers and others to set priorities and negotiate project timelines.
• Meet with users to determine needs and create requirements and use cases to facilitate accomplishing tasks.
• Work with client to determine and maintain SOX and CSOX compliance.

BUSINESS SYSTEMS ANALYST

Confidential (Los Angeles, CA)

Responsibilities:

• Studying the mainframe version of an ERP type application to generate requirements and use cases to convert it to a J2EE/HTML based application including adding additional functionality.
• Leading JAD sessions to determine requirements from users and management.
• Working with testing, development and teams to gather necessary data to create specifications and verify quality assurance.
• Converting requirements from other analysts to use cases and design specifications utilizing UML and RUP methodology and templates.
• Include items in documentation to conform to SOX requirements.
• Working with client for final approval of documentation.
• Projects include
• Development of three “bolt on” pieces to the new J2EE application (designed to be sold separately) including analysis, screens and documentation.
• Originally assigned three modules to analyze/document - I completed 10, plus specifications for reports.
• Using ERoom (Documentum) to manage project documentation and project artifacts.
• Maintenance of Style Guide to document consistent features for the new application.

BUSINESS ANALYST/PROJECT MANAGER

Confidential (Burbank, CA)

Responsibilities:

• Create specification and identify difficulties with upgrade from Windows 2000 to XP.
• Meeting with the business units to determine and document requests.
• Work with local and intrastate development staff to determine method to accomplish objectives.

BUSINESS ANALYST/PROJECT MANAGER

Confidential (Irvine, CA)

Responsibilities:

• Leading JAD sessions with various business units to gather requirements.
• Create Business Requirements, Use Cases, Flowcharts, Design Specifications and Quality Assurance testing documentation utilizing UML and RUP.
• Negotiate with the business unit for approval of documentation and delivery to meet project objectives.
• Coordinate with business units, developers and other staff to ascertain best methodology/practice.
• Handled up to fifteen small to medium size projects at any given time including:
• Enhancements to two existing outward facing JAVA based sites and a JAVA based intranet tracking application.
• Lead BSA for implementation of Active Directory.
• Lead BSA for integration of non-web based application to one of the JAVA applications.
• Mentoring other Analysts in Company databases, documentation and company procedures in a classroom setting and via informal meetings
• Work with Commercial and Retail business units to establish SOX compliance.

BUSINESS SYSTEM ANALYST/PROJECT MANAGER

Confidential (Irvine, CA)

Responsibilities:

• Leading JAD sessions with clients to analyze and document requirements.
• Research options with internal departments and external vendors to meet those requirements and present options for completing the project to the business users.
• Create Charter, Business Requirements, Use Cases and Quality Assurance testing documentation (utilizing VSS, Visio, Word, Excel ).
• Work with programmers and testers on each portion of a project and track the progress.
• Projects include:
• Upgrade/enhancement of existing J2EE application.
• Changes to existing application(s) via Store Procedures and other SQL (2000) design changes
• Researching vendors to provide ad-hoc and other reporting needs for several departments and the J2EE application.
• Creating a project tracking database.
• Participation in a team to develop and expand on the enterprise templates for implementing and tracking projects.
• Creation of Actuate marketing/analysis reports for the enterprise and individual departments.