Ranjithbabu Sounderrajan

*

Ranjithbabu Sounderrajan

Email :mailto:ad438y@r.postjobfree.com : Cell : 407-***-**** Sr. Database developer –Projects with Cognizant, accomplished IT Professional

- Currently in Healthcare – PBM Domain

CAREER SUMMARY

• 15+ years of experience as Database developer in analysis, development, and testing of business application such as OLTP, OLAP, Enterprise,Web based, client/server, SOA architectures

• Extensive knowledge and working experience in Oracle PL/SQL, PosrgreSQL pl/pgsql and Microsoft T-SQL

• Experience in cloud migration from On-prem oracle DB to Azure Postgres flexible server

• Good domain knowledge in pharmacy benefit management and finance areas

• Involved with data modeling team to create logical/physical data model using ERWIN

• Involved in source system analysis and data extractions from various platforms

• Extensive experience developing external tables and using oracle utility tools like SQL Loader, Import and Export on UNIX platforms

• Experience in web based applications using Oracle APEX HTML-DB, ASP and HTML

• Highly proficient in developing and understanding complex stored procedures and functions in PLSQL coding

• Experience in building schemas, managing DB objects (tables, views, Materialized views, Indexes, triggers, Scheduled Jobs), partitioning large volume tables, Using Hints in queries to improve performance of complex SQLs, SQL tuning, troubleshooting, debugging and fixing the codes/scripts mid-range applications to Oracle applications using ETL, XML, and web services, PL/SQL, SQL Loader, FTP and UTL Files.

• Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, and SQLTRACE. .

• Good experience with the usage of Bulk Insert, Nested tables, External tables, advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors.

• Experience in working Azure PostgreSQL managed instance

• Experience in using Java classes in oracle plsql for file operations

• Experience in running Batch Jobs in Multithreading

• Experience in using REST API call from Oracle PLSQL code using UTL_HTTP methods

• Proficient on Core Java concepts, SPRING BOOT for building microservices, XML, HTML,CSS and JSON

• Worked as SCRUM Master and had extensive knowledge in Agile Methodologies, such as SCRUM

• Experienced with Full Project life cycle and well versed with scrum, Agile and standard SDLC methodologies.

• Extensive Experience on explaining technical concepts and adjust messaging based on the audience, including non-technical groups

• Participated in Requirements gathering, preparing Business Specification Documents, Functional Specification Documents, Data Mapping Sheets, Design Reviews and Test Cases for modules.

Ranjithbabu Sounderrajan

2

HIGHLIGHTS

Areas of Expertise

• Advanced PLSQL programming SQL Tuning/Query Reporting/ Performance Tuning

• Iteration/Sprint Planning Meetings Agile Principals/Tasking Meetings/Retrospectives

• Agile methodologies Story-Based development

• Data Migration and Data Mapping Data validation

• Data Migration and Data Integration Cleansing/data scrubbing

• Data profiling and gap analysis Story-Based Development

• D.0 Claim Processing HIPAA D.0 Implementation

• HIPAA 5010 Implementation ICD 10 Implementation

REFERRALS, AWARDS AND APPRECIATIONS

• Available on LinkedIn, or upon request

• Awarded ESI Star 2010

• Awarded the Above & Beyond award for Q1

2010

• Received appreciations by clients in

multiple projects.

CERTIFICATIONS

• Completed Pharmacy benefit

management(PBM) Training and cognizant

Internal Certification

• Completed AHM 250 Training and cognizant

Internal Certification

• Oracle Certified Associate

AZ-900, Azure DP-900, Azure AZ-303 and 304

Solution architect design

• Certifed Yugabyte DB associate

Ranjithbabu Sounderrajan

3

EDUCATION

M.Sc. (Computer Science), Vellore Inst. of Technology- Vellore-TN-India (2003) B.Sc. (Mathematics), Madras University (2001) - Vellore-TN- India (2001) EXPERIENCE HISTORY:

Name of the Company Client From To Duration Onshore/Off shore

CVS Health -Richardson, TX- Sr. Oracle

developer

CVS Health Sep-2019 Till Now 4 Years,3

months

Onshore

Cognizant Technology Solutions- U.S

Corp – Client – CVS Health- Sr. Oracle

developer

CVS Health Feb- 2011 Sep-2019 8 Years, 7

Months

Onshore

Cognizant Technology Solutions- U.S

Corp - Sr. Oracle developer

Express

Script

Jul - 2009 Feb-2011 10 years Onshore

Cognizant Technology Solutions -

Chennai -India- Associate- Projects

Express

Script

Feb -2007 Jul-2009 2.5 Years Offshore

Allsec Technologies India Ltd–

,Chennai-13 – Sr Application developer

Sep -

2005

Jan-2007 1.4 Years Offshore

Golden InfoTech Pvt Ltd, Taylor’s Road

Chennai-10- Programmer

May -

2003

Aug-

2005

2.4 Years Offshore

PROFESSIONAL EXPERIENCE

Client: CVS Health, U.S.A, Richardson, TX Onshore Feb 2011 - Till Now Client Overview: CVS Health Corporation is an integrated pharmacy services provider, combining a United States pharmaceutical services company with a U.S. pharmacy chain. The Experienced Leader in Specialty pharmacy industry

Role: Sr Oracle Programmer

Responsibilities /Accomplishments

• Develop APEX based web applications to assist customer in daily processing. Enhance and applications with new required functionality and correct errors in the applications when required. Develop and enhance Javascript in APEX applications using either java script files or dynamic actions in APEX pages.

• Added Javascript functionality to existing application pages and where possible using dynamic actions in APEX.

• Added Javascript/Jquery functionality to pages and reports where possible.

• Created a user interface screen using APEX and Data explorer to expose data retrieved from enterprise data

• Developed, debugged, and optimized SQL queries for reporting and app development Ranjithbabu Sounderrajan

4

• Promoting clean code and consist design patterns across the team and writing SQL procedures in Toad,SQL developer, and Oracle Application Express(APEX)

• Worked multiple joins like cross join, left outer join, right outer join, inner join between two or more tables.

• Implemented Single sign on feature for Oracle based legacy application using Azure Intra ID

• Created Row security policies on Tables to ensure data security while inserting, deleting, and selecting using data modification commands.

• Created Users, User Attributes, Privileges, Groups, Roles, Schemas and worked on setting search paths to schemas.

• Created, inserted, and extracted data from multi-dimensional arrays and composite types

• Created Procedures/Functions to execute arbitrary SQL statements (Dynamic SQL) without result set/with input parameters/result set

• With clause (Common Table Expressions) is used for auxiliary/recursive statements in large queries

• Transaction control is implemented through PL procedures using commit/rollback

• Handled exceptional conditions and warnings in plsql objects, Information is executed using SQLCODE and SQLERRM

• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.

• Implement REST/SOAP(JSON/WSDL/XML)Webservice calls from Oracle PLSQL code to integrate /transfer data from Legacy applications to Angular JS applications

• Worked on Complex Business rules in Oracle Packages and Procedures using advanced Oracle PLSQL concepts (Collections, User Defined Record type, Types, Dynamic SQLs, UTIL and UTL_HTTP package usage, Send and Receive JSON Request to API and Regular Expressions).

• Review migration assessment report and worked on the necessary manual fix that required to complete the migration

• Unit tested the mappings by running SQL queries and comparing the data in source and target databases

• Worked Onprem Oracle 12c to 19c migration and Oracle 19c to Azure Postgres DB migration in different time frame

Data Migration projects experience

Roles/Responsibilities

• Worked on complex business logics in Oracle Packages and procedures to migrate Specialty pharmacy patients’ and prescriptions from the stage tables to the Target tables.

• Coordinated with various teams and executed Data migration process using Informatica tool in production and always ensured to complete the migration within the Migration window.

• Worked on Pre and Post migration reports using complex SQL queries and analytical functions

• Worked on various data fix scripts and executed them after post migration whenever Business found any data discrepancies on the results. Worked as Scrum Master for the following Health care compliance, regularity projects and other projects.

• HIPAA 5.1 to D.0 Implementation (Worked in Agile software model) Ranjithbabu Sounderrajan

5

• HIPAA 4010 to 5010 Implementation

• Auto enrollment for patients from multiple pharmacy sites

• Clinical program enrollment enhancement

• ICD10 implementation

• Integration of CVS Retail pharmacies to CVS specialty pharmacies for ease access to the specialty drug dispense

• Data migration from CVS one Specialty application to other specialty application

•

Technologies: Oracle PLSQL, Oracle APEX application Builder, Azure PostgresSQL,Oracle 19c, Toad 12.11.0, XML, Java API service, REST/SOAP UI5.0 JSON,TortoiseSVN

(Subversion), Informatica PowerCenter, Forms and Reports 12g, XML, UNIX and Tivoli Client: Express Scripts, U.S.A Orlando, FL July 2009 - Feb 2011 Client Summary: CuraScript, Inc. is a wholly owned subsidiary of Express Scripts, Inc., one of the nation’s largest Pharmacy Benefit Managers (PBMs). As an experienced leader in the specialty pharmacy industry and specializes in providing specialty medications and support to individuals with chronic illnesses requiring these complex, high-cost therapies. Role: Oracle Consultant/Scrum Master

Responsibilities /Accomplishments:

• Project delivery under stringent timelines and high pressure.

• Conduct Sprint planning meeting, Daily stand up meeting, Sprint Estimation Meeting, Sprint Retrospective and other Project related meetings

• Conduct meeting with Product owners and BAs to prioritize the User Stories in Product Backlog.

• Responsible for closely coordinate with the Product Owners and Release Management team to manage the release schedule and decides when the product is ready to ship.

• Responsible for committing the work based on the team’s band width and deliver the final product on time.

• Developed an Agile team assessment instrument to measure and track the team’s adoption of agile principles.

• Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings

• Taught the team to create clear and concise epics/stories

• Facilitated Scrum of Scrum for offshore teams in India.

• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility ensured consistent application of scrum methodologies across the enterprise

• Assisted team with making appropriate commitments through story selection, sizing and task definition and participated proactively in developing and maintaining team standards, tools and best practices reducing development time by 35%

• Responsible for Consulting with other application team (Java and MS Access) for integrating Centura and Java technologies.

• Designed and developed the product in Centura and integrated to framework components in Java using Java Swing and the Spring Framework.

• Finetune the SQL performances, Writing complex business logic in Oracle DB

• Responsible for creating a detailed ADD(Application design document) for assigned projects

Ranjithbabu Sounderrajan

6

• Designed/developed tables, views, various SQL queries, stored procedures, functions and Packages to implement the business logic using PL/SQL.

• Responsible for creating Oracle Package and procedures based on specific project requirements

• Worked on various data fix scripts and executed them after post migration whenever Business found any data discrepancies on the results. Technology: Oracle 11G, PL/SQL, Centura Team developer 1.2, Wincvs, Java and web service, Oracle Fusion Middleware, Web Logic Server, Forms (11g), Reports, PL/SQL, SQL, DB2, UNIX Shell scripting, clear Case, Harvest.

Client: Express Scripts, U.S.A Chennai, India Feb 2007- Jul 2009 Role: Oracle Consultant/ Technical Lead - Chennai -India Feb 2007 - Jul 2009 Responsibilities/Accomplishments:

• Developing of Oracle Forms and Reports to include: interacting with stored procedures, packages, triggers, and materialized views; experience with effective debugging; and performance tuning

• Fine tuning Oracle database tables and queries as and when required and tuning SQLs using Analytical Functions.

• Solved several show-stopping performance issues to ensure that we could migrate within very tight timescales.

• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace reports.

• Create and execute test plans, to include unit and peer testing, for standard and client- specific benefits requirements

• Developed UNIX jobs with the help of Oracle Advance Queue and Scheduler

• Perform impact analyzes of changes

• Perform knowledge transfer in the areas of Oracle SQL and PL/SQL programming, Oracle Developer suite (Forms and Reports).

• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.

Technology: Centura Team Developer 1.5/ Centura Gupta SQL/Oracle SQL and Pl/SQL and Java and Java web service

Allsec Technologies India Pvt. Ltd. – Chennai

URL: https://www.allsectech.com

Role : Sr. Software Engineer Sep 2005 – Jan 2007

Roles & Responsibilities:

• Led a team of 8, reported to the Project Manager and responsible for Design, Development and Testing including Analysis and Understanding of the Customer’s Requirement.

• Played a very important role to develop a accounting software for Allsec’s prestigious overseas contract from Singapore.

• Have worked on SQL server store procedures and SQL scripting for certain payroll functions.

Ranjithbabu Sounderrajan

7

• Responsible for Writing PL/SQL blocks (Packages, Procedures and Functions), test cases Payroll application requirements.

• Coding & Unit testing for payroll modules and executing the Programs & generating the test results.

• Responsible for Conducting Code review meeting

• Responsible for attending Defect prevention meeting, Release planning meeting and project requirement meeting and actively contributed to all the project needs Technology: VB6.0, Oracle 9i, Crystal Reports, Toad 9.0, FarPoint (Spread 3.1), VSS and Microsoft SQL server Management Studio.

Golden InfoTech Pvt. Ltd. – Chennai May 2003 – Sep 2005 Role: Software Programmer

Roles & Responsibilities

• Worked as a Programmer and responsible for Design & Coding in Visual Basic 6.0 and Oracle Pl/Sql and preparation of Unit Test Case and test results.

• Design and development in VB6.0, Oracle 9.0 and Crystal Reports

• Reported to Project Lead

REFERENCES ARE AVAILABLE UPON REQUEST

Contact this candidate