Experience

First Solar

• Venture Capital and Private Equity Principals
• 1 - 100 Employee

• Developer II - Data Engineer/Modeler

  • Mar 2018 - Present

  - Successfully participated in a project to move data and functionality to a SQL database solution to decommission the previous SAP HANA tool. This was done to realize cost savings from the new solution. - Positioned data to be utilized by end users to facilitate reporting solutions. - Build, maintain, and support SSAS cubes utilized to source enterprise reports. - Migrate data from on premise SQL databases to Cloud Azure Data Warehouse and Azure Data Lake. - Created several Azure… Show more - Successfully participated in a project to move data and functionality to a SQL database solution to decommission the previous SAP HANA tool. This was done to realize cost savings from the new solution. - Positioned data to be utilized by end users to facilitate reporting solutions. - Build, maintain, and support SSAS cubes utilized to source enterprise reports. - Migrate data from on premise SQL databases to Cloud Azure Data Warehouse and Azure Data Lake. - Created several Azure Data Factory pipelines to import data from Azure Data Warehouse into Anaplan (cloud-based planning software). - Research new technologies, create proof of concept designs, and implement new solutions tailored to the company’s needs. Show less



NAMSA

• United States
• Business Consulting and Services
• 700 & Above Employee

• System Analyst

  • Oct 2016 - Mar 2018

  6750 Wales Road Northwood, Ohio 43619 - 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 (Salesforce) and legacy (Microsoft AX, Microsoft Dynamics CRM, Scribe, NAMSA’s customer portal, and NAMSA’s lab software) systems to identify how to integrate the disparate systems. - Designed and built the Integration System… Show more - 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 (Salesforce) and legacy (Microsoft AX, Microsoft Dynamics CRM, Scribe, NAMSA’s customer portal, and NAMSA’s lab software) systems 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. - Followed strict guidelines and created documentation to support solutions and pass internal quality assurance tests to validate the solutions and adhere to FDA regulations. Show less



Style Crest, Inc.

• United States
• Wholesale Building Materials
• 100 - 200 Employee

• Senior Applications Engineer

  • Oct 2014 - Oct 2016

  - Utilized IBM Cognos (Framework Manager, Transformer, Report Studio, and Query Studio) to create a Business Intelligence solution that presents Sales, Pricing, and Installation 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 and data warehouse for a Business Intelligence solution - Performed the role of Business… Show more - Utilized IBM Cognos (Framework Manager, Transformer, Report Studio, and Query Studio) to create a Business Intelligence solution that presents Sales, Pricing, and Installation 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 and data warehouse for a Business Intelligence solution - Performed the role of Business Intelligence 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 Show less



Libbey Inc.

• United States
• Furniture

• Software Analyst

  • Mar 2008 - Oct 2014

  - 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 a Business Intelligence… Show more - 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 a Business Intelligence solution - Performed the role of Business Intelligence Data Modeler 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 - HIPPA trained - handles sensitive information according to HIPAA regulations - Created documentation for technical solutions to advance customer experience in the implementation and adoption of products and services Show less



Emdeon

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Document Solutions Specialist 1

  • Jan 2007 - Mar 2008

  - 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 are completed correctly - Successfully completed HIPPA training - Professionally handled… Show more - 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 are completed correctly - Successfully completed HIPPA training - Professionally handled confidential information to complete tasks - Utilized remote desktop to facilitate solutions in Scottsdale, Arizona Show less



Best Buy

• Retail
• 700 & Above Employee

• Inventory Associate

  • Apr 2005 - Nov 2007

  - Successfully served as Inventory Senior between 08/06 – 01/07 - Productively lead team to complete time sensitive projects - Effectively completed daily paperwork essential for inventory control matters - Participated in the store’s overall quality assurance system - Used various internal computer programs to provide customer service solutions for in store customers, business customers, and e-commerce customers - Managed a balance between labor and budget to create efficient… Show more - Successfully served as Inventory Senior between 08/06 – 01/07 - Productively lead team to complete time sensitive projects - Effectively completed daily paperwork essential for inventory control matters - Participated in the store’s overall quality assurance system - Used various internal computer programs to provide customer service solutions for in store customers, business customers, and e-commerce customers - Managed a balance between labor and budget to create efficient schedules for the warehouse - Trained employees on several responsibilities vital to inventory control matters - Participated in opening a new store Show less



Warnock, Tanner & Associates

• Consulting Intern

  • Nov 2002 - Aug 2003

  - 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, Oracle9i Database, PL/SQL, and HTML