Vikas Singh

Business Analyst

Pune, Maharashtra, India8 yrs 11 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Proficient in SQL and Python for data analysis.
Experience in healthcare data analytics and reporting.
Skilled in creating dashboards using Tableau and Power BI.

Stackforce AI infers this person is a Data Analyst with expertise in Healthcare analytics and Business Intelligence.

Contact

Skills

Core Skills

Data AnalysisBusiness AnalyticsSales AnalyticsSales OperationsBanking Analytics

Other Skills

SQLPythonExcelPower BITableauPegaTeradataImpalaSFDCMicrosoft OfficeLeadershipMicrosoft WordResearchMicrosoft PowerPointSocial Media

About

A smart-working and enthusiastic Computer professional with good knowledge and hands-on experience in the latest technologies Salesforce, SQL, Tableau, Teradata and Advanced Excel. Like to learn new trends in information technology and explore my skills in that.

Experience

8 yrs 11 mos

Total Experience

2 yrs 2 mos

Average Tenure

5 yrs

Current Experience

Cognizant

Business Analyst - Analytics

Jun 2021 – Present · 5 yrs

Worked in Marketing Analytics and Business Insights Team
Analyzed healthcare data, generated reports and provide complex data-driven solutions to client requests to guide them in making major decisions in branding strategy
Lead end-to-end involvement in product launches, seamlessly navigating from initial requirement gathering to User Acceptance Testing(UAT)
Created metrics as per the business requirement document for the new launch of product using SQL codes
Configuration of product business rule in Pega system
Created the Insight suggestion dashboard for various franchise using SQL codes and Excel
(Rheum, Gastro, WH, Urology, GIC, Derm, Hepatology etc )
Automated the codes in Python script to refresh the dashbaord
Maintained the Master Business Requirement Document to track and document the product details, ensuring accessibility for business stakeholders to review
Worked on adhoc analysis requests utilizing technologies like Advance Excel,Hive,Trino, snowflake, Python
Proficient in SQL for database querying and manipulation. Utilized Python Particularly in data analysis using Pandas
Migrated Excel dashboard to Power BI dashboard

SQLPythonExcelPower BITableauPega+2

Zs

Data Analyst

Apr 2020 – May 2021 · 1 yr 1 mo · Pune, Maharashtra, India

Worked in Sales/Marketing Analytics and Business Insights Team
Analyzed healthcare data, generate reports and provide complex data-driven solutions to client
requests to guide them in making major decisions in branding strategy using excel
Used Impala and Teradata for data query and huge Datasets
Created tracker to track the performance of the brands by calculating Volume/Market Share/ Market Share Change on the fresh data
Created the Linear Projection to check the recovery of brands and Market
Worked on Adhoc Requests

ExcelTeradataImpalaData AnalysisSales Analytics

Nvidia

Data Analyst

Sep 2018 – Apr 2020 · 1 yr 7 mos · Pune Area, India

Worked in Sales Operation as a part of customer master data and reporting team
Perform data-cleansing activities to ensure sales data is consistent and accurate for
Management reporting
Data-Cleansing activities using Excel and SFDC reports
Created Dashboards in Tableau to have a track of all Salesforce accounts/Leads/Contact to check
the weekly, monthly and yearly reports.
Involved in creating database objects like tables, view and writing queries in SQL
Works closely with stakeholder to understand and implement business rules
Created reports and report folders for different user profiles based on the need in the organization
Worked on Adhoc Requests