Senior Consultant
CAPGEMINI
Total years of experience :18 years, 10 Months
CHCS Services
Brief description of the project:
CHCS Services, Inc. is a leading full-service Third-Party Administrator (TPA) of Health and Life Insurance products. This project is part of large technology transformation program within CHCS and will cater to converting the legacy policy admin system CAPSIL, along with its peripheral systems to new technology based insurance policy admin system called as InsPro. It involves understanding the new platform from a technological and functional perspective, designing the data conversion model and maintenance. CAPSIL and InsPro systems will be functional in parallel, administering certain lines of business independently. Interfaces between InsPro and legacy systems are crucial in the project. Scope of project is to analyze business requirements, develop technical specifications, writing new programs, modifications to the existing ones, testing and deployment in model and production environments.
Job Responsibilities:
•Managing and leading the project team
•Final approval of the design specification
•Establish and enforce technical standards for deliverables of projects.
•Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI.
•Create\document ETL framework and a template package to help developers understand ETL development strategies.
•
Tesseract Upgrade and Concorde Consolidation (TUCC) and TSO (Transformation, Stabilization and Optimization)
Brief description of the project:
Tesseract is a service center application used in APAC, EMEA and LATAM region with separate database instances for each region. As a part of upgrade project all database server needs to be consolidated into single Instance thereby reducing maintenance, cost and providing efficient performance. This project also includes coding and development of sql Interfaces to communicate with ERP & external systems.
MSI has outsourced Repair Services to SCI. SCI will take over the Repair operations on behalf of MSI. And TSO is a MSI-SCI integration project. An RMA will be initiated in the appropriate MSI repair application (Tesseract) for all regions and for all repair businesses. The RMA “Create” will be sent from MSI through the B2B Data Hub to SCI. SCI will load the RMA into their repair application and send a “Functional Acknowledgement” back to MSI through the B2B Data Hub. Same as Create there are Update/Hold/Release outbound transactions. Like outbound there are some inbound notifications which Sanmina is sending (WIP/
UHC (United Healthcare)
Brief description of the project:
It’s an in-house application development of pre-adjudication process in healthcare insurance claim processing.
Use SSIS for transferring processed data to client with business validation also send the confirmation mail regarding file name and other details. We have built our OCR application “Red Drop” claims, in that we have use TOCR and MODI components. In that application we have cropped images and pass to TOCR and MODI engine. After validating data as per business validation we have post in DB.
Responsible for:
•Database Designing, User Interface, Coding and Report Generation and Lead team.
•Primary point to contact for customer for various business process improvements.
•Negotiated requirement and implemented solution within application functionality.
•Created Stored Procedures, triggers, views, tables and generated TSQL
•Created indexes for better performance
•Create and deploy SSIS packages
•Involved in database development using stored procedures, triggers, views and cursors.
•Maintained data integrity by performing validation checks.
•Involved in running the SQL Profiler for better execution Plans.
•Generated custom and parameterized reports using SSRS
•Created reports that call sub reports in SSRS
TRI-Code:
TRI-Code is a code-from-image system allowing secure document coding over the Internet or a local area network. The application is a process flow management system that controls the distribution of coding “batches” throughout the indexing process; including logical unitization, coding, QC, and data validation and MIS report. The system allows the tracking and reporting of the batches throughout each process, the monitoring of productivity and quality, and the ability to create job cost and job estimate reports. The four cornerstones of TRI-Code are security, quality, flexibility, and performance.
Responsible for:
•Database Designing, User Interface, Coding and Report Generation and Lead team.
•Primary point to contact for customer for various business process improvements.
•Negotiated requirement and implemented solution within application functionality.
•Created Stored Procedures, triggers, views, tables and generated TSQL
•Created indexes for better performance
•Create and deploy SSIS packages
•Involved in database development using stored procedures, triggers, views and cursors.
•Maintained data integrity by performing validation checks.
•Involved in running the SQL Profiler for better execution Plans
•Participating and leading client engagement in developing plans and strategies of data management processes and IT programs for the clients, providing hands on assistance in data modeling, technical implementation of vendor products and practices
•Facilitating, guiding, and influencing the clients and teams towards right information technology architecture and becoming interface between Business leadership, Tech leadership and the delivery teams
•Leading and mentoring other IT consultants within the practice and across business units
•Supporting business development and ensuring high levels of client satisfaction during delivery
•Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
•Experienced in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs
•Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL and CDC.
•Experience in Performance Tuning and Query Optimization.
•Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
•Developed ETL scripts to enable weekly processing of 2-4 GB data sets into data warehouse.
•Optimized ETL performance to provide quickest response time possible.
•Automated and executed operational processes and procedures to ensure uptime and performance in a high-availability web-based environment.
•Experience in Data Conversion and Data Migration. Data Security, Backup & Recovery
•Excellent capability to explore, learn and understand newer business domains and technology.
•Proficient at Performance Tuning with a solid knowledge of Optimizing Code.
•Data Security, Backup-Recovery, Database Migration & Data Conversion
•Provide status reporting of team activities against the plan or schedule, inform task accomplishment, issues and status.
•Coach and help develop team members, assure that the team members have the necessary education and training to effectively participate on the team
Responsible for:
•Design and Developing of workflow procedures.
•Interacted with client to gather the requirements and implement the same in the project.
•SQL programming: Database design, stored procedures, trigger, functions.
•Created, tested, performance tuned, and implemented complex stored procedures using SQL Server 2000.
•Create DTS packages
First Class
.
First Class