SUMMARY

• Over 8 years of experience in analysis, design, Application Development and Production Support using Oracle SQL, PL/SQL, and UNIX.
• Involved in all the phases of SDLC - Analysis and Design, Data Modeling - ER Diagrams and different methodologies, System Testing, Development, documentation and implementation on both Client/Server as well as Web-based applications.
• Extensive hands-on expertise using Informatica 9.x / 8.x and Erwin Data Modeler with strong business understanding of Banking, Insurance, Finance and Pharmaceuticals-Healthcare and Telecom sectors.
• Strong experience in fields of Health Care, Finance, Supply chain and Telecom domains.
• Extensive work experience on Oracle 11g/10g/9i/8i, SQL server databases on Unix, Linux and Windows enterprise platforms
• Strong experience in Data modeling for Enterprise Data Warehouse, OLTP and Data marts using Erwin and MS Visio.
• Highly proficient in developing Oracle PL/SQL Packages, Stored procedures, Functions, Triggers and Cursors as per business logic. Also developed various applications using Oracle in-built packages.
• Used DBMS utility packages like DBMS XMLGEN and UTL FILE to generate XML Files for interfaces with other system.
• Involved in development of Real time applications and ETL Processes - Extract, Transform and Load for Data warehouse.
• Hands on experience with Oracle Warehouse builder application to transfer data from different source system to flat file to conversion staging area.
• Experience in Tuning SQL statements using EXPLAIN PLAN and TKPROF to improve query performance and creating relevant system and user’s documentation.
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Extensively developed Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
• Proficient in translating business requirements into logical data models, creating modularized enterprise applications
• Worked on Production Support, receiving production calls on troubleshooting the application and resolving bugs.
• Strong experience in client interaction and understanding business application, business data flow and data elements
• Experience in design and development of reporting environments
• Extensive experience using Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Ability to work in any team structure and work independently with minimal supervision to meet and exceed expectations for project deadlines.
• Excellent communication, analytical and Interpersonal skills for interacting with business users, architects, developers and managers alike.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i/8i/7.x, MS SQL Server, MS-Access

Languages: SQL, PL/SQL, HTML, XML, C, Pro*C, Java, Hibernate

Scripting Languages: UNIX Shell Scripting, Perl scripting

Tools: TOAD, SQL Navigator, SQL Developer, Informatica PowerCenter 9.1/8.6,Oracle Warehouse Builder, IBM Application Developer (RAD), Eclipse

Reporting Tools: Business Objects, Oracle Discoverer, oracle forms and reports

SQL Utilities: TKPROF, SQL*Loader, Export, Import

ER Design: ERWIN, MS Visio

Office Applications: Microsoft Office 2003/XP/2000/97 (Word, Excel, PowerPoint)

Operating System: Solaris9/8, HP-UX 11g, SCO UNIX R5, Red Hat Linux 6, Windows XP/2000/NT/98

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

Senior Oracle/ETL Developer

Responsibilities:

• Involved in gathering of business scope and technical requirements and created technical specifications.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Router and SQL transformations. Created complex mapplets for reusable purposes.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Fine-tuned existing Informatica maps for performance optimization.
• Worked on Informatica Designer tools - Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Preparation of QA migration and PROD migration Documents after development and testing in Development environment and executed Quality Assurance testing.
• Using Erwin generated SQL statements (ddls) required for the database administrator to create Entities and their attributes in the databases
• Extensively worked on Ad Hoc Requests from business users using oracle sql queries, hierarchical queries delivering results in very quick turnaround times
• Modified the existing PL/SQL Packages, Stored Procedures and functions to cater additional business enhancements
• Extensively wrote UNIX Shell scripts to automate the daily/monthly ETL Jobs
• Used Toad as an advanced SQL - PL/SQL editor.

Environment: Oracle 11g/10g/9i, SQL, PLSQL, TOAD, Informatica PowerCenter 8.6/9.1, Windows XP, UNIX

Confidential, Burr Ridge, Illinois

Oracle PL/SQL Developer

Responsibilities:

• As a team member interacted with Business Analysts for requirements gathering, research and solving client specific data issues.
• Created different schemas and maintained schema objects.
• Created views and materialized views to get specific data to be accessed by the front end.
• Extensively used cursors and ref cursors in creating packaged procedures and functions.
• Used oracle built in package DBMS CRYPTO for encryption of customer’s credit card information.
• Reviewed the existing Packages, Stored Procedures and functions and modified them to improve their performance which enhanced the speed of loading of web pages in the application.
• Extensively used INDEXES AND HINTS for better performance of queries.
• Used external tables to import data from QuickBooks to the database.
• Used Oracle utilities like Explain Plan and Sql trace and TKProf to improve performance of queries.
• Wrote hierarchical queries to populate Product and services list
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.

Environment: Oracle 11g, SQL, PLSQL, TOAD, Windows XP

Confidential, Tampa, FL

Oracle PL/SQL Developer

Responsibilities:

• As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
• Created different schemas and maintained schema objects
• Wrote PL/SQL Overloading Stored Procedures, Functions, Packages and Package Constructors to enforce business rules
• Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Created control file scripts and used SQLLDR to load data into the staging table.
• Implemented complex Interface business rules using Oracle Database Triggers constructs
• Utilized partitions to fine-tune SQL data load.
• Extensively used INDEXES AND HINTS for better performance of queries.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof
• Created java classes for their java application, to interact with Oracle database using Java API - JDBC (Java Database Connectivity) for executing SQL statements and support other basic SQL functionalities.
• Server side java (EJB and Servlets) for high volume database connection pooling.
• Implemented J2EE patterns for data access and manipulation in various health care sub-domains like Enrollment, dis-enrollment etc.
• Extensively wrote UNIX Shell scripts to automate the data load from sqlldr to staging table.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.

Environment: Oracle 9i, Oracle 10gR2, SQL, PLSQL, TOAD, Microsoft Visual Studio, Windows XP, Red Hat LINUX, JAVA, Eclipse. IBM Websphere 6.0

Confidential

Oracle/ETL Developer

Responsibilities:

• As a team member interacted with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
• Created different schemas and maintained schema objects
• Wrote PL/SQL Overloading Stored Procedures, Functions, Packages and Package Constructors to enforce business logic
• Extensively used UTL FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area.
• Used Oracle Warehouse Builder to transfer data from other source databases like DB2 to flat files.
• Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions
• Implemented complex Interface business rules using Oracle Database Triggers constructs
• Utilized partitions to fine-tune SQL data load.
• Extensively used INDEXES AND HINTS for better performance of queries.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof
• Used oracle built in function DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Setup and configured ETL runtime environment in Dev, TST, QA instances for efficient, time-constrained batch loads
• Wrote Perl Scripts for the users to retrieve data over the web browser.
• Responsible for automated UNIX Shell script jobs using CRONTAB.
• Created cron Jobs to perform regular updates to the data warehouse database.
• Responsible for data conversion activity for System Integration and User acceptance testing
• Involved in Production Support to resolve end-users data related reports issues.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.

Environment: Oracle 10gR2, SQL, PLSQL, Oracle Warehouse Builder, TOAD, Windows XP, UNIX on HPUX

Confidential, Miami, FL

Oracle PL/SQL Developer

Responsibilities:

• As a Team member interacted with Business Analysts and client representatives for requirements gathering, research and solving client specific data issues.
• Data Analysis, Data Mapping and defining data flows.
• Created Procedures, Functions and packages using PL/SQL.
• Written various Triggers, Stored Procedures to perform or automate some of the tasks and enforce business rules.
• Used Oracle warehouse Builder to transfer data from flat files to conversion staging area with data transformations operators according to business rules and to view the audit trails.
• Responsible for developing and converting customer information table, ESN table and SIM table from Legacy systems.
• Created partitions for performance improvement of queries.
• Responsible for automated UNIX Shell script jobs using CRONTAB.
• Generated XML Files from the database. Used XML Style sheets for reporting on the XML Data over the browser on the intranet.
• Used Dynamic SQL in Procedures for System administration and improving performance.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions
• Created UNIX Shell scripts for ftp batch jobs, creating SQL reports and email notifications.
• Detected and corrected bugs during system integration and user acceptance testing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Created java code to call complex stored procedures which takes input parameters and also displays back the results in the web environment.
• J2EE components to interact with backend oracle database.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Involved in Production Support to resolve end-users data related reports issues

Environment: Oracle 10g, SQL, PLSQL, DB2, TOAD, Oracle Warehouse Builder, Windows XP, UNIX on HPUX, JAVA.

Confidential, Norfolk, VA

Oracle PL/SQL Developer

Responsibilities:

• Responsible for G-EAGLS online application, email alerts modules requirements gathering, preparing Functional and Technical specification documents
• Coordinated specifications signoffs with end users
• Designed and created logical data models, schema objects, validation code and performance-tuning strategies using various types of Indexes and table partitioning
• Wrote PL/SQL Stored Procedures, Functions, Overloading, Packages and Package Constructors to enforce business rules
• Used Native compilation of procedures and functions to improve performance.
• Generated and used SQL*Loader scripts to populate EAGLS staging schema from TOTAL-SYSTEMS feeds
• Utilized partitions to fine-tune SQL data retrieval and load
• Extensively utilized PL/SQL Cursors, REF Cursors, Collections features to perform ETL load from multiple-feeds of source data
• Setup and configured ETL runtime environment in Dev, TST, QA instances for efficient, time-constrained batch loads
• Used Oracle warehouse builder to load bulk data from various flat files into staging area.
• Created KORN Jobs to perform regular updates to the data warehouse database and keep the tables in sync with the OLTP data.
• Wrote Perl Scripts for the users to retrieve data over the web browser.
• Developed reports (exception reports) as per business requirement using Crystal Reports.
• Involved in logical and physical database design and Star Schema design, Identified Fact Tables, Transaction Tables.
• Performance tuned the queries using TKPROF, DBMS PROFILER.
• Created Java programs to query the database and generate XML Files.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Participating in code walk through and review sessions with the Java development team and offshore team.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, Oracle Warehouse Builder, TOAD, PVCS, Erwin 4.1, Mercury Test Director, Caliber RM, Windows XP, Red Hat LINUXExperience in India:

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in validating technical specs for RFQ, Purchase Order, Vendors, Customers, stock availability and invoicing processes.
• Designed and fine-tuned the logical and physical data model for Quote-to-Invoice process
• Generated number of SQL scripts to create Master and transactional tables, Views, Synonyms, audit, integrity constraints setup
• Created PL/SQL Stored Procedures, Functions, Packages utilizing Cursors, user-defined exceptions and reusing Oracle pre-defined packages
• Fine-tuned SQL using Explain Plan, SQL-Trace and TK-Prof utilities
• Debugged PL/SQL code for efficiency and optimization
• Conducted Unit-testing of the named subprograms based on test plans and test cases
• Assisted DBA and System administrator in scheduling Order validation and confirmation jobs using Unix Shell scripts
• Prepared and maintained documentation capturing the process, troubleshooting tips and scope changes

Environment: SCO UNIX 5, Oracle8i, SQL*Plus, SQL, PL/SQL

Confidential

Responsibilities:

• Extensively used Cursors, Indexes, Views, Sub queries, Joins, exceptions and sequences.
• Used SQL Server Isolation Levels for transactional control
• Developed complex Procedures, Packages, Triggers and Functions using Oracle PL/SQL, as a part of back end development and Interfaces.
• Fine tuning of SQL queries.
• Created tables, indexes, sequences and constraints
• Performed manual testing of the application.

Environment: Oracle8i, Windows NT, SQL*Loader, MS SQL server, Manual Testing