SUMMARY

• Over 7 years of comprehensive experience in software design and development.
• Experience in all phases of a project - from Requirements Gathering, Analysis, Design, Development, Implementation and Managementof projects.
• Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
• Working Knowledge on Extraction, Transformation and Loading process (ETL).
• Experience in Informatica Power Center (versions 9.0/8.6/8.1/7.1/6.2/5.7 ), Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, Star Schema Modeling, OLTP, OLAP, Data Reports.
• Experience in SQL, PL/SQL (Procedures, Functions and Triggers), TOAD, Interactive UNIX and Shell scripting and good experience with Oracle tuning and optimizing the SQL queries to improve the performances.
• Good experience in Dimensional Data Modeling, Star Schema/Snowflake modeling, Datamarts, OLAP, FACT & Dimension Tables, Flow Diagrams, Ralph Kimball Approach, Physical and Logical data modeling using ERWIN.
• Comfortable working with Unit Testing, Debugging, and Deployment of Applications.
• Knowledge in design and setup of Backup and Recovery Strategy for various databases.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and Load testing.
• Expertise in developing the complex layouts in Forms and Reports.
• Extensive experience in Oracle 11g/10g/9i/8i RDBMS and SQL Server.
• Extensive experience in PL/SQL Programming using Stored Procedures, Functions, Packages, Triggers, Collections, and Bulk Collections.
• Expertise in loading data from legacy systems using SQL*Loader.
• Extensive experience on Materialized views, Collections like Nested Tables, Objects and Dynamic SQL.
• Significant experiencein24/7 Production Environment Support.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX SHELL SCRIPT, C

ETL Tools: Informatica Power Center 9x/8x/7x/6x (Source Analyzer, Warehouse/Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server)Power Mart.

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server, MS-Access, PostgreSQL

Web Design: JavaScript, XML, XSL, HTML, Front page, Flash, Drupal, Joomla

Operating Systems: Windows 2000/NT/XP/Vista/7/8/10, Linux

Database Back-End Tools: SQL*Loader, TOAD, SQL*Plus

Code Control tool: GitHub, Team Foundation sever

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Oracle Developer

Responsibilities:

• Studied user requirements and functional specifications.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Designed and developed Oracle Forms and Reports using Forms10g and Reports 10g.Including Forms based on stored procedures.
• Conversion of forms 6i to forms 10g along with Data conversion (legacy system to oracle).Developed few financial applications for legacy system.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and Parse it and load it into tables.
• Turned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Assisted in Installing Application Server, Report Server and Database Server.
• Involved in performing periodic cold backup of the databases.Configured Oracle 10g As Portal for deploying AERS on Linux and Windows for both production and development environments.
• Prepared test plans for System and User acceptance test.
• Involved in documenting users requirements, technical specifications and Reporting manuals.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SCHDULER, Create Directory, Data pump, CONNECT BY ROOT in existing Oracle 9i application.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Extensively worked on migrations and Conversions with legacy systems data in SQL Production Reporting.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors.
• Created Forms based functions, procedures and packages.
• Registration of Reports through creation of concurrent executables, concurrent programs, and assigning to Request Group.

Environment: Oracle 8i/10g/11g,PL/SQL,SQL Plus, SQL Navigator, XML, Shell Scripting, SQL*Loader, Shell Scripting, SQL developer, Data stage, Forms and Reports 10g/6i, CSS, UNIX

Confidential, Reston, VA

Oracle PL/SQL Developer

Responsibilities:

• Involved in identifying data ownership/responsibility, requirement gathering, data mapping, mapping design, analysis, validation, and consolidation of source system, defining error and restart logic, and quality assurance and production environment.
• Designed ER diagram using Visio, to set the logical and physical relationships of database.
• Documented technical specification, business requirements, and functional specifications for the development of mappings to load data into various target tables.
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flatfiles, XML files and loading into datamart in Oracle database.
• Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures.
• Developed interface for item data conversion to load items from flat file to Oracle.
• Inventory using SQL* Loader, PL/SQL and import items program.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Reviewing of design and code developed by peers.
• 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.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• 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.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control /auditing of different processes.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Coordinated with DBA’s in resolving the database issues that lead to production job failures.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved extensively in Unit testing, integration testing, system testing and UAT.
• Used the Rational Clearcase for versioning the various objects like the mappings, workflows, sql scripts and Perl scripts.

Environment: Oracle 10g,Oracle Forms 10g, reports 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Korn), XML, SQL*loader, Stored Procedures/Triggers, Windows NT, MS Visio.

Confidential, Waukegan, IL

Oracle - PL/SQL Developer

Responsibilities:

• Created Database objects like Tables and Views.
• Developed Packages, Procedures and Functions to migrate the data from database systems.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Involved in the Design and Development the RDS Data warehouse system includes tables, Indexes, triggers, Procedures, Functions and Packages.
• Used Cursors and Ref cursors as a part of the procedure to retrieve data in the Procedures.
• Used Informatica to extract, transform and load data from multiple heterogeneous sources into Oracle.
• Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
• Designed the change data capture logic in the Informatica mappings by incremental extraction of source data.
• Used the transformations like Source qualifier, Router, Filter, Sequence Generators and Expression as per the Business requirement to create the mappings.
• Developed complex aggregate, joiner, look up transformation rules (business rules) to generate consolidated data using Informatica Power Mart tool.
• Tuned the Informatica mappings and the database SQL for better performance of the application.
• Involved in Technical Documentation of user manuals for the end user.

Environment: SQL, PL/SQL, Oracle 10g/11g, XML, Informatica Power Center 8.5, Winscp, SVN, Putty Manger, UNIX Shell Scripting, UNIX, Windows

Confidential, Denver, CO

Oracle Developer

Responsibility:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Worked closely with a project team for gathering business requirements and interacted with business users to translate business requirements into technical specifications.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created database objects such as tables, views, synonyms, indexes, sequences, functions, stored procedures, packages and database link as per business requirements.
• Involved Database Administration of database objects, including tables, clusters, indexes, views, sequences packages and procedures Troubleshoots with regards to database problems and TQA defects.
• Extensively used Advanced PLSQL features like Bulk Collects, Forall in the procedures for the performance issues.
• Maintaining the Data Base changes according to the client’s requirements.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Developed Forms and Reports for their customer master Management.
• Extensively involved in the Performance tuning by using explain plan.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Loaded the data into database tables using SQL*loader and oracle External tables from text and excel files.

Environment: Oracle 9i/10g (SQL * PLUS, SQL, PL/SQL), TOAD, SQL Navigator, Oracle WEB server, Oracle Applications 11, HTML, Erwin Data Model, Apache Web Server, VSS. Oracle Discover 10g.

Confidential

Oracle - PL/SQL Developer

Responsibilities:

• Worked with BA to collect and document database design requirements and do data modeling with DB architect using Erwin.
• Implement the back end changes in existing product and in designing the database by gathering and understanding requirements from Business / System Analysts.
• Analyzed the functional specs provided by the data architect and created technical specs for all the projects.
• Developed Oracle database objects including tables, views, functions, procedures, packages, etc.
• Written queries using a lot of aggregate functions, joins, sub-queries, etc.
• Checking execution plan using explain plan.
• Created Indexes on selective columns to optimize queries.
• Developed triggers for auditing and error handling.
• Written Stored Procedures for effective inserts and updates of the data to the tables aimed to reducing the network traffic especially when the application is online.
• Wrote and modified Oracle PL/SQL statements, Procedures and Functions
• Used BULK COLLECT, BULK INSERT and FORALL to decrease query execution time.
• Reproduce Oracle schema objects includes tables, temporary tables, views, indexes, triggers and procedures, based on customer requirement.
• Created test cases and test reports and worked with QA team to validate the data and scenarios.
• Solved issues during testing and production phase.
• Provided on call production support during production roll outs.

Environment: Unix, Oracle 11g, Oracle developer 11g, Oracle EBS, ERP R12, Oracle Enterprise Manager, MS SQL server management studio 2008, Toad for Oracle 9.0, PL/SQL, Erwin.

Confidential

Oracle - PL/SQL Developer

Responsibilities:

• Involved in all the phases of SDLC including requirement gathering/analysis, designing high level technical designs, coding, testing, deployment and support.
• Responsible for ETL activities like source data Extraction, data validation, data cleansing, data Transformation and Loading into target system using ETL tool Talend and PL/SQL packages.
• Developed data load tool (GDLT) using SQL, PL-SQL & Unix scripts for migration activities.
• Responsible for Data Integrity and Reconciliation checks and Stats reporting to management.
• Performing defect analysis, reviews, discussions, code changes, code reviews, code testing, defect fixing and code check in.
• Responsible for Performance Tuning of slow running oracle queries using Query Level Performance tuning, explain plan, indexing, oracle hints, oracle bulk processing .
• Responsible for coordinating with client and different stakeholder’s for requirement understanding, clarifications and coordinating with offshore resources.

Environment: Oracle 8i (SQL, PL-SQL), GDLT, ICQA, Toad, Oracle Enterprise Edition, UNIX scripting (sed, perl, awk), Pro*C, Talend,5.3, Oracle Form Designer, Erwin Data Modeler, SVN, MS Excel, MS Word, MS PPT.