SUMMARY:

• Over nine years of IT experience as an SQL, PL/SQL Developer on a variety of Windows 2000/2003/Xp platforms with Sybase and Oracle 9i/10g.
• Expertise in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data Warehouse from heterogeneous databases such as Sybase, Oracle, Excel and MS Access.
• Expertise in creating cubes with dimensions and facts tables using SQL Server Analysis Services (SSAS).
• Expert in creating and deploying SSRS reports on the portal for user accessibility.
• Experience in all phases of the project Life cycle - Requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.
• Very Good Knowledge about the Oracle tools like TOAD, SQL*PLUS and SQL Navigator.
• Proficient in Query/application tuning using Optimizer hints, Explain plan, SQL trace, TKPROF.
• Created table partitions to improve performance and data management.
• Experience in data modeling using Erwin and Visual studio.
• Experience in creating Materialized Views.
• Experience with locally managed and dictionary managed tablespaces.
• Expert in Creating Public Synonyms, DBLinks.
• Managing security by creating and granting roles and privileges to users.
• Knowledge of DBMS JOBS, DBMS PROFILER, DBMS SCHEDULER packages.
• Experience in developing External Tables, Stored Procedures, Table Partitions, Functions, Packages, Views, Joins, Indexes, Cursors and Database Triggers, Collections.
• Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref. cursors, nested tables and Dynamic SQL.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Experienced in writing UNIX shell scripts.
• Have written scripts involving table level triggers to monitor table transactions and maintain history.
• Expertise in handling errors using Exceptions.
• Experience in database application development using Interactive SQL, SSMS, Aqua Data Studio, TOAD, and SQL Developer.
• Good experience in sending the request to web service and getting the response from web service.
• Experience in parsing of XML’s using DOM Parser i.e. DBMS DOM.
• Knowledge of Oracle 9i and 10g Database Architecture.
• Making structural changes to the database.
• Documentation of projects and databases.
• Work with software developers to develop and enhance applications.
• IT experience in Software Development Life Cycle (SDLC), which involves Requirements Gathering, Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Experience in performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Clear communication and documentation of technical specifications.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills.
• Expert Skills in time management, prioritizing tasks.

TECHNICAL SKILLS:

Operating Systems: Windows NT/XP/2000

Software & Languages: SQL, PL/SQL, UNIX Shell scripting

Databases: Sybase, SQL Server 2008, Oracle 9i, 10g

Tools: Interactive SQL, SQL Server Management Studio, Aqua Data Studio, Toad, SQL Navigator, Erwin, Visio, SQL Plus, Contivo Analyst, ContivoRepository, Contivo Builder, Visual Source Safe, CVS, SVN

Utilities: Explain plan, DBMS Profiler

PROFESSIONAL EXPERIENCE:

Confidential

Application Architect

Responsibilities:

• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Develop/maintain from simple to complex reports that might include sub-reports and drill down capabilities and other features supported by SSRS.
• Created OLAP cubes and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Involved in Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Analysis Services.
• Wrote Package containing several Procedures and Functions in PL/SQL to handle sequencing issue.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created temporary tables to load the test data into the temporary tables.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Logical and Physical data modeling using ERWIN.
• Good knowledge of Oracle RDBMS
• Created the indexes and analyzed the table for better performance.
• Experience in building Indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.

Environment: Sybase, UNIX, SAS, SSMS

Confidential

Developer

Responsibilities:

• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Wrote Package containing several Procedures and Functions in PL/SQL to handle sequencing issue.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created temporary tables to load the test data into the temporary tables.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Logical and Physical data modeling using ERWIN.
• Good knowledge of Oracle RDBMS
• Created the indexes and analyzed the table for better performance.
• Experience in building Indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.

Environment: SSMS, Sybase, Unix, SAS

Confidential

Mapping Expert

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, low-level design, mapping and testing.
• Extensively involved in Mapping between source and target systems.
• Developing functions for rule editor using procedures, functions and packages.
• Involved in testing of developed Maps.
• Involved in QC support.
• Participated in IT support.
• Involved in UAT support.

Environment: Contivo Analyst, Contivo Repository

Confidential

Module Lead and Oracle PL/SQL developer

Responsibilities:

• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Wrote Package containing several Procedures and Functions in PL/SQL to handle sequencing issue.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Created temporary tables to load the test data into the temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections and Dynamic SQL.
• Logical and Physical data modeling using ERWIN and Visio.
• Good knowledge of Oracle RDBMS
• Created the indexes and analyzed the table for better performance.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks
• Experience in building Indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.
• Used Explain plan for Tuning the SQL statements by creating indexes.
• Experience with Pl/SQL Tuning using DBMS PROFILER.
• Use of Optimizer Hints to tune the Sql Queries.
• Worked extensively on Exception handling to error handling and tracking.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Documented test cases and test logs.
• Involved in unit testing, integration testing and UAT.

Environment: Oracle 10g, Toad, VSS

Confidential

Module Lead and Oracle PL/SQL developer

Responsibilities:

• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Wrote Package containing several Procedures and Functions in PL/SQL for business application development.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Involved in Creation of tables, Partition of tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Wrote code to send the request to web service and get the response from web service.
• Wrote Java stored procedures in Oracle PL/SQL to interact with the front end applications.
• Extensively worked on parsing of XML’s using DOM parser. Used DBMS DOM package for parsing.
• Worked on UTL FILE package for reading the text files and extracting data into tables.
• Experience in using packages like DBMS JOBS to schedule background processes.
• Extensively used the advanced features of PL/SQL like collections and Dynamic SQL.
• Created temporary tables to load the test data into the temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Logical and Physical data modeling using ERWIN and Visio.
• Good knowledge of Oracle RDBMS
• Created the indexes and analyzed the table for better performance.
• Experience in building Indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.
• Used Explain plan for tuning of SQL statements by creating indexes.
• Experience with Pl/SQL Tuning using DBMS PROFILER.
• Use of Optimizer Hints to tune the SQL Queries.
• Worked extensively on Exception handling to error handling and tracking.
• Wrote shell scripts to interact with the files on the Unix server.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Good interaction with the front end application developers to understand their requirements and do the backend coding appropriately.
• Documented test cases, test logs, and user guides.
• Involved in unit testing, integration testing and UAT.

Environment: Oracle 10g, Toad, UNIX, Java, Web services, VSS.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Involved in various stages of SDLC like Coding, Testing.
• Wrote Package containing several Procedures and Functions in PL/SQL for business application development.
• Worked on sequences, functions, synonyms, triggers, packages, stored procedures.
• Involved in Creation of tables, Join conditions and views for the business application development.
• Experience in using packages like DBMS JOBS to schedule background processes.
• Extensively used the advanced features of PL/SQL like collections and Dynamic SQL.
• Created temporary tables to load the test data into the temporary tables.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Good knowledge of Oracle RDBMS
• Created the indexes and analyzed the table for better performance.
• Experience in building Indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.
• Worked extensively on Exception handling to error handling and tracking.
• Extensively used TOAD for database access and PL/SQL Development.
• Documented test cases and test logs.
• Involved in unit testing.

Environment: Oracle 10g, Toad, VSS.

Confidential

Oracle PL/SQL developer.

Responsibilities:

• Design Low Level Design documents from HLD.
• Wrote Package containing several Procedures and Functions in PL/SQL for business application development.
• Worked on sequences, functions, synonyms, triggers, packages, stored procedures.
• Involved in Creation of tables, Join conditions and views for the business application development
• Resolving ITS issues by using AR-System.
• Involve in various GAP Analysis work for different products.
• Involve in Releases for different network products of BT.
• Involved in preparing release notes and release scripts for various releases.
• Actively participate in various Conference Calls and CCB calls.

Environment: Oracle 9i, SQL Navigator and VSS.

Confidential

Oracle PL/SQL developer.

Responsibilities:

• Design Low Level Design documents from HLD.
• Wrote Packages containing several Procedures and Functions in PL/SQL for business application development.
• Coding for 100M Ethernet distance based charges.
• Coding for changing the non-distance based products to distance based products.
• Converting all Non-ADSL rental charges to distance based rental charges.
• Written Script in VB for automated test combination generation.
• Written script in VB for row distance calculator test case generation.
• Exporting from front end application to CSV (contents of web page to Excel sheet).
• Involved in debugging of code.
• Involved in Testing.

Environment: Oracle 9i, VB, SQL Navigator and VSS.