Shrikant Shekhar

• 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.

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

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

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