SUMMARY

• Total IT: 8 years of IT Experience with of Oracle Development experience including analysis, modeling, design, administration and maintenance of Oracle Database systems on both UNIX and NT platforms and Implementation of applications in the client/server environment.
• Oracle: 8 years of solid database experience on Oracle 10G/9i/8i, PL/SQL, SQL*Loader, Physical database design, Logical database design, Data Modeling (Designer 2000), Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
• PL/SQL: 8 years of strong back - end programming experience using PL/SQL, SQL, MS SQL, T-SQL, C, C++, Java, VB, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL, SQL*Loader and SQR( Hyperion reporting tool).
• Forms/Reports: 6 years of strong front-end programming experience using Oracle Forms 6i/5.0/4.5, Oracle Reports 6i/3/2.5, Oracle Report Writer, Oracle Developer 2000, SQR 3.0, Crystal Reports and Oracle Discoverer.
• DW: 3 Years of strong Data Warehousing and Business Intelligence experience using PL/SQL, Manual ETL, UNIX Shell Scripting, OLTP, OLAP, and SQL Loader.
• Data Modeling: 3 years of Data Modeling experience in Dimensional, Relational, Star and Snow-Flake schemas, fact and dimensional tables for Physical and logical data modeling using Erwin 4.5/4.0/3.5/3.0 , Oracle Designer, MS Vision
• Environment: 8 years of strong experience in Installation, Setup, Configuration, Maintenance and Tuning of Oracle 8i /9i//11i/8.0/7.x/ under UNIX (Sun Solaris 2.6, 7, 8) and Windows NT/95/98/2000 environment. Experience on Unix Shell Scripting, CGI/PERL, Autosys, ClearCase, Sun Solaris, Windows 2000, Windows NT 4.0, Windows 98/95/3.1, MS DOS 6.22, Novell Netware, IBM Compatibles, Sun Classic, Sun Sparc & Sun Ultra.

TECHNICAL SKILLS

Oracle: PL/SQL, SQL, MS SQL, Oracle Forms 4.5/5.0/6i, Reports 6i/3.0/2.5, Database Design (both Physical and Logical), Database Modeling (Designer 2000), Data Exports & Imports, Inbound/Outbound Interfaces, Performance Tuning, Administration, Software Maintenance, User & Security Management, Query Optimization, Export/Import Utilities

Databases: FoxPro, Informix, Oracle 7.x, 8.x, 9i, 10g, PL/SQL, SQL*Plus, SQL, MS-SQL, Cobol, JCL, TSO, DB2, MS Access, PRO*C.

Languages: SQL, PL/SQL, C, C++, Pro*C, VB, COBOL, Java, PL/SQL web, Toolkit, SQR, Sybase, Access, Advance Queries, VI

Programming: SQL, PL/SQL, Developer 2000 (Forms 11i/6i/4.5, Reports 6i/2.5), Unix Shell Scripting, SQL*Loader, SQL*Plus, Discoverer, Pro*C, C, C++, Java 2.0/1.2, XML, XSD, SOAP, WSDL, Siebel Prolog, Haskell, PASCAL, HTML 4.0, Visual Basic 5.0, FORTRAN, Assembly Language (8085/8086)

Reporting Tools: SQL Navigator, PL SQL Developer, Oracle Discoverer, Business Objects, Designer 2000, Tora Oracle Tkprof & Trace

DBA Tools: Server Manager, Oracle Enterprise Manager, TKPROF, IMP/EXP, SQL*Loader, SQL*NET.

Data Warehousing: Oracle Warehouse Builder 10.1/9i, Informatica Power Center 8.0/7.X/6.X/5.X/4.X (Source Analyzer, Data Warehousing Designer, Mapping Designer, Power plugs, Mapplet, Transformations), ETL, OLTP, OLAP, Data Reports, Writer

Data Modeling: ERwin 4.5/4.0/3.5/3.0 , Logical, Physical, Relational Modeling, ER Diagrams, Dimensional Data Modeling (Star and Snowflake Schema, fact and dimensions tables), Entities, Attributes, Cardinality, Oracle Designer 2000, MS Visio

Environment: Sun Solaris 2.6, Sun OS, MS DOS 6.22, Windows 3.x/ 95/98/2000/03/ XP, Windows NT 4.0, IBM compatibles, Red Hat Linux, SUN Sparc, Sun Classic, Sun Ultra, DOS, SUN Solaris 2.5/5.6 Unix and Linux

PROFESSIONAL EXPERIENCE

Confidential, Wilmington DE

ETL Developer

Responsibilities:

• Interacted with business to get the requirements.
• Analyzed data according to the business logic.
• Worked on the whole life of SDLC project.
• Analysis, Data Modeling and System Documentation of financial system
• Technical documents had been prepared for design, test plans and code review.
• Created database triggers to implement and enforce data integrity and security.
• Developed various backend application programs, such as inline Views, Ref cursors, Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL languages.
• Created Stored Procedures and Functions to be called by Java Demons.
• Written UNIX shell scripts to automate the process. Handled ctrlm jobs when critical jobs failed.
• Worked on complex framework for storing the transactional data in warehouse.
• Worked on Datastage for loading files to stage and from stage to Database.
• Worked on modifying and enhancing existing datastage jobs .
• Extensively used mapping and session parameters in ETL development.
• Worked with Excel sheets
• Enhance and maintain existing functionality.
• Optimize SQL queries for better performance.
• Written Korn Shell scripts for mounting database and create SQL*Plus session.
• Prepared user manual and technical support manual.

Environment: Oracle 9i, Datastage 8.1,Toad 10.0, Korn Shell Scripts.

Confidential, PA

Responsibilities:

• Interacted with the Business Analyst in collecting the technical and business requirements for the project.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse using inline views .(some 10 million rows of data)
• Worked on the software maintenance project that needs immediate fixes
• Implemented Java script in the entire event handling functions and procedure calls.
• Worked on External tables, Materialized views, complex procedures and packages.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.
• Worked on SQL loader for loading data into the database.
• Wrote complex adhoc queries.
• Worked on performance tuning for very complex queries using inline views, indexes and various tuning techniques.
• Worked on Forms and Reports 10g.

Environment: Oracle 10g/9i, Forms 10g, Reports 10 g, SQL loader, SQL Navigator, Java, UNIX - Putty, PL/SQL, UNIX Shell scripts

Confidential, CO

Responsibilities:

• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse using inline views .(some 10 million rows of data)
• Extensively worked on advanced queries for passing data between different interfaces between oracle clients and clarify client.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.
• Worked on performance tuning for very complex queries using inline views, indexes and various tuning techniques.
• Worked on Mercury Quality center for testing.
• Created backend queries, stored procedures, packages and database triggers.
• Used SQL Loader to load the large volumes of data into the central database.
• Developed many PL/SQL Triggers to monitor the database activities and to implement database security.
• Worked on Sqlserver in rolling up jobs with huge data with respect to a SOA project.
• Worked on Java applications as the front end being java.
• Used PVCS for the version controlling of the files.
• Embedded stored procedures in VI shell scripts and scheduled them in Autosys for reconciliation process which handles millions of data.
• Used Putty to embed the batch jobs in shell scripts.
• Worked on Oracle financials in payments and order management modules.
• Developed PL/SQL Functions for various calculations in the application.
• Extensively used cursors, cursor for loops to fetch the data from different tables.
• Involved in SQL Tuning by creation of indexes, rebuilding indexes, and clusters.
• Extensively used oracle queries for messaging between interfaces.

Environment: Oracle 10g/9i, SQL Developer, Java, UNIX - Putty, PL/SQL, UNIX Shell scripts, Autosys, SQL server 2005

Confidential, Florida

Responsibilities:

• Responsible for modifying applications utilizing Forms 6i for California Language Patient Chart Schedule and member id translation modifications.
• Involved in the technical detail designs of the database and requirements.
• Utilize PL/SQL and SQL to develop and modify Oracle packages, procedures and functions for new external ami and calap projects with interfaces to Java application.
• Have experience in property and casualty modules.
• Utilize SQR and Shell Scripting in a UNIX environment for reporting and data manipulation.
• Ran a lot of reports using SQR and tested the functionality by gathering the input parameters which is quite challenging as the data is test data is not up to the mark to generate the reports.
• Tuning Database and SQL scripts for Optimal Performance, Redesign and build the schemas to meet Optimal Performance measures.
• Developed different types of reports on reports 6i
• Worked on oracle applications like GL AP AR INV OM modules.
• Used different methodologies with 2 or more triggers in 2 or more methods and impressed the client.
• Worked on External tables by interfacing it with oracle database .Enhanced couple of forms.
• Worked on the enhancement of the forms and created some from the scratch.
• Worked on XML for passing the data to java stored procedures.
• Worked on the middle tier for oracle and Unix
• Used smart term for creating the shells and batch jobs to manage to run the SQRs with input parameters.
• Worked on different interfaces by coordinating with many people in order to generate EOBs and EOPs manually.
• Worked on the oracle financials as to make payments for the EOBs generated for the particular tax number.

Environment: Oracle 10g/9i, SQL Developer, J2EE,SQR Windows 2000, UNIX - smart term, PL/SQL, UNIX Shell scripts, oracle External tables, SQL loader, Oracle 11 i.

Confidential

Responsibilities:

• Interacted with the Business Analyst in collecting the technical and business requirements for the project.
• Generated WebPages with HTML tags using pre defined HTP and HTF Packages using PL/SQL web tool kit.
• Writing and designing schema, complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse
• Extensively worked on advanced queries for passing data between different interfaces between oracle clients and clarify client.
• Involved in the documentation and design of the database and involved in the coding of the interfaces and deployment.
• Created forms from forms 6i modifying them and deploying in order to sync with one of the interfaces.
• Implemented Java script in the entire event handling functions and procedure calls.
• Used SQL Loader to load the large volumes of data into the central database.
• Used Erwin for the data transformations and reporting.
• Developed many PL/SQL Triggers to monitor the database activities and to implement database security.
• Worked on reports 6i in one of the interface to generate reports.
• Extensively worked on forms and reports, modified couple and developed some from scratch
• Worked on the web services front end which demands the requirement.
• Developed PL/SQL Functions for various calculations in the application.
• Extensively used cursors, cursor for loops to fetch the data from different tables.
• Involved in SQL Tuning and debugging by creation of indexes, rebuilding indexes, and clusters.
• Extensively used oracle queries for messaging between interfaces.

Environment: Oracle 10g/9i,Access SQL Developer, PL/SQL Web Toolkit, Windows 2000, LINUX, PL/SQL, UNIX Shell scripts,, OLAP, SQL Loader, HTML, XML, Java script

Confidential

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Conducted focus group to determine what data elements are needed in Oracle.
• Involved in Designing and Modeling of the database using Erwin.
• Created entities and attributes in Logical Design. Followed proper naming conventions in Physical Design.
• Created Tables, Views, and Synonyms, Indexes, Sequence, Users and assigned privileges in development environment.
• Data from Flat Files been uploaded into Oracle Tables using SQL* Loader.
• Changed the database object structures as per development team’s request.
• Developed Database Triggers, Stored Procedures and functions written in PL/SQL to update the Base Tables and impose Integrity Constraints.
• Created Mappings, Mapplets and Transformations and imported source and target metadata in datastage.
• Created reports using Reports 6i.
• Worked with performance and tuning issues. Optimized existing SQL queries.
• Written Shell Scripts for automation of some daily tasks.

Environment: Oracle9i, SQL Loader, Datastage 8.0, SQL Developer, Crystal Reports, DB2, UNIX, Forms 6i, Reports 6i, JSP.