SUMMARY

• Over 8+ years of IT experience as application developer, Database design, Data ware house using oracle 12c/11g,SQL, PL/ SQL, Oracle Data Integration.
• Extensive experience wif e Business Suite/ Applications - Performing functional and technical work mainly wifin the Inventory (INV), Purchase Order (PO), Order Management (OM) and Account Payables (AP), Account Receivables(AR) ofOracle Applications 11i and R12.
• Experience in PLSQL - Functions, Stored Procedures, Cursors, Triggers and Packages.
• Experience in all phases of SDLC including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Experience in Database Performance Tuning, Performance Monitoring and Optimization usingOracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Proficient in advance features of PLSQL programming like Records and Collections, Bulk load, Bind variables, Ref Cursors and Dynamic SQL
• Good Knowledge on Client-Server application development usingOracle PL/ SQL,SQL *PLUS, TOAD andSQL *LOADER.
• Experience in designing, modelling, performance tuning and analysis, implementing process using ETL tool data Integration tool for data extraction, transformation and loading process.
• Good experience in UNIX and Perl scripts to create reports and logs based on the business prerequisites.
• Experienced in Troubleshooting and Maintenance of Database Objects
• Good experience in Test Case Preparation, Test Case Execution, Bug Reporting and Bug Fixing.
• Extensive experience of working in different environments like Unix and Windows.
• Worked extensively on PARTITIONS to enhance query performance.
• Worked in Agile Methodology.
• Worked on version control tools such as GitHub, Tortoise SVN and used JIRA bug tracking tool.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Experience in Back end Testing of the applications by executing complex SQLcommands in requirements gathering, functional gap analysis, application design, configuration, and module setup, test script generation, writing training guides, training end users, and production support.
• Good experience in working Onsite - Offshore Model.
• Self-motivated, flexible, proactive, responsive, goal oriented and rapid learner.
• Good team player wif excellent Communication, Presentation and Interpersonal skills.

TECHNICAL SKILLS

Languages: SOL, PL/SQL, UNIX Shell Script

RDBMS: Oracle MS SQL Server 2000, MySQL.

Development Tools: TOAD SQL Developer, SQL Navigator, SQL *Loader,Oracle EXP,Oracle IMP, ODBC, FTP, VSS, Ultra Edit, SQL*Plus, ERWIN,Oracle Warehouse Builder (OWB),Oracle

Enterprise Manager (OEM):

Operating Systems: Windows Linux, UNIX, Methodology/Best Practice Oracle CDM Advantage 2.0Database Management Database Design, Development & Maintenance

Scripting: Bash Shell, HTML, XML, SQL

PROFESSIONAL EXPERIENCE

Confidential, Kalamazoo MI

Sr. PL/ SQL Developer

Responsibilities:

• Worked wif the project Stakeholders and Users in understanding the Business requirements for the project.
• Planning development timelines, Tracking development status and delivering all deliverables on time.
• Participated in day to day agile processes like scrums and sprints.
• Design and DevelopOracle Packages, Functions, and Procedure and Postgres functions.
• Install Postgres and Clone Production databases to Lower environments.
• Participated in the Analysis phase, preparing the technical specification, Development and Testing documents.
• Ongoing proactive database-level performance tuning, wif a good working knowledge ofOracle internals.
• Responsible for System/Software upgrades configuration and responsible for Code reviews.
• Involved in User Acceptance testing and Post production support. Ensured that all defects are resolved by team wifin time.
• Trained interns wif System architecture, Project guidelines and Development processes.
• Build and maintainOracle PL/SQL packages and stored procedures (using TOAD and PL/SQL developer), Workflows, and SQR reports as requested by client, for Processing and Analysis.
• Used Ref cursors and Collections for accessing complex data through joining many tables.
• Extensively involved in Performing database, SQL's, API's tuning and optimization.
• Handled Exception extensively for the ease of debugging and displaying the error messages in the application.
• Coordinated wif front-end Developers for implementing logic in stored procedures and functions for faster retrieval of data.
• Improved the application performance significantly by tuning SQL Queries and PL/SQL program units.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexing and Partitioning of tables.
• Performed need based DBA activities like DB schema creating and maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.
• Interacting wif UI development team to Develop in tandem back-end solutions wif front-end web executions.
• Designed and developed the data migration Scripts and Programs to upgrade the Development, QA, UAT and Production DB schemas upgrade toOracle 12c fromOracle 11g in Development and Production Environments.
• Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.
• Worked as the Production support engineer for more TEMPthan 15 Universities.
• Developed test cases that were used in conjunction wif the Quality Assurance team to validate code.
• Interacted wif Business Users in creating Unit and System Test cases for enhancements in the existing application.
• Application support in resolving production problems for existing application and ensure all issues get resolved accordingly.
• Delivered tasks accurately in time provided.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL.
• DevelopedOracle partitions, and performance tuning/query tuning.
• Created ETL transformations and jobs usingOracle using dynamic packages and procedures usingOracle code.
• Used Git and Jira as our versions control and ticket submission tools.

Environment: Oracle 11g/12c, MongoDB, SQL, PL/SQL, TOAD,Oracle Developer, SQL *Loader, SQL *Plus.

Confidential, Plano TX

Oracle PL/SQL Developer

Responsibilities:

• Ensure conformance to code standards and documentation requirements.
• UsedDynamicSQL programming technique to build and process SQL statements.
• Worked wif the Business Analysts and Users in understanding the business requirements for the project.
• Building Conceptual, logical and Physical data model using Erwin Tools.
• Worked wif the Business Analysts and Users in understanding the business requirements for the project.
• Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Triggers, and Synonyms.
• Used TOAD,PL / SQL developer tools for faster application development.
• Constructed standard and materialized views for viewing and extracting usable data from various sources to get a clear real-time view of business-critical information
• Extensively involved in developingPL / SQL packages that includes advancedPL / SQL concepts like REF CURSOR, BULK COLLECTS, for all, etc.
• UsedSQL *Loader to load data from external system and developed PL/ SQL programs to dump the data form staging tables into base tables.
• Performed exception handling and analyzed table structures and integrity constraints for report-creation strategies.
• Production support for data fixes and debugging aborted processes.
• Extensively involved in Oracle query (SQL) tuning,PL / SQL execution optimization,
• Explain Plan, AWR reports,SQL Trace, TKROF, Stats Pack andSQL *PLUS Auto trace.
• Performed functional testing for the procedures and packages.
• Extensive use of UC4 in windows and Unix environment for scheduling routine tasks.
• Tested new enhancements and bug fixes before deployment into the production environment.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Involved Database Administration of database objects, including tables, clusters, Indexes, views, sequences, packages and procedures Troubleshoots wif regards to database problems and QA defects.
• Experience in creating ETL transformations and jobs using Pentaho and Pentaho.
• Data Integration Designer and scheduling them on Pentaho environment.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, Oracle Developer, SQL *Loader, SQL *PLUS, Linux, SQL Navigator, UC4. Unix shell scripting, Pentaho, Erwin.

Confidential - Houston, TX

PL /SQL Developer

Responsibilities:

• Experienced in Installing, configuring and maintaining multi node (2-node, 4-node) clusters running SQL Server 2008R2/2008 in Active/Active, Active/Passive and Active/Passive mode.
• Worked on invoking data base objects such as custom PL SQL packages, Functions, Procedures etc. from OAF.
• Reporting of status to project management. Coordinated component, system testing wif the appropriate technical groups and Release Management and documented test procedures and findings.
• Performed in configuring DR sites using Database Mirroring technology on SQL server 2008R2/2008/2005 wif a witness server or wifout witness server to configure automatic failover.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2005/2008/2008 R2 databases.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Involved in developing application using Java and PLSQL.
• Highly experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server.
• Have Hands on in Reports Creation and Generation through XML Publisher. Created and invoked workflows through PLSQL and OAF.
• Worked on invoking data base objects such as custom PLSQL packages, Functions, Procedures etc. from OAF.
• Creating ETL packages in SQL Integration services (SSIS) for various data loads and extracts from different types of sources like SQL Server, Text, CSV flat files.
• Analyze existing production data and create reports to help business to understand Market trends and inclinations.
• Develop SQL queries and PLSQL subprograms to pull the required data, format and generate the reports.
• Worked on installation, configuration and deployment of SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Performed in configuring DR sites using Database Mirroring technology on SQL server 2008R2/2008/2005 wif a witness server or wifout witness server to configure automatic failover.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2005/2008/2008 R2 databases.
• Highly experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server.
• Experience in logical & physical Data modeling, data architecture design, Normalization and De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema) using DM tools like ERWIN, Visio, SQL Diagrams.
• Managed the troubleshooting, planning and migration activities in line wif the company's requirements. Performed Database Integrity Checks.
• Updated Database Statistics and performed Re-indexing through Maintenance Plan.
• Managed the troubleshooting, planning and migration activities in line wif the company's requirements. Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Plan.
• NAS administration consists of data migration (Snapmirror and NDMPCopy), creating and maintaining CIFS, Quotas and DFS structure.
• Setup and Support the SAN and Backup environment that connects to (8) Brocade 4900 Switches. Exchange 2003, VM 4.0 and NBU 6.0 - Data Domain environments run on SAN . Netapp SAN
• Highly Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV'S.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Expertise in using tools like SQL profiler, windows performance monitor and performance counter for monitoring and tuning MS SQL Server performance, SCOM and OVPM.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS.
• Experience in configuring and managing Linked Server, Data transfer between SQL Server and other RDBMS.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more.
• Performed ETL mappings using MS SQL Server Integration Services 2008R2/2012.
• Developed complex SQL Queries, Joins, subqueries, correlated sub queries, Stored Procedures, functions, Joins, Constraints, DDL, DML and User Defined Functions wif best execution plan in SSMS to implement the business logic.
• Defined and Created databases, tables, Cluster/Non-Custer Index, Views, Unique/Check Constraints and Triggers using T- SQL in Development and Production environment.

Environment: SQL Server 2012/2008R2/2005 Enterprise, Windows Enterprise Server 2012/2008R2, T- SQL, SSIS, SSAS, SSRS, NetBackup and Spotlight.

Confidential - Waltham, MA

PL/SQL Developer

Responsibilities:

• Interacted wif Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.
• Involved wif Users for resolving Production issues related to the application.
• Involved in Production support for database and User Interface issues wifin that application.
• Analyzing the code to understand the transformation and business logic applied.
• Worked for CRDB (Credit Risk Database).
• Involved in analysis of the requirements wif business users in Coordinating and maintenance of source system owners.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in understanding of Data models and SRS/mappings documents.
• Created database views and Procedures based on requirements.
• Designing and executing the test scripts and test scenarios.
• Involved in developing detailed test plan, test cases and test scripts using PL/SQL.
• Experience in handling Checkpoints, Logging, Error handling by using Event Handler and
• Custom Logging for SSIS Packages.
• Experience in creating SSIS packages to automate the Import and Export data from SQL Server using SSIS tools like Import and Export wizard, Package Installation.
• Assisted in production of OLAP cubes in SSAS by writing queries in SQL to produce reportsUsing SSRS.
• Created various dashboards and reports using SSRS and Power BI for Data visualization.
• Performed data validation to check all business rules and requirements are met.
• Created unit test case scripts for easy testing and tracking. Created test scripts documentation for all the procedures.
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors.
• Worked on extending partitions for Production Database.
• Supported L2 team in case of batch issues or long running jobs.
• Had War Rooms wif business users after deploying the changes to UAT.
• Tested the data in UAT and used to check wif Business for Signoff.
• Responsible for creating the Change requests and prepare all the documentation required to move the code changes to production.
• Involved wif QA team while testing the data and helped them incase if they need any help.
• Participated in weekly status meetings to update the status of work.
• Used to understand the business from application level to work on the incidents.
• Worked as L3 lead for supporting the application and used to involve in meetings wif User's.
• Performance tuning of existingOracle forms as well as newly createdOracle forms using different built-in as well as User-defined functions and procedures.

Environment: SQL Server 2012/2008R2/2005 Enterprise, Windows Enterprise Server 2012/2008R2, PL- SQL, Oracle, Windows, Linux, SSIS, SSAS, SSRS, NetBackup and Spotlight

Confidential

PL SQL Developer

Responsibilities:

• Collaborated wif the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Created and managed many objects in largeOracle Databases containing millions of records.
• Coded and debugged the Stored Procedures, Packages, Views and Materialized Views inOracle Databases.
• Extensive use of SQL Query, Joining tables,SQL functions in Queries, PL/ SQL wif the use of Cursors, REF Cursors and loops.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, plans, profiling and Trace sessions for Cost based Optimization.
• Created database objects like tables, views, synonyms, indexes and sequences.
• UsedSQL *Loader and UTL FILE for moving the data from flat files to staging area tables.
• Developed PL/ SQL procedures and functions to migrate data betweenOracle Databases.
• Used shell scripting to change and modify data.
• OptimizedSQL statements and PL / SQL blocks by analyzing the execute plans and collecting statistics.
• Worked wif OLTP database.
• Created and modifiedOracle Database objects to make sure allSQL statements could be executed in the most efficient ways.
• Worked on ETL code conversion and DATA Stage in one of the Migration projects.
• Wrote PL/ SQL procedures to created database objects dynamically based on user inputs.
• Involved in Unit testing and Integration System testing.

Environment: Oracle 11g, PL/ SQL, TOAD,SQL Developer, Shell scripting (Bourne and Cron),SQL *loader,Oracle Forms 10g, reports 10g, Stored Procedures/Triggers

Confidential

Jr. PL SQL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL-SQL in Development and Production environment for SQL Server 2000.
• Actively participated in gathering of Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Worked on complex PL SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new PL SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Created Stored Procedures to transform the data and worked extensively in PL SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2008/2005, T-SQL, Microsoft Framework 2.0, Erwin, MS Visio.