Khushbu Rupani Email & Phone Number

New York, Ny, Us

Create data solutions and review the requirements with managementDrive development of tools, reporting improvements, and automation, and create new innovative and insightful reportsCreate queries and user defined functions that require aggregating large data sets on a regular basis in a performant fashion with PostgreSQLDetect data quality issues and provide production supportDebug data issues in existing reports and implement fixesAcquire data from transactional source systems to the data mart using Databricks platform and build ETL pipelines with Spark SQLExperience in managing tasks through JIRA, Git, and deploying database code using Liquibase and Jenkins as a member of our Scrum team where we have two-week sprints, user stories and a product backlog. Build, scale and maintain data pipelines to process huge number of daily events into Spark

New York, Ny, Us

Used Spark SQL for interactive queries and processing of streaming dataImplemented partitioning using Spark SQL for faster processing of large datasetsWrote complex reporting functions in PostgreSQL which can be used in APIsBuilt performant materialized views in PostgreSQL and scheduled jobs to refresh them which can be used in reporting

New York, Ny, Us

Developed internal systems for data integration and reportingConducted analysis and gathered requirements from internal stakeholders and customersProcessed and loaded student’s assessment data and converted it into a standard format using SSIS ETL toolBuilt ETL Packages to bring data into specific formatsWrote complex T-SQL statements, stored procedures, views and user defined functionsImplemented user defined functions and test validation queries in PostgreSQL Debugged existing ETL packages and did performance tuning to fix bugsDesigned, Developed, Enhanced and Maintained data integration and reporting processes on a variety of platforms for a variety of productsImplemented ETL pipelines using Spark SQL to load data from source systems to data warehouse in Databricks

New York, Ny, Us

Performed delivery of reporting, dashboards and databasesInteracted with business units, project managers and lead to determine application and reporting needsMaintained existing databases, ETL data from different sources, and analyzed the dataPerformed data modeling and database optimizationInterpreted and wrote complex SQL queries and stored proceduresImplemented best practices in data management to ensure the integrity of the data, the quality of data processes and deliver analyzable or analyzed data to a variety of internal and external clients of the Medical CenterRecommended best practices for data transformations to supported the data movementTranslated, merged, mapped data into conceptual, logical and physical data modelsPerformed quality assurance, completed system integration testing to ensure reasonable performance requirementsUtilized Tableau desktop reporting tool and database solutionsCreated action filters, parameters and calculated sets for preparing dashboards and worksheets in TableauDeveloped Tableau visualizations and dashboards using Tableau DesktopDeveloped Tableau workbooks from multiple data sources using Data Blending

Stamford, Ct, Us

Designed databases to solve complex problemsUtilization of data modeling concepts such as the proper roles of conceptual, logical and physical data models Designed physical and logical database schemasUtilized T-SQL, SQL or PL/SQL and XMLConstructed and maintained Extract/Transform/Load (ETL) processesProduced reports and views based on multiple queriesCreated data layer for applications utilizing data transfer objects and data access objects in C# or VB/VB.NET Created query execution plans utilizing Microsoft SQL ServerUtilized OLTP and OLAP systems, multi-dimensional databases, operational data stores, data warehouses, data marts, staging databases and data servicing layersPerformed database maintenance activities such as performance tuning, optimization, capacity management and security administrationCreated stored procedures and maintaining data integrityDeveloped programs for data cleansing, data checking, data profiling and error preventionCreated, maintained and presented technical documentation (such as E/R diagrams) for various audiencesTransformed and performed various operations on data using Oracle TOAD

Generated Crystal Reports and Business Intelligence Reports using aggregate functions and shared variable concept based on retrieved data from database.Performed various SQL queries including building tables, stored procedures, user defined functions and triggers using system and mathematical forms.Fixed burst parts of database tables.Created indexes, integrity constraints and views.Converted database tables to normalized forms.Imported data from different file sources such as Excel spreadsheets, Text files to SQL Server 2008 tables, views and export data from SQL Server 2008 to different file sources using DTS packages facility.Built local DTS packages for transformation of data on daily basis.Developed User Interfaces to maintain database using C# .NET.Assisted in CASA Case Audit project by performing various operations on user interface controls. Created a small application using VBA(Visual Basic Access) and SQL Server.

Masters, Computer Science

Bachelor, Computer Engineering