SUMMARY:

Technology professional with experience managing enterprise implementations of information management systems. Expert in gathering, analyzing and defining business and functional requirements; leading data - modeling and process-mapping initiatives; and designing/re-engineering processes, workflows and technology solutions for information systems and networks. Proven ability to lead seamless implementations and deliver technical solutions improving revenues, margins and workplace productivity.

TECHNICAL SKILLS:

• SQL Server 2012
• Siterra
• Business Intelligence Development Studio (BIDS)
• Pivot Table Creation utilizing Power Pivot & Data Sources
• SQL Server Analysis Services (SSAS)
• Microsoft SharePoint 2010
• 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
• Administrator of Several EDMS Databases
• Oracle OBIEE, PL/SQL
• IT Help Desk/ Customer Service
• Tableau
• Tibco SpotFire
• Business Relationship Management (BRM)
• Microsoft Dynamics NAV 2009 & 2016
• To-Increase Dynamics ISV
• Microsoft SharePoint
• Agile PLM
• Microsoft Dynamics AX
• Atlissian Confluence & JIRA
• Data Haven Document Management
• Microsoft Azure

PROFESSIONAL EXPERIENCE:

Confidential, CHicago, IL

Senior Operations Business Systems Analyst/Project Manager

Responsibilities:

• Lead Senior Business Analyst/Project Manager for an ERP Re-Implementation project from Microsoft Dynamics NAV 2009 to NAV Dynamics 2016.
• Member of Business Process Re-engineering team to acquire a deep understanding of cross-functional business processes and influence realignment cross-functionally where applicable.
• Leading data migration team to normalize and migrate data to the new NAV 2016 platform.
• Providing on-going business process support for back office systems.
• Lead Analyst of GAP and Interface development, driving these areas to completion by UAT.
• Create quality documentation including Requirements gathering, analysis and design, workflow/process diagrams, gap documents, test cases/scripts and post implementation work instructions.
• Leader of JIRA triage and assignment of project tasks to responsible users and following through to completion.
• Report design and cube building in Jet Enterprise Business Intelligence Platform.
• Coordinate and conduct Conference room pilots and final UAT prior to go-live.
• Assists business SME’s on end user training of new system functionality.
• Search and Rescue member on Gogo Emergency Response Team.
• Lead photographer for corporate headshots of executives and employees.

Confidential, Chicago, IL

Senior Business Systems Analyst/IT Project Manager

Responsibilities:

• Product Owner responsible for the BRM 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, data flows, and Business Process Diagrams.
• Performed Project Management and Scrum Master duties for the JIRA Agile system managing Sprint Releases from start to implementation including promoting team and user communication throughout the process of a project.
• Performed QAT and UAT testing when needed, analyzing results and documenting potential issues before go live release.
• Responsible for querying the advertising data warehouse using SQL and/or Microsoft Excel Pivot tables to complete Business Requirement Documentation for specific project initiatives.
• Experienced with SSIS, SSRS, and SSAS. Monitored and helped modify the ETL processes and Cube Dimension changes. 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.
• Senior Business Analyst on a project to create new data warehouse and SSAS 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 Cubes to retrieve data from the Data Warehouse, Pivot Tables, 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

Business Systems Support Analyst

Responsibilities:

• Product Manager and Administrator 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).
• Managed the Systems Development Lifecycle (SDLC) team 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 requirements from business users to identify needs for a new data management solution. Created workflow diagrams, activity diagrams, business rules, 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. Created test use cases 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 identify the SWOT analysis of implementing 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 and reengineering the current data management software package to meet their needs for the future. Also created business process documentation and training.

Confidential, WHITING, IN

Information Management Lead Analyst

Responsibilities:

• Was contracted to the BP Refinery in Whiting, Indiana as a manager lead of a team working on a 10 billion dollar refinery upgrade project.
• Led 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 to fit the system to the business process that had been laid out.
• Worked with vendor through the Systems Development Lifecycle (SDLC) to ensure that the QA testing and implementation phases were conducted smoothly.
• Product Manager/Administrator of Documentum Administrator in charge of database, reporting and data governance for user security clearance.
• Team member in the Analysis and modification of BP standards and policies for better data process flow for the project.
• Created training documentation and performing training for end users for EMC Documentum and other various software packages.
• Was 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

Software and Hardware Support Analyst

Responsibilities:

• Product Manager/Administrator 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.
• Managed the Systems Development Lifecycle (SDLC) team 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.