SUMMARY

• Having 9plus years of experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications and Data warehouse environments using teh Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL. Good experience of Performance Analysis and SQL query tuning using Query Optimizer, Indexes, Hints, Explain Plan.
• Expertise in SQL and PL/SQL programming and strong Knowledge on Oracle Architecture and Database design.
• Worked on Oracle database servers 8i, 9i, 10g and11g.
• Strong working experience in use of SDLC methodologies like gathering teh Requirements, Data Analysis, Design, Development, Implementation and Testing of Data.
• Expertise in using tools such as TOAD, SQL developer, PL/SQL developer.
• Solid experience in Banking, Retail management system, HealthCare, Automotive and financial management system.
• Created Technical documentation of different lifecycle deliverables and user manuals.
• Extensively worked with various SQL scripts for relational databases.
• Expertise in all phases of teh Software Development Life Cycle. Worked 24*7 to provide production support while teh Project is in Production.
• Experience with Partitioning of Tables like Range and List Partitioning.
• Experience in teh usage of Autosys scheduler to schedule jobs/packages, workflows, and sessions.
• Experience in working with Data Warehouse Management System.
• Good knowledge on DBA issues like Storage, Space and Security issues.
• Experience in using several built - in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, and DBMS SQL to name a few.
• Experience in query optimization, performance, and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Collect, Creation of global temporary tables and table partitioning.
• Good knowledge in front end development using oracle forms/reports6i/9i/10g.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Experience in writing Technical design documents and developing unit test documents.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL, and SQL Loader.
• Expertise in loading data from legacy systems using SQL*Loader.
• Ability to learn and support new systems and applications.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Providing daily, weekly, and monthly status reports to managers.
• Exposure to Tableau to build Dashboards and to generate Reports.
• Great Team player with Strong interpersonal, communication and documentation skills and ability to collaborate well with others in teh team and with Business Users.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.x/7.x, Informatica Designer, Workflow Manager, Autosys, Star Schema, Snowflake Schema, OLTP, OLAP

Web Technology: HTML

Languages: PL/SQL, SQL, C, Java, UNIX Shell Scripting, VB6

Database: Oracle 8i/9i/10g/11g, My SQL, SQL server, Teradata, Oracle Reports and Forms 11g, Oracle APEX

Operating Systems: Windows 7/98/XP, UNIX

Tools: PL/SQL Developer, TOAD, SQL Loader, SQL *PLUS, MS Visual Studio, Informatica Power Center

PROFESSIONAL EXPERIENCE

Confidential, DETRIOT, MI

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coordinated with ONSTAR business users to better understand teh new requirements and documented teh needs of Users.
• Worked on Mobile Application for ONSTAR and supported teh Customers of any issues.
• Reported any Production outages with Mobile App, Login and Telemetry Partners.
• Created database objects like Tables, Stored Procedures, Functions, Packages using SQL and PL/SQL.
• Loaded teh data from files into database tables using SQL*loader.
• Worked on multiple SQL queries to analyze teh Business data and needs.
• Used Database links to pull teh data from other Databases.
• Created and worked on Cognos Reports and schedule them to run daily.
• Worked on Autosys Job scheduler for automating teh daily jobs in UAT and Production environment.
• Created new jobs in Autosys and deployed in teh Production using teh help of support team.
• Worked on UNIX shell scripting for creating new JIL files and Autosys jobs.
• Worked on Tableau reporting to build dashboards, charts for teh daily activities and to teh needs of Business.
• Worked on Tuning of teh SQL queries taking long time to process teh data, checked Explain Plan and added Hints like Parallel, Index, materialize to reduce teh response time.
• Involved in updating teh procedures, functions and loading of data into target table based on teh current requirement.
• Worked on UNIX for rerunning teh failed jobs in Autosys.
• Created indexes on tables for faster retrieval of teh data to enhance database performance.
• Gave Technical Training Sessions on UNIX, Autosys and Oracle PL/SQL to fellow team members.
• Tested teh data in UAT and supported teh team while teh project is in Production.
• Worked with DBA in case of any issues with Data Lag in Production, Tablespaces and supported teh team in case of assistance.
• Participated in daily status meeting to update teh Production Outages related to Mobile App and Telemetry.
• Attended weekly meetings on Advisor calls for providing better customer experiences.

Environment: Oracle 11g, SQL Developer, PL/SQL, SQL*LOADER, UNIX, Autosys Job Scheduler, Tableau Reporting, Windows 7.

Confidential, CHARLOTTE, NC

Software Developer

Responsibilities:

• Involved in meetings with Manager and Team members for discussing ongoing issues.
• Worked as L3 support system for ongoing production issues.
• Worked on Autosys for running jobs to load teh data daily from production to our database.
• Developed Complex database objects like Stored Procedures using SQL and PL/SQL.
• Documented teh new requirements in teh project and presented with teh team.
• Created Tables, Indexes and Views.
• Tuned SQL performance by checking explain plan and rewriting SQL statements.
• Worked on Unix to run jobs daily based on business requirements.
• Provided support for Production issues and during releases.
• Used Autosys job scheduler for automating teh daily regular run of DW cycle in Test and UAT environments.
• Involved in configuring and working on Team Foundation Server to provide teh source code management and project management in agile technologies.
• Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
• Interacted with other team members for issues in production and ran jobs based on batches.
• Looked for failed jobs in Unix and reran teh jobs by checking teh cause of failure.
• Worked with DBA in case of any issues with storage issues.

Environment: Oracle 11g/10g, SQL, PL/SQL, UNIX, AUTOSYS, SQL*LOADER, PL/SQL Developer tool, Windows 7.

Confidential, MIAMI, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coordinated with teh business users to better understand teh requirements of Brands (CCL, CAU, PCL, HAL, COS) coming from various ships and documented teh needs of Users.
• Visited teh Ships to check teh errors in Casino Machines and used it for testing.
• Involved in logical modeling and physical modeling of application.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Created TABLES, INDEXES, SEQUENCES.
• Created database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Worked on SQL queries to query and analyze teh data.
• Used Database links to get teh data from Brands Data Warehouse.
• Created Views and Materialized Views for Tableau developers to develop Tableau reports.
• Worked on Complex queries to tune teh performance of it.
• Worked on Hints to optimize teh queries.
• Created and modified Materialized Views to refresh On Demand.
• Used Oracle Job scheduler for automating teh daily jobs in UAT and Production environment.
• Used Analytical functions like LAG, LEAD, FIRST VALUE, and LAST VALUE.
• Worked on Tableau reporting to build reports, charts for teh Confidential Ships.
• Worked on Tuning of teh SQL queries taking long time to process teh request, checked Explain Plans and added Hints to reduce teh response time.
• Worked on PIVOT and UNPIVOT functions to Organize data from Rows to Columns and vice- versa.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on teh current requirement.
• Created indexes on teh tables for faster retrieval of teh data to enhance database performance.
• Used SQL Loader to load teh data from very huge files.
• Created jobs using Oracle Scheduler and resolved teh issues caused by Scheduler.
• Involved in teh continuous enhancements of Ships requirements and fixing any production issues.
• Used Merge Statement for Merging DML data with history data.
• Used External Tables to Load huge Data Files.
• Created Test cases for Unit Test, System Test and Integration Test to check teh data quality.
• Used Hyperion to extract teh queries and to export teh data.
• Worked on Visual Basic for building reports on Anti-Money Laundering.
• Gave Technical Training Sessions in UNIX and Oracle PL/SQL to fellow team members.
• Worked on Tableau reporting dashboards to check Users requirement.
• Created views and provided teh data for users by using them.
• Participated in weekly status meetings to update teh status of work.
• Worked with DBA in case of any issues with Tablespaces and supporting teh team in case of assistance.
• Tested teh data in UAT and supported teh team while teh project is in Production.

Environment: Oracle 11g, SQL Developer, PL/SQL, SQL*LOADER, PL/SQL Developer tool, Oracle Job Scheduler, Tableau Reporting, Business Intelligence Development Studio (BIDS), Windows 7.

Confidential, RALEIGH, NC

PRODUCTION SUPPORT/DATA ANALYST

Responsibilities:

• Supported L2, L3 teams for any Production issues in a Database.
• Coordinated with teh business users to better understand teh requirements and document their expectations, handling teh current process, modifying and created teh jobs to teh updated requirements, handle teh load process to data mart and eventually data warehouse.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created External Tables, Joins, Indexes, and sequences.
• Experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on teh current requirement.
• Designed and developed various custom packages triggers and forms.
• Used Autosys job scheduler for automating teh daily regular run of DW cycle in UAT environments.
• Created SQL*plus reports as per client's various needs and developed business objects.
• Worked on Tuning of teh SQL queries, which takes long time to process teh request using Explain Plans to reduce teh response time.
• Extensively worked in performance tuning of programs, ETL procedures and processes. Also used debugger to troubleshoot logical errors.
• Experience with Parallel Processing database like MPP.
• Reviewed peer codes and documented proof of concepts and database schemas.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Supported QA activities, test plans and performance enhancement techniques.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues

Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, SQL*LOADER, PL/SQL Developer tool, Windows 7.

Confidential, CHARLOTTE, NC

Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering requirements from Business Users, used to have meetings with them.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created User Schemas, TABLES, INDEXES, SEQUENCES, and VIEWS.
• Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator,Normalizer and joiner.
• Created ETL Procedures for more than 300+ tables and views on top of these tables.
• Tuned performance by exploiting teh Oracle’s new built-in functions and rewriting SQL statements.
• Used Informatica Power Center to create and build mappings for getting teh data from Flat files and other database tables.
• Involved in configuring and working Team Foundation Server (TFS) to provide teh source code management and project management in agile technologies.
• Used Scrambled and Unscrambled functions to Encrypt and Decrypt teh sensitive data.
• Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
• Analyzing teh code written by different developers to understand teh transformation applied on columns to document them.
• Tested teh data in UAT and supported teh team while teh project is in Production.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, SQL, PLSQL, UNIX, AUTOSYS, SQL*LOADER, Toad, PL/SQL Developer tool, Flat Files, Windows 7.

Confidential, MINNEAPOLIS, MN

Oracle PL/SQL Developer

Responsibilities

• Involved in gathering user requirements and reporting requirements for a better understanding of teh business process.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created Indexes on teh columns to tune teh performance.
• Extensively worked with Oracle Reports, also created new Reports as per User Requirement.
• Interacted with Customers who use Reports in case if they seek any help.
• Made modifications to existing Oracle Reports as per teh requirement.
• Analyzed data, designed, and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Coded, tested, and troubleshot software applications.
• Conducted unit testing and maintained data extractions and object models.
• Tested teh Forms, debugged and fixed teh Forms after teh testing.
• Worked on Oracle Forms and Reports as per document provided by user.
• Programed in UNIX shell scripts to provide a user interface to Oracle forms and reports.
• Created Reports in PDF, XML and Excel format as per teh Requirement provided by teh User.
• Worked with Paper Parameter form, Paper Layout's on Oracle Reports.
• Involved in doing Unit Testing for teh Packages created.

Environment-Oracle 11g, Oracle Reports and Forms 11g, SQL, PL/SQL, SQL Navigator, Windows XP/7, Service Now.

Confidential, TAMPA, FL

Oracle PL/SQL Developer

Responsibilities

• Gatheird user requirements and reporting requirements for a better understanding of teh business process and teh current reporting system.
• Interacted with Business users to check regarding requirement issues.
• Created Tables, Indexes, Views, Triggers.
• Worked on Stored Packages, Procedures, Functions and Triggers using SQL and PL/SQL.
• Coordinated with DBAs to make teh daily loads run much faster by tuning different aspects of teh load jobs.
• Developed Packages in PL/SQL Developer tool and Toad.
• Provided production support for multiple projects.
• Worked on Hints to improve teh performance of a query.
• Worked for ICD 10 Project to differentiate between ICD 9 and ICD 10, as per teh requirements provided by Business.
• Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator,Normalizer and joiner.
• Worked on building mappings using ETL to load teh data from other database tables.
• Worked on Router, Joiner, Lookup transformations.
• Created some oracle objects for OLAP.
• Formulated oracle process, data retrieval methods and SQL code blocks.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Involved in projects related to Data Integration and Data Migration.
• Involved in doing Unit Testing for teh development which I have done.
• Involved in configuring and working Team Foundation Server (TFS) to provide teh source code management and project management in agile technologies.
• Experience in teh usage of Autosys scheduler to run Packages and Informatica sessions.
• Used Function-based Indexes in PL/SQL Packages to increase teh performance of Package.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Supported QA people while testing teh Data provided by our team.

Environment - TOAD, PL/SQL Developer, Windows XP/7, UNIX, Oracle 11g, Informatica Power Center 9.1.

Confidential

Data Analyst

Responsibilities

• Interacted with Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.
• Experience in working with Technical specification document after getting approvals of BRD's from Business users.
• Analyzed teh data files to better know teh business.
• Creating Tables, Indexes, Views.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Developed database objects like Stored Procedures, Functions, and Packages using PL/SQL.
• Worked along with teh DBA to resolve performance and tuning issues.
• Experience in teh usage of Autosys scheduler in order to schedule workflows and sessions.
• Used different partitioning options for better performance.
• Involved in doing Unit Testing, Integration Testing and System Testing.
• Assist in QA and UAT testing and also involved in Production support.

Environment -Oracle 10g, Windows XP, SQL Loader, SQL * Plus, MS Visual Studio, TFS.