We provide IT Staff Augmentation Services!

Data Warehouse Architect Resume

SUMMARY:

  • Experience in Insurance, Financial, Manufacturing, Sales, Retail and E - Commerce.
  • I have around 10+ years of experience in Software Development, Analysis and QA activities
  • Flexible to work on Waterfall, Agile, Scrum Agile methodologies.
  • Strong experience in SAP BODS 4.2 ETL development.
  • Experience in in SAP HANA 2.0 data designing and SAP HANA SQL
  • Strong experience in ETL and ELT models.
  • Worked on SAP BODS 4.2.5 Data cleansing for Address (Person firm (URAC)), profile and phone.
  • Worked on SAP BODS 4.2 deployment and worked with configuration management and parameters in SAP BODS 4.2
  • Strong experience in Data Warehouse Modeling designing design.
  • Proven experience in Data Migration of legacy data bases to Modern databases.
  • Experience in Web services and XML with Real-time jobs in SAP BODS for data cleansing
  • Expert in creating SQL Queries, PL/SQL Packages, Function, stored procedures, triggers, and cursors, Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad
  • Knowledge of Extraction, Transformation and Loading (ETL) process to load the database
  • Worked with Various data sources like File system (.csv, .xls,.xlsx, flat), SQL server and Oracle.
  • Worked on SSIS 2012 Package deployment and worked with SSISDB and parameters in SSIS 2012
  • Implemented various dashboards with different kinds of pictorial representation by using pi-charts, Bar-Charts, Trending. etc.
  • Implemented Drill through and Drill down reports from Dash boards using SSRS.
  • Implemented Share Point Reports using Report Builder and Power view with Power pivot.
  • Worked on Share point deployment or the reports.
  • Implemented SSRS style sheet model for easy maintenance and uniformity across all the reports
  • Ability to interact with business analysts, Experience in Analyzing Functional Requirements and implement the requirements to achieve the target
  • Involved in Scrum meeting and Bug Triage meetings with entire team.
  • Experienced in waterfall, Agile and Scrum Agile working environment.
  • Proven experience as lead to maintain bigger team size(more than 20)
  • Demonstrated ability to work as a team lead, team player as well as an Individual.

TECHNICAL SKILLS:

ETL Tools: SAP BODS 4.X, SSIS 2008R2/2012, DTS

Database Tools: SQL Developer, Toad, SSMS, SAP HANA Modeler (eclipse neon)

Languages: SQL, PL/SQL, C#.Net, VBA scripting

Reporting Tools: SSRS, SharePoint report builder

Databases: Oracle 8i/9.2/10g/11g, SQL Server 2005/2008/2008 R2/2012, SAP HANA 2.0

Operating System: Windows 7/XP/NT/Vista, MS-DOS

Known Tools (understanding): Confidential Power BI, SAP LUMIRA, SAP BO reporting, HDFS, Hive, Kafka, NiFi, Druid

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Architect

Responsibilities:

  • Production and Sales data in one place to enable Data Scientists to perform Analytics on top of it.
  • We are in the process of building POC using Confidential Azure Cloud and HDFS as data storage.
  • We are using Nifi to replicate the data from various sources in real time for POC.

Tools: & Technologies: Apache NiFi, Apache Kafka, HIVE LLAP, Confidential Azure, Azure SQL, SAP HANA 2.0, DRUID, MS VISIO

ERP systems: Confidential, PARC (Capstone), Oracle ERP, Factory Talk (Panel view), Radius (ERP on Progress DB).

Confidential

Data Warehouse Architect

Responsibilities:

  • Analyzed all the source models and collected various data point to understand the user needs
  • Build new SAP HANA data model to accomplish all the divisions requirement
  • Identified the required reports and dashboards for various divisions.
  • Based on the requirements we implemented the Calculation Views (As SAP Corporation suggested we get rid of all Attribute and analytical views and migrated all of them to calculation views)
  • Provided guidance to the UI team to implement Dashboards using LUMIRA Designer (2.0)
  • Responsible for CRP (Conference Room Pilot with Actual end Users to get the feedback from them (As this is the first HANA based cloud solution we asked feedback in various phases).
  • Responsible for complete integration of Paper division ERP system and PARC (Capstone) system to SAP HANA Cloud.
  • After successful rollout of Paper Division we are working with other Divisions now.

Tools: & Technologies: SAP BODS 4.2, SQL Server 2012, SAP HANA 2.0, Oracle 11g, Golden Gate, AGILE Scheduler, MS VISIO

Confidential

Data Warehouse Architect

Responsibilities:

  • As part of Confidential Business Technologies (BT) BI and DWH Team I am responsible for below activities
  • Responsible for Architecture and data flow Design to migrate the Legacy DWH to Integrated Data Warehouse.
  • Responsible for Guiding the Offshore team for Development strategies and approaches.
  • Daily interaction with Client and understand the new requirements and suggest appropriate solutions for the issues
  • Design the new DataMart and Data Vault for new Divisions integration.
  • Build Integrations between all the source systems to SAP HANA 2.0 Cloud platform to enable Analytics.
  • Providing daily extract to Price-FX, Logility and SOP forecasting systems for Demand forecasting the sales analytics.
  • Providing the data to TransPlace and CAS transportation systems on weekly basis to give the provision of deciding better business with tenders and Logistics suppliers.
  • Responsible for preparing and presenting application health statistics and test execution progress status reports for SMR in prescribed templates
  • Working as Team player whenever any team member struck with issues and whenever project requires expertize
  • Interacting ESKER e-Invoicing system team for invoice generation and notification to global customers and implementing the complex requirement to push all the invoice/orders from ORACLE ERP system.
  • Responsible for cleanse the data from various ERP systems and divisions and reconcile it to slandered format and globally accepted way.
  • Responsible for Captive Project data ware house which build on Oracle project management.

Tools: & Technologies: SAP BODS 4.2, SQL Server 2012, SAP HANA 2.0, Oracle 11g, Golden Gate, AGILE Scheduler, MS VISIO

Confidential

Technical Project lead

Responsibilities:

  • Responsible for upgrading the existing software from 3.1 (BODI) to 4.2.5 (Data services) without any business impact.
  • Understand the Requirement which were implemented in 3.1 and need to implement the same with 4.2.5 with latest features and best performance.
  • Upgraded the repositories from 3.2 to 4.2.5 and fixed the issues with the upgrade.
  • Responsible for real-time jobs upgrades which will deals with 1.5 million of requests every day from various sources for address cleansing.
  • Design batch jobs for handling millions of records to provide address standardization for various systems.
  • Communicate with for AIX admins and DB admins to setup the new systems for production deployment.
  • Re-designed the most complex tightly coupled batch jobs to loosely coupled and easily maintainable jobs.
  • Implemented lots of complex custom functions to obtaining the desired business output.
  • Worked with Nested schemas to handle the XML files (as Source and target)
  • Tracked project health with Confidential MPP and published the Weekly and monthly reports for Project status.
  • Responsible for address standardization of customer base with help of Web services(SAP BODS build)

Tools: & Technologies: SAP BODS 4.2, DB2 9.x, AIX 6.1

Confidential, Denver, CO

Technical Project Lead

Responsibilities:

  • Analyze the requirements from FSD and provide feedback.
  • Responsible for development, design and implementation of application systems using Oracle PL/SQL and SAP BODS architecture. Serve as member of a project team or as an individual contributor when required.
  • Conducted and driven the mapping sessions with DOL to identify the mapping between Legacy system (DB2) and modern OLEDB system (Oracle)
  • Designed Analytical data warehouse to perform fraud analytics ( identify fraud applicants)
  • Implemented multiple interfaces/Web services using SAP BODS to connect with various systems like Banks, Jails, Cruse, IRS, Hospitals etc.. and identify fraud claims from claimants.
  • Automated the whole testing suite to test the SAP BODS jobs data.
  • Based on the requirements and generated dashboards and score cards in EXCEL using VB macros.
  • Designed complex, global or strategic development projects. Identify and address interfacing functions and applications.
  • Establish and maintain naming conventions for packages, classes, interfaces, methods, and variables. Naming conventions will use best practices for the various technologies used.
  • Responsible for preparing and presenting application health statistics and test execution progress status reports for SMR in prescribed templates.
  • Responsible for PCI Audits for 4 states data conversion teams

Tools: & Technologies: SAP BODS 4.2, ORACLE 11G, SVN

Confidentia

Team Lead and Data Analyst

Responsibilities:

  • Responsible for development, design and implementation of application systems using MS SQL SERVER, SSIS, and SSRS architecture. Serve as member of a project team or as an individual contributor when required.
  • Implemented complex ETL Jobs to read and consolidate the data from multiple sources from various auditors across the globe.
  • Performed data cleansing for all the source files (excel, csv, dat, txt) to standardize and remove the bad data from input
  • Design and developed AUDIT data warehouse for internal audit team from INTEL Corp.
  • Implemented various drill down and drill through reports and dash boards to analyze the expenses at various levels using SSRS and SharePoint reporting.
  • Designed and published Tabular data model for giving the provision to generate Power view reports using power pivot from SharePoint interface.
  • Developed an automated (Script based) test suite for testing the ETL jobs.
  • Responsible for preparing and presenting application health statistics and test execution progress status reports for SMR and MBR in prescribed templates.

Tools: & Technologies: SSIS, SSRS, MSSQLSERVER2008

Confidential

ETL Developer and Team Lead

Responsibilities:

  • Assist in the development, design and implementation of complex SSIS requirements to deliver on time
  • Develop dynamic reports using Report builder and power view at SharePoint 2010 Implemented
  • Develop ETL packages to get the large amount of data from various systems and different sources like .CSV, Flat files, Excel files, SQL server with liked servers etc.
  • Responsible for SSIS packages deployment in dev. and test environment

Tools: & Technologies: SSIS, Confidential Visual Studio .Net 2008, MSSQLSERVER2008

Confidential

ETL Developer and Team Lead

Responsibilities:

  • design and development of windows service and business logic for dll
  • Interaction with projects seniors to understand the Business requirements.
  • Developed Stored procedures in SQLServer2008r2
  • Developed SSIS package to get the data from ORACLE Source tables
  • Involved in deployment and release.

Tools: & Technologies: SSIS, Confidential Visual Studio .Net 2008, MSSQLSERVER2008

Hire Now