PROFESSIONAL SUMMARY:

• 13+ years of IT consulting experience, and has deep exposure in Leading Projects, Solution Design and Data Architecture.
• Implemented and led “end to end” DW/BI and Data Migration projects, and was involved from initial requirement gathering, design and development to the production deployment.
• Involved in various Project Management activities including People Management, Resource Allocation and Mentoring, Project Tracking, Auditing and Quality Control.
• Worked on planning phase, and prepared Request for Proposals, SOW, Roadmaps and Project Estimations.
• Excellent Business and technical writing skills in preparing Technical Requirements Document (TRD), Roadmap, Requirements Traceability Matrix and Data Mapping Document.
• Thorough hands - on in ETL mappings and BI reports, primarily Informatica and Business Objects.
• Proficient in writing SQL queries, and performed Data Analysis and Data modeling activities.
• Worked on a strategy project around Big Data and AWS Cloud migration.
• Well versed with both Waterfall and Agile(Scrum) SDLC Model

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead/Senior Systems Analyst

Responsibilities:

• Rahul helped established the presence of Confidential, and helped gain further projects by successfully leading the RMB SIT module.
• Was directly managing 4 resources, and overseeing a team of 10 people.
• Actively involved in streamlining the load process, performance tuning and automation activities.
• Worked with Biller Team on Account Setup, Billing Calculation, Stop Loss and Invoicing.
• Prepared a white paper on how ASO Billing works in Health Plans, primarily focused on Stop Loss.
• Conducted the Group Structure requirement sessions with legacy and WGS stakeholders.
• Contributed to the Blue-print documentation for overall solution.
• Performed complex Data Analysis exercise on the data warehouse to compare disparate systems.
• Led the field mapping sessions to receive data in 834 file format.
• Rahul acted as a bridge between the business and development team.
• Key responsibility was to understand the requirements and work with team on solution design.
• Tracked the project progress, and kept senior management aligned on timelines
• Rahul was the Offshore Delivery Lead, and ensured nothing fails in production post upgrade.
• Managed the project with a completely fresh team, handling around 14 members.
• Involved in the entire SDLC from analysis phase to the development, testing and deployment.

Confidential

Project Lead, Data Modeler

Responsibilities:

• Rahul Created Conceptual Data Model for Claims, and tied to the Provider data model.
• Analyzed the existing databases and did extensive data profiling to determine the Data and the grain of target tables.
• Prepared requirement specification document and data mapping sheet for each identified system.
• Portrayed the complete process flow in MS Visio to gain confidence of the Senior Management and other stakeholders.
• The project required extensive interaction between the blues and the association.
• Documented the requirements and Data Lineage materials for each ETL layer.
• Worked with Capabilities team to identify a fuzzy logic for Member match, raising hit ratio to ~95%.
• Rahul was appointed as a Project Lead for Rx Claims migration.
• Conducted review sessions with each business team and SME’s to get the Technical Specification Document
• Connected with downstream teams to ensure the reports don’t break with the migration.

Confidential

ETL Architect

Responsibilities:

• Rahul prepared the ETL framework and assisted in Database Design by creating the Conceptual and Physical model.
• Coached the team members (onsite and offshore) with task planning, ETL code and review activities.
• Designed the task flow to transmit daily feeds via Informatica Cloud.
• Worked with team to implement the job scheduling module using Active Batch.

Confidential

Strategy Lead

Responsibilities:

• Rahul laid out a Visual Representation of Current State versus Target State Architecture
• Aligned the Offshore team setup (~10) and brought them up-to speed.
• Portrayed the Big Data design options for areas like Inquiry, Archival, Disaster Recovery along with key considerations.
• Assisted team build an end to end data flow, and data transfer solution from On-Premise to AWS Cloud.

Confidential

BI Consultant and Lead

Responsibilities:

• Rahul assisted finalizing the migration approach to the actual migration and testing.
• Groomed the team and provided sessions on Business Object tools and methodologies.
• Proactively came up with a whitepaper to track the challenges faced during the course of the project.
• Rahul was leading the team at onsite from the reporting front.
• Closely worked with the BW and reporting teams to design the reporting solution.
• Designed the BO security model on top of BW to enforce data level security
• Created PL/SQL procedures to replicate the legacy system functionality.
• Modified the existing Business Reports to accommodate database changes.
• Teamed up with the testing and front end team to check if balancing was reflected accurately
• Rahul was the lead designer and the onsite coordinator for the project.
• His role in the project started right from setting up the BO environment, which included installing the reporting application and its integration with the BW system, to the designing of BO reports and XCelsius dashboards.
• Dealt with end users to gather the reporting requirements and develop Business Object reports.
• Successfully developed the security model for the entire Data warehouse.
• Developed the dashboards involving traffic lights and alerts on the dashboard.
• Contributed in designing the ETL structure for better performance of the system.
• Continued working on building knowledge repository around system functionalities, sustenance docs, technology and processes used to build the security etc.

Confidential

Senior Developer

Responsibilities:

• Rahul studied the ongoing functional and technical requirements and helped create the tables in SQL Server.
• Broaden the spectrum in both Extraction, Transformation and Load (ETL) and Business Intelligence (BI) workspace, as worked in SSIS and SSRS modules.

Confidential

Operations Engineer

Responsibilities:

• Rahul worked on the essential maintenance activities, Fix on Fail, User Requests, Enhancements, Business raised change requests etc.
• Proactively came up with ideas to tackle daily issues and to enhance system performance.