We provide IT Staff Augmentation Services!

Data Modeler/data Warehouse Developer Resume

Cleveland, OhiO

SUMMARY

  • Senior Software Engineer with experience in Full Life Cycle development in various Data Bases, Client, and Data Warehouse applications.

TECHNICAL SKILLS

  • SQL Server 2005,2008,2012,2016 Strong decision maker
  • Data warehousing and analytics Complex problem solver
  • SSIS, SSAS, SSRS Efficient data management
  • DB2 Microsoft Development Tool Set
  • SQL / T SQL SQL expert
  • Performance and scalability Optimization Erwin
  • Data Modeling IBM Mainframe Tool Set
  • Azure SQL Server Azure Data Warehouse Design Netezza Data Warehouse Design Oracle 12c
  • Toad for Oracle and DB2 Toad Data Modeler
  • Pl/SQL Power BI/Tableau
  • Cobol/VSAM/JCL/CICS IMS

PROFESSIONAL EXPERIENCE

Data Modeler/Data Warehouse Developer

Confidential - Cleveland, Ohio

Responsibilities:

  • Design and Develop SSIS and Tabular SSAS Models for Data Analytics
  • All Data Modeling Functions for Operational and Data Warehouse DataBases
  • Develop SSAS Tabular Models to be used in corporate Power BI Reports
  • Create Power BI reports for corporate users
  • Functions as SQL Server DBA for the Data Analytics Team
  • Developed SSAS models for enterprise dash board and deployed to Microsoft cloud using Azure, Azure Data Factory and Data Lakes

IT Consultant / Data Architect

Confidential - Cleveland, Ohio

Responsibilities:

  • Design and Develop a Data Warehouse for Cleveland School System
  • All Data Warehouse functions including all SSIS package creation and executions
  • Data Warehouse design and Transaction Database design and assorted Data Architect Tasks as assigned
  • Final Data Warehouse will be Located in the Microsoft Azure Cloud
  • Responsible for Building the Warehouse on local network and elevating the Data Warehouse into the Microsoft Azure Cloud

Senior SQL Server DBA / Data Warehouse Developer

Confidential - Cleveland, Ohio

Responsibilities:

  • All DBA functions including performance, patching, and monitoring…
  • Data Warehouse functions including all SSIS package and SSRS creation and running
  • Data Warehouse design and Transaction Database design
  • Responsible for 2 junior level DBA’s

Data Base / Application Consultant

Confidential - Cleveland, Ohio

Responsibilities:

  • Full Application Life Cycle Development for converting an ASP/JavaScript / XML global Inventory application into ASP.Net MVC / Jscript / C# for internal and external users.
  • Design and Converted of an Object-Oriented Data Base into a Relational SQL Server Data Base.
  • Creation of a forecasting system for inventory levels utilizing SSIS and for reporting SSRS.

Data Base Designer - Modeler / Oracle DBA Consultant

Confidential - Cleveland, Ohio

Responsibilities:

  • All Data Modeling, Data Requirements and Oracle Data Base Functions related to PNC Customer Service System.
  • Created and maintained all Logical, Physical, and Entity models for PNC Customer Service System in IMS and DB2 into Oracle using Toad Data Modeler.
  • Created and maintained PNC’s Data Dictionary, Meta Data, and Reference.

Data Base Designer - Modeler / Data Warehouse Architect Consultant

Confidential - Westfield Center, Ohio

Responsibilities:

  • All Data Modeling, Data Requirements and Data Base Functions related to Data Base and Data Warehouse Architecture Design and Implementation.
  • Lead integration of multiple transaction Data Stores into Netezza Enterprise Data Warehouse. Integrated Policy Administration Package into Transactional and Data Warehouse Data Stores.
  • Created and maintained all Logical, Physical, Entity, and Dimensional Data Base models for all of Westfield’s Corporate OLTP Data Bases and OLAP Data Bases for SQL Server and DB2 using Erwin.
  • Created and maintained Westfield’s Data Dictionary, Meta Data, and Reference Data based on User requirements and relational models.

SQL Server DBA/Data Warehouse Architect Consultant

Confidential - Brecksville, Ohio

Responsibilities:

  • All SQL Server DBA functions, including performance and tuning, backup and recovery, and maintenance and patching functions.
  • Designed and Developed and Implemented a SQL Server 2016 Data Warehouse in the cloud with Azure using AZCOPY, Azure Data Factory and SSIS.
  • Designed and developed and Implemented multiple Cubes and Data Marts using Analysis Services for business users with SSDT and Visual Studio 2014.

Data Warehouse Developer Consultant

Confidential - Brecksville, Ohio

Responsibilities:

  • Worked on converting and Migrating IBM Cognos Data Warehouse Model into SQL Server 2012, utilizing SSIS, SSAS, and SSRS data tools.
  • Designed, Developed and Implemented Multi-Dimensional Cubes using Star Schema.
  • Created a New Data Warehouse in SQL Server 2012 and created SSIS packages and Analysis Services Solution to populate the Warehouse.
  • Designed, Developed and Implemented multiple SSRS reports and implemented onto a User Dash Board.

SQL Server DBA/Business Intelligence DBA Consultant

Confidential - Beachwood, Ohio

Responsibilities:

  • All SQL Server DBA Functions including Backups, Installations, Migrations, and all SQL Server DBA Functions as needed by the client.
  • Designed, Developed and Implemented Microsoft Business Intelligence Infrastructure for full SQL Server 2012 Stack, including SSIS packages design and installation, SSRS creation and installation, Cube design and SSAS creation across a Global Network.

Data Base Architect/Data Warehouse Developer

Confidential - Mayfield, Ohio

Responsibilities:

  • Refactored old legacy Cobol and DB2 programs and Implemented the code into C#, .Net and SQL Server.
  • Created and Implemented detailed Data Base standards and guidelines for programmers and Business users.
  • Designed, Developed and Implemented desktop applications using Microsoft Tool set and Microsoft BI Tools.
  • Organized and lead meetings with stakeholders, contractor product teams and customers.
  • Conducted technical Code reviews and applied Standards and Guideline for Data Bases with developers.
  • Performed functional, non-functional, regression and performance tests, to implement performance improvement s.
  • Migrated and Implemented 300+ legacy DTS applications into SSIS.
  • Founding member of Progressives Claims It Data Governance Team.
  • Created and maintained all Logical, Physical, Entity, and Dimensional Data Base models for all of Progressive Claims IT OLTP Data Bases and OLAP Data Bases, including SQL Server, DB2, and IDMS using Erwin.
  • Created and maintained Claims IT Data Dictionary, Meta Data, and Reference Data based on User requirements and relational models.

Senior Consultant

Confidential - Cleveland, Ohio

Responsibilities:

  • Worked at multiple client sites using Mainframe Cobol, DB2, CICS, Roscoe, and JCL.
  • Worked on multiple client Sites using Visual Basic, SQL Server and C#.

Senior Programmer/Analyst

Confidential - Cleveland, Ohio

Responsibilities:

  • Designed and developed and Implemented a Wire Transfer system from KeyBank to the Federal Reserve.
  • Designed and developed and Implemented a problem Ticket system using mainframe DB2 and Visual Basic

Tools: Used: Mainframe Cobol, DB2, CICS, Roscoe, JCL, Visual Basic, and SQL Server.

Programmer/Analyst

Confidential

Responsibilities:

  • Supported Medical Life Insurance Company subsidiary of Confidential Cross/ Confidential Shield of Ohio.
  • Supported Life Insurance system for Company.

Tools: Used: Mainframe Cobol, DB2, CICS, Roscoe, JCL, and C.

Hire Now