OBJECTIVE

Looking for a career full of challenge and opportunity in a corporate world where enthusiasm, sincerity and hard work is rewarded with encouragement, growth and opportunity to prove one-self.

PROFESSIONAL SUMMARY

• Over 8 years of professional experience in IT industry in Oracle SQL/PLSQL development and support.
• Strong IT experience in analysis, documentation, designing, development, testing, implementation and support in various content management suites, Oracle/DB2 Database and UNIX/Solaris 10/Linux operating systems.
• Strong experience working on Cognos Business Objects reporting and configuring it with the Datamart for DW reporting.
• Experience and knowledge of Telecom, Equity, Fixed Income, Insurance, brokerage and financial
• data applications/domains.
• Experience in COBOL JCL on mainframe system program s support and enhancement.
• Proficient in working in 24 7 environment and carrying pagers.
• Hands of experience in writing, testing and implementation of Database Stored Procedures, Functions, Triggers at Database level using PL/SQL programming.
• Proficient in using/operating/installing on jobs, servers and agents monitoring tool such as TIDAL SCHEDULAR, CONTROL-M TWS as administrator.
• Involved in the development, Enhancement and Maintaining of applications in Oracle 9i/10g/11g using SQL, PL/SQL in windows and UNIX environments.
• Strong experience in working on XQUERY, XML reporting XML files to Oracle data conversions in 11g and below.
• Experience of migrating the SQL SERVER database objects to ORACE 10g and performing data analysis so as to improve the performance as part of SQL TUNING.
• Extensive experience working with the Oracle Developer Suite.
• Highly skilled in writing Stored Packages, Procedures, Functions, Views and Database Triggers using SQL and PL/SQL.
• Strong PL/SQL experience with Cursors, Ref cursors, collections, Dynamic SQL, DBMS Packages, Materialized views, UTL File, Import/Export Utilities and Shell Scripting.
• Expertise in using tools such as SQL Plus, SQL Navigator, TOAD, SQL Developer and SQL Loader.
• Developed and supported Extraction, Transformation and Load process using Pl/Sql scripts to populate the tables.
• Extensive experience in data modeling. Created ER Diagrams on Erwin, Microsoft Visio and Smart Draw using Normalization Techniques.
• Expertise in Interacting Customer, understanding needs, focusing on issues and translating them into technical actions.
• Good analytical and leadership skills, commitment to co-operative teamwork and developing high quality software meeting requirements of the customer.

TECHNICAL EXPERTISE

• Web Technologies: HTML, DHTML, XML, JavaScript, SERVLETS, JSP, JDBC.
• Programming Languages: C, C , PL SQL, Java, JCL, COBOL, DQL XQUERY.
• GUI: Oracle Developer - Forms 9i/10g, Reports 9i/10g, Discoverer
• /9i/10g, Developer 2000.
• Databases: Oracle 9i/10g/11g, IBM DB2, MS Access
• Application Server: Jboss, Tomcat, Weblogic
• Operating System: Solaris 10/Linux/DOS / Windows 98/NT/2000/XP
• Development Tools / IDE: Eclipse, Toad, DB Visualizer 7.0.2, Project Raptor, Jdeveloper,
• SQL Navigator, SQL PLUS
• Configuration Management: Visual Source Safe
• Content Management: Documentum 5.3/6.5,Metaviewer
• Ticket/Request handling: Clarify-CRM, Kintana, Service Now, JIRA.
• Server/Jobs monitoring: TIDAL SCHEDULAR, CONTROL-M, TWS UC4
• ETL Reporting tools: Informatica Power Center 7.1, Business Objects 5.1/6.5,
• Crystal Reports 6.5, Cognos, OBIEE 11g
• Data Modeling Tools: Erwin, ER-Studio.
• Other tools: Citrix, Winscp, Re-point, Putty, WS FTP Pro.

SUMMARY OF IMPORTANT PROJECTS

Sr. Oracle Developer- Tech. Lead

CONFIDENTIAL is one of the world's leading banks that operates throughout the globe mainly CONFIDENTIALis its global multi-asset brokerage division. It offers execution, clearing, and prime brokerage Services.CONFIDENTIALis one of the world's largest futures commission merchants FCM which primarily serves institutional clients and provides access to more than 85 Stock exchanges.

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Developed Stored Procedures, Functions and Packages for implementing complex business logic.
• Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Involved in the ETL process of developing new tables from the existing views and materialized views.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 11g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Created SQL Loader scripts to load data from external system to oracle.
• Work on XQUERY for generation of XML data for end clients and also receive data in form of XML and then convert that to Oracle data.
• Scheduling of various process to automate them for live production warehouse system.
• As a senior Developer responsible for creating and managing PLSQL packages used by front end Java applications as well as batch applications using Bulk loading, Dynamic Sql, ref Cursors, regular expressions.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Responsible for performance tuning of SQL queries written in procedures and functions at the back end which are called from the front end forms
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL's thorough out the projects
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Acting as onsite team coordinator and involved in various activities such as client servicing, requirement gathering, and DB request Handling, PL/SQL enhancement and support.

Environment: UC4, JIRA, Oracle 11g, TOAD, PL/ SQL, Business Objects XI, OBIEE 11g.

CONFIDENTIAL

Sr. Oracle Developer- Project Lead

CONFIDENTIAL

Served as a Sr. Oracle Dev/Lead/Consultant in the enhancement and development of an enterprise data warehouse/business intelligence application for the automotive services at Tyco Electronics Connectivity. Primary focus and/or development efforts were in the re-engineering of the ETL processes using the Oracle Data Integrator formerly known as Synopsis tool. Additional tasks included the creation of schema objects tables, views, indexes, packages, triggers, etc. in an Oracle10g environment, the expansion of a single dimensional data model star schema into multiple star schemas, source to target mapping, storage capacity planning and the support and maintenance of the Cognos EP Series 7 reporting environment. Actively involved and lead creation of DATAMARTS and data movement of warehouse data across environments.

Responsibilities:

• Identify and document system requirements taking into account functional requirements as well as performance, functionality, and supportability, etc.
• Creation of DATAMARTS for end user reporting and linking the same with the cognos reporting for the business users.
• Hands on experience in using Cognos and Cognos transformer for cube building and reporting for end user along with Datamart link.
• Performing Data Analyst roles for the project for any new developments done.
• Complete code builds and unit test to validate design including documentation deliverable
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 11g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Involved in the creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Database links etc.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Conduct code reviews to ensure development is performed in accordance with development standards
• Follow version control and change management processes to support internal and external audit requirements
• Work with the Production Operations team to optimize ongoing performance

Environment: OEM, Oracle 11g, SQL Developer 3.2, PL/SQL Developer, PL/ SQL, Shell Scripts, Data Mart, Data Warehouse, Cognos.

Sr. Oracle Developer

CONFIDENTIAL

CONFIDENTIAL is one of the biggest telecom and internet service providers in United States. Project was development and support of core projects like Inventory Data warehouse, GARM, Service first etc.

Responsible for developing PLSQL Packages, SQL Loader scripts and UNIX shell scripts for loading data coming from various systems into the data warehouse.

Responsibilities:

• Analysis, design, construction and testing of complex end user applications using Oracle 11g RAC and Oracle Data Integrator
• Participate in business requirements analysis sessions
• Identify and document functional and derived requirements and map them to customer requirements
• Identify and document system requirements taking into account functional requirements as well as performance, functionality, and supportability, etc.
• Complete functional and technical design deliverables
• Complete code builds and unit test to validate design including documentation deliverables
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 11g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Involved in the creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Database links etc.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Conduct code reviews to ensure development is performed in accordance with development standards
• Identify changes, analyze the impact of change and provide detailed assessments to determine the LOE
• Follow version control and change management processes to support internal and external audit requirements
• Participate in technical interchange meetings
• Adhere to and contribute to development standards
• Work with the Production Operations team to optimize ongoing performance

Environment: Oracle 11g, SQL Developer, PL/ SQL, Shell Scripts, SQL Navigator.

CONFIDENTIAL

System Analyst-Lead developer

• It is an insurance domain project of the CONFIDENTIAL . Under this project, we have a total of 300 JAVA VB based applications and more than hundreds of Databases/instances that team were responsible of complete maintenance and support for the end/external users and the internal ING users as well. All the databases activities are being handled by us along with the front end support for these applications. This also included managing of mainframe servers and server programs using JCL and COBOL for enhancements.
• This had an onshore-offshore model with 24 7 supports from offshore and development/enhancements at onsite with me leading the team.

Responsibilities:

• Meeting with end user, collecting requirements and converting into technical specification.
• Developed Stored Procedures, Functions and Packages for implementing complex business logic.
• Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Created SQL Loader scripts to load data from external system to oracle.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Responsible for performance tuning of SQL queries written in procedures and functions at the back end which are called from the front end forms
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Created data entry Forms using oracle Forms 6i for entering data related to Order Information and inventory.
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client
• Acting as onsite team coordinator and involved in various activities such as client servicing, requirement gathering, DB request Handling, PL/SQL enhancement and support.

Environment: Oracle 10g, SQL PLUS, PL/ SQL, SQL Loader, Shell Scripts, SQL Navigator, Windows XP, MS-Excel, TOAD.

CONFIDENTIAL

Sr. Oracle Developer

This is an application for credit collectors, managers to track and manage all the accounts in their workQ that are past due collections, jobs, payments, notes, contacts, correspondence, actions, and treatments . Managers can flag priority accounts, create filters to distribute the work load between collectors. Other functionalities include building their own list of accounts using MyQ, creating actions, generating reports that provide collectors and managers with required information.

Responsibilities:

• Invoved in all the stages of the application development including design, development migration and maintenance.
• As a senior Developer responsible for creating and managing PLSQL packages used by front end Java applications as well as batch applications using Bulk loading, Dynamic Sql, ref Cursors, regular expressions.
• Created and maintained the ER diagrams of the database using Erwin tool.
• Loading data from various sources using External table, Data pump, Sql loader utility, shell scripts and scheduled jobs to run on a regular basis using crontab.
• Writing Stored Procedures, Functions, Packages and Autonomous triggers using PL/SQL to implement business rules and processes.
• Involved in the creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Database links etc.
• Performance tuning of materialized views using fast refresh.
• Good experience in enforcing data integrity using integrity constraints.
• Performance Tuning of SQL queries and Optimization of materialized views using fast refresh.
• Involved in unit testing and provided test scripts to the test team

Environment: Oracle 11g, CVS, AIX UNIX 5.3, TOAD 9.5, SQL Plus, SQL Developer, Java.

CONFIDENTIAL

Software Engineer

Operational Data Store ODS , data pertaining to the services, customer and locations rendered by Time Warner Cable. Services are categorized based on different Divisions, Regions, Systems, and Channel Lineup Areas. The objective of the Project was to collect data from different customers and replicated the data and the pooled data was modified and used for Reporting.

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Involved in Data modeling to develop the database design using Erwin 4.0 and developed the logic in the oracle backend with normalization concepts.
• Developed Unix Shell scripts to automate repetitive database processes.
• Worked on data conversion, loaded data from different Sources into the Temp data backup environment using SQL Loader and validated the data before loading it into oracle tables.
• Optimizing PL/SQL code and SQL queries using Explain Plan, Indexes and Hints.
• Setup batch and production jobs using AUTOSYS.
• Provided production support to improve turnaround time on various issues.
• Provided database support to testing team in writing complex SQL queries.
• Involved in designing of required end user forms and reports using Oracle forms 10g Reports 10g.
• Customization of existing forms and development of new forms using different form built in's, created LOV's and record groups.
• Worked with different triggers in forms like Block processing triggers, Interface event triggers, navigation triggers and validation triggers.

Environment: SQL, PL/SQL, Oracle 10g, SQL Loader, Visio, Toad, UNIX Shell Scripting, Erwin, AIX 5.3, Windows NT/XP, Oracle Reports 10g and forms 10g.

CONFIDENTIAL

Software Engineer

• The project was basically regarding the content management of the CONFIDENTIAL various business level confidential documents. These basically included p3 to p1 level business agreements with various corporations throughout the globe.
• Inetially, we used the metaviewer content management tool to manage these. Later on, this was replaced by documentum 5.3 initially which was then further upgraded to documentum 6.5 in later times by the team.
• Responsibilities: DQL operations, client servicing, Requirement Gathering, SUN SOLARIS/AIX, RE- POINT, DOCBASE activities handling, DOC BROKER operations, Application Support.

Environment: AIX/Sun-Solaris server, JAVA,.NET, Documentum 6.5/5.3,DQL,SQL,ORACLE 9i, PL/SQL.

CONFIDENTIAL

Associate Software Engineer

• This is a web based J2EE project that aims to provide a panacea to the legacy system of personal loan and mortgage application approval, underwriting and disbursal. Through the use of this system, the customers within the organization will be able raise electronic requests for approval or rejection of loans applied by the customers and tracks them till closure. The use of this system has helped the client to garner more business in short time and register good profit.
• Responsibilities: PL SQL programming, client servicing, Requirement Gathering, Preparing Tech Doc, Test Plan, Release document,DBA activities, BO reports deployment.

Environment: ORACLE 9i, PL SQL, JAVA,.NET, BO, CITRIX, DWH, DATAMART, ICM, WINTEL SERVER, RIGHT FAX, VISION PLUS, SUN-SOLARIS/AIX

CONFIDENTIAL

Internship-Trainee

• CONFIDENTIAL - Capital division Treasury project. It stands for Capital Market services. It is a finance-based project dealing with Hedging and financial reporting for CONFIDENTIAL markets.
• Features: - CEF BAF Hedge Reports related to hedging, derivatives. Financial Reporting tool to meet various Business requirements of the client.
• Responsibilities: PL SQL programming, client servicing, Requirement Gathering, Preparing Tech Doc, Test Plan, Release document and developing new modules using SDLC.

Environment: ORACLE 9i, PL SQL,.NET DWH, DATAMART, VISION PLUS, UNIX/LINUX