KEDAR KAGADE
Waitara,NSW
Summary
An accomplished IT professional with 18+ years of experience in IT industry. Domain expertise in Pharma & Cosmetics Retail Sales and Inventory, Wealth Management, Credit Card Fraud reporting, Tableau, Power BI, MSBI and Snowflake, Redshift, MSSQL etc database technologies. Efficiently coordinated and interacted with clients and employees from several parts of the world including US, India, UK, France, Germany, Switzerland, Thailand. Profound knowledge of Tableau, Power BI, Microsoft Business Intelligence, Snowflake, Redshift databases. Proven competency in handling entire project lifecycle from inception to delivery including business requirement gathering, clear choice preparation, design proposal, development and testing, Project Management, tracking, quality assurance and implementation & support. Innate ability to understand customer requirements, improve resource allocation and lead teams to translate into IT deliveries with maximum efficiency and optimize profitable growth. Excellent Analytical, consulting and interpersonal skills, a team player with ability to foster team’s performance. Participate and deploy the change management activities by accompanying end users and providing trainings. Experienced in working on multiple projects at the same time. Worked as SME of Wealth Management, Fraud, Pharma and Cosmetics Retails reporting. Experienced in data analysis and data mapping. Strong customer service focus and champion in bridging the gap between the Business and IT. Prepare the project delivery plan and the knowledge transfer in close relation with the operating teams. Experienced in facilitation of Scrum ceremonies.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Data Analytics Lead/Manager
Cognizant
08.2022 - Current
- Customer Foundation Data Products Platform is a process and framework of collecting, organizing, managing and analyzing customer data from diverse sources to form a unified view of each customer for Tier 1 Bank in Australia
- I manage multiple teams (27+ resources) for Customer FDP for their Compliance, Enhancement and Big Data Migration projects.
Data Analytics Lead
Infosys
11.2018 - 04.2022
- Bank of America: The objective was to build data warehouse to provide MF/ETF/SMA data to CIO Due Diligence team
- The data was gathered from various sources inside and outside of Bank
- As data was Highly confidential security was major issue
- Team was successfully build secured data lake appreciated by CIO DD team.
- Bayer Pharmaceuticals: The object was to build Sales/Inventory/Calls data warehouse and Visualizations for Sales management, pharmacists, doctors and medical representatives
- The data was used to calculated perks and commission of medical representatives
- The client’s top management was using Visualization for Board reporting.
Tableau/Power BI Developer/Sr SQL BI Developer
L’Oreal
08.2011 - 11.2018
- L’Oreal is a cosmetic giant
- The project includes populate and Maintain Data Warehouse to accommodate Sales, Marketing, Inventory and Finance data
- Merge data warehouses with newly acquired brands, support financial month end activities, calculate commission and perks for Beauty Advisors.
Sr. SQL BI Developer
Thomson Reuters
12.2010 - 07.2011
- The objective was migration of Teamtrack project management tool to latest version
- TR uses Issues module of teamtrack extensively for tracking purpose
- New custom feature were added for tracking and reporting
Programmer Analyst
K&T Electrical Contractors Inc.
03.2006 - 11.2010
- The objective of the project was to Automate USPS Storage Towers systems, Conveyor Bel systems, Flight Assignments
Software Engineer
Prathamesh Construction
07.2005 - 02.2006
- The objective of project was to build Humane Machine Interface to operate various tools using MS.Net
- The PLC code was controlled by software.
Education
Master of Computer Management - Information Technology
Pune University
06.2002
Bachelor of Commerce (Accounting/Economics) -
Pune University
06.1998
Skills
- MSSQL, Snowflake, HIVE/Impala, Redshift
- Business Intelligence Data Modeling
- Dashboard Design
- Data Warehousing and Analytics
- Requirements Gathering and Analysis
- Scrum
- Data Mapping
- Database Management
- Data and Analytics
- Microsoft Power BI
- Tableau
- SQL
- Agile Project Management
Career Trajectory
- Cognizant, Data Analytics Lead/Manager, Aug 2022 – till date, Australia
- Infosys, Data Analytics Lead, Nov 2018 – Apr 2022, USA
- L’Oreal, Tableau/Power BI Developer/Sr SQL BI Developer, Aug 2011 – Nov 2018, USA
- Thomson Reuters, Sr. SQL BI Developer, Dec 2010 – Jul 2011, USA
- K&T Electrical Contractors Inc., Programmer Analyst, Mar 2006 – Nov 2010
- Prathamesh Construction, Software Engineer, Jul 2005 – Feb 2006, India
Certification
- SAFe 6.0 Certified Scrum Master
- SAFe 6.0 Certified Product Owner/Product Manager
Timeline
Data Analytics Lead/Manager
Cognizant
08.2022 - Current
Data Analytics Lead
Infosys
11.2018 - 04.2022
Tableau/Power BI Developer/Sr SQL BI Developer
L’Oreal
08.2011 - 11.2018
Sr. SQL BI Developer
Thomson Reuters
12.2010 - 07.2011
Programmer Analyst
K&T Electrical Contractors Inc.
03.2006 - 11.2010
Software Engineer
Prathamesh Construction
07.2005 - 02.2006
Master of Computer Management - Information Technology
Pune University
Bachelor of Commerce (Accounting/Economics) -
Pune University