Sign in

Engineer Data

Irvine, California, United States
December 12, 2018

Contact this candidate


Renu Sidgal

** ****** *****

Irvine, CA *****


SUMMARY: I am a self-motivated, result oriented and competent IT professional with more than 20+ years of IT & Business experience. Strong skills include Data Warehouse/ETL design from ground up, Dimensional & Relational data modeling, proficiency in SQL/MDX/DMX queries. I have experience in design and implementation of e-commerce transaction system, payment processing system, ETL in SSIS/Talend/Informatica and data analytics in Power BI/Tableau. Working as an independent consultant has aided me to be proficient in problem solving skills, accomplishing goals, meeting tighter deadlines, performing wide variety of complicated tasks in an extremely changing and stressful environment. Have extensive experience in database design optimization, development, analyzing data, and performance tuning queries. Furthermore, I possess excellent troubleshooting skills and can quickly resolve complex issues. I have performed the roles of a Data Warehouse/BI Architect, Data Architect, BI DBA, Project / Team Lead, Senior Database Engineer and Senior Software Engineer. EDUCATION Bachelor of Engineering in Computer Science, India Aug 87 to May 91 EXPERIENCE 22+ year(s) in T-SQL Programming and Database Performance Tuning 6 months self-learning of MS Azure and AWS

12+ years of dimensional and relational data modeling using ER/Studio 10+ years of SQL Server Integration Services (SSIS) 4+ years of ETL using Talend Data Management Platform 6.4 2+ years of ETL using Informatica Power Center

6+ years in Master Data Management and Data Quality Services Implementation 8+ years of Data Analytics using Power BI and Tableau 4+ years of SQL Server Analysis Services CUBE, 1+ year of Data Mining 7+ years of SQL Server Reporting Services (SSRS) and Crystal Reports Development 8+ years in web application development using .NET/MVC.NET, ASP.NET

MS Azure: SQL Data Warehouse, Data Factory, Data Lake (self-learning/certification work in progress)

AWS: Aurora, Redshift, AWS Pipeline (self-learning/certification work in progress)

Databases: SQL Server 2016/2014/2012/2008 R2 and earlier versions, MySQL, Oracle, Informix, MS Access and Fox Pro

Dimensional & Relational Data Modelling tool: ER/Studio Data Architect

ETL, OLAP Cube, and Data Mining: SSIS, Informatica & Talend for ETL, SSAS for OLAP Cube and Data Mining

Data Analytics: Power BI (cloud), Tableau (cloud & on-premises), SSAS, SSRS, Excel, Power Pivot, Power Query, Power View/Map etc.

Data Mining Algorithms: Microsoft Decision Tree, Time Series, Association & Clustering algorithms

Database Programming: TSQL, MySQL, .NET CLR Routines in, MDX Queries, DMX Queries, VB/C# scripting in SSIS, and DAX Expressions

Scripting Languages: Powershell, Python, and Perl

Products/ERP: Avalara, Microsoft Dynamics CRM, Great Plains, Oracle Financial, eSynergy, Macola, MAS90

Web Programming: MVC.Net, ASP.Net, VB.Net, C#.Net, jQuery, java script, PHP

Mobile Programming: Android, java

Additional Training/Classes: MS SQL Server DBA SQL Server Performance Tuning Advance Class/Workshop Master SQL Server Integration Services (SSIS Advance Class) Talend Enterprise Data Integration Administration & Development Talend Enterprise Data Quality Implementation Informatica Power Center Power BI Master SQL Server Analysis Services (SSAS Advance Class) Oracle Financials

Professional Experience

Data Warehouse/Business Intelligence Architect

Profit Recovery Partners – Dec 2014 to Present

Introduced and supported Power BI Tool set to power users and analysts for self-service BI in the company

Lead/developed a portal to manage and maintain the PRP Client Facing Dashboard web pages. This tool has saved the BI Team hundreds of hours in dashboard deployment and has been a game changer for the BI Team

Main contributor in PReSS (Profit Recovery & expense Savings System) project for o The alignment of data related processes and deliverables into a unified product offering o Features & functions are associated with modules and all rolled up into a single Client-Centric platform o Clearly defining the Product (PReSS) and Service (Consulting/Industry Expertise) offering PRP provides

Analyzing the requirements of a subject area, process evaluation, pre-stage the incoming data for the subject area

Data modelling based on requirements/process/pre-staged data. Once data modeling complete, implement to physical model, then stage and push the pre-staged data to the physical model thru ETL

Lead/developed Tableau, Power BI visualizations based on conformed dashboards from the management

Responsible for design, and development of Tableau data sources/security, interactive visualizations/reports, KPIs/Top N Expenses/Products/Locations, Level-of-Detail (LOD) expressions, INCLUDE, EXCLUDE, FIXED etc.

Automate the entire process for scalability

Responsibility also includes SQL Server database administration

Implemented Master Data Services by integrating Data Quality Services into SSIS

Work with different Practice Group teams (Logistics, Research and Services, Financial, Personnel, and Printing),Business Analysts team and Solution Management team

Coach/Train Associate Data Engineer(s) in BI Team Data Warehouse and Business Intelligence Solution Provider PharMedQuest - Jan 2014 – Dec 2016

As a part time consultant, implemented Data Warehouse and Business Intelligence solution for PharMedQuest, which is a specialty healthcare management company delivering quality, cost-effective care through the integration of medical and pharmacy info

Responsibility included dimensional data modeling of operational data using ER Data Architect, ETL using SSIS, and Dashboards/Reports using SSRS/Excel add-ins like Power Pivot/Query/View

Responsibility also included SQL Data Warehouse Database administration, performance tuning, speedup slow

/ blocking queries and resolve deadlocks

Business Intelligence DBA

Lucrazon Global – Feb 2014 to Dec 2014

Designed and built data warehouse for eCommerce business from ground up using SSIS

Responsible for design/development and automation of product download from fulfillment house/drop shippers location and uploading to MySQL database using SSIS package

Designed and developed a number of complex compensation plans using T-SQL, and automated these calculations to generate ACH Payouts for customers

Designed and developed Income Report using T-SQL for customers to show their income from various compensation plans

Provided support for MS CRM and MS Great Plains

Designed and developed SSIS packages to automate the process of parsing Bank statements for ACH debit and credit payments and inserting ACH transactions into MS CRM database

Implemented Report Manager in SSRS as a one-stop point to get reports within the entire company. Reports included eCommerce orders, Analysis reports, Data reports, Processing reports, Inventory reports, Accounting reports, all exposed in Report Manager. eCommerce Orders being emailed to appropriate Fulfillment Houses

Set up Replication for eCommerce database

Participated in design and development of API using for Products/Orders management with fulfillment houses

Senior Database Engineer / Database Analyst / Software Engineer PADI Worldwide – Nov 2008 to Feb 2014

Implemented Report Manager in SSRS as a one-stop point to get reports within the entire company. Reports include Analysis reports, Executive Dashboard/KPI reports, Data reports, Processing reports, Inventory reports, Accounting reports, all exposed in Report Manager

Designed and built data warehouse from ground up, gathering/cleaning data from various servers using SSIS/T- SQL jobs as part of ETL process

Know how to quickly load a fact table, dimension table of a data warehouse

Development/processing/deploying of SSAS Cubes

Automated SSAS Cube processing through Cube Processing tasks of SSIS

Implemented and designed Data Mining Models/Structures using MS Time Series and Association Rules algorithms

For a B2C application, implemented product recommendation engine using MS Association algorithm

Implemented data mining MS Time Series algorithm for analysis of product sales/growth and provided results of it in the form of SSRS charts

Deploy/Configure/Administer SSIS packages in SQL Server 2012

Implemented Master Data Services by integrating Data Quality Services into SSIS (SQL Server 2012)

Responsible for conducting and managing Report meetings with super users

Implemented Active Directory security for reports on Report Manager so that each office in any report can view only their data. This is a requirement in the companywide reports for security. The effort is a 2-step development. A REST web service was developed .NET CLR that is being called by a T-SQL stored procedure before any report execution

Designed/implemented data marts for executive reports like Customer Ranking, Report Cards, State of the Business, and Dashboard reports

Developed numerous Excel/Power Pivot reports as front ends to SSAS Cube and have exposed in Report Manager

Developed .Net user interface to expose SSRS reports like Customer Report Cards in PADI’s web site

Created Power Query, Power Pivot, Power View and Power Map reports and deploy as part of SharePoint BI

Implemented payment processing black box in 4.0 that could be used for all/any B2C .Net web applications at PADI

Implemented payment processing for Paypal Direct, Paypal Express Checkout and Datatrans credit card payment processors

Implemented Tax processing system used by all .Net web applications. Taxes being calculated both for merchandise/non-merchandise products sold in Europe/Australia/Canada with multiple currency. Used Avalara Tax for US only sold merchandise products

Senior Consultant II

Nexgenix – From May 1996 to Mar 2001

As a team leader was responsible for getting user requirements, team management, code review, allocation of the work to team members etc.,

As a DBA/Database Analyst was responsible for monitoring data, data modeling, stored procedures development, programs optimization etc.,

As a Report Writer was responsible for design, development of many financial reports which were Projected Revenue Report, Project P&L Report, Revenue Analysis Reports – to analyze the projection versus actual growth of the company weekly/monthly/quarterly/six months. Various reports were developed helpful to the consulting businesses. Other reports included processing reports for Accounts Receivables and Accounts Payable departments. These reports were developed using Crystal Reports and were linked to desktop/web applications through a user interface

Database Engineer / Database Analyst / Web programmer / Software Engineer Independent Consultant – From 1997 to 2008

Implemented Data Warehouse and Business Intelligence solutions. Involved in end to end process from ETL of operational data to dimensional model using Informatica Power Center, and designing dashboards/analytics using SSRS/Excel add-ins like Power Pivot/Query/View

Responsible for complete design/implementation/support of the operational database for all the applications developed

Responsible for complete development of T-SQL jobs for all the applications developed

Developed T-SQL procedures, triggers, functions, optimization of stored procedures

Interacted extensively with users to collect requirements for creating customized reports

Responsible for complete design/development/support of various reports developed in SSRS & Crystal Reports

Provided user interface and exposed SSRS reports in desktop applications/web applications developed by me

Responsible for complete design/development of web applications as an independent consultant

Worked on a mobile application in android, 4 for a stock market application. It involves data mining of the stock market data and expose data as charts in the application Few Projects include

Quick Delivery System – an application developed to place food orders at various restaurants and deliver orders to respective customers. Order report/analysis reports were developed using Crystal Reports

Investment Management System developed for Investment Clubs – Enabled members to log on to the application to view their positions, transactions, performance and view reports. Reports were developed in SSRS 2005 and exposed in the application

Project Management Application – Application developed to completely manage Customers and Project life cycle. Enabled customers to create a project profile, and to initiate a project formally. Email/notifications sent to various parties regarding the new project submission and approval. Maintained the life cycle of projects. Reports developed in SSRS 2005 and exposed in the application

HR department application - This was a report project. The project involved capturing HR related data from various companies. Based on each company requirements web-based reports were developed with SQL procedures and crystal reports

Accounting Software – Developed accounting application for a Clothing manufacturing company in India. The project was a team of 2 people. Various accounting reports were developed for the users

Inventory Management Software – Developed application for inventory management for a manufacturing company in India. Involved in the project after half way developed and participated to its completion REFERENCES

Available upon request

Contact this candidate