Senior Dw / Reporting Engineer Resume
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
