SUMMARY: 

• Data Analytics, Business Analysis, EDI, Metrics Tracking, Dashboard Creation, Requirements Gathering, Process Improvement, Project Management, Procurement, Supply Chain, Insurance

TECHNICAL SKILLS:

 Microsoft Office 2016, Tableau, Power BI, SQL, Power Pivot, Power Query

PROFESSIONAL EXPERIENCE:

Business Intelligence Analyst

Confidential

• Developed executive level Balanced Scorecard, customer, and business group dashboards in Power BI
• Conducted requirements gathering sessions to capture business requirements
• Guided business users in conceptualizing additional views and reports possible with advanced BI solutions
• Converted desires of the business into detailed requirements artifacts
• Collaborated with development team in designing data model and determine ETL processes
• Developed and managed stakeholder communication and change management plans
• Oversaw UAT, ensuring requirements were met
• Trained senior leadership and support staff power users on system tools and processes
• Developed processes to manage key data sets utilizing Excel Master Data Services
• Initiated IT developers to develop appropriate structure in MDS
• Created detailed process maps and process documentation for support staff to manage master data attributes and entities

Business Analyst

Confidential

• Developed Tableau dashboards to track process performance and to provide visibility to client’s buyers, deployment leads, and leadership on deployment progress
• Conducted requirements gathering to identify customer needs
• Established direct connections to Oracle databases
• Developed logic to join multiple tables
• Developed and published series of interactive Tableau dashboards
• Pursued better data visibility by establishing direct connections to Electronic Data Interchange (EDI) network data, and created dashboards and reports showing current connectivity status for all client facilities and suppliers
• Engaged IT to gain access to Oracle tables and mainframe data sets
• Collaborated with client ETL experts to develop queries and appropriate data staging
• Assisted in development of Maturity Model Assessment for the EDI/Shipping Label onboarding process
• Developed process mapping and operational metrics, and identified operational gaps and corrective actions
• Identified process inefficiencies and developed corrective actions plans
• Identified ticket progress was unnecessary delayed by two weeks due to system constraints. Met with developers to understand cost to fix. Presented issue and cost to client. System fix will be implemented in Jan 2016 with minimal cost.
• Secured service level agreement with service center to provide support to the EDI/Shipping Label onboarding process
• Identified need for additional support resources and pitched client the cost and benefits of engaging the service center
• Conducted time studies for each workflow to understand volume of work and estimate cost
• Drove work towards Infosys center by leveraging team’s unique position with language capability and work day time zone overlap.
• Conducted ad - hoc analysis
• Development of 2016-2018 EDI/SP20 and Assurance of Supply Center Program Greenbooks
• Conducted capabilities assessments for regional deployment managers
• Led design, development, and launch of global database system to track and report cost savings projects
• Managed requirements gathering sessions and stakeholder reviews
• Developed prototypes
• Managed testing matrix, communication plans, and change log
• Oversaw development work, ensuring developers adhered to budget, timeline, and requirements outlined in SOW
• Developed data migration plans to new system, ensuring a seamless transition to new database and reporting tools
• Created training tools and delivered WebEx and classroom style training
• Conceived of and implemented process efficiencies, reducing the need for 4 client FTEs which saved $1M during the two year reporting cycle
• Represented team in three internal audits of the process and database. Database earned the “Gold Standard” designation from client’s internal auditing team
• Secured service level agreements for Pune and Poland Infosys teams to work supplier onboarding tickets for client
• Identified need for supplier onboarding transactions work, and engaged service center supervisors to discuss bandwidth and resource capabilities
• Pitched program to client and secured signing of SLAs
• Developed Standard Work and Process Mapping
• Oversaw team’s progress, escalated issues to client as defined in standard work, and held monthly governance meetings with key client representatives.
• Developed monthly reporting packages for Directors and Chief Procurement Officer detailing cost savings projects related to recent acquisitions
• Assisted client’s accounting and business resources teams to complete the PIA (Post-Implementation Assessment) following the closing of a large acquisition and integration
• Collaborated with Treasury to execute the supplier payment terms standardization program
• Conducted data analysis on legacy suppliers and developed prioritization sequence of payment terms conversion
• Identified additional $20.9M in cash flow opportunity through examination of additional legacy facilities with spend from suppliers already converted to standard terms, yielding significant additional cash flow
• Engaged IT to develop automated reports to assist process teams in their monthly reporting
• Assisted in development of M&A best practices and the Integration Playbook
• Conducted initial data analysis on new acquisitions and developed interactive Tableau reports revealing potential synergy savings and data cleanup needs.
• Engaged recently acquired company’s IT division, and provided required data points
• Validated IT’s data reports met specifications
• Blended data with client data (suppliers, part categories, etc)
• Developed Tableau visualizations detailing each category’s spend, suppliers, potential cash flow benefit, and potential synergy savings
• Developed reporting packages, processes, and databases to conduct monthly Direct Material Cost Reduction (DMCR) analysis for the Global Mining facilities
• Assisted client with the 2014 World Wide Supplier Meetings
• Developed database to track attendees
• Secured SLA with client to engage Pune service center to manage data entry and generation of supplier attendee dossiers, which were distributed to all client’s leadership in attendance

Quality Assurance Lead/Editor

Confidential

• Performed QA on physician reviews of disability, FMLA, and medical utilization cases, ensuring reviews and determinations were accurate and met client requirements
• Developed dashboard to track group’s performance metrics
• Increased division’s accuracy six points to 99%, ensuring the renewal of key high volume contracts
• Coached team members on methods to improve their efficiency and accuracy

Product Improvement Analyst

Confidential

• Managed data analytics for Caterpillar’s Dealer Solution Network - a Microsoft Dynamics application for the dealer’s technicians to seek resolution on product issues
• Assisted numerous Six Sigma projects by data mining system to assist in continuous product improvement and new product introduction programs, most notably Caterpillar’s Tier 4 engine development
• Monitored process KPIs and delivered reports to product managers
• Compiled support volumes, ticket completion times, and first pass resolution data and created reporting packages for each product group

Technical Communicator II

Confidential

• Business Analyst for development of application to track insurance product life cycle
• Conducted requirements gathering with impacted teams (actuarial, claims, legal, marketing, sales)
• Developed process mapping
• Managed all requirements artifacts and oversaw developers’ work
• Managed UAT and training
• Managed product documentation
• Maintained product specifications in both mainframe and Windows-systems, ensuring product parameters kept up to date with federal and state guidelines