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

Email: ad4gid@r.postjobfree.com

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

Mary L. West

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

Oswego, IL 60543

Professional Summary:

Skilled Business Systems Analyst with more than 15 years of experience planning, developing and implementing software and business development initiatives aimed toward sustaining long-term growth. In addition, I have exceptional analytical skills and making strategic decisions with strong communication, presentation and negotiation skills. Fifteen Years of experience with various tools such as: 8 years of SQL, Tableau, Qlikview, SAS, SSRS, and Micro-Strategy.

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, VB V6.0, Citrix, Visio, SAP Business Objects Intelligence, Info view, SAP Financials, Citrix, AQUA/Paraccel, BPMN, GUI, WEB based software, Oracle, HP Quality Management - ALM, SQUID, SAS, Hyperion BRIO Query and BI Tools: Tableau, Qlikview, SAS, Micro Strategy, Power BI, and HP ALM.

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: Eight years of SQL and Sequel with knowledge of VBA, EXCEL macros, html, .net, xml, Java J2EE

Education:

•B.S. Accounting, Elmhurst College

•MBA Finance, Graduate Courses, NIU

Professional Experience:

MUFG – Union Bank – Business Systems Analyst January 2,2022 to June 30, 2022

Worked with the Aggregation Team for getting their Article V metrics and enhancements..

Had various tasks with their Article V Metrics.

Data analytics for data validation.

Fidelity Investments – Business Systems Analyst June 1,2021 to December 31, 2021

Worked with Fidelity’s Health care system HOBS, for their multiple clients on their Annual Enrollment.

The primary client I worked on was IBM with their subsidiary Kyndryl.

Had various tasks with their Annual Enrollment Plan.

Data analytics for data validation.

Assurant, Inc. – Business Systems Analyst January 2021 to June 2021

Participate as the TPA data subject matter expert in the development and deployment of new client programs being on-boarded to the AIM business system and historical client program migrations from the UDB business system to the AIM business system. Review and/or compile system requirements/enhancements for handling client data in an efficient and standardized manner. (Xx %)

• Processes third party batch data for month end execution on the AIM databases, testing for data integrity and results of data validation edits. Reconciles client data to control totals and client remittances and analyzes variances from expected results. • Identifies data reject reasons and works with the client and internal staff in Underwriting, Marketing, and Actuarial to mitigate data and/or table issues in a timely and accurate manner. Facilitates sessions to review rejects and develop the appropriate course of action required to mitigate same. (XX %)

• Compiles and/or executes database queries and performs Quality Assurance testing to validate system modifications/enhancements and conversions/migrations of client business to AIM. (XX %)

• Works with clients and TWG departments, including IT, Finance, Underwriting, Actuary, and Marketing, to ensure business processing requests are fulfilled timely and accurately. (Xx %)

• Compiles and maintains TPA process and procedure documentation and data flow diagrams. Recommend and propose to management changes and improvements to existing procedures and processes. (Xx %)

\Agile financial data metrics and sales metrics.

EMD Serono (Division MERCK – Remote) - Business Systems Analyst/QA: (Contract was until the Manager got off of Medical Leave) Dec 2019 to July 2020

Entering and gathering Business Requirements

Creating and executing test cases

Creating Defects and doing RTM for full coverage of Requirements

Software iBond for clinical medical patients

iBond uses Utilization Management to determine the status and eligibility of the health care claims.

Strong regulatory environment for the Pharmaceutical Industry.

Created SQL queries for data validation, mapping and cleansing of data. Creating dashboards and scorecards for upper management on the status.

Resolving JIRA Issues.

SharePoint and Team documents

Early development of IBond software.

Clinical development of their IBond software.

Quality testing of IBond software and financial Agile data metrics.

Migration of IBond clinical software.

Blue Cross Blue Shield (BCBS) –Project Controller/ Business Systems Analyst- (Contractor) - Budgeted monies were cut) June 2019 – Dec 2019

Requirements, analysis of claim and financial data, formulas, alignment of business rules, data profiling.

Created SQL queries for data validation of the six initiatives. Created SRS reports on the data.

Standup meetings and report ability on gap analysis of the overall DR Strategy -Disaster Recovery project.

Infrastructure experience managing the processes and the governances.

Agile Methodology with iterations of development and testing.

Sales force for reporting on customers and contacts.

Early development of IBond software.

Clinical development of their IBond software.

Metadata source to build the .net Data warehouse.

Worked with vendors on pricing for the budget forecast.

Used Sales force to monitor Customer information for contacts over a financial cloud using Azure.

Used utilization management to determine claim status and necessary progress. JDE for demand forecasting.

Did GUI mock-ups for the FRD documentation to present to end-users.

BMO Harris Bank – Business Analyst Jan 2019 – May 2019

Requirements, analysis of claim and financial data, formulas, alignment of business rules, data profiling.

Gap analysis of tables and fields to add to APIs. Create SQL queries to move data from ACCESS database to EXCEL to normalize the data. Acting as Data Steward of the Metadata.

Infrastructure experience managing the processes and the governances.

Handling and tracking capital expenditures and reporting by departments with dashboards and scorecards.

Worked with Sales Force for Customer information.

Agile Methodologies77with iterations of development and testing.

Google sheets were used for communication on the documentation.

Gallagher Bassett Insurance - Technical Business Systems Analyst (Contractor) April 2018 – Nov 2018

Budget monies were cut on the project)

Data Mart design: Mappings for Mule Soft implementation to provide 3,000 fields, data extracts, from ODS to all clients.

Managed analytical resources to convert source code and designs into mappings from data warehouse to Data Mart. ETL, extracted, transformed and loaded the data from Tandem, Cabot system into the EDW.

Project management to meet milestones for source to target progress, transformations, alternate sourcing decision.

Requirements, analysis of claim and financial data, formulas, alignment of business rules, data profiling. Data was over a financial cloud atmosphere.

Gap analysis of tables and fields to add to APIs.

Infrastructure experience managing the processes and the governances.

Used Jira for reporting requirements management, automated builds, lab management, testing and release management capabilities.

MS Project for tracking of project initiatives. Sales force for reporting on Customers statements.

Metadata was used to retrieve the dependent data into the data warehouse such as APIs.

Work closely with Global Procurement Leadership, Negotiators and Business Project Managers

Perform 4 comparative analytics on a monthly basis on compliance metrics to ensure portfolios are prepared for audits and produce and average of 10% increase in adherence per month

Increase SAP processing efficiency reducing number of needed contracts by 60%

Did GUI mock-ups in the FRD documentation for the end users.

CDK Global Services, Inc. –Project Manager/Business Systems Analyst/Data Steward -(Contractor Projects were completed) Jan 2018 – April 2018 Led various projects in the EPMO Department related to their Automotive Technology Software.

Worked in the IT EPMO office

Managed the entire project lifecycle from project definition through implementation.

One of the projects was on “RPA” (Robotics Process Automation)

Used Jira for reporting requirements management, automated builds, lab management, testing and release management capabilities.

MS Project for tacking of Project initiatives.

Used Sales Force for Customer information and reporting.

Worked with Vendors for pricing and billing.

GE, Remote Position – Business Systems Analyst/Data Analyst/PM - (Contractor – Contracted ended)

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 using SQL Queries. Using Tara data to do analysis and analytics.

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

Extracted data from JDE for analysis; did Agile financial data metrics.

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

Created pivot tables to describe analysis using graphs and charts.

SAP backend to Tableau; downloaded data from Tableau into EXCEL. Using SAP Business Objects.

Used Jira for reporting requirements management, automated builds, and lab management, testing and release management capabilities.

Used SAP commissions for comparison to actuals.

Sampos Canopius US Insurance, Chicago, IL – (Budget monies got cut) 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 using Sql queries.

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

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

•Supported Financial Cloud based applications including SAP Financials

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

PNC Bank, Chicago, IL Oct 2016 – April 2017

Business Systems Analyst / Data Analyst/ Metric Report Developer (Contractor – Contract ended)

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 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.

•Used Jira for reporting requirements management, automated builds, lab management, testing and release management capabilities.

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

Sr. System Integration Business Analyst/ Data Analyst/PM – (Contractor – Budget monies got cut)

(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. Strong regulations for building the PTC software.

•There were four segments: Back Office Systems, ITCM (Communications), On-Board Locomotive, and Wayside systems. Provided direction to the test execution Teams in Montreal and Homewood.

•Back-Office had fee billing and was heavily modified.

•Change Management for the third-party software, Wabtec, Defect Management, Vendor Management for IT audits, Managed HPSM associated with HPALM defects, and conducted daily triage meetings.

•SME and Project Leader on testing writing user stories.

•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.

•Migration of old software to the Data Warehouse.

Office Depot, Itasca, IL Oct 2015– Dec 2015

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

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

•POS systems and software to do the analysis and resolution of payment disputes. Supply Change Management for changing from Office Maxx to office Depot.

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

Sr. Business Systems Analyst /Metric Report Developer/ Data Analyst – (Contractor- Contract monies ended)

•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

AbbVie, Deerfield IL May 2015 – Jun 2015

Sr. Business Systems Analyst /Project Leader – (Contractor- Contract ended job was finished)

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

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

Sr. Business Systems Analyst – (Contractor – Ended the project and did not do the Data Warehouse)

•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- Contract was not extended))

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

•Their” Shop Your Way”, POS system and developed a router to route the calls, orders, and returns to the CSRs.

•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.

•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. Supple Management as far as Sear’s changing brand lines to K-Mart.

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

Business Systems Analyst – (Contractor- Contract budget monies were cut))

•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.

•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

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

•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.

•Built a Data Mart with Erwin 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 – Budget monies got cut)

•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.

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

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

•Worked with all business cross-functional teams

U.S. Cellular Jun 2013 – Nov 2013

Business Systems Analyst/ Report Developer – (Contractor- Another contract came about)

•Developed SAP Business Intelligent Object Oriented reports for the business environment for Ecommerce retail of mobile devices, worked heavily with SAP Business Objects.

•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.

•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 Systems Analyst/ Project Manager – (Contractor) – Peggy Mathias manager said the budget monies were cut

•Translated business needs into design documents and specifications. Analyze cross-functional requirements and interrelationships of systems to identify dependencies and potential issues. The whole SDLC of building the TM1 models on a global bases.

•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. 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.

•Scope Management, BRD, FRD, DRD, and Technical Documentation.

•Define the processes in the Scope Management to ensure the adequate refinement and adequacy of the scope of the project.

Navistar Inc., Jun 2011 – Sep 2012

Senior Business Analyst – (Employee –Company down-sized 850 employees))

•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.

•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 suddenly ended)

•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 Systems Analyst, General Employment Solutions – (Contractor – Company hired internal employee)

•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 Systems Analyst – (Employee – Company downsized 150 employees)

•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.

•Used Jira for reporting requirements management, automated builds, and lab management, testing and release management capabilities.

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