SUMMARY

• 10 years of experience in Retail banking, Investment banking, and Pharmaceutical industries in designing and developing client-server and web applications using Microsoft, Business Objects Webi and Crystal Reports, Oracle Technologies.
• Expertise in database design and Client server programming using VB6, VBA excel MS-Access SQL Server 2000, 2003, DB2, Oracle 10g using stored procedures and triggers
• Experience in performing various QA Methodologies like Regression Testing, User Acceptance Testing, Back End Testing and Front End Testing using both manual and automated testing tools.
• Experience in Financial GL and automated reconciliation Systems including PeopleSoft, TDB, IMPACT, Intellimatch and Recmanager.
• Experience in MIS, KPI, Metrics and Dashboard Reporting for Equities/Fixed income, Regulatory, Treasury and Risk and Control Dept.
• Expertise in Data Analysis, ETL, Data Conversion, Data Cleansing, Data Profiling, Design and Data Modeling.
• Specializing in the area of Data Warehousing and Business Intelligence.

MANAGEMENT COMPETENCY

• Proven ability to lead successful programs and teams
• Ability to develop and implement policies and procedures
• Skilled in problem resolution and customer relations
• Adept at training, motivating and managing personnel
• Strong Leadership and excellent presentation communication skills
• Outstanding skills in analyzing business process and end-user needs, detail oriented and committed to delivering superior quality work.

TECHNICAL COMPETENCY

• Database :MS-Access 2007, Oracle 10G, MS SQL Server 2008,DB2
• Programming: VB6,VB Script, ASP, CSS , HTML, DHTML, Java Script, VBA Excel, Outlook, Access ,Cobol, C, Visual studio 6.
• Business Applications Tools: MS Office 2007, , SharePoint, Documentum, Informatica ETL , Load Runner, Quick Test Pro ,Toad, Clear Quest, Rapid Sql , MS Visio, PeopleSoft , Siebel.
• Business Intelligence Tools : SAP Business Objects XI R3,4.1, Xcelcius, Crystal Reports XI, SAP Business Planning SRC reports
• Operating System : UNIX, Windows XP/NT/2000, LINUX

EXPERIENCE

2 Global Asset art Risk Reporting Tool

Responsibilities:

• Managing Implementation of Reconciliation breaks application and business Objects reporting tool for Global Analytics and reporting.
• Supporting Daily BAU functions including Developing and Reporting Daily ,Monthly MIS ,KPI and Metric reports and Dashboards using SAP former Business Objects reporting tool Webi, Deski, Xcelsius , vba Excel, Access .
• Assisted with automation of Operations control department's manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Gather user requirements in specifying the analysis, design, and development and liaise directly with business users and other business analysts to define and clearly document requirements. Engage with stakeholders and senior management across multiple business areas and divisions including IT, Risk and control, Finance, Operations and Business Groups.
• Involved in the designing and building of Universes, Classes and Objects for financial reports. Designed and developed complex Webi Reports using Crosstabs, Formulas for providing analytical calculations.
• Involved in specifying the star schema design by applying Data warehouse methodology of dimensional modeling and development using BO Designer. Also involved creating and maintain BO Universe and Administration of CMS.
• Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Barclays Operational Risk Framework and internal Barclays Policies and Standards.
• Identifying root cause of issues with the data and addressing them with the solution to resolve the issues by collaborating effectively across the teams.

Environment: SQL Server 2000, Sybase ,Oracle 10g ,PL SQL,Rapid Sql, SharePoint, Business objects Webi, Deski, Xcelcius for Dashboard , VBA Excel, MS-Access .

Capital One Financial Corporation provides various financial products and services to consumers, small businesses, and commercial clients in the United States.

Responsibilities:

• Assisted in the development of Incentive Plans for the Banking Segment across all 3 Lines of Business - Consumer, Small Business and Commercial.
• Perform various incentive plan calculations for the Banking Segment across all 3 Lines of Business - Consumer, Small Business and Commercial.
• Distribute various incentive plan reports for the Banking Segment across all 3 Lines of Business Consumer, Small Business and Commercial.
• Analyze various incentive plan reports for the Banking Segment across all 3 Lines of Business - Consumer, Small Business and Commercial.
• Communicate results and recommendations to senior management
• Create incentive reports as requested by senior management

Environment: Visual Basic 6.0, VBA Excel, SQL Server, Sybase, Oracle 10G, Business Objects Tool Business Planning, Crystal Reports, Webi , Documentum, Clear Quest.

Confidential is part of the Nomura Group, one of the largest global investment banking and securities firms. NHA's major divisions are Equity, Fixed Income, Investment Banking, and Asset Management. Scope of the project includes end User Computing EUC remediation project And Management Reporting using Business Objects 11 R2. Major objectives included the redesign and enhancement of existing Data mart based MS Access and Excel VBA applications.

Responsibilities:

• Involved in the designing and building of Universes, Classes and Objects for financial reports. Designed and developed complex Crystal and Webi Reports using Crosstabs, Formulas for providing analytical calculations.
• Analysis and reverse engineering of legacy MS Access and Excel VBA applications. Extensively use Excel functions in development, focusing on read/write integration to databases.
• Gather user requirements in specifying the analysis, design, and development and liaise directly with business users and other business analysts to define and clearly document requirements
• Produce Business Requirements and Functional specification documents

Environment: Visual Basic 6,Vb script, Java script, ASP 3, DB2, SQL Server 2000, Sybase ,Oracle 10g ,PL SQL,TOAD, ADO,OLE DB, COM , ERWIN , PeopleSoft FMS , Business objects XI/3 , VBA Excel, MS-Access , Informatica ETL .

This system gives the user the complete information about the fail of delivery of Securities as defined by SEC regulation SHO. This Application generates a notice letter of Buy-in Intent for the security s . This application sends the notices using Microsoft Outlook as an attachment in Excel Sheet. This application generates Reports of the Fail deliveries of securities for the management review.

Responsibilities:

• Developed prototypes, Designed specifications and modified existing functionalities for optimization.
• Involved in creating COM components, Views, Stored Procedures in SQL server. Extensive usage of VBA/OLE automation, interfacing VB with MS Outlook and Excel and for reports.
• Design and Developed Reports using Crystal reports and exporting Data to Excel.

Project: B Borrows and Distribution System BDS

The BDS system provides a series of queries that allow the user to determine the cost of outstanding borrows and fails to deliver allocated to short accounts controlled at the Business Unit level.

Responsibilities:

• Designed the web pages and programmed the web enabled modules using Visual Interde, ASP, HTML, DHTML, VBScript, and JavaScript. VBScript and Java Script was used for client end /server side validation and Visual Source Safe VSS to control source-code.
• Design and Developed Reports using Crystal reports .

Environment: Vb script, Java script, ASP 3, DB2, SQL Server 2000, ADO, OLE DB, VBA Excel, Visual Interde, Neon Systems client Shadow ODBC Adapter to Connect DB2 Database.

1 Project: Sample Quality Review System Sample Stability Testing QA Dept. This package is used during Quality Review of Samples for QA Dept. to ensure that the products manufactured at the site comply throughout their shelf life with approved specifications Stability testing of the sample . Reports and queries are generated using Crystal Reports for product information report and products due for analyzing.

2 Project: Budget Monitoring System. This Software Keeps Track of allotted budget to every department or for particular project. Every year user inputs budget amount respectively and then work orders and vendors bills are passed which updates the budget amount and user have online monitoring of the budget status, order details, cash-flow statement etc.

3 Project : Equipment Preventive Maintenance System. This package maintains a complete database about description of all equipment owned by the company. The description for each machine contains, apart from technical specifications, all past maintenance history, schedules for further preventive maintenance. This Application Helps the Engineering Dept. for maintenance of the machines.

Responsibilities:

• Involved in Design and Development of the system.
• Interacted with the users at various phases.
• Involved in GUI Design.
• Creating Stored Procedures and Triggers using Pl-SQL, Implementation.
• Designed and created various reports using Crystal Reports.

Environment: Visual Basic 4.0, ORACLE 7, PL SQL, Crystal Reports 3.0