Always Happy to hear from you!
Connect for collaborations and inquiries.
Developing data solutions that inspire and engage. With a passion for innovative data solutions & Strategy , I transform ideas into beautiful, functional realities.
With experience in industries ranging from Travel / Retail to Global Media powerhouse / Banking/Finance. I bring you an in-depth wealth of solutions to real world challenges.
Designing, building, and optimizing robust, scalable data pipelines and architectures within cloud environments. I leverage cutting-edge big data technologies to transform complex data challenges into streamlined, high-performance solutions.
My expertise ensures data is reliable, accessible, and primed to drive impactful business intelligence and innovation.
Consultant, Data Engineer & Solution Developer
Tools - PowerBI / Amazon Quicksight / JavaScript / R & ggPlot2
85%Data - Python, SQL, R
Web - Python and PHP
Tools used for ETL
(Airflow / DataBricks / Snowflakes)
Cloud Platforms and DevOps Tools (AWS, Docker, Git)
75%Deep expertise in Python for data engineering and analysis, alongside mastery of SQL for relational database management. This is complemented by strong proficiency in NoSQL databases, enabling flexible and scalable data solutions for diverse architectural needs.
Experienced 20+ years in Global powerhouses like SIEMENS/BBC, MNC Retail Groups & Banking Sector. Large-scale Projects building Business Intelligence (BI) solutions, supporting strategic business decisions, people analytics, surveys, monitoring systems / KPIs to support SLA credits etc.
Developing Cloud based solutions, building Data pipelines, optimizing data cost in the cloud (storage and transition).
Lead project for People Analytics, Dashboard using Qlikview. Integrating various data sources from flat files, SQL database, SQLite, feedback from surveys. So far in my tenure various compliance and strategic goals were met and improved. Achieved significant cost reduction by the efficient use of Python for automation.
Lead Data aspect Bank Strategy. Developing the Adhoc reports using SQL, R, Excel and VBA to support various departments in the Bank. Gathering data points based on evolving business requirements and developing KPI reports to support decision making. Implementing KPIs based on Basel III requirements (ie.- Liquidity Coverage Ratio (LCR) and Net Stable Funding Ratio (NSFR)), Central Bank complaince on Risk Mgmt. etc.
Lead project developing a comprehensive Dashboard interface linked with Key
Performance Indicators (KPIs), to Analyze the direction and trend of business.
Coordinated with Marketing & Sales Team to plan advertisement maximizing returns. Integrated
data sources i.e. Oracle, MS SQL and Flat files from Retail Pro.
Successful implementation of the project resulted in Dashboard of sales till 2 AM in the night
from the 6 countries across GCC was visible to Managing Director each morning
at 8 AM.
This helped business plan the inventory and marketing strategies effectively. Sales started
improving 6 months. Several Brands improved sales by 23%, wastage reduced by 7% on
an average across the Group's Fine Dining and Fast Food divisions.
Launched a startup for education sector. Did many small projects related business intelligence solution. Although not everything went as planned and I returned to the industry.
Worked on various projects, one of which was BBC London. Required integration all data sources through ServiceFlow and provide a comprehensive reporting interface. Developed and maintained metrics to automate performance evaluation of 450 Key Performance Indicators (KPIs) based on business SLA’s, to provide the reporting Dashboard for availability of Network, Hardware, Servers and Systems through server, network and data logs.
Was responsible for managing travel related website data maintained in MySQL and developed in PHP. Twice in year products were launched, the website had enquiry and feedback features. Presenting Hotels and Flight data which was not API driven.
Graduated with Mathematics major from Christ Church
College, Kanpur University.
Certified from Harvard University, Microsoft, AWS and HackerRank
After doing many projects in my career, using many different tools (Python, SQL, R, Jupyter Notebooks, AWS,
and many other tools)
and languages to solve various challenges. Mentioning all in this section is not possible.
I have mentioned below simple code snippets and screenshots of some present on GitHub
and Google Colab .
upcomingAdjusting computing resources to match demand, Cost-Effectively.
upcomingAutomation and insights through machine learning models.
Connect for collaborations and inquiries.