Pratik Mohanty

Accomplished Technical Consultant with 10 years of experience implementing proactive IT solutions and resolving workflow-related challenges in government and financial sectors. Certified in [Area of certification], I specialize in [Area of expertise]. Dedicated to delivering exceptional results, I excel in analyzing complex technical issues, devising innovative strategies, and collaborating with cross-functional teams to drive efficiency and optimize performance.

• Project Management Unit for Building & Other Construction Workers Welfare Board under Department of Labour, Employment, Training & Skill Development Jharkhand, 11/2023 - Present, Ranchi, Jharkhand, Building & Other Construction Workers Welfare Board, Department of Labour, Employment, Training & Skill Development Jharkhand, PricewaterhouseCoopers (PWC), The Department of Labour, Employment and Training, Government of Jharkhand committed to protect the interest of its labour force in the organized and unorganized sectors in the fast-changing economic scenario to effectively implement various Labour laws and to produce trained manpower. To achieve this objective of the state, the Department started initiatives viz. Aam Admi Bima Yojana, upgradation of ITIs, Converting ITIs in centres of Excellence, conversion of Employment exchanges into Model career centre etc. In this regard, a Project Management Unit for Building & Other Construction Workers Welfare Board was constituted for performing PMU activities for the department., Associate, Conduct in-depth financial analysis by reviewing financial statements, balance sheets, income statements, and cash flow statements., Assist in the development of budgets and financial forecasts, monitoring performance against these budgets, and providing insights on variances., Generate financial reports and dashboards to communicate key performance indicators (KPIs) to stakeholders., Analyse historical and current financial data to identify trends and patterns that may impact., Bid Process Management, Building Functional Requirement Specifications, Wireframe design and presentation of Cess Management portal., Maintaining utility certificate report for BOCW on their annual and monthly expenditure of benefits provided to BOC workers., Conducting and providing training sessions to District Officials.
• Project Management Unit for Department of Transport, Jharkhand, 07/2023 - 10/2023, Ranchi, Jharkhand, Department of Transport, Jharkhand, PricewaterhouseCoopers (PWC), Infrastructure as a Service (IaaS) and Software as a Services (SaaS)., Associate, As-Is Study of S permit portal and finding out the problematic features., Development of MIS/Dashboard based on different types of data & use cases using SQL, Excel., Assist client in documentation and knowledge transfer., Wireframe design of Challan system for Jharkhand traffic., Concept note & SOP for traffic enforcement system in Jharkhand., Workflow diagram for Automatic Testing system for Commercial vehicles., Built Payment workflow for Commercial vehicle driving training school., Data collection and Dashboard creation to present the statistics of Commercial vehicle permit and counter-signature status.
• Odisha State Workflow Automation System (OSWAS), 11/2018 - 06/2023, Bhubaneswar, Odisha, Odisha Secretariate, Tata Consultancy Services (TCS), OSWAS application was implemented to digitalize and automate the workflow of Odisha Secretariat. Later the application was deployed in all districts of Odisha starting from block level to digitalize the government systems., System Engineer, Database development using MYSQL., Query optimization for better performance of the application., Building new queries for MIS reports to be implemented in OSWAS application., Building queries to generate customized reports as per client’s requirements., Provided database training to team members.
• Nielsen, 05/2016 - 10/2018, Bhubaneswar, Odisha, Nielsen Global Solutions, Tata Consultancy Services (TCS), Support in Nielsen Global Solutions to maintain their retail customers., System Engineer, Query optimization using PLSQL., Building queries for report generation for MIS of the application.
• Agilent Technologies, 01/2014 - 04/2016, Kolkata, West Bengal, Agilent Technologies, Tata Consultancy Services (TCS), Maintaining grid database and server., Assistant System Engineer, Patching activities of new versions of the existing Oracle Exadata server, Data import and export from development database to production database, Providing 24x7 support to the customer, Maintaining threshold utility of the server, Taking hot and cold backup of the database

• Total Experience: 9.5 years
• Date of Birth: 05/08/93
• Nationality: Indian

• Completed Google project management certification.