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 training, parallel run, support and customization of OLTP application.
• Domain knowledge of Banking, Finance, Asset Management and Health Care
• 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 knowledge of Data analysis and Database Design skills.
• Extensive experience in writing SQL queries, performance tuning, PL/SQL stored procedures, Cursor with parameter, Reference 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, Health Care, 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

Senior Lead Oracle PL/SQL Developer

Description: It's a sensor driven Grid Management solution in energy and utilities space targeted for the alternative energy generators to manage control and monitor the production to leverage decentralization of intelligence.

• Review and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
• Writing ad-hoc queries to analyze the desired output from the relational model.
• Identify in-efficiently written SQL's for fine tuning in order to improve performance.
• Bulk updates/inserts using Merge statements.
• Optimize the 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 technics for faster retrieval of information.
• Conversion and mapping of data, verifying the 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 the 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

Database: Oracle 11g

Confidential

Senior Lead Oracle PL/SQL Developer

• am, promotion and contact information, reject reason if rejected and sent to vendor in order to take further course of action.
• Understanding the existing application architecture, flow of the system and making changes for incorporating business needs.
• Provide parallel solution to new business requirements for the Second Brand 2nd Brand Customer without impacting the 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 the historical data using analytical queries and processing it.
• Written ad-hoc Queries on the 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 the 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 the requirement.

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

Database : Oracle 10g, Oracle 11g

Confidential

Senior Lead Oracle PL/SQL Developer

Description: Pricing Request System is an intelligent, workflow management web application that defines and facilitates the end to end pricing process.

• Database Migration of Pricing Request System PRS from Oracle 10g to Oracle 11g Cluster server.
• Making the necessary changes planned for migration in the 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 the 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 the 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 the 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

Database : Oracle 10g, Oracle 11g Cluster

Confidential

Team Lead Oracle DB Developer

• Review PL/SQL stored procedures/complex SQL queries, packages and triggers for optimal output.
• Analyze the communications, informational, data based and programming requirements of clients.
• Understand and make changes to Linux shell scripts for implementing the 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 the modules that are developed.
• Perform functional testing as per the functional specification document.

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

Database O/S used: Oracle 10g

Confidential

Team Lead/ Oracle PL/SQL Developer

Description: It is a web based solution OLTP providing financial services like applying for new Initial Public Offers IPO and New Funds Offer NFO enabling the blocking of account to the extent of application bid amount from the investor account.

• Collect and review business requirements from the 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 the investors linked account.
• Writing ad-hoc SQL queries, creating views and writing stored procedures and performance tuning.
• Implementing the change requests after identifying the bottle necks/issues, working on the possible solutions, discussing it with the functional analysts and getting approval for the 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

Database: Oracle 10g

Confidential

Team Lead, SQL, PL/SQL Developer

Description: Automating the work flow of reconciling the sundry and suspense accounts between the GHO Finance department and the branches by Centralizing the control of sundry account management OLTP by way of escalating and MIS reporting at any point.

• Automating the 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 knowledge, 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

Database : SQL Server 2008

Confidential

Project Lead Oracle PL/SQL Developer

Description: It's a web based solution for centralized storage for database archival retrieval of TBA Total Branch Automation historical data.

• Collect and review business requirements from the client.
• Manage workload to deliver quality deliverables, meet requirements and time lines.
• Assisted in designing the database for the application.
• Written the functional specification documents and interacted with the 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 the application for uploading the historical data on as when required basis by the 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

Database : Oracle 10g

Confidential

Project Lead, SQL, PL/SQL developer

Description: The customer is in the business Health Care domain of automating compliance management for HIPAA, Sarbanes-Oxley, Visa CISP, the Patriot Act, GLBA, OCC Regulations, the REALTOR Secure program, OSHA, and Patient Safety / Risk which includes surveys, questionnaires, issue management, incident recording, task management, risk assessment, mitigation planning, work plans, budgeting, trending snapshot graphs and reports.

• Gather requirement specifications from the client.
• Verifying functional spec by interacting with the 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 the 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

Database : SQL Server 2005

Confidential

Team Lead , SQL, PL SQL developer

Description: Web site for a real estate development company, which will be available to the public to use including a comprehensive real estate tracking system/check list to track all phases of real estate projects from purchase of land through due diligence, financing, investors, buyer seller documents, leasing, hiring vendors including sale of the shopping centre and post-closing.

• Gather requirement specifications from the 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 the application.
• Manage workload of quality deliverables and time lines.
• Weekly status update and escalations.
• Impact analysis with severity of the change request raised and reviewed with seniors and client.

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

Database: SQL Server 2003

Confidential

Team Lead , SQL, PL/SQL developer

Description: Confidential is a reputed software products services company based at New York Connecticut in USA and Newfoundland in Canada, specializing in EDI applications. CRC wants to develop a system for creation, editing, Printing and electronic communication of Air Waybills to US Customs AMS through third party vendor based upon the syntax known as the Air Transport Association Cargo Interchange Messaging Procedures IATA Cargo-IMP . CRC has named this system as Electronic Air Waybill System EAWS .

• Communicating with the client on a regular basis to gather and understand the requirements.
• Review requirement specification document with the customers.
• Get the necessary approval of requirements and design and participate in code review.
• Ensure application meet the 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 the application.
• Trouble shoot and customization of the application.

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

Database: SQL Server 2000

Team Lead, SQL, PL/SQL developer

Description: Confidentialis a financial services company providing brokerage, asset management and other financial services to international customers located primarily in Latin American. Markets include US Non-US Equities, Bonds, Corporate Sovereign bonds, Fixed income, Mutual Funds, Hedge Funds, Derivatives, Commodity and Financial Futures etc.

• 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 the 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

Database: SQL Server 2000/2003/2005

Confidential

Team Lead , SQL, Oracle PL/SQL developer

Description: The system is developed for the Company which is into financing Consumer durable items, cars and other retail products.

• Understand business needs and work flows to translate into software.
• Communicate the data quality issues with customer.
• Based on the requirement specification design, develop, testing and implement the solution.
• Day to day SQL scripting and automation.
• Writing Unix Shell scripts for automating the batch jobs.
• Automation of data mining, ETL activities like data upload to staging, cleansing , conversion of data for standardizing and store the information in summarized form for further drill down by BI and risk managers.
• Designing the 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 the 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

Database: ORACLE 7.x

Team Lead, SQL, PL/SQL Developer

Description: Developed an interface for the bank's running legacy system to talk with Master Card switch Base-24 Switch to do ATM/POS transactions OLTP like Balance Inquiry, Cash Withdrawal, Mini Statement, Fund transfer, Split fund transfer, Cash Deposit from any of the Bank's ATM/POS networks as well as from other ATM/POS machines which are in Maestro network and have tie up with the bank.

• Understand business needs and work flows to translate into software.
• Interact with the Base-24 switch vendor to understand the ISO-8583 messaging.
• Prepare the functional specification document for the developer and work flow document for better understanding of the flow of ATM/POS request and response.
• Coordinating with Bank IT Staff, Switch vendor and ATM machine vendor for testing the application.
• Help the team in designing the 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 the sample messages provided by the Switch vendor.
• Taking the final approval and sign-off from the Switch Vendor, Bank's IT Staff.
• Involved in implementation and going live.
• Developed Debit Card maintenance interfaces along with reports.
• Maintenance and support for the application.

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

Database: SQL Server 2000

Team Lead, SQL, PL/SQL developer

Confidential is a comprehensive Bank Automation Solution OLTP addressing the entire gamut of operations of a bank including Retail and Risk Management activities. It is based on client server technology and Branch Banking, Credits, Asset management NPA , User security and Standing Instruction. Some of the features are Signature/Document scanning and retrieval, Tele-banking, ATM interface, Any Branch Banking etc.

• Written PL/SQL stored procedures for converting the bank's legacy data to the 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.
• Developed new modules using the application frame work, business frame work in n-tier architectures.
• Involved in QA, implementing the application, doing parallel run and day to day support activities.
• Escalate critical issues to seniors to take necessary actions.
• Written ad-hoc SQL queries, for testing end-to-end process.
• Revisit stored procedures/views for identified client needs.
• Involved in Enhancements and Customization of modules.
• Given demonstration and user training to end user.

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

Database: SYBASE SQL Anywhere 5.5.x