SUMMARY:

• 10+ years’ of experience in consulting, housing industry, global manufacturing, healthcare data management, and medical device research industry
• Technical experience with all phases of the Software Development Life Cycle
• Strong understanding of Data Warehouse methodologies and best practices including relational structures, data extraction, data transformations, and dimensional data modeling
• Enterprise reporting and dashboard development experience
• Advanced SQL programming skills including writing complex queries
• Effective communicator - customer service, sales, and presentation experience
• Vast experience in requirement gathering and executing those requirements
• Excellent problem solving and analytical skills
• Bachelor of Business Administration - Information Technology

TECHNICAL SKILLS:

• IBM Cognos - DataStage, Framework Manager, Transformer, Report Studio, and Query Studio
• Microsoft Office
• SQL Server Integration Services (SSIS)
• Google Maps
• SQL Database
• SQL
• Microsoft Dynamics CRM
• PL/SQL
• Microsoft SharePoint
• HTML and CSS
• Tableau
• JavaScript
• DB2 for the iSeries
• JQuery
• Oracle Database
• Visual Basic
• Oracle Portal
• PowerShell
• LINUX
• Microsoft Visual FoxPro

PROFESSIONAL EXPERIENCE:

Confidential, Northwood, Ohio

System Analyst

• Collaborated with internal resources and outside consultants to define requirements and develop a solution using SSIS and Scribe to integrate data between Salesforce, Microsoft AX, NAMSA’s customer portal, and NAMSA’s lab software.
• Performed research on new CRM application - Salesforce.com and legacy systems (Microsoft AX, Microsoft Dynamics CRM, Scribe, NAMSA’s customer portal, and NAMSA’s Laboratory Information Management Systems (LIMS) to identify how to integrate the disparate systems.
• Designed and built the Integration System database. Assisted in setup of the Integration System server connections.
• Created SSIS package template used as the base of every Integration System Interface SSIS package and worked on a team to development all of the other SSIS packages required to integrate customer, contact, finance, sales, and lab information.
• Following company guidelines created documentation to support solutions and pass internal quality assurance tests to validate the solutions and adhere to FDA regulations.

Senior Applications Engineer

• Utilized IBM Cognos (Framework Manager, Transformer, Report Studio, and Query Studio) to create a Business Intelligence (BI) solution that presented Sales, Pricing, and Installation information.
• Performed as a business analyst to gather requirements for reporting needs to build a successful data model for users to utilize.
• Created & maintained database tables for a staging area and data warehouse BI solution.
• Performed the role of BI Data Modeler using SSIS to extract, transform, and load (ETL) data from a DMAS database and Microsoft Dynamics CRM into a data governed data warehouse.
• Developed and implemented Google Map solution into Microsoft Dynamics CRM to visually illustrate service locations and route appointments.
• Modified Microsoft Dynamics CRM forms to satisfy unique needs and processes of the business.
• Maintained security in Microsoft SharePoint to secure sensitive information.
• Created documentation for technical solutions to increase customer adoption and assist during the implementation of new solutions.

Software Analyst

• Utilized IBM Cognos (DataStage, Framework Manager, Transformer, Report Studio, and Query Studio) to create a Business Intelligence solution that presents Sales, Supply Chain, and Manufacturing information to the organization.
• Performed as a business analyst to gather requirements for reporting needs to build a successful data model for users to utilize.
• Created and maintained database tables for a staging area, data warehouse, and several data marts for BI application.
• Performed the role of Business Intelligence Data Modeler using Cognos DataStage to extract, transform, and load (ETL) data from BANN and several instances of JD Edwards databases into several regional data warehouses and one data governed global data warehouse.
• Successfully collaborated with coworkers located throughout the world to create reporting solutions (using Cognos) and dashboard reporting solutions (using Tableau) for regional and global use.
• Created and supported several custom internal web applications (i.e. open enrollment, new product development workflow, and capital spending approval workflow) using PL/SQL, HTML, and JavaScript.
• Implemented and supported several purchased software solutions such as Tableau and MasterTax.

Document Solutions Specialist

• Effectively used Microsoft Visual FoxPro to provide custom solutions for the medical billing industry.
• Collaborated with Customer Service Representatives to provide solutions for customer issues.
• Meticulously documented changes made to report forms, tables, and programs necessary to complete action requests.
• Participated in quality assurance procedures to verify that action requests were completed correctly.
• Followed HIPPA regulations when handling sensitive information to complete tasks.
• Utilized remote desktop to facilitate solutions in Scottsdale, Arizona.

Consulting Intern

• Assisted in the building of web sites for customers through the use of ‘Oracle Portal’ and ‘Oracle9i Database’ to increase customer efficiency, effectiveness, and participation in e-commerce.
• Presented and demonstrated custom built solutions to potential customers.
• Designed the Warnock, Tanner & Associates, Inc. web site using Oracle Portal, Oracle Database, PL/SQL, and HTML.