Priyanka Sharma
New Delhi
Summary
Motivated and detail-oriented Business Analyst with 3 years of professional experience and a proven track record in data analysis, visualization, and reporting. Adept at client management with strong problem-solving skills and a keen ability to identify patterns and trends in data. Proficient in utilizing advanced Excel functions, SQL, and Power BI to create compelling data-driven narratives and deliver actionable insights. Demonstrated expertise in managing client projects within deadlines and streamlining processes through ETL and BRE automation.
Overview
3
3
years of professional experience
Work History
Business Analyst - Product Management
Ancora
Gurgoan
09.2023 - Current
- Product Demonstrations: Presented Ancora's SaaS solutions, including PowerPay for real-time payout calculations, and PowerOn for streamlined vendor acquisition and onboarding.
- Client and Project Management: Collaborated with CanaraHSBC, Piper Serica, GHFL, and Poonawalla Fincorp to gather and document client requirements in Business Requirement Documents (BRD).
- Managed solution delivery by maintaining trackers and process documentation for Change Requests (CR) related to Ancora's SaaS products.
- Client Engagement: Worked directly at Canara HSBC to automate the incentive process for Salesforce.
- Partnered with the tech team to enhance UI/UX, and improve product functionality.
- ETL Processes: Developed and executed ETL processes using an in-house tool for data extraction, transformation, and loading.
- Calculated commissions based on predefined logic and conditions.
- Business Rules Engine (BRE): Configured complex payout and incentive schemes using the BRE to ensure accurate calculations.
- Reporting: Generated detailed Excel billing reports for vendors and users, utilizing advanced functions, and SQL queries for precise data processing.
- Quality Assurance (QA): Performed comprehensive QA testing to verify software reliability, identify defects, and suggest enhancements to improve performance and user experience.
Data Analyst - Strategy and Management
Adda247
Gurgoan
12.2021 - 09.2023
- Conducted comprehensive data analysis to identify trends, and developed interactive dashboards and reports in Power BI using advanced Excel functions and DAX queries to track the performance of the company on all parameters, such as revenue, subscribers, views, targets, achievement, growth, and facilitating data-driven discussions.
- Developed and maintained a dashboard for the CEO's office to update on a daily basis the business performance of the company.
- Utilized data visualization tools, such as Power BI, to create interactive dashboards, resulting in improvement in data-driven decision-making.
- Performed mid-month and monthly business review reports and PPT for all company verticals.
- Performed faculty analysis reports and facilitated them to improve their performance.
Convergytics
Bangalore
10.2021 - 11.2021
- Performed extraction of Data files from the portals on a daily basis
- Cleaning and analyzing the data using Excel, and SQL Server
- Assist the Team in preparing reports with Power BI Desktop
Education
Masters of Travel and Tourism Management -
IGNOU
New Delhi06-2024
BSc. Mathematical Sciences - Mathematics, Computer Sciences, OR, Statistics
University of Delhi
New Delhi06-2017
12th - Non - Medical
CBSE
New Delhi04-2014
10th -
CBSE
New Delhi04-2012
Skills
- MS Excel
- MS Word
- PowerPoint
- Data Visualization -Power BI
- Database Management-SQL
- Python
- ETL processes
- Business Rules Engine (BRE)
- Client management
- Project Management
- Quality Assurance (QA)
- Issue tracking
- JIRA
- Process Documentation and Product solutioning
- Requirements gathering
- Business Analysis
- Reporting
- Dashboard Creation
- Excellent communication skills
Timeline
Business Analyst - Product Management
Ancora
09.2023 - Current
Data Analyst - Strategy and Management
Adda247
12.2021 - 09.2023
Convergytics
10.2021 - 11.2021
Masters of Travel and Tourism Management -
IGNOU
BSc. Mathematical Sciences - Mathematics, Computer Sciences, OR, Statistics
University of Delhi
12th - Non - Medical
CBSE
10th -
CBSE
Similar Profiles
Samantha ZickSamantha Zick
BOH Line and Prep Cook at AncoraBOH Line and Prep Cook at Ancora
Kevin M. GaleKevin M. Gale
MANAGING DIRECTOR, HEAD OF FIXED INCOME at AncoraMANAGING DIRECTOR, HEAD OF FIXED INCOME at Ancora
Aliana RamirezAliana Ramirez
Director of Educational Partnerships at Ancora Training/Ancora EducationDirector of Educational Partnerships at Ancora Training/Ancora Education
Ankit TanejaAnkit Taneja
Founder at Uphaar - Roohani EnterprisesFounder at Uphaar - Roohani Enterprises
Ajit SinghAjit Singh
Financial Modeling Student(Internship) at InvactFinancial Modeling Student(Internship) at Invact