SUMMARY

• Confidential has over 15 plus years of BI stack experience in Multidimensional Cube design and Data Warehouse environment. Combined he has 8+ years of OLAP Ralph Kimball Dimensional and Bill Inmon OLTP ER Architecture design. He is proficient with SSIS, SSAS and SSRS as well as ER/Studio and Erwin Data Modeler Workspace and MS Visio.

TECHNICAL SKILLS

• Azure Cloud environment / Knowledgeable AWS hands on
• Logical & Physical Bi Modeling
• Informatica
• Data Mapping
• MDM/ DQS
• SSIS/ETL staging Data Warehouse
• SSAS/with MDX coding
• SSRS
• Power Bi/ with DAX coding/Tableau
• Agile/Scrum methodology
• R Analytics/ R Data Mining
• Hadoop, Spark
• Knowledgeable

PROFESSIONAL EXPERIENCE

Software Dev analyst

Confidential

Orlando, FL

Responsibilities:

• Prepared and maintained software architecture documentation as per methods.
• Performed data profiling in the source systems
• Created software models and documented technical designs.
• Analyzed data patterns for identification of correct data during conversion designing.
• Provided technical assistance for discoveries of data content issues
• Involved in defining the source to target data mappings, business rules and data definitions
• Involved in data warehouse design
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions
• Designed/developed SSIS ETL process for OLTP Staging database and tables.
• Designed/developed SSIS ETL process for DW and tables.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse

Confidential, Franklin, TN

Business Intelligence ETL Architect/ Senior BI Developer

Responsibilities:

• Created Business Intelligence Assessment and collaborate with operation and manager engineer’s data and stakeholders to design and implement and deliver insightful analytic/ reporting solitons.
• Built data model for analytics and reporting scalability.
• Designed/developed SSIS ETL process raw data into staging and SSIS ETL process for OLTP database and tables.
• Designed/developed SSIS ETL process for OLTP Staging database and tables.
• Designed/developed SSIS ETL process for DW and tables.
• Built, testing and refined data pipelines (ETL) across production databases.
• Designed functional and non - functional Technical documents and designed SSRS reporting.
• Migrated SQL Server 2012 to 2014 and fixed defects on the existing production application.
• Supported delivery and deployment of defined technical solutions.

Confidential

Nashville, TN

BI Application Architect

Responsibilities:

• Designed SSIS ETL process for raw data and SSIS ETL process for OLTP database and tables.
• Designed SSIS ETL process for OLTP Staging database and tables and Designed SSIS ETL process for DW and tables.
• Developed on OLTP Data mapping source to OLAP source targets.
• Created Dimensional models in star and snowflake schemas.
• Developed on SSIS ETL OLTP mapping to OLAP Data Warehouse.
• Designed dimensional model for Data warehouse.
• Designed Cube model in SSAS, Developed SSAS Cubes and Design Cube ETL Cube process.
• Designed functional and non-functional Technical document.
• Created MDX to design calculated member and name sets, used MDX code to develop SSRS reports and Supported MDX coding for Tableau user.
• Designed SSRS analysis reporting and migrated SQL Server 2012 to 2014.
• Fix defects on the existing production application.
• Support delivery and deployment of defined technical solutions.
• Communicate with accuracy, the project status, issues, risks and scope.

Confidential

Wilmington, NC

BI Team Lead/ Senior BI Developer

Responsibilities:

• Analyze and validate data to ensure business requirements are met.
• Design using ER/Studio and MS Visio.
• Develop on OLTP Data mapping source to OLAP source targets.
• Created Dimensional models in star and snowflake schemas.
• Develop on SSIS ETL OLTP mapping to OLAP Data Warehouse.
• Design dimensional model in Data warehouse.
• Designed Cube model in SSAS, Developed SSAS Cubes and Designed Cube ETL Cube process.
• Create MDX to design calculated member and name set and MDX code to develop SSRS reports.
• Migrated SQL Server 2008 to 2012, fixed defects on the existing production application and supported delivery and deployment of defined technical solutions.

Confidential

BI Team Lead / Senior BI Developer 

Responsibilities:

• Bi modeling design using ER/Studio and with MS Visio
• Created Dimensional models in star and snowflake schemas
• Review and employ database schemas to document Physical Data Models and develop logical data model, and dictionaries
• Support the development of integrated data models and artifacts identifying as-is, planned, and to-be mission data and supporting metadata
• Work with business, process teams, and leaders, to understand their business information requirements and to classify, organize, make available and govern the data needed to meet those requirements
• Prepared functional and technical design documents
• Designed and prepared LLD documents
• Designed data control flow diagrams
• Helped to establish standards of data warehouse project requirements, as well as design, development, implementation and maintenance processes
• Participated in the design, implementation, and documentation of migration and integration projects across multiple database platforms
• Design and develop SSIS ETL OLTP mapping to OLAP Data Warehouse
• Develop Informatica ETL OLTP mapping to OLAP Data Warehouse
• Develop SSIS ETL source Load into staging
• Develop Informatica ETL source Load into staging
• Analyze and validate data to ensure business requirements are met
• Develop Dim table and fact table in Data warehouse
• Develop Multidimensional Database
• Develop SSAS cubes that can be browsed on web and client Power bi tool
• Develop Cognos Dynamic Cubes Transformer that can be browsed on web and client Power bi tool
• Design MDX code queries for dynamic cube functionality
• Used MDX code queries to create KPI functionality for reporting
• Designed solution for SSRS reports
• Develop SSRS Chart-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Develop SSRS custom components for reporting using ETL automation

Confidential

Charlotte, NC

BI Developer/Remote

Responsibilities:

• Lead team on SSAS, SSRS, and SSIS.
• Using MDX to develop calculated member and name sets and set up KPIs fields.
• Utilized MDX queries to develop SSRS reports.
• Participated in information deployment decisions.
• Enhanced and developed SSIS packages as well configured packages in SSIS environment and on server.
• Developed OLAP functionality in Data Warehouse and Multidimensional Cubes database.
• Developed and enhanced SSRS/Report Builder reports and configured packages in SSIS environment and on server.
• Participated in the design, implementation, and documentation of migration and integration projects across multiple database platforms.
• Supported load testing and reviewed deliverable and participated in enterprise information deployment decisions.

Confidential

Kansas City, MO

Junior Merge Tech

Responsibilities:

• Uploaded new banking image software, then deployed and validated the image onto each new CPU’s.
• Validated software applications, network, database and internet connections for each work station.

Confidential

Overland Park, KS

Mentor Software Support Mentor/ Business Intelligence

Responsibilities:

• Mentored students on how to use SSIS ETL tools and configuring cube browser.
• Mentored students on configuring large data source for unified dimensional model cube.
• Mentored students on connecting Crystal Reports to a number of data sources (Oracle, SQL Server, MS Access, DB2 databases, etc.)
• Mentored IT professionals on how to use Share Point 2008 and the BI stack (SSAS, SSIS, and SSRS).
• Mentored students on designing and developing reports using Report Builder/SQL Reporting Service (SSRS).
• Assisted classroom instructors in refining existing instructional strategies and introduced new BI strategies and concepts.
• Mentored students on installation, configuration, performance tuning, and production trouble shooting, and client/server installation.
• Mentored students in database development, writing stored procedures, Queries, functions, triggers, ETL, DTS/SSIS packages for SQL Server databases.