Ashish Rawat Email & Phone Number

Bengaluru, Karnataka, India

•Built ETL pipelines to automate ingestion of transactional data for FODL UTV Spend & Non-Spend usecase to provide a standardized view of finance analytics for discount Business volume, discount billed business & discount revenue.•Developed, refined, and scaled data processing pipelines for management reporting.•Translated the existing IBI Queries to Spark SQL/Dataframe with Performance Optimization and reduced query execution time by 30%.•Periodic Evaluation of new technology through developing POC.•Providing technical guidance and mentorship to team members to enhance their skills and performance.•Build an enterprise dashboard for corporate portfolio (HR, Finance, Dependent departments) to enable data for business decisions & data science models.•Designed and built ETL pipelines to automate ingestion of structured and unstructured data from various external systems into foundry to deliver complete solution for various analytics. This will enable visual exploration and custom dashboarding.•Automated ETL processes making it easier to wrangle data and reduced time by 20%.•Managed, mentored and grew a team of big data engineers.

Bengaluru Area, India

•Used Hive to develop the datamarts to provide future business model (consumption and generation) for Electricity and Gas consumption in each revenue month based on history data for next 20 years. •Hive queries, spark, Java utilities and wrapper script have used to process and load data to Hive tables.•Designed and built ETL pipelines to automate ingestion of semi- structured data using Spark and Hive.•Build scalable distributed BDP based data Retrieval system for online portal requests using Java, Rest, Hive, HBase.•Developed mv2BD-rule based data ingestion & validation framework that provides an easy, configurable and scalable data ingestion platform that supports source database systems and EDWs, delivering data efficiently from different relational databases into Hive warehouse.

Bengaluru Area, India

•Developed applications using Model-View-Controller (MVC) Architecture and spring framework.•Used Spring MVC Model View Controller to handle/intercept the user requests and used various controllers to delegate the request flow to the Backend tier of the application•Developed and consumed Web Services using REST

Bangalore, India

•Built Spring Batch applications which interacts with data layer components to provide data persistence capability using spring JDBC.•Designed and developed the front end using JSP, HTML and JavaScript and JQuery.

•Engaged in enhancement and maintaining the Bellaliant.net Portal - For Your Home, For Your Business applications.•Engage in development, Build and Release activities.•Direct Interaction with Clients to understand the requirements and for timely deliverables.

B.Tech, Electronics & Communication

Intermediate, Computer Science

Activities and Societies: Sports, Skits, Science club, Painting, Dance club

High School, Science

Activities and Societies: Member Of School Cricket Team, Dancing, skit, sports