SUMMARY:

• Sr. Oracle Developer having more than 10 years of experience in Information Technology with expertise in analysis, design, development and maintenance of OLAP and OLTP Production applications, Data - Warehouse applications, Data Marts, Web based applications, Performance Tuning, Implementation and Support for Internet, Client/Server and Multi-tired applications using Oracle 11g/10g/9i/8i/7.x, SQL*Plus, PL/SQL, SQL Server, Windows NT/2000/XP and UNIX servers (Sun Solaris, HP-UNIX, Linux and IBM AIX), Stored Procedures/Packages, UNIX Shell scripts, PERL, SQL*Loader, Designer/2000, Oracle Web Application Server, TOAD, XML and HTML.
• Working knowledge and experiences of software development life cycle (SDLC) and project methodologies, as well as tools and techniques within each phase (e.g., requirement elicitation, data dictionaries, data diagram, ERD, programming languages, technical platforms, standards and procedures).
• Worked extensively on Hash/Range, Range,Hash, Composite Partitioning Environments and tuning of queries accordingly
• Strong database development experience in Oracle 10g/9i/8i, SQL and PL/SQL using P ackages, P rocedures, Functions, Triggers.
• Worked on large Data-Warehouse/Databases ranging from 1 TB to 10 TB having more than 400 users and over a million transactions per day with Data Modeling options.
• Involved in B usiness analysis and requirements gathering for various systems, including identification of facts, measures, dimensions and hierarchies for the business applications.
• Experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation, Data Validation and Data Loading (ETL).
• Wrote custom ETL and data cleansing program using PL/SQL (Packages, Procedures, Cursors), UNIX Script, SQL*Loader to load data to Data warehouse and Data Marts.
• Used Rational Clear Case/Clear Quest, SVN for migrating jobs from development to production environment.
• Created documents for functional requirements and technical design using a number of tools including Visio.
• Proficient in performance tuning and query cost based optimization (CBO) with utilities like Sql*Trace, TKProf and Explain Plan.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS:

Databases: Oracle7.x/8.0/8i/9i/10g/11g, SQL Server 7.0/2000, Teradata, DB2, DB2 UDB.

ETL Tools: Informatica, DataStage 7.5/8.1,SAS8.0, SQL * Loader, Oracle9i Warehouse Builder.

Operating Systems: MVS, Windows 98/2000/XP, Windows NT 4.0, SUN Solaris, HP-UX, Linux

And IBM AIX 4.0

Languages: C, C++,C#, .NET, PL/SQL, SQL, UNIX Korn shell scripting, Perl Scripting

Database Tools: SQL Plus, SQL * Loader, Import, Export, TOAD10.6.

Other Tools: Business Objects XI, Crystal Reports, Oracle Forms 9i, Oracle Reports 9i, Designer 2000, Erwin R7.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Developer

Responsibilities:

• Involved in debugging and tuning the PL/SQL code, tuning queries.
• Used Explain Plan, dbms xplan, indexing and hints for performance tuning.
• Involved in Zonal and Global batch runs to load data from ftp folder to staging schema.
• Created PL/SQL Procedure, Functions and Packages to load reporting schema (ETL).
• Created/modified UNIX shell scripts for batch jobs.
• Created Business Objects reports to support the front end application.
• Maintained the versions of scripts, documentation and code in SVN.
• Attended meetings and review to discuss current issues and processes to tackle such issues.
• Attended Design meetings, code review and test review meetings.
• Involved in Unit Testing, Regression testing and UAT.
• Involved in Production support.
• Used control-M for batch process.
• Used SQL* Loader to load the data feeds from different sources.

Environment: ORACLE 11g, Business Objects XI, PL/SQL, SQL * Loader, Toad 10.6, Control-M, UNIX AIX.

Confidential, Charlotte NC

Sr. Developer

Responsibilities:

• Involved in debugging and tuning the PL/SQL code, tuning queries.
• Used Explain Plan, dbms xplan, indexing and hints for performance tuning.
• Develop processes using ETL tools, PL/SQL and SQL to support business reporting requirements.
• Widely used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used Transformations like look up, Router, Filter, Joiner, Stored procedure, Source Qualifier, Aggregator and Update strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Attended Design meetings, code review and test review meetings.
• Worked with Dev, QA and Business teams in different phases of the SDLC
• Attended meetings and review to discuss current issues and processes to tackle such issues.
• Used SQL* Loader to load the flat files from different sources.

Environment: Informatica Power Center 8.6, SQL*Plus,, PL/SQL, Oracle 11g/10g, SQL* Loader, Toad, Win XP Pro, SVN, Flat files (delimited, fixed width), UNIX Shell scripting.

Confidential, Newport-New Jersey

Responsibilities:

• Designed, Developed and Generated SQL Scripts for various objects like Tables, Indexes, Triggers, Functions/Stored Procedures and Packages using TOAD 10.6.
• Used Explain Plan, dbms xplan, indexing and hints for performance tuning.
• Involved in debugging and tuning the PL/SQL code, tuning queries.
• Develop processes using ETL tools, PL/SQL and SQL to support business reporting requirements.
• Attended Design meetings, code review and test review meetings.
• Maintained the versions of scripts, documentation and code in SVN.
• Attended meetings and review to discuss current issues and processes to tackle such issues.
• Used SQL* Loader to load the flat files from different sources.
• Used control-M for batch job scheduling.

Environment: ORACLE 11g, PL/SQL, SQL * Loader, Toad 10.6, Control-M, UNIX AIX.

Confidential, Arlington VA

Sr. Developer

Responsibilities:

• Designed, Developed and Generated SQL Scripts for various objects like Tables, Indexes, Triggers, Functions/Stored Procedures and Packages using TOAD 9.7.
• Used Explain Plan, indexing and hints for performance tuning.
• Involved in debugging and tuning the PL/SQL code, tuning queries.
• Develop processes using ETL tools, PL/SQL and SQL to support business reporting requirements.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, TKProf utility.
• Attended Design meetings, code review and test review meetings.
• Maintained the versions of scripts, documentation and code in SVN.
• Attended meetings and review to discuss current issues and processes to tackle such issues.
• Assist in developing data models, as well as logical and physical database design.
• Used SQL* Loader for to load the flat files from other different sources.
• Used control-M for batch job scheduling.

Environment: ORACLE 11g, PL/SQL, SQL * Loader, Toad 8.6, Erwin, Windows 2000/2003, UNIX AIX.

Confidential, Washington DC

Sr Developer

Responsibilities:

• Involved in Re-Engineering of existing Design/Interfaces and preparation of Technical Design Documents and Data Flow Diagrams.
• Involved in designing Logical and Physical data models using Erwin 5.0.
• Involved in Normalization, Forward-Engineering and Reverse-Engineering.
• Designed, Developed and Generated SQL Scripts for various objects like Tables, Indexes, Triggers, Functions/Stored Procedures and Packages using TOAD 8.6.
• Involved in the audit process, Created PL/SQL Packages, Procedures, and Functions for audit process.
• Used SQL* Loader for to load the flat files from other different sources.
• Used Explain Plan, indexing and hints for performance tuning.
• Involved in debugging and tuning the PL/SQL code, tuning queries.
• Re-organization of database objects (Tablespaces, Tables, and Indexes etc.)
• Refresh of Development, QA and test databases using expdp and impdp utilities.
• Worked closely with Business Owners to make sure requirements where converted correctly to Functional Specs and the correct logic was implemented in the technical design and code.
• Attended Design meetings, code review and test review meetings.
• Maintained the versions of scripts, documentation and code in PVCS.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Attended meetings and review to discuss current issues and processes to tackle such issues.
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.

Environment: ORACLE 10g, PL/SQL, SQL * Loader, Toad 8.6, Erwin, Windows 2000/2003, UNIX AIX.

Confidential, Reston,VA

Sr Developer

Responsibilities:

• Was involved in the PO data migration/conversion from PSFT system to the EMPAC Oracle tables. The process involved moving the legacy tables PO headers, PO lines, PO vendors, PO distributors data into the interface tables and finally to Oracle tables via Oracle API. Wrote PL/SQL packages, procedures, and functions to perform mapping, validation and migration of data.
• Wrote DDL Scripts to create new database objects like tables, views, synonyms, and indexes.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Performed tuning of SQL queries because ATLAS had many calls in any single transaction upon user request.
• Used SQL* Loader for Data Conversions and to load the flat files from other different sources.
• Tuned SQL* LOADER and SQL Scripts to load data faster.
• Used Explain Plain, indexing and hints for performance tuning.
• Attended team status meetings and technical meetings.
• Worked closely with Business Owners to make sure requirements where converted correctly to Functional Specs and the correct logic was implemented in the technical design and code.
• Liaison to Business work streams - Escalated issues and requests related to the ATLAS tool set to senior management. Identified cross-team dependencies/intersection points and timing of critical deliverables.
• Attended Design meetings, code review and test review meetings.
• Documented solutions across processes, systems, users and asset lifecycle. Scenarios were systematically screened on ability to meet basic criteria. Interviewed key project stakeholders with regards to the current sources and uses of enterprise data, strengths and weaknesses in the current data stores, and business processes underlying the use of enterprise data.
• Maintained the versions of scripts, documentation and code in PVCS.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Attended meetings and review to discuss current issues and processes to tackle such issues.
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.

Environment: ORACLE 9i, PL/SQL, SQL * Loader, Toad 8.6, PeopleSoft SCM, UNIX, TOAD and EMPAC, mWarehouse, mFieldworks, Oracle Forms 6i.

Confidential, VA

Database Developer/DBA

Responsibilities:

• Involved in Re-Engineering of existing Design/Interfaces and preparation of Technical Design Documents and Data Flow Diagrams.
• Involved in designing Logical and Physical data models using Erwin 5.0.
• Involved in Normalization, Forward-Engineering and Reverse-Engineering.
• Designed, Developed and Generated SQL Scripts for various objects like Tables, Indexes, Triggers, Functions/Stored Procedures and Packages using TOAD 8.6.
• Involved in SQL Query optimization using Optimizer Hints.
• Performed SQL tuning for development code migration to production systems.
• Involved in SQL tuning for user based ad hoc queries.
• Developed PL/SQL (Procedures and functions) scripts to validate, load data from flat files received on regular basis from MCO’s and MMIS to Oracle database.
• Created control files for SQL Loader.
• Design and implement backup strategies by scheduling hot backups on Production database.
• Performs logical backups on Development Database using import export data pump and scheduling cold backups.
• Involved in daily activities include operational support of the live system including generation of extracts and reports, data management and maintenance, bug fixes, and management of automated extracts and uploaded data.
• Developed UNIX shell (ksh) scripts to automate engineering and testing tasks.
• Designed and developed an Audit process using a combination of PL/SQL and Unix scripts to provide health checks for data to maintain functional and referential integrity.
• Participate in Architecture and Design of new production databases.

Environment: ORACLE 10g/9i, PL/SQL, SQL * Loader, Crystal Reports XI, Visual Source safe 6.0,Toad 8.6, Unix AIX, Windows NT.

Confidential, Arlington, VA .

Responsibilities:

• Analysis and design of the data mart. Worked extensively with the data team and business architects to understand the nature and source of data.
• Generated requirement documents with detailed data flow diagrams and impact analysis.
• Used Erwin to create the physical and logical model of the system and to forward-engineer the schema objects.
• Developed Datastage mappings with extensive use of source qualifier, joiner and router and lookup transformations to load data into the rules engine data mart and setup a regular schedule for these mappings via sessions/batches using Workflow Manager.
• Used SQL*Loader, PL/SQL, stored procedures, packages, functions and dynamic tables for data load to a set of custom base tables. Used Unix scripts to process data where necessary.
• Extensively involved in the debugging and tuning of Datastage mappings by modifying system parameters. Used cost based optimization to tune Oracle 9i database queries and PL/SQL programs.
• All schedules were built using Datastage Workflow Manager, also created cron schedules for some load processes.
• Designed and developed an Audit process using a combination of PL/SQL and UNIX scripts to provide health checks for data in the mart so as to maintain functional and referential integrity.

Environment: Oracle9i (9.2.0.5), SQL, PL/SQL, SQL*Plus, SQL*Loader, AIX UNIX.