SUMMARY

• Over 11 years of IT experience in all phases of Software Development Life Cycle.
• Involved in Design, development, implementation, testing and documentation of business applications using Oracle technologies.
• Strong in using tools such as PL/SQL developer, ERWIN, VISIO, SQL*Loader, Oracle Reports 6i, TOAD and SQL*Plus.
• Good exposure of ETL and Data warehousing concepts.
• Working knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables.
• Proficient in Oracle 11g/10g/9i/8i, PL/SQL Development Toad, PL/SQL Developer, Perl, UNIX, Korn Shell Scripting.
• Strong Experience in data Maintenance and Support which uses Oracle 9i database, SQL, PL/SQL, SQL* Loader in windows NT and Unix environment.
• Extensively used PL/SQL to built Oracle Packages, Stored Procedures, Functions, Triggers, Cursors, REF Cursors, Materialized Views and Views for processing data, enforcing referential integrity and needed business rules.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL, and Parallel Query.
• Involved in creating and maintaining partitioned Tables and Indexes.
• Performance Tuning, Optimization using TKPROF, AWR, ASH and Cost Based Optimizer
• Experience with FTP Protocol, System Analysis, Business Analysis, Documentation, Implementation, Telecommunications, Windows NT, HTTP, TCP/IP, UNIX.
• Strong working knowledge with EDI X12 HIPAA transactions 835 and 837.
• Highly Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent analytical, problem solving, communication and inter - personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/2003, Solaris 10, HP-UX 10/11, AIX 5.3, Linux

Programming languages: C, C++, Visual Basic 6.0, Java, PL/SQL programming

Web Technologies: HTML, JSP, XML, VB Script

Script Languages: Shell scripting, Perl, Awk

Tools: XRunner, Toad, PL/SQL Developer, Report Builder, Changeman DS, Tortoise, Service Center, Clear Quest, Star Team, Remedy, Putty, PVCS, CVS, VSS, Autosys, ORSYP, SQL Navigator, Microsoft Project

Database: Oracle 10g/9i/8i, MS Access 2000, Sybase, SQL SERVER 2005 and 2000, Data Ware house

Others: Object Oriented Designing Methodology, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle Developer

Responsibilities:

• Leading a team of 5 developers, assigning, advising and analysing work
• Working directly with Business Analyst and Product Owners to gather requirements
• Migrating data from Easy Labour Management to Work Force Now (WFN)
• Coding application components in an Agile environment utilizing a test driven development approach
• Designing process flow for migrating clients from easy labour manager to WFN2
• Attending daily scrum calls to share project status with Scrum master and team members
• Creating stored procedures, function, packages, triggers to implement business logic
• Preparing SQL*Loader script to load data from flat file & CSV to base tables
• Using external table to load data from flat file to base tables
• Developing new schemas and migrating data from old DB to new DB
• Adding data file to tablespace when short of space and tuned queries to improve performance and reviewing script to eliminate bottlenecks
• Analysing Statspack/AWR Reports to identify on-going/proactive issues and worked with Primary DBA to resolve it
• Utilising impdp & expdp to get production dump to FIT for debugging purpose
• Writing shell scripts and to schedule jobs in crontab

Confidential, San Francisco

Lead Oracle Developer

Responsibilities:

• Worked on complete SDLC(system development life cycle) including system analysis, high level design, detailed design, coding and testing.
• Translation of technical specifications, and/or logical and physical design into code for new or enhancement projects for internal clients.
• Develop new procedures and packages for new report requests and automate them.
• Database design changes for daily reports and ad hoc reporting needs.
• Developed PL/SQL procedures and functions for the data load process.
• Imported data into oracle database from flat files using Korn shell scripts
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding actual tables and to eliminate the complexity of the large queries
• Created complex queries using subquery, set operators, regular expression, pivot, analytical functions etc
• Created Materialized Views for reporting needs and to expose the data to downstream applications
• Used range, list and hash partitioning keys to partition large tables
• Used NDM to for inbound and outbound interfaces
• Fine tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Improve the performance of problematic modules by implementing performance tuning techniques in the database.
• Perform code review as well as design review and provide code approval for production implementation
• Created autosys scripts to automate batch jobs
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Daily data load monitoring, support, enhancement and tuning.
• Unit and Integration Testing of PL/SQL deliverables.
• Weekly status meetings with Business Analysts, Data Architects, QA and Production Support engineers.
• On-call support for scheduled production deployments.

Environment: Oracle 11g, PL/SQL, SVN, UNIX Shell Scripts, TOAD, Visio, Autosys, Perl

Confidential

Project Manager

Responsibilities:

• Extensively worked with clients to gather requirements and design needs.
• Took part in Technical and Business meetings on resourcing, deliverables and design.
• Assigned the work to onsite and offshore teams and completed scheduled deliveries.
• Instructed and guided the development team about deliverables and independent modules assigned.
• Ensured adherence to quality standards and review project deliverables.
• Delegated responsibilities, designed time schedules and crated project status report.
• Reported project status to management through graphs, charts and visual aids on a weekly and monthly basis.
• Conducted internal audit related to various projects for different teams so as to adhere to CMMI level 3 standards.

Environment: .Net Technologies, SQL SERVER, Unix, Java, Windows 7, TOAD, Visio, Microsoft Project.

Confidential

Senior Oracle Developer

Responsibilities:

• Working with Oracle databases to manage data for development, training and production environments.
• Worked on database design with the team.
• Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
• Used Sqlldr for loading the database tables with huge volumes of data from Old Schema.
• Involved into updating procedures, functions, triggers, and packages based on the change requests.
• Ran batch jobs for loading database tables from flat files using SQL*Loader.
• Creating materialized views for downstream application users to snap the data.
• Partitioned the table so as to improve the efficiency of the query.
• Trouble shooting production issues.

Environment: Oracle 10g/9i, SQL*Loader, Unix, Perl, Windows 7, SQL, PL/SQL, TOAD, Visio

Confidential

Sr Programmer Analyst

Responsibilities:

• Gathering the application model requirements from the UI developers for the new modules, and designing the logical and physical ER data models using ERWIN.
• Generating, modifying and forwarding of DDL scripts.
• Deploying the database applications with the defined standards, and providing database solutions for the Java application development.
• Developing database applications using SQL, PL/SQL, Materialized Views, Partitions etc. under Unix environment.
• Design and create the PL/SQL, SQL Loader and shell scripts for Data Conversion.

Environment: Oracle10g RAC, ERWIN, PL/SQL, TOAD, Unix, CVS

Confidential, San Francisco, CA

Senior Oracle Consultant

Responsibilities:

• Worked very closely with functional team to understand their Development related requirements and created FSD (Functional System Design Document) based on the requirement provided in BRD (Business Requirement Document) and translated service requests (SR).
• Created new procedures, tables and shell scripts for archiving the databases.
• Developed SQL Scripts and Procedures to load data into databases.
• Created test scenarios for the code developed and distributed across to QA and documented work flow of all process.
• Debugged and Fixed production fallouts.
• Provided database support and worked closely with the development team as they submitted daily changes recorded as releases to the production database.
• Altering the database Objects to synchronize it with the new database created.
• Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
• Used Sqlldr for loading the database tables with huge volumes of data.
• Involved into updating procedures, functions, triggers, and packages based on the change requests.
• Trained and mentored onsite and offshore team members.
• Writing PERL, UNIX Shell Scripts for processing incoming text files
• Import & Export database for validation and performance testing.

Environment: Oracle 10g, SQL, PL/SQL, SQL * Plus, Oracle Data warehouse, TOAD, SQL*Loader, import/export, UNIX (Solaris), Perl, Windows XP professional

Confidential, Lake Oswego, OR

Sr Pl/Sql Developer

Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Objects, Associative arrays, Records, Types, Materialized views etc.
• Created Procedures, Functions, Packages and Database Triggers.
• Developed SQL *Loader scripts, Conversion scripts for the conversion of the data to the custom new schema.
• Created the materialized views - Partitioned very large database tables using Hash partitioning to improve performance.
• Involved in the Data conversion and migration from the legacy system to the new Core Data Warehouse system.
• Creating Primary/Surrogate keys on the dimension tables.
• Developing ETL scripts for loading dimension tables and fact tables from transactional tables.
• Ran batch jobs for loading database tables from flat files using SQL*Loader.
• Performed validations on the imported data from legacy system before loading into interface tables using PL/SQL packages.
• Involved in Migration of data from 8i to 10g while up gradation.
• Developed and Tuned SQL, PL/SQL and stored procedures.
• Performance tuned SQL queries using parallel query and indexes hints.
• Used TKPROF and EXPLAIN PLAN extensively.
• Created indexes to improve the system performance.
• Bulk Collect was used to improve the performance of the program.
• Used UTL FILE to read the data and to generate a file that has to be sent to USERS.
• Developed test plans and test cases for user acceptance and unit testing.
• Wrote client-customized UNIX shell scripts to upload new data into tables for testing new customizations.
• Used AWK to manipulate data files before loading them to database.
• Developed PERL scripts to modify and parse data files as per the business needs.
• Debugged and fixed production fallouts due to code glitches.
• Extensive documentation of each module for user level and system level maintenance.

Environment: Oracle 10g / 8i, SQL, PL/SQL, SQL * Plus, Oracle Data warehouse, Data Mart, Oracle Bi/XML Publisher 5.6.2, Advanced Queuing/Streams, TOAD, SQL*Loader, import/export, UNIX (AIX 5.3), Perl, XML, Windows XP professional

Confidential, Jersey City, NJ

Sr Pl/Sql Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Configuring the data sources for database and data warehouses.
• Formatted, cleaned, Summarized, aggregated and transformed data into data warehouse.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Created custom partition tables for reporting.
• Worked on performance tuning and used Explain Plan, TKPROF for tuning the queries.
• External table was used to read flat files and populate database tables.
• Used Refcursors and Collections for accessing complex data resulted from joining of large number of tables.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Moved data from the old tables into the new tables using Sql*Loader
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Optimized existing queries for better performance and less impact on database.
• Used cursors and bulk collect extensively.
• Worked on Table Partition.
• Involved in the design and implementation of the process for loading the monthly loads coming from flat files in to staging tables in the Oracle Data base using SQL* Loader.
• Developed Technical Design documents according to Functional documents.
• Involved with QA team and reviewing their test cases and recommending changes if required

Environment: Oracle 10g / 9i, SQL, PL/SQL, SQL * Plus, Oracle Data warehouse, Data Mart, TOAD, SQL*Loader, import/export, UNIX (SunOS 5.10), Windows XP professional, HTML

Confidential

Quality Assurance Analyst

Responsibilities:

• Wrote test plan and test cases for web based project.
• Performed functional, UI, navigation, usability, integration, and Regression testing.
• Wrote SQL queries for Backend testing and data validation.
• Found and reported bugs.

Environment: Oracle 8i, Asp.Net, HTML, JavaScript, CSS, SQL server.