Chandresh Chauhan

Last Updated: */**/****

251-***-****

adx0b4@r.postjobfree.com

SUMMARY

Seeking a new curve in analytics, using various BI utilities, data model for predictive analysis, Big Data Architecture to achieve high class data deliverables & quality products & services; as by far, meritoriously used data tools i.e. Teradata EDW, PowerDesigner data modeling, Azure, SSIS, SQL server, SSRS PowerBI, MicroStrategy, and Python to engineer & analyze data to give a significant growth to the organization.

PROFILE SUMMARY

8+ years of immense Database Engineering, Business Intelligence, Big Data, and Microsoft BI Reporting Stack work experience with all Healthcare Domains.

Advance experience in Teradata EDW, Data modeling architecture using PowerDesigner, BTEQ Scripts, Microsoft Azure SQL Server configuration, optimization/tuning, Alation, ETL Tool (SSIS), PowerShell & job scheduling on Task scheduler, Reporting Tools – SSRS, PowerBI & provide internal PowerApps to team.

Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques. Extensively works on Database Objects such as modeling database structures, tables, UDFs, Indexes, Stored Procedures, and Views. Also works on data deliverables through Python Pandas, Pyspark, Matplots, SeaBorn, SQL Lite 3 via pipelining various data sources.

Broad knowledge of creating internal application on PowerApps and deployed Reports in SSRS/ PowerBI in Tabular, Matrix, Chart, filters, Linked, Drill-down, Drill-through, Linked, Sub reports etc. Experience in data manipulations and dynamic generation of datasets using expressions, parameters in both SSIS & SSRS.

Expert Experience in writing complex SQL queries, Performance Tuning and Query Optimization. Experience with logical and physical data modeling and database design. Full understanding of SDLC & Agile (Kanban) methodology.

Great Experience in using Microsoft ETL tool: SSIS. Designed and developed SSIS Packages for migration/modification, mapping multiple sources, generating error reports, validate analytics reports, sending emails, creating high level flow design document.

Experience with IT code versioning & scheduler tools: GitHub, All Scripts Sunrise Manager, TIDAL, Tortoise SVN, TFS, RedGate Other useful IT tools: SNOW, TOAD, VMware. GeoNetworks Map: For providers/ members geo-spatial network mappings.

EDUCATION

Troy University

May 2012

Bachelors of Science, Major in Information Systems

EXPERIENCE

Sr. Data Engineer HCA Healthcare Inc. (Corporate)

October 2017 - Present

Formulate next generation analytics environment, engineer automated clinical big data to Clinical Service Group (CSG) dept. to deploy/develop/analyze/manage big data (EDWCDA) on Teradata EDW, SQL Server, PowerBI by constructing data Engineering pipelines using multiple tools: SSIS, PowerDesigner data modeling, Python Pandas, PowerShell, BTEQ scripts etc. & then Migrate/manage data using PowerShell, SSIS/ GitHub/ Zeke, Windows task scheduler. Completed Certificate for MicroStrategy Education Training program, Power BI DIAD, Data Analytics with Python.

Built data models, EDW databases, Azure Databricks for data governance & data pipelines for near real-time data warehouse, design administrate areas of SQL server, reconciliations and various ad-hoc complex analytic reports with the implementation team to deliver internal PowerApps user application using agile software development principles. Support Big Data architecture & ETL processes.

Task Lead: Lead a team of software engineers that developed analytical tools and data exploitation techniques that were deployed into multiple enterprise systems and works with Project Manager, VP & consulting team.

Developed custom ad-hoc SQL queries and performed testing and data analysis using PowerBI on Teradata servers. Works on time tracking projects within agile environment using Rally Software & keep track of revised documents on Confluence.

Execute/Mange/ Modify SSIS packages to populate/ integrate data from various data sources: SAS Files, Flat Files, Excel and various DB into SQL Server Management Studio.

Analyze & then design the current state of big data EDW & ETL architecture, Escalate data concerns/solutions to AVP and work with Developers. Also design process documentation for future state roadmap as well as solution blueprint.

Ability to use & learn ever changing new innovative ideas quickly & works independently as a team player. Prefer to work in a broadminded team & can multi-task with an organized framework.

Senior Developer Anthem Inc. (Amerigroup)

April 2013 – October 2017

Designed and developed complex Stored Procedures, UDF, ad-hoc queries/expressions in SQL server then using in dynamic parameterized dataset in SSRS reporting for generating various Monthly, Quarterly, Bi-Yearly, Yearly reports using BCP utility in TIDAL.

Developed ETL for processing and monitoring of SSIS packages to export/import data from CSV files, Text files and Excel using SQL queries and various transformations. Converted reports running through Visual Basics to SSMS using SSRS/SSIS tools (VB-PCP Project). Automating SSIS Execution in Windows Scheduler using DTExec Commands in TIDAL.

Created custom team SDLC process for data analysis framework. As SME, provided code review to other developers.

Collaborate with Project Managers, Data Analysts & Developers to clearly define specific business needs, expectations, timelines & execution methods, which are clearly communicated to specific business groups.

Worked on datasets using Python Panda data frames, matplot, seaborn & folium for interactive maps.

Regularly worked with various software tools like SVN repository check-in/check-out, TIDAL, SNOW and FACETS front end, SERVICE NOW, CMD Utility, and GeoNetworks.

Final Project: To clean up DB objects: reports, views, functions, tables etc. from current production database server to a new server. Developing GEO reports for various providers/members by geographic regions.

Database Developer II University of Michigan Hospitals

December 2012 - March 2013

Generated Reports on SAP Crystal report retrieving command created in BIDS 2008 for Daily Ad Hoc reports.

Utilizing BMC Software for creating and maintain report jobs queuing on Ticket system. Created Users and Groups for Central Management Console (CMC), Managed Central Management Server (CMS). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis.

Worked Extensively with All Scripts Sunrise Clinical Manager (SCM) in taking/recording Medical Orders, Inpatients/Outpatients record keeping, managing configuration etc.

Experienced in developing and designing reports on SQL Server Reporting Services (SSRS).

Critical Ad-Hoc reports generating daily for Inpatients/Outpatients. Knowledge about daily Hospital Nursing Scenarios. Experienced in creating Temp Tables, Stored Procedures observing Business Rules.

Familiar to convert crystal reports into SSRS; In-depth knowledge of T-SQL queries.

INTERNSHIPS

SQL Business Developer University of South Alabama (Agile Robotics)

May 2010 - August 2010

June 2011 - August 2011

Used SQL Server 2008 to query basic SQL code and to analyze the data captured for a robot anchored to help cure autism in young children.

Wrote SQL code to capture robotic movements’ time stamps and effects to create graphs using SSRS for efficiency.

Worked as Business Analyst to gather requirements, analyzing further application development possibilities, and helped in testing following all the phases of SDLC process.

SKILLS SUMMARY

Advance Skills: Teradata EDW, SSMS, SSRS, SSIS, PowerDesigner, PowerApps, BTEQ scripts, PowerShell, Power BI, MicroStrategy, Tableau, SAP Crystal Reports, Big Data, Microsoft Azure, Python.

Complete Microsoft Office, TOAD, Microsoft Visio, TIDAL, SNOW, Tortoise SVN, TOAD, GitHub, TFS, RedGate, VMware, GeoNetworks Map: For providers/ members geo-spatial network mappings.

Novice in Web Design: HTML, JavaScript, CSS, and VB 2005/2008

Basic-to-Novice Application Language skills: C++, Java

Partially installed & configured VMware.

Contact this candidate