Data Analyssis & Visualization Using SAS, SQL, Power BI & Excel

My name is Pankaj Ray, and I’d like to help you with your data analysis needs.

I have been working as a Sr. data analyst for three years. In that time, I have helped my clients understand their data and make decisions based on it by using the right tools and techniques. I also have experience with a wide range of industries, including Banking, healthcare, retail, and education.

Data extraction and preparation

Data visualization using Tableau, Power BI and Excel

Data analysis using SAS, SQL and Advanced Excel


Data cleansing and validation

I’m a self-starter who loves diving into new challenges, so if you’re looking for someone who can tackle projects from start to finish and deliver them with great results, then I could be your guy!

👨‍🎓 PROFESSIONAL SYNOPSIS & PROJECTS UNDERTAKEN 🎖

• Generate reports either in EXCEL, PDF, RTF and CSV format using SAS/ODS according to client
requirements.
• Extensive use of PROC SQL, PROC PRINT, PROC SORT to perform analysis of the datasets using
queries, joining and altering tables using Merging, Keep and Drop.
• Implementation of ad hoc requests and coding enhancements using various functions like SUBSTR,
SCAN, DAY, MONTH, YEAR, SUM, INTNX, CAT, TRANWRD, etc.
• Convert unstructured business requirements into structured analytical plans, Work across multiple
products and effectively use various data platforms and analysis tools
• Possess good knowledge of SAS with a comprehensive understanding and application of its Procedures
and contents like SAS/BASE, SAS/SQL, SAS/Macros.
• Experience in data management, cleaning, reporting and integration using SAS Programming skills.
• Accountability for quality, timeliness and efficiency for the work assigned to me.
• Configuration for complex and urgent deliverables.
• Strong leadership, problem-solving, planning, team-building and project management skills