SUMMARY

• More than 10 Years of extensive experience in design, analysis, development and project implementation of information system with experience in Federal, Financial, Brokerage and Health Care Domains.
• 8years of experience currently working as an Oracle Pl/SQL programmer.
• Proficient PL/SQL Developer - Strong exposure in writing simple and complex SQL queries and creating PL/SQL Functions, Stored Procedures and Packages
• Experienced in advanced PL/SQL concepts such as VArray, Cursors, Bulk Collect and Dynamic SQLs
• Strong experience of developing, implementing and maintaining application systems underUNIX Operating Systemusing SQL, PL/SQL, Oracle Forms/SQL*FORMS, C, PRO*C, SQL Server,Unix Shell Script, Oracle 10g/9i database.
• Experience in Creating reusable DDL, DML SQL queries that can be used for different input data to validate against the User Interface.
• Proficient in creating Oracle objects - Tables (Partitioned & Non-Partitioned), Views, Materialized Views, Triggers, Synonyms, Nested tables and Collections
• Developed various tools for - DB standardization, DB hygiene and maintenance activities
• Worked on various Oracle utilities and Application developers such as TOAD, SQL Developer, SQL *PLUS, SQL *Loader.
• Good experience working on logical and physicalData Modelingusingnormalizing Techniques
• Expertise in Performance Tuning and Query Optimization - Extensive experience in analyzing query performances using EXPLAIN PLAN
• Experienced in re-designing PL/SQL procedures and fine tune queries to improve performance
• Experienced Technical writer - Involved in discussions with Business Users along with Business Analysts and provided feasibility report of business requirement
• Highly experienced in system analysis and translating Software Requirement Specification (SRS) and Business Requirement Specification (BRS) into Technical Specifications and Design
• Working knowledge on UNIX and Data Warehousing/ETL concepts - CreatedShell Scriptsfor invoking SQL scripts.
• Experienced in Design and Development of Data warehousing solutions for Extraction, Transformation and Loading (ETL) mechanism using Informatica
• Sound knowledge on SDLC process - Involved in all phases of Software Development Life Cycle- analysis, design, development, testing, implementation and maintenance of applications using Methodologies such as AGILE methodology.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i SQL Server 2008/2005/2000, MS Access:

Operating Systems: Windows Server 2003, Windows 7/Vista/XP/2000/NT, UNIX:

Development Tools: Visual Studio 2010/2008/2005/2003, Visual Studio 6.0:

Microsoft Technologies: .Net Framework 4.2/ 4.0/3.5/2.0/1.1 /1.0, ADO.NET, ASP.NET 4.0/3.5/2.0/1.1

Scripting Languages: JavaScript, VB Script, JQuery, SQL * Plus, Pro*C:

Markup Languages: XML/XSD, XSL/XSLT, CSS, HTML, DHTML:

Reporting Tools: APEX,SSRS, Crystal Reports 10.0/9.0/8.0, Business Objects:

ETL/Other Tools: Informatica, MS Visio, NUnit, UML 2.0, ERWIN3.5.2,4.0, MS Office:

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr Data Architect/Modeler

Responsibilities:

• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Created database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL in 10g.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Improved the performance of the application by rewriting theSQL queries.

Environment: Oracle 11g, Oracle Forms (11g, 10g), Agile, SQL * Loader, Autosys, UNIX, Erwin.

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Gathering the functional requirements from users and converting them into Technical requirements using AIM methodology and get sign-off from DBA/Architects.
• Migrated DB tables from Oracle 7 to Oracle 10g and altered tables with new data types.
• Migrated PL/SQL Code from Oracle 7 to 10g and implemented Object types.
• Created database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL in 10g..
• Performed thorough Unit testing, System Testing and User Acceptance Testing in development environment for the result of error free and smooth migration process and provided quality work for functional users.
• Developed various procedures, functions and packages to implement thenew business using Oracle PL SQL.
• Statement level, row level database triggers were developed for auto updating the data.
• Responsible for code development using PL/SQL in UNIX environment.
• Preparation of Test Plans.
• Responsible for the yearly ROLLOVER process.
• Responsible for migration the SQL server database for “LOCATION” schema to ORACLE.

Environment: Oracle 11g, Oracle Forms (11g, 10g), Agile, SQL * Loader, Autosys, UNIX

Confidential, NYC

Lead Oracle Pl/SQL Developer

Responsibilities:

• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Single point of contact for all database changes and handled all DML and DDL scripts in code repository.
• Create reusable DDL, DML SQL queries that can be used for different input data to validate against the User Interface.
• Developed UNIX shell scripts to connect and download data from various internal systems and external firms.
• Worked with the testing team to resolve bugs related to day one ETL mappings before production.
• Created and monitored workflows and taskusing Informatica Workflow Manager.
• UsedDTS Packagesas ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Preparing ETL mapping Documents for every mapping andData Migrationdocument for smooth transfer of project from development to testing environment and then to production environment
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object type’sand Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Agile, Oracle 11g, SQL * Plus, TOAD, Oracle Forms 9i, SQL* Loader, Informatica, SQL Developer, Shell Scripts, UNIX, Erwin, Windows XP

Confidential

Sr. Technical Consultant

Responsibilities:

• Created PL/SQL packages to perform validations on the imported data and load into the Interface table from legacy system.
• Used AUTONOMOUS TRANSACTION PRAGMA in the procedures to control the transactions.
• Redesigned existing stored procedures using the Bulk Collect to improve performance of business modules and also created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and TKProf.
• Created value sets, Custom menu, Responsibility, users, Request Groups, Request Sets, Concurrent program and Executable for the custom programs.
• Developed custom Forms and Reports as per client requirements using Oracle Forms builder and Oracle Reports builder respectively.
• Worked on: Order Management, Order Management Pricing Validations, Auto-Creation of Projects, etc.
• Worked on critical/high/medium defects and resolved them with proper resolution during different phases of testing-PT/SIT/UAT.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, Oracle Forms, TOAD, XML, HP-UNIX shell scripting.

Confidential

Senior Developer

Responsibilities:

• Used VB.NET for developing the Module, Windows forms.
• Used third party controls Infragistics in Forms.
• Created database templates and scripts to extract from Legacy system to Smart Bank Application.
• Wrote stored procedures/functions for accrual of Wrote client side validations using JavaScript.
• Created several user controls VB.NET
• Worked on Complex Stored Procedures, Functions, Triggers in Sql Server
• Created data import export packages.
• Performance tuning of Application
• Code Review and Integration Testing
• Computation of Interest accrual
• Created various reports like tabular reports, matrix reports, and parameterized reports using SSRS.

Environment: VB.NET, Visual Studio.NET 2008/2010, T- SQL, Unix, SQL Server 2005,Oracle, .NET Framework 3.5, WCF, Silverlight, Windows XP.