SUNMEET SINGH SETHI

917-***-****

acv9h2@r.postjobfree.com

SUMMARY

An SQL Developer/Production Support Analyst with about 6 years of experience.

Extensive support experience supporting large user groups in productions.

Strong skills in Oracle and Netezza database (SQL, UNIX).

Proficient knowledge of Software Development Life Cycle (from Requirement Analysis to successful Implementation).

Comfortable with providing after hour support (24x7).

Strong SQL and Query Tuning Skills.

Has solid experience using Oracle 8i/9i/10g and Netezza databases as a back end.

Designed various reports using Crystal reports and PL/SQL reports to meet the requirements of management and different users.

Proficient working experience in SQL, PL/SQL (Client and Server side Procedures, Functions, Packages, Objects, indexes, views, Triggers).

Good interpersonal communication, team leadership and excellent team player.

Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

Extensive experience in using different tools like Winscp, putty, winsql, SQL developer, Toad, SOAP UI, IBM Datastage etc

TECHNICAL SKILLS

Programming Languages : SQL and Unix, JavaScript, Html, Shell script,

C++, XML, CSS, VB, JAVA, JSP, Servlets

Database : Oracle 10g/9i/8i, Netezza

Operating System : MS-DOS, Windows, UNIX and Linux

Tools : Toad, WinSQL, SQL Developer, SQL*Plus, IBM Datastage,

Crystal Reports 8.5, SQL*Loader, Crontab, JCS System

Erwin, Eclipse, Oracle Forms and Reports 6i, Winscp,

Putty, Rumba for UNIX.

WORK EXPERIENCE

Epsilon, Wakefield, MA Sept 2010 - Present

Lead Operations Analyst

Department: Pharma Tech

The purpose of the system was to offer a full range of marketing services to help clients connect with their customers anytime and anywhere. Epsilon is world's largest permission-based email marketing provider, sending over 40 billion emails annually. After receiving data from different vendors in form of pipe delimited, fixed length or XML files, system processes them through file receipt, validation, convert all the way till ODS, CDM and RDM. At the end of processing campaigns were run to filter out the data so that email or direct email can be sent to right recipient at right time.

Responsibilities:

Designed and developed many Tables, Store Procedures, functions and Triggers.

Involved in meetings with business users to understand the requirements.

Used Job Control System(JCS) to schedule and automate the batch processing.

Wrote various Korn Shell scripts to load data into temp tables as well as creating extracts for sending data back to vendors.

Used SQL developer to maintain meta data in the repository and depending on the needs send it to DEV, QA or Production environments.

Used Netezza Database for performance and speed.

Used IBM’s Data stage tool to find and fix any bugs in the CDI processes.

Created different extracts and reports and automated using shell scripts to automatically ftp them to vendors.

Used Dream to upload files to send emails to right recipients at right time.

Performed reject analysis after daily processing and sent any meta data rejects to BSA’s and data rejects back to vendors.

Provided after hour support (24x7) for the batch processing.

Fixed bugs in the shortest available time and restarting the batch from point it failed.

Research production problems and initiate corrective action where appropriate.

Performed Unit, System, Regression, Security and User Acceptance testing.

Wrote cleanup scripts for cleaning up the space on both database as well as file system.

Trained and managed offshore teams to run batch processes and monitor during off hours.

Created daily Audit reports that indicate how much data got inserted, updated and rejected during the processing.

Support given in all phases of Software Development Life Cycle (SDLC).

Used WinSQL, SQL developer and SQL PLUS to perform various DDL and DML operations.

Used winscp and putty for performing unix operations.

Wrote shell scripts to convert data into PDP layouts.

Automated the entire processing and schedule it to run overnight.

Helped Business System Analyst in developing and testing new requirements.

Researched bugs, fixed and tested the code before moving to production in shortest time available time.

Wrote shell scripts to automate the ftp’ing of files and extracts to different vendors.

Used crontab as well as JCS to schedule jobs.

Created parent child relationships between different processes so that they run in sequence one after another.

Created various Indexes to improve performance, created sequences and defined primary key, foreign key relationships on tables.

IBM, Raynham, MA April 2009 – August 2010

Oracle PL/SQL Developer / Support Engg.

Project: Johnson & Johnson’s Order to Cash System

The purpose of the system was to bring in delivery information (orders) published from HCS SAP system and manages the process all the way through till shipment confirmation and getting the tracking information from Clippership. It also included printing of Pick List and Pack list for Codman products along with shipping Label. It would also include sending of lot master for any new lots picked and recorded during pick confirmation followed by an inventory adjustment transaction to move the inventory from ‘COLOT’ to the lot on pick confirmation.

Responsibilities:

Designed and developed many Tables, Store Procedures, functions and Triggers.

Involved in meetings with business users to understand the requirements.

Wrote several PL/SQL routines to read data from comma separated and Excel files and load into Oracle tables.

Participated in all phases of Software Development Life Cycle (SDLC).

Wrote Korn shell script to automate the process of ftp different files and scheduled using crontab.

Used Sql loader to load the data from mapping spread sheets into Lookup tables.

Assisted in debugging the PL/SQL code for fixing bugs.

Provided Hyper-care support by monitoring closely in JnJ Codman distribution center for first three weeks of Go-Live.

Wrote and executed various test scripts to test the functionality of the system.

Closely worked with the end-users to help them understand the usage of newly developed system.

Used TOAD and SQL PLUS to perform various DDL and DML operations.

Provided Support to the business users in warehouse in using the newly developed software.

Documented Functional specification documents and technical specification document

Promoted code to the testing and production Server.

Developed various oracle forms and reports using oracle 6i forms and reports.

Implemented locking and Unlocking mechanism of deliveries so that no two shippers can access same delivery at same time.

Provided after hour support (24x7) for the application.

Fixed bugs in the shortest time available.

Research production problems and initiate corrective action where appropriate.

Performed Unit, System, Regression, Security and User Acceptance testing.

Documented all the issues occurred on production server and routed through CCR process.

Created custom and ad-hoc reports on one time basis using Oracle Reports 6i.

Participated in QA and documentation.

Created various indexes for improving the performance.

Assisted in creating QA testing and break-fix environment.

Used crontab for scheduling the nightly data loading jobs.

Monitored Nightly running jobs for first couple of weeks of Go-Live.

Developed various maintenance forms, reports and PL/SQL routines after Go-Live.

Created various ad-hoc reports using Crystal Reports 8.5

e-touch Systems, Fremont, CA July 2008 - Nov 2008

Oracle-PL/SQL Developer

Project: NASA’s Conference Management System

The purpose of the system was to simplify and standardize the NASA conference recordkeeping in related informational systems. The users of the system were conference attendees, procurement officers, conference planners, financial managers, and others supporting conference participation in NASA. Conference database records were generated by attendees and conference sponsors and be moderated and maintained by moderators.

Responsibilities:

Designed the logical and physical database, and generated the script files for the physical database for future use.

Involved in analyzing and designing database using Normalization techniques.

Implemented complex Business Logic by writing Procedures, Functions, Database Triggers and Packages using TOAD and SQL*PLUS

Created various sequences, views, triggers.

Created many Servlet/JSP reports.

Worked in data handling using Java.

Used JDBC for Oracle connection.

Tested all the required Stored Procedures, Functions, Packages and Database Triggers.

Maintained the dependencies of all Procedures, Functions, Packages, Views and Triggers.

Coded packages for some commonly used functions and procedures using PL/SQL.

Created many reports for the users and moderator.

Used JDBC for Oracle connection.

Wrote Data Access Object (DAO) to connect PL/SQL procedures and functions with front end.

Took part in bug fixing.

Designed numerous JSPs and Servlets.

Used Toad to load and insert scripts into the oracle database.

Extensively used SQL queries to verify the integrity of the database.

Executed Explain plan to optimize queries.

Created admin module to create new usernames and passwords, change passwords, protect passwords by converting them into hash values.

Created various reports using Jasper reports.

Wrote cleanup scripts to clear all the data and reset sequences after testing was done.

Provided after hour support for the application.

Assisted in doing query optimizations and performance tuning of the system.

PERI software solutions, Newark, NJ

Oracle-PL/SQL Developer Oct 2007 - June 2008

Project: LIU’s Online Exam Management System

Designed and implemented a Web based application that allowed multiple choice exams to be created, administered, and taken. Students can come to website, register themselves and take the exams. The mentors can upload the multiple choice exams, edit exams and delete when they want. Project was implemented using java servlets and Oracle 10g.

Responsibilities:

Designed and developed many Tables, Store Procedures and Triggers.

Involved in the user specific requirement specification and documentation.

Wrote several PL/SQL routines.

Carried out normalization/ de-normalization of schemas.

Coded Stored Procedures, Functions, Packages and Database Triggers.

Wrote efficient views and Oracle queries

Designed numerous JSPs and Servlets.

Generated various reports using Jasper Reports.

Supported the application by providing after hours support.

Created many KSH scripts and enhanced the existing scripts

Involved in migrating the existing data across the two platforms.

As an application DBA, contributed to tuning the SQL queries, create database objects and optimally set storage parameters for tables and indexes.

Involved in the complete life cycle of database development, which includes designing of database, populating data, creating stored procedures for display on web, writing triggers and creating views for various reporting needs.

Developed the reports for high management and middle management for on time decision using Jasper reports.

Extensively used UTL_FILE package to write data from oracle tables to a flat file.

Support given in all phases of Software Development Life Cycle (SDLC).

Did performance tuning using TKPROF, DBMS_PROFILER, EXPLAIN PLAN and SQL TRACE.

EDUCATION

Georgia State University, Atlanta, USA Aug 2005 - Aug 2007

MS, Computer Science

Visvesvaraya Technological University, Karnataka, INDIA Aug 2000 - May 2004

B.Tech. Computer Science

Contact this candidate