We provide IT Staff Augmentation Services!

Senior Dw / Reporting Engineer Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • 9 years of IT experience (7 years in BI and DW) working for variety of companies within several industries mainly Retail, Insurance, Manufacturing and Government
  • Strong understanding of Data Warehousing methodologies and Data Modeling, normal forms, Star Schema, Snowflake Schema, Slowly Changing Dimensions, Fact tables, Dimension tables, type 1 and type 2, OLAP and OLTP systems
  • Experience with leading teams of 7 - 8 technical resources in ETL and Reporting
  • Consulting experience working for high profile consulting companies on several projects
  • Experience across all phases of SDLC and Agile from project initiation to post-implementation and support
  • Experience in ETL processes. Worked extensively on data extraction, cleansing, data integration, and loading from different data sources using DATASTAGE, Oracle PL/SQL, Unix Shell, Teradata and SAS EG
  • Knowledge of various data modeling methodologies: Kimball, Data Vault
  • Extensive knowledge of data warehouse design and development using Oracle 11g, Teradata and SQL Server
  • Developed database objects such astables, views, stored procedures, triggers, row-level audit tables, cursors, indexes, user-defined data-types, functionsandconstraints
  • Experienced inextracting,transformingandloadingthe data usingSSISin SQL Server 2005/2008/R2andData Transformation Servicesin SQL Server
  • Proficient in business intelligent tools for enterprise decision supporting like SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS) and SQL Server Analysis Service (SSAS).
  • Hands on experience with Checkpoints, breakpoints, Loggings and error handling in SSIS.
  • Extensive experience in MICROSTRATEGY architecture, design, advanced reporting, dashboards and administration
  • Developed and supported complex ETL jobs using IBM INFOSPHERE DATASTAGE. Integrated multiple data sources and processing stages, including performance tuning and optimization
  • Experience in Creating OBIEE Dashboards and Answers and BI Publisher reports

TECHNICAL SKILLS

Business Intelligence Tools: MICROSTRATEGY 9.2.1m - 9.3.1 - 9.4, 10.2, OBIEE, BIP, Oracle Reports, SAS

Programming/web: Shell Script, Perl, VB.Net & ASP.Net (1.1, 2.0), XML Web Services, Visual C++ .net, C#, XML, JavaScript, Java

Database: Oracle 9i/10g/11g, SQL Server 2014, Teradata 14 - SQL Developer, Toad

ETL Tools: IBM INFOSPHERE DATASTAGE 8.5, Oracle SQL Loader, PL/SQL, SAS

Other Tools: Erwin, Control-M, ACCUREV, GIT, MS Project, MS Visio, HP Quality Centre, PVCS, MATLAB, SHAREPOINT, SVN

Methodologies: AGILE, SDLC, Prince2, etc.

PROFESSIONAL EXPERIENCE

Confidential

Senior DW / Reporting Engineer

Responsibilities:

  • Leading technical development & implementation of ETL and Reporting for business solutions using Teradata, SQL Server, SAS, Shell Scripting and MICROSTRATEGY.
  • Design and development of Enterprise Reporting Solutions (Store Reporting, Sales, Profit and Loss, Offers, Leads, Conversions, Membership Movements, Retentions) using Teradata and MICROSTRATEGY 9.4., and Providing Self-Service Visual Insights Reporting for general managers, state managers and store managers.
  • Setting Up the Data Lake environment for operational reporting
  • Working across different teams to improve communication and knowledge transfer and create a new platform for this purpose.
  • Consolidating data from various sources such as IBM Mainframe, Oracle, SQL Server, flat files into Teradata EDW.
  • Developed and implemented reporting solutions for KPIs dashboard, Store Insights, Profit and Loss Dashboards, Offers flexible report, Laps Reporting and Channel Scorecard.
  • Defined standards for data warehouse design and implementation.
  • Conducted a full impact analysis and remediation of data warehouse migration from Teradata to SQL Server with Data Vault architecture.
  • Performance tuning of the existing ETL codes and reports.

Environment: MICROSTRATEGY, Teradata, SQL Server, SAS EG, AUTOSYS, Data Vault, Unix Shell, Amazon cloud

Confidential

Senior BI / DW Consultant

Responsibilities:

  • Design and development of Enterprise Reporting Solutions (Merchandising, Finance, Operations) using MICROSTRATEGY 9.4. Creating subscriptions using Distribution Services and NARROWCAST Server from the scratch.
  • Providing Self-Service Visual Insights Reports and Documents for general managers, category managers, suppliers and business users for all subject areas such as finance, marketing and operations. E.g. easy ordering, logistics, workforce management, financial reports and store reports.
  • Design and development of OBIIEE Dashboards and Answers for Customer Reporting and Loyalty.
  • Designing end-to-end ETL process (BRD, BFS, BRN, IFM, LDM, and TSD) including gathering requirements from users and stakeholders and coordination with data providers and source systems.
  • Leading technical Development & implementation of ETL for business solutions using Oracle 11g, Teradata, Shell Scripting and IBM DATASTAGE 8.5, including data validation and cleansing.
  • Developed and implemented more than 100 reports, documents and mobile/desktop dashboards for variety of projects mainly in finance, marketing, operations, insurance and workforce management.
  • Successfully migrated the whole Business Information Warehouse (BIW) from HP Superdome to Oracle Exadata in less than 4 month.
  • Delivered the full ETL process and reporting solution for 7 totally different projects including Fresh Produce ordering / reports, Supplier’s Income analysis / reports, Multichannel, Workforce Management, Fresh Store Assisted Ordering and Logistics.
  • Improved the performance of existing oracle scripts and legacy codes.
  • Successfully delivered code modifications for secure transaction processing of customer credit cards to be aligned with PCI Compliance.

Environment: Oracle 11g, MICROSTRATEGY 9.4, IBM DATASTAGE, OBIEE, BIP, SQL Server, Erwin, Unix Shell, Perl, CONTROL-M, ACCUREV, LIQUIBASE, HP Quality Center

Confidential

Data Analyst / Developer

Responsibilities:

  • Designed and developed a data migration solution to integrate data from various data sources into a centralized SQL Server 2008 database. Dealt with large weather data files was the main concern as the system required a fast and real time response. Developed a platform to load weather forecasts into the database and use it for trajectory prediction.
  • Analyzed source systems; identified data rules, violations and cleansing strategies.
  • Defined standards and implemented a framework for the development.
  • Defined and implemented the required business transformation rules and logics.
  • Implemented reconciliation processes; Identified and resolved inconsistencies.

Environment: SQL Server, Java, MATLAB

Confidential

Database / Data Warehouse Support

Responsibilities:

  • Support more than 200 finance and business users with their ADHOC reporting needs.
  • Providing data extracts out of DW to the business for user acceptance testing process.
  • Upgrading the database and software to new releases.
  • Managing the storage structures of the database.
  • Managing users and security.
  • Developing IPs and data extracts.
  • Managing schema objects, such as tables, indexes, and views.

Environment: Oracle, Windows Server

Confidential

Analyst Programmer / Sales Consultant

Responsibilities:

  • Analysis of business and organizational requirements for information management solutions.
  • Implementation of third party tools, plug-ins and components.
  • Tracking and monitoring the applications and providing resolutions to technical issues
  • Maintaining reports and other documents.
  • Identifying modification and renovation requirements for the application and developing update patches accordingly.

Environment: SQL Server, My SQL, C#, JAVASCRIPT, CSS, xml

We'd love your feedback!