Sreenath Tangellapalli
Hyderabad
Summary
Adept Service Delivery Manager with a proven track record at Health Care Service Corporation/Emblem, leveraging expertise in Oracle EBS and SQL to drive healthcare EDI solutions and operational efficiencies. Skilled in managing global teams to exceed project deliverables, demonstrating exceptional leadership and technical acumen. Achieved significant process automation, enhancing client satisfaction and team productivity.
Overview
21
21
years of professional experience
1
1
Certification
Work History
Service Delivery Manager
Health Care Service Corporation/Emblem
Hyderabad
05.2018 - Current
- Stronghold on Healthcare EDI Files, Scrubs, Rejections, Reject Analysis and the Reporting needs
- Worked in different roles such as Project/Delivery Manager, Sr
- Application Developer, Sr, Production Support lead & Oracle Developer for different clients and also provided both Technical and Functional based solutions when needed
- MANAGEMENT SKILLS
- Worked for major clients like HCSC – Health Care Service Corporation, Clear Spring Health, Emblem Health, United Health Group, ., Aetna Inc., Cisco Linksys, Schneider National Inc
- With teams located across the globe
- Managed both onsite and offshore resources for completion of projects on time and budget, : SQL Server, SSRS, Tableau, EDI
- Tools : EDM – Encounter Data Manager Application, Service Now, SVN etc
- Description:
- Health Care Service Corporation is the licensee of the Blue Cross and Blue Shield Association for five states
- It concentrates its operations in Illinois, Montana, New Mexico, Oklahoma, and Texas
- HCSC is the fifth largest health insurer in the US overall and employs more than 23,000 people
- As of 2019, it was noted to be the third largest commercial health insurer in the United States
- It serves nearly 16 million members
- Support and Maintenance – EDM – Encounter Data Manager
- Involved in daily support activities
- Involved in new developments and enhancement of existing and new SQL scripts and packages
- Involved in daily ETL activities, Scrub and Reject Analysis, Audits, Client Presentation, SLA Reporting
- Activities, Roles & Responsibilities
- Project Management
- SO creation and giving necessary approval
- Interview and Recruitment
- Complete Project Setup and Initiation
- KT Plan and provisioning the training for new associates
- Leading the Status Meetings
- Reporting to Onsite
- Assigning activates to offshore team members
- Having daily touch point calls with the team, going through and directing them through the assigned activities
- Creating SRS documents and Guiding/Supporting UAT activities
- Driving Client status meetings
- Weekly Deck preparation, to be presented to client
- Increasing Operational efficiency by driving automations
- Supporting Research activities
- Hosting and driving Team Meetings
- Onboarding new team members and monitoring/driving the KT plan
- Encouraging and embracing the team to use new digital technologies e.g
- Tableau for reporting needed.
UHC NEMIS Encounters, National Encounter Mang
08.2011 - 04.2018
- Supported healthcare data analytics.
- EDI 837 file support.
- ETL activities.
- Monitoring daily jobs.
- Development and UAT support.
- Healthcare Process Automation.
- SQL performance tuning.
- Code debugging.
- Support go-live and post-go-live activities.
- CMS submission and response reconciliation.
- Reports generation and SLA compliance.
Sr. Data Analyst/ Data Engineer
Optum Technologies – United Health Group
Phoenix
06.2010 - 07.2011
- Python, Unix, Oracle SQL & PL/SQL, SQL Server, Java Script, XML, HTML, ETL, EDI , HIPAA
- Tools : Git Hub, SQL developer, PL/SQL, Discoverer, ITG, CA Agile, TWS, Harvest, Tortoise SVN, ALM, ADR – Document Mang., SharePoint, Ipswich WS_FTP & WinSCP3, Fortify, ECG, Dashboard, Oracle Service Catalogue, ServiceNow
- Description:
- United Health Group Incorporated is a diversified managed health care company headquartered in Minnesota, USA
- United Health Group offers a spectrum of products and services through two operating businesses: United Healthcare and Optum
- Through its family of subsidiaries and divisions, United Health Group serves approximately 70 million individuals nationwide
- Support and Maintenance – FACETS and NEMIS (Integrated application)
- Involved in daily support activities
- Involved in new developments and enhancement of existing reports, forms & SQL/PL-SQL scripts and packages
- Involved in daily ETL activities and BI reporting
- NEMIS – It's an in-house application developed from the scratch by the United Health Care (Currently Optum Tech
- An IT wing of UHG)
- It's complex integrated health care claim processing system, which supports & handles Medicare and Medicaid business of 32 states all over the United States, meeting their regulatory requirements, there by growing UHC – Community and State plan, exponentially over the period since inception
- FACETS is a Healthcare adjudication system, which run on SQL server
- I have in-depth understanding of the tables, and the queries
- It is the upstream source system, where the data is extracted on a daily, weekly, bi-weekly and monthly basis and loaded into the NEMIS system for further processing
- Daily Activities, Roles & Responsibilities
- Worked on Development and enhancement of existing DB objects - Packages, Procedures, Triggers, Tables, Views, Sequences, Synonyms, Indexes
- Identifying the Full Table scans during any performance issue, and proposing or creating new indexes on the columns, where the indexes are needed
- Creating Partitions on the tables
- Worked on multiple Data Interfaces, both Inbound and Outbound
- Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc
- Create functions to provide custom functionality as per the requirements
- Be aware of potential blocking, deadlocking and write code to avoid those situations
- Identify the blocking session, and killing them based on the urgency to let the other job run
- Killing the sessions based on the priority and the severity of the job
- Running Analyze and Gather stats, for the tables, where there is a frequent update of data on the tables, including both Stage and Base tables
- Update the data on multiple tables, making sure the data integrity is maintained across the child and parent tables
- Did innumerable updates on the Production DB and was able to show high sensitivity towards the live data
- Handled thousands and millions of Dollars ($) worth of data transactions on a daily basis
- Worked on customizing the seeded and custom reports included SQL & PL/SQL reports
- Working on 100's of tickets on the weekly and Bi-Weekly basis, meeting their deadlines and the defined SLA's and running the reconciliation process on top them for the Business validations
- Part of the architecture team, analyzing the current process and proposing new changes on a Bi-Weekly basis
- Attending Daily Stand-up Calls and Staff meetings on the Weekly basis
- Active member of the Staff meeting, and proposed new changes and bringing up the pain points in the current process or the day-to-day activities
- Hosting daily stand-up call, and taking the updates both from On-site and Offshore team members
- Monitoring the Job Abends, identifying the issues, fixing them and resuming the jobs through TWS – Work scheduled
- Monitoring the data audits and making sure that the audits are not deviated
- Being the SME of the current process, I Handle multiple requests from the BA be it either questions or clarifications
- I had to perform necessary analysis and get back with the solutions and the answers
- Attending Project Kickoff, Project Transition, Go-Live, Production verification meetings and raising concerns or corrections if any
- Worked on Data Streamline process, which I developed from the scratch and improvised it over the period
- It is a process, which works on the configurations done for every single plan (Individual State requirements), loads the data from the .CSV files, run the updates and business logic, run the validations, bypasses the claims, which do not meet the state requirements, and finally sets the claims for generation – for HIPAA 837 outbound extracts
- Generating 837 Outbound extracts, running the files through Internal Edifices for data validations and finding their respective errors, before sending it to the state
- Loading Vendor Files - Following through the vendors, if the files do no arrive on time or if there are any data corrections on the files to be reported
- Getting the files fixed and loading them
- Worked on the Tech only Packages, Break fixes and Worked Orders
- Going through the requirement documents or the BRD's, setup the calls with the business and raise & following up through the clarifications
- AGILE - Creating User Stories, Tasks and updating their status as and when there is progress
- Setting up new Job definitions and the Job streams, and fixing their schedules and dependencies in the TWS (Tivoli Work Scheduler)
- Migrating the jobs from the DEV to PROD, and verifying them
- Extensively involved in ETL activities on a daily basis
- Pulling the data/Extracting the data by connecting to the external systems, creating huge data files in the currently system, run the files through the data validations process – Loading them in Raw tables, moving them to Interface and then finally moving them to Seeded or the Base tables
- Created Temporary tables and the Loader files (.CTL) files for loading the huge data files, provided by the business, based on the need and availability and for the temporary and permanent data updates
- Debugging the code, and identifying the error and fixing the data
- Backing out the data, if the wrong data has been loaded, or if the business requests to back out the data
- Working on writing Queries, finding the data, running the data corrections and updates based on the instructions given by the Business team
- Running the updated data through validations, and if they are valid then generating the outbound extracts
- Worked on .XML configuration files and made the changes and enhancements
- Configuring the data validation setups in the DB configuration tables, for easy and flexible code maintenance
- Identifying the performance issues during the data load or the generation’s process, killing the SID - session through “Oracle Service Catalogue”, tuning the code/query (or) running the stats, and finally resuming the job and following up through it until completion
- Leading the offshore and making sure all the deliverables are delivered on time
- Hosting SRS walk through and leading the discussion with the Business team to solve the ongoing issues and process based bottlenecks
- Increased the productivity and accuracy of the current process; regularly interacting with the client’s, for the betterment of the existing process
- Monitoring the audits
- Analyzing and fixing the data, when there is an Audit controls deviation
- Managing on-site and offshore team members, including project management
- Lead the Agile team, as a Scrum Master
- Taking the updates and sharing the tasks, among the team folks
- Have been a part of Kanban team as well
- Prioritizing and completing the task, as per the business deadlines
- Worked on Design documents, Tech Spec, Mini Tech Spec and Detail Design
- Uploading all the required documents into ADR (Document Mang.) and the scripts into Harvest/SVN and follow through the approvals
- Active participant of the Deployment team
- Supporting and deploying of the scripts and verifying the deployments
- Worked on Research tickets, provided work around, and solutions
- Loading huge PHI (Protected Health Information) files e.g
- Claim and Provider files, processing them and generating the reports for the Business on a Weekly and Bi-Weekly basis
- Providing the estimates for the Projects, Work Orders and Break Fixes
- Preparing the scripts, updating the code with the changes and the enhancements, preparing the data in DEV instance and carrying out Unit Testing, preparing Test Case, Test Summary Report, Test Case Snapshot, Mapping, Deployment and SVN Tag documents
- Deployment verification and support activities
- Supporting UAT and setting up the data in the respective instance
- Supporting Pre-Deployment, Deployment and Post Deployment Activities
- Holding process and domain based training sessions with the clients
- (Oracle e-business 11i) - 11.5.10 Upgrade
R12 Implementation, Schneider National Inc
Chennai
02.2009 - 05.2010
- Oracle APPS R12 (GL
Developer
Schneider National, Linksys- Cisco Inc
Pune
04.2008 - 02.2009
- Is a provider of truckload, intermodal and logistics services
- Schneider’s solutions include Regional, Long Haul, Expedited, Dedicated, Bulk, Intermodal, Brokerage, Cross-Dock Logistics, Supply Chain Management and Port Logistics
- Schneider is head quartered in Green Bay, Wisconsin
- Schneider is one of the largest truckload carriers in North America, hauling 16,275 loads per day, with 11,300 company drivers, 9,600 company trucks and 31,000 trailers on the road
- The company conducts business worldwide with 168 facilities, including a presence in the United States, Canada, Mexico and China
- Schneider’s customers include more than two-thirds of the FORTUNE 500 companies
- Implementation and Support Activities - Implementation of R12 version of Oracle Applications EBS Schneider National Inc.)
- Tasks, Roles & Responsibility
- Worked on Reports both D2k and SQL & PL/SQL reports
- Worked on Outbound Interfaces
- Generated Flat files
- Worked on extensive SQL
- Loader files (Control Files)
- As a Technical Consultant, I was involved in all phases of project including post production support activities of all the modules
- Involved in gathering requirements from business users, preparing design documents for interfaces, data conversions for suppliers and Purchase orders, coordination with offshore team during development and unit testing
- Responsible for preparing test cases, functional testing of interfaces, attending client meeting etc…
- Participated in CRP, UAT, Go live activities had extensive business user interaction during each phase of implementation
- Worked on RICE components
- Hands on experience on BPEL
- Oracle 11.5.10.2 Version of EBS Implementation, : Oracle APPS 11.5.10.2 (GL, INV, AR, OM), Oracle 11, Linksys is an American company selling data networking hardware products mainly to home users and small businesses
- Its products include wired and wireless routers, Ethernet switches, VoIP equipment, wireless Internet video cameras, audiovisual products and network storage systems.
CERBIOS Pharma
Hyderabad
07.2004 - 03.2008
- Oracle APPS (Receivables, Service contracts), Cerbios Pharma is a Swiss based manufacturing company and 90% of its products are sold in the US
- It implemented Oracle Applications earlier and this was an upgrade from 11.5.9 to 11.5.10.2 Version of Oracle EBS
- Roles & Responsibility
- I was responsible for gathering requirements from business, coordinate with cross functional team, prepare detailed technical design document required for conversion, coordinating with offshore team during design and development
- Responsible for coordinating with multiple IT teams to planning and conducting CRP1, CRP2, UAT, provide status report to stakeholders periodically, managing the timelines in terms of deliverables
- Worked on customizations, reports, data migration, interfaces, new form development related to OM, AR modules
- Developed concurrent programs for reports, data conversion and interface programs, developed new form extension using Template.fmb
Aetna Inc
Orlando
- Oracle EBS (O2C, P2P and SCM modules, including custom applications)
- Tools :, Aetna is one of the nation's leading diversified health care benefits companies, serving approximately 37.2 million people with information and resources to help them make better informed decisions about their health care
- Aetna offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioural health, group life, long-term care and disability plans, and medical management capabilities
- Aetna customers include employer groups, individuals, college students, part-time and hourly workers, health plans and government-sponsored plans
- Involved in Upgrade and Post Go-Live support activities
- Worked on new developments and enhancements of existing objects
- Tasks, Roles & Responsibility
- Worked on Development and enhancement of existing DB objects - Packages, Procedures, Triggers, Tables, Views, Sequences, Synonyms, Indexes
- Involved in ETL activities
- Involved in major enhancements
- Development and Customization of existing RDF, SQL & PL/SQL Reports, Custom Packages and Forms
- Gap Analysis between 11.5.9 to 11.5.10 Oracle Applications EBS
- Raising Service Requests in Oracle Metalink and following through the issues
- Any scripts or the patches provided by the Oracle, where deployed
- Testing of new developments and customizations
- Preparation of MD50, MD120 and TE20
- Working on Change Request
- Analyzing all the DB objects and identifying the impacts on them due to upgrade
- Identifying the custom objects, which are impacted due to upgraded API’s
- Identifying the impacted .Pll’s and .Pls files and replacing them
- Worked on Zoom functionality and the Custom.pll
- Worked on developing Forms from the scratch using the Template.fmb
- Worked on Personalization of Forms
- Responsible for conducting SIT,UAT and post production support for multiple projects
- Production support enhancements, responsible for transitioning to new members of the team
Cisco Inc
- Now acquired by Belkin International, Inc.
- Acquired Linksys then
- After the acquisition, they decided to implement Oracle EBS modules like AR, AP and OM
- Project involved creating of new interfaces and RDF & SQL reports
- Task, Roles & Responsibility
- Form creation, compilation and registration
- Worked on Break fixes
- Alliance Cases
- Customization of existing seeded reports
- Preparing Detail technical design document
- Responsible for managing the entire releases which includes managing the timelines, resources, providing status updates to stakeholders, coordinating with offshore development team, conducting SIT, UAT and also worked on post implementation support, transitioning to support team
- Developed Excel format reports, generating them on running the Concurrent Programs and Sets
- Worked on Discoverer and XML Publisher reports
- Worked on Alliance Cases – Incident Management System
- Developed and Customized Master Detail forms
- Code Enhancements
- Worked on Interfaces.
Education
Mater of Computer Applications -
06.2004
Skills
- National Encounter Management Information Systems (NEMIS)
- Compass Application
- FACETS
- EDM
- CDM
- Oracle EBS Business ERP Applications
- Accounts Payables (AP)
- Account Receivables (AR)
- General Ledger (GL)
- Order Management (OM)
- Inventory (INV)
- Sun Solaris
- Windows 7
- Windows 2008
- Windows 2000
- Windows NT
- Windows 98
- Unix
- SQL
- PL-SQL
- SQL Server
- SSRS
- SSIS
- NET
- Developer 2000
- Oracle Workflow
- Oracle XML publisher
- Oracle Discoverer Reports 10g
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle EBS Suite
- Oracle SQL
- Oracle API's
- Python
- Java
- XML
- Java Script
- Health Care
- Manufacturing
- Logistics Industries
- TOAD
- SQL Developer
- XML Publisher
- Tableau Reporting
- Ultra Edit
- Beyond Compare
- SnagIt 11
- PVCS
- Harvest
- TortoiseSVN
- Kintana
- HP Project and Portfolio Management Software
- Tivoli Work Scheduler
- HPSM
- Service Request
- Team Track Management System
- ITG
- ECG Dashboard
- CA Agile Central
- Live Link
- SharePoint
- ADR
- HP ALM
- Mercury Quality Center
- Test Director
- HPE Security Fortify SCA
- Enterprise Service Catalog Suite
- Putty
- Ipswich WS_FTP
- WinSCP3
- Microsoft Project
- MS Office
- Visio
- SQL databases
- Query languages
- Structured query language (SQL)
- Data mapping
- Database management
- HIPAA
Certification
Oracle Certified Associate
Technicalskills - Applicationtechnicalknowledgeareas
National Encounter Management Information Systems (NEMIS), Compass Application, FACETS, EDM, CDM, Sun Solaris, Windows7/2008/2000/NT/98, Unix, SQL/PL-SQL, SQL Server, SSRS, SSIS, .NET, Oracle Workflow, Oracle XML publisher, Oracle Discoverer Reports 10g, Oracle 12c, 11g, 10g, 9i, Oracle EBS Suite (R12, 11.5.10.2 and earlier versions), Oracle SQL & PL/SQL, Oracle API's, Python, Java, XML, Java Script, Health Care, Manufacturing, Logistics Industries, TOAD, SQL & PL/SQL Developer, XML Publisher, Tableau Reporting, Text Editors - Ultra Edit, Beyond Compare & SnagIt 11, Version Control - PVCS, Harvest & TortoiseSVN, Migration Tools - Kintana, HP Project and Portfolio Mang. Software, Automation Job Scheduler - Tivoli Work Scheduler(TWS), Incident Management - HPSM, Service Request and Team Track Mang. System., Release Services – ITG, ECG Dashboard – File moving and Tracking System, CA Agile Central (Formerly Rally), Document Management – Live Link, SharePoint & ADR, Application Life Cycle Mang. – HP ALM, Mercury Quality Center & Test Director, Code Verification & Bugs finding Tool - HPE Security Fortify SCA, Others: Enterprise Service Catalog Suite, Putty (SSH), Unix Box – Ipswich WS_FTP 12.5.1 Professional, WinSCP3, Microsoft project, MS office, Visio
Managementskills
HCSC – Health Care Service Corporation, Clear Spring Health, Emblem Health, United Health Group, Aetna Inc., Cisco Linksys, Schneider National Inc., 7, 8, 10, Effective client management, Communication, Presentation, Facilitation, SDLC project management, User Acceptance Test planning and execution, Agile methodologies
Timeline
Service Delivery Manager
Health Care Service Corporation/Emblem
05.2018 - Current
UHC NEMIS Encounters, National Encounter Mang
08.2011 - 04.2018
Sr. Data Analyst/ Data Engineer
Optum Technologies – United Health Group
06.2010 - 07.2011
R12 Implementation, Schneider National Inc
02.2009 - 05.2010
Developer
Schneider National, Linksys- Cisco Inc
04.2008 - 02.2009
CERBIOS Pharma
07.2004 - 03.2008
Aetna Inc
Cisco Inc