CAREER SUMMARY:

• 8 Years of Experience in the field of Software Design, Development and Implementation with proficiency in Oracle 10g, 11gR1 and 11gR2, SQL, PL/SQL that includes complete System Development Life Cycle from Analysis and Design to Implementation
• Involved in multiple projects covering all the areas of Software Development Life Cycle (SDLC) including Requirements Analysis, Application Design, Technical Design, Development, Testing & Debugging along with Deployment, Documentation and in corporation of user feedback to plan enhancement in the Application system
• Experience in Java, Web Services, JavaScript programming
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle
• Experience in writing unit testing documents for all code & experienced with detailed data analysis
• Worked with query tools like Toad, SQL*Plus, SQL Developer
• Able to conceptualize complex issues and develop complex processes, procedures and solutions
• Exposure to concepts of Data warehouse Design, Data Modeling, ETL Design, Development and Reporting
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD
• Experience in Performance Tuning & Optimization of SQL statements
• Experience in Golden Gate Replication
• Experience in Oracle SQL Design, Development & Oracle 11g Features
• Experience in identifying Business and Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications
• Hands on experience in AJAX, JQuery, writing and troubleshooting complex routines in JavaScript
• Strong in writing Stored Procedures and SQL queries to different databases and schemas
• Involved in Data Modeling and Data Mart
• Ability to apply analytical skills, and produce thoughtful and strategic recommendations for ultimate presentation to the customer
• Good understanding on HIPAA compliance regulations
• Good understanding of the Oracle database, related utilities and tools
• Experience working in a high performance, high volume, high availability systems development environment
• Experience working in a distributed development team
• Hands on experience in tracking down the bottlenecks in query using trace files
• Participated in all Business Intelligence activities related to data warehouse, ETL and report development methodology
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Responsibilities:

• Involved in Coverage Review Communication compliance system analysis design, coding, data conversions, development and implementation
• Developed PL/SQL Packages, Procedures, Functions and Triggers, cursors accordance with Business requirements for loading static data into database tables
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Modified existing packages, procedures, functions and triggers according to the new business requirements
• Updated packages, stored procedures, functions, tables, databases in Oracle Server
• Created flat files through PL/SQL procedure in various data output formats
• Reviewed the design specifications, ensure completeness of design, development of PL/SQL
• Interacted and coordinated with various application teams for resolving issues, patch movements
• Developed Test cases for Unit testing, Created Indexes, Views and Tables
• Performed unit and integration testing for the front end application
• Created materialized views like primary key, row id, and sub query materialized views
• Supported development, pre - production and the production databases
• Generated Dynamic SQL’s
• Implemented Golden Gate Replication on PMR tables
• Involved in generating reports and forms using Oracle Developer 11g R1
• Altered the procedures and functions according new business requirement
• Coordinated with various application teams for resolving issues, patch movements
• Performed performance tuning using Explain Plan, Hints the newly generated scripts
• Tuned SQL queries manually by Explain plan
• Involved in handling the changes in compiling scripts according to the database changes
• Involved in system analysis design, coding, data conversions, development and implementation
• Modified the existing packages, procedures, functions and triggers according to the new business requirements
• Fixed bugs in Oracle Server for a bug free application
• Migrated the code from one database to the other environments
• Created flat files through PL/SQL procedure in various data output formats
• Fixed issues in the application
• Implemented Golden Gate Replication on Service tracking tables
• Developed PL/SQL scripts for data processing
• Worked on APEX forms to all CTE in one place
• Involved in Developing and Generating Reports
• Involved in designing and developing the Extraction, Transformation, and Loading (ETL) program to move data from source to target

Environment: Oracle11gR1, WINDOWS7, PL/SQL developer, MS Visio, ALM, Remedy, HP Tools.

Confidential, NY

Responsibilities:

• Involved in system analysis design, coding, data conversions, development and implementation
• Hands on experience on SQL loader and TOAD
• Modifying existing packages, procedures, functions and triggers according to the new business requirements
• Fixing bugs in Oracle Server for a bug free application
• Experience in migrating the code from one database to the other environments like Teat and UAT
• Created flat files through PL/SQL procedure in various data output formats
• Solving and fixing issues or defects in the application
• Interaction and coordination with various application teams for resolving issues, patch movements
• Responsible to document major design decisions
• Wrote stored PL/SQL Procedures for reports
• Worked on data mart’s & data modeling
• Implemented Golden Gate Replication on Service tracking tables
• Developed PL/SQL scripts for data processing
• Created Indexes, Views and Tables
• Working on APEX forms to all CTE in one place
• Unit testing the complex data loaded and METRICs
• Working with Macys and Kroger requirements individually to meet their individual requirements
• Experience in working with Business Intelligence tool (Enterprise Guide) Software for analytical tasks
• Involved in Developing and Generating Reports
• Involved in designing and developing the Extraction, Transformation, and Loading (ETL) program to move data from source to target

Environment: Oracle11gR1, WINDOWS7, PL/SQLdeveloper, Tortoise SVN, Bugzilla, COGNOS, beyond compare3.

Confidential, NY

Responsibilities:

• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules
• Extensively worked on Schema Migration, Database Program Migration, and Data Migration from Sybase to Oracle by using Oracle SQL Developer
• Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS PROFILER, and Hints etc.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect
• Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading in the PL/SQL Packages
• Worked with the SQL development team to assist with high level design and detail design activities for multiple data solutions
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day
• Worked on Table partitioning and Index creation to improve the performance of the query
• Worked with DBA's regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process
• Facilitate timely approval of major milestones, approvals and signoff
• Report the project status and generate milestone reports
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus
• Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project's success
• Created a risk plan and list all the mitigations
• Facilitate and document the post implementation results in the form of closure reports
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL
• Participate in requirements review, application design review and test plan reviews

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL * Plus, TOAD, SQL*Loader, Shell Scripts, SQL Plus, SQL Developer, UNIX.

Confidential, NJ

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project
• Gathered the requirements from the users and analyzed their business needs and created SRS documents
• Involved in SDLC including designing, coding and testing
• Writing Technical design documentation
• SQL tuning of queries
• Complex queries like inline views and Sub queries
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, SQL Developer, PL/SQL and TOAD
• Defined database requirements and designed data model
• Extensively used Dynamic SQL for calling procedures
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries
• Running explain plan for tuning the SQL queries
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Applying constraints and writing triggers to apply the business rules
• Involved in handling errors and transaction processing in the procedures
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader
• Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers
• Created Indexes for faster retrieval of the customer information and enhance the database performance
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users
• Transformed complex business rules to Oracle PL/SQL
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables
• Building UNIX shell scripts for data migration and batch processing

Environment: Oracle 11g/10g, PL/SQL, Oracle Forms 10g, Reports10g, SQL Navigator, UNIX, Windows XP, SQL Developer, PLSQL Developer.

Confidential, GA

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users
• Responsible for Analyzing requirements, designing, maintaining and updating data models
• Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system
• Developed stored procedures to pull the data from the distributed systems
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN
• Developed and implemented complex data models and logical database designs
• Involved in unit testing and integrated testing
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing
• Defined database requirements and designed data model
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables
• Involved in importing the production data to work environment through TOAD
• Involved in handling the changes in compiling scripts according to the database changes

Environment: Oracle 10g, UNIX Shell Scripts, PL/SQL, Toad, PL/SQL Developer, SQL Optimizer, Putty.

Confidential, NY

Responsibilities:

• Responsible for system study & information gathering
• Development was done using front end as Oracle Pl/SQL Developer/2000
• Involved in creation of Tables using storage parameters and clusters
• Involved in writing Database procedures, Functions, Packages and Database Triggers
• Coded many generic routines (as functions), which could be called from other procedures
• Developed user interface screens, Master detail relations and Report screens
• Analyzing and upgrading Oracle Reports
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company
• Integrated the mailing system to alert various group on the status of data pulls and data processing
• Conducted training sessions to end-users

Environment: Oracle 9i, PL/SQL, SQL Loader, Shell Scripting, MS Visio, JavaScript, HTML, CSS.

Confidential, Sacramento, CA

Responsibilities:

• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows
• Designed reports that had complex SQL, PL/SQL code and stored the procedures
• The filter conditions for the Queries were dynamic in nature and included lexical parameters
• Responsible for coding and modifications to enforce business rules and to improve performance of the system
• Fined tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans

Environment: Oracle 8i, SQL*Plus, IBM Web Sphere 6.1, MS Visio, JavaScript, HTML, CSS, Windows 2000.

Confidential

Responsibilities:

• Involved in creation of Tables using storage parameters and clusters
• Coded many generic routines (as functions), which could be called from other procedures
• Developed user interface screens, Master detail relations and Report screens
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company
• Created user defined Exceptions while handling exceptions
• Wrote stored procedures, Functions and Database triggers using PL/SQL
• Conducted training sessions for the end-users
• Involved in system analysis, development, documentation and implementation of the inventory and payroll system
• Involved in Report design and creation in Crystal Reports
• Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements
• Created scripts to trigger nightly batch processes
• Involved in Developing and Generating Reports
• OLTP environment experience
• Preparing Unit test scripts, setting up a test environment and unit testing the code
• Tuning of the SQL statements for application developers

Environment: Oracle 8i, SQL*Plus, Windows 2000.