We provide IT Staff Augmentation Services!

Sr. Business Intelligence/process Analyst Resume

5.00 Rating

Moorestown, NJ

SUMMARY

  • My job is to make my boss’ job easier I am an experienced professional with over 15 years of experience in Financial/Business Intelligence/Data/Systems analysis, monitoring, and management.
  • My objective is to obtain a junior leadership position with a reputable organization utilizing my technical skills and business experience to add to the growth and success of the company.
  • I am dedicated to lifelong learning and wish to provide guidance and support to co - workers and team members.

TECHNICAL PROFICIENCIES:

  • SAP Asset Management
  • Controlling
  • and Project Support modules
  • Hyperion reporting
  • Business Objects
  • Excel
  • MSPower BI
  • MSWord
  • PowerPoint
  • Access
  • Visio
  • Essbase
  • Oracle
  • Brio Reporting
  • Salesforce.com
  • Accuate Reporting
  • Webfocus
  • OnePos
  • SharePoint
  • Great Plains Dynamics
  • PeopleSoft
  • FRX Financial Reporting System
  • MAS 500
  • Tableau Business Intelligence
  • Quickbooks Pro 2011
  • Amdocs (CSG) Billing
  • DST Billing
  • JD Edwards
  • NOVO
  • Daptiv
  • Jira
  • Confluence
  • various billing systems
  • internet and e-mail applications

PROFESSIONAL EXPERIENCE

Confidential, Moorestown, NJ

Sr. Business Intelligence/Process Analyst

Responsibilities:

  • Provide month, quarter, and year end support to Finance and Accounting teams with revenue recognition, profit center moves, cost center hierarchy maintenance, expense reporting via project workbench structures, and other issues that need technical support
  • Provide tier 2 technical support for CES SAP application group for the Asset Management, Controlling, and Project Support modules in support of various business units within the corporation
  • Handle day to day administration, monitoring and support of SAP infrastructure and system issues
  • Tracking and handling customer support issues and responses via the ITSM/Remedy ticketing system
  • Develop and maintain policies and procedures for CES SAP and Hyperion support groups
  • Manage and maintain automated business intelligence tools and reports
  • Working with on and offshore development groups with testing and implementing new business units being brought on to the SAP system
  • Assume other duties and responsibilities as directed by senior management

Confidential, Mount Laurel, NJ

Sr. Business Intelligence/Data Analyst (Consultant)

Responsibilities:

  • Lead teams of business and technical analysts in initiatives focusing on Data Warehouse and Business Intelligence solutions
  • Supervised 4 junior IT Data/Business analysts in building Tableau dashboards and pulling data from various tables to assist in reporting for support teams and business units
  • Developed a deep understanding of the technical model and how technology and systems store and process data in support of business objectives
  • Working with business leaders and end users to determine requirements and document use cases
  • Using strong SQL skills to explore and profile data
  • Developing and delivering documentation and business specifications to the data warehouse and Tableau technical teams
  • Developing testing strategy and conduct appropriate testing to identify and resolve data quality issues

Confidential, Philadelphia, PA

Sr. Financial/Business Analyst (Consultant)

Responsibilities:

  • Managed the documentation of desk level procedures by eliciting and capturing process details in a model form using company approved tool sets
  • Publishing deliverable content to business unit for review and approval
  • Transcription of process models into desk level procedures for reference by upper management and functional business areas
  • Establishing and maintaining business rapport with functional areas and business units to ensure process documentation expectations are met
  • Analyzing workflow models and ensuring alignment of developed desk level procedures with process details
  • Validates processes and desk level procedures that satisfy the business unit’s needs by demonstrating desk level procedure usability

Confidential, Philadelphia, PA

Sr. Financial/Business Analyst (Consultant)

Responsibilities:

  • Responsible for pulling data from JD Edwards and in-house CRM systems into Excel or Access databases to find root causes that ultimately result in low profit margin.
  • Gathering information from the financial analysts based in the United Kingdom and other parts of the United States to determine ways to increase profitability
  • Daily customer contract review to determine if pricing is conducive to costs of services

Confidential, King of Prussia, PA

Sr. Business Analyst (Consultant)

Responsibilities:

  • Providing system support to the roll-out of new Front Team processes and procedures
  • Acting as a liaison between theFront Door team and Delivery Services Chief of Staffand the user community, including gathering user requirements
  • Delivering complex reports to meet business requirements, includingDaptiv report development usingCognos 10 and custom reports using Excel to pull data from Daptiv and cross referencing the data using Access to merge and simplify the output
  • QA Testingof configuration and functionality changes to the tools
  • Contributing to the implementation of improvements in standard solutions and processes
  • Managing user facing release projects across all project delivery systems of record
  • Responding to user questions, including providing one-on-one demos as needed

Confidential, Philadelphia, PA

Sr. Business Analyst (Consultant)

Responsibilities:

  • Supporting wireless business operations teams, business partners, corporate departments and field business units
  • Purchasing necessary equipment for sales portals, retail store outlets, and call centers
  • Asset tracking, maintenance scheduling, and reporting
  • Planning and executing sales portal order audits, researching escalations, and order entry testing, troubleshooting, and data modeling
  • Presenting system problems and test plans to project stakeholders using MS PowerPoint and Visio
  • Investigating technical billing system issues reported by various sales, customer service, and corporate deployment teams
  • Providing reports to upper management using Oracle SQL, MS Access, and Excel to pull and analyze data that shows the effectiveness of sales promotions and quarterly campaigns. Techniques for pulling and analyzing data included: Excel match, lookup, and pivot table functions to gather, sort, and simplify the dataset while using Access to cross reference and merge the Excel data pull. SQL Server Reporting Services were also used to pull data from various billing systems to produce management reports
  • Created and published Tableau dashboards for senior level management that measured weekly key performance indicators such as: service order fulfillment, revenue generated by field and inside sales reps, customer retention, product performance by region, call volume tracking
  • Writing technical and operational business requirements and documenting business processes
  • Routing Tier 2 tickets to the appropriate escalation teams
  • Testing new offers, campaigns, and promotions to ensure proper discounts are applied to orders
  • Troubleshooting and escalating outage issues
  • Ad Hoc reports and support as requested

Confidential, Columbia, MD

Government Contract Manager (Consultant)

Responsibilities:

  • Managing government contracts procured by BCC-writing proposals, setting the pricing, signing contracts, monitoring contract services and payments
  • Liaison between BCC and various local and state government contracting offices
  • Compliance-Ensuring BCC meets it’s government contract requirements
  • Tracking project expenses and ensuring invoices are paid accurately and on time

Confidential

Workforce Analyst

Responsibilities:

  • Workforce management and reporting for all call center and agent performance metrics using Excel macros and various other Excel functions
  • Providing daily scorecard reporting involving total call volume and call volume per rep, average handle time (AHT) over all and per rep to determine reps needed per half hour intervals during the day.
  • Implementing new and revising old policies and procedures for data reporting and workforce management
  • Monitoring call center supervisor performance for quality assurance and coaching for all call center agents
  • Collecting and distributing service request, call data, and ad hoc reports for various city of Philadelphia departments including: the Mayor’s Office, Streets Department, and the Department of Licenses and Inspections
  • Staffing recommendations and overtime requirements based on call volume
  • On-call 24hrs during emergency weather events to assist the Office of Emergency Management with vital information regarding citizen concerns and disaster related data
  • Reviewing and monitoring civil service contracts for workforce compliance
  • Supervising a team of customer satisfaction surveyors and reporting outcomes

Confidential, Philadelphia, PA

Sr. Financial Analyst

Responsibilities:

  • Extensive use of Excel and Access to extract data from Oracle 11i to do forecasting and operational reporting
  • Conducting complex financial analysis for new and existing projects and reporting
  • Preparing financial reports and recommending improvements in financial reporting systems and processes
  • Conducting audits to ensure financial controls are maintained
  • Performing day to day billing functions for Field Case Management
  • Serving as the lead biller and maintaining responsibility for coordinating with team members to ensure quality and timelines are met

Confidential, Wynnewood, PA

Finance Billing Analyst (Consultant)

Responsibilities:

  • In-depth analysis of vendor invoicing essential to the main business operations-telecom lines, cable, and internet services using Excel macros and various other Excel functions
  • Paying vendor invoices for data lines, telecom lines, and cable services
  • Analysis of vendor and subscriber accounts, invoices, and contract pricing involving over $300k in monthly billing
  • Ensuring vendor invoices are paid and charged to the proper departmental accounts
  • Monitoring call-center service level goals and recommending process improvements
  • Presenting Cost vs. Revenue analysis results to Finance VP with recommendations for improvement
  • Submitted purchase order requisitions to upper management for approval
  • Entering purchase order detail in Oracle to create blanket or line by line orders
  • Monthly reporting of outstanding purchase order expenditures vs. actual expenditures, accruals
  • Special talent for pulling data from several databases and tying it into one comprehensive report to give upper management a complete picture of the performance of various aspects of the business
  • Taking advantage of cost cutting opportunities and make recommendations to improve business operations where needed
  • Subsidiary tasks include: contract review and summaries, billing system audits, small project management, and ad hoc reporting as requested

Confidential, Oak,s PA -

Project Analyst

Responsibilities:

  • Providing capital reporting to middle and upper level management and tracking capital spending for a budget of over $500m annually for the Eastern Division
  • Initiating and tracking purchasing for all Eastern Division projects
  • Lead eWorkflow CAF/CAR authorization project implementation for the entire Eastern Division
  • Designed the entire routing flow using Microsoft Visio for the departmental, region, and division levels
  • Monitoring capital budget status utilizing various reporting tools such as Essbase, Brio, and Oracle
  • Monthly call-center service level reporting for the five regions in Confidential ’s eastern division
  • Weekly monitoring of service level goals including the scheduling of account executives for proper telephone coverage, scheduling breaks and lunches for the account executives, monitoring the call volume to ensure proper call coverage for 24 hour call centers
  • Troubleshooting and resolving issues pertaining to Cable Data and CSG billing systems
  • Configuring all online billing rate codes to provision correct QOS for HSD customers
  • Organizing national online services and promotions and coordinating those efforts with the local MIS contacts
  • Managing the Service Code Tool for all Cable Data and CSG markets involving HSD,CDV and Video codes
  • Conducting monthly audit of rate codes
  • Creating multiple reports to monitor rate code usage and abuse
  • Regularly attend meetings with various groups including Marketing, Finance, and Engineering to provide input that will support the operational development of new products
  • End-to-End testing for bootfile speed of new products or enhancements
  • Working closely with all departments within Confidential Online by providing reports as needed from the Cable Data billing system
  • Other responsibilities include developing and writing operating procedures for the department, and cross-training group members

Confidential, Horsham, PA

IT Financial Analyst (Consultant)

Responsibilities:

  • Administrator to CIMS server monthly allocation reporting system
  • Coordinated with all levels of management to develop department budgets and controls
  • Performed activity based cost allocations
  • Analyzed budget variances and presented performance information to department Managers and the CIO
  • Managed monthly reporting process to accounting and internal departmental groups
  • Participated in case studies that analyze company-wide cost saving opportunities
  • Communicated with business unit leaders regarding cost allocation and planning
  • General Ledger analysis using MAS 500 accounting system

Confidential, Philadelphia, PA

Financial Analyst/Accountant

Responsibilities:

  • Maintained Event Profitability System for monthly management reports by building expansive spreadsheet models
  • Calculated the Economic Impact each event had on the city of Philadelphia
  • Generated monthly Flash Reports for Senior VPs, VPs, and department managers using FRX Financial Reporting System
  • Performed budget variance analysis and assisted management in yearly budget process
  • Designed and Maintained travel expense reporting process by using Access and PeopleSoft
  • Performed trend analysis and financial forecasting for short and long term objectives
  • Involved in monthly close process including:
  • Journal entries for Accounts Receivable, Accounts Payable, Gift Shop sales, Bank Reconciliations, American Express expenses and reimbursements, chargebacks, expense accruals, also re-classes and depreciation schedules when necessary

We'd love your feedback!