Analyst Resume
5.00/5 (Submit Your Rating)
Warren, MI
SUMMARY:
- Self - motivated, easy to get along with, focused, proactive, dedicated professional that is skilled at multi-tasking and troubleshooting complex problems, who operates with integrity and is an effective team player with excellent communication skills and attention to details along with the ability to meet deadlines, improve productivity, reduce expenses, and enhance levels of service.
TECHNICAL SKILLS:
- Microsoft products including Excel
- PowerPoint
- Access
- Word
- Project
- Visio
- SharePoint
- OneNote and Lync
- QuickBase
- R1
- SQL Training
- Comet
- WebCenter
- SAP SD/FICO/MM modules
- GroupWise
- Outlook
- Imagemaster
- Dreamweaver MX
- IDU knowledge of Oracle
- Six Sigma and PMP training.
PROFESSIONAL EXPERIENCE:
Confidential, Warren, MI
Analyst
Responsibilities:
- Responsible for contracting analysis for numerous medical health insurance payers for the hospitals, employed physicians and behavioral health facilities under Confidential in Michigan, Washington, DC and Maryland. This also includes Medicaid and Medicare.
- Conduct analytics and ad hoc reporting around provider reimbursement and the health plans for individual hospitals.
- Perform contracting and financial analysis to support the regional lead for the Managed Care Center of Excellence.
- Create R1 system contract modeling requirements for insurance payer contracts and reimbursement criteria to enhance negotiation savings. Perform QA auditing on contract models.
Confidential, Okemos, MI
IT Controlling/Senior Business Analyst
Responsibilities:
- Gathered requirements and documentation, implemented new processes to increase efficiency and revenue, and quality controlled process checks to confirm adherence to business requirements.
- Prepared IT project budget, actuals, forecasts, variances and performed monthly close. Analyzed monthly billings from and to internal TK businesses, financial statements and P&L. Streamlined month end close accrual process.
- Implemented and prepared financial and other reports by collecting, analyzing, trending, and quality controlling information, IT SLA contracts, and cost.
- Assisted in the development and monitoring of policies to ensure adherence to compliance requirements.
Confidential, Southfield, MI
Strategy, Planning and Business Analyst
Responsibilities:
- Contributed to development and implementation of the Phase II & III Financial Pre-Spend SharePoint sites and spend approval workflow processes, documented business requirements and performed quality UAT testing and test scripts.
- Produced training material and conducted training to the entire IT Enterprise Architecture & Infrastructure (A&I) organization on the new Pre-Spend SharePoint site and approval workflow processes.
- Managed $76M ITO A&I budget for G&A and facilitated capital spending requests. Tracked and monitored costs within the new IBM ITO Managed Services contract including budget, forecast, actuals and variances. Resolved budget issues with appropriate parties.
- Contributed to reducing the budget by $4.4M. Discovered $1.4M of hardware mischarged to tax account.
- Managed and tracked server assets and associated G&A items. Reduced extended maintenance charges by two months that saved approximately $20k per year.
- Provided ITO A&I support with new SAP MM operational standards, consulted on requisitioning and on the new IBM Managed Services contract parameters.
- Identified and implemented opportunities to streamline A&I processes with adherence to compliance requirements.
- Developed new processes/policies, documented business requirements and tools in pursuit of business process redesign that helped minimize organizational cost.
- Prepared analysis for key contract renewals including requirements gathering, meeting coordination, and creation of executive presentations.
- SharePoint administrator for the Financial Pre-Spend and the A&I Planning SharePoint sites.
Confidential, Sterling Heights, MI
Senior Financial Analyst / IT Portfolio Manager
Responsibilities:
- Managed and oversaw all IT project finances for the organization under IRM’s PMO. Met with business stakeholders to identify business needs and objectives and implemented PMO operational efficiencies.
- Resolved IT project financial issues by discovering and bringing resolution to $250K of provider billing mischarges in 2013, $977K in 2012, $531K in 2011 and $442K in 2010. Recovered $400K pure savings to the company.
- Contributed to reducing budget by $4.2M in 2013, $2.3M in 2012, $10M in 2011 and $6.3M in 2010.
- Produced monthly IT project budget, forecasts, actuals and variance reports for management, IRM team and business functions. Reported and tracked $2.5M of Six Sigma IT cost savings and open issues. Managed accruals.
- Approved all computer material purchase requests (CMRs) for hardware and software worth $690K annually. Created metrics to show various views of cost and cost savings, project status, CMRs, etc.
- Managed the return of 1,500 terminated employee assets across business functions to the IT service provider with a cost savings of $85K.
- Analyzed and remediated 1,100 IT Local Admin security audit findings down to 83 that received positive re-audit ratings. Also, provided analysis, increased process efficiency, consolidated activities and wrote procedures for local admin privileges and active directory. Performed software cleanup activities and application attestation reviews.
- Supported IT Managed Services contract negotiations, analyzed labor and hardware and software maintenance data, created schedules and documents to support GDLS’ position, managed legal contract document control and performed financial analysis surrounding MS and Time and Materials (T&M) contracts.
- Contributed and provided business requirements to the pre-implementation of the Supplier Relationship Management software project. Contributed to continuous improvements by maintaining, creating and evolving IRM processes.
- Performed Microsoft Access administrator functions.
Confidential, Rochester Hills, MI
Financial Analyst
Responsibilities:
- Assisted with transfer of Corporate Controlling ITO functions and knowledge from IL to MI for reorganization due to acquisition of Gedas ($720M company). Also, assisted with implementation of new SAP system changeover.
- Performed financial analysis and contract management for desktop and computing contracts and projects.
- Generated $13M per month of invoicing for variable, fixed and T&M contracts. Discovered and recovered $350K of additional revenue and $20K of freight charges from customer.
- Performed month end analysis of P&L, created monthly reporting and assisted with forecasting.
- Designed and implemented process for tracking $41M of costs which also reduced PR redundancies and dollars spent. Created reporting and performed analysis on temporary staffing worth up to $1.3M.
- Designed and implemented process and quality control measures for managing contracts and invoicing. Increased efficiency and effectiveness of revenue generation, customer service and SOX compliance.
- Wrote and updated process flows and controls per SOX standards to pass audit.
- Created accruals for unbilled revenue, WIP, deferrals, amortizations, costs and managed account reconciliations. Suggested and implemented different account numbers for revenue and costs accruals, which decreased time spent and made month end analysis more efficient for entire ITO division.
- Assigned, created and edited WBS element/project numbers and contracts in SAP.
- Trained others and delegated work as needed. Also, performed as interim SAP SD super user.
Confidential, Detroit, MI
Program Financial Analyst
Responsibilities:
- Assisted financial consulting team with global ad hoc financial reporting, tracking, consolidating and administrative work to ensure smooth operations for GM client and Confidential .
- Consolidated PR vs. PO completion status report worth $1.2B and tracked major issues for escalation.
- Maintained $10M forecast and actual for consultant service fees and produced leadership presentations.
- Investigated and reported on the status of 333 ADS applications listed as retired in client’s tracking system to eliminate vendor’s billing.
- Served as focal point for approved change controls with pricing impacts. Tracked and reported on status of the global service contracts’ pricing re-alignments, quality assurance completion and supplier agreement to re-alignments.
- Reviewed, consolidated and prepared Confidential status reports for client.
- Built supplier invoicing calendar that fed into client’s internal financial calendar, assisted with building supplier survey and consolidated supplier issues.
Program PMO Financial Analyst
- Financial Analyst and SME for $52M Budget for 2006 MSA Program.
- Assisted GM’s program leadership with budget and forecasting which reduced budget by $15M.
- Prepared monthly financial reports and variance analyses, collected financial data, reviewed and processed financial information. Advised PMO and program leadership on financial status and consulted as needed.
- Prepared year-end financial summary and performed quality assurance checks.
- Assisted with planning, structuring and mapping 2005 financial budget allocations to new 2006 financial budget allocations and created budget spreadsheet templates for various financial reporting views.
- Acted as first point of contact for PMO to suppliers and GM staff and investigated, resolved or escalated issues to appropriate parties.
- Coordinated 2006 program status meetings, created agendas and presentations and posted minutes and other correspondence to Quick Place.
- Entered On-Off boarding/NDA tracking into Access supplier/consultant database and produced status reports.