Shrikant Shekhar

Shrikant Shekhar

Business Analyst /Data Analyst
India
English, Hindi

About Me

To acquire a good position in Data Analytics / Business Analyst where I could utilize my knowledge of Business strategy building, Power BI, SQL , Python and Analytical skills for the profitability of the organization as …

Experience

Power BI Developer

Ienegizer
May 2023 - Present · 3 years 1 month

• End to end Power BI Dashboard development, deployment (publishing of reports), report automation, create pages like Agent Performance Report, Monthly and Daily performance report, Call Detail Report, Monthly billing.
• Develop Global Short-Term and Long-Term forecasts for all call volumes.
• Write DAX, create hierarchies, put row level security, set schedule refresh, Data modeling, Data manipulation, build interactive visualizations.
• Use SQL server to create store procedure, BULK import, create views, write DDL, DML, DCL commands, joins.
• Used Python and Machine Learning for Predictive Modeling, for calculation of attrition.
• Effectively solve complex business problems in cross-functional environment, interacting with partners in Capacity Planning, Finance, Scheduling and Real Time Optimization Via Interviews, sprint discussion, User story, Create Business Related Document, User Manual, build crisis/contingency plan.
• Conduct in-depth research on accounts and provide sales intelligence for strategic deals and positive impact on business outcomes.
• Conduct cross functional discussion with various team (sales and development) to help build business strategy and with proper business research.

Power BI/SQL Developer

Ienergizer
May 2023 - Present · 3 years 2 months

End to end Power BI Dashboard development
Deployment of reports
Report automation
Create pages like Agent Performance Report, Monthly and Daily performance report, Call Detail Report, Monthly billing
Develop Global Short-Term and Long-Term forecasts for all call volumes
Write DAX
Create hierarchies
Put row level security
Set schedule refresh
Data modeling
Data manipulation
Build interactive visualizations
Use SQL server to create store procedure
Use BULK import
Create views
Write DDL commands
Write DML commands
Write DCL commands
Use joins
Used Python and Machine Learning for Predictive Modeling
Calculation of attrition
Effectively solve complex business problems in cross-functional environment
Interacting with partners in Capacity Planning, Finance, Scheduling and Real Time Optimization Via Interviews
Sprint discussion
User story
Create Business Related Document
User Manual
Build crisis/contingency plan
Conduct in-depth research on accounts
Provide sales intelligence for strategic deals
Conduct cross functional discussion with various team
Help build business strategy
Business research

Business Analyst

PROVANA Pvt. Ltd.
Nov 2021 - Jun 2022 · 7 months

End to end Dashboard development using Power BI
Development of collection pages
Development of liquidation and revenue earned dashboards
Development of inventory of files dashboards
Development of forecasting and loan default and recovery of loans dashboards
Power BI function used
DAX expression
Data modeling
Data visualization
Drill down
Drill trough
Used SQL skills for creating store procedure
Used joins
Used group by
Created complex sub queries
Created views
Knowledge of documentations - BRD
Requirement gathering
Create user story
User Manual
Interviewed and conducted workshop with client on product requirement
Worked on recommended technological to create an optimized report

Business Analyst R&D

CETPA INFOTECH PVT LTD
Mar 2020 - Sep 2021 · 1 year 6 months

Development of interactive dashboard for CETPA InfoTech
Perform DAX queries using Power BI tools on Revenue earned
Forecasting trends on enrolment
Category wise analysis
Number of Student Placed
Publish Power BI report using Power BI Services
Create hierarchies
Drill down
Drill through
Build KPI
SQL SERVER – performed operation like joins
Grouping
CRUD operations
Set trigger
Facilitate regular meeting with client for updating and addition on project
Transmitting business goals into technical specification
Do market research for positive business outcomes
Provide sales intelligence support
Help to build business strategy
Cross discussion with various team

Skills

MS Sql Server Python Power BI Data Analysis and Reporting SQL Machine Learning DAX Data modeling Data manipulation Report automation Hierarchies Row level security Scheduled refresh Interactive visualizations SQL Server Stored procedures BULK import Views DDL DML DCL Joins Predictive Modeling Logistic Regression Decision Tree Random Forest NumPy Pandas Matplotlib Seaborn Ridge regression Lasso regression K Nearest Neighbor Communication skills Analytical skills Agile methodology
Report this Profile?