SUMMARY

• Technology professional experienced in working with stakeholders to elicit and validate requirements, create process flows and implement changes to streamline processes, eliminate waste and reduce operational costs.
• Experienced as a Project Manager and Scrum Master leading small to enterprise wide SDLC implementations of business systems, including business intelligence reporting.

TECHNICAL SKILLS

• SQL Server
• Siterra
• Business Intelligence Development Studio
• Pivot Table Creation utilizing Power Pivot & Data Sources
• SQL Server Analysis Services (SSAS)
• Microsoft SharePoint
• SQL Server Integration Services (SSIS)
• Microsoft Project & Visio
• SQL Server Reporting Services (SSRS)
• Adobe Products (Photoshop/Lightroom/Adobe)
• Data Warehouse ETL Creation and Processing
• Microsoft Windows Server Edition
• Service Now
• Cisco Network Hardware, VoIP, Wireless
• Requirements Gathering/Business Flows
• Jet Enterprise Reporting & BI
• PeopleSoft
• Database Administration
• Oracle OBIEE, PL/SQL
• IT Help Desk/ Customer Service
• Tableau
• Tibco SpotFire
• Business Relationship Management
• Microsoft Dynamics AX
• Microsoft Dynamics NAV 2009 & 2016
• Microsoft Azure
• Agile PLM
• Data Haven (Dynamics NAV)
• Microsoft CRM
• Atlassian Confluence & JIRA
• Power BI
• To Increase Advanced Jobs (Dynamics NAV)
• E - Ship (Dynamics NAV)
• Agile & Waterfall Methodologies
• Manufacturing & Production (Dynamics NAV)
• Servicing (Dynamics NAV)
• Warehousing (Dynamics NAV)
• Demand Planning & Purchasing (Dynamics NAV)
• Quality Management (Dynamics NAV)
• Financial Management (Dynamics NAV)

PROFESSIONAL EXPERIENCE

Confidential - CHicago, il

Senior IT Business Analyst/Project Manager

Responsibilities:

• Lead Senior BA on ERP implementation of Microsoft Dynamics NAV 2016, acting as liaison between the business and IT/Dev team, ensuring the understanding of the requirements to the development teams.
• Led the business process re-engineering and drafting of business & functional requirements document to implement cross functional business processes & systems.
• Identified, analyzed and created process flows for the “as is” state and created process flows for the “to be” state in Microsoft Visio.
• Identified gaps, created technical design documents, use cases, test scripts, and post implementation work instructions/job aids.
• Functioned as a scrum master of Dynamics NAV ERP, leading JIRA backlog grooming, sprint planning and story assignment, daily standups while leading the development team through design, development, QA, regression testing, remediation, user acceptance testing & deployment in the allotted sprint time box. Following deployment, held sprint retrospective meeting.
• Member of several integration workstreams between external programs and Dynamics NAV, ensuring the requirements were followed and team was meeting deadlines.
• Created custom business intelligence reports/dashboards for executive management using Excel, Tableau, Power BI, & Jet Enterprise for Microsoft Dynamics.
• Member of data migration team, performing data cleansing, validation and ensuring correct mappings. Also ensured that data governance and SOX compliance was followed.
• Responsible for creating the team and managing resources to lead the charge for implementation of change management for the enterprise ERP system.
• Experienced in the core ERP areas of demand planning, procure to pay, order to cash, service & asset management and accounting.
• Selected vendor for Service Now workforce management solution implementation by leading RFI (request for information), RFP (request for proposals), and cost-benefit/ROI (return on investment) findings processes.
• As a Project Manager, responsible for successfully managing a team of business analysts and 50+ stakeholders in a re-implementation of Microsoft Dynamics NAV 2016 along with associated business processes utilizing Six Sigma methodologies.
• As a Project Manager, responsible for tracking schedule & tasks, managing resources, mitigating risks and organizing/running three conference room pilots, user acceptance testing, and developing and delivering documentation and dashboards for post go-live analytics for the NAV 2016 Project.

Confidential - chicago, il

Senior IT Business Analyst/Project Manager

Responsibilities:

• Senior Business Analyst responsible for business relationship management of the Tribune advertising enterprise data warehouse, related cubes and reporting via data from Microsoft Dynamics AX & Microsoft CRM.
• Responsible for being the liaison between the business subject matter experts across all departments and the technology teams displaying excellent verbal and written communication skills.
• Responsible for eliciting business requirements through proactively communicating and collaborating with external and internal employees to analyze information needs and functional requirements and deliver documentation such as; business requirements documents, use cases, test scripts business process diagrams, and training documentation.
• Performed Project Management and Scrum Master duties in JIRA, managing sprint planning, sprint execution, daily scrum standups, deployment and sprint retrospectives.
• Responsible for promoting team and user communication throughout the process of a project.
• Performed QAT and UAT testing on each release, analyzing results and documenting potential issues for remediation before release to production.
• Responsible for querying the data warehouse, Dynamics AX or Microsoft CRM using SQL and/or Microsoft Excel pivot tables to complete business requirement documentation for specific project initiatives.
• Collected requirements for SSIS, SSRS, and SSAS initiatives. Monitored and helped modify the ETL processes and analytics cube dimension changes with developers as needed. Analyzed report structure and provided feedback to developers.
• Senior Business Analyst on a project initiative to move from one advertising platform to a new platform and worked with users from 8 different business units across the country during the project collecting and validating requirements.
• Senior Business Analyst on a project to create new data warehouse and cube for financial ad-hoc reporting. Worked on team to gather requirements and prepare the entity relationship diagram based upon the gathered requirements.
• Analyzed PeopleSoft Financial SQL queries and provided documentation for a project to reorganize the company into 2 separately operating companies.
• Created new documentation for different areas and trained users in several areas including using analytics cubes to retrieve data from the data warehouse, pivot tables, power pivot, commission payouts, submitting help desk tickets and other programs.
• Tasked with finding new ways to control costs, increase efficiency or improve revenue opportunities through new projects or updates to current business processes.

Confidential - DOWNERS GROVE, IL

IT Business Analyst

Responsibilities:

• Business Analyst and Product Owner of several software packages across the company.
• Gathers and assesses requirements from internal business units; created solutions to resolve issues (e.g., reports, system performance; new project setup; and security).
• Project Manager of the systems development lifecycle (SDLC) process to ensure all requirements for software releases were met and patches for bugs for current software are tested before implementation of the updates to the live system.
• Tasked with researching new software packages to automate tasks to increase productivity. Also worked closely with the hardware team to document hardware requirements for new software.
• Responsible for metadata management and managing data governance of the data systems which includes researching and enforcing policies and procedures to protect intellectual property. Created documentation and flows used to train users on various software platforms.
• Manager of the IT ticket system working with users towards resolution of issues and requests for new items.
• Project Manager on a project to gather business requirements from business users companywide to identify needs for a new data management solution. Created process diagrams, functional business requirements, non-functional requirements and other documentation as required for project.
• Performed vendor selection and tangible/intangible benefits of the vendors as well as creating Return on Investment documents laying out the cost and benefits of the different solutions.
• Performed data mining/ data cleansing for the data migration phase.
• Created test use cases and scripts for QA & UAT testing of the new solution. Collected results from end users through the use of various data collection methods. (e.g. Interviews, surveys, observations)
• Started the discovery phase to document the business case for implementation an enterprise data warehouse.
• Worked as a consultant for a client in Detroit, MI to help cut costs and increase productivity by helping to change business processes to help cut costs of manual work load and to boost productivity. Created documentation and workflows to train users on new processes.
• Worked as a consultant for a client in Channahon, IL gathering requirements, creating process flows, use cases, testing scripts and implementing a new data management software package to meet their needs for the future.

Confidential - WHITING, IN

Information Management Business Analyst

Responsibilities:

• Contractor at BP Refinery in Whiting, Indiana as a manager lead of a team working on a 10 billion dollar refinery upgrade project.
• Successfully managed the project,driving requirements gathering all the way to implementation and the data migration of 500,000+ documents from the Citadon Document Management System (EDMS) to EMC Documentum Management System (EDMS).
• Elicited requirements from business users during the project and led the implementation of the system matching the validated requirements.
• Worked with system architect through the systems development lifecycle (SDLC) to ensure that the requirements were followed, QA testing was completed, user acceptance testing was conducted and implementation phases were conducted smoothly.
• Product Manager/Administrator of Documentum Administrator in charge of database, reporting and data governance for user security clearance.
• Responsible for collecting requirements and performing analysis and modification of BP standards and policies for better data process flow for the project.
• Created training documentation and performed training for end users for EMC Documentum and other various software packages.
• Responsible for auditing, document boarding, and indexing of engineering, concurrent engineering, procurement, supplier, construction, and project documentation within the Electronic Data Management System (EDMS/ERP) against BP Standards for Compliance.

Confidential - DOWNERS GROVE, IL

IT Systems Support Analyst

Responsibilities:

• Business Analyst/Product Manager of several software packages including Document Management Systems, AutoCAD, Adventnet Service Desk Plus, Microsoft Products, and other various software products.
• Responsible for managing data governance of all documentation in the document management system which includes researching and enforcing policies and procedures to protect intellectual property.
• Project Manager of the systems development lifecycle (SDLC) process to ensure all requirements for software releases were met and patches for bugs for current software are tested before implementation of the updates to the live system.
• Administered and helped end users through IT ticket system with issues related to various software and hardware systems and contacted vendors for support until resolution of issue.
• Creates basic and advanced documentation for users and performs training classes to enrich the end user’s knowledge of software applications.
• Was responsible for maintaining inventory, assignment and setup of end user computer equipment, and the programming of Cisco VoIP phones.
• Assisted Network Administrator with Cisco Router installations, card upgrades, troubleshooting and cross connection of cables to user cubicles. Also assisted with Active Directory, TCP/IP, and Wireless technologies.