Renu Sidgal

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

Irvine, CA *****

949-***-****

ad0pn3@r.postjobfree.com

SUMMARY: I am a self-motivated, result oriented, and competent IT professional with more than 20+ years of IT & Business experience. I have solid technical background in BI Technologies, strong analytical and conceptual skills, excellent interpersonal, relationship-building, teamwork, and communication skills and experience working the Agile SDLC methodology. Working as an independent consultant has trained me to be proficient in problem solving, accomplishing goals, meeting tight deadlines, and performing a wide variety of complicated tasks in a changing and challenging environment. I have extensive experience in database design & optimization, development, and data analysis. Furthermore, I possess excellent troubleshooting skills and am able to quickly resolve complex issues. I have performed the roles of a Project/Team Lead, Data Warehouse/BI Architect, Data Architect, BI DBA, Senior Database Engineer, and Senior Software Engineer.

EDUCATION Bachelor of Engineering in Computer Science EXPERIENCE 22+ year(s) in Database development and performance tuning 4+ years in Snowflake Cloud Data Platform

8+ years of MS Azure SQL Database, and Azure Data Factory 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 8+ years in Master Data Management, Data Governance & 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 8+ years in web application development using .NET/MVC.NET, ASP.NET TECHNOLOGIES

• Snowflake Cloud Data Platform

• MS Azure: SQL Database, Data Factory, and Data Lakes

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

• ITSM Platforms, Products, and ERP: ServiceNow, Tanium, Veracode, Microsoft Dynamics CRM, Great Plains, Avalara, Oracle Financial, eSynergy, Macola, and MAS90

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

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

• Dimensional & Relational Data Modelling tools: ER (entity relationship) Studio Data Architect

• Extract Transform Load, OLAP Cube, and Data Mining: MS Azure Data Factory, SSIS, Informatica & Talend for ETL, MS SSAS for OLAP Cube and Data Mining

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

• Scripting Languages: Python, PowerShell and Perl

• Database Programming: TSQL, MySQL, .NET CLR Routines in vb.net, MDX Queries, DMX Queries, and DAX Expressions

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

• Mobile Programming: Android, Java

BI Professional Training, and Certification: Snowflake Database Engineer, MS SQL Server DBA SQL Server Performance Tuning Advance Workshop Master SQL Server Integration Services (advance training) Talend Enterprise Data Integration Administration & Development Talend Enterprise Data Quality Implementation Informatica Power Center Power BI Master SQL Server Analysis Services (advance training) Oracle Financials Professional Experience

Business Intelligence Specialist

First American – Jan 2019 to Oct 2023

• Being the first person hired into the Infosec Business Intelligence team, I have single handedly managed reporting and dashboard needs across all Infosec verticals by identifying business requirements and providing business intelligence solutions to enable informed decision-making for the stakeholders

• Successfully managed a multi-million-dollar project by seamlessly working together with Deloitte consultants to establish the reporting infrastructure and data using BI technologies

• Wore multiple hats and filled in many roles with in the Business Intelligence team, including as an architect, project manager, and a hiring manager

• I have trained team members in all aspects of reporting and dashboard projects and BI technologies

• Main responsibilities included:

o Architect database and models

o Data marts creation/management in MS Azure SQL Database, and Snowflake o Extract, transform, load data using MS Azure Data Factory and Snowflake o Design/development of BI Visualizations by working closely with stakeholders o Create Dashboards using Tableau and Power BI

o Python programming to download data from ServiceNow, Tanium, and Veracode data into MS Azure SQL database

Data Warehouse/Business Intelligence Architect

Profit Recovery Partners – Dec 2014 to Dec 2018

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

• Lead and developed a portal to manage and maintain the PRP Client facing dashboards. 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 for PReSS (Profit Recovery & expense Savings System) product for the alignment of data related processes and deliverables into a unified product offering

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

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

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

• Responsibility also included SQL Server database administration

• Implemented Master Data Services by integrating Data Governance & Quality Services into SSIS

• Work with different Practice Group teams (Logistics, Research and Services, Financial, Personnel, and Printing), Business Analysts team and Solution Management teams in automating their processes for scalability

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

• 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

• Build data warehouse for eCommerce business from ground up using SQL server integration services

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

• Designed and developed a number of complex compensations 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 MVC.net for Products/Orders management with fulfillment houses

Senior Database Engineer / Data 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 mvc.net 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

Team Lead

Nexgenix – 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

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

• As a Report developer 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 developed were 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/Data Analyst/Web programmer /Software Engineer Independent Consultant – 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, MVC.net 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

• 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