Resume

Sign in

Manager Developer

Location:
Plano, Texas, United States
Posted:
June 25, 2019

Contact this candidate

Resume:

CV - RANJITHBABU SOUNDERRAJAN

TIMELINE SUMMARY

SSLC HSLC BSC MSC (CS)

199*-****-**** 199*-****-**** 200*-****-**** 2003

200*-****-**** 200*-****-**** 200*-****-**** 2009 2010 Till now Programmer Sr.Programmer Sr. Associate Manager - Projects Golden InfoTech Allsec tech solutions Cognizant tech solutions Cognizant tech solutions

(India) (India) (India) (U.S)

EXPERIENCE / COMPETENCY

PROFESSIONAL SYNOPSIS

2.4

1.4

2.5

9.6

0

2

4

6

8

10

12

2003-2005 GOLDEN INFOTECH PVT LTD

(INDIA)

2005-2007 ALLSEC TECHNOLOGY

SOLUTIONS

(INDIA)

2007-2009 COGNIZANT TECHNOLOGY

SOLUTIONS

(INDIA)

2009-TILL NOW COGNIZANT TECHNOLOGY

SOLUTIONS

UNITES STATES OF AMERICA)

WORKED YEARS

16 Years of experience ...

ac9oun@r.postjobfree.com

ranjithbabu2003

+1-407******

ranjithbabu-sounderrajan-0758521a

+1-407******

CAREER OBJECTIVE: One Day I will be in a Position and at a Place where I always wanted to be. Currently looking for the Place and Position to make my Success with the mutual growth and happiness for me and opportunity given achiever.

EDUCATION

EXPERIENCE

PROFESSIONAL EXPERTISE IN:

16 years of experience in IT Application development and support projects.

Currently working as Sr Technical Lead in Specialty pharmacy Projects at client place

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 working Experience in Oracle e-Business Suite Application (ERP) to automate client’ business processes under Finance and Supply Chain Management (SCM).

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

Worked on enterprise level projects using Java Eclipse tool and web logic server

Extensive Experience on design and architect the projects

Extensive Experience on creating ER diagrams/Logical/Physical data flow diagrams/Sequence diagrams

Extensive experience in Advanced Oracle PLSQL Programming Skills.

Expertise in Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle Applications ERP technology, Oracle Fusion Middleware, Oracle Web Logic Server, UNIX Shell

Involved in developing various inbound and outbound interfaces to integrate legacy systems, mid-range applications to Oracle applications using ETL, XML, and web services, PL/SQL, SQL Loader, FTP and UTL Files.

Expertise in Oracle Data Modeling, Performance Tuning, Exception Handling and PLSQL Collections.

Experience in using Analytic Functions, Hierarchical Queries, Materialized Views, External Tables, Collections, Oracle Supplied Packages

Experience in loading Data from External Files to Oracle Database using SQL Loader

Experience in Oracle Scheduling Jobs.

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

Strong working experience in implementing REST/SOAP API calls (JSON/WSDL/XML) in Oracle PLSQL code.

Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects and Bulk Binds).

Good Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer, TOAD. Sql * Plus, Oracle Enterprise Manager (OEM)

Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL. Proficient in writing and tuning complex SQL statements.

Extensively worked on changing the reports per client requirements and Optimizing the Report Performance.

Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.

Analyzed data, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.

Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters, and Program units by using PL/SQL procedures and functions of OOPS methodology

Experience in Data Warehousing Concepts like Star Schema, Snowflake Schema Methodologies.

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

Strong knowledge on Data Extraction using Informatica as ETL tool.

Have extensive end to end work experience on Data Migration Projects

Hands-on experience with source control tools like Visual Source Safe (VSS), Wincvs, PVCS and TortoiseSVN LANGUAGE PROFICIENCIES INTERNATIONAL EXPERIENCE

HIGHLIGHTS

Areas of Expertise

Oracle Sql and 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

TECHNICAL SKILLS

ORACLE 12C, ORACLE PLSQL, Advanced SQL/PLSQL Programming, Toad 12.11, SQL Developer, Oracle Forms and Reports builder, Oracle e-Business Suite Application (ERP), Oracle APEX 18.2, SQL Navigator, SQL*Loader, Crystal reports

Visual Source Safe (VSS), Wincvs, PVCS and TortoiseSVN

Informatica

Visual basic 6.0,Visual Source, .NET Framework 4.5, Gupta centura Team developer, Synergy/DE, ISAM Files, UNIX, Shell scripting, Cora Java, Java Development Kit (JDK), Eclipse Java, Node JS EDUCATION

M.Sc. (Computer Science), Vellore Inst. of Technology- Vellore-TN-India (2003) B.Sc. (Mathematics), Madras University (2001) - Vellore-TN- India (2001) 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. Awards &

Appreciation_Updated_2019.pdf

CERTIFICATIONS

Completed Pharmacy benefit management(PBM) Training and cognizant Internal Certification

Completed AHM 250 Training and cognizant Internal Certification

Oracle Certified Associate

PROJECT MANAGEMENT EXPERIENCE

Extensive knowledge on Preparing T & M timesheet report for billable project teams

Extensive knowledge on Preparing Proof of documents(PODs) for SOWs and send it to Client IT Manager for approval

Extensive knowledge on Preparing account’s T & E sheet for expense reimbursement and send it to IT Manager at Client side for approval

Experienced/Involved on coordinating with offshore account manager to raise the invoice for the monthly fiscal periods

Experienced on coordinating with client’s admin team to send “On boarding” request and forward the details to offshore manager to setup the project allocation in cognizant ESA portal

Experienced on arranging project status meeting with account leads on every week and walkthrough the projects status

Experienced on identifying any new business opportunities and help account leads to create new business proposals

Experienced on closing allocations and raising release requests to work force management team and updating tracker sheets

Experienced on arranging/coordinating fun & event activities on every annual team get together

Responsible for coordinating with account team leads and ensure their completion of client and Cognizant’s mandatory training courses.

My level of

language

proficiency

Language Read Write Speak

English 100% 100% Fluently

Tamil 100% 100% Fluently

EMPLOYMENT HISTORY

Cognizant Technology solutions

Client: Client: CVS Health,Richardson,TX Feb 2011 – Till Now Health care /PBM- Specialty

Sr.Oracle Consultant/SME/Technical Lead

Working as Tech Lead/Subject Matter Expert(SME)/ for PBM Specialty projects

Responsible for creating Entity Relationship diagrams/Dimensional Diagrams for business requirements.

Responsible for creating Beg Estimates /LOE for dev efforts and get it review with PMO team

Resource planning and defining dev Tasks schedules as per Priorities

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

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

Provide day to day guidance on project issues, and help the team in completing the assigned work on schedule. Prioritize activities to be performed.

Deliver 100% adherence to Request/Incident/Defect SLAs by following high quality coding standards and performing reviews.

Use of SOAP UI/POSTMAN for sanity testing after each API development.

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).

Responsible for monitoring the code deployment activities during Go live date and ensured the modules are successfully delivered in production environment for smooth Business execution Oracle 12c, PL/SQL Programming, Toad 12.6.0,SQL Developer, XML, Java API service, REST/SOAP UI5.0 JSON,TortoiseSVN (Subversion), Informatica PowerCenter, Forms and Reports 12g, XML, UNIX and Tivoli, Oracle e- Business Suite Application (ERP), Synergy/DE,ISAM files Cognizant Technology solutions

Client: Client: Express Scripts,Orlando,Florida July 2009 – Feb 2011 Health care /PBM- Specialty

Scrum Master- Agile Project model

ESI Star of the year award.

Awarded the Above & Beyond award for Q1 2010

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.

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. Java Eclipse, Java, Java Development Kit (JDK).

EMPLOYER NAME

WORK LOCATION

DOMAIN

POSITION HELD

ACCOMPLISHMENTS

ROLES &

RESPONSIBILITIES

TOOLS & TECHNOLOGY

EMPLOYER NAME

WORK LOCATION

DOMAIN

POSITION HELD

ROLES &

RESPONSIBILITIES

TOOLS & TECHNOLOGY

Cognizant Technology solutions

Client: Express Scripts Chennai, India Feb 2007- Jul 2009 Health care /PBM- Specialty

Sr Associate - Projects

Awarded for built a Project repository tool( WizdomTree) – Used for the developers to easily refer the completed project documents and design and develop the new projects

Awarded for built a eLearning tool- Used for the new onboarding resources Awarded associate of the Quarter in the account level.

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 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.

Create ER and data flow diagrams

Building a SOAP web service calls in Team developer code and closely work with multiple teams and Integrate the application

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. Java Eclipse, Java, Java Development Kit (JDK).

Allsec Technologies India Pvt. Ltd

URL: https://www.allsectech.com

Chennai, India Sep 2005 – Feb 2007

HR & Pay Roll service

Sr Software Programmer

Received associate of the month award for couple of times and worked as a key resource among the team of 30

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 an accounting software for Allsec’s prestigious overseas contract from Singapore.

Have worked on the web applications using ASP.NET and AJAX 1.0

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

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. Microsoft Visual studio 2008(Visual Basic 9, WCF, WF, WPF, ASP.NET AJAX 1.0, VSTO, CardSpace, Silverlight), NET Framework 3.5, Microsoft SQL Server 2005 .XML

Oracle 9i, Crystal Reports, Toad 9.0, Oracle SQL /PLSQL Programming FarPoint (Spread 3.1), VSS Golden InfoTech Pvt LTD

Chennai,India May 2003 – Sep 2005

Software Product development

Programmer

Recognized as the best performer for two consecutive year for on time customer delivery, Effective Mgt

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

VB6.0, Oracle 9i, Crystal Reports, Toad 9.0, Oracle SQL /PLSQL Programming FarPoint (Spread 3.1), VSS and Microsoft SQL server Management Studio

EMPLOYER NAME

WORK LOCATION

TYPE OF BUSINESS

POSITION HELD

ACCOMPLISHMENTS

ROLES & RESPONSIBILITIES

TOOLS & TECHNOLOGY

EMPLOYER NAME

WORK LOCATION

TYPE OF BUSINESS

POSITION HELD

ACCOMPLISHMENTS

ROLES & RESPONSIBILITIES

TOOLS & TECHNOLOGY

EMPLOYER NAME

WORK LOCATION

DOMAIN

POSITION HELD

ACCOMPLISHMENTS

ROLES &

RESPONSIBILITIES

TOOLS & TECHNOLOGY

DECLARATION:

I hereby declare that all the above details are true and confidential according to my knowledge.

(Ranjithbabu Sounderrajan)

REFERENCES ARE AVAILABLE UPON REQUEST



Contact this candidate