| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePhone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLELinkedIn: http://LINKEDIN LINK AVAILABLECandidate's Name
Street Address Raintree DriveOswego, IL Street Address
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 J2EEEducation:B.S. Accounting, Elmhurst CollegeMBA Finance, Graduate Courses, NIUProfessional Experience:MUFG Union Bank Business Systems Analyst January 2,2022 to June 30, 2022Worked 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, 2021Worked with Fidelitys 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 2021Participate 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 2020Entering and gathering Business RequirementsCreating and executing test casesCreating Defects and doing RTM for full coverage of RequirementsSoftware iBond for clinical medical patientsiBond 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 documentsEarly 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 2019Requirements, 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 2019Requirements, 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 2018Budget 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 ManagersPerform 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 monthIncrease 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 officeManaged 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/2017GE Energy ManagementSupport the SIC (Sales Incentive Commission) Team: with data analysis in EXCEL, R2 calculation, YOY, baselineComplete Orders and Sales Baseline calculationsRun 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 teamExtracted data from JDE for analysis; did Agile financial data metrics.Outline and execute feasibility to determine gaps in systems and delivery of data processesCreated 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 2017Implementation 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 FinancialsUsed to analyze the Descriptive and Structural Metadata from various sources.PNC Bank, Chicago, IL Oct 2016 April 2017Business Systems Analyst / Data Analyst/ Metric Report Developer (Contractor Contract ended)Extract large data from Tableau to Excel, pivot table, vlookup, PowerPointResponsible for transformation of loan processing proceduresInvolved 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-users' 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 mortgageRe-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, Montral, Canada Feb 2016 Sep 2016Sr. 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 segments process flow of information using VisioTook 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 2015Sr. 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 diagramsProactively 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 DepotResponsible for trending and statistical reporting for gap analysisDeveloped reports in SQL and ParaccelPOS 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 2015Sr. 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 ManagementWorked with their commercial lending department to for their transformation into regionsWorked with end stakeholders for process improvement and project coordination of tasks and issuesResponsible 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-managementAbbVie, Deerfield IL May 2015 Jun 2015Sr. 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 softwareInitiated a Playbook for the Mobility Team on a global basis and project coordination of responsibilitiesGlobal MDSL telecom expense reimbursement interfaced with the SAP financial modulesY-USA, Chicago, IL Mar 2015 May 2015Sr. 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 Ys in the Data WarehouseExecuted data mining, data cleansing, data profiling and data mapping of key data elements of their non-integrated systemsCreated Visio process flow diagrams for the presentation of the flow of information to upper managementWorked 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 ITSears Holding, Hoffman Estate, IL Oct 2014 Jan 2015Sr. Business Systems Analyst (Contractor- Contract was not extended))Backfill three month contract in the MSO (Members Services Organization) Business IntelligenceTheir 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 systemWorked heavily with the off-shore development teams and the SMEs to get the business rules and UAT, System, and Integration testingExecuted 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 Sears changing brand lines to K-Mart.Blue Cross Blue Shield (BCBS), Naperville, IL Jul 2014 Oct 2014Business 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 SDLCExecuted data mining and mapping of key data elements to their Vantage softwareWorked in the PMO to establish issue tracking and measurements of defects and Vendor ManagementTranslated 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 2014Business Analyst/ QA Integration Testing (Contractor Budget monies got cut)Executed and wrote a test cases and stories using SQUID softwareSenior 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 TestingTranslated 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 scriptsWorked with all business cross-functional teamsU.S. Cellular Jun 2013 Nov 2013Business 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 storesDid 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 2013Process Improvement Business Systems Analyst/ Project Manager (Contractor) Peggy Mathias manager said the budget monies were cutTranslated 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 2012Senior 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 VisioDeveloped 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 materialsTrained 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 2011Senior 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 2011Senior 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 2010Senior 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 ITIdentified 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 2005Avoco Intl., Inc., Dec 2002 Apr 2003Assistant ControllerExibitgroup/ Giltspur Roselle, IL Sept 2002 Dec 2002Sr. IT AnalystSutech Industries, IL Feb 2002 Aug 2002Project CoordinatorWalgreens, Deerfield, IL Dec 2001 Jan 2002Business AnalystPrevious Experience Available Upon Request |
