Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Timeline
Generic

KEERTI CHOUHAN

Pune

Summary

Prudent Business Intelligence Developer, Solution Architect and Business analyst with 12 Years’ experience, providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.

Experienced with managing high-stakes projects and ensuring client satisfaction. Utilizes analytical skills and strategic thinking to drive successful outcomes. Track record of effective teamwork and adaptability in dynamic environments.

Professional with strong expertise in strategic analysis and project management, prepared for this role. Proven track record in driving impactful results through effective leadership, cross-functional collaboration, and adaptability to evolving business needs. Skilled in data analysis, process optimization, and stakeholder engagement. Known for reliability and results-focused mindset.

Overview

18
18
years of professional experience
5
5
Certifications
2
2
Languages

Work History

Senior Associate Level 2

Apex Fund Services LLP
07.2021 - Current
  • Dashboard Development
  • Data collection, Data wrangling and Data Analysis
  • Data modeling
  • Revenue Reconciliation
  • Customize Report Development
  • Providing support on Business Application (Prophix)
  • Solution Architect
  • Project: Cohort KPI Dashboard and reports –i) To Automize the manual process of data collection and data processing from different sources to prepare consolidate data for reconciliation with workday Report and shows different KPIs on Power BI dashboard
  • Ii) To migrate existing SQL based dashboard to snowflake based DBT models
  • Client: (Business stakeholder) (Apex Group), Ex-co committee
  • Technologies: SQL, Snowflake, Power bi, Alteryx designer, GitHub, Duration:2 Year
  • Project: CHSS-Client Happiness stability status, is a dashboard developed in Power Bi Dashboard which shows happiness, stability and rating given by all global clients for type of different products.
  • Client: (Business stakeholder) (Apex Group)
  • Technologies: SQL, Snowflake, Power bi, Alteryx designer Duration:1 Year
  • Project: Alteryx Decommission– To transform Alteryx generated reports into power bi reports.
  • Client: (Business stakeholder) (Apex Group)
  • Technologies: SQL, Snowflake, Power bi, Alteryx designer Duration:1 Year
  • Project: Power BI Group HR – Dashboard Amendments in some existing metrics (Global Voluntary Attrition %, Yearly Average Scoring, Performance Scoring Filters) and some additional filters has been implemented
  • Client: Apex Group
  • Technologies: SQL, Power Bi Duration:1 Month
  • Project: IT Dashboard-a centralized solution for better usability of existing data to leverage current data of Apex FS in a way that will provide Management with a powerful tool to analyze the overall health of processes within the IT Department, highlight successes and barriers, and examine trends. This assist data-based decision making and significantly increases efficiency.
  • Client: Apex -FS
  • Technologies: SQL, Power Bi Duration:1 Year
  • Project: KYCP Reports: Creating customized reports designs as per different business requirements
  • Client: Hari Bhambra (Global Head of Compliance Solutions, Apex -FS)
  • Technologies: SQL, SSRS Duration:1 Year
  • Project: KYCP - Phase 2 - Global Senior Management – Dashboard: To provide Senior Management relevant indicators about KYCP applications.
  • Client: Hari Bhambra (Global Head of Compliance Solutions, Apex -FS)
  • Technologies: SQL, Power Bi Duration:1 Month
  • Project: Governance Tracker - Phase 2: To report the data entered by the users in Apex Management System application AMS (Phase 1) into a dashboard view divided in different tabs without manual intervention as well as to increase efficiency and accuracy in the visualizing/reporting of data for the CHR (Client Happiness Rating) report.
  • Client: Global Head of Governance and Internal Audit, Regional Head of Risk (Apex -FS)
  • Technologies: SQL, Power Bi Duration:2 Months

Business Intelligence Data Analyst consultant

Grant Thornton Bharat LLP
08.2016 - 04.2021
  • Integrated BI assets into customer relationship management (CRM) tasks, improving service personnel's available intelligence.
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Done Diagnostic analysis using descriptive and statically methods.
  • Performed Analysis of the controls at different fraud points and mitigation of fraud risks.
  • Was responsible for Creating/Preparing SQL queries to fetch the required Data from Database as per the Requirement and preparing customized reports.
  • Responsible for SQL query optimization
  • Innovative e-Gov solutions for good governance and public sector reforms, improved public service delivery, and transparency in governance, enhanced citizen participation.
  • MIS management and website analysis and revamping the existing system
  • UAT testing and solution architect.
  • Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
  • Project : Prepare 5 Years Road map for Sagar Smart City to improve livability index
  • Client: Gov. of M.P(Smart City)
  • Gathering information and coordinating different government bodies
  • Prepare analysis report on existing and required resources of city to improve livability index
  • Gap analysis
  • Technologies: Advance Excel, Power Bi Duration:1 Month
  • Project : Management consulting for ICT/ITeS/Telecom/Networking Infrastructure/Smart city works/ jobs/ projects/ services/Business Opportunities
  • Client: ITI Limited Bengaluru
  • This project is to provide consultancy in identifying the business opportunities for ITI Ltd and associate with ITI Ltd in discussion with prospective customers to get the work on a nomination basis or through limited or open bidding process after assessing eligibility and capacity of ITI Ltd to win. As well as designing Architecture, Mapping solutions to Bill of Quantities (BoQ), Bid stitching and Pricing, utilizing ITI’s resources and product line to maximize the overall best value margins to ITI Ltd
  • Providing market analysis (predictive, hypothesis) and market research report for product Development and product sale.
  • Business process Re-engineering (BPR)
  • Providing and preparing technical/commercial analytics presentations and support officers of ITI Ltd during the presentations and exhibiting Proof of Concept (PoC) when required, before clients/customers
  • Data Visualization
  • Technologies: SQL, Power Bi Duration:1 Month
  • Project: (PMIS) Ministry of Electronic and Information Technology
  • Client: Ministry of Electronic and Information Technology
  • PMIS is a web-based, centralized tool for monitoring and evaluation of the physical, financial and outcome parameter of the mission mode project under e-Kranti framework of Digital India program and other such e-Governance project
  • I was part of the data processing team and was responsible for client communication and coordination with the development team.
  • Data analysis for different project under Digital India Program
  • Processing large data sets stored in SQL and other formats and extracting Data for further processing.
  • Technologies: SQL, Power Bi Duration:1 Year
  • Project: C&O Budget– Information Management and Dashboard Development
  • Client: C&O Department (Grant Thornton Bharat LLP)
  • This project aims to develop the MIS and business performance reporting platform for C&O budget department to monitor the funds flow and investments.
  • Review existing data ingestion processes and reporting processes.
  • Budget variance analysis, automation using Power Bi Dashboard and MIS Query based reporting to the level of Yearly / Quarterly / Monthly in Excel / PDF formats.
  • Assisting in configuring the data into user friendly dashboards based on reports / information required for review by the C&O Project leadership after benchmarking the gaps in the existing reporting system.
  • Assisting in enhancing analytical capability for business functions leadership e.g. drill-down, slice-dice, variance analysis, etc.
  • Technologies: Power Bi, SQL Server, Azure Duration:6 Months
  • Project: Samarth-Scheme for Capacity Building in Textile Sector
  • Client: Ministry of Textiles (Gov. Of India)
  • This project is a Management Information System, an advanced version of the previous scheme (ISDS). It provides complete insight into managing the implementation of the scheme and includes various application modules for various stack holders. It contains various features and modules.
  • Reduced overall cost of manpower and time by providing automation with the help of technologies.
  • Attending meetings with ministry officials and different stake holders to understand their requirement and feedback on IT product.
  • Work on report development and help team to prepare data for report designing using ETL process.
  • Develop high level dashboards for Result Framework achievement attendance analysis reporting.
  • Data Modeling, Data integration, data Migration, Skill analysis and progress & reporting using Power Bi
  • Data base maintenance, data retrieval and answering various queries for parliament sessions on regular basis.
  • Technologies: Advance Excel, Power Bi, MS Word, Power Point, MySQL Duration:2 Years
  • Project: To develop centralized dashboard for all skill sectors
  • Client: Ministry of Textiles (Gov. Of India)
  • This project aims to integrate all the different management Information System (MIS) working across different Central Ministries and states to create a centralized national database of skill development activities.
  • Requirement analysis, and information gathering.
  • Data migration, Data Wrangling, and exploration
  • Data management, DB maintenance
  • Data integration and ETL processing
  • Descriptive & Diagnostic Analytics
  • Collaborating with senior management and government bodies to lead and implement process & policy changes.
  • Technologies: SSIS, SSRS Duration:6 months
  • Project: Integrated Skills Development Scheme
  • Client: Ministry of Textiles (Gov. Of India)
  • This project is a Management Information System for ISDS of Ministry of Textiles (Gov. Of India) and has been developed in PHP and MySQL. It provides complete insight into managing the implementation of the scheme and includes various application modules for various stack holders. It represents the electronic automation of several different kinds of counting, tallying, record-keeping, and accounting techniques. It produces regular reports on operations and implementations for every level of the scheme.
  • Resolving technical issues and queries of MIS
  • Data integration, data migration, data analysis & reporting
  • Project monitoring through a robust MIS system with real time view of the progress of the scheme.
  • Data analysis of implementing agencies’ performance on various parameters and guidelines set by the ministry.
  • Finding root cause of lacunas in scheme implementation and suggesting
  • Visual Analytics Using Power Bi server.
  • Respond to requests for information and to access relevant files.
  • Comply with data integrity and security policies.
  • Technologies: MySQL, Advance Excel, Power Bi Duration:1 Year

Software Engineer

Lugis Technologies Pvt. Ltd.
10.2013 - 07.2016
  • Researched, designed, and implemented scalable applications for data extraction, analysis, retrieval, and indexing.
  • Revised, modularized, and updated old code bases to modern development standards, reducing operating costs and improving functionality.
  • Orchestrated efficient large-scale software deployments, including testing features and correcting code.
  • Project: Meethai Street, a web application
  • This web application is basically designed for maintaining inventory and online selling and purchase of sweets products, this was recreation of existing application with various bug fixing.
  • Database development and maintenance
  • Revamping website
  • Bug fixing
  • Technologies: WAMP
  • Project: Rudra Handicrafts web application
  • This application was to provide online shopping and marketing. Developed with PHP and MySQL

Intern

IGS Lab Technologies Pvt. Ltd.
01.2013 - 07.2013
  • Projects: - “Packet Handling Methods for preventing Selective Jamming Attack”, A simulation tool written in Java for the partial fulfillment of MTech
  • Duration: 6 Months

Assistant Professor

JIET
07.2008 - 06.2013
  • Developed and coordinated in-house projects e.g., library management, online student’s registration and tracking system and employee management system.
  • Conducted workshops on industry-oriented courses.
  • Data analysis on student’s performance
  • Teaching different subjects in ECE department.

IT Trainer

NIIT Jodhpur
05.2007 - 06.2008
  • Provided training on Microsoft platforms and technologies.

Education

M. Tech. - CSE

Jodhpur National University
Jodhpur, Raj
07.2014

B.E - E&C

M.B.M Engineering College
Jodhpur, Raj
07.2006

Skills

Data-driven business insights

Certification

Online Certification in Python for Data Science and Machine Learning with “A” Grade from NIELT Chennai, MEITY, Aug2020

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Senior Associate Level 2

Apex Fund Services LLP
07.2021 - Current

Business Intelligence Data Analyst consultant

Grant Thornton Bharat LLP
08.2016 - 04.2021

Software Engineer

Lugis Technologies Pvt. Ltd.
10.2013 - 07.2016

Intern

IGS Lab Technologies Pvt. Ltd.
01.2013 - 07.2013

Assistant Professor

JIET
07.2008 - 06.2013

IT Trainer

NIIT Jodhpur
05.2007 - 06.2008

B.E - E&C

M.B.M Engineering College

M. Tech. - CSE

Jodhpur National University

Similar Profiles

CREATE PROFILE
KEERTI CHOUHAN