Hetal B Email & Phone Number

United States

Hampton Roads, Va, Us

Hampton Roads, Va, Us

 Prepared documentation for all entities, attributes, data relationships, primary & foreign key structures, allowedvalues, codes, business rules, glossary evolve, & changes during project Analyze raw data, draw conclusions & develop recommendations writing SQL scripts to manipulate data for dataloads and extracts. Develop Business and Sales reports using Power BI Create and maintain project artifacts such as Business Requirements Document, data flow diagrams Create and document other software related deliverable as and when required Data analysis usingSQL,DAX function in Excel, Power BI, Tableau and SPSS Involved in writing the SQL Scripts for report development, Tableau reports, Dashboards and handled theperformance issues effectively Created Dataflow Diagrams to indicate flow of data from various source to the target system and the connectionfrom which source we can get the required information in future as well. Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional andperformance Testing. Wrote SQL statements to extract Data from SQL server database Manage research and Data Analytics team Developed yearly reports and presented to Board of directors Gathered, analysed, and interpreted research data and build reports Created questioner and Collected responsesin SurveyMonkey and from community Developed Data collection and analysis plans and conducted analysis of datasets using various statisticaltechniques in SPSS and Excel Wrote of scientific manuscripts and grants applications Worked on different data formats, Flat files, SQL files, Databases, XML schema, CSV files. Developed work plans, managed deadlines and coordination of project team and sub - team activities Involved in project cycle plan for the data warehouse, source data analysis, data extraction process,

Bellevue, Wa, Us

 Reviewing query performance and optimizing code to speed up the process and optimize the space. Worked on all activities related to the development, implementation, administration, and Installation of SQLServer, SSMS, SSIS, SSRS, and support of ETL processes for large-scale Data projects which included the claims &policy data of the client. Creating and dropping the clustered Indexes, non-clustered indexes, primary keys, and unique keys to getmaximum performance. Developed complex SQL queries using stored procedures with common table expressions (CTEs) subqueries, openqueries, temporary tables, derived tabled, group by, the row over the partition, Joins, rank, dense rank, exists, notexists etc. Performing efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance Designing new job processes using SQL agent, new database maintenance plans, DTS programs, and performancetuning of the existing processes. Data conversions and data loads from various databases and file structures. Work with all levels of development from analysis through implementation and support. Participate in discussions involving the application creation and understand the requirements and provide theback-end functionality for the applications. Creating ETL Processes and SSIS Packages to load and transform the data. Creating SSIS Packages to pull data from various environments like SQL, Oracle, Teradata, CSV, Excel, and text andpush data to share the drive with CSV, txt, and table extensions. Hands-on experience using different transformations like fuzzy lookup and derived column transformation usingSSIS. Used Pivot unpivot in SSIS and SQL to receive desired results. Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy grouping etc. forcreating many SSIS packages. Source Code / Software Configuration Management (SCM)activities using SVN.

• Reviewing query performance and optimizing code.• Programming views, stored procedures, and functions• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support CSD Team. • Creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Develop complex T-SQL code for the application.• Performing efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell• Designing new job process, new database maintenance plans, DTS programs and performance tuning of the existing processes.• Data conversions and data loads from various databases and file structures.• Work with all levels of development from analysis through implementation and support.• Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.• ETL Processes, SSIS Packages, SSAS and SSRS.• Troubleshooting technical issues in a variety of application environments, including researching issues related to system configuration, software and database systems, and data integrity or conformity.• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse. • Worked on all types of transformations that are available in Power bi query editor.• Scheduled and monitored SSRS and Power BI report subscription and deliveries such as Email Delivery and File Share Delivery as required.•

Chicago, Il, Us

• Handle common database procedures such as upgrade, backup, recovery, migration, etc.• Create back up data for migration• Work on Log Shipping and handling for migration process• create log scripts and deployed it to log tables for new and existing processes • Reviewing query performance and optimizing code.• Programming views, stored procedures, and functions• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support CSD Team. • Creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Develop complex T-SQL code for the application.• Performing efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.• Migrated existing self-service reports and adhoc reports to Power BI.• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL datawarehouse environment. Experience in DWH/BI project implementation using Azure DF.• Installed and configured Enterprise gateway and Personal gateway in Power bi service.• Designing new job process, new database maintenance plans, DTS programs and performance tuning of the existing processes.• Data conversions and data loads from various databases and file structures.• Load data from word, excel, csv to sql server and vice versa.

• Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2016. • Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse. • Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy grouping etc. for creating many SSIS packages. • Used MicroStrategy Desktop 9.2.1 to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model. • Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports. • Integrated Custom Visuals based on business requirements using Power BI desktop. • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports. • Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic. • Creation and maintenance of Business Objects Reports.• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files. • Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data. • Worked with different methods of logging in SSIS. • Integrated Custom Visuals based on business requirements using Power BI desktop.• Developed custom Calculated measures using DAX in Power BI to satisfy business needs. • Expertise in Power BI, Power BI Pro, Power BI Mobile.

• Working on Designing, Analysis, Development, Maintenance, Implementation using Crystal Reports /2008/XIR4.1, Business Objects XI.• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports XIR4.1. Maintaining proper documentation of the reports for future reference.• Experience in migrating data from Oracle database to MS SQL server 2012 database.

• Working on Designing, Analysis, Development, Maintenance, Implementation using Crystal Reports /2008/XIR4.1, Business Objects XI.• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports XIR4.1. Maintaining proper documentation of the reports for future reference.• Experience in migrating data from Oracle database to MS SQL server 2012 database.

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.• Developed Reports in MS Access and MS Excel.• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing.• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.• Designed and developed SSIS packages to load data from Flat files, Excel, Access to Data warehouse.• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS. • Expert in Created/Updated database objects like tables, views, stored procedures, function, packages,• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status. • Developed and delivered dynamic reporting solutions using MS SQL Server 2005 Reporting Services (SSRS).• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.