We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

4.00/5 (Submit Your Rating)

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

We'd love your feedback!