SUMMARY

• Over 9 years of experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 12c/11g/10g, Oracle Forms9i, Reports9i/6i, SQL, PL/SQL, SQL*Loader, BI Publisher.
• Involved in complete project Life Cycle including requirements gathering and Analysis, Database design, Database development and Application development, Testing, Implementation and Support of the application software.
• Knowledge in ETL techniques using Informatica Powercenter, Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the target Databases.
• Good understanding of ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
• Experience in SQL, PL/SQL, Tables, Table Partitions, Database links, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes.
• Experience using Autonomous Transactions, Materialized Views, Bulk Collects and Collections.
• Have Experience in creating mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer
• Experience in writing PL/SQL ETL routines in data warehousing applications.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Rich experience in doing MSSQL migrations and up-gradations.
• Hands on implementation experience in industries like Banking, Trading, Energy distribution, Telecommunications and Health insurance.
• Worked with applications like Automotive Domain, Banking Information Systems, Health Care Management Information Systems, and Financial Accounting.
• Experience in Migrating Data to Oracle database.
• Experience using TOAD, SQL Navigator under UNIX and Windows NT/2000/XP/Vista, Sun Solaris operating systems.
• Good knowledge financial modules like AP, AR, OM, GL and on E Business Suite.
• Ability to cope up with team with good analytical, communication, organizational and interpersonal skills.

TECHNICAL SKILLS

Oracle apps: Oracle E-Business Suite Version 12.0.2, 11.0.2, 11.5.10

Foundation: Sysadmin, AOL, FND

Oracle Financials: GL, AP, AR,CE

SCM: INV, OM,PO

RDBMS: MS SQL Server 2012, 2008, 2005, 2000, MS Access

Operating Systems: Windows Server 2012/2008/2003 , Windows 7/8

Database Tools: SSIS, SSRS, SSAS, Cognos, SQL Server Data Tools, SQL Server

Oracle Product Set: Oracle Ver.9i, 10g, 11g Developer 2000(Forms 6i,10g Reports 6i,10g), SQL Loader.

Languages: T-SQL, PL/SQL, C#, Asp.Net, HTML

Others: Toad, SQL Developer

Tools: SQL Server Management Studio, ETL Informatica Power center, BI Development Studio, MS Office, MS Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Emeryville, CA

Oracle PL/SQL Developer

Responsibilities:

• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL
• Coordinated with Java Web Services team to generate the reports.
• Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).
• Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Worked on various tables to create Indexes to improve query performance.
• Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Involved in Performance Improvement on Java application side.
• Involved in writing several complex Queries and Procedures.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Involved in the Database Design (Relational and Dimensional models) and Involved in Logical & Physical Database Layout Design.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Client side validations were performed using JavaScript.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Participated in code walkthroughs and review sessions with the development team.

Environment: Oracle 11g, SQL, PL/SQL, Java,ETL Informatica, UNIX, Windows 2000 server, TOAD, SQL LOADER, Rapid SQL, JavaScript, XML, Autosys, Puty, DWH, HP QC

Confidential, Sacramento, CA

Oracle Pl/Sql Developer

Responsibilities:

• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• 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.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Design and develop ETL mappings and workflows using Informatica.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Implemented custom HTML java scripting and JQuery when building page reports, buttons and templates in APEX.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Designed and developed front end portal for the BOW (book of work) workflow tool, Java web application using HTML, JavaScript and CSS. Involved as the developer for web application workflow tool and created various JSP's and servlets.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Experienced in writing unix shell scripts for different purposes such as scheduling jobs and moving the files from remote server to local informatica server.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, SQL Developer and Rapid SQL.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g/11g on LINUX, Java, SQL Developer,ETL Informatica, TOAD, Rapid SQL, AIX, HP-UX, Oracle Enterprise Manager, Java Script, CSS, XML, HTML, UNIX, Shell Scripting, TOAD, Putty, HP-UX.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked with SQL*Loader and External Tables to load weekly flat files into staging tables.
• Developed procedures to move data from staging tables to production tables.
• Experience in Data Warehousing and ETL using Informatica Power Center 8.6.
• Involved in Performance tuning of SQL queries as data warehouse consists of many f rows of data.
• Created data for Crystal Reports using procedures and complex Queries.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Documented design specifications and architecture using Microsoft Visio
• Used Oracle APEX to create screen design and reports design templates.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Knowledge in ETL techniques using Informatica Powercenter, Oracle PL/SQL Stored Procedures to Extract and Transform data from various data sources and Load to the target Databases.
• Did unit testing for database module and QA testing for Java module.
• Worked on the data migration to move the data from the legacy system to the target system which will be the source of data for multiple systems. Multiple systems will be managed through the data from the Master Database.
• Created the PL/SQL packages, procedures, functions applying the business logic facilitate the functionality for various modules.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 8.6.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the different tables.
• Design and developed the scripts to create tables, views, indexes and sequences.
• Migrated data from the previous database in SQL Server database to Oracle 11g.
• Involved in performance tuning and troubleshooting issues.
• Fine Tuned procedures in various schemas across databases using Oracle Hints, Explain plans and Trace sessions.
• Ran Cron jobs for loading database tables from Flat Files using SQL*Loader and also used DBMS SCHEDULER to schedule PL/SQL stored procedures.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 11g, Microsoft SQL Server 2005,ETL Informatica, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10.6, AIX 7.1.

Confidential

SQL Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans and DTS packages.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Provided back-end support for functional testing and performance test

Environment: SQL Server 2005/2000, MS Visio, DTS, MS excel 2003, T-SQL.