SUMMARY

• Result - oriented professional having vast experience in the IT industry who excels at managing and executing mainly Database oriented assignments and client/server custom development projects, across the entire project lifecycle (SDLC), collaborating with project teams, interfacing with clients, and deploying technology to build successful solutions for customers.
• My major strengths include Oracle design and applications using Oracle 11g Technologies, Object oriented analysis, design, prototyping, development, user acceptance testing (UAT), implementation and documentation expertise in Databases using SQL, PL/SQL.
• My strong asset is in proven leadership, excellent communication skills, very competent, strong team player and attention to detail with a clear vision to accomplish the company goals.
• More than 7 years of experience in Information Technology in the field of Systems Development, Software Development, Web Development, Systems Integration, Shared Services and Project & Resource Management.
• Experienced in Software Development Life Cycle Projects using Oracle SQL, PL/SQL and Web on Oracle 11g technologies
• Experience in business requirements gathering, define and capture metadata for business rules, creating physical infrastructure, system analysis, design, development and user training associated with the ETL processes.
• Technically competent with several years of hands-on development experience with Oracle
• Database administration and maintenance such as db creation, user and roles creation, stored procedures, triggers, maintenance plan, DTS and replication using Oracle.
• Super Knowledge on data modeling for both OLTP, OLAP
• 7 years experience in Oracle PL/SQL, SQL tuning and overall database performance tuning, advance PL/SQL techniques (i.e. collection, REF cursor, table function etc.).
• Expert hands on analytic functions.
• Hands on Experience on PLSQL Web Toolkit
• Clear concept on data warehouse design (i.e. Star schema & snow flake)
• Super Knowledge on handling large volume of data (Multi terabyte)
• Hands on experience on parallel execution, table partitioning, process scheduling.
• Very much expert on developing database trigger, procedure, package, functions and have some more expertise on scheduling with dbms package and implement RLS(row level security)
• Expert on Dynamic SQL
• Expert hands on oracle built in packages (i.e. DBMS *, UTL * etc.)
• Expert hands on data loading with SQL* loader and external tables.
• Expert hands on database space administration, Query optimization, CBO (Cost based optimizer), SQL tuning with STA (Sql tuning advisor), ADDM, Temporary segment monitoring, long running process monitoring and oracle wait events
• Hands on experience on data migration from test server to production server.
• Duplicate database.
• Hands on experience on OEM.
• Experience on data movement with transportable table space, exp dp, imp dp, exp, imp.
• Extensive Knowledge on Oracle 10g & 11g
• Worked with different reporting tools (Oracle Report, Crystal Report).
• Experience in Object Oriented Analysis and Design (OOAD) techniques like Unified Modeling Language (UML), IT Security and Controls (Authentication, Authorization)
• Technical experience in architecting and building client / server applications and handling on-site/offshore models
• Knowledgeable in Data Modeling/Database Design (using SD-pro and MS Visio)
• Expertise on working in Unix environment
• Experience working in virtual teams and multi-cultural environment.
• Effective leadership experience driving process improvements
• Excellent Oral/written communication, presentation and documentation skills

TECHNICAL SKILLS

Operating Systems: Windows and Unix, Windows XP/NT/2000

Programming/Scripting Languages: PL/SQL, PHP, C#, .Net framework 3.5, Fortan77, Java2, VBScript, JavaScript

Databases/RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2005 (Oracle- PL/SQL, T-SQL, Stored Procedures, DTS), MS Access. SQL* Plus, SQL Loader, SQL Developer, TOAD

Web/Implementation Technologies: Oracle ADF framework, ASP 3.0, IIS 6.0, HTML, XML, CSS, TCP/IP, Web Services, JSP, ADO .Net, ODBC, Multi-tier architecture, JDBC.

GUI/Tools: OBIEE(Oracle Business Intelligence Enterprise Edition), Visual Basic 6.0, PVCS Version Manager, PVCS Defect Tracker, Visual Source Safe (VSS), MS Office 2007 (Word, Excel, Power Point), MS Visio, MS Project, Test Director/QC, QTP, Load Runner

Others: SQL Navigator, Data Modeling, ER Modeling, Visio

PROFESSIONAL EXPERIENCE

Confidential - NJ

Application Developer

Responsibilities:

• Involved in the design development, testing of Application using ORACLE RDBMS, SQL, PL/SQL, SQL*Loader.
• Participated in the full SDLC software design applying BPM Patterns.
• Worked on database design with the team. Designed database, schema objects stored procedures, functions, and triggers, Packages using cursors.
• Loaded huge amount of records into staging tables using SQL Loader.
• After the development life cycle, worked on the same application maintenance/support.

Environment: Oracle 11G, UNIX Shell Programming, SQL, PL/SQL, SQL*Plus, TOAD, SQL Developer

Confidential - NJ

Application Developer - Oracle, PL/SQL Server

Responsibilities:

• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Applied Business Process management (BPM) patterns and Object Oriented techniques as per industry standards to consistently enforce business rules/policies across processes.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using ERwin.
• Developed PL/SQL Packages to extract, transformation and loading of data.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Experience in Generating Reports.
• Used joins, indexes effectively in where clauses for Query optimization and worked in performance tuning.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Oracle 11G, UNIX Shell Programming, SQL, PL/SQL, SQL*Plus, TOAD, SQL Developer