Hitesh Sudan Email & Phone Number

Palm Beach Gardens, Fl, Us

Palm Beach Gardens, Fl, Us

Teaneck, New Jersey, Us

Seattle, Wa, Us

• Work with stakeholders and SME's to design and develop data warehouse models using data modeling techniques to cater reporting needs of users. • Design, develop, test and deploy new SSIS packages loading data into staging tables from various sources like files and remote databases. • Performance tuning of poorly performing existing SQL Server Integration packages and SQL Queries impacting the reporting needs of Users. • Development of new SQL stored procedures, functions, views loading data to temporal tables in SQL Server 2016 as per the functional and technical specifications of the project.• Development of new Security models in databases to restrict data access to unauthorized users using the new Row Level Security feature in SQL Server 2016.• Support the new and existing applications by doing root cause analysis and fix issues reported by users in data to minimize the impact on reporting.• Define table indexing, partitioning strategies and Query Store to optimize the performance of database and SQL queries.• Experience in ingesting data into HDFS from heterogenous data sources using Sqoop.• Building distributed in memory applications using Spark and Spark SQL API’s to do analytics efficiently on huge data sets.• Experience in creating managed and external table schemas in Hive with appropriate static and dynamic partitioning and Bucketing strategies for efficient querying of data.• Involved in performance optimization of spark jobs and designed efficient queries to query data from Hive.• Experience in dealing with different types of files in Hadoop landscape like Avro, Parquet, JSON, ORC, Sequence and Text files.• Experience in Object Oriented Analysis and Design methodologies and scripting in Scala and Python

Mumbai, Maharashtra, In

Project - Micron Technology Inc.• Involved in gathering, analyzing, documenting business and functional requirements by interacting with business users from various domains like Supply Chain, Sales, Finance and Purchasing. • Develop complex SSIS ETL’s solutions sourcing data from heterogenous sources like SAP BW, SQL Server and SAP HANA, XML files, Flat files to load data into Oracle and SQL Server.• Worked on change requests to enhance performance of existing SSIS ETL packages and rewriting poorly executing SQLs.• Worked extensively with DBA’s for partitioning, indexing of tables with huge data volume on Oracle and SQL Server.• Involved in migration of complex ETLs from Data stage and Perl to SSIS 2008 and to SSIS 2012.• Good Knowledge of SAP HANA Modeler HANA Studio, Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytical Privileges, Procedures.• Experienced in creation of data warehouse system based on the methodology of Star Schema, Snowflake schema and Data Vault.• Created SSIS packages with C# scripting to process and sync SSAS/OLAP cubes programmatically.• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SQL Server Reporting Services (SSRS). • Expertise in developing complex Power BI Reports/ Dashboards using visualizations for data analysis. • Experience in both scrum(Agile) process and waterfall models for software development. • Mentored and guided a team of 7 developers ensuring the timely delivery of Deliverables. Responsible for sync up between offshore and onshore teams.

Mumbai, Maharashtra, In

Project - Numonyx• Responsible for monitoring Production Plans and resolving incidents created by the job failures ensuring timely data delivery for reporting.• Analyzed and resolved incidents created by Business Users related to data issues.• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards• Performance tuned poorly running ETL jobs and SQLs. • Worked for recovery of missing data caused due to the failure of the ETL jobs and ensured the minimal impact on reporting. • Contributed to the knowledge repository of the project with relevant documents and presentations and received appreciation for the same.