SUMMARY

• 10 Years of experience in the Information Technology with extensive experience in Database development, RDBMS based application, Requirement gathering and analysis, Unit Testing and monitoring, Documentation and technical support.
• Have experience in data Extraction, Loading and Transformation in data ware house environment.
• Worked with users oncreating Purchase Requisition for tax products.
• Worked onOraclee - BusinessTax module to Defined tax rules for exemptions and exceptions
• Worked in analyzing existing standards and conversion needs to develop E-business modules.
• Interacted with end users and functional architects for mapping the legacy data to the Oracle tables.
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
• Developed packages, scenarios using interfaces and variables.
• Good knowledge about Topology, Designer, Operator in Oracle Data Integrator.
• Ability to work individually as well as in a team with excellent problem solving skills.
• Knowledge on data ware housing concepts like schemas and approaches.
• Experienced as an Oracle developer in large production environments and database implementation on UNIX and Windows.
• Good knowledge in Unix and Shell Scripting
• Experienced in agile and waterfall environment.
• Experienced in Developing PL/SQL - Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
• Extensive knowledge in developing PL/SQL codes using Oracle 11g.
• Experienced user of PL/SQL for development of server-end program units as well as reusable codes using Procedures and functions.
• Experienced in developing UNIX Shell Scripts and PERL Scripts to execute scripts and manipulate files and directories.
• Experienced in scheduling jobs using Autosys and Crontab and monitoring the batch processing.
• Experienced in writing SQL queries creating different kinds of reports from large scale database.
• Extensively worked with creation of Data Objects such as tables, views, synonyms, sequences materialized views, stored procedures, user defined functions, database triggers and indexes.
• Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Experienced in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Experienced in migration of database from SQL Server 2000 to Oracle 10g.
• Translated T-SQL procedures, functions and views into Oracle’s PL/SQL Packages, Procedure, Functions and Views.
• Extensive Knowledge and Experience in ETL tools like SQL Loader, DTS packages to transfer the data between different databases.
• Extensive Knowledge and Experience in Data Analysis and managing Data warehouse and Data marts.
• Extensive Knowledge in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
• Used Erwin tool for data modeling and MS Visio to create flow charts for process flow.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Experienced in providing technical and non technical Production Support.
• Involved in preparing SQL and PL/SQL coding convention and standards.
• Involved in preparing functional specifications, technical documentation, schema documents, flow charts and user support documents.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12.10, MS-Access, DB2, MS SQL Server 2000/2005/2008 , MySql

Operating System: Windows 98/XP, UNIX, MS Windows 2000/2003, MAC OS 8

Languages: PL/SQL, T-SQL, HTML, XML, UNIX shell script, C

Tools: / Utilities: SQL*Plus, PL/SQL Developer, TOAD, Visual Studio, Putty, SQL*LOADER, SQL navigator, 11i Forms and ReportsEBS 12.2, CVS, Oracle APEX, HTML DB, Python, DTS Package, VI Editor, Erwin, XML, NDM, Autosys 4.5/4.5.1, WinSCP, MS Excel, APEX\MS Project, MS Visio, Putty, SCM, SVN, ECL IDE, SQL YOG, Oracle VM .

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked in Agile Scrum team dealing with daily stand ups, sprint planning, mid sprint review.
• Worked on Jira for maintaining and reporting work status.
• Presented demos to the business users to display enhancements before the deployment.
• Worked on creating packages, procedures, functions applying the business logic to update the database.
• Worked on SVN to create deployment scripts for promoting the code to future environments.
• Coordinated with the Back Office system team i.e. BOS QA team to generate the XML's based upon the account criteria.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Mergeandunion all.
• Developing reports onSSRSon SQL Server ( 2000/2005/2008 ). Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Great ability to create and manage various database objects liketables, views.
• Worked on implementing optimizers to tune the queries for better performance.
• Worked providing data to generate reports for QLIK.
• Worked on building queries for data comparisons among different applications.
• Worked on ad hoc requests to provide support for testing and UI needs.
• Developed solutions to support the business and to enhance functionality based on business requirements
• Work closely with the business and others developers to develop new solutions and extend the functionality of Pulse application.
• Follow established SDLC process for code development through code release and support
• Worked on creating views for generating reports for past and current year’s data.
• Developed scripts to create tables, views, indexes and sequences.
• Created functional document, user document, process flow diagram and flow charts.
• Worked on gathering requirements, design, development, analysis, testing and deployment of Pulse application for reporting purpose.

Environment: Oracle 12.10,, PL/SQL, SQL*Plus,, TOAD, UNIX, Shell Scripts, MS Office, MS Visio, Windows 2000, Jira, ALM, Jenkins, Qlik.

Confidential, Atlanta GA

Sr. PL/SQL Programmer Lead

Responsibilities:

• Lead a team of 5 in all stages of software development lifecycle.
• Interface with other technical personnel or team members to finalize requirements.
• Write and review portions of detailed specifications for the development of system components of moderate complexity.
• Work closely with other development team members to understand moderately complex product requirements and translate them into software designs. Successfully implement development processes, coding best practices, and code reviews.
• Operate in various development environments (Agile, Waterfall, etc.) while collaborating with key stakeholders.
• Work on database query tuning, performance tuning,
• Work on various oracle functionalities like indexes, hints, explain-plan, Partitions, Clusters.
• Keep abreast of new technology developments.
• Complete bug fixes.
• Performed unit testing and supported integration testing and end user testing.
• Work with MySQL database to generate data for ECL queries.
• Write ECL queries to obtain the desired results.
• Manipulate data using ECL code.
• Create views with complex functions for application team usage
• Create necessary software documentation
• Work on store procedures, functions, triggers, cursors and collections for meeting the data requirements.
• Developed Scripts for Oracle tables, views and sequences.
• Validating existing data against given requirements, generating data exception report and sending it back to business teams for correction. Loading of corrected data from excel to staging tables Involved in regular code inspection and optimizing code.
• Involved in Data modeling activities.
• Worked on Ad hoc Request

Environment: Oracle 11g, PL/SQL, TOAD, Explain Plan, Hpcc systems, SQL, MS- Office, UNIX, MS Office,, Windows 2000, Sql Yog, ECL IDE, ECL watch, Oracle VM, Quick base.

Confidential, Atlanta, GA

Sr. PL/SQL Programmer

Responsibilities:

• Generated SQL and PL/SQL scripts to install building database objects such as tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created complex functions, stored procedures and packages by using PL/SQL.
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
• Wrote several Korn Shell Scripts for deploying code to the next environment and handle errors.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Validate outgoing XML messages.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Worked with Toad for Oracle for creation of database objects, packages, stored procedures, functions and triggers for Oracle OLTP & OLAP databases.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on various tables to create Indexes to improve query performance.
• Worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Involved in Dimensional modeling and developed the star and snowflake schemas.
• Designed and developed complex reports to meet end user requirements and deployed.
• Developed complex triggers in reports before/after for validation of user input.
• Performed unit testing and supported integration testing and end user testing.
• Validating existing data against given requirements, generating data exception report and sending it back to business teams for correction. Loading of corrected data from excel to staging tables Involved in regular code inspection and optimizing code.
• Involved in Data modeling activities.
• Worked on Adhoc Request

Environment: Oracle 11g, SQL, PL/SQL,SQL Loader, TOAD, XML Explain Plan, MS- Office, UNIX, Shell Scripts, MS Office, MS Visio, Windows 2000

Confidential, Atlanta, GA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Was a part of an Agile Scrum team dealing with daily build.
• Worked on Jira for maintaining and reporting work status.
• Worked directly with application team and product for working on User stories.
• Worked on gathering requirements, design, development, analysis, testing and deployment of Virtual Merchant application.
• Worked with business users and prepared the program specification and design document for the development of the Virtual Merchant Application.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the database.
• Worked on partitioning of tables to accommodate large volume of data and faster data retrieval.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Developed scripts to create tables, views, indexes and sequences.
• Created custom tables to import the Merchant data and insert into the Virtual Merchant Database.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Extensively used SQL Loader in Migration of the data from the previous Virtual Merchant database in SQL Server database to Oracle 11g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Created the test scripts and complex queries to test the application and to assurance the quality of the data.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 11.2/11.1/10 g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Visual SourceSafe, FTP, DTS package, MS- Office, UNIX, Shell Scripts, MS Office, MS Visio, Windows 2000, Jira, Confluence, RQM.

Confidential

Pl/Sql Developer

Responsibilities:

• Involved in requirement gathering from functional team and creating stored PL/SQLPackages, Procedures, functions and Triggers.
• Worked on manipulation of master data from SAP R/3 UI.
• Involved in integration of data from source systems to calculate the buffers and PO’s to supply the finished good to distribution centers on demand During NFL season and all the sports events.
• Integration of data from source systems to calculate the buffers and PO’s to supply the finished good to distribution centers on demand During NFL season and all the sports events.
• Involved in creating stored Procedures, PL/SQL Packages, Triggers, functions, ref cursors, LOBs, Collections, Varrays, Index by table, Bulk Collect, for all various oracle dbms utilities to implement the business logic.
• Involved in Data integration through the batch jobs performed by Autosys.
• Involved in accumulating required data from different systems and through the batch jobs in Autosys to calculate the buffers and PO’s.
• Involved in database query tuning performance tuning using various oracle functionalities like indexes, hints, explain-plan, Partitions, Clusters.
• Experience to maintain Development, QA, UAT Database environments.
• Performed exception handling for data that did not conform to the required format.
• Implemented oracle methodologies indexes, partitions and hints to optimize performance of database shell scripts to automate loading files into database using Autosys, error handling andnotification.
• Support for the development, pre-production and the production databases.
• Provided support for Informatica failures and manually execution of workflows.
• Designed New Batch jobs and worked in Batch processing.
• Used TOAD 10.6 to develop database objects.
• Changing the logic and enhancement at mapping as per the requirement.
• Unit testing of the developed module and deployment of respective work.

Environment: Oracle 11g, SQL, PL/SQL, Toad 10.6, Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Visual SourceSafe, FTP, DTS package, MS- Office, UNIX, Shell Scripts, MS Office, MS Visio, Windows 2000.

Confidential

Oracle Developer

Responsibilities:

• Prepared program Specification development of PL/SQL package, procedure and functions as required by the business users
• Migration of the existing SQL Server procedures, function and DB Objects into Oracle PL/SQL Packages, Procedures, Functions and DB Objects.
• Created and maintained records within the company's database management software.
• Developed Scripts for Oracle tables, views and sequences.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Applied optimizer hints to tune the queries for faster performances.
• Modifying the procedures, functions and DB Objects with respect to the business requirements.
• Involved in preparing the PL/SQL coding standard and guidelines.
• Created Reports using complex SQL queries for the Business Process.
• Designed and developed the data's pre-staging and staging mechanism.
• Created Staging Tables to handle the import data.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Wrote Procedures and functions for the validation of input data and to implement business rules.
• Performed Unit Testing and Integration Testing of the application.
• Involved in preparing documentation and user support documents.

Environment: Oracle 10g, SQL Server 2000/2005, PL/SQL, T-SQL, SQL* Loader, TOAD, Visual Studio, Visual Studio, C#, ASP.Net,, MS- Office, Crystal Report 9.0, MS-project, Windows XP, Windows 2000