Professional Summary:

• Masters in Computer Applications having 11 years of Experience in IT industry Banking Domain .
• 3 Years of working Experience as BA Business Analyst , Data Analyst in Data ware Housing projects.
• 4 Years of working Experience as Data Modeler. 3 Years in OLAP system and 2 Years in OLTP system.
• Exposure in overall SDLC including Requirement Gathering, Development, Testing, Debugging, Deployment, Documentation, Production Support.
• 6 Years of Hands on Experience in Oracle/SQL Development projects.
• Extensive Experience in SQL Optimization.
• Professional Experience in designing and developing client side applications using Power Builder 6.5, 7.0, 9.0. 2 and BankPro.
• Experience in Managing team of 8-11 people.
• Strong in design and implementation of business application development in Banking and Financial Services
• Quick Learner.
• Strong Analytical Skills.
• Self-learning attitude.
• Good communication and interpersonal skills.

Technical Skills:

ERWIN CA Data Modeling Tool

DBMS: DB2, Oracle 8, 10g, MS SQL Server 2005

Open Systems: Power Builder 6.5, 7.0 and 9.0, BankPro

Professional Work Experience:

Senior Associate

Confidential

Responsibilities:

• Client liaison, i.e. interfacing with the client to gather the business requirements for the development projects and convert them to technical requirements.
• Coordinate with source system owners/administrators to effect data standardization, function as a liaison with operations management and staff to resolve problems and improve processes or systems Channel / Deposit subject area .
• Conducting one-on-one sessions with business users to gather data warehouse requirements.
• Creating Logical and Physical Data Model using ERWIN to enhance/build the existing/new DataMart in EDW to meet the Business Requirements for their Reporting/New Marketing Strategies.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Preparing Functional Design document.
• Generating ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from DB2 database systems.
• Provide solutions to the end user queries.
• Performing Analysis on long running SQLs, provide suggestions to optimize the query.

Technology Lead

Confidential

Responsibilities:

• Client liaison, i.e. interfacing with the client to gather the business requirements for the development projects and convert them to technical requirements.
• Conducting one-on-one sessions with business users to gather requirements.
• Creating Logical and Physical Data Model using ERWIN to enhance/build the existing database in StatusMart to meet the Business Requirements for their Reporting/New Marketing Strategies.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Co-ordination with offshore team.
• Code Review.

Environment: - Oracle 10g, SQL Server 2005

Confidential

Responsibilities:

• Analysis of long running reporting queries/database objects in order to expedite the performance of the application.
• I was actively involved in providing solutions to client using different techniques like SQL optimization to reduce I/O bottleneck, modification of poorly performing indexes, logical tuning of different database objects, table partitioning etc..
• Worked on SSIS packages for this application.

Technology: - SQL Server 2005

Confidential

Responsibilities:

• Understanding Requirements
• Performing impact analysis
• Performing Code and LLD Review
• Designing the solution
• Coding
• Unit/Integration testing
• Bug Fixing
• Managing and Mentoring team of 10 people.

Senior Software Engineer

Confidential

Responsibilities:

• Analysis of long running queries/database objects in order to expedite the performance of the application.
• Creating Logical and Physical Data Model using ERWIN to enhance/build the existing to meet the Business Requirements for their Reporting.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.

Environment: Oracle 8

Analyst Programmer

Confidential

Responsibilities:

• Designed and developed Sales Enquiry Management System and Collection of Branch Rates Application modules.
• Involved in the optimization of queries which was taking longer time for execution in the existing application.
• Involved in database design for new functionality.

Environment: Oracle 8, Power Builder 7.0

Software Engineer

Confidential

• Confidential is an integrated Treasury Management Solution covering several key markets such as Foreign Exchange, Money Markets, Equity, and their related derivative instruments. Worked on Money Market Deals, refer to transactions between entities, known as counter parties who are usually banks, corporate entities and financial institutions. I was also involved in customization of the product for the client Finansa Credit Limited, Thailand and for National Saving Bank, Sri Lanka .
• I was also looking after Reporting Module for all the applications. The reporting module was required to have good database knowledge. He has worked on Stored Procedures, Functions, PL/SQL Programming, and Triggers for the various reporting requirements. I was also involved in the queries optimization which was taking longer time in execution.

Environment: Oracle 8, PowerBuilder 6.5

Programmer

Confidential

• This is India's first and only Bilingual Banking application as per the mandatory requirements of the Official languages Act, 1963. BancMate has been developed using the CLIENT/ SERVER technology and uses the Open Data Base Compliance or ODBC technology. A large number of public sector banks like PNB, Allahabad Bank, OBC, Vijaya Bank, Indian Overseas Bank, Indian Bank etc. are using this package.
• I was involved in Coding of Retail Lending, Reports and Locker modules.

Environment: SQL SERVER 2000, Power Builder 7.0, 9.0