Developer Project

S.BHUVANESHWARI

Thiruvottiyur, Chennai.

Email: **********@*****.***

OBJECTIVE:

Seeking for a good position in an organization, which drives me to prove and enhance my knowledge and helps me to achieve a personal and professional satisfaction.

WORKING EXPERIENCE:

Hewlett Packard Global Soft Private Ltd, Chennai (July 2011- August 2013)

Ally – Intranet/Extranet

Client : Ally financial solutions – Previously known as General Motors Acceptance Corporation (GMAC) to be a provider of financing to automotive customers. Over the following years the business has expanded to include insurance, online banking, mortgage operations, and commercial finance.

Role : PLSQL developer

Team Size : 8

Technology : Core Java, Struts Framework, PL/SQL, jsp and Servlets

Tool : Toad, Eclipse, SVN

Frame Work : Struts

Database : Oracle 10g

Server : Sun one Webserver

Description:

Development and enhancements for Intranet / Extranet

Brief explanation about applications in the project:

DCT: Dealer competitive Tracking/Dealer Contact tool, allows the users keep a track of all contacts made and provide various reports

Auction Reconciliation: The application presents authorized users with a screen to enter Auction Sales data. The screens displays the total proceeds and give the user the chance to alter any amounts before they submit the results and send an e-mail when data is added or updated

Cash Actual: Capture and report Actual Cash Activity on a Daily Basis.

Held Offerings: The “Held Offering” application helps notify dealers about issues that need to be remedied in order for Ally to book the contract.

ABQA/One Touch: ABQA is an application used to create, complete and audit quality assurance reviews on accounts booked to ensure adherence to credit and underwriting policy guidelines and regulations. The results are then reported to the business owners and other stakeholders on a monthly basis for remediation, if necessary.

Security Filings: Security Filings is an application where new insurance are filled, verification and maintenance of existing insurance are done. It is used to generate reports for analyzing the insurance.

Responsibilities as PLSQL Developer:

Direct interaction with clients for requirements

Coding for the new requirement / coding for enhancements in PL /SQL

Testing in various scenarios and showing the Demo to client and getting the approval for deployment

Deploying the changes in Development, Pre-Production and Production environments

Back up routine works for Development environments

New cron jobs coding and enhancements of existing cron jobs

Weekly, Monthly and yearly activities in Development, Pre – Production and Production environments

Performance Tuning.

Maintaining the changes in SVN

ACHIEVEMENTS:

Employee of the year 2013 cash award.

Best Performer Award.

Best Team Award.

TATA CONSULTANCY SERVICE, Chennai – (February 2014 – April 2015)

Commercial Lines Data Warehouse (CLDW) – TOP 10 (February 2014 – December 2014)

Client : Hartford - The Hartford, is a United States-based investment and insurance company that is part of the Fortune 500 list

Role : PLSQL developer

Team Size : 6

Technology : Oracle, Unix

Tool : Toad, Informatica, Autosys, Quality Center

Frame Work : ETL Framework

Database : Oracle 10g

Description:

The insurance data of Hartford is taken care by our account. We follow ETL process to process the data.

ETL process: Data comes from different sources in different formats will get loaded in to the system, then its gets processed and reformatted. And finally loaded to the Dimensions and facts of data warehouse.

Upstream reports are taken from those Dimensions and Facts. Using which Business people will take decisions to improve the Business.

The ETL process for the CLDW includes 100 jobs. The jobs ran thrice a week, each load and the process took 2 days to complete. In Our project, we did changes in code (jil changes, procedures and packages), time and dependency to run the jobs daily and made the jobs to complete in Single day.

Responsibilities as a Developer in CLDW TOP 10 project.

Analyzing the CLDW jobs and packages for dependency

Coding for the new changes

Writing the test case, uploading the test case into Quality Center and running the test cases.

Running the CLDW jobs for testing.

Implementation of the new changes

FARES (January 2015 – April 2015)

Client : Japan Airlines (JAL): It is the largest airline company in Japan. It is headquartered in Shinagawa, Tokyo, Japan. Which deals with domestic and international airline services.

Role : PLSQL developer and Testing

Team Size : 7

Technology : Oracle, Unix, Java

Tool : Toad, eclipse, Quality Center, SVN

Framework : Struts

Database : Oracle 10g

Server : Sun one Webserver

Description:

Our project’s scope is to migrate JAL applications from its own Mainframe system to Amadeus System. Amadeus is a Global service provider (i.e.) Most of the airline industry uses the Amadeus server.

There are so many classifications under airline industry domain in that, we started working on migrating FARES to Amadeus. On completion of FARES other classifications will also be moved one by one.

Responsibilities as a Developer and Tester in FARES

Requirement analysis

Coding in PL/SQL

Test plan, Testing scenario and cases preparation

Execution of Test cases

Implementation

COMPUTER SCIENCE CORPORATION, Chennai – (April 2015 – October 2016)

SOLVE ENGINE

Client : Dell EMC (EMC Corporation until 2016) is an American multinational corporation headquartered in Hopkinton, Massachusetts, United States.

Role : PLSQL developer

Team Size : 31

Technology : Java, PL/SQL, jsp and Unix

Tool : Toad, Eclipse, SVN, Quality Center

SDLC : Agile Methodology

Database : Oracle 11g

Description:

EMC Corporation is the world leader in systems, software, services, and solutions for information storage and management. It help organizations of all sizes across the globe implement information lifecycle management (ILM) strategies that enable them to better and more cost-effectively manage, use, protect, and share their information.

EMC Corporation is the world leader in products, services, and solutions for information storage and its management. It is the information storage standard for every major computing platform and, through its solutions, serve as caretaker for more than two-thirds of the world’s most essential information.

Initially it was just a desktop application and manual paperwork. The scope of this project is to make it completely online based application. It gets data from different sources and also from the online application.

Responsibilities as a Developer in SOLVE ENGINE project.

Analyzing and Discussing about the story given

Coding for the new story

Implementing and testing the story in dev and getting the green flag from internal testing team

Implementing in test, pre-prod environment and getting the green flag from EMC testing team

Main resource in preparing db scripts for prod deployment from the scratch.

Virtusa Software Services Pvt Ltd in Chennai (Nov 2017- Till)

CFIL

Client : CITIBANK

Role : PRO*C developer

Team Size : 19

Technology : Pro*c, UNIX, SQL

Database : Oracle 11

Description:

Migration of multiple database to single database. Enhancement in CFIL.

Brief explanation about applications in the project:

We are migrating the Database for different location to a single database. As part of that, BRM module is first been migrating to CFIL.

Responsibilities as PLSQL Developer:

Coding for the Migration/new requirement / enhancements in Pro*C

Preparing UTP and PS documents for the change

Deploying the changes in Development and UAT.

Testing in Dev and UAT.

TECHNICAL KNOWLEDGE:

Programming Language: C, C++, Core Java and PL/SQL.

Scripting Language: HTML, JavaScript.

Database: Oracle 9i, 10g, 11g.

Operating System: Windows 98/XP, Windows 7, Ubuntu, UNIX.

Tools: Toad, Web Control Center, Quality Center,SVN.

EDUCATIONAL QUALIFICATION:

B.E (Computer Science Engineering) graduation from Vel Tech HighTech Engineering College-Anna University Chennai with 79% - 2011.

H.S.C from Vellayan Chettiyar Hr. Sec. School Chennai with 88% - 2007.

S.S.L.C from Vellayan Chettiyar Hr. Sec. School Chennai with 83% - 2005.

STRENGTH:

Ability to work independently as well as in a team

Structured problem solving skills

Able to achieve the targets in the given time and the expected level.

Ability to lead teams

Hard working capability

Strong written and communication skills.

Flexible and adapt quickly to new working environments.

Quick learner and hardworking.

FIELDS OF INTEREST:

Programming

Database Management System

Web Designing

PERSONAL DETAILS:

Date of Birth : 8th February 1990

Marital Status : Married

Passport : Valid

Languages Known : English & Tamil.

Nationality : Indian

References: Available on request.

S BHUVANESHWARI

Contact this candidate