Pradip Kumar Singh

• Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
• Conducted interviews with key business users to collect information on business processes and user requirements.
• Generated business intelligence reports to inform strategic decision-making.
• Collaborated with stakeholders to define project objectives and criteria.
• Proven ability to develop and implement creative solutions to complex problems.
• Generated standard and custom reports to provide insights into business performance.
• Created dashboards to monitor and track key performance indicators.

Responsibilities:

• Developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions.
• Performing and documenting data analysis, data validation, and data mapping/design.
• Reviewing and improving existing systems and collaborating with teams to integrate new systems.
• Conducting unit tests and helped in developing database queries to analyze the effects and troubleshoot any issues.

Responsibilities:

• Developed wire-frames, site maps and content inventories for new dashboard designs
• Synthesized current business intelligence data to produce reports and polished presentations highlighting findings and recommending changes
• Mapped process activities to identify shortfalls and identify options to rectify operational inefficiencies
• Optimized system and platform performance capabilities in most efficient, practical way possible
• Worked closely with all product development departments to create and maintain dashboard for their presentations and meetings
• Researched and helped team to resolved issues regarding integrity of data flow into databases
• Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement

Responsibilities:

• Created a dashboard to present operational, financial metrics in concise, insightful and user-friendly manner
  
• Generated insightful metrics from raw data using ETL process and Tableau software
  
• Design and develop complex reports, scorecard and dashboards according to ongoing process and operational needs using various tools such as Talend, SQL and Tableau
  
• Work closely with report requestors to clarify needs and ensure that deliverables are to their specifications and delivered in timely manned
  
• Provides planning, processing and performing all jobs
  
• Responds promptly and professionally to bug reports
  
• Analyzes, designs, coordinates and supervises the development of software systems
  
• Analyzes system specifications and translates system requirements to task specifications
  
• Utilizes tools and equipment involved in the performance of essential functions of programming including measuring instruments
  
• Maintains client databases
  
• Researches and recommends software tools to management
  
• Guide team development efforts towards successful project delivery. Provide technical leadership to teammates through coaching and mentorship
  
• Assist in the collection and documentation of user's requirements, development of user stories, estimates and work plans. Prepare reports, manuals and other documentation on the status and operation
  
• Adhere to high-quality development principles while delivering solutions on-time
  

Responsibilities:

• Collects client data from different sources, perform ETL using Talend to process raw data into useful information and build the dashboard using Tableau.
  
• Revenue and materials management dashboards for billing, procurement, finance metrics, inventory management, and more
  
• Clinical dashboards for pediatrics, oncology, cardiology, endocrinology, ophthalmology, and more
  
• Operational dashboards for bed & unit management, ADT analysis, ALOS, registration, labs, and more
  

Responsibilities:

• Setup Tableau Dashboards to see daily/weekly/MTD reports of different metrics for different (almost 20) teams in Operations
• Automated daily/Weekly/MTD reports using Excel VBA
• Generate 90% of the reports using VBA Macros automation
• Very efficient and quick in delivering Ad-hoc request
• Analyzing the reports prepared and provide insight on the report
  

Responsibilities:

• Preparing reports using VBA, Macros
  
• Pipeline reports to all the Business Development Executives and Management
  
• Subsidy report for NSIC
  
• Chairperson and Ratings Analyst performance report
  
• Salesperson revenue reports
  
• Automation of excel, word to reduce the time and increase productivity
  
• Automated outlook and excel to send emails to the huge number of customer in very less time
  
• Working with google forms
  
• Providing inputs and testing the reports generated from a customized Rating software
  

Responsibilities:

• Preparing Reports using VBA, Macros
  
• Thomas - Kilmann Conflict management report
  
• Career-Path Index report
  
• Influentiality index report
  
• Managing Learning Management System (LMS)
  
• Scheduling Classes
  
• Updating Course Modules
  
• Creating Assessment papers and Scorecards
  

Responsibilities:

• Health Insurance plan designing
  
• Client profiling for healthcare plans
  
• Financial ratings for health insurance carriers
  
• Preparing reports using VBA, Macros
  
• Health Insurance plan comparison
  
• Benchmarking report for the client
  
• Automation of excel using VBA and Macros, word to reduce the time and increase productivity
  
• Designed MS Access tool to track daily activity and different projects activity
  

Responsibilities:

• Health Insurance plan designing
  
• Health Insurance certificates designing using IStream applications.
  
• Team Handling of 6 members
  
• Query resolution of team members as well as clients
  
• Preparing reports using VBA and Macros
  
• Productivity report
  
• Quality Report
  
• TAT report
  
• Automation of excel using VBA and Macros to capture data and prepare the report
  

Project Title: Batch Management System

Client: NIIT NOIDA

Role: Programmer

Team Size: 1

Skill Used: J2EE, SERVLET, JSP, SQL, HTML

Project Details: This is a web application. The BMS is designed in such a way that it will not only keep records of the batches running in a center but also will suggest the scheduler with options of empty slots, number of students in a slot and faculties available at a particular time. This will reduce a lot of paperwork, time and hassle involved in batch management at any center.