Mayank Agarwal

• Improved team efficiency by streamlining processes and implementing innovative management strategies.
• Identified areas for improvement within the department, implementing strategic initiatives to address gaps in performance or resources.
• Created and maintained a strong team culture that promoted high levels of collaboration, employee satisfaction, and overall performance.
• Supervised day-to-day operations to meet performance, quality and service expectations.
• Mentored junior staff members on best practices for project management and team collaboration skills, fostering a supportive work environment.
• Conducted performance evaluations and provided constructive feedback to employees.
• Established team priorities, maintained schedules and monitored performance.
• Established performance goals for employees and provided feedback on methods for reaching those milestones.

• Produced comprehensive management reports across IT systems for continued analysis and evaluation.
• Integrated new business systems swiftly and accurately, building momentum for technical project opportunities.
• Developed and implemented effective IT strategy to meet company infrastructure demands.
• Carried out system builds, reviews and general administration to consistently maximize platform potential.
• Delivered IT and Data services within agreed SLAs for full department compliance.
• Worked flexibly to meet out-of-hours IT coverage and disaster recovery.
• Researched and implemented emerging technologies, hardware and software.
• Introduced new methods, practices, and systems to reduce turnaround time.
• Functioned as point of contact for project administrators and managers focused on timely and successful completion of full lifecycles of assigned projects.

Key Features of an HRMS/PMS Application: Benefits of an Integrated HRMS/PMS Application:

Project: Jindal Integrated Information System (JIIS) ERP.

Environment: ASP.Net, Oracle 11g, Crystal Reports.

Project Description:

Jindal Integrated Information System designed and developed in ASP.NET to specifically target enterprises. It has all the features of P2P, O2C and HRMS. All the processes are categorized, giving a simple interface to end user.

• Created multi-tier architecture for the application in ASP.NET, C#.
• Requirement Analysis, Unit test case preparation and Unit testing.
• Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using Connected Architecture which requires the strong OOP concepts.
• Involved in complete Life Cycle including Analysis, Design, Development and Testing.
• Developed modules of the application in ASP.NET and involved in writing C# classes.
• Creating custom site pages, lists, views and master pages and adding ASP controls.
• Expertise in developing the reports using SAP Crystal Reports product. Exposure to sub-reports, charts, graphs, cross tab reports.
• Sound knowledge of basic SQL, relational Database and advanced SQL queries.
• Developed Complex database objects like Stored Procedures, Functions, Packages , Views and Triggers using SQL and PL/SQL.

Project: Dealer Order Management System (DOMS).

Environment: ASP.Net, Oracle 11g, Crystal Reports.

Project Description:

Dealer Order Management System designed and developed in ASP.NET. Dealer can raise order and they can track the status of order. Purpose is to provide the visibility to dealer sales team. All the processes are categorized, giving a simple interface to end user.

• Involved in complete Life Cycle including Analysis, Design, Development and Testing.
• Creating custom site pages, lists, views and master pages and adding ASP controls.
• Developed Complex database objects like Stored Procedures, Functions, Packages , Views and Triggers using SQL and PL/SQL.

Project: E-Invoicing.

Environment: ASP.Net, Oracle 11g, Crystal Reports.

Project Description:

E-Invoicing designed and developed in ASP.NET. API based request to IRP for Submission of validated data/JSON Schema from ERP and getting back the QR code and IRN successfully from IRP.

• Creating custom site pages, lists, views and master pages and adding ASP controls.
• Developed Complex database objects like Stored Procedures, Functions, Packages , Views and Triggers using SQL and PL/SQL.

Project: Extrusion Information System-EIS.

Environment: ASP.Net, Oracle 11g, Crystal Reports.

Project Description:

EIS designed and developed in ASP.NET. EIS is a application through which we are getting real-time data from scada to ERP system, gives context to plant-floor data, and enables the coordination of schedules, orders, distribution, and more, helping our company comply with regulations, improve efficiency, increase transparency, and accelerate data availability and synchronization.

• Creating custom site pages, lists, views and master pages and adding ASP controls.
• Developed Complex database objects like Stored Procedures, Functions, Packages , Views and Triggers using SQL and PL/SQL.

Project: HRMS/PMS.

Environment: MVC, SQL.

Project Description:

An HRMS/PMS application is a software solution that combines both Human Resource Management System (HRMS) and Performance Management System (PMS) functionalities into a unified platform. This kind of application helps organizations manage HR tasks and employee performance seamlessly in one system, reducing the need for multiple, disconnected tools.

• Employee Data Management (HRMS):Store and manage employee records (personal information, job details, etc.).
  Track work history, compensation, benefits, and legal documents. Centralize employee data for easier access and reporting.
  
• Payroll & Compensation (HRMS):Automated payroll processing and compliance with local labor laws.
  Manage employee salaries, bonuses, deductions, and benefits. Tax management and generation of payslips.
  
• Recruitment & Onboarding (HRMS):Manage recruitment processes (job posting, applications, interviews).
  Streamlined onboarding processes for new hires, including document submission and training schedules.
  
• Time and Attendance (HRMS):Track employee attendance, working hours, and leaves (sick, vacation, etc.).
  Integration with biometric devices or mobile apps for clock-in/out features.
  
• Employee Training & Development (HRMS):Manage training schedules, track employee skills, and development programs. Evaluate training effectiveness and improve skill development programs.
  
• Performance Reviews & Appraisals (PMS):Set performance goals for employees and track progress. Conduct regular performance reviews, feedback sessions, and 360-degree feedback collection. Align individual goals with organizational objectives.
  
• Continuous Feedback & Recognition (PMS):Enable ongoing feedback from peers, managers, and employees.
  Employee recognition tools to celebrate achievements and milestones. Encourage motivation and morale-building.
  
• Goal Setting & Tracking (PMS):Establish SMART (Specific, Measurable, Achievable, Relevant, Time-bound) goals for employees. Track goal progress and ensure alignment with organizational objectives.
  
• Analytics & Reporting (HRMS/PMS):Generate detailed reports on HR data, attendance, payroll, performance, and more. Advanced analytics to identify trends, performance gaps, and areas of improvement. Customizable dashboards for HR and leadership teams.
  

Benefits of an HRMS/:

• Efficiency: Automates repetitive HR tasks like payroll, attendance tracking, and performance reviews, saving time for HR professionals and managers.
• Data Accuracy: Reduces human errors and ensures that all employee-related data is consistently accurate and up-to-date.
• Improved Decision-Making: Real-time insights and analytics from both HR and performance data help in making informed decisions regarding talent management.
• Employee Engagement: Features like continuous feedback, recognition, and career development opportunities can lead to higher employee satisfaction and engagement.
• Goal Alignment: Helps align individual performance with company goals, driving greater overall success.

Project: HMS.

Environment: MVC, SQL.

Project Description:

A Hospital Management System (HMS) is a software application that helps in managing and automating various aspects of a hospital's operations. It streamlines administrative, financial, and clinical processes to ensure better management of resources, improved patient care, and overall efficiency. Here are some of the key features and functionalities commonly found in a Hospital Management System:

• Patient Registration: Allows new patients to register and manage their basic details like name, age, gender, contact information, etc. Provides a unique patient ID for easy identification in the system.
• Appointment Management: Allows patients to schedule appointments with doctors. Provides doctors with a system to manage their schedules and availability.
• Patient Medical Records: Stores and manages patient history, diagnoses, treatments, lab results, prescriptions, and other clinical data. Enables doctors and healthcare providers to access patient records quickly for better decision-making.
• Billing and Payment Management: Handles invoicing and payments for services rendered, including consultation fees, laboratory tests, surgeries, etc. Can integrate with insurance providers for claim management.
• Inventory Management: Keeps track of medical supplies, medications, and other hospital assets. Ensures that stock levels are maintained and helps with reordering when necessary.
• Laboratory and Test Management: Manages laboratory test requests, results, and scheduling. Tracks patient progress and notifies when tests or results are ready.
• Doctor and Staff Management: Manages doctor and healthcare staff profiles, schedules, and payrolls. Tracks qualifications, specialties, and availability.
• Pharmacy Management: Manages the hospital's pharmacy by tracking medication stocks, orders, and dispensing. Ensures accurate prescriptions and helps avoid medication errors.
• Emergency and Admission Management: Handles emergency patient admissions and ensures smooth coordination. Assigns rooms, manages beds, and tracks patient status.
• Reporting and Analytics: Generates reports for financial, clinical, and operational purposes. Provides insights into hospital performance, patient demographics, revenue generation, and more.
• Security and Compliance: Ensures that patient data is secure and meets legal and regulatory standards (e.g., HIPAA in the US). Provides role-based access control and audit logs for monitoring actions within the system.
• Telemedicine and Remote Consultations: Allows virtual consultations between patients and healthcare providers. Facilitates follow-up appointments and regular check-ins remotely.

• Efficiency: Streamlines hospital operations and reduces manual errors.
• Data Management: Centralizes data, making it easily accessible and well-organized.
• Improved Patient Care: Faster access to patient data enables better clinical decisions.
• Cost Savings: Automation reduces administrative costs and errors.
• Scalability: Can grow as the hospital expands and additional services are added.

• Delivered unit-tested systems within customer-prescribed timeframes.
• Tested methodology with writing and execution of test plans, debugging and testing scripts and tools.
• Increased code quality and reduced bug rates by establishing comprehensive unit and integration testing protocols.
• Conducted data modeling, performance and integration testing.

• Wrote and developed new and well-tested code for different software projects.
• Performed software testing and diagnosis, supporting ongoing embedded system development.