Pankaj Sonawane
Pankaj Sonawane

Design is

intelligence made visible

Automation is

about making things fast

Together

they are a tool that empowers us to achieve incredible things

About Me

Hi! This is Pankaj, introducing myself as a Google Certified UX designer, IBM Certified Data Scientist, a skilled professional with a passion for designing visually captivating presentations, websites, software and Web applications. I have a knack for capturing attention and delivering impactful content. My proficiency extends beyond the surface as I possess the ability to automate Excel, Word, and PowerPoint using Python and VBA Macros, streamlining processes and maximizing efficiency. Hailing from the beautiful city of Nashik, I have been immersed in a creative environment from an early age. Drawing inspiration from my surroundings, they constantly seek out new challenges and opportunities to learn and grow. I made the bold decision to move to Mumbai in 2007, driven by a desire to explore new opportunities and expand the horizons. The bustling city provided the perfect backdrop for my passion of learning and automation to thrive. Love for acquiring knowledge and discovering innovative solutions is evident in the exceptional work I produce. Whether it's crafting user-friendly websites, developing powerful software, or presenting information in an engaging manner, I combines my technical expertise and artistic flair to deliver exceptional results. My dedication to continuous learning and love for design and automation ensures that I stay ahead of the curve, always ready to take on exciting new projects.

  • Age 45
  • Residence India
  • Qualification BCS - Pune University, BCA, MCA - Data Science
  • e-mail pankaj@codviz.com
  • Phone +91 8888928846

What I Do

Automation

I specialize in automating repetitive tasks across Excel, Word, and PowerPoint using Python and VBA Macros, significantly enhancing efficiency and accuracy in business operations. By integrating advanced data analytics and Data Science methodologies, I uncover patterns and trends that drive strategic decision-making and deliver measurable business impact. Additionally, I develop interactive dashboards and visualizations that transform raw data into actionable insights, fostering a data-centric culture within the organization. By staying at the forefront of technological advancements, I continuously explore new tools and technologies to create cost-effective solutions that streamline processes, eliminate manual errors, and empower data-driven decision-making.

Web Design

I have a keen eye for aesthetics and also specializes in creating visually stunning and user-friendly websites that leave a lasting impression on visitors. I am proficient in JavaScript, Vue JS, HTML, CSS and PHP, enabling myself to build interactive and responsive web pages that adapt seamlessly across different devices and screen sizes. Also, excels in designing intuitive user interfaces (UI) and user experiences (UX), ensuring a seamless and enjoyable browsing experience for website visitors. I collaborate closely with clients to understand their specific needs and goals, translating their vision into a visually compelling website that aligns with their brand and objectives.

Application Development

In application development, I demonstrate expertise in Python, Tkinter, MySQL, and PHP, excelling in designing and implementing intuitive user experiences. Leveraging Tkinter's extensive widget library, I create interactive and visually appealing desktop and mobile interfaces that enhance user engagement. My proficiency in PHP and MySQL allows me to effectively integrate databases into applications, ensuring efficient data storage, retrieval, and seamless server-side functionality. I possess a strong understanding of application architecture and consistently apply best practices to ensure scalability, security, and high performance throughout the development process. Additionally, I am adept at troubleshooting and optimizing code, ensuring that applications run smoothly and efficiently in diverse environments.

Presentation Designing

In the realm of presentation design, I possesses a wealth of expertise and skills. I have a keen eye for visual storytelling, crafting captivating presentations that effectively communicate key messages and engage audiences. I possess a deep understanding of design principles, utilizing color, typography, and layout to create visually stunning and impactful slides. I excel in creating cohesive and professional presentations, ensuring consistency in branding, imagery, and overall aesthetics. I have a talent for organizing information and data in a clear and compelling manner, making complex concepts easily understandable for viewers.

Testimonials

Fun Facts

Happy Clients

578+

Presentation Designed

1500+

Awards Won

9

Applications Developed

14

Resume

Education

Masters
Open University

Master of Computer Application (MCA)

I pursued a Master in Computer Applications (MCA) while actively working, driven by a commitment to enhance my technical skills and deepen my understanding of advanced computing concepts. Balancing professional responsibilities with academic pursuits, I leveraged this advanced degree to gain expertise in areas such as Data Science, AI, database management, and systems architecture. The MCA program not only equipped me with the latest technological knowledge but also enabled me to apply cutting-edge solutions to real-world challenges in my professional role, further advancing my career in the tech industry.

Google Certification
Google - through coursera

UX Design

I have acquired a Google UX Design certificate to deepen my understanding of user experience principles and enhance my ability to create intuitive, user-centered designs. This certification provided me with hands-on experience in all aspects of the UX design process, from research and wireframing to prototyping and usability testing. With this certification, I am equipped to integrate UX best practices into my projects, ensuring that the applications and interfaces I develop are not only functional but also provide a seamless and enjoyable user experience.

IBM Certification
IBM - through coursera

IBM Data Science Professional

I have acquired the IBM Data Science Professional Certification to expand my expertise in data science and enhance my ability to derive meaningful insights from complex datasets. This certification provided me with a comprehensive understanding of data analysis, machine learning, and statistical methods, along with hands-on experience in using tools like Python, SQL, and Jupyter Notebooks. With this certification, I am well-equipped to apply advanced data science techniques to real-world problems, enabling data-driven decision-making and driving innovation in my projects.

Graduation
Open University

Bachelor's of Computer Application (BCA)

Pursued a Bachelor of Computer Applications (BCA) as an additional qualification to stay abreast of the rapid changes and developments in technology. This education provided me with a solid foundation in computer science and software development, enabling me to adapt to emerging technologies and continuously enhance my technical skills in a dynamic and evolving industry.

Graduation
Pune University

Bachelor's of Computer Science (BCS)

Bachelor's degree in Computer Science, equipping myself with a strong foundation in various aspects of the field. I have acquired comprehensive knowledge and skills that position myself for success in the dynamic and ever-evolving world of technology.

Technical
Bombay Education Board

ITI

Completed and acquired ITI Certification from Bombay (now Mumbai) Technical Board. I showcased my expertise in programming as well as Microsoft Office"

Junior College
Pune University

HSC (12th)

Completed my Higher Secondary through well know KTHM College in Nashik in Science Stream (Maths and Science).

School
Maharashtra State Board

SSC (10th)

Completed my Schooling through prestigious St. Xavier's Convent High School. Nashik

Tech Update
Udemy

JavaScript, VueJS, PHP, Python, HTML, CSS, MySQL

Post working hours, I best utilized my time learning new technologies online. Also, acquired certifications for the same. While learning I developed various applications and designed multiple website as a hand on training and learning process. Automation that I learned was best utilized at my work place.

Experience

2024 - Current
Kotak Mahindra Capital Company

Senior Manager

Automate and add visualisation related to financial pitch books. Responsible for presenting data in a clear and visually appealing manner, transforming complex information into easily understandable insights. Collating data from various sources, employing meticulous attention to detail and ensuring accuracy and completeness. Design is core role.

2007 - 2024
Kotak Mahindra Capital Company

Manager

Responsible for presenting data in a clear and visually appealing manner, transforming complex information into easily understandable insights. Collating data from various sources, employing meticulous attention to detail and ensuring accuracy and completeness. Automate tasks related to financial pitch books. Design is core role.

2005 - 2007
Zenta (for Chase Manhaten Bank)

Customer Relationship Executive (Backoffice of Chase)

Interacting with US clients with respect to their financial security (Core product cannot be mentioned)

2004 - 2006
Government School and AL-MSB - Nashik

Computer Teacher (Part Time in 2 Schools)

Teaching students from class 5th to 10th computer subjects including programming (in Basic and VB) and Microsoft Office

2000 - 2008
FRIENDS COMPUTER ACADEMEY (FCA)

Computer Trainer and Software Developer (Part Time)

Apart from teaching in school I used to develop application softwares in VB / Oracle / MySQL on behalf of FCA for clients in various sectors

2006 - 2007
Asset International

Centre Manager (Part Time)

Franchisee of Aptech Limited. Was responsible to handle the centre with more than 100 students daily for Animation (MAYA), Programming (VB, C, C++, Oracle), SAP and some more high end courses

Design Skills

Data Science

70%

Presentation Design

99%

Web Design

85%

Automation

75%

Graphic Design

90%

Coding Skills

Python

95%

PHP

85%

HTML/CSS

100%

JavaScript

65%

VueJs with Quasar Framework

60%

Knowledges

  • Data Science
  • UI/UX Design
  • Data Visualisation
  • Problem-Solving
  • Digital Design
  • Automation
  • Social Media
  • Time Management
  • Communication
  • Social Networking
  • Print
  • Web-Design

Videos

SoundCloud Audio

PDF Utility

PDFUtility
YouTube Video 1

Python Amazing Beginners Codes

Learn Python
Media Project 2

Alogorithms

Learning Python
Vimeo Video 1

Flowchart

Learn Python
Media Project 1

Python Print / Input

Learn Python
Mockup Design 1

Data Types

Learn Python

Blogs

PDF Utility

Free and Offline PDF Utlity for Personal and Corporate requirement

StartPDF is a remarkable Python and Tkinter-based PDF FREE OFFLINE utility that simplifies PDF management. From securing your documents with passwords to merging files seamlessly, Extracting Tables to Watermark Pages in PDF, StartPDF offers a comprehensive set of tools for various PDF tasks. Its user-friendly interface and versatility make it a must-have application for anyone dealing with PDF files regularly.

You dont have to upload any of your secured documents on any unidentified website.
PDFUtility
PDF Utility

A Comprehensive Guide to Python PDF Libraries

There is always a need for a offline and Free PDF tool which can be versatile and solve all basic requirements related to PDF manipulation or Automation. For example, If our only requirement is to watermark a PDF files why we need to purchase an entire software, or we just need to split or delete or replace PDF or use of PDF files to extract tables is our only requirement, there is no need to buy the entire bulk of software and pay for the same.

Python
Data Visualisation

Plotting Heat Map over Indian Districts using Python

I recently worked on a project involving the plotting of a heat map over the districts of India, using data stored in an Excel file. The project required extensive data cleaning, including normalizing district names and handling discrepancies between the data and geographic boundaries. I utilized Python libraries such as pandas for data manipulation, geopandas for working with spatial data, and matplotlib and Bokeh for visualizing the heat map. By effectively cleaning and processing the data, I was able to create an accurate and insightful visualization that highlighted key trends across different regions, providing valuable insights for data-driven decision-making.

Data Visualisation
Colour Pallet

The Fear of Choosing Colors: How to Get It Right!

Data Visualisation

Contact

Mumbai

+91 8888928846

pankaj@codviz.com

Freelance Available

How Can I Help You?

Legal

Privacy Policy:

Introduction:

Welcome to CodViz! This website belongs to Pankaj Sonawane and this Privacy Policy outlines how we collect, use, and safeguard your personal information when you visit our website.

Information We Collect:

Personal Information: We may collect certain personally identifiable information, such as your name, email address, and any information you voluntarily provide through comments or contact forms.

Usage Data: We may collect non-personal information about how you interact with our website, such as your IP address, browser type, and pages visited.

How We Use Your Information

We use your personal information to respond to your inquiries, provide you with requested information, and improve your experience on our website.

Usage data helps us analyze trends, monitor the effectiveness of our content, and improve the overall user experience.

Cookies and Tracking:

We use cookies and similar technologies to enhance your browsing experience and gather information about how you use our website. You can control cookie preferences through your browser settings.

Third-Party Links:

Our website may contain links to third-party websites. We are not responsible for the content or privacy practices of these sites.

Data Security:

We implement reasonable security measures to protect your personal information from unauthorized access and disclosure.

Your Choices:

You can opt-out of providing personal information by not submitting forms or comments. You can manage cookie preferences through your browser settings.

Changes to this Privacy Policy:

We may update this Privacy Policy from time to time. The latest version will be posted on this page.

Terms of Use:

Acceptance of Terms:

By accessing and using CodViz and StarPDF, you agree to abide by these Terms of Use.

Content and Intellectual Property:

The content on this website, including text, images, and media, is protected by copyright and other intellectual property laws. You may not use, reproduce, or distribute our content without permission.

User Conduct:

You agree not to engage in any activity that disrupts or interferes with the functioning of our website or violates any laws.

Comments and Contributions:

You may leave comments and contributions on our website. However, you are solely responsible for the content you post, and you agree not to post any unlawful, defamatory, or offensive content.

Third-Party Links:

We are not responsible for the accuracy or content of third-party websites linked to from our website.

Disclaimer of Liability:

We provide information on our website for general purposes. We do not guarantee the accuracy, completeness, or reliability of the information provided.

Changes to Terms:

We may update these Terms of Use at any time. Continued use of the website constitutes your acceptance of the updated terms.

Governing Law:

These Terms of Use are governed by the laws of Government of India