SUMMARY

• Over 8 years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation.
• Extensively worked in Client - Server application development using Oracle 8.0/8i, 9i, 10/g, 11/g, PL/SQL and SQL *PLUS, Reports 2.5/3.0/6i and SQL* Net.
• Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schema) and ER Diagrams using Microsoft Visio, Erwin and IBM Rational Rose data modeler tool.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables.
• Extensively Worked on Oracle Database creation, Table space management, (Export & Import) Backup, Performance tuning, Tuning Init.ora file.
• Working knowledge of SQL Trace, TK-Prof, Explain Plan, Pro*C, SQL Loader for performance tuning and database optimization.
• Understanding of the functionality and data model ofOraclePO, AP, AR, FV and GL modules
• Extensively worked in writing PL/SQL stored procedures, database triggers, exception handlers and cursors and ref-cursors and utPL/SQL test cases.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Expert in maintaining data integrity using various constraints and database triggers.
• Expertise in data migration with both (target - source) same database as well as with heterogeneous databases.
• Experience in working with Java developers to coordinate Web-based functionalities with Oracle Database
• Created the business model for a new Java based integrated care management system that was used across multiple divisions regarding healthcare claims and requests for information
• Coordinated all QA activities and enhancements usingAgileMethodology.
• Researched and updated problem data and code to resolve hundreds of help desk tickets
• Experienced inAgileMethodologyof Project Management
• Proficient in interpersonal relations, team lead skills, project management, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.

TECHNICAL SKILLS

• MS Office Suite
• Word
• Excel
• Outlook
• Publisher
• PowerPoint
• One Note
• Forecasting models
• Linear Regression
• Statistical Quality control
• SPSS
• SWOT analysis MS Windows (1997/2000/XP/NT/Vista) MS Share Point Rational Rose
• Requisite Pro
• Clear Case
• Clear Quest
• Bugzilla
• Mercury Quality Center Microsoft Access
• TOAD
• SQL Server
• Oracle 10g 11g
• SQL Navigator and TOAD
• Oracle Internet Applications Server (9iAS)
• Oracle Application Server (OAS)
• MySQL 4.1 5.X
• SQL Server 2000/2005 HTML
• HTTP
• XML
• Core Java Microsoft
• Unix
• Linux
• SQL
• PL/SQL
• C and UML
• Oracle 8i/9i/10g 1g
• MS-AccessServer7.0
• SSRS
• Designer 2000
• MS SSRS 2005
• 2008 MS SQL Visual Basic6.0
• SQL*Loader shell scripting
• Iterative Development and Process Design Re engineering
• Agile
• RUP
• UML
• SDLC (Waterfall
• Spiral
• Rapid
• Prototyping)
• Use Cases
• Data modeling
• Research
• Analytics
• Statistical Modeling
• UATMS Office Visio
• MS Office Project
• Microsoft Office Suite 2010
• Informatica
• Micro Strategy

PROFESSIONAL EXPERIENCE

Confidential - NYC, NY

Oracle PL/SQL Developer

Responsibilities:

• Expertise in complete software development life cycle process which include Analysis, Design, Development, Testing and Implementation.
• Utilized SQL * Loader, External Table to load flat files database tables, created scripts for database objects, export file for loading data into production.
• Expert in writingoracleStored Procedures, Functions, Database Triggers and Packages, cursors, Objects and PL/SQL collections etc.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Worked on data export and import wizard to transfer data between different schema in oracle using TOAD.
• Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.
• Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
• Sound Knowledge in understanding already existed packages, and worked with them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Developed, enhanced, maintained and supported the Web for Student, the Web for Faculty and Internet Native Banner Forms using Oracle, PL/SQL Web Toolkit, SQL, PL/SQL, Oracle Forms and a third party product called Sungard SCT Banner.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Worked with Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with Unix shell scripts and PERL scripts to generate daily reports.
• Experienced inOraclesupplied packages Such as DBMS SQL, DBMS JOB, UTL FILE, DBMS LOB, DBMS UTILITY etc.
• Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
• Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

Environment: ORACLE-PL SQL, Oracle 10g, 11g, TOAD, UNIX, Shell Scripting, TOAD, SQL*LOADER,PRO*C, Java1.7, J2EE, Net Beans 7.4, HTML, JavaTechnologies JSP, Servlets, My SQL 4.1, 5.X

Confidential - Bridgewater, NJ

Oracle PL/SQL Developer

Responsibilities:

• Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
• Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Involved in Extraction and loading of data in between the schema using oracle Export and Import utilities.
• Involved in designing Technical specification document, identified various data mappings and the design of Data warehouse.
• Loaded data using to database using ETL tools like SQL* loader and external tables to load data from data warehouse and various other database like SQL Server and DB2.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schema.
• Created scripts to load the data into staging tables from other database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Developed UNIX shell script to automate notification of Emails, to the users when a process fails in production.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in the database administration and creating objects such as database, users, and schema and table spaces.
• Involved in production support by efficiently debugging the production issues.

Environment: Oracle 10g(, Reports 6i, Forms6i, Erwin, TOAD for MySQL, TOAD, Control M 6.2.01, CVS Pro*C, Mainframes, UNIX, Linux, Windows NT, Windows 2000, SQL Navigator, MS Outlook 98,MS Office 2000, shell scripting

Confidential - Vancouver, WA

Oracle Pl/SQL developer

Responsibilities:

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in uploading of the data from flat files into Databases and validated the data withPL/SQL procedures.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching betweenSQLandPL/SQLengines.
• Generated TKPROF reports from Oracle 10g/9i database and analyzed the reports for Oracle wait events, time consumingSQLqueries, table space growth, and database growth.
• UsedSQLtrace and TKPROF & SQL*LOADER,PRO*C
• PerformedSQLtuning using Hints and indexes.
• Performed the data analysis and mapping; database normalization, performance tuning, query optimization; data extraction, transfer, and loading (ETL) and clean up.
• Implemented Teradata RDBMS analysis with Business Objects to develop reports, interactive drill charts, balanced scorecards and dynamic Dashboards.
• Responsible for requirements gathering, status reporting, creating various metrics, projects deliverables.
• Partitioned tables and indexes for better performance of application
• AnalyzedSQLstatements; reorganize database objects to improve response of queries.
• Involved in handling the changes in compiling scripts according to the database changes.
• Involved in the development and set up of various equity and fixed income indices.
• Do the daily stand up meeting to identify the critical issue and discuss about their suggestions as part of project development concern.
• Maintaining daily batch cycle and providing 24-hour production support.
• Interact with business to get the feedback about the application and about the value creation.

Environment: Oracle 10g(Reports 6i, Forms6i, Erwin, TOAD for MySQL, TOAD, Control M, Pro*C, Mainframes, UNIX, Linux, Windows NT, Windows 2000, SQL Navigator, MS Outlook 98, MS Office 2000, shell scripting

Confidential - Gaithersburg, MD

Oracle PL/SQL developer

Responsibilities:

• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.
• Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
• Sound Knowledge in understanding already existed packages, and worked with them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Developed, enhanced, maintained and supported the Web for Student, the Web for Faculty and Internet Native Banner Forms using Oracle, PL/SQL Web Toolkit, SQL, PL/SQL, Oracle Forms and a third party product called Sungard SCT Banner.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Worked with Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
• Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
• Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

Environment: SQL Server, J2EE, UNIX, MS Project, Oracle, Web Logic, SOX Compliance, JavaScript, HTML, Microsoft Office Suite 2010, Excel, Windows 2007 Enterprise, TOAD, HTML, XML, JAVASCRIPT, CSS, ETL, SDLC, Waterfall, Agile methodologies.

Confidential

Database Developer/Tester

Responsibilities:

• Build the new universes in Business Objects as per the user requirements by identifying the required tables from Data mart and by defining the universe connections
• Used Business Objects tocreate reports based onSQL-queries.Generated executivedashboardreports with latest company financial data bybusinessunit and by product.
• Performed the data analysis and mapping; database normalization, performance tuning, query optimization; data extraction, transfer, and loading (ETL) and clean up.
• Implemented Teradata RDBMS analysis with Business Objects to develop reports, interactive drill charts, balanced scorecards and dynamic Dashboards.
• Responsible for requirements gathering, status reporting, creating various metrics, projects deliverables.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Designed and developed Informatics Mappings to load data from Source systems.
• Worked on Informatics Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Involved in migrating warehouse database from Oracle 9i to 10g database.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER create directory, data pump, CONNECT BY ROOT in existing Oracle 9i application.
• Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Developed BO full client Reports, Web intelligence report in 6.5 and XI R2 and universes with context and loops.
• Migrated Reports from 6.5 thick clients (desktop Intelligence report) to XI r2 Thin Client (Web Intelligence Report) through Report Conversion Tool (RPT) and Import wizard.

Environment: Quality center, Quick Test Professional 8.2, SQL Server, J2EE, UNIX, .Net, MS Project, Oracle, Web Logic,Shell script, JavaScript, HTML, Microsoft Office Suite 2010, Excel