Prashant Kumar

• Tool 360(Create a dashboard to achieve the optimize the internal Tools of FIS transforming more than 2500 tools present as per process and drive global Tools roadmap and governance)
• 2.4 Years of experience of working in Power BI, SQL, Python, data modelling, descriptive and predictive analytic.
• Created Power BI dashboard to depict various views of Tools like Ownership View, Operational View, Technical View, Strategic View, and Roadmap view.
• Used Power BI DAX for creating Complex Calculated Columns and Calculated measures used in various KPI’s of Tools Analytical View as well as business requirements.
• Developed Paginated Reports using Power BI report builder to generate pdf. of Summary of Tool which would be further used by VP’s or higher management for decision making. Integrated the Paginated report with Tool 360 dashboard.
• Created Power Apps to bring feedback loop for Tools. So that any rectification or suggestion can be provided by Tool experts and created various flows using Power Automate to get notification, implements approvals, and send notification to Tool Owners So that Backend data is up to date.
• Implemented Custom connector in Power Apps to Connect with FIS AI based APIs to bring Q&A Ability in Power BI. Integrated all Power BI, Power Apps and Power Automate.
• Participated in requirements meetings and data mapping session to understand business needs and delivered efficient solution to those needs.
• Requirement Readiness Engineering (Create a Power BI dashboard to shows the various KPI’s of readiness score shared by all the requirement managers and integrating with financial data).Developed and maintained complex SQL scripts using Stored Procedures, CTE’s and SQL Views to ensure high performance data integration solution for the Requirement Readiness Report.
• Around 120 Requirement managers in SharePoint Lists merged them into SQL tables.
• Created Power BI report as per the business requirement provided by the best methodology and executed daily report publishing in Power BI service and was responsible for maintenance and sharing of report access various stakeholders.
• Worked with the teams to define report requirements and to design and develop sound database solutions.
• Used Power BI DAX to calculate Loan loss as per calculation shared by stakeholder and depicted the Loan Loss in the report for various vintage as well as report dates.
• Developed complex SQL script using stored procedures and common table expressions(CTEs) to support Power BI Cashflow and Loan Loss report and created dashboard for showing correlation between Loan Loss and credit scores for all vintage.
• Built a machine learning model using python to predict Loan Loss for next 1 month,3 month. Was able to get accuracy of 90% for 1 month and 87% for 3 months. Used Precision and recall matrix to ensure the accuracy.
• Worked on complex calculated measures, columns and tables using Data Analysis Expression language (DAX).
• Developed complex SQL queries using stored procedures, common table expressions (CTEs),and Views to be used as Direct mode of import by the report.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), and views to be used as a Direct mode of import by the report.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), Views to be used as Direct mode of import by report.
• Participated in daily meetings, huddles and discussion with client and internal team members for gathering requirements and understanding business needs.

● Project WorkAbility for Hartford
This is a development project in the Insurance domain for the maintenance and enhancement of PL SQL and Python-based. This is a long-term project with our company for more than a decade.
It follows Agile Scrum methodology and sticks to most of the Agile principles like Scrum, Sprint planning, Sprint
Retrospective, etc. For inculcating development best practices and tracking purposes, we use IBM’s Rational Team Concert (RTC).
● Created procedures and packages in PL/SQL Oracle using Toad application Worked on Exception Handling related to my User Story.
● Used GIT on daily basis to publish changes and deployment.
● Successfully delivered user stories planning and implementation that facilitated smooth project deliveries.
● Attended client scrum calls and handled real-time problems on a daily basis, honed communication skills.
● Created stored procedures and functions that helped to reduce the load on the backend server.
● Implemented Python to schedule jobs.