Sr. Business Analyst Resume
Owings Mills, MD
SUMMARY:
- Lean Six Sigma Yellow Belt
- Certified Scrum Master
- Experienced in the creation of SQL queries, datamining and metadata discovery
- Proven background improving processes, requirements and positively communicating recommendations and strategies to manage data solutions effectively
- Adept Confidential developing and supporting analytics solutions, data transformations and reporting
TECHNICAL SKILLS:
SOFTWARE APPLICATIONS: Microsoft Word 2007/2010, Excel 2007/2010, PowerPoint2007/2010, Great Plains, SIMBA, Elite, Softpak billing, E - time, Lawson, Enterprise HR Version 4 (ADP), Oracle Business Suite ( iProcurement), CATS/Fulcrum receiving, NAM ( Confidential & Confidential -National Access Management) Database, Centralized Ticketing System (CTS), CASPR-milestone/activity management (Business Objects Reporting), PACE. Visio, Siterra, NORAD ( Confidential & Confidential Work Order Management System-Swiftrack), Salesforce, Field Scheduling Tool (FST) (Sprint), Primavera, Box (Sharepoint-like system). PACE, SharePoint, Harmony (project management system), Oracle SQL developer, Business Objects (Deski), Oracle SQL Developer, Fundsuite SX, R Programming
PROFESSIONAL EXPERIENCE:
Confidential, Owings Mills, MD
Sr. Business Analyst
Responsibilities:
- Create functional requirements documentation for Fundsuite SX (SaaS) database using Agile methodology and work closely with stakeholders to develop scope, assumptions and constraints of the project
- Manage project metrics reporting and all other pertinent project documents in SharePoint
- Communicate directly with project manager and dept. heads to ensure that current data warehousing and management processes are aligned
- Perform gap analysis to ensure that the required mechanisms are in place to achieve future state goals
- Review interim and end state diagraming to understand how data flow affects requirements gathering
- Gather metadata for all known UDTs to determine if the same data would continue be required once new database is stood up
- Verify with SMEs that the data analyzed is categorized properly and old UDTs can be eliminated
- Conduct performance tests on current databases to use as benchmark for performance for new system
- Create high level scoping, risk management tracking and lessons learned for UDT mini project created to analyze type, quantity and business use of current UDTs
- Use Microsoft Visual Basic to assess which systems each discovered macro accesses
- Create milestone tracker to assist with forecasting of TRP milestones and tracking of Deloitte team forecasting
- Create mapping from client dataset to TRP dataset for developers to begin creation of test data output
- Prepare week to week comparative analysis housed in SharePoint
- Work closely with business analysts, developers and database SMEs to ensure accuracy of requirements and develop timelines
- Monitor risk register and formulate “lessons learned” documentation
- Create process documentation and data flowcharts in Visio and Excel
- Create adhoc reporting as necessary project management, workflows,
Confidential, Baltimore MD
Business Analyst
Responsibilities:
- Produced daily reports for field services via Oracle SQL query via CCB database to determine number of inside/outside meter install jobs requiring rescheduling or meter exchange
- Produced daily, weekly and monthly metrics to determine appt. completion rates, gas leaks encountered, and missed appt. rates of installation contracting companies
- Generated reports from Business Objects (Deski) to update daily metrics, metadata and installation trackers
- Managed project metrics reporting and all other pertinent project data in SharePoint
- Communicate directly with program/project manager to ensure that current data warehousing and management processes are aligned
- Created SQL queries to provide real time statistical updates to management team
- Prepared week to week comparative analysis and update in SharePoint
Jr Project Manager
Confidential, White Marsh, MD
Responsibilities:
- Managed workflows/milestones in Harmony (MS project - style) database for non-customer impacting/minor customer impacting projects for internal stakeholders (marketing, finance, tech ops)
- Managed impacts of projects from other markets or divisions where there is an overlap or possible effect on deployment of projects or services regionally.
- Reviewed metrics to gauge how truck rolls are affected after product launch based on call volume spikes in call center
- Met with other division/market PMs and stakeholders to ensure that regional PMO requirements are being properly met and reported per project standards
- Loaded project metrics reporting and all other pertinent data into SharePoint database
- Stakeholder for Beltway region Spanish Packaging and Spanish Billing projects (June 2014)
- Project Manager for ongoing Beltway market channel change project and equipment returns project
Confidential
Project Analyst
Responsibilities:
- Managed dataflow process to/from CASPR/Pace application via SQL server
- Forecasted/reforecast milestones based on customer needs and estimated critical path completion per project staff updates using Excel
- Managed project metrics reporting and all other pertinent project data in SharePoint database
- Communicate directly with sponsor (program/project director level) to ensure that current data warehousing and management processes are aligned
- Created SQL queries to create daily reports from CASPR (client database) for both markets and provide trued up data to management team
- Prepared weekly comparative analysis of project milestone data to client database using Excel (vlookup)
- Updated management on deficiencies in data management processes and reviewed metadata for accuracy
- Corrected data load errors in both systems-client and company systems
- Trained staff on how to format data from one database to another and supervised daily csv data load
- Worked closely with SA staff to ensure forecast/ milestone completion date accuracy
- Created adhoc reporting as necessary
Confidential
Project Controls Manager
Responsibilities:
- Compiled performance analytics for turfing project and created stakeholder register
- Traveled to meetings to assist with preparation of project workflows as they related to database functions, OEM processes, and sponsor project requirements
- Determined sponsor requirements regarding forecast timelines, completion ratios, system requirements and reporting needs
- Managed input of BOM documentation into Norad
- Created OOMs through Norad for site acquisition and construction drivers quotes for purchase order creation from customer per site (single and bulk loads)
- Liaised directly with sponsor PM and CM regarding OOM review and approvals
- Created WBS for PMO staffers and for inclusion on work order requests and OOMs
- Served as designated Caspr SME (Scheduling tool) to facilitate milestone forecast dates management and actualization
- Trained project staff to use Caspr, Norad, Siterra and grant accesses as needed to these systems
- Created daily reports through Business Objects and SQL to manage project milestones and metadata
- Reviewed construction/site acquisition documents loaded into Box for accuracy before releasing submission packages to client
- Established B2B interface and created use cases to determine employee roles regarding systems accesses behind client firewall
- Created site closeout packages and lessons learned
- Evaluated team and individual performance
Confidential, Raleigh, NC
Senior Project Controls Coordinator
Responsibilities:
- Reviewed and submitted SERs (quotes) for subcontractors into FST (Field Scheduling Tool) for purchase order creation from home office
- Submit requests for contract excluded items (CORs) into FST for approval/purchase order creation
- Managed contract related documents in FST and Siterra (for Sprint)
- Reviewed daily entry of corporate finance team (Chicago) to assess if purchase order requests for CORs and SERs are being input timely for dissemination to subcontractors/ approved vendors in FST
- Reviewed billing exceptions for contractors in FST and approve documents and invoices when tasks/milestones have been achieved
- Participated in bi-weekly deployment meetings to assess best practices as required and recommend changes
- Worked directly with construction managers to assist in proper and timely submission of site documents
- Assisted project coordinators with training in FST and Siterra
- Lead change order document management project for DC and Baltimore markets
- Coordinated cowc actualization efforts with SAMs and CMs to ensure accurate loading of approved documents (photo sims, ZPs, BPs, structural, etc.) in the associated tasks/milestones daily
- Researched vendor aging as requested to resolve change order/po line item discrepancies in FST
- Compiled project analytics to quantify if adjustments are required to current processes using available BI methodologies
Confidential, Columbia, MD
Senior Project Coordinator (PMO)
Responsibilities:
- Compiled performance analytics for turfing project (consultancy)
- Reviewed contracts to determine risks and schedule constraints
- Managed and trained project coordinators on site acquisition driver exchange project in Norad
- Manage the “true-up” process for site acquisition completed sites for VAWVA Market project in Norad
- Traveled to meetings to assist with preparation of project workflows as they relate to database functions, OEM processes, and client project requirements (consultancy)
- Worked closely with database administrator regarding creation of module based on specific customer project needs and controlling data input into Salesforce (consultancy)
- Outlined customer needs regarding forecast timelines, completion ratios, system requirements and reporting needs (consultancy)
- Managed project metrics reporting and all other pertinent project data in SharePoint database
- Managed user access to client project management and financial databases
- Created OOMs through Norad for site acquisition and construction drivers
- Liaised directly with client PM and CM regarding OOM review and approvals
- Wrote work scopes for inclusion on work order requests and OOMs
- Created weekly queries and SQL uploads into Caspr (MS Project-like task management software) to manage milestone forecast date and task completion
- Created weekly reports through Business Objects to manage project milestones
- Responsible for coordination of B2B requirements and use case to build tunnel to access client systems and to integrate current BI methodologies used
- Created Confidential & Confidential workflows with Visio to disseminate to team (consultancy )
- Trained on Primavera due to possible upgrade of project management software
Confidential, Hanover, MD
Data Analyst
Responsibilities:
- Managed the NAM database (National Access Management) and tracker for 1161 site Ethernet project
- Organized data uploads and review milestone reports daily for accuracy
- Worked with internal software developers on CATS software to increase functionality/ease of use
- Updated site work ticket status in Centralized Ticketing System (CTS)
- Reviewed and track milestone activity in CASPR (activity management database) for sites actualized or overdue based on turf vendor and compare to Nam database
- Analyzed and reported scheduling issues and provided risk mitigation assessment to Project Manager
- Audited Statement of Work (SOW) completion items for recovery from Verizon
Confidential, Columbia, MD
Procurement Manager
Responsibilities:
- Supervised and trained procurement staff to use both CATS web and Oracle iProcurement for 775 site new build project and worked with systems developer on billing system prototype
- Processed all contract labor, switch and construction invoices through Oracle D-base and CATS/ Fulcrum.
- Worked directly with Budget Analyst to keeping invoicing/receiving risks within budgetary guidelines
- Forecasted monthly labor expense and requested contract approval for new or ongoing requisitions
- Created new contract approvals forms and requisitions for new vendors for approval by corporate legal department; request all back up documentation prior to submission
- Worked directly with vendors to assist in account reconciliation and billing guidelines training
- Coded and managed manual check processing for site applications, surveys and title work
- Worked closely with Site Development Managers and Construction managers with regard to partial and final site construction payment, vendor billing and site candidate changes
- Created processes and guidelines for managers and staff with regard to procurement functions
- Prepared EOM accruals
- Created receiving/requisitioning report through Oracle Discover Plus to create trending report in Excel 2007