SUMMARY

• An IT professional with around 8 years of work experience as a support analyst in production support, development and administering databases.
• Strong knowledge in Oracle 9i/10g/11g/12c database programming using PL/SQL (Stored Procedures, Functions, Packages, and Triggers) and standard built - in Oracle packages in UNIX and Windows environment.
• Good Knowledge of using IDE Tools like Eclipse, NetBeans, IDEA IntelliJ for Java/J2EE application development and web technologies like HTML as required for database management.
• Design of data models and objects including Tables, Views, and User defined Functions, Triggers and Stored Procedures for applications.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, and sub-queries to generate various reports.
• Experience in Database design on the basis of URD as well as normalization of databases.
• Experience in application development and production support of large and critical network with 24/7 uptime.
• Extensive experience in working with Dimensional Modeling (Data Marts, Facts and Dimensions), Data Migration, loading high volume of data, Data Cleansing, ETL Processes.
• Experienced in design and development of various web and enterprise applications using J2EE technologies like JSP, Servlets.
• Processing corrupt files and handling file issues using UNIX shell scripts.
• Excellent proficiency in Data Transformations, Data Loading, Database Modeling using various utilities like Export, Import and SQL* Loader and Performance Tuning of Legacy Systems.
• Well versed in both Client and Server-side Programming using Java Technologies.
• Escalation handling on recovery call and service delivery within SLA.
• Extensive knowledge and implementation skills in Struts MVC framework and JSF.
• Implemented concepts in PL/SQL like Ref Cursors, DBLinks and Snapshot refresh etc.
• Extensively experienced in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as an individual or as part of a team.

TECHNICAL SKILLS

Language(s): SQL, PL/SQL, C, C#.net, Java & JSP’s, HTML

OS Platform(s): Windows, UNIX, Red Hat LINUX

Database(s): Oracle 9i/10g/11g/12c, DB2 (Release 9.1 or later), MS Access 2007 orlater, MS-SQL Server 2005 or later

Version Control Tool(s): IBM Rational Clear Case, Tortoise SVN (Subversion)

Defect Tracking: Bugzilla

Scripting: UNIX Korn Shell Script, Perl Script, Java Script

Package(s): Adobe Products, MS Office

Other Tools: TOAD 10.1 or later, SQL *Plus, SQL *Loader, SQL Developer 3.0 or later, WinSCP, Eclipse 3.6 or later, SharePoint, MS Project, MS Visio, EditPlus, Putty, Confluence, Erwin, TextPad

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Senior Analyst

Responsibilities:

• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling Sync up with Confluence for Project related information.
• Used SQL*Loader/Korn Shell Script to load data from various sources into an Oracle database.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Used Clear case for maintaining the component and for release and version management.
• Maintaining scripts using Korn Shell scripting (extension- .ksh) and Perl to support development.
• Developed UNIX shell scripts to automate repetitive database processes.
• Tracking all the releases and updating the information on to a centralized location (Wiki).
• Developed korn shell scripts for job scheduling, batch processing and database transactions.
• Strong proficiency in MS Project/MS Office suite/MS Visio/SharePoint portal.
• Responsible for Administration of version Control tools such as IBM Rational Clear Case, Subversion, participated in Peer code reviews and verifying coding standards.
• Involved in creating UNIX shell scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Gathered FSD (Functional Specifications Document) from the business in order to bridge even the slightest gap between stakeholders and the development team.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Implemented the application using Spring MVC framework with JPA.
• Extensively worked in software development methodologies including both Agile (Scrum, Kanban, XP- Extreme Programming) and Waterfall models.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Partitioned the fact tables and materialized views to enhance the performance.
• Participated in change and code reviews to understand the testing needs of the change components.
• Tuned database SQL statements and procedures by monitoring run times and system statistics.
• Good understanding of database objects and ability to triage issues.
• Integration of front-end with Oracle database using JDBC API through JDBC-ODBC Bridge driver at server side.
• Wrote various scripts in PERL and SHELL for database health and space checks.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Maintaining daily batch cycle and providing 24 hour production support.

Environment: Oracle 12c (PL/SQL, SQL*Loader), Erwin 9.2/9.6, Eclipse 4.4, Toad 11.5/12.0, MS Visio 2013, UNIX korn shell and Perl scripting, MS Excel 2013, Confluence, Scrum, Kanban, SharePoint, Tortoise SVN, Bugzilla.

Confidential, Jersey City, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in designing and development of data warehouse for the corporate data repository.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures).
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Created Users and maintained security with Roles and Privileges.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Coded and implemented data migration processes using Oracle procedures/packages (using PL/SQL).
• Worked on troubleshooting defects in a timely manner.
• Designed/Coded/implemented automatic error handling and recovery processes for table data loads and developed SQL* loader scripts to load data in the custom tables.
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Developed and optimized of SQL queries using TOAD Explain Plan utilities.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency.
• Extensively involved in preparing and organizing Detailed Technical Documents from the functional specifications.
• Created relevant staging tables to load the CSV files, identified the business validation rules.
• Developed Spring JDBC Components.
• Run batch jobs for loading database tables from flat files using SQL Loader.
• Used Version Control tools like Microsoft Visual SourceSafe for Source Control.
• Developed Materialized views and Ref Cursors for reporting purpose.
• Used JDBC API to establish connection between Java and Database.
• Developed and modified PLSQL procedures, functions and package as per requirement.
• Tuned the oracle PLSQL procedures and queries using explain plan and hints to improve the performance of the reports.
• AUTONOMOUS TRANSACTION PRAGMA is used in the framework procedures to log the status when error occurs.
• Involved in Integration test, System test and Implementation.
• Designed and developed Controller Servlet, which will route request to Application Controller
• Worked closely with users and developers team to resolve issues in the developed reports.

Environment: Oracle 11g (PL/SQL, SQL*Loader), JDK 1.7, Microsoft Visual SourceSafe, Toad 10.6/11.0, JSP, MS Visio 2013, UNIX, Crystal Reports XI, HP-UX 11.20, MS Excel 2007/2010, SQL Server 2010/2012, JavaScript.

Confidential

IT Analyst

Responsibilities:

• Worked for the onshore Target team in preparing SQL scripts.
• Extensively used EXPLAIN PLAN, SQL TRACE, ANALYZE and HINTS.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Ensuring effective quality control processes are in place to monitor deliverables produced.
• Ensuring all the milestones are achieved within the agreed timeframe.
• Arranged quick run meeting with all the teams to make sure everyone is on the same page.
• Developed JSP pages using tag libraries and exploited the potential of Hibernate and Spring for Object-Database mapping, transactions, and for achieving dynamic business functionalities.
• Used Tortoise SVN to check in the code as process of migration from DB2 to Oracle 11g.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Coordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.
• Attended business user sessions to make changes in warehouse loads.
• Developed UNIX korn shell scripts to process file feeds.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Developed materialized views for data replication in distributed environments.
• Partitioned large tables using range partition technique.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Created documentation. Gathered requirements, wrote technical specifications, workflow diagrams.
• Worked on OLTP for optimization and to facilitate the processing of large numbers of concurrent updates to the database.
• Created and executed test cases and ensured bugs are logged and tracked through closure.
• Used UTL FILE (file handler), DBMS JOB, and other utility built-in Packages in PL/SQL.
• Involved in Requirement Analysis, gathering requirements from Business Teams and interacting with the Development team.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Environment: Oracle 11g (PL/SQL, SQL*Loader), J2EE, Oracle Warehouse Builder (OWB 10.2), SQL Developer 3.1, MS Visio 2010, UNIX korn shell scripting, MS Excel 2007/2010, Spring 3, Hibernate, IBM Rational Clear Case.

Confidential

Systems Engineer

Responsibilities:

• Worked as a developer, as and when demanded, production support team and this project was purely based out of telecom domain.
• Created automated scripts in Linux environment for Dev and basic sanity testing.
• Developed PL/SQL scripts using complex business logics.
• Designed computations with simple logics and delivered incentives during various days of every month to distributors/ retailers of whole PAN India.
• Involved in migrating production database from Oracle 9i to 10g database.
• Despite of the tight packed schedules, prepared some adhoc reports, which delivered the bulk amount of required data to the client.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Oracle Database and SQL tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Developed Java code as per the user requirement and supported .Net projects created by different visual studio versions.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• To obtain improved response time in case of complex queries, MQT (Materialized Query Tables) were created and defined smoke testing process and procedures.
• Wrote korn shell scripts to support the auto generated periodic incentive reports.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind (ForAll) features with Collections instead of using cursors and FOR loops.
• Managed day-day production support activities till the Change Request is completely rolled out.
• Extensively worked with Oracle Utilities like UTL FILE, DB Links, and TOAD, UNIX Korn Shell Scripting, Imports/ Exports using external tables and SQL * Loader.
• Used Dynamic SQL and autonomous transactions for error handling.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
• Fixed all the security hole and bugs in most of the packages and also fixed security hole in control files of the SQL*loader.
• Created various Korn Shell Scripts for scheduling various data cleansing scripts and loading process.
• Re-designed the existing system in Oracle 10g by performing data validation and developing load processes using PL/SQL stored procedures, functions and triggers to enhance and improve functionality requested by business users to reduce their manual processing time.
• Developed and modified UNIX scripts to wrap PL/SQL code, FTP files, send emails, automate batch processing and upload data.
• Extensively used BLOB and CLOB to store images and large documents.

Environment: Oracle 10g (PL/SQL, SQL*Loader), Toad 10.6/11.0, SQL Developer 2.1/3.0, Putty, WinSCP, UNIX korn shell scripting, MS Excel 2007, MS Access 2007, IBM Rational Clear Case.

Confidential

Software Programmer

Responsibilities:

• Re-designed the existing system in Oracle 10g by performing data validation and developing load processes using PL/SQL stored procedures, functions and triggers to enhance and improve functionality requested by business users to reduce their manual processing time.
• Implemented Snowflake Schema for the OLAP database for the company’s investment management system.
• Integration of front-end with Oracle database using JDBC API through JDBC-ODBC Bridge driver at server side.
• Developed logic and code for the registration and validation of the enrolling customer.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Written various Triggers, Stored Procedures to perform or automate many of the tasks.
• Wrote stored procedures for developing Adhoc Reports according to user specification.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Optimized SQL queries used in Reports and Stored Programs (Procedures, Functions and Packages) to improve performance drastically.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Developed and optimized of SQL queries using TOAD Explain Plan utilities.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency.
• Used Key files to hide certain parameters from users and added key mapping entries to a key map file.
• Performed client side validation using JavaScript. Validation from client side was done using JavaScript.
• Developed and modified UNIX scripts to wrap PL/SQL code, FTP files, send emails, automate batch processing and upload data.

Environment: Oracle 9i/10g (SQL, PL/SQL), JavaScript, TKPROF, HTML, JDBC, JSP, Java Servlets, HTML, UNIX shell Scripting, SQL*Loader, TOAD 10.0, MS Excel 2003, UNIX.