Senior Business Systems Analyst Resume Profile
IL
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.
Professional Experience
Confidential
Senior Business Systems Analyst/IT Project Manager
Key Results
- Product Owner responsible for the BRM of the Tribune Advertising Enterprise Data Warehouse, Analytics Cubes, ETL Processes and Enterprise Reporting.
- Responsible for being the liaison between the business and technology areas, working to elicit business requirements through proactively communicating and collaborating with external and internal employees to analyze the customers functional requirements.
- Turned functional requirements into technical requirements which included Business Requirements Documents, Use Cases, Data Flows, Business Process Diagrams, Entity Relationship Diagrams and other required documentation.
- Responsible for creating Epics, User Stories, and Bug Tasks based on gathered requirements and managing these items through the Agile SDLC process.
- Led daily stand up Scum meetings between the developers and QA teams to identify potential blockers in the process. Worked on resolution of these blockers for development/QA to resume.
- Responsible for Project Management/Release Management of each Sprint, selecting items to be in current/upcoming sprints and managing the product backlog. Held Sprint Planning meetings to determine scope of Sprint and estimated time frames needed to complete sprint.
- Managed the sprint release process from initiation to production including promoting team and user communication throughout the process of a project.
- Assisted with QA testing upon determined need from the QA staff. Worked closely to ensure proper QA testing was completed.
- Communicated and assisted SME's with UAT testing to ensure that UAT testing via test cases was completed successfully.
- Experience querying using SQL databases to complete Business Requirement Documentation for specific project initiatives.
- Experience with SSIS, SSRS, and SSAS. Monitored and helped modify the ETL processes, SSIS packages and Cube Dimension changes based upon needs identified by the development team.
- Senior Business Analyst on a project initiative to migrate from 8 legacy order systems to a new enterprise wide platform. Identified requirements for over 80 new reports to be developed during this process as well as modifications to existing reports.
- Senior Business Analyst on a project to create new data warehouse and analytical cubes for financial ad-hoc reporting. Worked on the team to gather requirements and prepare the Entity Relationship Diagram based upon the gathered requirements.
- 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.
Confidential
Business Systems Support Analyst
Key Results
- Product Manager and Administrator of several software packages across the company.
- 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.
- Gathered and assessed requirements from internal business units and worked towards resolution of requests/issues.
- Managed the Systems Development Lifecycle SDLC team to ensure all gathered requirements for releases were met through extensive testing QA/UAT for bugs before implementation of the updates to production.
- 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 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.
| Confidential |
Information Management Lead Analyst
Key Results:
- 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 and a million plus database records from the Citadon Document Management System EDMS to EMC Documentum Management System EDMS .
- Elicited requirements from business users during the project to fit their needs into the new the system as compared to the new business process that had been laid out.
- Worked with the data architect through the Systems Development Lifecycle SDLC to ensure that the development, QA testing, UAT and implementation phases were conducted smoothly.
- Product Manager/Administrator of Documentum Administrator in charge of database, SQL DQL reporting and data governance for user security clearance.
- Modified BP standards and policies for better data process flow for the project.
- Created training documentation, instruction manuals and performed training for end users for various software packages throughout the refinery.
- 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
Software and Hardware Support Analyst
Key Results:
- 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 gathered requirements for releases were met through extensive testing QA/UAT for bugs before implementation of the updates to production.
- Configured new IT ticketing system from out of the box functionality to custom Ambitech requirements.
- 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.
| Confidential |
Document Control Coordinator
- Responsible for building a new document control system at the Morris, IL plant.
- Implemented a rollout of AutoCAD 2006 to entire plant.
| Confidential |
Document Control Specialist
- Administrator for the Meridian by Blue Cielo Workflow document management system. Supported end users refinery wide with any issues relating to the software.
- Was responsible for data auditing, data quality, data governance, data indexing and data boarding. Performed maintenance and help desk related issues on drafting department PCs and plotters, including installing service packs, patches, printers, and configuration of software for new users.
Skills Systems Proficiency
| SQL Server 2012 | Atlissian JIRA |
| 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 |
| Data Flow Design | Cisco Network Hardware, VoIP, Wireless |
| Requirements Gathering | Crystal Reports |
| PeopleSoft | Administrator of Several EDMS Databases |
| Oracle OBIEE, PL/SQL | IT Help Desk/ Customer Service |
| Tableau | Tibco SpotFire |
| Business Relationship Management BRM | Microsoft Dynamics AX |
