SUMMARY

• 7 years of IT Experience as Oracle Developer for System Analysis, Designing, Development Testing & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments.
• Expert in creating complex SQL Queries, Sub Queries, Hierarchal Queries, PL/SQL Packages, Cursors, Functions, Stored procedures, Triggers, Exception handling, transaction control and xml generation. Created database objects using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Excellent working knowledge of Oracle database architecture (column orientation, projections, pivoting, segmentations, partitions, high availability and recovery, security)
• Implementation experience in relational and dimensional modeling, star/snowflake schema
• Use of Analytical and Aggregate functions for performing various operations in SQL.
• Make use of Oracle Data Pump wizard. Work on export and import utilities.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Use efficient Joins, Indexes, bulk operations, materialized views for Query Optimization.
• Using Explain Plan to analyze tables and apply Oracle hints for Performance Tuning.
• Working knowledge on Data replication, Data Integration, High Availability, Master Data Management and Data Governance
• Proven experience architecting, designing and implementing low latency near real time systems and working with 50+ TB data sets.
• Use of Jil files and applyIM to install changes in development and production environment.
• Use of Oracle golden gate for migrating the data from MDM to CDE.
• Must have proven experience with ETL technologies and large data movements techniqueshave Change Data Capture (CDC) and data integration expertise
• Adopted agile methodologies and involve in the daily scrum meeting. Work on sprint created by scrum master in JIRA.
• Extensively use Unix Shell Scripting for creating scripts to call Oracle stored procedures and functions. Use grep, find, awk, sed commands for analyzing and doing operations on various files.
• Scheduling Data integration job using Autosys and Control - M.
• Strong experience in Data Modeling. Use Toad data modeler 3.x to design LDM and PDM.
• Worked on Oracle Database Upgrade and SQL Server decommission.
• Extensively use of Macros in Excel.
• Worked extensively on Stash, Team Foundation Server and clear case for version control and merging code from development to master.
• Documentation of projects for Business Requirement Spec(BRS), Functional Requirement Spec (FRS), Use case Spec, DFDs, Test Plan, Test Script & Test Cases.
• Extensive experience with all phases of the Software Development Life Cycle.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS

Languages: SQL, PL/SQL,C# 3.0, Unix Shell Scripting

Oracle Tools: SQL Developer 4.1, TOAD 10.6, SQL* Plus, Oracle Golden gate

ETL Tools: Informatica 9.x, SQL *Loader

Databases: Oracle 10g/11g.

Operating System: Windows 7/XP/NT/Vista, UNIX.

Data Modeling Tools: Toad Data Modeler 3.6, Erwin 7.x, MS Visio 2013, MS Powerpoint

Server: Unix and Informatica.

Other Tools: Stash, Clearcase, Autosys, Toad 10.6, Toad Data Modeler 3.6,Autosys,Stash,Jira, TFS,VSS, Putty, IIS, MS-Excel 2007/2010/2013 , CodeGen,Tivoli,JRS,HPQC,EQUIP,PRISM

PROFESSIONAL EXPERIENCE

Confidential, Merrimack, New Hampshire

Sr. Oracle PL/SQL Developer

Responsibilities:

• Work on Data contribution by creating database objects like tables, views, procedures, cursors, triggers, types, sequences, packages, functions using Toad and SQL Developer.
• Carried out Data adoption by tuning complex SQL queries using Explain Plan, Indexes, Collections, and Bulk Operations. Use Partitions, Oracle Hints for optimal query performance.
• Created conceptual, logical and physical model and review it with data analysts and DBA’s to ensure adherence to the standards.
• Scheduling Data integration job using Autosys and Control-M.
• Co-ordinate with UI developers to call AIPs through their services.
• Work on utplsql for testing.
• Work on migration of data from CDE to ODS to Warehouse using Informatica workflows and mappings.
• Use of Jil files and applyIM to install changes in development and production environment.
• Oracle golden gate for migrating the data from MDM to CDE.
• Use of stash for version control, merging changes from development folder to master folder.
• Adopted agile methodologies and involve in the daily scrum meeting. Work on sprint created by scrum master in JIRA.
• Make use of Putty to login to Informatica and UNIX server.
• Code generator to generate the packages of similar kinds.

Environment: Oracle database 10g/11g, Informatica 9.1.0, SQL Developer 4.x, Toad 10.6, Toad Data Modeler 3.6, Autosys, Stash, Jira, Unix Server, Informatica Server, Oracle Golden Gate

Confidential, Northbrook, Illinois

Sr.Oracle PL\SQL Developer

Responsibilities:

• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
• Created database objects like tables, views, procedures, packages using Oracle Utilities like PL/SQL, SQL* Plus and Handled Exceptions
• Excellent working knowledge of Oracle database architecture (column orientation, projections, pivoting, segmentations, partitions, high availability and recovery, security)
• Implementation experience in relational and dimensional modeling, star/snowflake schema
• Extensively use Unix Shell Scripting for creating scripts to call Oracle stored procedures and functions.
• Use Oracle Reports for publishing returns and earnings of various entities and sub-entities
• Used Tivoli Job Scheduler for scheduling and monitoring jobs and its successor. Setting the various jobs in Production and UAT environment.
• Resolving abended jobs using application log file.
• Performance tuning, troubleshooting and bug fixing of PL/SQL scripts while working closely with the UI developers.
• Maintaining quality related documents like Project Plan, PSSP, DR-BCP, RAT Register etc.
• Extensively usedErwin7.x fordata modelingandDimensional Data Modeling
• Production support for the backend database and reporting applications.
• HPQC for logging defects and executing test cases.
• Carried out extensive data validation with client's data specialist validating complex SQL queries.
• Discussions with business groups about the data quality results and future steps to develop business rules to ensure efficient data quality check and validation.
• Designed the documentation that involves functional specification, user Manual and technical review.

Environment: Oracle database 10g/11g, PL/SQL, SQL, Erwin 7.x, Telnet, Unix Shell Scripting, Toad, Team Foundation Server, Tivoli, HPQC

Confidential, Minneapolis, MN

Sr.Oracle PL\SQL Developer

Responsibilities:

• Created Indexes to improve query performance.
• Partitioning large Tables using Range Partitioning, Index Organized Table, Rollback Tablespace.
• Pro-actively participated in SQL tuning, analyze DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Extract, Transform and load data from flat files, excel into oracle database.
• Rewrite SQL Queries for optimization and also developed PL/SQL packages, procedures and functions to perform certain specialized functions / enhancement on oracle application.
• Involve in the continuous enhancements and fixing of production problems and provided 24/7 production support.
• Coordinate with the DBA for table creation, granting privileges, killing inactive sessions and other administrative activities.
• Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Developed user controls using ASP.NET.
• Deliver solutions that are reliable, easy to maintain and meet or exceed established performance measures.
• Work in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Streamlined and enhanced the quality assurance processes by consolidating and automating different tasks that resulted in increased efficiency and accuracy of data
• Built Triggers to log the information about users and the operations they perform in their session.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Solving the offshore technical issues and co-coordinating between offshore team and client.

Environment: Oracle PL/SQL, Oracle database 11g, PL/SQL, SQL, Toad, UNIX and Windows, Team Foundation Server, Microsoft Visual Studio 2008

Confidential

Oracle PL\SQL Developer

Responsibilities:

• Analyzed Internal & External Source systems and Business Requirements to develop Health Insurance Claims Data warehouse Logical and physical model (Facts and Dimensions) and Business Process Model.
• Applying Data Modeling techniques using ERD and Data Flow diagram.
• Developed back end interfaces using Tables, PL/SQL packages, stored procedures, functions, Collections, Object types specifically for financial reporting.
• Tuning the SQL Queries for better performance and troubleshooting development problems by using Hints, Indexes, Partitioning and analyzing the Stats updates.
• Implemented Business Rules using PL/SQL Procedure/Packages with complex water fall calculations.
• Unix Shell scripting for supporting nightly batch schedules.
• Data Migration and Production support for the backend database and reporting applications.
• Importing Source Tables from the different databases.
• Performance testing, User Acceptance testing of the application and participated in code and Design Reviews, Status meetings and Walkthroughs.
• Involved in continuous enhancement, optimization and fixing of problems.

Environment: Oracle PL/SQL, SQL, 10g/11g, Oracle Reports 9i, Windows NT/2000, Linux, Oracle (9i), PL/SQL scripting, MS Visio, UNIX Shell Scripting Visual Source Safe

Confidential

Application Programmer

Responsibilities:

• Worked with Business Analysts and clients, analyzing and assessing the business specifications and designing and developing the Application.
• Developed new/modified various PL/SQL packages, stored procedures, functions, database triggers as per business requirements.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Involved in performance tuning, troubleshooting and bug fixing of PL/SQL scripts while working closely with the UI developers.
• Responsible for translating all the business requirements into technical specifications and document the technical requirements towards ensuring compliance during Software Development.
• Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load)
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Applying Data Modeling techniques using ERD and Data Flow diagram.
• Worked on Performance tuning by using Explain Plan, hints and also worked on Partition tables using Range method.
• Involved in Production support for the backend database and reporting applications
• Involved in writing PL/SQL scripts which will generate auditing triggers automatically.

Environment: Oracle 10g, SQL, PL/SQL, SQL Server, Unix Shell Scripting, Data Modeling using Visio, Microsoft Excel