Learn Data Skills
Beta
Bindi Patel

Bindi Patel

DBA

AdminaHealth

Technologies

My Portfolio Highlights

My New Course

Intermediate SQL Queries

Data explorer, uncovering insights in the digital wilderness.

My Work

Take a look at my latest work.

course

Intermediate SQL Queries

course

Intermediate SQL Server

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

AdminaHealth® | Mar 2022 - Present

SQL Server DBA

N/A

Community Health Center | May 2020 - Mar 2022

Business Intelligence Developer

• Build ETL packages using SSIS which gets (Encounters, prescription and provider) data from the ECW (E Clinical Works) Application database and generates Flat files for Vendors like CVS and Verity. • Worked with the population health team to understand their requirement and then create the Reports for them based on the request. So, there are usually 2 types of requests one-time data request and periodically data requests. • Created Mobile Dental Forecasting Dashboard for school-based health care (SBHC) using Tableau. • Created SSRS Subscription report so it sends data monthly to various users. • Having Good knowledge about how to work with Behavioral health data, Dental Data and Medical Data.
Show More

Compucity | Jun 2018 - Apr 2020

Database/ETL Deleloper

• Worked with Business architect to determine logic for the new data warehouse, and for integration process. • Created dimensional model for data warehouse, created and wrote DDL scripts for different object such as tables, stored procedures, triggers and user defined functions. • Designed SSIS packages for transient and persistent staging area, to extract data from transaction database and different applications, from excel files and flat files using for each loop container, sequence container, and tasks such as execute SQL task, lookup, merge, merge join, pivot, etc. • Wrote complex TSQL stored procedures to embed all business logic provided by stake holders. • Used variables and expressions to make SSIS package dynamic.

Brigham and Women's | Dec 2016 - May 2018

Business Intelligence Developer

• Utilized SQL Server table configurations and environment variables to dynamically run packages. • Executed event handler and error handler mechanisms in SSIS to retrieve customized information about error if package fails and insert useful information to the audit log tables. • Worked with SQL Server Job Agent to schedule packages, run and monitor them. • Used Team Foundation Server to keep track of new created SSIS packages, and to modify and update existing packages when it is necessary. • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. • Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.

State Street | Nov 2014 - Nov 2016

SQL Developer/ETL/Tableau

● Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. ● Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts. ● Involved in designing ETL as a part of Data warehousing and using SSIS. ● Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration. ● Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent. ● Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse ● Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps. ● Worked with various interactive dashboards using parameters, calculated fields, groups and using Blended Axes, Dual Axes and Individual Axes. ● Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types. ● Worked with SSIS using different task and containers in order to automate the process. ● Also, worked with their Generic DBI tool so we can schedule email delivery including the snapshot reports and excel reports to the investment analyst. ● Created SQL Server Drill down, Drill through, sub report using SSRS to fit business requirements. ● Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2014. ● Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.

Seterus Inc | Jan 2013 - Oct 2014

SQL Developer

• Created BNTC (Best Number to Call) and BTTC (Best Time to Call) files for the business by using database development. • Made huge performance tuning in Green Field • Developed various T-SQL stored procedures, triggers, views and adding/ changing tables for data load, transformation and extraction. • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures. • Designed and optimized indexes, views, stored procedures and functions using T-SQL • Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc. • Designed and implemented Stored Procedures and Triggers for automating tasks. • Used agile methodology to achieve Goal by using regular scrums and Sprints.

Powered by

  • Work
  • Courses
  • Experience
  • Create Your Data Portfolio for Free