We provide IT Staff Augmentation Services!

Sr. Data Warehouse Resume Profile

SUMMARY

  • Data warehouse and Business Intelligence Architect/Lead Developer with over 9 years of hands-on and strategic roles in Full Development Life-cycle of Data Warehouse and Business Intelligence ETL, Cube, Report Model and Report Solutions, including requirement gathering and analysis, data modeling, data analysis, implementation, testing, maintenance, support and documentation.
  • 9 years of experience in modeling and implementing Star and Star-Flake Hybrid Schemas based on Ralph Kimball's Dimensional Modeling principles and best practices.
  • 9 years of experience in designing and developing various types of Fact Tables such as Transactional, Periodic Snapshot, Accumulating Snapshot, Temporal Snapshot, Covered and Fact-less Facts.
  • 9 years of experience in designing and developing Dimension Tables such as Conformed, Inferred, Date, Time, Slowly Changing Dimensions, Degenerate, Junk, Role Playing, etc.
  • 8 years of experience in extracting, scrubbing and loading large sets of data from Relational and Non-Relational data sources using SQL Server Integration Service SSIS , Data Transformation Services DTS and Bulk Copy Program BCP .
  • 8 years of experience in designing and developing periodic and ad-hoc Charts, Graphs, Maps, Dashboards and Tabular Reports using SQL Server Reporting Service SSRS and Crystal Report
  • 6 years of experience in designing and developing Tabular and Multidimensional Models using SQL Server Analysis Service SSAS
  • 8 years of experience in designing and creating SQL Server Agent Jobs and Schedules to automate Cube Processing, ETL Processing, Database Maintenance, Index Optimization and Report Delivery.
  • 9 years of experience in designing and creating Tables, Views, Indexes, Stored Procedures, DML Triggers, DDL Triggers, Constraints, User Profiles, User Defined Functions, SQL Mail, Alerts, Agent Jobs, Partitioning, Index Analysis, Backup, Recovery, etc.
  • 9 years of experience in Query Optimization and Tuning Indexes, OLAP Cubes, Reports, Report Models and SSIS Packages to improve Performance and Availability.
  • 9 years of experience in Data Profiling, Cleansing and Quality Tracking.
  • 7 years of experience in Test-Driven and Incremental Development Process.
  • 4 years of experience in Object Oriented Programming and Design Patterns.
  • Lead and Mentor other team members.
  • Certificate of Appreciation awarded to me in recognition of my outstanding performance in support of the United States Department of Agriculture Executive Management Systems Office EMSO .
  • Rookie of the Year Award in recognition of being the most outstanding newbie of the season ViaTech Employee Award .
  • Good interpersonal skills and successful in working with people from different cultures and backgrounds.

TECHNICAL SKILLS

  • Databases: Microsoft SQL Server 2000/2005/2008/2008R2/2012/2014 Oracle 10g/11g Netezza TwinFin DB2 HBase 0.96.0 MySQL 5.6
  • Business Intelligence Tools: SQL Server Integration Services SSIS 2005/2008/2008R2/2012 SQL Server Reporting Services SSRS 2005/2008/2008R2/2012 SQL Server Analysis Services SSAS 2005/2008/2008R2/2012 PowerPivot Power Query Power View Power Map Oracle Business Intelligence Enterprise Edition OBIEE 11g Informatica PowerCenter 9.1 SharePoint InfoSphere DataStage 9.1
  • Database Design and Modeling: CA Erwin Data Modeler DBManager MS Visio
  • Unit Testing Framework: tSQLt
  • Programming Languages: T-SQL NZSQL PL/SQL C VB MDX R Hive Pig
  • Development Processes: Agile Test Driven
  • Methodology: Ralph Kimball Bill Inmon Hybrid
  • Source Control: TFS VSS GitHub
  • Development Tools: SSDT BIDS SSMS Oracle SQL Developer WinSQL Aginity

EXPERIENCE

Sr. Data Warehouse/Business Intelligence Consultant

Worked on various projects that involve designing, implementing and supporting Data Warehouse and Business Intelligence solutions that support various business decisions on Provider, Clinical, Consumer and Sales Insights.

  • Designed and implemented Consumer Knowledge Base Management Data warehouse to support Consumer and Sales insight initiatives. The data warehouse includes 3 Facts and more than 20 Dimensions.
  • Designed and implemented the ETL Process to populate the Consumer Knowledge Base Management Data warehouse. The source data come from structured and unstructured sources.
  • Worked closely with Solution Managers and Business Analysts to define data and reporting requirements, data dictionary,
  • Designed and implemented various Fact and Dimension upgrades to support ICD-10 conversion initiative. The changes were implemented on various subject areas such as Preventable Patient ER Visit, Provider Insight, Clinical, etc.
  • Lead other team members.

Technology: Netezza TwinFin, SQL Server 2012 SSIS 2012 InfoSphere DataStage 9.1 T-SQL NZSQL C CA Erwin Data Modeler TFS 2013 WinSQL Aginity Workbench

Sr. Data Warehouse/Business Intelligence Consultant

Responsible for architecting and modeling Financial Management Information System's Operating Ledger Data Mart Solution from the ground up. The solution was designed to support various business decisions related to Sponsored and Non-sponsored Projects.

  • Designed the Data Warehouse and Business Intelligence environment software and hardware architecture design.
  • Worked on source data discovery and data profiling to determine data quality and availability.
  • Designed a dimensional data model for the Operating Ledger Data Mart. The model involves 3 Fact Tables and over 12 Type 2 and Type 1 Dimension Tables.
  • Designed a security table that is used for a project based user authorization.
  • Created a data dictionary that shows source to data mapping i.e. source extract and transformation/mapping rules , change data capture requirements, and target table properties. ETL Developers, Report Developers, Business Analysts and other Users will use the document.
  • Created a DDL Script to implement the Dimensional Model.
  • Worked closely with Business Stakeholders to define data and reporting requirements.
  • Lead and mentor other team members.

Technology: SQL Server 2012 SSRS 2012 SSIS 2012 SSAS 2012 T-SQL C CA Erwin Data Modeler

  • Responsible for architecting, modeling, and implementing Organizational Effectiveness's Data Warehouse Solution from the ground up. The solution was designed to support various business decisions related to Student, Finance and Human Resource.
  • Worked with the project manager to design a template for gathering data and report requirement.
  • Worked closely with Business Stakeholders to define data and reporting requirements.
  • Design the Data Warehouse and Business Intelligence environment software and hardware architecture and prepared a best practice document.
  • Design an SSIS package template that can be reused by other developers to extract data from PeopleSoft and other miscellaneous data sources.
  • Design a dimensional data model for the Student Data Warehouse. The model involves 7 various Fact Tables and over 45 Type 2 and Type 1 Dimension Tables.
  • Created a DDL Script to implement the Dimensional Model.
  • Design the ETL workflow diagram and worked on creating ETL process i.e. Stored Procedures, SSIS Packages, SQL Server Agent Jobs to populate the Student Data Warehouse
  • Lead and mentor other team members.
  • Create unit test case routines for testing tables, stored procedures, triggers, functions, SSIS packages, etc.

Technology: SQL Server 2012 SSIS 2012 SSRS 2012 SSAS 2012 T-SQL C MS Visio

Data Warehouse/Business Intelligence Architect

  • Responsible for architecting and leading the development effort to implement a Data Warehouse and Business Intelligence Solution from the ground up. The solution was designed to support various department and teams such as Loan Servicing, Loan Origination, Deposit Operation, Compliance, Accounting, and Collection.
  • Coordinate and guide the management team to prioritize projects and deliverables. It includes hosting Proof of Concept sessions on various stages of the project.
  • Work with the business analyst to define business and reporting requirements templates.
  • Design the Data Warehouse and Business Intelligence environment software and hardware architecture.
  • Design and implement Staging Database and its ETL process to get data from hybrid data sources, Operational Data Store and its ETL Process, Data Warehouse and its ETL process as well as Reporting and Analytics Solutions Data Cubes, Reports, and Report Models .
  • Design and lead the implementation of company wide data dictionary/metadata repository.
  • Design and develop Stored Procedure based parameterized periodic and ad-hoc Charts, Graphs, Maps, Dashboards and Tabular reports with drilldown and drill through capability.
  • Create routines to log and notify data movement Audit Information such as number of insert count, update count, delete count, error, warning, username, timestamp, duration, etc.
  • Create multiple SQL Server Agent Jobs to automate ETL and database maintenance processes.
  • Develop a Utility for profiling, validating and cleaning data in the Operational Data Store.
  • Develop a routine that detect, store and alert any Activity/Change that happened within the Data Warehouse and the Business Intelligence Environment.
  • Lead and mentor other team members.
  • Create unit test case routines for testing tables, stored procedures, triggers, functions, SSIS packages and OLAP Cubes

Technology: MS SQL Server 2008R2/2012 SSIS 2008R2/2012 SSRS 2008R2/2012 SSAS 2008R2/2012 T-SQL MDX C TFS ASP.NET JQuery PowerPivot Hadoop Hive Pig Impala Hue, Erwin Data Modeler

Sr. Data Warehouse/Business Intelligence Engineer

Worked on various projects that involve designing, implementing and supporting data warehouse and Business Intelligence solutions that support claims, policies and financial management systems.

  • Senior member of the team that designed and implemented Claims Data Warehouse.
  • Implemented ETL solution for the Policy and Financial Management Data Warehouse.
  • Design and implement Data Mart, ETL process and OLAP Cube for IT Finance.
  • Work closely with business users, managers, and business analysts to gather and refine requirements for reports, dashboards, report models, ETL processes and data warehouse developments.
  • Collaborate with testers and business users to make sure business scenarios are covered in test cases.

Technology: MS SQL Server 2005/2008/2008R2 SSIS 2005/2008/2008R2 SSRS 2005/2008/2008R2 SSAS 2005/2008/2008R2 IBM DB2 Oracle 10g T-SQL MDX PL/SQL VB.NET VSS TFS Visio Oracle SQL Developer SharePoint.

Sr. Data Warehouse/Business Intelligence Engineer

Worked on various DW/BI projects which involve designing, implementing and supporting solutions to support the claims management operation and facilitate the decision making process.

  • Design and implement Claims Staging database and its ETL process. The data come from hybrid data sources such as Claims Management System, Policy Management System, Check Management System and Financial Management systems . It is used to facilitate the daily incremental data refreshing process.
  • Design and Implement Claims Operational Data store and its ETL Process.
  • Develop 40 Claims related operational Daily, Weekly, Monthly, Tabular, Graphical, dashboard, etc. reports. Some of the reports are based on OLAP Cubes.
  • Design and develop Claims Management Report Model along with its underling Start-Schema data mart and its ETL Process for ad hoc reporting

Technology: MS SQL Server 2005 SSIS 2005 SSRS 2005 SSAS 2005 IBM DB2 Oracle 10g DBMS VB.NET T-SQL MDX PL/SQL MS Visual Source Safe SharePoint

Software/Database Engineer

Member of a team that developed MS Web Deployment Tool: a tool to migrate and synchronize Databases, BI Components, Configurations, Web Servers, Websites, Security Certificates, GAC Assemblies, COM Objects, etc.

  • Developed a library component for SQL Database, SQL Scripter, Web Server, Registry key, Registry value, Certificate, COM Object, Manifest, Directory and File providers.
  • Developed test automation tool for the tool.
  • Developed schema, user defined data types, tables, views, constraints, stored procedures, triggers and user defined functions and imported data from external sources using SSIS

Technology: MS SQL Server 2005 SSIS 2005 T-SQL XML, C , ASP.NET, ADO.NET, Product Studio, Source Depot

Senior Software Engineer

Member of a team that developed eteligis: a web based application that facilitates distribution of corporate and private press release to various news outlets and other distribution points. The application is integrated with different external applications and data warehouse.

  • Worked with business analysts to determine ETL, analytical, and report requirements.
  • Reviewed and modified the database design to eliminate redundant and inconsistent data.
  • Worked on the database schema design and developed tables, constraints, user defined data types, indexes, views, user defined functions, stored procedures, triggers, Alerts, agent jobs, etc.
  • Worked in the full ETL life cycle and solely responsible for the design, development and maintenance of SSIS packages.
  • Created unit test case scripts for testing tables, stored procedures, and triggers.
  • Designed and developed complex reports containing charts and graphs using SSRS.
  • Create various ad hoc queries based on user requirements.

Technology: MS SQL Server 2005 SSIS 2005 SSRS 2005 SSAS 2005 C , T-SQL MS Visual Source Safe Issue Manager DBManager.

Software Engineer

Member of a team that developed Shared Registration Service: a web based multi-tier service to help all web applications to maintain association between eAuthenticationID and Shared Employee ID. The system avoids manual pre-registration of all users in every application's database by registering users automatically upon first login. The service is consumed by all web applications.

  • Participated in designing the system architecture using layered approach.
  • Created the physical and logical database design as well as the database implementation.
  • Addressed query performance issues associated with stored procedures and tables.
  • Created unit test case scripts for testing tables, views, indexes, stored procedures, and triggers.
  • Created deployment scripts to upload the database to the production server.
  • Created different DTS to import payment information from different data sources and they were later upgraded to SSIS packages.
  • Created unit test case scripts for testing tables, stored procedures, and triggers.
  • Optimized the query performance by modifying stored procedures and creating indexes whenever necessary.
  • Used SQL profiler extensively for performance tuning.
  • Involved in the physical and logical database design as well as the database implementation
  • Part of a team that developed Improper Payments Information Act: a web based multi tier application to estimate improper payments and report on actions to reduce them. It was initiated in response to Federal Agencies making more than 2 trillion in payments to individuals and a variety of other entities each year.
  • Designed and developed reports containing charts and graphs using crystal report and later converted to SSRS.
  • Create SSIS package to migrate existing data to the new database on the production server.
  • Designed and developed reports containing charts and graphs using crystal report and later converted to SSRS
  • Deployed the reports in a SharePoint portal site.
  • Wrote ad hoc queries to extract historical data based on various dimensions.

Technology: MS SQL Server 2000/2005 SSIS 2005 SSRS 2005 ERWIN C 2003/2005 ASP.NET 2003/2005 Crystal Report T-SQL MS Visual Source Safe Share Point Server MS Excel.

Software Developer

Part of a team that developed Legal Case Tracking Management: a multi-tier distributed XML Web service, consumed by web and windows based clients. The system connects the Central Legal Department Office with six zones and a dozen regional offices. It interfaces to Finance System and Human Resource Management System.

  • Involved in analyzing the requirement, as well as designing and implementing the system architecture and layering, using variation oriented design, to make the system extensible.
  • Involved in analyzing the requirement, as well as designing and implementing the system architecture and layering, using variation oriented design, to make the system extensible.
  • Part of a team that developed Employee Association Membership Management: a window based application that keeps track of member's registration, deposit, withdrawal, dividend and events.
  • Designed and developed complex reports containing charts and graphs.
  • Develop the data access component.
  • Involved in the physical and logical database design and implementation of the database.
  • Involved in the physical and logical database design and implementation of the database.
  • Develop the data access component.
  • Designed and developed complex reports containing charts and graphs.

Technology: C 2003 ASP.NET2003 Web Services ADO.NET Ajax Rational Rose MS Visual Studio.NET MS SQL Server MS Project MS Visual Source Safe

Hire Now