SUMMARY

• 5.5 years of experience in software projects implementation.
• 4 years of experience in SQL development.
• 3 years of experience in PL/SQL development.
• 1 year of experience in Storage (NetApp).
• 2 years of experience in Scripting, VB & C++.
• Core competency in PL/SQL, Storage (NetApp), UNIX, Perl Scripting, Windows, Database (Oracle), VB, C++, Oracle DBA, Networking, Solaris.
• Extensively worked on Oracle 11g & 9i.
• Proficiency in writing and tuning complex queries, stored procedures, joins and triggers.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle using PL/SQL.
• Strong Customer Centric Approach, with Process Orientation; Motivated by internal standards of performance to deliver quality results.
• Working knowledge of Agile Methodology of Project Management.
• Articulate communicator with strong analytical and interpersonal skills, skilled at collaborating with project teams, interfacing with clients.
• A systematic, organized, hardworking and dedicated team player confident in handling multiple assignments under pressure and meeting tight deadlines.
• Successfully executed and supported many projects in India, Australia and USA.
• Experienced in providing production support in different geographies and time zones all over the globe.

Technical Skills

Operating System : Windows, UNIX, LINUX, Solaris, ONTAP
Programming Languages : PL/SQL, SQL, C++, VB 6.0, scripting
SQL Developer Tools : SQL Developer, SQL*plus, Toad
Markup/Scripting Languages : HTML, PERL, UNIX, XML
Database : Oracle (9, 10, 11), NetApp, NAS, SAN
Other Tools : Remedy 7.1, DFM, RSA, Tivoli, Putty

Project Details

Projects Profile (1) Project :

Servicer & Investor Reporting

Client :

Confidential, (HERNDON, VA)

Duration : (09/2011 – 09/2012) Environment : Tool : SQL Developer, PL/SQL2.3.4 Environment : Oracle 11g, Unix Project Overview: The Federal National Mortgage Association, commonly known asFannie Maeis a government sponsored enterprise. The corporation\'s purpose is to expand the secondary mortgage market by securitizing mortgages in the form of mortgage-backed securities (MBS), allowing lenders to reinvest their assets into more lending and in effect increasing the number of lenders in the mortgage market. Roles and Responsibilities: I was working as the senior developer and involved in the SDLC for many modules of the project along with production support for critical application. Key responsibilities handled by me were:

• Requirement Gathering from Business Analysts and cross-functional teams
• Part of the team that was involved in project planning and timeline estimation for new modules
• Involved in the Database Objects creation and normalization of tables
• Involved in Development of Technical Designs, Code Review, Analysis and Testing of new PL/SQL procedures and enhancements to existing applications, fix software bugs
• Writing and tuning complex SQL statements, complex joins, M-views and sub-queries
• Provided Production support by triaging batch failures and other production issues
• Used TKPROF (SQL Trace) tool to analyze and fix multiple time consuming SQL statements that were available in stored packages.
• Extensively used DBMS_Scheduler for scheduling the nightly batch jobs
• Used Bulk Collect feature to improve performance
• Used SQL Loader to load the data from Flat Files into the staging tables and verified the Log Files for rejected rows
• USED Pragma Exception_INIT and RAISE_APPLICATION_ERROR to handle exceptions
• Used various Exception handling cases for proper flow of data into database tables
• Used PRAGMA INLINE to optimize the invocation of subprogram units
• Creating many reusable components for migrating Excel data to Oracle database
• Involved in importing the production data to work environment through Datapump Utility
• Regular Demonstrations with the clients teams to provide the appropriate solution to their needs followed by Unit Testing, SIT and UAT

Projects Profile (2) Project :

SUNCORP – Resource Management Systems

Client :

Confidential,Brisbane, Australia

Duration : (12/2009 – 08/2011) Environment : Tool : Toad, SQL Plus, PL/SQL2.3.4 Environment : Oracle 9i, Unix Project Overview:

Confidential,an Australian based Banking and Financial Management organization dealing with critical & non critical production servers and management and administration for all their Unix/Windows servers. They have a centralized database to maintain all relevant financial information regarding Credit Information, purchase order etc. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries.

Roles and Responsibilities: My interest in PL/SQL development made me to grasp this opportunity of a PL/SQL developer within the project. After on job training, I started the management of the assigned support activities independently. My strong grasping power enabled me to become a strong PL/SQL developer and handled various complex coding tasks independently. I learned various tools and nurture the learning by designing and developing high quality stored procedures, triggers, reports and other PL/SQL artifacts. Key responsibilities handled by me were:

• Extensively worked on Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader.
• Created DDL scripts, database objects like Tables, Views, Indexes, Synonyms and Sequences
• Developed PL/SQL Procedures, triggers, Functions and Packages and used SQL loader to load data into the database.
• Used partitioning and sub partitioning of tables to improve performance
• Developed Shell scripts and SQL control files to load data through SQL Loader.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts
• Developed triggers and PL/SQL procedures for automation of jobs scheduling
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF
• Analyzed and computed statistics to improve response time for queries.
• Involved in Performance tuning of complex queries
• Test case/data preparation, execution and verification of the test results.
• Create spreadsheets and reports using oracle PL SQL, Toad and SQL
• Conducting Knowledge sharing sessions with the onsite team
• Onsite – Offshore coordinator.

Projects Profile (3) Project :

Confidential,SMS

Client :

Confidential,Brisbane, Australia

Duration : (02/2009 – 12/2009) Environment : Tool : Netapp Storage O.S : DATA ONTAP 7.2.4 Project Overview: Confidential, an Australian based Banking and Financial Management organization dealing with critical & non critical production servers and management and administration for all their Unix/Windows servers. The project part included maintaining and monitoring the Suncorp boxes of approximately 4000 cross-platform servers including all technologies like VMware, Microsoft, all UNIX flavors including Solaris, HP-UX and Linux. Roles and Responsibilities: After on job training, I started management of the assigned support activities independently. My Inquisitiveness & perseverance made me the go to person for any L2 support issues. I evolved as a senior support engineer and have learned the new storage tool and nurture its knowledge while supporting the project with a 24 X 7 work culture. Key responsibilities handled by me were:

• Solely handled the Storage (NetApp) part of the project and worked on various NetApp filers like FAS 3000 series, FAS 6000 series etc
• Worked on NAS environment on both Unix/Windows Servers
• Familiarity with SAN environment, creating DFS and NIFS shares
• LUN Management - Creating, formatting and mapping to target
• Volume Activations/Deactivations, Migrations
• Nearstores/Primary/DR filers Health check and Flexclones
• Volume Space status, Aggregate status check and various DFS related tasks
• Owned Snapmirror Remediation, Snapvault lags issues and Snapshot monitoring, virus checks etc.
• Performed File restoration, Flexclone deletions & Expired volume deletion tasks.
• NetApp Storage Administration-(via secure shell through ONTAP CLI and DFM)
• Handled Veritas Netbackup Restores and VTL Capacity Balancing
• Managed Firmware upgrades on RSA effectively
• Technical support Lead for L2 support group
• System monitoring for hardware alerts for IBM servers via RSA
• Incident Management, Change Management, Work Orders resolving various Incidents/tickets and change approvals/resolutions
• Delegation of work among the team to meet the deadlines as per client requirements/deadlines
• Conducting Knowledge sharing sessions with the onsite team

Projects Profile (4) Project : Confidential, Client :

Confidential,, India

Duration : (02/2008 – 02/2009) Organization : NCCMS Environment : Languages : Java, Sql O.S : Windows Project Overview:

Confidential,is an enterprise application that will automate the processes involved in the production of an Electronic Devices. This application is an enterprise application, distributed and data centric, that provides a user interface for getting the information regarding different electronic devices.

Roles and Responsibilities: Active member of the Database team Involved in the coding of key modules

• Handled all major backhand coding using SQL
• Written complex queries to interact with database
• Written triggers to execute key tasks

Involved in Unit and System testing Documented the UAT and release notes

Projects Profile (5) Project :

Mobile Tracker

Client :

Confidential,India

Duration : (02/2007 – 02/2008) Environment : Languages : Visual C++, C, SQL O.S : Windows Project Overview:

An Integrated System, Which works cohesively with all the telecom service providers. It is a detector that detects the address, name of the last user and the mobile service which he\\she beholds. It’s a website Linked with Company’s Customer Database & keeps record of the users of the website.

Roles and Responsibilities: Create requirement document and freeze the requirement after consultation. Creating the schedule of the project

• Handled all major backhand coding using SQL

Coding of the key application module

• Data Routing

Education

• Bachelors of Technology in Computer Science

Certifications

• IMS ITIL Problem and Change management
• ITIL Service Desk and Incident management
• UNIX Training Certification

Achievements
• Best Team Work Award.
• Got Meritorious Position in Mathematics Olympiad.
• Got Prizes in Article and Poster Competitions.
• Got SAN/NAS Training by Sun Microsystems.
• A great performer in the training courses of Infosys Technologies.
• Among the Top performers in various webinars/seminars/trainings conducted by Infosys.