Aug 2021 – Aug 2022 · 1 yr · Pune, Maharashtra, India · Hybrid

• Design, structure and develop data models for different business lines of the company. Further designing reports to fulfil various requirements of business, operations and finances.
• Derive Proof of Concept for technologies to use for building Data Warehouse.
• Implementation of Analytical database with fact and dimensional modelling.
• Used Kafka, Debezium, AWS S3, Snowflake, Airflow, Quicksight to create the complete pipeline end-to-end.

Apr 2019 – Aug 2021 · 2 yrs 4 mos

• Design, structure and develop data models for different business lines of the company. Further designing reports to fulfil various requirements of business, operations and finances.
• Development of new framework for internal use to validate and maintain the sanity of development and the data being generated.
• Complete implementation of Analytical database with fact and dimensional modelling.
• Responsible for all types of reporting and dashboards with analytical and transactional databases.
• Constantly involved in performance tuning, optimizations, reiterations, feature development for new use cases, scalability and efficient database handling.
• Building end-to-end integration of UPI Payment option for Sales business. The role involves direct interaction with the client for proper working.
• Handling multiple projects with different teams, managing all at once is an achievement. Currently leading a team of 7-10 members.

Apr 2017 – Mar 2019 · 1 yr 11 mos

• Reporting and Dashboard - Designed Logi-sights dashboard for proper analysis of performance and other metrics for different business lines. Presenting data in visualized chart for in-depth analysis.
• Statistical Based Projection Model - Full development of the Predictive Modelling Project involving end-to-end design, implementation and deployment.
• Considering related features according to the business needs, to project items to be used by Procurement Team.
• Management Information System - End to end development of Business level finance PNL for the complex model of Ecommerce.
• Adapter Integration - Developed flow to connect and update real time sync up to client system for proper handshake for the service that ElasticRun provides.
• REST API Development - Created REST API layer over it to provide real-time and granular information of the metrics to field and central operations.

Jun 2016 – Apr 2017 · 10 mos

• Reconciliation System – Single handedly designed and developed a data flow structure using ETL tool to populate insightful metrics used to monitor daily operations and performance. Further enhanced it with query based orchestration in ETL to facilitate financial data to accounts and business owners.
• Mentor junior team members on software design and development, coding practices and strategies.

May 2015 – Jul 2015 · 2 mos · Bangalore

• Micro SD Emulator Enhancement: Enhance Micro SD Emulator Infrastructure to be able to do the following critical aspects – Measure different performance parameters more precisely – Enhance Emulator to simulate Performance variations – Enhance Emulator to consider impact of Tprog, Tr NAND Timings.