| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateRanjithbabu Sounderrajan1Ranjithbabu SounderrajanEmail :mailto:EMAIL AVAILABLE : Cell : PHONE NUMBER AVAILABLE Sr. Database developer Projects with Cognizant, accomplished IT Professional- Currently in Healthcare PBM DomainCAREER 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 Sounderrajan2HIGHLIGHTSAreas 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 ImplementationREFERRALS, AWARDS AND APPRECIATIONS Available on LinkedIn, or upon request Awarded ESI Star 2010 Awarded the Above & Beyond award for Q12010 Received appreciations by clients inmultiple projects.CERTIFICATIONS Completed Pharmacy benefitmanagement(PBM) Training and cognizantInternal Certification Completed AHM 250 Training and cognizantInternal Certification Oracle Certified AssociateAZ-900, Azure DP-900, Azure AZ-303 and 304Solution architect design Certifed Yugabyte DB associateRanjithbabu Sounderrajan3EDUCATIONM.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 shoreCVS Health -Richardson, TX- Sr. OracledeveloperCVS Health Sep-2019 Till Now 4 Years,3monthsOnshoreCognizant Technology Solutions- U.SCorp Client CVS Health- Sr. OracledeveloperCVS Health Feb- 2011 Sep-2019 8 Years, 7MonthsOnshoreCognizant Technology Solutions- U.SCorp - Sr. Oracle developerExpressScriptJul - 2009 Feb-2011 10 years OnshoreCognizant Technology Solutions -Chennai -India- Associate- ProjectsExpressScriptFeb -2007 Jul-2009 2.5 Years OffshoreAllsec Technologies India Ltd,Chennai-13 Sr Application developerSep -2005Jan-2007 1.4 Years OffshoreGolden InfoTech Pvt Ltd, Taylors RoadChennai-10- ProgrammerMay -2003Aug-20052.4 Years OffshorePROFESSIONAL EXPERIENCEClient: 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 industryRole: Sr Oracle ProgrammerResponsibilities /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 Sounderrajan4 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 frameData Migration projects experienceRoles/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 Sounderrajan5 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 applicationTechnologies: 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 nations 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 MasterResponsibilities /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 teams band width and deliver the final product on time. Developed an Agile team assessment instrument to measure and track the teams 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 projectsRanjithbabu Sounderrajan6 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 serviceAllsec Technologies India Pvt. Ltd. ChennaiURL: https://www.allsectech.comRole : Sr. Software Engineer Sep 2005 Jan 2007Roles & Responsibilities: Led a team of 8, reported to the Project Manager and responsible for Design, Development and Testing including Analysis and Understanding of the Customers Requirement. Played a very important role to develop a accounting software for Allsecs prestigious overseas contract from Singapore. Have worked on SQL server store procedures and SQL scripting for certain payroll functions.Ranjithbabu Sounderrajan7 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 ProgrammerRoles & 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 LeadREFERENCES ARE AVAILABLE UPON REQUEST |
