Summary

• Senior Business Analyst/Project Manager
• Over ten years of experience in analysis and design to client specifications in diverse environments. Agile and Waterfall Methodology, conducting JAD sessions to involve the entire team, planning, gathering requirements, getting feedback on workflow analysis design flowcharts , coding concerns, discussions on where there may be concerns between departments based on process changes or coding/data changes, unit testing, auditing data, and getting sign offs on UATs. Data conversion, reports conversion utilizing multi-platform orientation/sources in various environments.

Technical skills:

Experience:

Confidential

Senior Data Analyst

Responsibilities:

Data Integrity. Created Process Flow Charts using Visio. Analyzed data in the Data Warehouse, comparing against the Staging, Pre-Staging and main Sources and sources from the State. Worked with the ETL developers.

Confidential

Senior Business Analyst

Responsibilities:

Agile/Scrum environment. We would release an upgrade each month. This requires gathering requirements, writing up BRD/System Specs handing off to the developers, user acceptance, testing, implementing and testing again in Prod. Pending obstacles, most requests would make it into the next release. Gather requirements, schedule meetings with Stakeholders Physicians and Users, work with Project Leads, Project Managers and Developers. Create Specs, Process Flow Diagrams, QA Test Documents and Testing. Data analysis to document data from source to target. The projects were around developing/updating reports stored and updated in SharePoint and TFS.

Confidential

Senior Business Analyst

Responsibilities:

Gather requirements, schedule meetings with Stakeholders and Users, work with Project Leads, Project Managers, Developers, Data Analysts and DBAs. Create BRDs, Complex Context Diagrams, Complex - Business Flow Diagrams, Process Flow Diagrams, Cross-Functional Flowchart, Database Model, Screen shots of current web applications, Mockups of 'to be' state, SOW, Org Charts, Project Plans, and many more. The projects were around developing/updating web sites/pages which were stored and updated in SharePoint and TFS.

Confidential

Senior Business Analyst

Responsibilities:

Tasked with transitioning responsibilities from over 8 supported applications from the client SMEs to our own resources SMEs in an effort for the client SMEs to move on to another priority project within the client company in an Agile and Scrum environment. Each team member submitted their part of the project plan with a timeline of accomplishing the various pieces. We had standup meetings twice a week doing a round robin on where we are in the project. Based on new information, adjustments to the project plan would be made. Collaborated with other Site Leads in an effort to coordinate shared resources for training and support during the transition phase. Voiced updates and any concerns/issues during weekly PMO meetings. During Site Lead/BA meetings, bring each other up to speed on how each site is performing, giving opportunity to benefit from shared information. Worked with Department Managers, Directors, PMO, other Site Leads, and Technical Analysts. Submitted weekly progress through various project documents.

Confidential

Title: Senior Business Analyst

Responsibilities:

Worked on a project modifying about 300 reports as part of a conversion process. Added SQL script to each report stored procedure as required. Worked with MISBITS, JIRA Tickets, SQL Server 2005, SSMS, SSRS, SSIS, using TFS in the .net environment. Complex Select statements, created tables and temp tables , fields, stored procedures modifying SP's that use OPENQUERIES, sub-queries, CASE functions , Functions, within various environments using the database structure of SQL DB's and IDS. Completed project ahead of schedule.

Confidential

Title: Senior Business Analyst

Responsibilities:

Modified an existing MS Access database with additional tables, queries, forms and macros to streamline current processes. Cut a three day process down to an hour through the use of forms and macros. Ran and audited weekly and monthly reports displaying forecasted and actuals for current projects.

Tracked volume of storage on servers, calculated costs, compared against billing and analyzed data for cost savings to submit re-engineering saves. Developed MS Access ad-hoc database and ad-hoc queries.

Confidential

Title: Senior Business Analyst

Responsibilities:

Developed a database that combined reporting data from multi sources into one source 'Reporting Repository' in the .net environment. Worked with upper management on KPI specifications, gathered user specifications, developed flowcharts and wrote technical documentation. Transitioned all department reports from Excel and MS Access to SQL SSRS T-SQL in the .net environment using the Reporting Repository. Weekly meetings with project manager and upper management for discussion on current status of projects.

Confidential

Title: Systems Analyst

Responsibilities:

Worked with high level management on requirements, interviewed business groups for KPI specifications and worked with IT team to come up with a plan of data flow. Transitioned all company reports from Oracle Discoverer to Oracle Answers/Dashboard by creating reports, charts, pivot tables, graphics in Answers and populated Oracle Dashboard using the Oracle BI EE tool in a Web environment. Daily meetings with manager discussing current status on projects. Weekly team meetings with Director, Managers, DBA, ETL and at times department heads - presented current needs/requirements to the DBA and ETL developers based on prior discussions with upper management. Worked with the DBA and ETL developers to document data mappings using multi sources.

Confidential

Title: Systems Analyst

Responsibilities:

Managed/monitored Project Enhancement/Bugs Requests for the Commercial Department. Worked with IT from initial request to full implementation. Worked with Micro Strategies Department Business Intelligence handling conversion of reports from MS Access to MicroStrategies. Submitted Project requests for data implementation into Micro Strategies database for accessibility in reporting. Managed all Promotional Tracking reports, and modified existing reports. Created Ad-Hoc reports. Attended JAD meetings, gave the status of each project I worked on and asked for feedback from each department head on any prioritization changes based on new company mandates. Acted as liaison between the departments in reference to current projects.

Confidential

Title: Systems Analyst

Responsibilities:

Created many applications in MS Access utilizing multi-platform orientation/sources. Some simple some more complex One application saved the company fours hours of run time for a daily Aging report. The application I wrote had a run time of less than 3 minutes Wrote/modified SQL script. Created tables, queries, forms, reports and macros Conducted JAD meetings with non-technical personnel to gather KPI specifications to create data models and time lines for deliverables. Prioritized projects and managed time between discussions about the project. Designed flowcharts based off of workflow analysis. Designed and created the database, forms, and reports of the project to completion. Managed several projects at any given time. Criteria changed frequently requiring in-depth understanding for timely modifications and new projects being proposed requiring business planning and acumen.

Confidential

Title: Office Manager

Responsibilities:

Developed an MS Access Application that kept track of all business information on clients. Developed reports push a button on a form to retrieve data for business questions as .. How many clients do I currently have, How many clients have I lost to date, In what geographical area are most of my clients, What are the most popular plants that are purchased, Which plants or service make the most profit, produce a list of clients that have not paid current, etc. utilizing queries, forms, reports and macros.

Confidential

Title: Funding Reconciliation

Responsibilities:

Reconciliation in the Funding Department to rectify all funding related issues. Analyze/Research/ Backwards-checking and reconcile what's out of balance for 20 funders daily.

Confidential

Title: Systems Analyst

Responsibilities:

Created complex reports by writing SQL queries, using multi-platform orientation/sources. Installed, maintained, set up, configured and implemented Business Objects connecting to DB2/AS400 database. Developed/modified Universes Cubes . Hands on or walked clients through a complete install over the phone. Trouble shoot Business Objects report issues for over 120 different companies - compared data from the client's source DB2/AS400 database to Business Objects results while being aware of the client's crucial deadlines. Converted reports from Business Objects 3.x to 4.x to 5.x. Planned, compiled created , tested, and wrote the 'Implementation Manual Guide' for Business Objects. Made decisions of what information to include and the layout prior to the actual documentation. Ensured that purchased software was properly licensed, accounted for, and controlled to prevent unauthorized use or reproduction of program, and distributed security codes accordingly.

Confidential

Title: Systems Analyst

Responsibilities:

Application Senior Support for SalesLogix software. Investigated the underlying cause of incidents, and prevented them from recurring by communicating with the Developers to implement a structural change to the coding for future upgrades. Analyzed client issues by going directly into their data through net-meeting/pc-anywhere or requested client's database over the network to test and trouble shoot. Set up each client's database when necessary to analyze the data against the issue. Worked with Oracle, SQL, and Interbase databases. A process within the application, executed 52 scripts of code against a live DB. No one in the company at the time knew what these scripts did to the DB. All of the developers were no longer with the company I took it upon myself to research and test until I understood what each one did. Documented this in a knowledgebase article. Planned/decided what information to include. In my planning process, I took into account my audience - which were co-workers, business owners, business partners, database administrators and end users. Based on the diversity of the audience, an explanation of the SQL script and the benefits to each of the 52 processes were necessary in addition to the 52 separate scripts.

Confidential

Title: Systems Analyst

Responsibilities:

SDLC - Implemented an Administrative District Integrated System called SASIxp School Administrative Student Information cross platform from the ground up. Interfaced with software vendor NCS on issues concerning pricing or any currently known system/functionality problems encountered with SASI. Communicated these known concerns with Upper Management and End Users in an effort to prevent any expectations not met from escalating. Ensured that SASI was properly licensed, accounted for, and controlled to prevent unauthorized use or reproduction of program. Data conversion process: Worked with 'Old Vendor-AS400' and 'New Vendor-SASI' to insure data integrity. This involved decisions on what data to convert, how the data would be set up in the new system Tables/Fields and how they are joined recognizing differences between the old and new and planning accommodations. Gathering information from end users and compiling data expectations. Coordinated with upper management and the end user JAD to evaluate user report requirements and analyze software related issues and presented systems specifications with recommendations. Audited data after conversion making sure data is where it is expected to be and functions as designed by testing processes/reports against the Conversion/Implementation Plan. Created workgroups and users with security levels. Set up parameters within the system. Wrote, organized, and updated end user software training material and visual aids. Planned training documentation with consideration to my audience a technical dictionary, index, which subjects to cover, layout, testing, and a list of resources before publication. Scheduled and helped develop formal training classes for end-users. Conducted classroom style instruction for end-users. Created queries ad hoc reports .