Data Manager

Nitin Asthana

BI/ETL/DW

US Citizen Ph: 703-***-****,

*********@*****.***, Fairfax, VA

PROFESSIONAL SUMMARY:

. Over 21+ years of hands-on experience in business intelligence, business

analysis, system analysis, OBIEE architecture, design, development,

reporting, data modeling, enterprise data warehouse, database

administration, application support, and documentation

. Expertise in OBIEE 11g/ 10.1.3.4/, Siebel Analytics 7.8, BI publisher,

Siebel CRM 8.1, Actuate 9.2/8.0/7.2, Oracle 11g,10.2,9i, 8i, Oracle

WebLogic Server 10.3.6,OLTP, OLAP Cubes, Sybase 11.9, SQL Server

2000,DB2, UNIX/HP-UX/Solaris5.2/AIX5/WindowsXP/DOS Operating Systems,

Oracle tools/utilities/ - Developer 2000 (Reports 2.5, Forms

4.5),Business Objects (Crystal Reports), Middleware, PL/SQL, SQLPLUS,

SQL*LOADER, Designer 2000, ERwin 3.2.5, ETL/Informatica PowerCenter 9.5,

PowerExchange 9.5,B2B 9.5,DAC 10.1.3.4, Oracle Data Integrator (ODI)

11gR1,HTML,XML 1.0, C and C++ Programming languages, JavaScript, Java

2,Web Services, VB 6, Hyperion Essbase.

. Familiar with client server development projects supporting major

database systems and have worked on various commercial applications in

financial, manufacturing, sales, and telecom services

. Major Clients: Bank of America, Citi Group, UBS, ABN AMRO, ING,

Prudential Financial, State Street, H&R Block, Loomis Sayles, Johns

Hopkins University, Federal Government Department of Commerce (DOC),

Department of Defense (DOD), Department of Homeland Security (DHS)

TECHNICAL SKILLS:

Software:

OBIEE 11g1/10.1.3.4/ Siebel Analytics, Siebel 8.1 CRM, Actuate

9.1/8.0/7.2/6.0/5.0/4.0/3.2, Oracle 10g, 9i, 8i, Oracle WebLogic Server

10.3.6, Developer 2000 (Reports 2.5, Forms 4.5), SQL PLUS 9.2, PL/SQL,

Oracle enterprise Manager (OEM), TOAD, HTML, C++, C, MS COBOL, PASCAL,

Shell Programming, Wins95/NT, SCO Open Server 5.0, SCO UNIX SVR 3.2, HP-

UX 9.0, Java2, VB 6.0, Crystal Reports 8.1

Hardware:

HP 9000 model 832s, Sun SPARC ULTRA-4 Server, Sun Enterprise 250,

Sun 4000 Series, Compaq Prosignia 300, Compaq Deskpro Pentium IV, Wipros

Landmark 4860 mini system (486 based)

PROFESSIONAL EXPERIENCE:

Department of Homeland Security (DHS), Washington, DC

March 2011 - Present

OBIEE / Informatica Architect/Admin/Developer

. Interact with stakeholder and users, gather the business requirements,

design and develop functional requirement documents for Department of

Homeland Security (DHS) for the Fraud Detection and National Security

(FDNS).

. Lead the upgrade of OBIEE 10g to OBIEE 11g, ran full SDLC, and integrated

OBIEE report with Siebel CRM application.

. Design and develop the subject area, business model, mapping,

presentation catalog, answers, and complex dashboards for call center

survey Siebel module in OBIEE.

. Extract and load data from ODS and flat files using Oracle Data

Integrator (ODI) designer interface, tune packages/interfaces and set

data connection in topology manager.

. Use operator to view and manage integration jobs as well as manage users

and their repository privileges in security manager.

. Design and develop dimension hierarchies to achieve the drill down

functionality, KPI and scorecard, interactive dashboard, and request for

FDNS application.

. Provide leadership, design, and development of complex the stored

procedure and view and materialize view for performance BI publisher

reports using rtf template.

. Implement, configure, and install OBIEE 11g components and Oracle

WebLogic Server as well as the Informatica client and server in a stand-

alone configuration or as part of the Enterprise.

. Involved in BI server and database tuning, data modeling and query

performance tuning to achieve maximum performance, and retrieve data from

data warehouse structures.

. Build the Star Schemas based on the functionality as well as design,

configure, and document RPD (logical and Physical Data Models, and

Presentation Layer including administrator functionality).

. Deliver data modeling, including multi-dimensional modeling & Data

Warehousing.

. Provide production support for end-users of the system, including

training, responding to questions, resolving problems, and providing ad-

hoc reporting.

. Design, model, and build data warehouse for FDNS system using ETL

Informatica and schedule the jobs in DAC for nightly incremental refresh.

. Heavily involved in Informatica MDM,IDQ,Data Governance and profiling

. Use informatica B2B to extract data from unstructured source files and

PowerExchange to extract real time data.

. Create, design, develop, tune, and troubleshoot ETL Informatica staging,

SDE, SIL mapping, change data capture (CDC), and session and workflow for

full, incremental load.

. Deliver OBIEE, Presentation catalog, Informatica, and DAC build in

multiple environments.

. Develop, configure, and schedule DAC subject area, task group, and the

execution plan.

Development Tools: OBIEE 11g (Siebel Analytics), Oracle BI Answers, Oracle

BI Dashboards, Presentation catalog, BI Administrator and Oracle BI

Publisher, oracle WebLogic server 10.3.5, SUN OS 5.10, Windows NT

4,Oracle 11, Oracle 10.2,OLTP,OLAP Cubes, OWB, RAC, Data warehouse, SQL,

HTML, JAVA 2, JavaScript, JSP, Java, Middleware, Tomcat 4.0, WebSphere,

XML 1.0,XLS 1.0, MS VSS 6, Informatica PowerCenter 9.5,PowerExchage,

B2B,Oracle Date Integrator (ODI) 11gR1, Siebel 8.1,,DAC 10.1.3.4, SOA,

Agile

Johns Hopkins University Applied Physics Laboratory, MD

October 2010 - March 2011

Oracle BI / Informatica Architect/ Admin/Developer

. Led the implementation of the Oracle Enterprise Business Suite and Oracle

Business Intelligence applications for Financial Analytics, Procurement,

Spend Analytics, and Project Analytics modules.

. Collaborated closely with Business Users, gathered the business and

analytic requirements from different user groups, and ran full SDLC.

. Designed, setup security models, and implemented single sign on (SSO) for

OBIEE dashboard and BI publisher.

. Configured LDAP server settings in the BI Server and BI publisher to set

up users and groups.

. Used the Security Manager in Oracle BI Admin Tool to setup access

privileges and query privileges.

. Implemented user and database level security providing mentoring and

successful results in a deadline driven environment.

. Designed and developed answer, dashboard, and BI publisher reports for

PO, GL, Procurement, spending, and project.

. Troubleshot and performance tuned BI server, data warehouse, dashboard,

and answers and providing cache management.

. Setup Multiuser Development Environment (MUDE) and created projects using

the Project Manager utility.

. Implemented custom/OOB business intelligence solutions (Metadata and

Dashboards/Reports) using the BI Applications Analytics platform.

. Implemented Flex Field (FF) changes in the OOB business model to report

on GL, Procurement and spending, Purchase Orders, Purchase Requisitions,

Project Billing, and Project Cost, etc.

. Created dimensional hierarchies, level based measures, fragmentation

content, aggregations, and complex joins.

. Performed installation and configuration of BI Scheduler for delivers.

. Installed the OBIEE and BI publisher as well as configured the data

sources, security, and the setup of the super user for Publisher and

integration with BI presentation services.

. Configured the SA System Subject to set the delivery profiles of all the

users from LDAP directory.

. Developed iBots for delivering reports through email to the Finance and

Procurement users.

. Enabled and administered Usage tracking by using direct insert method.

. Implemented DAC Analysis Subject Area in the RPD to get statistics about

execution plans and tasks.

. Did Informatica MDM,IDQ,Data Governance and profiling

. Designed, developed, tuned, and troubleshoot ETL Informatica mapping,

session, and workflow for full, incremental load using EBS data source.

. Developed, configured, and scheduled the DAC subject area, task group,

and execution plan.

. Developed drill down reports, created templates for Publisher reports,

and used guided navigation feature.

. Configured global filters, dashboards, and page prompts in OBI web

catalog.

. Managed migration of RPD and presentation catalog changes across

environments through catalog manager.

. Configured charts, pivot table views, and filters in user interface.

. Configured repository/session variables and initialization blocks to get

dynamic reports and dashboards.

Environment: OBIEE 10.1.3.4.1, OBI Apps 7.9.6.1, Oracle BI Publisher

10.1.3.4.1, Oracle 11G, SQL Developer, Middleware, ETL/Informatica

PowerCenter 8.6, DAC 10.1.3.4, OWB, Linux 2.2, EBS Financials, EBS

Procurement and Spend, EBS Projects.

Department of Defense (DOD), Washington, DC May

2010 -Sep. 2011

OBIEE/Informatica Architect /Developer

. Served as the Architect entrusted to interact with stakeholder and users,

gather the business requirements, and design and develop functional

requirement documents for Department of defense (DOD) for defense

personal property system (DPS) application.

. Designed and developed subject area, business model, mapping, web

catalog, answers and complex dashboards for call center survey Siebel

module in OBIEE.

. Designed and developed dimension hierarchies to achieve the drill down

functionality, interactive KPI dashboard, and answers for DPS

application.

. Designed and developed complex stored procedures as well as viewed and

materialized view for performance BI publisher reports using rtf

template.

. Converted Actuate 7.2 reports to BI publisher reports and modified

existing BI publisher reports rtf templates and SQL queries.

. Implemented, configured, deployed Oracle Business Intelligence Enterprise

Edition (OBIEE) components in a stand-alone configuration or as part of

the Enterprise.

. Involved in BI server and database tuning as well as in data modeling and

query performance tuning to achieve maximum performance while retrieving

data from database structures.

. Built the Star Schemas based on the functionality and handled data

modeling including multi-dimensional modeling & Data Warehousing.

. Designed, configured, and documented logical and Physical Data Models as

well as Presentation Layer including administrator functionality.

. Provided production support for end-users of the system, including:

training, responding to questions, resolving problems, and providing ad-

hoc reporting.

. Designed, developed, tuned, and troubleshot ETL Informatica mapping,

sessions, and workflow for full, incremental load.

. Provided development, configuration, and scheduling of the DAC subject

area, task group, and execution plan.

. Upgraded Informatica from 7.8 to Informatica 8.6, DAC from 7.8.2 to DAC

10.1.3.4, and Siebel analytics from 7.8 to OBIEE 10.1.3.4.

. Delivered OBIEE support, web catalog, Informatica, and DAC built in

multiple environments.

Development Tools: OBIEE 10.1.3.4 (Siebel Analytics), Oracle BI Answers,

Oracle BI Dashboards, Web catalog, BI Administrator and Oracle BI

Publisher, SUN OS 5.10, Windows NT 4, Oracle 11, Oracle 10.2, OLTP, OLAP

Cubes, OWB, RAC, Data warehouse, SQL, HTML, JAVA 2, JavaScript, JSP,

Java, Tomcat 4.0, Agile, WebSphere, Middleware, XML 1.0, XLS 1.0, MS VSS

6, Power Center Informatica 8.1, Siebel 8.1, DAC 10.1.3.4. SOA

Federal Government Department of Commerce, Washington, DC

October 2008 - April 2010

OBIEE/Informatica Lead / Architect

. Served as the Lead and Architect entrusted to design and develop

dimension hierarchies to achieve the drill down functionality,

interactive dashboard, answers for Non response follow up reports for

housing unit, group quarter enumeration, group quarter advanced visit,

remote Alaska and elementary transitory location operations.

. Collaborated with stakeholder and users, gathered business requirements,

designed and developed functional requirement documents for PBO

application for NRFU, GQE, GQAV, RA and UL operations for CENSUS 2010.

. Designed and developed complex stored procedure as well as viewed and

materialized view for performance BI publisher reports using rtf

template.

. Provided modification in existing BI publisher reports rtf templates and

SQL queries.

. Implemented, led configuration, and deployed Oracle Business Intelligence

Enterprise Edition (OBIEE) components in a stand-alone configuration or

as part of the Enterprise.

. Directly involved in BI server and database tuning, and data modeling and

query performance tuning to achieve maximum performance while retrieving

data from database structures.

. Built the Star Schemas based on the functionality, design, configuration,

and document logical and Physical Data Models.

o Presentation Layer included administrator functionality.

. Delivered the data modeling including multi-dimensional modeling & Data

Warehousing.

. Provided production support for end-users of the system which included

the training, responding to questions, resolving problems, and providing

ad-hoc reporting.

Development Tools: OBIEE 10.1.3 (Siebel Analytics), Oracle BI Answers,

Oracle BI Dashboards, BI Administrator and Oracle BI Publisher, Solaris

5.2, Windows NT 4, Oracle 10.2,Oracle 11,OLAP,OWB, RAC,DB2, Data

warehouse, SQL, HTML,JAVA 2, JavaScript, JSP, Java, Middleware, Tomcat

4.0, Agile, WebSphere, XML 1.0,XLS 1.0, MS VSS 6,Power Center Informatica

8.1,DAC. SOA

ING, Windsor, CT

January 2008 - September 2008

OBIEE/Siebel Analytics Lead / Application Architect

. Served as the main Siebel Lead and Application Architect who implemented

and configured OBIEE in Windows environment and integrate it with an

Oracle data warehouse and Hyperion ESSBASE.

. Interacted with business and users, gathered the business requirements,

designed and developed functional requirement documents for loan, fund,

consolidate enrollment tool, and beneficiary maintenance.

. Designed and developed complex reports, interactive dashboard, answers

related to payroll deduct and direct bill loan, fund, consolidate

enrollment tool and beneficiary maintenance.

. Built the Siebel Analytics repository (RPD) /metadata and defined/created

the subject areas where reporting and analysis were centered around.

. Constructed data visibility and security rules as well as implemented

them within Siebel Analytics to provide record-level, team-based, and

group-based security into the Data warehouse.

. Collaborated with client to define corporate Key Performance Indicators,

business intelligence corporate strategy, and roadmap.

. Created, modified, and administered analytics intelligence interactive

dashboards, answers with links to web sites, HTML text, links to

documents, and embedded content, such as images, text, charts, and

tables.

. Designed and developed complex financial BI publisher report using rtf

template and writing complex SQL queries in BI Publisher data set.

. Provided modification, enhancements, and changes in exiting BI publisher

reports as per the business requirement.

. Captured and documented Business Requirements from client conducting

interviews and workshops.

. Completed the development on the functional and the technical

specifications.

. Assisted in the performance of gap Analysis related to Data Models and

data extracted in ETL's, and map client requirements into OBIEE/ Siebel

Analytics functionality.

. Extensively handled data modeling, including multi-dimensional modeling &

Data Warehousing.

. Built the Star Schemas based on the functionality.

. Designed, configured, and documented logical and Physical Data Models.

o Presentation Layer included the administrator functionality.

. Produced on the different layers of the Siebel Administration Tool.

. Designed, built, and tested reports, Dashboards, BI Publisher, Microsoft

Integration, and other functionality within the OBIEE suite.

. Create Oracle BI metadata in the analytics repository with Oracle BI

Administration Tool.

. Implemented Multi-User Development (MUD) in Production and created

dimension hierarchies to achieve the drill down functionality.

. Performed administrative tasks like creating Users and assigning them to

a group and restricting users to the development environment.

. Implemented caching to increase performance as well as created, modified,

and administered analytics intelligence dashboards.

. Maintained Session and Security in OBIEE and created users and groups

assigning these users and groups to the Dashboards.

. Developed Test Plan including test scripts for Unit, System, and User

Acceptance Testing including resolution of bugs.

. Delivered world class business and technology solutions that enable

client to become high performance businesses.

. Led configuration of in-scope functional and technical requirements based

on design documents including data structures, data mapping, and related

Performance Tuning.

Development Tools: OBIEE 10.1.3 (Siebel Analytics), Oracle BI Answers,

Oracle BI Dashboards, BI Administrator and Oracle BI Publisher,Solaris

5.2, Windows NT 4, Oracle 10,OLAP,Oracle BAM 10g, Sybase 11.9,

DB2,Datawarehouse,T-SQL, DBArtisen, SQL, HTML, JAVA 2, JavaScript, JSP,

Java, Tomcat 4.0, WebSphere,XML 1.0,XLS 1.0, MS VSS 6,Power Center

Informatica 8.1,DAC, Hyperion Essbase, SOA

Prudential Financial, NJ

September 2007 - December 2007

Siebel Analytics Consultant/Lead

. Interacted with management, business and users, gathered the business

requirements, designed and developed complex dynamic business quality

compliance group reports related to annuity, audit and early warning.

. Designed and developed functional requirement documents for agency system

business quality for compliance group.

. Debugged and troubleshot the existing report for better performance and

fixing the errors.

. Gained an understanding Client requirements, source data, business

objectives, and key performance indicators.

. Designed the Technical Design documents by understanding the Functional

Design documents for the sales performance.

. Created and developed complex reports, interactive dashboard, answers,

and BI Publisher.

. Identified the Facts, Dimensions, and grained of the Dimensional mode and

referential joins.

. Built Siebel Analytics Repository at 3 layers i.e., Physical Layer

(connecting to Data sources and import schema), Business Model / data

mapping (create Logical tables and data source mapping) and Presentation

Layer level (create presentation catalogs).

. Developed Business Facts and Dimensions as well as defined Logical

relation between them in BMM layer.

. Created Dimensional Hierarchies for the Drill Down functionality and

implemented Business Logics for Facts.

. Analyzed and validated the business model in Siebel Administration Tool

by performing consistency checks, validating logical source tables,

logical columns, and validating repository level calculations done in the

business model layer.

. Imported Physical Tables and defined Relations in Physical Layer in

Siebel Analytics.

. Created Reports using different Analytics Views (Pivot Table, Chart,

Column Selector, Table).

. Developed Pivot Tables and manipulated Init Blocks for report analysis.

. Tuned the performance of the reports by creating various types of indexes

wherever appropriate.

. Used many pre-processing, post-processing, and validations scripts using

Oracle PL/SQL.

. Managed the security of the defined users and groups, set permissions,

Group Inheritance, Authentication Methods, Query Limits, Timing

Restrictions, and Filters.

. Converted and migrated actuate reports to Business Objects and created

new crystal reports.

. Created parameterized Crystal Reports using Charts, Cross-Tab, Sub-

reports, Xcelsius, dashboard, Running Totals, chart, and Live Office

documents.

. Provided extensive analysis to design the Universes and assign them to

respective domains.

. Used Business Object Universe, Business Objects Reports, and Business

Objects repository as well as new enterprise universes were designed and

developed to support the user requirements.

Development Tools: Siebel Analytics 7.8.4, Windows NT 4, Business Object

X1,Sybase 11.9, Oracle 10.2,Datawarehouse,T-SQL, DBArtisen, SQL, PL/SQL,

HTML,JAVA 2, JavaScript, JSP, Java, Active portal, Web Services,

WebSphere, IIS, XML 1.0, XLS 1.0, Power center Informatica 7.1, MS VSS 6,

Hyperion Essbase, BI Publisher

Loomis Sayles, Boston, MA July 2006 -

September 2007

Sr. Siebel Analytics / Actuate Consultant Lead

. Served as the Lead, designing and developing functional requirement

documents (FRD) for GPS, Fixed Income, Mutual funds, Hedge fund, and

Derivatives.

. Developed application in Java and called the dynamic actuate reports from

Java application using requester, report server APIs, and actuate web

services.

. Interacted with business and users around the world and gathered the

business requirements.

. Designed and developed complex dynamic financial reports related account

distribution, account listing, sales, stale price, prime brokerage, and

multiple products etc.

. Designed and developed the business model, mapping, physical design, and

universe for GPS in Siebel Analytics administration.

. Built the Siebel Analytics repository/metadata, and defined/created the

subject areas where reporting and analysis were centered around.

. Created financial interactive dashboard and answers in Seibel Analytics

and developed the complex drill down financial reports in Seibel

Analytics.

. Designed and developed espreadsheet using actuate 7.2 eSpreadsheet

designer, Java Callback classes, and XSLT templates file for top

management to analyze the data and to take the appropriate decision.

. Migrated reports including espreadsheets from actuate 5 and actuate 7.2

to Actuate 9.1.

. Installed Actuate 9.1 iserver and iportal on Solaris 5.2 and customize

iportal.

. Designed and developed new libraries and bas file and did some

modification in existing libraries.

. Developed and tuned package, stored procedure, and used them in reports

to enhance performance.

. Debugged and troubleshot the existing report for better performance and

fixed the errors.

. Extensively used multiple / single Data Filters, Memory Buffer,

Sequential, and Conditional sections.

. Created information objects from number of heterogeneous data sources for

end user using actuate information object designer and used these

information objects in Actuate query for ad-hoc queries.

. Provided Multiple Level Dynamic Groupings and wrote Actuate iserver

online backup Shell Script.

Development Tools: Solaris 5.2, Windows NT 4, Siebel Analytics 7.8.4,

Actuate 9.1/8.0/7.2 (eRDPro), Machine console), Actuate iServer,

eSpreadsheet engine 10, Actuate Query, eAnalysis, BIRT 2.2,LDAP,RSSE,

Sybase 11.9,Oracle 10.2,Datawarehouse,T-SQL, DBArtisen,SQL,PL/SQL,

HTML,JAVA 2, JavaScript, JSP, Java, Tomcat 4.0, Active portal, Web

Services, IIS, WebSphere, XML 1.0,XLS 1.0, MS VSS 6, VSS 6, JIRA,

Informatica 7.1

CITI GROUP, NJ

May 2005 - June 2006

Sr. Siebel Analytics Lead/Application Architect

. Designed and developed business requirement documents (BRD) functional

requirement documents (FRD) for Global equity office (GEO), Fixed Income,

and Mutual funds.

. Developed the application in Java and called the dynamic actuate reports

from Java application using requester APIs.

. Designed and developed complex dynamic financial equity research reports

related to McLagan, PAN European, soft dollar, account by account, sales,

and market sales.

. Designed and developed logical and physical database design and

repository for GEO in Siebel Analytics administration.

. Collaborated with business analysts and users around the world, gathering

the business requirements

. Designed and developed financial interactive dashboard and answers in

Siebel Analytics.

. Developed complex drill down financial reports in Siebel Analytics and

extracted data from heterogeneous data source loading in Oracle data

warehouse using ETL Informatica.

. Developed and provided page level security to secure the reports and

information for appropriate users in Actuate.

. Created various kind of financial eSpreadsheet using Actuate eSpreadsheet

designer and XSLT templates.

. Created user interactive form based drill down reports with the help of

browser script control, HTML, and JavaScript.

. Developed information objects from number of heterogeneous data sources

for end user using Actuate information object designer and used these

information objects in Actuate query for ad-hoc queries.

. Designed and developed new libraries and bas file and provided

modification in existing libraries.

. Developed and tuned packages, stored procedure, and used them in reports

for better performance.

. Troubleshot and debugged the existing report to enhance performance and

fix errors.

. Provided analysis, plan, and design for the migration from Actuate 7.2 to

Actuate 8.0.

. Extensively used multiple /single Data Filters, Memory Buffer,

Sequential, Conditional sections, and Multiple Level dynamic Groupings.

Development Tools: Solaris 5.2, Windows NT 4, Actuate 8.0/7.2 (eRDPro),

Machine console),Actuate iServer, eSpreadsheet engine, Actuate Query,

Designer, Sybase 11.9,Oracle 9i,Datawarehouse,T-SQL, DBArtisen,SQL,PL/SQL, HTML,JAVA 2, JavaScript, JSP, Java, Tomcat 4.0, Active

portal, XML 1.0,XLS 1.0, Web Sphere, Test Director 8.0,MS VSS 6, ETL

Informatica 6.2, Seibel Analytics 7,Teradata

ABN AMRO, NJ

September 2004 - April 2005

Sr. Actuate Consultant / Team Lead

. Designed and developed complex dynamic financial trade reports related to

export LC, import LC, collection, import bill Schedule, guarantee fee

detail, bank trade, and export and import standby etc.

. Installed Actuate 7.2 server and portal on AIX 5 and imported the

encyclopedia volume using actuate acimport utility.

. Created user interactive form based drill down reports with the help of

browser script control, HTML, and JavaScript.

. Interacted with business analysts and users, gathered the business

requirements, designed and developed functional requirement documents

(FRD) for MaxTrade7.

. Designed and developed cube cell reports using actuate Analytics for top

management to analyze the data and to take the appropriate decision

. Created information objects from number of heterogeneous data sources for

end user using actuate information object designer.

. Developed tons of queries to analyze the data using Actuate query and put

the result set in e.Analysis for further drill down.

. Designed and developed eSpreadsheets including graph and pai chart to

investigate the financial data.

. Designed and developed new libraries and bas file and did some

modification in existing libraries.

. Debugged and troubleshot the existing report to provide enhancements and

fix errors.

. Developed and tuned packages, stored procedures, and used those

procedures for reports to increase performance.

. Analyzed, planned, and designed the migration from Actuate 5 to Actuate

7.2.

. Extensively used multiple / single Data Filters, Memory Buffer,

Sequential, Conditional sections and Multiple Level dynamic Groupings.

Development Tools: AIX 5, Windows NT 4, Actuate 7.2 (eRDPro), Actuate 5.0,

Actuate query, eSpreadsheet, e.Analysis, Sybase 11.9,T-SQL, DBArtisen,

Informatica, HTML, JavaScript, JSP, Java, Tomcat 4.0, Active portal,

Web Sphere, Test Director 8.0,

UBS, NJ

March 2004 - August 2004

Sr. Actuate Consultant / Application Lead

. Interacted with the Business Analyst, gathered the business requirements,

designed and developed functional requirement documents (FRD) for

companies' financial stock options quick, and provided application

support.

. Advanced reports like options outstanding, FAS disclosure summary, option

expense, and actual forfeiture complying with financial accounting

Standard Board (FASB) rules and regulation.

. Designed and developed quick and advanced dynamic financial stock option

reports like options outstanding, FAS disclosure summary, option expense,

actual forfeiture, and prime brokerage.

. Developed and tuned Oracle packages, stored procedures, and used them in

reports for better performance.

. Developed reports with Export to Excel functionality that sent report

data to Excel spreadsheets for specific usage.

. Integrated Actuate reports with VB application using requestor APIs.

. Designed and developed libraries for reusability and bas file.

. Designed, developed, and deployed financial reports as part of the

Financial Analysis and Management System (FAMS) group.

. Developed Staff FTE, Head Count, Expense, Revenue, NEV, and Portfolio

reports for the current financial year forecast and next financial year

plan.

. Developed Monthly, Quarterly, and Annual trend reports for Actual,

Forecast, and Plan data.

. Used sequential sections, parallel sections, conditional sections,

multiple level nested groupings, dynamic (runtime) queries, and charts in

most reports.

. Utilized memory buffers, single/multiple input filter, and output to

Excel using Objects.

. Interacted with a group of 200 users to gather requirements, interacted

with the DBA for database modifications, SQL queries, and performance

tuning, and interacted with the Website Developer for designing the front-

end interface.

. Followed the change control process using PVCS and eNotes to deploy the

reports on the development server and then move the server to UAT server

where it was tested and debugged before final movement to the Production

server.

Development Tools: Sun Solaris 5.2, Windows NT 4, Actuate7.2 Oracle 9i,SQL

Contact this candidate