We provide IT Staff Augmentation Services!

Data Warehouse Architect Consultant Resume

SUMMARY

  • 11 plus years of experience in IT with 9 plus years of experience in managing and leading DW/BI efforts from requirement gathering to its implementation.
  • Experience with Data Warehousing and Data Architecture on multiple platforms like Microsoft, Microsoft Azure, Oracle.
  • Extensive hands - on experience with designing and building regular and real time Data warehouse solutions, Data Marts, Operational Data Stores (ODS) in Health Care, Insurance, Finance, Banking and Retail Industries.
  • Extensive hands-on experience in conceptual data modeling, logical data modeling, physical data modeling, Enterprise Data Warehouse design, Data Mart design.
  • Experience in Metadata management, Data Quality, Master Data Management and Data Governance.
  • Strong demonstrable Power BI, PowerPivot, Power View, Power Query database modeling and visualizations.
  • Experience in Data Integration between Homogenous and Heterogeneous Systems using multiple ETL tools.
  • Experience in developing Analysis Services (SSAS) Cubes (Tabular and Multi-Dimensional) and Data Mining Models.
  • Experience in Data Analysis using different Data Mining techniques/ algorithms like Time Series, Linear Regression, Logistic Regression and Clustering.
  • Strong experience in Stored Procedure/TSQL coding, Performance tuning, and Query Optimization and tracking data changes using Change Data Capture (CDC).
  • Strong knowledge of Software Development Life Cycle (SDLC) principles, involved in all phases of SDLC; Requirements analysis, Design, Development and Unit Testing, Implementation and Maintenance.
  • Good understanding of Big Data frameworks like Hadoop, Spark and associated technologies.
  • Experience in handling complex projects with estimation and capacity planning within specified budget or timeline.
  • Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
  • Experience in working with Agile Scrum and Waterfall methodologies.
  • Good working knowledge of Unified Modelling Language (UML) for Object Oriented Analysis & Design methodologies.
  • A strong sense of leadership, ownership and a willingness to work with team members to drive out successful solutions.
  • Skilled in facilitating discussion in order to solve problems with project stakeholders.
  • Skilled in abstracting complex business problems in order to come up with a technical solution.
  • Excellent interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

Database: Microsoft SQL Server (Versions: 16,14,13,12,11,10.5,10), Oracle (10g,11g,12c), Postgres, MySQL

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Azure Data Factory (ADF), Informatica - Power Center, Oracle Data Integrator, Talend Open Studio

Data Visualization: Power BI, Tableau, Power Pivot, Power View

Master Data Management: Microsoft Master Data Services, Microsoft Data Quality Services

Reporting Services: SQL Server Reporting Services (SSRS), Crystal Reports, Cognos

Data Modeling: Microsoft Visio, Erwin

Programming Languages: C#, Python, Scala

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Architect Consultant

Responsibilities:

  • Technical expert responsible for the architecture, design and implementation of BI/DW/Analytics solutions, with complete and accurate information information/ data delivery to business users using maintainable, systematic, and automated procedures.
  • Provide expertise and architectural leadership in the areas of Data Governance, Master Data Management, Analytics, Data Warehousing, Scorecards, Dashboards, Business Performance Monitoring.
  • Collaborate with business stakeholders throughout the company to assess and prioritize business intelligence and reporting needs; develop key performance indicators and dashboards and deliver reporting and analytic solutions to stakeholders providing data-driven insight into business performance, issues and initiatives.
  • Lead and oversee work of Business Intelligence (BI) Team, including setting direction, planning, assigning, scheduling and reviewing to assure work products meet quality standards.
  • Responsible for leading the team’s efforts in designing, developing, testing and implementing reports and solutions that utilize the underlying data stores.
  • Lead setting up Power BI architecture and implementation for analytical solutions that were decided to be used in the company
  • Lead Microsoft Master Data Services implementation in an effort to have centralized data across the whole company and also becomes the source of truth for Data Warehouse implementation.
  • Design, Maintain, and Enhance all other Data Models to support business initiatives through careful and planned design while managing model extensibility with performance
  • Ensure all the data warehouse architecture codes are maintained in a version control system.
  • Collaborate with business intelligence developers and business units to deliver an overall integrated reporting within the data warehouse platform.
  • Map configurations and complex data architectures, ensuring documentation meets current and forecasted need.
  • Lead design and build ETL architecture for the Data Warehouse and Data Mart using SQL Server Integration Services (SSIS).
  • Co-ordinate with business owners, stake holders and reporting team to address system improvements
  • Instrumental in creating an in-house tool for Meta data and data governance for quality purposes.
  • Lead Tabular Analysis Services solution using SSAS on the top of data warehouse to give access to business users using Power BI and excel power pivot.
  • Responsible for providing advanced technical skills and leadership in the design, development, control, and use of business data.
  • Contributes to the career growth and mentorship of the members of the Data Warehouse Team

Confidential

Data Warehouse Architect Consultant

Responsibilities:

  • Technical expert responsible for the architecture, design and implementation of BI/DW solutions, with complete and accurate information information/ data delivery to business users using maintainable, systematic, and automated procedures.
  • Provide expertise and architectural leadership in the areas of Data Governance, Master Data Management, Analytics, Data Warehousing, Scorecards, Dashboards, Business Performance Monitoring.
  • Designs and builds conceptual, logical and physical dimensional data models and third normal form artifacts.
  • Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
  • Engage with business stakeholders to gather requirements and create conceptual, logical and physical data models for data warehouse architecture using Ralph Kimball methodologies
  • Lead and oversee work of Business Intelligence (BI) Team, including setting direction, planning, assigning, scheduling and reviewing to assure work products meet quality standards.
  • Responsible for leading the team’s efforts in designing, developing, testing and implementing reports and solutions that utilize the underlying data stores.
  • Design, Maintain, and Enhance All Other Data Models to support business initiatives through careful and planned design while managing model extensibility with performance
  • Ensure all the data warehouse architecture codes are maintained in a version control system.
  • Collaborate with business intelligence developers and business units to deliver an overall integrated reporting within the data warehouse platform.
  • Map configurations and complex data architectures, ensuring documentation meets current and forecasted need.
  • Lead design and build ETL architecture for the Data Warehouse and Data Mart
  • Co-ordinate with business owners, stake holders and reporting team to address system improvements
  • Instrumental in creating an in-house tool for Meta data and data governance for quality purposes.
  • Lead Tabular Analysis Services solution using SSAS on the top of data warehouse to give access to business users using Power BI and excel power pivot.
  • Lead setting up Power BI architecture and implementation for analytical solutions that were decided to be used in the company
  • Responsible for providing advanced technical skills and leadership in the design, development, control, and use of business data.
  • Contributes to the career growth and mentorship of the members of the Data Warehouse Team

Confidential

Data Warehouse Architect / BI Consultant

Responsibilities:

  • Gathered business requirements and designed conceptual, logical and physical data models working in conjunction with the data warehouse architecture using Kimball’s paradigm.
  • Lead and improvised existing Enterprise Data Warehouse
  • Designed architecture for SSIS implementation and cube creation using SSAS
  • Involved in resource planning, preparing project plans and timelines for the projects involved.
  • Compiled source to target mapping documents to design the ETL jobs.
  • Build and Enhance Data warehouse according to the Business Requirements.
  • Worked on real time refresh on the data warehouse using Change Data Capture (CDC) method.
  • Created SSIS packages to load Dimensions and Facts in the DataMart.
  • Setup Database project within Visual Studio for the ETL process.
  • Developed Cubes using SSAS and experience in developing and extending OLAP cubes, Dimensions and Data Source Views.
  • Created Dimensions with the cube wizard and also generated Named Calculations and named queries.
  • Used Power Query to analyze, combine and refine data across different sources and also performed data cleansing operations.
  • Developed Power Pivot Reports in Excel by publishing them to SharePoint for providing ad-hoc reports according to client need.
  • Created score cards with executive summary dashboards using MS Office Performance Point Server 2010 Dashboard Designer that display performance monitoring measures for sales and sales trends deriving data from a SQL Server 2005/2008 OLAP data source and deployed them to SharePoint sites.
  • Responsible in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.
  • Responsible for performance tuning of the stored procedures and SQL commands in reports and troubleshooting of technical problems using Query Analyzer and Database Execution plan.
  • Extensive use of Team Foundation Server (TFS) to check in and check out source code and development code in multiuser environment.
  • Created Replication Publications and Subscriptions from the CRM application database.
  • Developed SQL Scripts to validate the data after the loading process. Modified and tested SQL stored procedures
  • Worked on QA testing by writing scripts for source and target data to verify the integrity of the data.

Confidential

Data Warehouse/ BI Architect Consultant

Responsibilities:

  • Gathered business requirements and designed conceptual, logical and physical data models working in conjunction with the data warehouse architecture using Kimball’s paradigm.
  • Developed collaborative partnerships across departments, business units and Allina to achieve results and improve performance.
  • Used four steps Dimensional design process - Select the business process, Declare the grain, Identify the dimensions, Identify the Facts.
  • Used Power Query to analyze data coming from different sources.
  • Designed and Developed SSIS packages to Extract, Transform and Load data from different sources to main server database tables.
  • Developed Cubes using SSAS and experience in developing and extending OLAP cubes, Dimensions and Data Source Views.
  • Created Dimensions with the cube wizard and also generated Named Calculations and named queries.
  • Created calculated measures and dimension members using MDX, mathematical formulas and user- defined functions.
  • Created MDX queries to retrieve data from the cube and also to display SSRS reports.
  • Designed and Developed SSRS reports for financial auditing and Vendor payment reconciliations.
  • Designed and deployed packages to Load data into Staging, QA, UAT and Production Environments with configuration files and deployment kit.
  • Extensive use of Active Batch Utility to schedule daily, weekly and monthly SSIS jobs.
  • Responsible in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.
  • Responsible for performance tuning of the stored procedures and SQL commands in reports and troubleshooting of technical problems using Query Analyzer and Database Execution plan.
  • Extensively used SSIS transformations such as Conditional Split, Lookup, Merge Join, Multicast and Aggregate, Script component.
  • Developed parameterized, drill down and aggregation reports using SSRS to ensure financial department and Order Supply department have same results.
  • Extensive use of Team Foundation Server (TFS) to check in and check out source code and development code in multiuser environment.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.

Confidential, Minneapolis, MN

Senior BI /ETL Lead Consultant

Responsibilities:

  • Ownership of 5 Complete Conversion Projects. Prepared detailed Software Requirement Specification (SRS) for the projects involved.
  • Involved in resource planning, preparing project plans and timelines for the projects involved.
  • Designed Data Model using Visio required for conversion project.
  • Gathered requirements and extensive communication with Business users and developed logical and physical data models for schemas using MS Visio.
  • Extensive use of Team Foundation Server (TFS) to check in and check out source code and development code in multiuser environment.
  • Designed high level ETL architecture for overall data transfer from Source to Destination with the help of SSIS.
  • Translated high-level requirements from the users to effective BI solutions.
  • Designed and developed SSIS (ETL) to Validate, Extract, Transform and Load data from different server locations and sources.
  • Generated Dynamic reports from Cubes (SSAS) using SSRS.
  • Created MDX queries to extract data from the Data Mart.
  • Designed and deployed packages to Load data into Staging, QA, UAT and Production Environments with configuration files and deployment kit.
  • Designed and developed backend stored procedures for Data Mapping Application for all the projects involved.
  • Designed and developed Verification SSIS packages for each ETL process to ensure data integrity and data validation.
  • Extensively used SSIS transformations such as Script component, Conditional Split, Lookup, Merge Join, Multicast and Aggregate.
  • Developed Audit, Balance and Control parameterized, drill down and aggregation reports using SSRS to ensure source and destination have same results.
  • Created Good News and Bad News reports for tie-outs using SSRS to ensure financial results balance while converting.
  • Generated month end reports for tie-outs and also on weekly basis using SSRS.
  • Extensively used formula fields, parameter fields, Running Total, Group selection and record selection in SSRS reports for writing new formulas in selecting different types of Sales.
  • Created jobs for all the SSIS packages to load data in various environments.
  • Responsible for performance tuning of the stored procedures and SQL commands in reports and troubleshooting of technical problems using Query Analyzer and Database Execution plan.
  • Responsible in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.
  • Conducted user training sessions and supported the requests for enhancements and modifications

Hire Now