Neeraj Kumar Email & Phone Number

Noida, Uttar Pradesh, India

Experienced and goal-oriented Technical Lead at R1RCM, specializing in Database Management, AI/ML, Python Development, and Project Planning. I help healthcare organizations improve their revenue cycle management by creating efficient, tech-driven solutions.I have a strong background in Agile and Scrum methodologies, leading teams to deliver high-quality projects on time. I’m passionate about building smart systems, solving complex problems, and driving impactful results.Key Skills:AI/ML: Developed predictive models and algorithms to make processes faster and smarter.Database Management: Managed and optimized large databases for better performance and reliability.Python: Built scalable applications and automated processes to save time and resources.Leadership: Guided teams to achieve goals and work effectively using Agile practices.Project Planning: Planned and executed projects, ensuring they were completed on time and met business needs.I’m always excited to learn new technologies, improve processes, and work with teams to create innovative solutions.

Noida, Uttar Pradesh, India

Client: Lord Abbett & Company LLCLord Abbett, a leading global asset manager, embarked on a strategic initiative to enhance its reporting capabilities through the development of a Data Warehouse solution. This solution aimed to leverage the Vermillion Reporting Suite (VRS) as the primary reporting tool to generate customized reports for various stakeholders. The project focused on supporting daily, monthly, quarterly, and ad-hoc reporting requirements, catering to the diverse needs of the organization. Data point included from fund performance, characteristics, holdings, breakdown, and attribution.Responsibilities:• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.• Involved in documentation of Data Mapping and ETL specifications for development from source to target.• Maintained warehouse metadata, naming standards and warehouse standards for future application development.• Implemented Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS/ETL Packages and Python Scripts for custom data handling requirement.• Good understanding of VRS (Vermillion Reporting Services Suits) for custom reporting, supports in Entity, Record set, Data Source, Style, Component, Scheduling and Obligation.• Good Understanding of Various delivery method and configuration for VRS for custom delivery Need likes (Email delivery, Shared Folder etc.)• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.• Created SSIS packages to clean and load data to data warehouse and packing to transfer data between OLTP and OLAP databases.• Created complex ETL packages using SSIS to extract data from staging tables to partitioned tables with incremental load.• Creating Service now incidents, request, and standard change to deploy ETL code.

Noida

Client: Encore Capital GroupProject Description:The Apollo - Verbal Contact: Dial Build Project aimed to enhance the functionality of the Dial Build process used in the MCM (Multi-Channel Marketing) call centre business. The project focused on developing a methodology to determine the principal account of contact for consumers, thereby preventing duplicate customer contacts and optimizing the dialling process. Additionally, the project aimed to allocate Dial Build files to Account Managers (AMs) based on their skill/authority and customer response, enabling efficient management of customer accounts.Responsibilities:• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.• Actively involved in interacting with business users to record user requirements and Business Analysis.• Involved in documentation of Data Mapping & ETL specifications for development from source to target.• Designed and developed the data transformations for source system data extraction; data staging, movement, and aggregation; information and analytics delivery.• Worked with SSDT Designer tools in developing SSIS solution to extract and load the data from flat files, SQL Server.• Maintained warehouse metadata, naming standards and warehouse standards for future application development.• Involved in unit testing and system testing while the code is moved to production.• Worked with slowly changing dimension (SCD) Type1, Type2, and Type3.• Implemented Elastics search in SSIS package using Zappysys SSIS Power pack custom tasks and flows.• Worked with REST API in SSIS and there testing.• Designed and implemented to deploy code through CI/CD tooling and automation.• Code migrations from one environment (DEV-QA-UAT-PROD) to another environment like (DDL’s, SPs, and DML VIEWS, SSIS).

Noida

Client: Station Casino 1. Application Database Maintenance: Responsible for the ongoing maintenance and management of the application database, ensuring data integrity and system reliability.2. Database Object Creation: Created and managed database objects, including procedures, views, and tables, aligning them with business requirements and best practices.3. Index Optimization: Implemented and maintained index structures to optimize query performance, resulting in faster and more efficient data retrieval.4. JSON Data Parsing: Proficiently parsed JSON data and imported it into the database, enabling structured storage and facilitating data analysis.

Pune Area, India

As a senior Engineer, I am closely working with client, from requirement gathering to sprint planing and end to end delivery of the solution. My main work includes working on SSIS development, SQL development, Performance tuning of ETL Load, Performance tuning of SQL queries.

Noida Area, India

1. Database Structures and Performance Optimization: Developed and maintained database structures while prioritizing performance optimization, ensuring efficient data storage and retrieval.2. ETL Process Design and Implementation: Designed and implemented ETL processes to extract data from multiple sources and transform it for business intelligence purposes, enabling data-driven decision-making.3. Reporting and data analytics solution implementation: Leverage SQL Server Reporting Services (SSRS) to produce actionable insights through visually appealing and informative reports, enhancing organizations' operational efficiency, transform it for business and enabling data-driven decision-making.3. Team Support and Leadership: Provided guidance, direction, and support to team members, ensuring they had the resources and skills needed to excel in their roles, fostering a culture of knowledge sharing and growth.5. Project Management: Oversaw project planning, execution, and delivery, ensuring strict adherence to timelines and maintaining high-quality standards.6. Stakeholder Collaboration: Collaborated closely with stakeholders to define project requirements, objectives, and deliverables, facilitating effective project outcomes

Client: Microsoft1. Reporting and data analytics solution implementation, by leveraging the SSRS to produce actionable insights through visually appealing and informative reports, enhancing organizations' operational efficiency, transform it for business and enabling data-driven decision-making.2. SQL development, creation of DB object for supporting the need of business.3. Report publishing to sharepoint server.

Client: Oracle India1. Content Publishing Support: Provided essential support for content publishing to Oracle University for a wide range of course materials.2. Application Development: Spearheaded the development of applications aimed at optimizing content management, including content splitting, format conversion (from PowerPoint to PDF), and the generation of XML for index structure creation.3. Course Material Enhancement: Contributed to enhancing the accessibility and usability of course materials by generating XML to create efficient index structures, facilitating easy access for learners.

Master Of Technology - Mtech, Artificial Intelligence, 7.3

Executive Development Program In Business Analytics And Big Data, Big Data

Master'S Degree, Computer Application, 72

Bca, Computer Applications, 67

Master Of Technology - Mtech, Aiml