PROFESSIONAL SUMMARY:

• 14+ years of IT experience.
• 10+ years of experience in writing SQL, PL/SQL codes in various RDBMS's like Oracle, SQL Server, Sybase SQL AnyWhere and MySQL.
• 5+ years of experience in overall ETL concepts like data mining, Data analysis, Data extraction, Data loading, data conversion and data warehousing .
• 3+ years of experience in data migration, data archival and retrieval.
• 4+ years of experience in QA, implementation, Go - Live, user, parallel run, support and customization of OLTP application.
• Domain noledge of Banking, Finance, Asset Management and Confidential
• Worked on multiple projects simultaneously.
• A self-starter with ability to work independently with good understanding of technologies such as object oriented designing, web based application development, multi-tier Client/Server architecture, reusable components, security and work-flow.
• Well versed with Project development life cycle (Agile Development methodology), System Business Process Analysis and Gap Analysis.
• Sound noledge of Data analysis and Database Design skills.
• Extensive experience in writing SQL queries, performance tuning, PL/SQL stored procedures, Cursor with parameter, cursor, Functions, Triggers, Packages, Collections (Bulk Collection), In memory arrays, Inline views, data analytical functions Oracle supplied package, DBMS Scheduler and maintenance of application in Oracle 7.x/8.x/10g/11g and SQL Server 2000/2003/2005, SSIS & SSRS, OBIEE, Sybase SQL Anywhere 5.5, MySQL databases under Windows NT/2000/XP platforms and Unix (HP-UX, SCO-Unix)/Linux (RH Linux 4.0) and Unix/Linux Shell scripting.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Unix/Linux Shell scripting, JCL, Quick Job, C, MF-Cobol

Databases: Oracle 10g/8i/7.x, MS SQL Server 2000/2003/2005, Sybase SQL Anywhere 5.5, MySQL, MS-Access, DB2-400, Btrieve record manager

Tools: used:MS-Access, MS-Excel, MS-PowerPoint, MS-Word, MS-Visio, MS-Front page, MS-Outlook, Mantis (bug tracking), JIRA, SONAR, SVN, Erwin, PL/SQL Developer, SSIS & SSRS, OBIEE

Operating Systems: Windows 95/98/NT 4.0/2000/XP/7, HP-Unix, RH Linux 4.0 Enterprise, Intel Pentium-III, Intel 80486 based systems, Uptron Mini-frames, Wipro Mighty Frames, Novell Netware 3.x/4.x, EC-1045 Main-frame (IBM-370 equivalent), OS/VS, MS-DOS

Domain Knowledge: Banking, Finance, Confidential, Data mining, Data Warehousing, MIS, Share Accounting, Public Issue System, Rights Issue System, Bank Reconciliation, Data Conversion, Data migration, Parallel run & Go-Live

Environment: HTML, JMS, XML, XSLT, Tomcat 3.2.x, Java Script, JSP, Servlets, Front Page2000, .Net framework 1.1 and 2.0, Hibernate, C#, AJAX, ATLAS

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Lead Oracle PL/SQL Developer

Responsibilities:

• Review and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
• Writing ad-hoc queries to analyze teh desired output from teh relational model.
• Identify in-efficiently written SQL’s for fine tuning in order to improve performance.
• Bulk updates/inserts using Merge statements.
• Optimize teh PL/SQL code using collections and bind variable for bulk operations.
• Writing analytical queries for faster processing and better performance.
• Using appropriate hints and query techniques for faster retrieval of information.
• Conversion and mapping of data, verifying teh data integrity and validations.
• ETL activities like retrieval of data from external file using external table for data transformation.
• Loading detailed atomic data into dimensional structures using SQL*Loader utility
• Exporting teh database using data pump (expdp/exp) utility.
• Balance requirements and realities to deliver a DW/BI solution that's accepted by business users and that supports their decision-making.
• Structure dimensional models around business processes.
• Creating sample data for unit and integrated testing for end-to-end process.
• Perform functional testing to ensure technical accuracy based on functional specification document.

Environment: J2EE, TOMCAT, Netbeans, spring, XML, JSP, Servlet, JDBC, RH Linux 4, Erwin, MS Windows 7, Toad

Confidential, Bellevue, WA

Senior Lead Oracle PL/SQL Developer

Responsibilities:

• Understanding teh existing application architecture, flow of teh system and making changes for incorporating business needs.
• Provide parallel solution to new business requirements for teh Second Brand(2nd Brand) Customer without impacting teh existing process by analyzing and replicating code incorporating necessary changes for dynamically created parameter table with required values populated.
• Written PL/SQL stored procedure to Identify Bridge To Value(BTV) customers from teh historical data using analytical queries and processing it.
• Written ad-hoc Queries on teh historical data to retrieve business critical needs.
• Written merge statement for bulk data updates and inserts.
• Exporting database using expdp (data pump), exp (export) utility.
• Retrieving and loading teh from external file using External table & SQL*Loader utility.
• Preparation of sample data for unit and integrated testing.
• Making changes to Unix shell scripts as per teh requirement.

Environment: Unix, MS Windows 7 professional, Informatica, Gloden Gate, Toad.

Confidential, Memphis, TN

Senior Lead Oracle PL/SQL Developer

Responsibilities:

• Database Migration of Pricing Request System (PRS) from Oracle 10g to Oracle 11g Cluster server.
• Making teh necessary changes planned for migration in teh stored procedures, packages, scripts etc.
• Comparison of table data, procedures, packages, functions, triggers make required changes before migrating it to new database.
• Changes to stored procedures and packages in order to log teh information into external file.
• Changes to TeraData bteq scripts.
• Job scheduling and monitoring using $Universe.
• Exporting and loading database using data pump(expdp) and SQL*Loader utility.
• Creating External table, for uploading teh data with significant performance improvement.
• Making changes to Linux shell scripts of Pricing Request System (PRS), Re-rate & ETL for migration and implementing directory structure as per teh new EDC Standard.

Environment: Java, J2EE, JSP, Log4J, JavaScript, Tomcat, CVS, HTML, Eclipse, Struts, Weblogic 10.3, Ant, Red hat Linux 4, MS Windows 7 professional, Oracle SQL Developer

Confidential, New York, NY

Team Lead Oracle DB Developer

Responsibilities:

• Review PL/SQL stored procedures/complex SQL queries, packages and triggers for optimal output.
• Analyze teh communications, informational, data based and programming requirements of clients.
• Understand and make changes to Linux shell scripts for implementing teh requirement.
• Providing technical assistance in systems development and database development activities.
• Identify in-efficiently written SQL for fine tuning and better performance.
• Transformation of data into summarized form to perform various data warehousing and business intelligence tasks.
• Prepare flowcharts using MS Visio and well documented teh modules that are developed.
• Perform functional testing as per teh functional specification document.

Environment: J2EE, TOMCAT, Netbeans, spring, XML, JSP, Servlet, JDBC, RH Linux 4, MS Windows 7, MS-Visio

Confidential

Team Lead/ Oracle PL/SQL Developer

Responsibilities:

• Collect and review business requirements from teh client.
• Manage workload for quality deliverables and time lines.
• Escalation of issues that impact productivity or ability to meet expectations, weekly status update.
• Assist manager in tracking progress, prioritizing work, developing time estimates and work plans.
• Mentor junior team members.
• Database design to enable blocking of application bid amount in teh investors linked account.
• Writing ad-hoc SQL queries, creating views and writing stored procedures and performance tuning.
• Implementing teh change requests after identifying teh bottle necks/issues, working on teh possible solutions, discussing it with teh functional analysts and getting approval for teh final changes.
• Used Mantis (bug tracking tool) for tracking and resolving bugs.
• Review and design development activities for customisation needs of client.
• Arrange build demo for clients, installation and procedural manuals for support staff.
• Implementation of business logic, review Stored Procedures, Functions, Views to develop reports.
• Maintain /Troubleshoot of application.

Environment: J2EE, TOMCAT, Netbeans, spring, JSP, Servlet, JDBC, Oracle Forms, MS Windows 2000/XP, SVN

Confidential

Team Lead, SQL, PL/SQL Developer

Responsibilities:

• Automating teh work flow of reconciliation between HO and branches.
• Review requirement specs with client and suggest better solutions.
• Prepare functional specs, assist in database design, ad-hoc SQL queries, view, stored procedures and SSRS reports.
• Manage workload to deliver quality deliverables that meet requirements and time lines.
• Weekly status update and escalation of issues that impact productivity or other modules.
• Assist manager in prioritizing work, prepare time estimates and milestones.
• Mentor junior team members in best practices, functional noledge, Unit testing and integrated testing.
• Application maintenance and troubleshoot.

Environment: VB/ASP.Net 2.0, HTML, AJAX, Atlas, c#, Javascript, XML, MS Windows NT/2000/XP, SVN

Confidential

Project Lead Oracle PL/SQL Developer

Responsibilities:

• Collect and review business requirements from teh client.
• Manage workload to deliver quality deliverables, meet requirements and time lines.
• Assisted in designing teh database for teh application.
• Written teh functional specification documents and interacted with teh client for user friendly interface.
• Data uploading using SQL*Loader, SSIS and export & importing of database dump files,
• Writing complex SQL queries, inline views, analytical functions, stored procedures and Packages, performance tuning of in-efficiently written SQLs.
• Used Bulk collect and bulk binding features for handling bulk operations as a measure towards performance tuning.
• Automated teh application for uploading teh historical data on as when required basis by teh end user having proper access rights with user friendly interface.
• Implemented user level, menu level, region level and zone level access securities.
• Support and troubleshooting of application.

Environment: J2EE, TOMCAT, Netbeans, spring, JSP, Servlet, JDBC, MS Windows NT/2000/XP, SVN

Confidential, Colts Neck, NJ

Project Lead, SQL, PL/SQL developer

Responsibilities:

• Gather requirement specifications from teh client.
• Verifying functional spec by interacting with teh client.
• Tracking progress, prioritizing work and prepared work plans.
• Writing PL/SQL Stored procedures, complex SQL queries, creating views, functions and triggers.
• Revisit stored procedures/views to determine compatibility with projected or identified client needs.
• Communicate status of assignments to Manager/Client on weekly basis.
• Involved in QA, functional testing, unit testing and integrated testing of teh OLTP application.
• Database/application Customization, support and troubleshoot.

Environment: VB/ASP.Net 2.0, HTML, AJAX Atlas, c#, hibernate, Javascript, XML, XSLT, MS Windows NT/2000/XP

Confidential, Bay Harbour Islands, FL

Team Lead, SQL, PL SQL developer

Responsibilities:

• Gather requirement specifications from teh client.
• Preparing functional spec documents.
• Assist in database design and mentor junior team members.
• Writing PL/SQL Stored procedures, complex SQL queries, creating views, functions and triggers.
• Revisit stored procedures/views to determine compatibility with projected client needs.
• Functional testing, unit testing and integrated testing of teh application.
• Manage workload of quality deliverables and time lines.
• Weekly status update and escalations.
• Impact analysis with severity of teh change request raised and reviewed with seniors and client.

Environment: VB.NET, C#, HTML, XML, MS Windows NT/2000

Confidential, New York, NY

Team Lead, SQL, PL/SQL developer

Responsibilities:

• Communicating with teh client on a regular basis to gather and understand teh requirements.
• Review requirement specification document with teh customers.
• Get teh necessary approval of requirements and design and participate in code review.
• Ensure application meet teh requirements.
• Database design and Writing PL/SQL Stored procedures, complex SQL queries, creating views, functions.
• Manage workload to deliver quality deliverables that meet requirements and time lines.
• Escalation of production issues and weekly status update to client/Manager.
• Assist manager in work priortization, time estimates and plan milestones.
• Mentor junior team members in functional, unit and integrated testing of teh application.
• Trouble shoot and customization of teh application.

Environment: VB.NET, C#, XML, XSLT, MS Windows NT/2000

Confidential, Miami, FL

Team Lead, SQL, PL/SQL developer

Responsibilities:

• Communicate with client on regular basis to gather requirements.
• Prepare requirement specification document and get customer approval.
• Functional testing to ensure applications meet requirements.
• Use of DTS(Data Transformation Services) for loading data from various excel file formats to staging tables.
• Writing SQL queries, Stored Procedures & functions and performance tuning.
• Written complex transformation logic in stored procedure to implement business rules.
• Involved in Database design, maintain ER diagram using Erwin.
• Finding ways to enhance teh design of application for better maintainability and reuse of code.
• Anticipate user's future needs while providing solutions.

Environment: VB.Net, ASP.Net, HTML, JavaScript, XML, MS Windows NT/2000, Erwin

Confidential

Team Lead, SQL, Oracle PL/SQL developer

Responsibilities:

• Understand business needs and work flows to translate into software.
• Communicate teh data quality issues with customer.
• Based on teh requirement specification design, develop, testing and implement teh solution.
• Day to day SQL scripting and automation.
• Writing Unix Shell scripts for automating teh batch jobs.
• Automation of data mining, ETL activities like data upload to staging, cleansing, conversion of data for standardizing and store teh information in summarized form for further drill down by BI and risk managers.
• Designing teh overall Data warehouse system.
• Creating indexes, fine tuning SQLs, creating views, Global temporary tables for performance tuning.
• Find ways to enhance design of application for better maintainability and code reuse.
• Making teh application user friendly with Unix shell batch scripts and User interface.
• Created parameterized ad-hoc reports using MS-Access and Oracle Forms.

Environment: Oracle Forms, UNIX HP-9000, MS-Access 2.x., MS Windows NT/2000, Novell Netware 4.x

Confidential

Team Lead, SQL, PL/SQL Developer

Responsibilities:

• Understand business needs and work flows to translate into software.
• Interact with teh Base-24 switch vendor to understand teh ISO-8583 messaging.
• Prepare teh functional specification document for teh developer and work flow document for better understanding of teh flow of ATM/POS request and response.
• Coordinating with Bank IT Staff, Switch vendor and ATM machine vendor for testing teh application.
• Help teh team in designing teh database taking into consideration various kinds of ATM/POS transactions.
• Creation of Positive Balance file and uploading to server for doing offline transactions.
• Involved in QA, functional testing with teh sample messages provided by teh Switch vendor.
• Taking teh final approval and sign-off from teh Switch Vendor, Bank’s IT Staff.
• Involved in implementation and going live.
• Developed Debit Card maintenance interfaces along with reports.
• Maintenance and support for teh application.

Environment: VB 6.0, MS Windows NT/2000, Novell Netware 4.x

Confidential

Team Lead, SQL, PL/SQL developer

Responsibilities:

• Written PL/SQL stored procedures for converting teh bank’s legacy data to teh retail banking format.
• Involved in ETL activities like Data extraction, Transformation logic as per business rule using PL/SQL stored procedure, data mapping, cleansing, standardizing
• Verifying business object documents, database design documents. ER Diagrams and maintaining database objects.
• Revisit stored procedures/views for identified client needs.
• Written ad-hoc SQL queries, for testing end-to-end process.
• Escalate critical issues to seniors to take necessary actions.
• Involved in QA, implementing teh application, doing parallel run and day to day support activities.
• Developed new modules using teh application frame work, business frame work in n-tier architectures.
• Involved in Enhancements and Customization of modules.
• Given demonstration and user to end user.

Environment: PowerBuilder 6.5, Windows 95/98, Novell Netware 3/4.x, Erwin