Project – 1:Project Name: Data Migration - AWSProject Role: Team LeadEnvironment: Python | Rest-API | Airflow | AWS – (S3, Glue, Redshift) | Github | Scrum.Responsibilities:• Built an ETL by integrating AWS - S3, Glue, Redshift services. • Extracted the data from client’s server through API and imported raw data into AWS-S3. • Automated the extraction process through Airflow.• Utilized AWS-Glue service to create tables in Glue Data Catalog for the data present in S3 using Crawlers.• Created Glue jobs to summarize, transform and load the data into Redshift by utilizing the Glue Catalog Tables.Project – 2:Project Name: DATA Migration – HadoopProject Role: Team LeadEnvironment: MySQL | Sqoop | Hadoop | Spark using Python | Scala | SQL | Github | Scrum.Responsibilities:• Used Spark-SQL for querying & transforming data present in HDFS to Hive tables using Data frames.• Developed Spark jobs to summarize and transform data present in Hive Tables.• Implemented Dynamic Partitioning and Bucketing using Hive on Hadoop Eco System for efficient data access.• Performed Aggregations on large data sets of structured, semi structured and unstructured data using BIG DATA concepts on Multi Node Hadoop Cluster.• Performed Analytics on BIG DATA using Spark-SQL, Data Frames, RDD's.Project – 3:Project Name: Sales Data AnalyticsProject Role: Data EngineerEnvironment: AWS – S3 | Snowflake | DBT | SQL | JINJA | Github | Scrum.Responsibilities:• Extracted data available in AWS – S3 and copied the data into Snowflake’s Tables.• Integrated Snowflake and Github to DBT to perform ETL operations.• Utilized SQL together in writing Complex Sub-Queries, Joins, Views, Aggregations and created tables, views in Snowflake.• Created Models, Macros, Tests and utilized Packages, Seeds as per the requirement to improve query performance.• Involved in Data Modelling – Refined data for proper Data Types, Handled the Faulty, Duplicate and Null records etc.

• Served as a Site In charge in Wipro InfoTech, One of the giant company in IT service Industry involved to provide IT solutions & support to various industry.• I have been a part of Future Group project (TOSS account) through Wipro InfoTech handling a critical location H.O Office Mumbai.• Handling a Team of 6 Engineers, their complaints & monitoring client satisfaction based on number of calls getting logged & closed within the desired SLA to ensure minimum violation of calls with genuine reasons. • Product technical problems, its solution and escalating the same to concerned stake holders for further rectification.• Vendor management to ensure timely closure of calls.

• Served as a Business Support Executive with Future Group, Mumbai.• My responsibilities involve ensuring the high-level Client Satisfaction of the Business Team, valuable & Promote products feed back to organization, improving / increase of service volume, services redemption.• In addition to the Service activities, I also did take care of vendor management to get call closure as per define SLA. Client handling, their complaints & monitoring their satisfaction.• Provided technical support to the Team Mates facing problems in HP Compaq products like HP/Compaq Machines, HP Workstations, HCL Systems, Acer Systems. Provided Technical Support to HP DeskJet, Laser Printers, Epson Dot Matrix & Inkjet Printers.• Providing technical support to the Engineers facing problems in application used by the client for end user billing.

Installing & Configuring Windows 2000 server, Windows 2000 Professional, Windows XP Professional, Windows XP Home Edition & Windows 98.b) Upgrading to Windows 2000, working with file systems & disks, Auditing & security, networking with TCP/IP.c) Client handling, their complaints, monitoring client satisfaction.d) Product technical problems, its solution and reporting to factory for product improvement.e) Warranty Claim management.