Sql Server Development

Suresh Ch Martha

Address: ** ******** ***,

Malden, Ma-02148

Email Id: ******.*.******@*****.***

Cell # 617-***-****

SUMMARY:

. Over 5.3 years of data warehousing experience using Actuate e Report

Designer Professional 8, Actuate iServer, Actuate 10,BIRT reporting,

Actuate IOD, SQL Server Reporting Services (SSRS), BO XI R2/R3, BO API

Calls using BOXI R2/R3 SDK for Java, BO XCelsius, Oracle 9i/10g, Sql

Server 2005, MS Access, Data Reports and has undergone training on

Informatica 7.1.

. Have implemented Actuate RSSE Configuration in iServer, Actuate API

Calls using C# .Net for Checkfree client.

. Integration of Actuate reports with .Net Application using Actuate

API's.

. Helped in creating xml file for dynamic database credentials reading.

. Development Utilities using C# .Net for Automatic bulk uploading of

Actuate files to iServer.

. Devised a .Net utility to calculate the lines of Code for Actuate ROD

files.

. Experience in creating Stored Procedures, Views, Functions and

involved in tuning of SQL queries and PL/SQL blocks.

. Has good experience with Java scripts.

. Involved in the full life cycle development of Data Warehousing.

. Experienced in analyzing, designing, developing, administering Complex

Universes, development of Webi reports & Performance Management.

. Experience in enhancing the reporting capabilities of Business Objects

reports by giving end user with out of box capabilities in Webi

reports.

. Well versed with Integration of Webi and Java portal using BO JAVA

SDK.

. Experience in performance tuning of BO webi reports & Actuate reports.

. He had played an active role in devising the Reporting Architecture

for one of the major customer of Satyam.

. Excellent interpersonal communication Skills and technical

documentation skills.

. Ability to be an effective team player and work under time

constraints.

. Some of the clients with whom I worked with are State Street

Boston(Actuate BIRT,Oracle 10g,Fermat), FIFA 2010 South Africa (BO XI

R2/R3, Sql Server 2005), NYSE (Actuate 10, Actuate BIRT, IOD, Java,

Oracle 10g), JP Morgan Chase (Informatica, Actuate 8, BIRT, BO XI R2,

Oracle 10g) & Checkfree(Actuate 8, MS SSRS, .Net, Sql Server 2005).

TECHNICAL SKILLS:

Data Bases Oracle 9i/10G, MS SQL Server 2005,

MS Access

Data Warehousing Actuate e Report Designer Professional-8 SP1, Actuate

iServer, Actuate 10, BIRT Reporting, Data Stage-7.5 EE,

Informatica.

Reporting Tools Actuate ErdPro, Actuate BIRT, Actuate IOD, Business

Objects XI R2, WebIntelligence, Xcelsius 2008, MS Access

Reports.

Programming C, Visual Basic, SQL, PL/SQL, Java, C# .Net

Database Utilities SQL*PLUS, SQL*LOADER, TD SQL Assistant, TOAD

Environment MS Windows NT 4.0/ 2000, Sun Solaris

Domain Knowledge Banking and Financial Services

EDUCATION:

Degree Institute Year %

BTECH NIST,India 2005 80.2

12th CHSE, India 2001 69.2

10th VEMS,ICSE, India 1999 79.4

Experience:

Company Year Location

DW Practice/State Oct 2010-till Date Boston USA

Street

Satyam Computer Oct 2005-Sept 2010 India/USA/South

Services Ltd Africa

CERTIFICATIONS:

o BO XI Level 1 certified (Internal certification)

PROJECT DETAILS

Client State Street Bank Boston

Boston, USA Oct 10- Present

Role BIRT Report Designer

Environment BIRT, Fermat, Oracle 10g

State Street Bank co-operation has it's Internal development team,

developing Limit Management System to automate the financial Limit &

Exposure request for each financial body. All the request from different

banks/financial Instituation will be routed through these software. This

application will automate all the approval process.

All the reports are developed in Actuate BIRT.

As a Team Lead, is responsible for

. Setting up meetings with Client for requirement gathering.

. Preparation of report technical specification.

. Setting up Meeting with offshore folks(Wipro Team) for design &

development of Reports.

. Writing Sql queries for different Modules.

. Query tuning for performance improvement.

. Developing BIRT reports

. Deployment of BIRT report on Tomcat server.

. Created Views, stored procedures and view for reports.

. Giving Production support.

. Helping testing team on Load Testing.

. Event Support in terms of DB load, Application load.

Client FIFA World Cup South 2010

South Africa Sept 09- Sept 10

Role BO Onsite Co-ordinator

Environment BO XI R2, C# .Net, Sql Server 2005

FIFA is the world governing body for the sport of football (Soccer). MATCH

is the primary company providing IT related services to FIFA. Event

Management System is a collection of software applications, which are

required to support the FIFA World cup 2010.

In general these systems are required to manage the people (Accreditee,

Volunteers, etc.,) and resources (vehicles, computers, etc.,) that are part

of the FIFA World cup. Event Management System includes the development of

4 main blocks:

- Accreditation System

- Volunteer Staff Management System

- Ground Transportation System

- Space and Material Planning

As a Onsite Coordinator, is responsible for

. Setting up meetings with Client for requirement gathering.

. Preparation of report technical specification.

. Setting up Meeting with offshore folks for design & development of

Reports.

. Writing Sql Server 2005 queries for different Modules.

. Query tuning for performance improvement.

. Migration of DB objects in different Environments.

. BO report development.

. Universe creation.

. Giving Production support.

. Helping testing team on Load Testing.

. Event Support in terms of DB load, Application load.

. Development of small utilities to handle automatic insertion of

"TRY/CATCH" block in stored procedure if not present already.

Client New York Stock Exchange (NYSE) India

May 09- Aug 09

Role Sr. Actuate Developer

Environment Actuate 10 Reporting Suite, Actuate BIRT and Actuate IOD

and Java, Oracle 10g

Client is recognized as a leading global financial services firm HQ in NY,

having more than $1.4 trillion in assets. NYSE is Leader in investment

banking, financial services for consumers, small business and commercial

banking, financial transaction processing, asset management and private

equity. LCA is built using old technology which is very slow response times

and application continues to grow Major redesign required to address

performance. Currently NYSE is using Actuate-6 with Sybase as the database.

Our responsibility is to migrate reports from Actuate-6 to Actuate-10 and

database from Sybase to Oracle 11g. Report Development project involves the

development of about 300 reports.

As a Team Member, is responsible for

. Preparing User Requirement Document (URD).

. Design & Development of Reports.

. Preparing Detailed Design Documents.

. Creating libraries- ROL(Report Template) & BAS(Business rule related

codes which is common across multiple reports where kept as functions

in BAS files)

. Migration of Actuate reports from Actuate 6 to Actuate 10.

. RSSE Implementation.

. Server Side Administration (RSSE Configuration, iServer

Administration).

. Utilities for bulk uploading of ROX file to iServer.

Client JP Morgan Chase,US, Jerser City, NJ

Dec 07- Apr 09

Role Sr. BO Architect

Environment Actuate 10, Actuate BIRT, BO XI R2, Informatica, Oracle 10

g, Java

JPMorgan Chase & Co. (JPMorgan Chase) incorporated in 1968, is a financial

holding company. JPMorgan Chase's principal bank subsidiary is JPMorgan

Chase Bank.

The Company's activities are organized into six business segments:

Investment Bank, Retail Financial Services, Card Services, Commercial

Banking, Treasury & Securities Services and Asset Management. Its wholesale

business comprises the Investment Bank, Commercial Banking, Treasury &

Securities Services, and Asset & Wealth Management. Its consumer business

comprises Retail Financial Services and Card Services.

The reports comprises of the Treasury and Securities services based on 4

content areas. Report project involves the development of about 40 reports

and integration of the report module with the Tech Portal application.

Reporting project development is distributed across 4 iterations, which

includes deliverables for online reports.

As a Onsite Coordinator, is responsible for

. Setting up meetings with Client for requirement gathering.

. Preparation of report technical specification.

. Setting up Meeting with offshore folks for design & development of

Reports.

. Working closely with the Database team in creating the stored

procedures & packages that needs to be done for the development.

. Developing stored procedures, functions & views for reports.

. Developing Informatica Workflows.

. Actuate Report Integration with Java Portal.

. Actuate RSSE Implementation.

. Tuning SQL queries.

. Managing Tech Portal users and roles.

. Engaged in development of Webi reports. All the reports here are in

Webi, BO XI R2 SP3.

. Development of Universes.

. Enhancing the reporting capabilities of Business Objects reports.

. Integration of Webi with Java portal using BO JAVA SDK.

. Tuning of BO reports.

. Migration of reports between different environments.

. Giving support to the User's while testing of report.

Client CheckFree Investment Services(CIS),US, India

Oct 05- Nov 07

Role Sr. Actuate Developer

Environment Actuate e.Reporting Suite (Actuate eRDPRO 8 SP 1),Actuate iServer, MS SSRS,

Sql Server 2005

Check Free Investor Services (CIS) is a leading provider of eCommerce

services and software, specializing in electronic bill payment and

investment services. CIS provides systems and services for automation of

investment management, trading, portfolio performance & reporting.

Application is used by more than 300 clients (Sponsors & Investment

Managers)

EPL involves the development of about 260 reports and integration of the

Report module with the EPL product. Reporting project development is

distributed across 4 iterations which includes deliverables for online as

well as batch reports.

As a Team Member, is responsible for

. Design & Development of Reports.

. Preparing Detailed Design Documents.

. Developing stored procedures, functions & views for reports.

. Creating utilities for Automatic Uploading of Actuate files to

iServer.

. RSSE Implementation.

. Creating Utilities for counting Lines of Code for actuate files

required for project

. Helping in Integration of Actuate and .Net.

. BIRT reporting.

. SQL query tuning for Actuate Reports.

. Server Side Administration (RSSE Configuration, iServer

Administration).

. Coordinating meetings with onsite peers.

. Shadowing the lead role.

Personal Details :

Name Suresh Ch Martha

Email ID ******.*.******@*****.***

Cell # 617-***-****

Address Boston MA, USA

2

Contact this candidate