Kedarnath Patil
Technical Proficiencies: Data Analytics | Business Intelligence | MarTech Solutions
Experience
Senior Data Consultant
EY is building a better working world by creating new value for clients, people, society, the planet, while building trust in the capital markets.EY teams in more than 150 countries work across a full spectrum of services in assurance, consulting, tax, strategy and transactions, strengthened by sector experience and diverse ecosystem partners.
- Collaborated with the Telecom Campaign Operations team to apply statistical tools and techniques for strategic marketing of various telecom products.
- Designed, developed and implemented complex data flows to optimize application performance and functionality. Partnered with cross-functional teams to identify and implement effective database solutions.
- Utilized HCL Unica (v11.1) for data mining and strategic marketing and Oracle SQL Developer for data extraction and response analysis. Automated the elimination of 4,700+ duplicate entries in a telecom performance database by analyzing names, social security numbers and tariff plans.
Senior Analyst
Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, Technology and Operations services — all powered by the world’s largest network of Advanced Technology and Intelligent Operations centers.
- Partnered with the Campaign Operations team to apply statistical tools and techniques for strategic marketing across various retail products. Leveraged HCL Unica (v10.2) for data mining and strategic marketing and utilized Snowflake for data extraction and response analysis.
- Optimized database structures by creating tables and indexes to condense larger datasets into manageable formats. Developed complex SQL join queries to support Star Schema, Snowflake Schema and Dimension and Fact table configurations.
- Constructed waterfall flowcharts in Unica to visualize data more effectively, enhancing stakeholder communication and decision-making.
Digi Bank of Singapore
DBS is a leading financial services group in Asia with a presence in 19 markets. Headquartered and listed in Singapore, DBS is in the three key Asian axes of growth: Greater China, Southeast Asia and South Asia. The bank's "AA-" and "Aa1" credit ratings are among the highest in the world.
- Worked in the Debit Card Operations team, leveraging statistical tools and techniques to implement strategic marketing initiatives for retail banking products, including Activation, Mutual Funds, Cross-sell and Fixed Deposits (FD).Utilized HCL Unica (v9.1) for data mining and strategic marketing and Teradata for data extraction and response analysis, with a focus on debit card campaigns.
- Assessed business requirements and analyzed the existing data and architecture to ensure alignment with organizational goals.
- Created database tables and indexes to streamline large datasets into compact, manageable structures for optimized performance.
Business Consultant
HDFC Bank is India's largest private sector bank, offering a comprehensive range of financial products and services to our customer base of over 92 million. Our extensive distribution network of 8,919 branches and 21,031 ATMs across 3,836 cities and towns as of August 2024, reaches every corner of the country, making us accessible to millions.
- Worked in Campaign operations Credit Card & Loan team, involves applying statistical tools and techniques for strategic marketing for various retail products of the Bank Used HCL Unica Data mining and strategic marketing tool (v7.5) & Oracle 9i for Data pulling, response analyzing for Credit Cards and Adobe campaign classic developer (v6.1.1) for Launching process. To research, plan, and implement Business strategies based on requirements of the market
- To create tables and indexes for compacting larger data into smaller tables. Analyzed existing SQL queries to identify opportunities for improvements
- Introduced new methods, practices and systems to reduce turnaround time.Developed complete business plans and operational strategies for new and existing business campaigns
Education
University of Mumbai
GPA : 7.7
Skills
- Data Cleaning, Data Modellling
- Data mining
- Cross Functional Teams
- Agile Development
Projects
Below are the sample Data Analytics projects on SQL, Python, Tableau & Power BI.
Music Store Data analysis using SQL
Analyzed music store data using advanced SQL queries to identify gaps and increase the business growth.
Data analysis using Python
Performed exploratory data analysis on diwali sales data using Python to improve the customer experience.
Blinkit Power BI Sales dashboard Project
Designed a power bi dashboard for Blinkit to track and analyze the online sales data acorss India.
EV Data Analysis using Tableau
Designed a Tableau dashboard for EV to track and analyze the overview sales data acorss USA States.
Customer Segmentation using clustering model
Developed a ML model to give various recommendations of financial products & services on target customer groups.
Interests
Apart from being a Data enthusiast, I enjoy most of my time being outdoors. In the winter, I am an aspiring Wildlife Photographer.
When forced indoors, I follow a number of sci-fi and thriller genre movies and sitcoms, I listen to House-music tracks and I spend a large amount of my free time exploring the latest technolgy advancements in the Data Analytics.
Awards & Certifications
- EY Client Extraordinaire
- AI for Everyone
- Google Looker Data Studio
- Implement Adobe Analytics
- Snowflake Hands On Essentials - Data Warehouse
- Microsoft Technology Associate: Web Development Fundamentals (MTA)
Blogs
Coming soon