SHELLY AGARWAL

Email Id:shellyy.agarwal@gmail.com

Mobile: 9884481371

CAREER OBJECTIVES To use my skills in the best possible way for achieving the company’s goals. To get a challenging position where I can put my all experience and knowledge to give a

significant growth to the organization. Successful teamwork experience and demonstrated leadership abilities such as integrity,

attention to detail, deadline oriented, goal oriented and a motivator.SKILLS SET

A logical, analytical thinker with excellent managerial and problem solving skills possessing 3 years of experience as Database Developer.

Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Views, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.

Experience in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).

Fair Knowledge in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.

Experience in requirement analysis, coding and testing various modules in a software development life cycle.

Tools/Software – Toad, Autosys , JIRA, Visual Studio, Reports10g Programming Languages – PL/SQL(Oracle 10G, 11G) Well acquainted with OOPS concepts in C++, Java. Beginners on Informatica ETL tool. Involved in JOB Scheduling and handling Autosys Team. Participating in code reviews before every release and in creation of LLD’s for the projects. Handled the project independently in the absence of my team lead and manager.

JOB EXPERIENCEPerficient Inc(Chennai)Technical Consultant (October 2016-Present)

Working as a PLSQL and Oracle Apps Developer.

Responsibilities: Created custom templates with Data Definitions for XML Publisher and Developed reports

using reports and registered as XML reports in applications. Developed triggers in reports before/after for validation of parameters.

BA Continuum India Pvt. Ltd(Chennai)Senior Software Engineer (Jan 2016- Sep 2016)Senior Technical Associate (Jul 2013- Jan 2016)

Working as a DB Developer and Production Support Team member in the team of Alternative Investments which manages $13.5 billion worth of assets and deals only with ultra high network clients. So this project is really critical and requires me to have a lot of domain knowledge, communication skills other than the coding skills.

Projects 1. Project : Client Document Capture Screen

Domain : GWIMT (Global Wealth Management & Technology) Role : PL/SQL Developer, JIRA Description : Application for Back office users to perform operations on Document

Management, Order Processing and Order Execution.Responsibilities:

Generating Tax reports, Fund Details and transmitting it to third party and systems, implemented the entire functionality of Conversions in system.

I have also streamlined many processes in the system: Enhanced the order execution cycle which reduced the overall time of operations.

Restructured the architecture for reports being sent to transfer agents in such a way that every time there is a new TA added, no release (code change) would be needed.

Responsible for handling issues in Production everyday and handle them in a pro-active manner.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Migration to Oracle 11G from 10G of 10 different schemas and 25 applications. Was involved in end to end integration testing across all non-production regions which covers 1500+ high level scenarios, also co-ordinated with external vendors to verify the entire file processing system.

2. Project : AIDOMS Domain : GWIMT (Global Wealth Management & Technology)

Role : PL/SQL Developer, Autosys Support Description: Application for Fund Managers to see reports.

Responsibilities: Client Reporting via Client Review Center - Implement basic data integration

between AIDOMS and CRC along with the ‘AI– Fund Liquidity’ by creating multiple reports on Fund and Security Tables.

Set up jobs for sending out all details from CDCP to AIDOMS.ACADEMIC BACKGROUNDB.Tech IT 2013 VIT University, Vellore 8.87(CGPA)Class XII 2009 ST. James School, Binnaguri (ISC) 90.4% Class X 2007 ST. James School, Binnaguri(ICSE) 85% ACADEMIC PROJECTS

Cloud Computing – To share one application on other system using VMWare. Project title: Airline reservation system , Jan 2012 –May 2012 (6 months)

Synopsis: Project theme is on making airline reservation system that contains airline schedules, fare tariffs and ticket reservation. The airline inventory contained all flights with their available seats, customer information and ticket details.

Tools and Languages: HTML, CSS, MYSql, WAMP server.ACHIEVEMENTS

Have received the 2nd best project delivery (Team of 5) in GWIM 2014 H2 BACI Team Awards.Out of 30 projects, 15 were nominated and my project Oracle 11G upgrade was selected for it.

Received 2 Silver awards from Onshore for excellent work, ability to produce best result in pressure situations and 2 Silver awards from my Manager for the delivery.

Distinguished by a Gold Award from manager for Order execution Enhancement. Held Vice-President Position at IEI student chapter in VIT from July 2011-April 2012. Organised an event ‘Blind C’ and a workshop on ‘Robotix’ in VIT by ADT solutions. Have been a co-ordinator in Riviera cultural fest at college.

SUMMER INTERSNSHIP Industrial internship in HCL ,May 2011–June 2011 (1.5 months) Worked on Java Programming and learning during this time. Industrial visit to Infosys, Bangalore.

EXTRA- CURRICULAR Participated in dance programmes in corporate events. Was a part of Employee Engagement Team for a period of 6 months.

PERSONAL INFORMATIONDate of birth 28th Dec 1991

Nationality IndianLinguistic Proficiency English, Hindi, Bengali