BUSINESS ANALYST

Top performing business analyst with high degree of expertise in the fields of data analysis and database administration to address issues in complex business environments, including business intelligence tools, concepts and methodologies. Business leader with track record of streamlining your processes, creating better data quality for improved decision-making contributing to higher profits.

Change Management | Consulting | P & L | Project Management | Restructuring | Turnarounds
Strategic Planning | Team Leadership & Motivation | Policy Development | Process Improvement
Needs Assessment | IT Infrastructure & Design | Data Warehousing | IT Strategy | IT Security
QA & Testing | Deployment / Migrations | Business Development | Inventory Management

Technical Overview
Databases: SQL Server 7.0, 2000, 2005, 2008, DTS, SSIS (SQL Server Integration Services), Access, Data Access (OLE, ODBC, ADO.NET) Oracle 9, Lotus Notes
Languages: Visual Basic, VBA, T-SQL, PL/SQL Networks: Windows 2000, 2003, 2008, 7, XP
Other: Crystal Reports, Crystal Enterprise, Visio

IBM, Columbia, Missouri | 10/2011 - 05/2012
A global technology company delivering professional technology services to clients worldwide.

SQL Database Administrator
Provided leadership to Backup and Recovery Services using Tivoli and SQL Maintenance Plans; used DMV SQL queries to tune and remediated poor performing queries to vendor teams. Coordinated and participated in client review; revisions; changes; testing; documentation; and notification of SQL Server enhancements. Engage in monitoring and correcting issues relating to space, integrity, and database functionality; create new objects using SQL and command scripts per the client\'s change orders. Designed process and data models ad hoc in response to staff and client inquiries. Collaborated with clients and IBM staff on specific issues relating to database administration, and documented all activities using tools and reports for knowledge transfer; define and document business and functional requirements, service line process maps ("As-Is/To be") flows and diagrams to uncover potential errors or misleading recommendations; validated the service line\'s progress, mapped in wave reports throughout the cycle.Worked closely with developers and requesters identifying data and functional requirements in the design of new systems. Ensured service line objectives are accomplished; user testing is performed; and client notification is prepared in a timely fashion. Ensured timely and accurate communication with staff throughout the life cycle of the technical support case. Ensured satisfactory adherence with ISeC security/compliance requirements. Proactively maintained an understanding of proprietary business practices. Estimated and built project schedules and drove projects to successful completion on-time with high quality. Addressed issues and mitigated risks, communicated status to the business and its stakeholders. Provided innovative ideas and solutions in a dynamic environment.

Accomplishments:

• Letter of commendation from an IBM team on a full Disaster Recovery to complete a server restoration previously unable to fully utilize its components.
• Received commendation regarding a server restoration, with no previous knowledge of its capabilities.
• Facilitated maintenance plans through timely creation, testing, and implementation of scripts.
• Discovered database security breach, documented and submitted to all stakeholders.
• Discovered a misconfigured cluster server, ensuring operation prior to change order.
• Management acceptance of several recommendations to further integrate the support environment and remove recurring issues across the as-is/to-be process map.
• Added value by keeping project timelines sustainable by way of vigorous learning of detailed material for multiple clients without all the documentation available.

Confidential, Owatonna, Minnesota | 8/2010 - 9/2010
SPX manufactures and markets products, components, services and technologies that are integral to meeting today's challenges and tomorrow's needs.

Data Analyst - Contract - Access, SQL Server 2005, SSIS
Imported data from OEM Excel files into Microsoft Access using SQL scripts, macros and VBA code.
Processed datasets to diagnose motor vehicle issues, and the platform used to store and process the data, both Access and SQL Server. Created new tables and relationships for the purposes of processing the data received. Created OEM builds for manufacturer's preliminary testing in SQL Server. Collaborated with the software engineer from the manufacturer on technical issues, and supported testers by fixing defects.

Accomplishments:

• Designed forms, VBA code, SQL queries, macros, and technical instructions to extract data automatically from a GM hardware tool into Microsoft Access.
• Developed functions that conducted specific inserts and updates for vendor specific diagnostic tools, error compilation, reporting, and testing purposes.
• Created base lookup tables for byte and bit reference, specific English language shorthand, and data item references between OEM and the SPX SQL database.
• Studied detailed material with little documentation available to preserve project timelines.
• Fixed broken VBA code to allow processes to work again in the Access environment.

Confidential, Faribault, Minnesota | April 2010
KGP Telecommunications is a leader in telecommunications products, supply chain management, and telecommunications equipment integration.

Database Reporting Analyst, Contract | Oracle 9, Crystal, SQL 2008 SSAS, SSRS, PL/SQ Surveyed department leaders on Oracle 9i database and reporting requirements; created new reports in Crystal for warehouse management reporting purposes with SQL queries. Scheduled reporting to emails or Crystal inbox for multiple distribution centers. Created sample ad hoc and drilldown reports for demonstration leading into the SQL migration. Audited availability of reports in Navision versus the current reporting environment in PeopleSoft. Recommended database solutions to automate an error correction solution in accounting. Analyzed the requirements to migrate to MS SQL Reporting Services.

Accomplishments:

• Completed the contract successfully and well ahead of schedule.
• Increased shipment efficiency and reduced routing errors through new reporting and automation.
• Increased the understanding how the new reporting system would overcome Crystal's limitations.
• Demonstrated that leveraging existing technology and experience could save the company money.

Confidential, Owatonna, Minnesota | 3/2003 - 10/2009
Costas has been making hand-rolled candies for over 90 years. Costas Chcolates are known worldwide and shipped across the US.

Business Intelligence Developer - SQL Server 2005, T-SQL, SSIS, SSMS, Access, Visio
Designed and implemented business intelligence (BI) framework and solutions and took the lead in gathering business requirements and preparing technical designs and specifications. Developed and participated in the review of business and functional requirements to determine primary functions that the solution would provide. Created data models with a comparison between current and future state design; analyzed source data and mapped to staging, then to production database with custom SQL. Developed SSIS Integrative Models to SQL Query for continuous updating of database and new SQL Queries to use with the customized reporting tool. Created extensive SQL query drilldown and ad hoc analysis of our sales and marketing programs to maximize performance and operation; define and document business and functional requirements, service line process maps ("As-Is/To be") flows and diagrams to uncover potential errors. Documented business requirements and translated those into Fact and Dimension definitions, ultimately delivering a data dictionary to the business. Documented and coordinated changes and enhancements of products and services. Established project scope and effectively managed scope utilizing change control processes. Created test plans, test cases conducted functional testing as needed. Conducted the user acceptance testing, defect and issue tracking processes related to the application software. Prepared and/or presented documentation of business/technical presentations. Proactively maintained an understanding of proprietary business practices. Estimated and built project schedules and drove projects to successful completion on-time with high quality. Addressed issues and mitigated risks, communicated status to the business and its stakeholders. Provided innovative ideas and solutions in a dynamic environment.

Accomplishments:

• Doubled the firm's chocolate production in less than 3 years and chocolate revenues in 5 years.
• Gained a strong marketing presence against competitors never envisioned prior to implementation.
• Created marketing system that increased sales and margins in new marketing programs.
• Integrated an extremely fragmented system for the purposes of expansion in a very short time.

Confidential, Eden Prairie, Minnesota | 6/2001 - 2/2003
HighJump Software is a global provider of a full suite of supply chain management software that streamlines the flow of inventory and information from supplier to store shelf.

Worldwide Applications Analyst - SQL Server 7, 2000, Oracle 8, Crystal, T-SQL, PL/SQL
Interfaced with staff on support-type issues and research as requested by client and staff. Delivered RCA analysis and solutions to quickly resolve major issues and ensure client satisfaction. Created SQL queries and objects to be used by warehouse management for reporting purposes. Conducted requirements analyses develop effective solutions for changes. Collected, reviewed, analyzed, evaluated and prioritized business and system requirements. Created test plans, test cases conducted functional testing as needed. Conducted the user acceptance testing, defect and issue tracking processes related to the application software. Established project scope and effectively managed scope utilizing change control processes. Addressed issues and mitigated risks, communicated status to the business and its stakeholders. Estimated and built project schedules and drove projects to successful completion on-time with high quality. Proactively maintained an understanding of proprietary business practices. Provided innovative ideas and solutions in a dynamic environment.

Accomplishments:

• Commended by executive team for ability to keep airplane manufacturer running during a faulty application implementation.
• Tuned queries on databases to perform faster while retaining quality.
• Restored downed systems quickly and efficiently, within client service level agreements.
• Converted a 30-item issues list from a poor implementation into a fully functional application and database solution without assistance from High Jump team.
• Trained new hires in database support methods and protocols to increase ramp-up times.

EDUCATION

Bachelor of Science: Accounting Information Systems

CERTIFICATIONS

Six Sigma | Lean | Client-Server Development | SQL Programming