Chandresh Desai Email & Phone Number

Washington Dc-Baltimore Area

☁️ Founded and lead Cloudairy, an innovative tech company specializing in cloud architecture solutions.☁️ Spearheaded the development of Cloudairy Cloudchart, a cutting-edge tool designed to transform cloud architecture through enhanced visualization, collaboration, and efficiency.☁️ Direct strategic initiatives that address the growing complexity and cost challenges in cloud infrastructure expansion, focusing on creating user-centric solutions for diverse organizational needs.

Washington Dc-Baltimore Area

Washington D.C. Metro Area

• Work with central infrastructure team on architecture choices and the best practices to adopt AWS efficiently and cost-effectively.• Ensure success in building, migrating, and deploying applications, software and services on the AWS platform• Engage with developers, system administrators, software architects, project manager and directors to define cloud strategies and deployments• Responsible for the end-to-end journey from On-Premise to Cloud with defining strategy, transformation, cloud deployment, cloud Integration, Cloud migration, and successful transitions to implementation support teams• Plan, consult, and design architecture and solutions on AWS along with AWS Team

Washington D.C. Metro Area

• Experienced in working with Hadoop clusters using Cloudera distributions.• Developing big data solutions in Hadoop Ecosystem using Apache Spark, Hive and Pig.• Developed various data ingestion pipelines using streaming tools like Flume, Spark and Kafka.• Worked with Data lake architecture and setting up Hadoop environment foringesting claim and provider data from multiple sources.• Import/export data using Sqoop from Relational Database systems to HDFS.• Involved in creating Hive tables, loading and analyzing data using hive queries.• Worked on Spark SQL, Data Frame, Spark Streaming, Reading/ Writing data from Avro, Json, Text,Parquet to RDD.• Exploring with Spark various modules of Spark and working with DataFrames, RDD and Spark Context.• Serve as a mentor and trainer of other members of the team. Provide guidance, assist in building skill sets, and provide knowledge of ETLprocessing, T-SQL debugging, Performance tuning technique, SSIS, SSRS for junior IT operation specialist.

Washington, District Of Columbia, United States

• Gathered user requirements and analyzed and designed software solution and database.• Responsible for data extraction and data ingestion from different data sources into Hadoop Data Lake by creating ETL pipelines using Pig, and Hive. • Worked extensively with Hive DDLs and Hive Query language (HQLs).• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.• Wrote T-SQL queries, Stored Procedures and used them to build packages.• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.• Worked on QA testing by writing scripts for source and target data to verify the integrity of the data.

Washington D.C. Metro Area

• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2008 Integration Services (SSIS).• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.• Involved in Maintenance and Deployment of SSIS Packages.• Create database objects in SQL Server 2008 including Tables, Triggers, Views, Stored Procedures,• User Defined Functions (UDF) and Indexes.• Created SSIS packages using SSIS designer for export heterogeneous data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2008• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).

Plantation,Fl

• Design ER diagrams and mapped the data into database objects.• Wrote SQL scripts to insert update and delete data in MS SQL database.• Created schema, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.• Transform data from various data sources using OLE DB connection by creating various SSIS packages.

Jacksonville, Florida Area

• Created database and database objects like tables, stored procedures, views, triggers, user defined data types and functions.• ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.• Designed, built the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).• Worked on improving the performance of the system.

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. • SQL Server 2005 RDBMS database development using T-SQL programming, queries, stored procedures, views. • Taking weekly database backup and schedules job using SQL Agent.• Experience in designing and building the dimensions and facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).

Ms, Computer Engineering

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering, Distinction