Nimisha Shah Email & Phone Number

Richardson, Texas, United States

Implemented ETL processes to read files in various file formats like text, csv, Parquet, Json, and Excel - using python libraries like Json, Csv, and Pyarrow. Worked extensively to parse deep Json files. Implemented ETL processes to consume files via network drive, local file system, FTP, SFTP protocol, AWS s3, and Azure Data Lake using FileIO(os module), FTP , Paramiko, and Boto3 packages/modules. . Leveraged Pandas library and lambda functions for data cleansing, transformation, aggregation, and visualization. Designed migration of 150 SSIS driven consumer inventory file processing ETL jobs into metadata driven python ETL pipelines. Used Dagster for Orchestration of these pipelines. Designed and created self-healing, well monitored processes with exception handling, logging, and reusability. The enhancement has helped process scalability and fault isolation, saving considerable time in troubleshooting ETL process failures. Designed and implemented solutions using cloud services like azure data lake, Azure SQL DB, AWS s3 , and AWS –RDS -SQL server. Worked with Azure SQL Database, On-Premise SQL Server and Azure DevOps.Member of BI team,responsible for BI development and implementations, data architecture, data warehousing and for successful delivery of business intelligence information to organization.

Dallas/Fort Worth Area

A member of Data Solutions Team - responsible for BI development and implementations, data architecture, data warehousing and for successful delivery of business intelligence information to the entire organization.Developing and maintaining customer data platform to build the best marketing experience for the customer.Making enhancements and maintaining various data marts and tabular models for self-serve reporting needs across various business units. Peformance tuning for stored procedures and ad hoc to improve performance and building data pipelines to integrate data from various sources into warehouse. Worked with Azure SQL Database, Azure SQL Managed Instance, On-Premise SQL Server and Azure DevOps.

Dallas/Fort Worth Area

Sql Server Stored procedures, views, tables,functions.Sql Server Integration services, Analysis Services and Reporting services.SSAS - Multi dimensional cube development.SSAS - Tabular Cube DevelopmentSSIS - ETL to load data from various different sources to SQL serverPower Bi reporting.SQL query troubleshooting, optimization.Worked with Azure SQL Database, On-Premise SQL Server and Azure DevOps.

Plano, Texas, United States

Developed stored procedures and triggers to facilitate consistent data entry into the database. Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, data conversion, derived columns, Merge join, row counts, Oledb source, Oledb destination, Excel source, Oledb Command Experience in creating Tables, Procedures, Functions, Views and other database objects using SQL Experience in writing Complex T-SQL Queries, Sub queries, Co-related sub queries Experience in writing queries using common table expressions, Rank, case, subqueries Experience in tuning the performance of Stored Procedures and long running queries and improving performance of database. Designing reports using SQL Server Reporting Services (SSRS) using multiple value parameters, cascading parameters, drill down/ drill through reports, and sub reports Deploying and scheduling Reports using SSRS to generate daily, weekly, monthly and quarterly Reports including status. Created ad-hoc reports for unit team lead as requested and provide on-going analytical support for these requests.

Dallas-Fort Worth Metroplex