Saranya Pandi

adeenh@r.postjobfree.com Tel: +91-994******* (Mobile)

CAREER OBJECTIVE

To secure a position where I can effectively utilize my technical and organizational skills, a position that offers professional growth while being resourceful, innovative and challenging.

PROFESSIONAL EXPERIENCE

Working as Module Lead in Mindtree Limited Chennai (Dec 14 May 18)

Working as Systems Analyst in Ramco Systems Limited Chennai (Apr 14 Dec 14)

Worked as Analyst Programmer in Ramco Systems Limited Chennai (May 11 - Apr 14)

Worked as Programmer Analyst Trainee in Cognizant Technology Solutions(Nov 09-Aug 10)

PROFESSIONAL SUMMARY

7 years and 8 months of Development experience in the SDLC with extensive knowledge and

skills in Analysis, Design, Development, Testing and Support.

IBM Certified Database Associate - DB2 10.1 Fundamentals.

Having good knowledge in SQL Server 2012 and above.

Offer outstanding talents in writing Stored Procedures in T-SQL.

Expertise in converting the Functional requirement in to Design specification.

Conducted optimization and Performance tuning of T-SQL queries and stored procedures.

Having good experience in Shell Scripting, Databases, Data warehouses with good exposure to Datastage 8.7/9.1

Good knowledge on Data warehousing concepts like Star Schema, Snow Flake, Dimension and Fact tables.

Expertise in Data modelling.

Good Exposure to AGILE software development lifecycle.

Quick learner, good at logical thinking and problem solving techniques and thrive to learn new technologies.

4 months of onsite experience in one of the largest and complex IT projects of South Africa.

Experience includes offshore coordination, competency development and implementation support/maintenance, Conducting Training sessions.

Involved in Production support in onsite for the Go live modules.

Expertise in Requirement analysis, defect analysis, troubleshooting and bug fixing

Team player and an adaptable person to work effectively in a team with good communication skills.

Designed databases and relevant objects through preparation of tables, groups and indexes.

Highly motivated, result-oriented individual.

Strong communication skills written and verbal.

Strong problem solving, interpersonal skills and accountable for bottom-line success on the task taken in hand.

Possess strong multi-tasking, team building, efficient time management and leadership skills.

Team player and an adaptable person to work effectively in a team with good communication skills.

TECHNICAL SKILLS

Hardware

IBM Mainframe Compatible PCs.

Operating Systems

MVS/ESA, Z/OS, MSDOS, Win XP,

Win 7,Win 8,UNIX

Programming Languages

Databases

COBOL, JCL, CICS, C, C++, T-SQL,SQL

IBM DB2(9.7/10.1),Oracle, SQL Server2012,2015,2016

Tools

Aqua Data Studio,IBM DataStudio,ERwin,

IBM DataStage Enterprise editionv8.7/9.1,TFS

PROFESSIONAL EXPERIENCE

Company : Mindtree India Pvt LTD., Chennai

Client : REALOGY Ltd,RFG May 15 May 18

Project : Dash 1.0,Dash 2.0

Role : Module Lead

Description :

RFG is a sub unit of Realogy which deals with Real estate Franchises and their Brokerage. Dash 1.0 dealt with the Real Estate Brokerage and their Royalty calculation based on the Brands. Dash 2.0 is the extended and Performance Tuned version of earlier Version.

Environment : Database - SQL Server 2015,2016

Software Methodologies - Visual Studio,TFS

Tools

SDLC Model - WaterFall

Responsibilities:

Understanding the Business Requirement and Functional Specification documents during project initiation phase

Defining the Scope based on the Functional and Technical Documents .

Estimates the size of the project and effort with respect to Development

Creating Tables,Writing Stored Procedures and functions based on the reuirement

Review of Code, Scripts prepared by the other team members.

Handling Defect Calls and performing Root Cause Analysis for Defects

Communicates the progress of project activities to the Management/Business Stakeholders.

Prepares Weekly / Monthly Project status report and participates in Management Review Meetings on regular time periods

Ensures the quality processes are followed throughout the Development cycle.

Support the Business Users [during UAT testing] & UAT testers in case of problems and provide assistance in troubleshooting.

Acts as a mentor for team members as a Team lead and provide performance feedback.

Production Support for Live modules.

Played vital part in resolving the critical issues raised during Go LIVE

Implemented processes for debugging of defects, errors and troubleshooting problems related to backend

Responsible for to construct best practices / Value added services and needs to identify the grey areas in project for improvement.

Company : Mindtree India Pvt LTD., Chennai

Client : AIG Dec ‘14 May 15

Project : Global Exposure Solution

Role : Module Lead

Description :

The Global Exposure Solution (GES) is a catastrophe risk management system that helps users to estimate location based risk against any exposure by capturing complete and accurate exposure data during quotation process. After capturing the data, cleansing of data is carried out using centralized service and formats it in a uniform way. Augmentation of captured data is done using third-party tools.

After all these processes, the processed data is sent through various CAT modelling tools that are available as centralized service, then the scrubbed data and CAT modelling results is stored in a central database, allowing the AIG underwriters and Risk Managers to manage location-based risks on individual and in aggregate basis.

Environment : Database - DB2 V 9.7

Software Methodologies - Aqua Data Studio, IBM Data Studio

Tools - PVCS, PEGA as Front End

SDLC Model - AGILE

Responsibilities:

Understanding the Business Requirement and Functional Specification documents during project initiation phase

Defining the Scope based on the Functional and Technical Documents .

Estimates the size of the project and effort with respect to Development

Creating Tables,Writing Stored Procedures and functions based on the reuirement

Review of Code, Scripts prepared by the other team members.

Handling Defect Calls and performing Root Cause Analysis for Defects

Communicates the progress of project activities to the Management/Business Stakeholders.

Prepares Weekly / Monthly Project status report and participates in Management Review Meetings on regular time periods

Ensures the quality processes are followed throughout the Development cycle.

Support the Business Users [during UAT testing] & UAT testers in case of problems and provide assistance in troubleshooting.

Acts as a mentor for team members as a Team lead and provide performance feedback.

Production Support for Live modules.

Played vital part in resolving the critical issues raised during Go LIVE

Implemented processes for debugging of defects, errors and troubleshooting problems related to backend

Responsible for to construct best practices / Value added services and needs to identify the grey areas in project for improvement.

Company: Ramco Systems Pvt LTD., Chennai

Client : Ethekwini Municipality, SA July ‘14 Dec ‘14

Project : Revenue Management System (RMS) Phase 2

Role : Developer

Description :

The revenue management system is one of the largest and complex IT projects in South Africa. The project is implemented by eThekwini municipality, Durban South Africa and one of the most prestigious projects of Ramco Systems, Chennai. Revenue Management System (RMS) is an ERP product developed by using Virtual Works (VW) tool, which is component-based architecture.

This project deals with managing and maintaining the basic needs of citizens in a government, like providing Water and Sanitation, Electricity, Solid waste Management, Leasehold, Property tax levies. This project contains various Business Process Components for revenue management like Customer Management, Charges Generation, Billing Management, Debt Management, Service provisioning etc. This project is to develop a product of Web Based ERP Solution to manage all aspects of revenue management of the local government.

Environment : Database - DB2 V 10.1

Software Methodologies - ER Win, Aqua Studio

Tools - Ramco Virtual Works (RVW), Virtual SourceSafe (VSS)

Responsibilities:

Performed Performance tuning of almost all batches in RMS.

Development of Change Requests(CRs) as given by Customers with adherence to software quality Standards.

Managing a team of 5 members.

Production Support for Live modules.

UAT Support for certain modules.

Implemented processes for debugging of defects, errors and troubleshooting problems relating to database objects.

Defect Fixing in various components and stages of Revenue Management Systems.

Handling design through Ramco Virtual Works (RVW) tool.

Prepared and executed Unit Test Cases for complex components.

Involved in defect fixing, deployment in onsite.

Involved in design reviews and code reviews.

Prepared database design documents, code reviews, definition and structure.

Company: Ramco Systems Pvt LTD., Chennai

Client : Ethekwini Municipality, SA May ‘11 June ‘14

Project : Revenue Management System (RMS) Phase 1

Role : Developer

Worked in onsite for a period of 4 months providing Implementation Support and UAT support.

Description :

The revenue management system is one of the largest and complex IT projects in South Africa. The project is implemented by eThekwini municipality, Durban South Africa and one of the most prestigious projects of Ramco Systems, Chennai. Revenue Management System (RMS) is an ERP product developed by using Virtual Works (VW) tool, which is component-based architecture.

This project deals with managing and maintaining the basic needs of citizens in a government, like providing Water and Sanitation, Electricity, Solid waste Management, Leasehold, Property tax levies.This project contains various Business Process Components for revenue management like Customer Management, Charges Generation, Billing Management, Debt Management, Service provisioning etc. This project is to develop a product of Web Based ERP Solution to manage all aspects of revenue management of the local government.

Environment : Database - DB2 V 9.7 and DB2 V 10.1

Software Methodologies - ER Win, Aqua Studio

Tools - Ramco Virtual Works (RVW), Virtual SourceSafe (VSS)

Responsibilities:

Part of a 10 member team in which we delivered a Non Functional Requirement CR(Performance Tuning)

Provided assistance for modeling and execution of database enhancements and component development.

Production Support for GO Live modules.

UAT Support for certain modules.

Defect Fixing in various components and stages of Revenue Management Systems.

Handling design through Ramco Virtual Works (RVW) tool.

Conducted debugging and unit testing services of SQL code, specifications and test conditions.

Involved in defect fixing, deployment in onsite.

Involved in design reviews and code reviews.

Extensive support during implementation of the module.

Prepared database design documents, code reviews, definition and structure.

Company: Cognizant Technologies Solutions

Client : JPMC US IS, Dallas, TX Nov ‘09-Aug ‘10

Project : CAPP Migration

Role : Developer

Description :

Corporate Actions Principal and Payment (CAPP), forms a part of the core custody operations of JPMC-IS. It stores all settled trade transactions as well as cash transactions for 18 months and provides online queries and various different reports as and when required. This system thereby acts as the Book of the Bank . It also creates daily asset tapes and extensive reports for balance reconciliation and cash proofs. This CAPP system earlier uses FILEMAXX database. The Filemaxx database is converted to DB2 Database which is the scope of the project.

Environment : Hardware - IBM Mainframe Compatible PCs

Operating systems - MVS/ESA, Z/OS, Windows XP

Programming Languages - COBOL, JCL, SQL

Databases- DB2, FILEMAXX

Responsibilities:

Part of a 15 member team in the CAPP migration project.

In a short span, quickly learnt the technology, understood the business and was able to give the deliverables on schedule.

Involved in coding and testing phase and provided a user friendly User Interface.

Prepared test plans and also documented the program flow.

Performed Unit Testing, System Testing and Integration Testing.

Performed peer reviews on code and test plans.

AWARDS AND RECOGNITIONS

Received appreciation (Unstoppable Award) from the top management in the AMM(All minds meet) for fixing more number of issues across various releases during implementation support and across versions with good quality and for providing extended support during crisis.

Was awarded Hats off & Unstoppable for successfully handling the design change for the key and equally complex production tickets right from Dev into Prod.

Completed IBM Certified Database Associate - DB2 10.1 Fundamentals. from IBM

Certified "SQL server for Developer PROFESSIONAL" from spring people.

Completed Big Data & Hadoop Advance Course from Skillspeed.

Completed Python for Data Science Expert from Edureka.

Contact this candidate