Prathamesh Sharma

Business Intelligence Analyst at Optimal Solutions Group
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • AWS Certified Cloud Practitioner
    Amazon Web Services (AWS)
    Oct, 2020
    - Nov, 2024
  • Tableau Desktop Specialist
    Tableau Software
    Sep, 2020
    - Nov, 2024
  • Google Analytics Individual Qualification
    Google
    Mar, 2020
    - Nov, 2024
  • Intermediate R
    DataCamp
    Mar, 2020
    - Nov, 2024
  • Python: Data Analysis
    LinkedIn
    Jan, 2020
    - Nov, 2024
  • Microsoft Excel- Excel from Beginner to Advance
    Udemy
    Nov, 2019
    - Nov, 2024
  • Joy of Computing using Python
    NPTEL
    Oct, 2018
    - Nov, 2024
  • C/C++ Training
    IIT Bombay Heritage Foundation
    Aug, 2016
    - Nov, 2024

Experience

  • Optimal Solutions Group
    • United States
    • Public Policy Offices
    • 1 - 100 Employee
    • Business Intelligence Analyst
      • Jun 2021 - Present

      Optimal Solutions Group, LLC is an economic and policy analysis research, consulting, and software development firm that stands out for its innovative approaches to provide rigorous, data-driven research and technical assistance to US Federal and State government agencies, Corporations, NGOs, and philanthropic foundations.As a Business Intelligence Analyst I am working on :• Developing business solutions and architecture using requirements gathering such as scope, processes, budget, and timeline for various clients such as Center of Medicare and Medicaid Services(CMS).• Analyzing client’s business requirements, processes, workflows, and integration strategies with other systems.• Plan, develop, and document business processes, requirement specifications, risks analysis, and time required to complete tasks and effectively communicate with business and technical teams using the Agile Sprint approach.• Interceder between business, IT, and technical team to ensure a smooth flow of information and requirement to complete the tasks on time.• Developing end-to-end Data Engineering architecture with data retrieval using complex SQL queries, data pipelines using Apache Airflow, and rich visualizations using Tableau.• Built data preprocessing architecture on Tableau server using Tableau Prep and integrating Python Script using TabPy, reducing the loading time of dashboard from 45 seconds to 3 seconds.• Responsible for taking monthly Microsoft SQL database backups as a Database Administrator.

    • Data Scientist
      • Aug 2020 - May 2021

      As a Data Science Intern I worked on :• Analyzed 1 million+ records of FPDS data using Regular Expressions and parallel computing with dask to segregate WOSB's across the U.S. Visualized the time series data based on Hans Rosling's life expectancy viz with Tableau gaining appreciation from SBA Administrator Barb Carson.• Streamlined the data preprocessing task for FPDS-NG data using pandas, NumPy, and feature engineering to clean files and impute missing values with 10 million+ records saving a huge chunk of the company's time.• Spearheaded exploratory data analysis process for proof of concept resulting in modifications. • Engineered dashboards in Tableau and Power BI with 70+ feature for Historically Underutilized Business Zone and Women-Owned Small Business using complex drill down & drill through and Parameterized Reports.

    • Business Intelligence Analyst
      • Jun 2020 - Aug 2020

      As a Business Intelligence Intern I worked on :• Implementing Google Analytics as a Microservice to find the most important web pages to perform accessibility analytics and integrate into one of Optimal's products using Python & SQL.• Building mock dashboards in Tableau and rebuilding them in Progress Telerik which will display the accessibility score ( Section-508 ) and help understand how accessible a website is based on 7 Lazar metrics.• I calculated the accessibility score by building a python script and input the Lazar formulas taking data from the WAVE API.• Revamped information retrieval speed for the company's software by building and deploying analytical cubes in SQL Server Management Studio, normalizing the database and passing columns using the correct data type.

  • The University of Texas at Dallas
    • United States
    • Higher Education
    • 700 & Above Employee
    • Graduate Student
      • Aug 2019 - May 2021

      Graduated with an M.S. in Information Technology and Management course from the Naveen Jindal School of Management.Coursework :• System Analysis and Project Management• Statistics and Data Analysis• Business Data Warehousing• Business Analytics with R• Applied Machine Learning• Big Data• Data Visualization • Marketing Web Analytics and Insights• Agile Project Management• Marketing Management• Organizational Behavior

    • Youtube Officer : Graduate Dean's Council at Naveen Jindal School of Management.
      • Jan 2020 - Dec 2020

      • The YouTube team is responsible for maintaining a YouTube channel to promote the accolades and reputation of the Jindal School of Management. • The channel will provide 2–3-minute conversations with individuals that helped to promote the Jindal School brand.• The goal of the short conversation is to demonstrate the impact of the Jindal degree post-graduation or in a corporate environment. • This team engages the Jindal School's Social Media Manager to capitalize on linking DC postings to Jindal School social media outlets.

    • ITM Program Mentor
      • Oct 2019 - Dec 2020

      I will be helping the current ITM Students and the incoming students regarding their queries for Information Technology Management Course.As a team,• As a team, we work towards making the ITM program a step better than it was the previous day.• We help students, prospective, and current have a better and wholesome experience while hoping to pursue or pursuing a master's in Information Technology and Management.

    • Social Media Officer : Management Information Systems Club
      • Oct 2019 - Dec 2020

      • Responsible for managing social media accounts for the oldest club in UTD.• MIS is the professional association comprised of career-minded IT professionals who seek to expand their potential. The organization seeks to provide avenues for all its members to be teachers as well as students and to make contacts with other members in the IT field. MIS helps you become more marketable in rapidly changing, technological careers.

  • Magnum Opus IT Consulting Pvt. Ltd.
    • India
    • Software Development
    • 1 - 100 Employee
    • Data Analyst Intern
      • May 2018 - Dec 2018

      • Constructed SQL queries to retrieve data to analyze player segmentation, forecast ROI, and build visualizations. • Conducted A/B testing to develop a hypothesis to measure effectiveness which increased revenue by 11%. • Explained less participation using statistical analysis resulting in a decrease in entry fees and increase in participants • Constructed SQL queries to retrieve data to analyze player segmentation, forecast ROI, and build visualizations. • Conducted A/B testing to develop a hypothesis to measure effectiveness which increased revenue by 11%. • Explained less participation using statistical analysis resulting in a decrease in entry fees and increase in participants

Education

  • The University of Texas at Dallas
    Master's degree, Information Technology Management
    2019 - 2021
  • Savitribai Phule Pune University
    Bachelor of Engineering - BE, Computer Science
    2015 - 2019

Community

You need to have a working account to view this content. Click here to join now