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, 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: 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, PS 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

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• 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

Confidential, Chicago, IL

Implementation Business Systems Analyst

Responsibilities:

• Undertaken conversion responsibilities from their Intech to Insurity cloud-based software.
• 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
• 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

Confidential, Chicago, IL

Business Systems Analyst / Data Analyst/ Metric Report Developer

Responsibilities:

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

Confidential

Sr. System Integration Business Analyst/ Data Analyst

Responsibilities:

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

Confidential, Itasca, IL

Sr. Business Systems Analyst /Metric Report Developer

Responsibilities:

• 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 Confidential
• Responsible for trending and statistical reporting for gap analysis
• Developed reports in SQL and Paraccel

Confidential, Naperville, IL

Sr. Business Systems Analyst /Metric Report Developer/ Data Analyst

Responsibilities:

• Transformation of West Allis, Wisconsin for their loan processing procedures
• 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.

Confidential, Deerfield IL

Sr. Business Systems Analyst /Project Leader

Responsibilities:

• 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

Confidential, Chicago, IL

Sr. Business Systems Analyst

Responsibilities:

• 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

Confidential, Hoffman Estate, IL

Sr. Business Systems Analyst

Responsibilities:

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

Confidential, Naperville, IL

Business Systems Analyst

Responsibilities:

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

Confidential, IL

Business Analyst/ QA Integration Testing

Responsibilities:

• 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 Confidential Vitality software releases
• 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.

Confidential

Business Analyst/ Report Developer

Responsibilities:

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

Confidential

Process Improvement Business Analyst/ Project Manager

Responsibilities:

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

Confidential

Senior Business Analyst

Responsibilities:

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