Resume

Sign in

Data Analyst

Location:
Oswego, Illinois, United States
Posted:
April 30, 2018

Contact this candidate

Resume:

Phone: 630-***-****

Email: ac5ao0@r.postjobfree.com

LinkedIn: http://www.linkedin.com/pub/mary-west/20/b79/955

Mary L. West

*** ******** *****

Oswego, IL 60543

Summary:

•Accomplished professional with extensive experience in business analysis, UAT testing, data analysis, project management.

•Translated business needs into design documents and specifications; analyzed cross-functional requirements and interrelationships of systems to identify dependencies and potential issues.

•Performed and developed UAT, System, Integration, and regression test scripts; executed and wrote test cases and stories using SQUID software; HP ALM, and JIRA software.

•Responsible for gathering, analyzing and defining business requirements; develop requirements documentation that meets the strategic information requirements of cross-functional departments.

•Strong SQL skills (against SQL Server Relational DBMS) for test cases requiring Data Validation and SQL scripts for data conversions and mapping of the key data elements.

•Document detailed, functional business descriptions of system deficiencies, user needs, program functions, and steps required to develop and / or modify technical-related technology systems.

•Advanced experience of ten years with pivot, V-Lookup, Index Match, Macros and VBA programming skill with EXCEL.

Led 50 million dollar implementation with a team of eight for the SDLC for the financial modules and using Hyperion analytics and financial modules AP, AR, GL, and Purchasing/POS.

Proactively collaborate with the cross-functional departments to identify potential process improvements and enhancements that increase efficiencies and decrease costs.

Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.

Technical Skills:

Software: Knowledge of Sales force, Crystal Reports, SSRS, SAS,SSIS, MS Office 2003/2007/2010/2013, SSRS 2005/2008, AGILE and WATERFALL Methodologies, MS SharePoint, Outlook, MS Office Suite (Excel, Word, Access, Power Point, Qlikview, MS Project, QuickBooks, BPCS, JBA, JD Edwards, International Software, Remedy, Hyperion, Cognos, Implementer, Infinium, JDA Retail Software, ITIL, DFU, DBU, AS/400 Query, SQL, PDM, JIRA, Lotus 1-2-3, Symphony, DB2, Lotus Notes, VB V6.0, Citrix, Visio, SAP Business Objects Intelligence, Info view, SAP, Citrix, AQUA/Paraccel, BPMN, GUI, WEB based software, Oracle, HP Quality Management - ALM, SQUID, SAS, Hyperion BRIO Query and JIRA.

Platforms: SQL Server 2003/2005/2008/2012, Windows Server 2003/2008, Windows NT/2000/XP/Vista/7, MSDOS, Unix/Linux, IBM AS/400, RS/6000, HP/9000.

Languages: SQL, Sequel, VBA, EXCEL macros, RPGIII, RPG/400, RPG IV, ILE, C, C++, ASSET, html, net,xml, Java J2EE

Education:

•B.S. Accounting, Elmhurst College

•MBA Finance, Graduate Courses, NIU

Professional Experience:

CDK Global Services, Inc. – Senior Project Manager Jan 2018 – April 2018 Leading various projects in the EPMO Department related to their Automotive Technology Software.

Worked in the IT PMO office

Develop a Business Case

Undertake a Feasibility Study

Establish the Project Charter

Appoint the Project Team

Set up the Project Office

Perform Phase Review

GE, Remote Position – Business Systems Analyst/Data Analyst/PM - (Contractor) Jul 2017 – 12/31/2017

GE Energy Management

Support the SIC (Sales Incentive Commission) Team: with data analysis in EXCEL, R2 calculation, YOY, baseline

Complete Orders and Sales Baseline calculations

Run comparisons on financial outcomes

Organize and analyze large volumes of data provided by the SIC team

Outline and execute feasibility to determine gaps in systems and delivery of data processes

Administrator on the SharePoint site and sharing of Team information

Created pivot tables to describe analysis using graphs and charts.

Use both structural and descriptive Meta Data.

SAP backend to Tableau; downloaded data from Tableau into EXCEL

Ran data integrity reports in SSRS to verify the data

Sampos Canopius US Insurance, Chicago, IL Apr 2017 –Jun 2017

Implementation Business Systems Analyst/PM/Data Analyst - (Contractor)

•Undertaken data conversion responsibilities from their Intech to Insurity cloud-based software.

•Strong EXCEL analysis work doing trend analysis, business cases, diversity reporting, and risk assessment of the acquired Sprint stores.

•Responsible for Data dictionary, data mapping, SQL development for data quality reports.

•UI design for the end user to work remotely and on their mobile devices.

•Supported Cloud based applications including SAP Financials

•Used to analyze the Descriptive and Structural Metadata from various sources.

•Supported the SAP Financial applications.

•Worked closely with the business and IT groups.

•Developed requirements, configured systems, created and executed test scripts. Developed use cases.

•Created in Visio process flow diagrams from the old system to the new system.

•They had various types of Meta Data, which consisted of structural, descriptive and administrative types of data.

PNC Bank, Chicago, IL Oct 2016 – April 2017

Business Systems Analyst / Data Analyst/ Metric Report Developer (Contractor)

Extract large data from Tableau to Excel, pivot table, vlookup, PowerPoint

•Responsible for transformation of loan processing procedures

•Involved in Demand and Supply Planning systems implementation and development of the finance flows, mortgage product flows, and the finance process information flows. Worked heavily with Black Knight, supplier of their new “LOS” – Loan originator vendor software. Development of use cases and test cases in HP ALM.

•Strong EXCEL analysis work doing trend analysis, business cases, diversity reporting, and risk assessment.

•Responsible for demand management as far as managing the processes that are concerned with balancing end-user’s' requirements with the capabilities of the supply chain for the new software implementation.

•Planned the process flows using Visio and the application through the SDLC.

•Worked with end stakeholders for process improvement and project coordination of tasks and issues

•Responsible for trending and statistical reporting for gap analysis of their loan processing teams divided by departments

•Metrics and report development for their Home Lending department for mortgages of all types

•Ran SQL queries in HP BRIO database to analyze and manipulate data.

•Worked with Commercial Loans department to improve the overall process of processing a mortgage

•Re-engineered the process flow of their mortgage lending.

•User Interface on their new software Empowered to work on mobile devices and remotely.

•Supported the SAP Financial applications. And other Meta Data to do analysis.

Canadian Railway, Montréal, Canada Feb 2016 – Sep 2016

Sr. System Integration Business Analyst/ Data Analyst/PM – (Contractor)

(On the PTC - Positive Train Control Project)

•Responsible for System development of use cases, integration testing, Segment/Component Testing, Nearest-Neighbor Testing, End-to-End Testing, QA Testing

•There were four segments: Back Office Systems, ITCM (Communications), On-Board Locomotive, and Wayside systems

•Data governance of the metadata and risk management of the data.

•Create EPICS stories in JIRA.

•Documented the four segment’s process flow of information using Visio

•Took the testing through the whole SDLC and did the documentation for requirements, functionality, and technical

•PTC Analyses, a major part of the requirements for the contents of the Product Safety Plan (PSP) was “validation and verification.” Validation involved a number of analyses that have been outlined in that section, verification involved data collection, performance evaluation and product refinement. The results of this process were also expected to be included in the PSP submitted to FRA for approval.

Office Depot, Itasca, IL Oct 2015– Dec 2015

Sr. Business Systems Analyst /Metric Report Developer – (Contractor)

Heavy usage of Microsoft Excel to build analyses for the purpose of loading diverse VBA scripts for data uploads.

•Translated business needs into design documents and specifications. Analyze cross-functional requirements and interrelationships of systems to identify dependencies and potential issues. Created Visio process flow diagrams

•Proactively collaborated with the cross-functional departments to identify potential process improvements and enhancements that increase efficiencies and decrease costs.

•Assisted with the Data Model for financial information for Office Maxx and Office Depot

•Responsible for trending and statistical reporting for gap analysis

•Developed reports in SQL and Paraccel

•Used various systems’ Meta data to do report ability, consolidations, and analysis.

•POS systems and software to do the analysis and resolution of payment disputes.

BMO Harris Bank, Naperville, IL Jul 2015 – Sep 2015

Sr. Business Systems Analyst /Metric Report Developer/ Data Analyst – (Contractor)

•Data models, data definition tables, procedure manuals, etc. via Visio, Excel, and external data modeling software.

•Transformation of West Allis, Wisconsin for their loan processing procedures and Cash Management

•Worked with their commercial lending department to for their transformation into regions

•Worked with end stakeholders for process improvement and project coordination of tasks and issues

•Responsible for trending and statistical reporting for gap analysis of their loan processing teams divided by communities. Created process flow diagrams in Visio for the presentation to upper-management

•Lean Tool Assessments done on the community meetings using ETL methodologies

•UI design for the end user to work remotely and on their mobile devices. Support

•Cloud based applications including SAP Financials

•Supported the SAP Financial applications. Worked closely with the business and IT groups in IT.

•Developed requirements, configure systems, create and execute test scripts.

AbbVie, Deerfield IL May 2015 – Jun 2015

Sr. Business Systems Analyst /Project Leader – (Contractor)

Heavy usage of Microsoft Excel to build analyses for the purpose of loading diverse VBA scripts for data uploads.

•Mobility Team for a global roll-out of MDSL telecom expense software

•Initiated a Playbook for the Mobility Team on a global basis and project coordination of responsibilities

•Global MDSL telecom expense reimbursement interfaced with the SAP financial modules

•Designed and implementing business processes utilizing VBA coding via Excel.

Y-USA, Chicago, IL Mar 2015 – May 2015

Sr. Business Systems Analyst – (Contractor)

•Worked with Data Management team to develop a Data Warehouse to store the data from the 2700 Ys.

•Developed business cases for financial analysis, financial modeling, trend analysis, and diversity reporting for all of the Y’s in the Data Warehouse

•Executed data mining, data cleansing, data profiling and data mapping of key data elements of their non-integrated systems

•Created Visio process flow diagrams for the presentation of the flow of information to upper management

•Worked with the Business rules for the data mapping and functionality of the Metadata.

•Drove root cause analysis on data quality issues, potentially identified and escalated from lines of business and IT

Sears Holding, Hoffman Estate, IL Oct 2014 – Jan 2015

Sr. Business Systems Analyst – (Contractor)

•Backfill three month contract in the MSO (Members Services Organization) – Business Intelligence

•Created custom ecommerce solutions for clients and then monitored client progress

•Wrote the “Business Requirements/System Design “documentation to automate their Dialer system for their point-of-sale web based system

•Worked heavily with the off-shore development teams and the SMEs to get the business rules and UAT, System, and Integration testing

•Executed data mining, data cleansing, data profiling and data mapping of key data elements of their non-integrated systems; resolved customer payment resolutions.

•Worked heavily doing SQL scripts and MYSQL for market analysis, supplier risk analysis and cost-benefit analysis in their retail market.

•ETL deployment with AGILE methodologies working with the off-shore developers to get it into the weekly sprints.

•Worked quite heavily with SSRS and Micro Strategy for reporting

Blue Cross Blue Shield (BCBS), Naperville, IL Jul 2014 – Oct 2014

Business Systems Analyst – (Contractor)

•Performed responsibilities for data quality of Defect Management with establishing guardrails and gap analysis; using HP Quality Management for tracking for MDM. Worked with the off-shore developers to resolve the defects.

•Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.

•Wrote SQL queries in ACCESS and using SSIS, to view the data and analyze the data with Hyperion, to analyze the patterns of the data for report ability.

•Executed data mining, data cleansing, data profiling and data mapping of key data elements of their non-integrated systems. Data governance of the metadata for Risk Management,

•Created process flow diagrams in Visio of how the information will flow in the Data Mart and the whole SDLC

•Executed data mining and mapping of key data elements to their Vantage software

•Collaborated with Data Owners to understand specific requirements

•Worked in the PMO to establish issue tracking and measurements of defects and Vendor Management

•Elicitation of Business requirements for the business rules to lay the ground work for the guardrails of the software for open enrollment. T-SQL including stored procedures, user-defined fields, views, query optimization.

•Translated business needs into design documents and specifications. Analyze cross-functional requirements and interrelationships of systems to identify dependencies and potential issues.

•Proactively collaborated with the cross-functional departments to identify potential process improvements and enhancements that increase efficiencies and decrease costs.

•Team to build a Data Mata for building guardrails; used SQL scripts to bring the data into the Data Mart.

Humana Inc., IL Nov 2013 – Jun 2014

Business Analyst/ QA Integration Testing – (Contractor)

•Executed and wrote a test cases and stories using SQUID software

•Senior software QA tester with full system development lifecycle experience, including designing, developing and implementing test plans, test cases and test processes fuelling swift corrective actions, significant cost savings and fault-free audits. Perform Regression Testing

•Translated business needs into design documents and specifications. Analyzed cross-functional requirements and interrelationships of systems to identify dependencies and potential issues.

•Proactively collaborated with the cross-functional departments to identify potential process improvements and enhancements that increase efficiencies and decrease costs.

•Elicitation of Business requirements. Revised the Vision and Scope with requirements documentation

•Tested and migrated the Humana Vitality software releases which was their ecommerce software.

•Performed and developed UAT, System, Integration, and Regression test scripts

•Worked with all business cross-functional teams; SSRS for reporting of the data and Hyperion for analytics of the Defects.

U.S. Cellular Jun 2013 – Nov 2013

Business Analyst/ Report Developer – (Contractor)

•Developed SAP Business Intelligent Object Oriented reports for the business environment for Ecommerce retail of mobile devices

•Strong EXCEL analysis work doing trend analysis, business cases, diversity reporting, and risk assessment of the acquired Sprint stores.

•Deployed enhancements and developed documentation for those requirements for Telecom Expense and Reimbursement accruals.

•Extracted and manipulated data to create operational reports and analytics using automated techniques to analyze the data for data integrity.

•SSRS for reporting purposes and SAS and Hyperion for analytics. Do analysis of pattern of billing with the 200 Sprint stores

•Did ‘Cost-Benefit’ and ‘ROI’ analysis for upper management and stakeholders to make decisive decision to close, sell, or keep the stores.

•Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.

•TEOCO mobile device software for inventory for Mobile devices for Androids, I Phones, and IPads for their acquired Sprint stores.

Abbott/ AbbVie Sep 2012 – May 2013

Process Improvement Business Analyst/ Project Manager – (Contractor)

•Translated business needs into design documents and specifications. Analyze cross-functional requirements and interrelationships of systems to identify dependencies and potential issues.

•Proactively collaborated with the cross-functional departments to identify potential process improvements and enhancements that increase efficiencies and decrease costs.

•Developed TM1 Commercial Models for the business stakeholders, Qlikview, roadmaps, and stories.

•Re-engineered for the Global clients and subsidiaries the Excel workbooks with VBA macros to TM1 Commercial Models for forecasting, sales volumes, budgets, and seasonal analytics for Humira, Sevorane, Syanagis, and Zemplar pharmaceuticals.

•Deployed enterprise software solutions and processes. Worked with the offshore developers in Brazil.

•Business Process Analysis including process flow diagrams, analysis on financial impact and all of the SDLC documentation.

•Responsible for Qlikview data visualization and training the end-users for drill-downs and data analytics.

•Issued tracking tools, Congo’s Analytics, SAS, and several reporting tools, SSRS, Crystal, Visio, and BPMN.

•Technically oriented to re-engineer business processes and technical requirements.

•Trained the users on the new modifications both onsite and off-shore. International and domestic user support.

•Gathered users’ requirements, UAT test scripts, unit and systems testing, design and functional documentation.

•Created Sequel scripts for validation of data with SSIS into Access database.

Navistar Inc., Jun 2011 – Sep 2012

Senior Business Analyst – (Employee)

•Translated business needs into design documents and specifications. Analyze cross-functional requirements and interrelationships of systems to identify dependencies and potential issues.

•Proactively collaborated with the cross-functional departments to identify potential process improvements and enhancements that increase efficiencies and decrease costs.

•Went through a nationwide conversion of HRIS along with ADP and the related enhancements

•Documented the requirements and functionalities along with the process flow diagrams in Visio

•Developed requirements and examples for future database and application design by both working directly with the end users of the tool and anticipating the future needs and movement of the organization.

•Identified and documented business processes through interviews with business subject matter experts, review of policies and procedures, existing workflows, training materials

•Trained end users through weekly classroom training classes on the RVD database tool.

•Created processes and implement business process flows using BPMN and Vision identifying the risks of the business processes. Data warehousing as a repository for Sales and Marketing statistics.

State Farm Insurance, Chicago, IL Apr 2011 – Jun 2011

Senior Business Analyst – (Contractor)

•Project managed several large enhancements for the insurance industry.

•Supported end users and did the implementation of the ‘EUCP’, claims processing software.

Applus Technologies Jan 2011 – Mar 2011

Senior Business Analyst, General Employment Solutions – (Contractor)

•Translated business needs into design documents and specifications. Analyze cross-functional requirements and interrelationships of systems to identify dependencies and potential issues.

•Proactively collaborate with the cross-functional departments to identify potential process improvements and enhancements that increase efficiencies and decrease costs.

•Gathered users’ requirements, UAT test scripts, unit and systems testing, design and functional documentation.

•Developed Chain Management Issue Tracking system and led four programmers for changes to vehicle software.

•Implementation of the vehicle emission control software for Denmark and Ireland.

NNR Global Logistics Inc., IL Feb 2005 – Oct 2010

Senior Business Analyst – (Employee)

•Led with hands-on experience on various software and hardware cross-platform implementations leading and coordinating these implementations with the new enterprise environment.

•ITIL services for implementations aligning the user and business needs to advocate the subsidiaries’ changes.

•Involved in analysis and design of change requests through the logistics tracking system. Built SQL stored procedures and triggers.

•Ensured transition plans and handled all testing to final stages and user acceptance.

•System, unit, and regression testing of changes along with the development of use cases and user acceptance of those changes. Coordinated with customer and freight companies for freight payment implementations.

•Designed ‘Order to Cash’ portal for the Logistics industry for freight pricing optimization.

•Communication: Functional liaison between logistics, accounting and IT

•Identified and documented business processes through interviews with business subject matter experts, review of policies and procedures, existing workflows, training materials.

Independent Consultant: Dec 2001 – Feb 2005

Avoco Intl., Inc., Dec 2002 – Apr 2003

Assistant Controller

Exibitgroup/ Giltspur – Roselle, IL Sept 2002 – Dec 2002

Sr. IT Analyst

Sutech Industries, IL Feb 2002 – Aug 2002

Project Coordinator

Walgreens, Deerfield, IL Dec 2001 – Jan 2002

Business Analyst

Previous Experience Available Upon Request



Contact this candidate