Data Manager

Summary

. *+ years of total IT experience with in depth understanding in full

lifecycle of SDLC methodologies like Spiral Methodology or Rapid

Application Development (RAD) etc...

. Experience with Business Objects XIR 4.0/3.2 / XI R2 / 6.x / 5.x, Web-

Intelligence Rich Client, Web Intelligence, Data Services XIR3.1,

Broadcast Agent, Publishing wizard, Designer, Supervisor, Auditor,

Crystal Reports (2011/Enterprise/XI R2), Xcelsius 4.5/4.0, Dashboard

Manager.

. Business Analysis experience in gathering requirements, developing and

designing BA documents (BRDs, FRDs, TSDs, Mapping Documents), bridging

the gap between the business and the technical persons.

. Good Exposure in Data Warehousing Concepts, Data Modeling Concepts and

Data Normalization techniques.

. Upgrade experience from 6.5/XIR2/XIR3.

. Experience in Administration in managing Folder security, User

security using Security Matrices.

. Expertise in Business Objects Installations and setting up the client

tools and in upgrading the existing versions with the latest Monthly

Hot Fix (MHF), Critical Hot Fix (CHF), Service Pack (SP) and Fix Pack

(FP).

. An enthusiastic and project-oriented team player with solid

communication and leadership skills and the ability to develop

creative solutions for challenging client needs and proficient in

providing accurate solutions.

. Professional American (Managerial & Lead) references will be provided

upon request.

Education & Certifications

Bachelor of Engineering in Information Technology, GIET, Orissa, India

Masters in Computer Science, 2007 Spring, Mc Neese State University, Lake

Charles, LA

Technical Skills

Business Business Objects XIR 4.0/3.2/ XI R2/6.x/5.x, Web

Intelligence Intelligence Rich Client/XI R2/6.0/2.x, Infoview,

Designer, Supervisor, Broad Cast Agent, ZABO, MS Access

Reports, Crystal Reports XI R2.

Business MS Office, Microsoft Visio, Microsoft Visual Source Safe

Analysis 6.0, Rational Rose, RequisitePro, Rational ClearCase,

ClearQuest, Business Requirements Gathering

ETL Tools Data Services XI R 3.2/3.1 (Data Quality), IBM

Information Server 8.1/7.5.x/7.1, Qualitystage 7.5x

(Manager, Administrator, Designer, Director), Parallel

Extender, SQL*Loader & OWB

Programming C, C++, OOPS Concepts

Languages

Databases MS SQL Server 2000/2005, Release 10 SQL/9i/8i/7.3,

PL/SQL, DB2 UDB, Teradata v2r5, Sybase 12.x, AS/400

UNIX Tools Shell Scripts, C Shell, K-Shell Scripts, VI-editor, Perl

Scripting.

Dimensional Dimensional Data Modeling, Data Modeling, Star Join

Data Modeling Schema Modeling, Snowflake Modeling, FACT and Dimensions

Tables, Physical and Logical Data Modeling, ERWIN

4.5/4.0/3.5/3.2

Servers Oracle 9iAS, MTS, IIS, Apache, Tomcat and MS Site Server

Professional Experience

Morgan Stanley Smith Barney (Wealth Management), New York, NY

Apr '13 - Till Date

Sr. Business Objects Developer

Project: Deployment Planning & Release Management (DPRM)

Responsibilities:

. Gathered requirements from all DPRM teams (Planning, Tools &

Development, Execution and Metrics) and documented them in BRDs.

. Worked closely with SMEs to understand the business workflow.

. Developed a Standards and Best Practices documents.

. Developed a brand new universe as per the requirements providing one

platform for business insights for all Business Releases.

. Applied folder level security at the universe level.

. Designed a user security model by creating multiple Business Objects

user groups & assigning them appropriate rights using Central

Management Console.

. Developed custom reports with complex variables.

. Developed mapping document from Old Source data to New Source data.

. Identified source system data thoroughly and developed custom feeds to

populate DPRM database.

. Converted most of the Qlikview dashboard reporting to Business Objects

reporting.

. Created custom business objects Daily feed files to support other DPRM

teams' SharePoint sites.

. Provided Business Objects Basic & Intermediate levels training.

. Created & Administered publications for report bursting to business

users using notifications using CMC.

. Developed many Planning team reports helping them to perform a

smoother release execution tracking all defects on time for all

projects across Morgan Stanley.

. Managed DPRM request portal & provided bi-weekly status updates.

. Managed & worked with offshore ETL team for any ETL related changes.

. Did troubleshoot all Business Objects relate issues in a timely

manner.

. Managed all documentation for all report requests in a BRD template.

. Provided custom SQL (derived tables) solutions for few reporting

requirements.

. Managed instances using Instance Manager.

Environment: SAP Business Objects 4.0/Data Services 3.1(CMC, Rich Client,

Designer, Import Wizard, Instance Manager), Web Intelligence (Webi),

Informatica 7.5, Qlikview 10, Sybase 15, Rapid SQL, Hp Quality Center, MS

Office 2007 suite.

Shire Pharmaceuticals, Chesterbrook, PA

Mar '13 - Apr '13

Sr. Business Objects Developer

Responsibilities:

. Involved in thorough testing of SAP Business Objects 4 version in all

environments.

. Developed detailed test scripts with detailed steps to test each and

every new feature in SAP BI 4.0

. Developed similar test scripts for all server tools, client tools and

web tools.

. Involved in server configuration and multiple nodes setup for better

performance in 4 different environments (Sandbox, Dev, QA & Prod)

. Ran all the test scripts against all the 4 environments.

. Did Load balancing test in QA and Prod environment using few existing

sample reports from SAPP Business Objects 3.1.

. Created test accounts to run the scripts with different security

access setup.

. Worked with Business Users to test their respective business reports

in QA.

Environment: SAP Business Objects 3.1/4.1(Information Design Tool, Data

Services, Web Intelligence (Webi), Rich Client, Xcelsius, Explorer,

Workspace, BI Mobile, Monitoring)

TD Bank US, Mt Laurel NJ

Nov '10 - Jan '13

Business Objects Developer

Project 1: TSFG Integration Project

Project 2: BLDM Commercial & Retail Risk Projects

Responsibilites:

. Involved in all the Phases of Integration process of TSFG acquisition

and worked with the respective team SMEs to gather more business

oriented knowledge..

. Provided quick turn around ETL solutions which can be implemented at

universe level.

. Streamlined the process of publishing the universe and reports &

followed norms by official signoff from the business.

. Implemented Cascading List of Values at the universe level using

Information Design Tool (IDT).

. Scheduled the reports to run daily, weekly or monthly as per

requirements and automated the reports to deliver pdf/excel output of

the report to the end users upon successful completion of the report.

. Used Crystal Reports Enterprise to connect to existing universes to

convert SSRS reports to Crystal Reports.

. Developed multiple Hyper linking reports in 4.0.

. Worked closely with Commercial & Retail Risk Information Management

delivery teams for resolving any technical roadblocks and meeting with

the Technical Analysts and with the Business users.

. Adhered to best practices for migration from XI 3.2 to 4.0.

. Used Relationship queries & Security Queries for automating the

security matrix spreadsheet for all user groups.

. Maintained backups and versioning at each migration level.

. Optimized few highly time consuming reports providing alternate

reporting solutions.

. Involved in training around 50 users.

. Created Daily & Monthly Audit reports to monitor universe usage, user

inactivity & user logins during daily load processes and month end

reporting.

. Provided Production Support and assisted Business Users as needed

regarding issues with Web Intelligence reports.

. Developed Universe Standards & Guidelines document for implementing

best BO practices.

. Worked closely with Web Logic/Web Services team for testing the Custom

designed Web Portal (Portico) for accessing Web Intelligence reports.

Environment: SAP Business Objects 4.0/3.2 (CMC, Web Intelligence (Webi)

Rich Client, Designer, Query Builder), Data Stage 8.5, Informatica 8.0,

Data Services, Crystal Reports Enterprise, SQL Server 2005, Release 10 SQL,

MS Office Suite, TOAD for Oracle, SQL Developer.

Wells Fargo Home Mortgage, Minneapolis MN/Fort Mill SC

Oct '09 - Oct '10

BI/Business Objects Developer

Project 1: MSP BI (Mortgage Servicing Platform - Business Intelligence)

The MSP data warehouse is a collaborative effort between LPS and Wells

Fargo to create a new reporting platform with a rich data environment. The

content is being built and validated in conjunction with Mortgage Servicing

Platform Warehouse implementation and currently contains metadata and

lineage from the MSP, Daisy, Passport, RFUF, and other documented sources.

Responsibilites:

. Gathered all reporting requirements from the internal business users

and documented them in BRDs appropriately.

. Designed mapping documents for mapping data elements from source

systems to target MSP BI warehouse necessary for reporting to identify

objects.

. Reviewed and Prepared Naming standards documents, Best practices

document, Release documents, code migration steps to perform.

. Implemented transformations within the work flows and data flow to

transform the data as per business rules.

. Used Data Quality (Data Services) for cleansing and standardizing the

Customer and operational data.

. Extensively worked on conversion of SAS and SQL BI reports to Business

Objects.

. Used import wizard for migration to import the list of users and

reports to the new environment.

. Supported the post-migration from XIR2/XIR3.2.

. Resolved all post migration access issues by re-creating the security

structure.

. Installed all Fix Packs and Hot Fixes periodically but better enhanced

performance.

. Maintained necessary documentation regarding all reports being

developed.

. Took training sessions for various business users for presentation of

the advanced features of Business Objects to users and developers to

enable them to develop queries and reports easily.

. Created 3 new universes for different time series views (Current,

Daily and Month End) and maintained 1 existing universe.

. Extensively used different data providers and successfully merged the

data from both the queries.

. Developed around 200 exception reports for the respective business

lines.

. Extensively used Web Intelligence Rich Client for developing using

Excel files as external data source contained predefined list of

Loans.

. Developed crystal reports which required data elements which have not

been mapped to the warehouse.

. Extensively used Combined Queries for replicating the MS Access

Queries used for reporting.

. Built Corporate Dashboards using Xcelsius to show all Key Indicators

for the higher management.

. Extensively used Net meeting and Microsoft Outlook Live Meeting for

assisting the remote users in different locations.

Project 2: - ERLMF (Early Resolution Loss Mitigation Fulfillment)

ERLMF is an automated workflow system intended to automate and manage the

Loss Mitigation process from setup to settlement. It is a workflow system

that presents loan tasks to you according to their priority. You need to

select workflow to perform your loan tasks. Depending on the role, some

associates may see additional menu items. It details the key tasks and

steps for processing a loan.

Responsibilities:

. Worked with Business Analyst to identify the different elements of

data in the application.

. Worked under the guidance of a Senior Data Modeler, based on the

Business requirements and functionality gathered after interacting

with the domain experts.

. Worked with Business Analysts on gathering reporting requirement and

documented them on a standardized template.

. Analyzed the various Entities sets (and types), their attributes,

Relationships (super-type,

sub-type, recursive relationships, keys, index, etc their

participation in the logical views based on sample information.

. Conducted peer reviews for all test deliverables before distribution

to other departments.

. Worked on bunch of daily report for managers to constantly monitor

daily beginning inventory (Inflows - new case setups) and daily ending

inventory (outflows - completions and removals).

. Worked on summary reports to give managers an overview of how much

inventory is currently in suspense, within what tasks and for how

long.

. Extensively used input controls.

. Designed reporting standards.

. Built universe on the designed schemas, well tested and exported them

to repository using Business Objects Designer Module.

. Created basic Bex Queries in Bex Query Designer.

. Used Aggregate Awareness to improve performance..

. Developed hyper linking reports using opendoc function.

. Involved in using Xcelsius to Transform Microsoft Excel spreadsheet

data into interactive flash media files for the upper level

management.

. Used Combination charts in Xcelsius for the mangers to easily switch

between different charts in the same Report.

. Created and developed Pivot charts and Pivot table reports from Pivot

tables by connecting them to an external data source and simulated it

to Xcelsius.

Environment: SAP Business Objects 3.2 (CMC, Web Intelligence (Webi),

Crystal Report, Xcelsius 2008, Universe Designer, Universe Builder), SAP

Data Services 3.2 (Data Integration & Data Quality), SAP BI 7.0, Release 10

SQL, Teradata V2R5, SQL Server 2008 (SSRS), SAS 9.1, MS Office Suite,

Windows XP Professional, Windows Server 2003.

First American Home Buyers Protection, Van Nuys, CA

June '08 - July '09

Business Objects Admin and Developer

First American Home Buyers Protection is one of the nation's leading and

most experienced home warranty companies. The company provides one year

residential service contracts that typically cover the major systems and

appliances in resale homes protecting home buyers from the cost of repair

or replacement of essential systems and repairs are completed by a

nationwide team of certified contractors.

Responsibilities:

. Built a new updated report requirements gathering template, which was

used to gather all necessary information from the user, regarding

their reporting requirements.

. Defined ETL Jobs for loading data from Source to Staging area and from

Staging area to Target.

. Responsible for conducting JAD sessions and live meetings with all the

end users.

. Worked with Data Modelers' on designing the staging area on both

logical and physical modeling phases.

. Designed Job Sequences for every project to run in a loop based on the

success or failure of individual jobs in the Sequencer.

. Defined rules on transformation of data from source to staging area

and from staging area to target.

. Worked with Data Base Analysts for creating various SQL views to be

implemented in the universes for better performance of the reports.

. Efficiently used CMC for administration jobs such as report

scheduling, add/remove a user, assigning rights and server management.

. Tuned the queries to improve the performance of the report refresh

time.

. Maintained existing 2 universes and developed 6 new Subject-Oriented

universes.

. Used Data Stage Manager for importing the source and target database

schemas, importing and exporting jobs/projects, creating new job

categories and table definitions.

. Extracted data from various sources, transformed according to the

requirement and Loaded into data warehouse schema using various stages

like sequential file, Aggregator, Transformer stage.

. Trained and assisted the Financial Analysts in creating ad hoc

reports, as they were responsible for ad hoc reporting for all the

enterprise wide users.

. Built highly complex reports in both web intelligence and in crystal

reports depending on the complexity.

. Created two Web Intelligence reports with hyper linking functionality

using OpenDoc function.

. Created new user groups mapping from the Windows NT user groups and

managed security rights associated with the users and groups for

different folders and universes.

. Managed all report scheduling and exported the instances to various

end users in pdf or excel formats.

. Extensively used Query builder and Instance Manager for managing

number of reports pointing each universe and for finding out the

status of all running reports and failed reports.

. Worked with Crystal Report XIR2 for creating complicated reports

including sub-reports, parameter based reports, graphical reports,

formula based, well-formatted reports, some including built in

security for different levels of employees.

. Created crystal reports for automatic generation of different versions

of work order dispatch orders, which are dispatched to the contractors

located in different parts of US.

. Extensively used Microsoft Visual Source Safe for version control for

Crystal Reports and various Microsoft Word Templates.

. Worked closely with DBAs for creating stored procedures to be used in

Crystal Reports for complex business requirements.

. Developed universes on top of SAP Bex Queries.

. Checked the integrity of the universes, finally exported them to

repository.

. Created test reports to check functionality of universes.

Environment: Business Objects XI R2, Ascential Datastage 7.5, Crystal

Reports XI R2, FALCON 1.8/2.0, SAP BW 3.5, Microsoft SQL Server 2005,

Microsoft Office 2007, Microsoft Visual Source Safe 6.0, Image Now 6.0

Prudential Financial, PA, USA

Sep '07 - April '08

Business Objects Developer

Prudential is one of the largest life insurance and financial services

institution in the United States of America. In order to provide value

added service to their 401K Retirement services clients Prudential

currently has a 401(k) website as part of their Retirement Services Online

(RSO) system. The prudential SCT re-architecture project was envisaged to

address the inherent issues with the existing internet service channel

(called, Retirement Services Online or RSO).

Responsibilities:

. Performed Business Analysis & Requirements Gathering from users and

managers.

. Developed BRDs and created Mapping Documents for specifying source

tables and target tables and the transformations as required.

. Involved in JAD sessions for review of the BRDs and Mapping Documents

with other team members.

. Extensively used BO Designer to design and maintain Data Warehouse

Universe.

. Designed and developed ETL jobs for extracting the Data from different

sources like Operational Date Store and Flat Files for loading data

into the Data Warehouse applying business rules and standard

validations.

. Performed the Unit testing for jobs developed to ensure that it meets

the requirements.

. Worked with data modelers with designing the staging and target

databases.

. Extensively used various utilities of Teradata for Fast Load, Multi-

Load, T-Pump and BTEQ to populate the Enterprise Data Warehouse.

. Involved in Universe Designing, Hierarchy Building for Data Analysis

and applied conditions in Objects.

. Used QaaWS tool for creating and editing web services and published

them for the users to be available for them.

. Designed, developed, tested and maintained highly complex reports.

. Extensively used Sectioning, Ranking, Filtering, Slice and Dice to

develop the reports.

. Generated Crystal report using Release 10 SQL working with stored

procedures.

. Created views & materialized views in Oracle database & connected thru

Crystal report.

. Exported the reports in to PDF, Excel and Word formats.

. Web Intelligence was used to create the reports, communicate to the

other team members and to test the reports.

. Experienced in working on Web Intelligence Universe Designer, Crystal

2008 and SDK.

. Performed the knowledge transfer to other team members.

. Created Queries, Document Centricity, Calculations, Variables, Breaks,

Sorting, Alerters and Formatted Presentation Styles (Graphical). Most

of the reports involved using multiple data providers, Free hand SQL,

Pie charts, Alerter's, Formula and formatting using slice and dice

panel.

. Customized Business Objects Info view and Designer using Business

Objects SDK.

. Interacted with Business Analysts and end users to develop standard

and ad-hoc reports according to functional specifications.

. Implemented Business Objects Universes hitting directly the Teradata

database.

. Developed user friendly, easily understandable manuals for all

universes developed with respect to their purpose.

. Responsible for creating SQL code testing on SQL Plus in order to

develop a code for creating a view by the DBA.

. Tested the built SQL code against the database and created various

crystal reports using SQL queries in a command for complex reports

involving complex calculations.

. Have excellent formatting techniques in Crystal Reports.

Environment: Business Objects XI R2 (Designer, Supervisor, BO Full Client,

Web Intelligence, Broad Cast Agent, Publisher, QaaWS), SDK, Data Integrator

XI R2, Teradata V2R6, Crystal 2008, MS Access, Erwin 5.0, Toad, MS Visio,

MS Office, Rational Rose Suite, Crystal Xcelsius 4.5, Release 10 SQL and

Windows Xp.

SBC Services Inc, San Ramon, CA

Dec'06-Jul'07

Sr Business Objects Developer

Worked in SBC Data warehouse group, Designed and Created Universes for

generating Complex reports for the Application using Enterprise Data

Warehouse (EDW). Also designed and developed many universes for PMR and

Revenue applications. Resolved many productions problems for various

applications. Prepared the document for how to retrieve the reports from

the repository and how to run the report for first time users, given

training to some of our developers and how to develop complex Reports using

Business objects. Worked in development of reports using Teradata database.

Responsibilities:

. Designed mappings, transformations and workflows using Data

Integrator.

. Assisted Data Modelers in defining and designing the database

structure for the warehouse using Erwin.

. Design and development of Universes using Business Objects 5.x

. Implemented Security Matrix and defined user profiles for different

groups.

. Detected cardinalities and checked the Integrity of Universes.

. Configured Info view and an admin instance.

. Customized Parameter passing from master report to detail reports.

. Implemented security structures with row level restrictions and object

hiding.

. Scheduled reports with Broadcast agent and implemented report

bursting.

. Linked webi reports for different hierarchies.

. Created complex reports for various Applications using the Universes,

free hand SQL as the main Data Providers

. Created the reports using Business Objects features such as Queries,

Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and

Formula's etc.

. Prepared the document explaining how to retrieve the reports from the

repository and how to run the report for first time users.

. Given training to some of our developers and how to develop complex

Reports using Business objects.

. Implemented Web intelligence with Tomcat and Apache Application

Servers.

Environment: Business Objects 6.5 (Data Integrator 6.5, Designer,

Supervisor, Business Objects, WebI, BCA), Oracle 9i, Erwin 4.5, Teradata

V2R3, Webi SDK, Crystal Reports 10, Toad, MS Office, MS Project.

AIM Investments, Houston, TX

Sep'05 -Oct'06

Business Objects Developer

AIM Investments is one of the Nation's largest Investment Companies. This

project carries different products like Global Conventional Debt, Clearance

and Collateral Management etc. Database was maintained in Oracle 9i on

Windows NT. They had a front-end reporting system named as Client Tracking

System. System requirement study was done. New Tables are created in

Oracle, Universe is designed in Business Objects Designer, and Web

intelligence is installed on NT. All sorts of mathematical formulae are

inserted in universe along with deals. Reports are created and exported to

the repository.

Responsibilities:

. Involved in Business Process Analysis, requirement gathering, re-

engineering.

. Designed and developed Business Intelligence application using

Business Objects and Web Intelligence

. Created Universe with 70 Classes, more than 500 objects using

inner/outer and equiv. joins as per requirement.

. Resolved loops by creating aliases and contexts Developed Hierarchies

to support drill down reports Created the reports using Business

Objects functionalities like Queries, Slice and Dice, Drill down,

Cross Tab, Master Detail

. Created complex Objects for easy reporting and for better performance.

. Generated reports using Web Intelligence also.

. Generated Crystal report using Release 10 SQL working with stored

procedures.

. Used the Broadcast Agent to schedule and broadcast timely reports

depending on the user profile.

. Tested the Universe structure to ensure the database is properly

updated.

. Involved in testing the Universe, Business Objects installation.

. Created reports for various portfolios using various data providers.

. Plan, coordinate and execute Business Objects deployment for End

users.

. End User community training in basic and advanced reporting,

configured with InfoView.

. Documentation of Universes and Business Objects Reports.

. Worked with ZABO.

Environment: Business Objects 5.x, ZABO, Designer, Webi 2.7, Supervisor,

Oracle9i, SQL, PL/SQL, DB2 8.0, MS Office Suite, MS Project, MS Visio,

Rational Rose, Clear Case, Clear Quest, Toad, Windows NT.

Comerica Financials, Detroit, MI

Oct'04 - Sep'05

Business Objects Programmer Analyst

Comerica selected Business Objects Budgeting and Business Objects Plan

Reporting because they offered extremely robust and flexible capabilities

through an intuitive and powerful Excel-based interface. With Business

Objects, Comerica now has the tools to easily access, analyze, and report

on information throughout the organization.

Responsibilities:

. Requirement collection and analysis from the End Users.

. Developed complex queries using different data providers in the same

report

. Exported the Business Objects reports to WEBI to be viewed by all

users on the intranet

. Created and published reports through Web Intelligence.

. Customized Web Intelligence front page by using webi SDK.

. Scheduled Reports using Broadcast Agent.

. Published reports to users to their e-mail addresses by using

Broadcast Agent Publisher.

. Worked with supervisor module in creating users and users groups for

different areas and setting privileges to them.

. Used PL/SQL scripts to import data.

. Trained the users in Business Objects and in using the newly developed

universe and in Report writing by Using Query Panel and Slice & Dice

etc.

Environment: Business Objects 5.1, SQL, PL/SQL, Erwin, Informatica 5.1,

SQL*Loader, UNIX Shell Script, Windows 2000/NT, ORACLE 8i, PL/SQL, SQL

Enterprise Manager

Contact this candidate