SUMMARY

• Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
• Expert in Client - Server application development using Oracle Database 11g/10g/9i/8i, PL/SQL, SQL *PLUS, SQL*DEVELOPER, TOAD.
• Extensive experience in Oracle RDBMS design and developing stored procedures, packages, triggers, cursors using SQL and PL/SQL.
• Solid understanding and experience in IT principles in Software Configuration Management, Systems Integration and Technology Development.
• Extensively worked on designing, developing, extending the functionality and testing Forms, Menus, Reports.
• Expertise in tuning of procedures, packages and SQL statements.
• Expertise in data modeling, normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Experienced in migrating data between OLTP and OLAP systems. Extensively worked on OLTP systems for extracting and loading data.
• Used Advanced PLSQL concepts, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Wrote SQL statements in Pro*C and replaced them with appropriate calls to functions in the SQL runtime library.
• Extensive experience in developing Oracle Forms using Forms Builder 10g/9i/6i.
• Migrated forms from version 6i to 10g and 10g to 11g, recompiled and restructured as per the business needs and latest functionality available.
• Experienced in creating various complex forms using .PLLs, Program Units, Various Smart Triggers, Call functions and adding alerts.
• Created Complex Master Detail Reports, with calculations, format triggers, Programming Units and Report triggers.
• Migrated various reports from Oracle Reports Builder 6i to 10g.
• Generated XML datafiles using DBMS XML, and parsed them to other databases using external tools.
• Extensively monitored various jobs for data staging, processing and loading data.
• Experience in handling very large data files using Export-Import Utilities, UNIX Shell scripts and SQL*Loader.
• Hands on Experience in Oracle Discoverer, developing reports, working various components like Discoverer Administrator, Discoverer Desktop, Discoverer Plus and Discoverer Viewer.
• Experienced in UNIX Shell Scripts to automate load process, handle multiple files, call PLSQL procedures, encrypt and archive data files.
• Involved in analyzing and validating data migrations from the old system to highly relational database system.
• Worked on Interface & Conversion for importing the data using SQL* Loader & PL/SQL.
• Well versed with client-server environment and tools like SQL* Loader, Toad and SQL Developer.
• Self-motivated with the ability to effectively manage time and multiple projects.
• Experienced in preparing and analyzing Data flow diagrams, Data dictionary, Database Normalization theory techniques, E-R Modeling and design techniques
• Good ability to quickly grasp and master new concepts and technologies
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction
• Expertise in unit testing, fixing software bugs quickly and effectively.
• Provided support to resolve end user support problems, optimize performance, resolve system defects and analyzed proposed improvements or changes to the system.
• Designing and developing application schemas, ER Diagram, Tables, Clusters, Indexes, Views, Materialized views, Triggers, Procedures, Functions and Packages
• Extracted Transformed and Loaded(ETL) data source database to data warehouse system.
• Knowledge of other Programming languages like Java, VB .Net, C.
• Excellent analytical and problem solving skills and can work independently.
• Excellent communication and responsible team player.
• 24/7 Production Database Support & Maintenance
• Proficient in Error handling and debugging coding issues and troubleshoot production problems.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, SQL Server 2005/2007

Languages: SQL, PL/SQL, Pro*C, C, UNIX Shell Scripting, Perl Scripting

Oracle Tools/ GUI: Forms 6i/9i/10g/11g, Reports 6i/9i/10g, Discoverer 4i/10g, Oracle APEX 3.2

Database Development Tools: TOAD, PLSQL Developer, SQL*DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator

Data Modeling Tools: ERWIN, Toad Data Modeler

ETL/ Data ware housing Tools: Informatica Power Center 8.1/8.6, Oracle Data Integrator, Oracle Warehouse Builder

Web Technologies: HTML, HTML5, XML

Other Scripting Tools: Secure Shell, Putty, WINSCP, DOS Prompt, VBA Script.

Oracle Utilities: SQL Loader, UTL FILE, TRACE, TKPROF, DBMS Utilities, etc.

Operating Systems: Windows Family, HP Unix, Sun Solaris, AIX, Oracle Linux

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

Senior Oracle Developer

Responsibilities:

• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center.
• Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Used Oracle 11G/R2 and 6i reports designer to create new reports. I am also using these tools to update the existing reports.
• Used Oracle Forms 11G to create new forms and maintain the existing forms.
• Developed user interface Forms, Reports, PL/SQL Packages, Procedures, Functions and Database Triggers to meet the business requirements.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable.
• Used Bulk collect and for all in stored procedures to improve the performance and make the application to run faster.
• Developed administrative tools using UNIX Shell scripting.
• Created multiple Unix shell scripts to import data into Oracle using the SQL*Loader
• Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.
• Involved in fixing bugs within Packages and Stored Procedures.
• Involved in Tuning Database & Application performance using Explain Plan.
• Developed SQL*Loader control files to extract data from flat files, create error, result log files and load data into temporary table to do validations.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.

Confidential, Tulsa, Oklahoma

Senior Oracle Developer

Responsibilities:

• Coordinated 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 logical modeling and physical modeling of application.
• Written packages, triggers, stored procedure and functions for the following modules products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• Involved with the Performance tuning, Optimization of queries and standardization of the code.
• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views and SQL scripts using PL/SQL.
• Created UNIX shell scripts to automate table creation, execute procedures by using CRONTAB.
• Involved in performance tuning which included creating indices, table partitioning, SQL hints using explain plan utility.
• Involved in developing and maintaining control files for SQL loader to load the data from SQL server to oracle database tables.
• Worked on queries using Teradata SQL Assistant to connect various ODBC sources.
• Worked with DBAs to help them in data loading process, batch jobs and various administration tasks.
• Responsible for data mapping and creating Run-Books from legacy system to oracle.
• Extensive experience in working with different FTP clients such as IpSwitch, winSCP for extracting data from sources to own destination.
• Created synonyms and make sure that users have executable permissions on all objects.
• Performed re-org for several dimension and fact tables for space release management in data warehouse.
• Extensively used cursors, sequences and indexes in the procedures.
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Analyzed the requirements and framed the business logic for the ETL process.
• Generated various reports out of OLTP system for validation and transforming.
• Responsible for monthly ETL in SQL server which are used by the users for potential tableau reporting.
• Created stored procedures for daily database space monitoring.
• Provided data and reports in a timely manner using WebFOCUS as the data reporting tool including the following WebFOCUS applications like HTML launch pages, compound Excel reporting, WebFOCUS SQL pass thru reporting and MS SQL Server.
• Implementation of High Availability solutions with Oracle 10g Real Application Cluster, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams
• Wrote dynamic SQL queries in different procedures and packages to work on PIVOT function.
• Worked extensively on Exception handling to trouble shoot the PL/SQL code.
• Involved in automation of SQL server jobs that are performed manually which involves MS ACCESS.
• Worked in production support environment which involved in performing operation such as monitoring jobs, performing root cause analysis, troubleshooting the issues, monitoring top activity and long running queries, performance tuning and space management.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Write Technical Specifications based on business requirements to provide account level financial summary reports to the business customers
• Perform Data Mapping and develop ETL Specification documents.
• Develop ETLs using PL/SQL in Oracle 10g & 11g to extract, transform and load data from OLTP into Warehouse.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Created Cursors, Collections and DB Triggers.
• Documented different Stages of Data Transformation, procedures and Scripts.
• Used OracleJDeveloperto support JAVA, JSP and HTML codes used in modules.
• Utilized PL/SQL nested tables for conditional trafficking of data within ETL process.
• Filtering of data by developing reusable PL/SQL functions.
• Performance tuning using Oracle Hints and Result caching where appropriate.
• Utilized PL/SQL bulk collect feature to optimize the ETL performance.
• Developed ETL programs using informatica to implement the business requirements.
• Document application from a technical maintenance point of view and host a knowledge transfer session.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Worked with visual studio 2010/2008/2005/2003 , .Net framework using ASP.Net and C#
• Maintain and Oracle PL/SQL batch process for claims based billing and reporting system.
• Debugging Production issues using Toad 9.7 debugger.
• Implemented various UNIX scripts to generate the data in CSV format.
• Worked on inline and correlated Sub queries based on business context.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Experience in operational DBA supporting OLAP and OLTP environment including implementation and design of data warehousing.
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus, SQL Developer and SQL Navigator.
• Experience in Query optimization & Performance tuning using Execution Plan, Performance Monitor.
• Strong experience on working with Procedures for improving the load performance in various schemas across databases using appropriate HINTS.
• Extensively worked on database up gradation and data migration from other systems to oracle.
• Extensive Knowledge on, PERL Programming and scheduling jobs using CRONTAB and DBMS JOBS.
• Extensive Experience in Creating Repository, Source, Target Databases for Extraction, Transformation and Loading (ETL) using OWB and Informatics.
• Developed and maintainedOracle HTML proceduresand functions withPL/SQLcode integration
• Worked onJDeveloperfor development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL and PHP.
• Analyzed, designed and developedOracle forms10g queries, layout,reporttriggers, parameterform, data models etc.
• Developed korn shell scripts to kick off back endPL/SQL, SQL, Pro*C programs.
• Worked onReportlayout design, Data models which used Placeholder, Summary and Formula Columns preparation of user manual and development of the program usingForms10g.
• Designed and DevelopedJSP programsby using Web Logic, an Eclipse IDE for Java, SOA and Rich Internet applications.

Confidential

Oracle Developer

Responsibilities:

• Created database objects like tables, synonyms, sequences, views.
• Developed ETLs to pull data from various sources and transform it for reporting applications using PL/SQL.
• Documented Technical Specs, Dataflow, Data Models and Class Models.
• Performed integration testing with frontend reporting infrastructure.
• Wrote shell scripts for automating the process of data loading.
• Documented requirements gathered from stake holders.
• Completely redesigned the database process in PL/SQL to be able to configure variables in database tables opposed to code and developed system alerts to proactively notify about discrepancies in data.
• Deployed database objects (procedures, triggers, tables) to production.
• Identified dependencies of different components.
• Review, process and carry out regular site and office safety audits and inspections for all related site projects.
• Conducted code review to ensure development standards.
• Created materialized views, partitions, tables, views and indexes.
• Developed complex hierarchical SQL queries to provide hierarchical views of organization’s structural data in Organizational Mapping system.
• Developed APIs to validate inputs and retrieve data for frontend applications.
• Developed Reusable PL/SQL functions for validation of inputs.