SUMMARY:

•*+years of experience in business requirement gathering, System and data analysis and reporting.

•Recently attended a five day classroom training course on SAP NetWeaver BW 7.3 Enterprise Data Warehouse from SAP Education.

•Designed and developed reports for Kaiser Permanente using Crystal report 10 and MS SQL Sever.

•Designed and developed reports for Financial Planning Resource and Analysis department in Golden Gate University using Crystal reports, SQL queries, and MS Access with Colleague system, Oracle CRM as the backend.

•Designed and developed web based application using Microsoft Active Server Pages, Java Script, VB Script, IIS, MS SQL Server and Oracle 8i for a Financial Services Company in India.

•Lead and execute QA related tasks as a part of the Software Development Life Cycle.

•Detail Oriented and can learn new systems quicker and meet customer expectations.

EDUCATION:

•Bachelors in Science

•Masters in Computer Applications

TECHNICAL SKILLS:

•Databases: Oracle 8i, MS SQL Server, MS Access, Colleague System

•Internet Tools: Active Server Pages, IIS 5.0, HTML, Java Script and VB Script

•Data Warehouse: SAP NetWeaver BW 7.3 Enterprise Data Warehouse.

•Report Tools: Business Objects XIR2 (WEBI and Crystal Reports)

•Other Tools: VSS, TOAD, Mercury Test Director for Quality Center

PROFESSIONAL WORK EXPERIENCE:

Thinknicity Inc.

Client: Kaiser Permanente, Oakland CA, Pricing Department (Web Based Reporting Project)

Crystal Reports Consultant, November 2006- Feb 2007

System Environment: Crystal Report 10, SQL Server, Mercury Test Director for Quality Center, Visual Source Safe.

•Analyze and design reports and stored procedures based on user requirements.

•Design technical specification based on functional needs.

•Review existing report design and logic; suggest improvements to address performance issues and enhancement requests.

•Coordinate with testing team for defects and bug fixes.

Golden Gate University,

Data Reporting Analyst, August 2005-April 2006

System Environment: Colleague (Release 17), Oracle CRM, MS Access, MS Excel, Crystal Report 8.0 & 11.0

•Gather user requirements, design report specifications, create reports for Financial Planning and Resource department to analyze and monitor university’s KPI’s and operating activities.

•Develop reports to accurately reflect “single version of the truth” based on the business process flow in a university environment.

•Work with business leaders to understand pain points and suggest solutions to better manage their decision making process.

•Identify areas of improvements from a reporting perspective that could yield better performance for “on-time” delivery of information.

•Generate periodic and special reports for management reporting, surveys, forecasts, and trend analysis.

•Manage report distribution process for Planning Resource and Analysis department.

•Migrate reports from Crystal 10 to BO XI.

ICICI Infotech Limited

Feb-2000 – May 2002, Multiple Projects

RLSMIS System for Personal Financial Services Limited, a subsidiary of ICICI Bank.

Developer and Project Quality Assurance Leader, November 2000-May 2002

System Environment: Oracle 8i, SQL, ASP, Java Script, VB Script, IIS 5.0, Crystal Report 7.0,VSS

Retail Lending Solutions Management Information System (RLSMIS) is a reporting system developed on the basis of Retail lending Solutions, a loan management system. PFS Limited disbursed loans (Personal, Home, Two wheeler loans etc) to customers. Based on the data in the above system, different reports were developed as per the user requirements.

•Gather and analyze user requirements.

•Develop standards for writing program specifications, program codes and stored procedures.

•Develop link diagrams and design program specification documents.

•Write stored procedures.

•Design and develop reports

•Prepare test plan documents

•Coordinate with the Software Quality Assurance Group to plan and conduct reviews and audits.

Administration of Bank rates module for a financial portal of ICICI.

Developer, August 2000-November 2000

This portal caters to the financial transaction requirements of the wholesale segment. My primary contribution was towards the Administration of Bank rates module.

System Environment: ASP, Java Script, VB Script, MS SQL Server 7.0,IIS 5.0

•Design screen layouts to display Bank rates for a particular day.

•Developed web pages to query and retrieve Bank Rates from database.

Lease Line Status System for the Networking group of ICICI Ltd

Developer, February 2000-August 2000

System Environment: ASP, Java Script, VB Script, MS SQL Server 7.0 and IIS 5.0

Lease Line Status System is a web-based application to keep track of the various procedures involved in getting a lease line commissioned for the ICICI group of companies. These include the registration, feasibility, billing and other sundry details related to the concerned lease line connection. This application is accessed by selected users from branches of ICICI Ltd. spread all over India.

•Study of the system requirement

•Design access database and prepare program specifications.

•Design and developed web pages to retrieve and display data.

•Design and develop reports.

Contact this candidate