SUMMARY:

• I have 10 years as a business analyst and project manager.
• This includes conducting meetings to gather and generate; requirements, use cases, process flows and reporting needs.
• All of my positions have also required; Testing, UAT, Creating User Manuals, Database Mapping, Gap Analysis, User Training, Data Mining, ERP Systems, SOX Audits, UML RUP and as a Supervisor/Manager.

• MS Word
• MS Excel
• MS Powerpoint
• Snag It
• MS Project
• Visio SharePoint
• ERoom (Documentum)
• MS Access 2.0 - 2016 SQL/PL
• SQL
• Visual Basic Applications (VBA)
• Crystal Reports Visual Basic VSS (now TFS)
• 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 Training End Users Gap Analysis Data Mining Visio diagrams (swim lanes, network diagrams, etc)
• Agile Methodology

EXPERIENCE:

BUSINSS ANALYST/PROJECT MANAGER

Burbank, CA

Confidential

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

Encino, CA

Confidential

Responsibilities:

• Set up MS Dynamics (local Install)
• 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/ACCESS PROGRAMMER

Encino, CA

Confidential

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 all forms, reports and scrubbing 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

 Fox Century City, CA

Confidential

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 training.

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

West LA, CA

Confidential

Responsibilities:

• Interacting with Cingular Wireless 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

Los Angeles, CA

Confidential

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

Los Angeles, CA

Confidential

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 training 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.

BUSINESS ANALYST/PROJECT MANAGER

Burbank, CA

Confidential

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

Irvine, CA

Confidential

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.
• Using VSS (old TFS) for co-ordination updates for code and code management.

BUSINESS SYSTEM ANALYST/PROJECT MANAGER

Irvine, CA

Confidential

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.

Database Analyst Programmer

Newport Beach, Ca

Confidential

Responsibilities:

• Identifying workflow of companies and developing methodologies with existing and new software to better track required data.
• Training clients on the full use and capability of CRM Software.
• Setting up recurrent administrative duties for the SQL server.
• SQL design and analysis for new and existing databases in SQL 7.0 and 2000.
• Designing customized reports in MS Access and Crystal Reports to show sales analysis, manufacturing WIP, customer contact data, etc.
• Creating “band-aids” as requested to modify existing Access database(s) to meet most immediate needs.
• Condensing MS Access estimating, planning and tracking system from 16 databases to one including new interfaces and reporting.
• Creating and tracking a project plan to show progress of projects.

INFORMATION TECHNOLOGY MANAGER

Confidential

Responsibilities:

• Department management including budgeting and personnel management.
• Analyzing current applications and researching and presenting new ones for consideration (CRM, PBX, Service Agreements, Vendors, etc).
• Interfacing with vendors for projects to enable autodialing through server and existing PBX, electronic document storage, software and hardware upgrades and design of company web page.
• Project lead to create Service Level Agreement between Hospital and entity.
• Increasing user confidence via training and reporting to increase usage of CRM system.
• Examining existing applications and condensing to remove redundancies.
• Creation of ad hoc reports in Crystal Reports, MS Access And FrontRange from SQL.
• Customizing and organizing screens and data for Goldmine FrontOffice.
• Adding needed fields and tables and other administrative duties in SQL.
• Elimination of duplicate records and other irrelevant information in the SQL database.
• Data mining for sales analysis and other marketing purposes utilizing SQL and MS Access.
• Interface with outside vendor to increase marketing data and move data into the existing CRM system.

Visual Basic Programmer

Orange, Ca

Confidential

Responsibilities:

• Utilizing Visual Basic 6.0 with an MS Access Backend to develop software for a wholesale mortgage firm designed to track loans from the initial cold call to close of escrow.
• Designing Reports for end users utilizing MS Access and SQL queries and Active Report software.
• Creation and maintenance a SQL 7.0 database to track 2.5 million leads and connect the information to the existing telemarketing software.
• Creation of software to track technical support customer service calls and follow up.
• On-going training of end users on use of the new software and its updates.

MS Access Developer/Programmer

Cypress, Ca

Confidential

Responsibilities:

• Migration of eight Access 2.0 databases into one single Access 97 database to facilitate a more user friendly system that was Confidential ready and automated.
• Creation of documentation to determine what changes were needed to make additional databases Confidential compliant.
• Design a testing plan to determine that date and data changes were effective and that software would function January 1, 2000.
• Use of a specified testing plan to test ConfidentialK readiness in a Lab setup specifically for this purpose. Testing included interaction with several servers and the specified database(s).
• Creation of a database for generating reports regarding bed occupancy at a Confidential hospital.

MS Access Developer/Programmer

Confidential

Responsibilities:

• Modification of an existing database used to generate and track payment of invoices including normalization, optimization, restructuring queries, storage and archiving processes.
• Testing to assure functionality for Confidential.
• Creation Business Requirements documents for modifying the database for normalization and for Y2K compliancy including tracking project time and cost.
• Meeting with end users and management for specifications, updates and training.
• Creating new user-friendly reports and forms and utilizing the client server environment across multiple servers using shells.
• Assignments included AAA, Sprint PCS and PIA Merchandising