SUMMARY:

• 10 years’ of IT experience in Analysis, Design, Development, Support, Administration, and Performance tuning of applications using Oracle SQL, PL/SQL, and T - SQL.
• Experience in all phases of the SDLC ( Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Excellent skills in writing PL/SQL Stored Procedures, Functions and Packages using Oracle 11g/10g/9i.
• Expert in designing different Database Objects like Tables, Views, Synonyms, Sequences, and DB Triggers.
• Experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Expertise on Ref Cursor, External Tables, Dynamic SQL, Collections and records and Exception handling.
• Worked with insurance, financial, and retail clients, and led teams on data conversion and migration projects.
• Expeience wuth very large scale database environment and administration ( DBA) for Oracle 10g and 11g.
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Good knowledge on Oracle 12c features line easy migration, instant analytics, and in-depth security.
• Good knowledge of DOTNET(VB.NET),Visual Studio 2008.
• Designed Jobs, Workflows, Data Flows, Scripts and Executing jobs with Data Integrator SAP BODS Designer.
• Strong experience in Oracle Cursor management, Exception Handling, performance tuning (PL/SQL / T-SQL), and optimization of SQL statements using SQL Trace, Explain Plan, TkProf, Indexing, and Hints.
• Well-being in the CRM industry as a strong PL/SQL technical resource for a data conversion and migration .
• Data Loading Experience in SQL Server 2008/2012 using SSIS ETL and expert in developing SSIS packages.
• Expert in using the tools TOAD, SQL *Loader, SQL Developer, SQL *plus and Oracle utilities like DBMS PIPE, UTL FILE, Exp, Imp and Data pump.
• Expertise in creating and maintaining Table Partitioning, Collections and records, Analytical functions, Materialized Views, Query Re-Write, and Transportable table spaces.
• Experience in using Automated Tool like JIRA.
• Experience with using serialization, de-serialization and delegates features of .NET.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Familiar with Oracle 12c standard and enterprise editions like advanced compression, Oracle OLAP, and partitioning.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Good knowledge on the process flows and data model of Oracle GL, AP, Install Base modules and CRM.
• Experience with Backlog Grooming, Sprint planning, Story sizing, Story Prioritizing, Standup meeting, and User Story Demos on Agile Project implementation.
• Experience in implementing the business rules in writing Oralce SQL and PL/SQL objects.
• Wrote Queries to retrieve data in XML format from the tables.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, and Export/Import .
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Data Bases: Oracle 11g/10g/9i, SQL Server, MS Access.

DB tools: Toad, Golden Gate, SQL Developer, SQL *plus, and SQL *loader.

Operating Systems: Unix, Solaris, Red Hat Linux, Windows XP/ 2007/2008/2010.

Scripting: SQL, UNIX Shell Scripting and JavaScript.

ETL Tools: Informatica 8.6 PowerCenter, BODI Data Integrator (ETL), and BODS Xi3.2, 4.2.

Utilities: UTL FILE, DBMS PIPE, Exp, Imp and Data pump.

Tools: Oracle Forms 9i, 6i, 4.5 and Reports 10g, 6i, 2.5, SSIS, SSRS, Erwin, and Rational Rose.

Languages: Oracle SQL, PL/SQL, T-SQL, C, C++, OOPS, Java/J2EE, .Net, perl, and Unix shell.

Web Technologies: HTML, CSS, XSLT, and UI.

Source Control: VSS, CVS, Subversion.

Methodologies: Agile, and Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.
• Created database triggers, sequences, stored procedures, and other database objects using Toad.
• Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas.
• Formulated SQL queries, functions and processes as per customization requirement for Oracle APEX.
• Provided Oracle APEX guidance & support to technical staff on application maintenance and SDLC process.
• Designed multiple new features in consolidation application related to Bank app search.
• Created and designed new web pages using HTML5, CSS3, and JavaScript.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used various LOVS (List of Values) and record groups at various points in the runtime.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Worked on enhancements & defects as per the business requirements.
• Performed SQL, PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked with DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix testing issues.
• Built new functionality and improve processing time through code optimizations and indexes.
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions, and DB Triggers.
• Validated the functions and procedures inside the package using the various fields in Oracle APEX.

Environment: Oracle 11g, SQL, PL/SQL, T-SQL/MS SQL, Toad 12, SQL Developer, TOAD Data Modeler, UNIX Shell, SQL *Loader, Oracle APEX 4.2, HTML, CSS, JavaScript, Windows, MS- Excel 2013, notepad++, and Agile.

Sr. T-SQL / Oracle PL/SQL Developer

Responsibilities:

• Worked on a data conversion project as a PL/SQL developer on critical Balance & Discrepancy (B&D) reports.
• Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
• Involved in walk-through sessions with business users during the Analysis, Design, and development phase(SDLC), written PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Designed and developed PL/SQL procedures and UNIX Shell Scripts, Data Import/Export and Conversions.
• Worked on various Financial modules GL, AP, AR, PO, FA, OM, INV, and CRM.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Worked on agile and test driven environment, participated on daily scrum meeting, discussions and finalize road blocks.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages, and Exceptions.
• Created the ETL Jobs in SAP BODS in a multi-developer environment maintaining versions in CR.
• Tracked defects using JIRA and generated defect summary reports.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Created DB objects in TOAD, SQL developer, SQL*Plus, SQL*Loader, and did Query performance tuning.
• Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
• Used CRM API 's for upload the service request information from AFA (Legacy System) to oracle apps ERP .
• Extract-Transform-Load ( ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Used Agile Scrum methodologies, performed standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Designed and developed ETL routines in BODS, modified or created new Data services jobs to meet project requirements.
• Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like .Net and Hierarchical databases like Oracle.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Used SVN version management to manage various versions of the procedures and functions of the application.
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Logged defects in Defect Manager, monitored their status and tracked them to closure using JIRA.
• Worked extensively through Agile development methodology by dividing the application into iterations
• Experience with custom development of data warehouse, operational data store, and OLTP systems.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, SQL Developer, SQL Loader, T-SQL, ETL, JIRA, Agile/Scrum, SSIS/SSRS, Windows 2007, MS- Excel 2013, SVN tool, notepad++, SAP BODS 3.2, 4.2.

Oracle PL/SQL Developer

Responsibilities:

• Involved in requirement analysis, prepared functional specifications, system design, development and administration.
• Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.
• Used T-SQL in order to design and tune T-SQL to interface with the Database and other applications .
• Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
• Customized few forms for the Business manages to validate the data.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Involved in writing CTL files (control files) for SQL*Loader to load the data from flat files into oracle tables.
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Involved in migrating from mainframes to Oracle 11g.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in Unit testing and Integration testing of forms and reports .
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Create Subscriptions in Data Mirror with different Mapping Types.
• Wrote SQL and PL/SQL programming code for ODI and oracle.
• Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
• Designed DW tables, scripts, ETL maps and ODI Extracts, Configured ODI modules and ETL tools and supported accessible applications, and Documented and maintained ETL specifications and processes.
• Developed extraction mappings to load data from Source systems to Data Warehouse.
• Experience with custom development of data warehouse, operational data store, and OLTP systems.
• Transferred SQL and Korn shell programs into ODI and created data extracts.
• Loaded data in Staging and Production databases.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Developed customized Forms like customer and supplier maintenance, bill, receipt, invoice, debit and credit notes.
• Used Unix Shell Scripts for Code optimization and Performance tuning of the application.

Environment: Oracle 11g (SQL, PL/SQL), SQL Loader, T-SQL, Golden Gate, ERwin, TOAD, Rational Rose, Informatica Power center, SSIS, Unix, Agile, Windows 2007/XP.

Oracle database developer / PL/SQL developer

Responsibilities:

• Involved in analyzing and designing of database using Normalization techniques.
• Tuned SQL queries using execution plans for better performance.
• Developed and maintained Oracle Forms and Reports for various applications using SQL*Plus and PL/SQL.
• Implemented necessary monitoring scripts for Golden gate in Unix/Perl scripting.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
• Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed SQL *Loader scripts to load data in the Staging tables.
• Developed PL/SQL stored procedures, user defined functions for complex calculations and bundle them into a stored package that could be invoked from the Forms triggers.
• Used Golden Gate on two systems (source data & replicated data) connected by TCP/IP.
• Developed and maintained for the ETL (Extract, Transform and Load) processes using Oracle and Informatica Power Center.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation and testing.
• Wrote Procedures and database triggers for the validation of input data and to implement business rules Developed several SQL reports for the Business Users to check the post processing rules.
• Testing all PL/SQL code for logic correction and Coordinating the offshore team and Production Support for the B2NCR Application.

Environment: Oracle 10g, SQL, PL/SQL, SQL *Loader, T-SQL, SSIS, Toad 9.0.1, Informatica, JIRA, ERwin 7.2, Golden Gate, Java, UNIX, Windows, Agile/waterfall.

Oracle Database Developer

Responsibilities:

• Developed database objects like Tables, Views, Indexes, Synonyms, and Sequences.
• Written packages, triggers, stored procedure and functions for the following module products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
• Loaded traffic data logs into staging tables using SQL *loader and UNIX shell scripts.
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Reduced IT Cost, Suggested BICC for BO to OBIEE Migration which would lead to efficient distribution of work and efficient utilization of resources at offshore and onsite.
• Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.
• Developed PL /SQL code for updating payment terms.
• Creation of Forms, Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS (List of Values) and record groups at various points in the runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL *Loader, Shell script, Subversion, waterfall, Windows XP and UNIX shell.

Software Programmer

Responsibilities:

• Created and maintained tables, materialized views (Summary Tables), procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
• Constant monitoring and performance tuning of the Oracle database, checking the most expensive queries.
• Incomplete and full database recovery with experience of complex recovery scenarios.
• Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
• Designed and developed UNIX scripts for creating, dropping tables used for scheduling the jobs.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Conducted code walk-through & internal/peer reviews on application code and other deliverables.
• Detected and corrected bugs during system integration and user acceptance testing.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 9i, SQL*Loader, PL/SQL, SQL*Plus, TOAD, SQL Developer, waterfall, Windows 2000 Server, UNIX shell scripting.