Resume of Senior BI Architect

Title
Senior BI Architect

Primary Skills
OLAP, Data Warehousing, Business Obejcts, SQL, PL/SQL, T-SQL

Location
US-CA-san jose (will consider relocating)

Posted
Feb-18-08


Background Summary
* Close to 8 years of IT experience in design, development and implementation of Business Intelligence

solutions and in all phases of Software Development Life Cycle.
* Close to 4 years of experience in OLAP tools providing basic to complex Business Intelligence solutions

using Business Objects XI R2/6.5/6.1/5.1.X, WebIntelligence XI/6.0/2.X, Crystal Reports XI R1/R2.
* Highly skilled in Business intelligence system study, design, development and implementation of applications

and Client/Server technologies.
* Extensive database experience using Oracle 9i/8i/7.x, MS SQL Server 2005/2000, DB2 UDB, MS Access, SQL,

PL/SQL, SQL *Plus, SQL Bulk Loader, TOAD 7.6, BCP Utility.
* Highly proficient in Oracle PL/SQL including writing queries, stored procedures, functions and triggers.
* Thorough knowledge of Ralph Kimball's Data Modeling concepts including Dimensional Modeling, Star and

Snowflake schema, Slowly Changing Dimensions (Type1, Type2, and Type3) and Surrogate keys.
* Expertise includes Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data import,

Data export.
* Developed Data Warehouse/Data Mart systems using various RDBMS (Oracle, MS-SQL Server, DB2 UDB) and ETL

tools (Informatica PowerCenter/PowerMart 6.2/5.1).
* Experienced in using modeling tools such as ERwin, and system specifications using UML.

Tools and Technologies
BI Tools - Business Objects XI R2/6.X/5.X, WebIntelligence 6.0/2.X, Broadcast Agent, Crystal Reports XI R1/R2
Data Bases - Oracle 9i/8i/7.x, MS SQL Server 2005/2000/7.0, UDB DB2, MS-Access, Informix Dynamic Server (IDS) 9.30
DB Tools - SQL *Plus, SQL Bulk Loader, TOAD 7.6, BCP Utility
Development Languages - SQL, PL/SQL, T-SQL, J2SE 1.4.2, JSP 1.2, RMI, Swing (JFC), CGI-Perl 5.0, JavaScript 1.2, XML

1.0, Unix Shell Scripting
ETL Tool - Informatica PowerCenter/PowerMart 6.2/5.1
Operating Systems - Unix (Solaris 5.9), HP Unix 11.0, Linux (Suse 9.0, Redhat 7.0), Windows NT/XP/2000
Data Modeling Tools - ERwin 4.1, Embarcadero ER/Studio, UML 2.0, MS Visio
Process Tools - Rational's Requisite Pro, Borland's CaliberRM
Workflow tools - MS-Project, MS-Excel, MS-VISIO, MS-PowerPoint, MS-Word
Methodologies - Ralph Kimball's Data modeling, Star and Snowflake Schema Modeling, OOAD

Professional Experience
Sr Analytics Architect, TrueDemand Software, Los Gatos, CA - Aug, 06 - till date

TrueDemand BIM Project

TrueDemand Software is a pioneer in the development of new supply chain applications. These applications take

advantage of both RFID and non-RFID data to help solve supply chain planning and execution problems.

This project is an effort to provide different predictive solutions such as Integrated Demand and Replenishment

solutions, New Product Introduction solutions, Promotions Management and Proactive Analytics.

Responsibilities
* Led a group of six to eight developers in architecting and building the EDW for the reporting and analytics

solutions.
* Conducted daily status and weekly reporting meetings of the group and update the senior management on the

progress on timely basis.
* Wrote Store Procedures using Transact SQL to populate the fact tables and dimension tables.
* The Stored Procedures support both daily and historical data loading to the fact tables.
* Utilized SQL Server native utility -- BCP utility for bulk loading.
* Embedded the BCP commands in the Stored Procedure and invoked the commands from the Stored Procedure using

the sp_cmdshell.
* As a senior architect, designed the data models to meet the requirements of each report.
* Worked extensively on Central Management console and Infoview to perform Business Objects Server side

Administrator role to manage users, objects, security both user level and object level.
* Set up single sign on functionality with LDAP.
* Created different CMS clusters and also different server groups to gain performance.
* Designed multiple universes to meet the report requirements.
* Created various detailed and summary WebI reports.
* Implemented various advanced features of WebI such as Custom Scope of Analysis, Linking Reports, Linking

Multiple Data Providers, Merge Dimensions, Complex Charts etc.
* Integrated the key dimensions such as Product, Location and Time in Universe.
* Created contexts to get the data from different fact tables that use the same dimensions.
* Used drill down functionality such as Drill Up, Drill Down and Drill Across to show the data at different

Hierarchical levels.
* Created complex condition objects to filter the data based on report requirements.
Environment: Business Objects XI R2, Designer XI R2, WebI XI R2, MS SQL Server 2005/2000, Windows Server 2003.

Principal Consultant, Infostep Inc., San Jose, CA - Jan, 06 - Aug, 06

Projects

Business Objects Technical Support, Business Objects, San Jose

Business Objects is the world's leading BI software company. Its software helps organizations gain better insight

into their business, improving Decision-making and enterprise performance.

Project deals with the various issues faced in installing, configuration, customization and general functionality of

the Business Objects suite of products at the client location.
Responsibilities
* As a principal consultant, led a team of 10 people to troubleshooting client side installation and

configuration problems.
* Identifying the defects in the product and escalating it appropriately for a fix.
* Providing workarounds for users for issues faced.
* Giving high level training to the customers for better understanding of the product.
* Replicating the client side issues using VM Ware and thus provide solution/workaround.
Environment: JSP, Servlets, Unix, IBM WAS 5.x, BEA Weblogic 8.1, Business Objects XI/ XI R2, Crystal Reports XI,

Tomcat, IIS 6.0, VM Ware, Oracle 9i, MySQL 5.0

TrueDemand Predictive Solutions System, TrueDemand Software, Los Gatos, CA

TrueDemand Software is a pioneer in the development of new supply chain applications. These applications take

advantage of both RFID and non-RFID data to help solve supply chain planning and execution problems.

This project is an effort to provide different predictive solutions such as Integrated Demand and Replenishment

solutions, New Product Introduction solutions, Promotions Management and Proactive Analytics.
Responsibilities
* Created various detailed and summary WebI reports such as In-Stock by Product to look at the Current Days of

Inventory and also the Problem Locations that have Current Days of Inventory less than the Specified Value, Read

Accuracy by Product to look at the percentage of reads of each item at each location (Supplier, Retail and Store)

for each product, Read Accuracy by Location which is the percentage reads for each location, Store Activity by

Product and Location etc.
* Participated in designing the data models to meet the requirements of each report.
* Helped the team to build an integrated Universe instead of having separate universe for each report.
* Helped the team to implement various advanced features of WebI such as Custom Scope of Analysis, Linking

Reports, Linking Multiple Data Providers, Merge Dimensions, Complex Charts etc.
* Integrated the key dimensions such as Product, Location and Time in Universe.
* Created contexts to get the data from different fact tables that uses the same dimensions.
* Used drill down functionality such as Drill Up, Drill Down and Drill Across to show the data at different

Hierarchical levels.
* Created complex condition objects to filter the data based on report requirements.
Environment: Business Objects XI R2, Designer XI R2, WebI XI R2, MS SQL Server 2000, Windows Server 2003.

ICE Reporting for Customer Support Group and CS Strategic Dashboard Project, Business Objects,
Vancouver, Canada

Business Objects is a global business intelligence (BI) software company, with more than 35,000 customers including

over 80 percent of the Fortune 500 -- and a network of more 3,000 partners and resellers.

ICE Reporting Project is to providing meaningful information, analysis and process definition, on all data that

impacts Customer Support, while promoting a common measurement strategy based on the Balanced Scorecard Methodology

- a management system that enables organizations to clarify their vision and strategy and translate them into

action. The system uses multiple data sources such as the global CRM system with all world-wide cases in one

database, Global Profiling System (GPS) containing all teams/managers/engineers and IVR system handling majority of

call & activity tracking.

Customer Support Strategic Dashboard Project is to build a Corporate Dashboard to help the Customer Support Managers

to analyze the performance of the Technical Support Engineer based on various Key Performance Metrics at World Wide

and also at the different regional level. The system uses a SQL server Data Mart which contains weekly, monthly and

quarterly data.
Responsibilities
ICE reporting project
* Created various Team and Engineer Operational Reports providing both detailed and summarized data on

Operational Activities using Crystal Reports XIR2.
* Created various ad-hoc searching reports driven by parameters like find Customer by Name, Agreement, Region,

Cases by Customer etc.
* Extensively used subreports in the reports to coordinate data that cannot otherwise be linked, to present

different views of the same data within a single report and to perform one-to-many lookups from a field that is not

indexed on the lookup field.
* Created many custom functions to be shared and reused by the report designers.
* Used Record selection functionality to restrict the records from the Database.
* Used drill down functionality on data to show the data behind the individual groups.
* Participated in testing and generating Business Objects Reports using the Case Universe.
* Worked extensively on Content Management using Central Management Console and Infoview.
* Participated in scheduling the reports using Central Management Console and Infoview.
Customer Support Strategic Dashboard Project
* Designed and developed the metric universe for the Dashboard project.
* Incorporated weekly, monthly and quarterly measures in the metrics universe.
* Created complex condition objects to retrieve data based on different time periods.
* Used Dashboard Manager to create analytics (Interactive Trend Metrics, Speedometer) based on different Key

Metrics such as Responsiveness Index, Engineer Productivity, Average Days to Close etc.
* Created various detailed and summary adhoc/canned WebI reports for the business users.
* Created scheduler to refresh the Dashboard Metrics.
* Managed and customized the contents in the Customer Support Strategic Dashboard using Dashboard Builder.
Environment: Business Objects XI R2, Designer, WebI, Dashboard Manager, Crystal Reports XI R2, Oracle 9i, Windows

NT, PeopleSoft 8.0, MS SQL Server 10.

Programmer Analyst, Malla Systems DBA eFulgent, Phoenix, AZ - Jan, 04 - Jan, 06

Projects

Commercial Mortgage Group Dashboard Project, Wells Fargo, San Francisco, CA

Wells Fargo is a diversified financial services company providing banking, insurance, investments, mortgage and

consumer finance for more than 23 million customers across North America and elsewhere internationally. Wells Fargo

has $453 billion in assets ranking fifth in assets and fourth in market value of stock among its peers as of

September 30, 2005.

This project is Phase 2 of the Commercial Mortgage Group (CMG) Executive Dashboard Project. This project is of a

larger Dashboard effort that includes building an underlying Data Mart and multiple interfaces to back-end Systems

of Record.
Responsibilities
* Designed and developed Business Objects universes (Reporting Universe, Metrics Universe and Alert Universe)

and reports for our Executives. The analytical system information access will be primarily through the web, allowing

access from anywhere, with appropriate security credentials.
* Created classes, objects, and conditions at Universe level and resolved loop using contexts and classes.
* Used @functions such as @Prompt, @Select, @Variable, and @Where extensively.
* Created and managed repository domains and categories using Supervisor.
* Created and managed users, groups, and security using Supervisor.
* Created customized web reports per requirement of client users such as LOB reports, Originator reports,

Alert reports with drill down capabilities which is possible by aggregating data and rolling it up from its lowest

level of granularity.
* Organized data in reports by using filters, ordering, ranking, and highlighting data.
* Used calculations, formulas, local variables, and functions in reports.
* Worked extensively with Application Foundation and Dashboard Manager.
* Created various Metrics to be used in Analytics.
* Generated different rules and Alerts for the executives.
* Created various Analytics such as Interactive Trend Metrics, Speedometer and Metric Analytics.
* Participated in deployment from Dev to UAT and then from UAT to PRD.
* Worked on cleaning the current universe in terms of naming convention and designing the better security.
* Created interactive and visual Dashboard using advanced statistical templates such as Pareto charts,

geographical maps, speedometers to display meaningful information about the state of organization's
performance.
Environment: Business Objects 6.5.1, WebIntelligence 6.5.1(Reporter, InfoView), Dashboard Manager, Application

Foundation, PL/SQL, Oracle 9i, HP Unix 11.0, Windows NT, Web Logic, Web Server.



Integrated Credit Reporting System, Union Bank of California, San Francisco, CA

Union Bank of California is one of the largest financial Institutions in the west coast with net worth of $51.2

billion dollars in assets.

Integrated Credit Reporting System is a bank wide Business Objects decision support application targeted to the

Senior Management for sound decision making and forecasting. This system utilizes Business Objects to query against

the credit reporting system on a daily basis. Many of the reports use extensive drilling and active refreshes to

provide the user with dynamic analysis capabilities. The ICRS Business Objects installation includes over 2300

Business Objects users deployed over multiple states.
Responsibilities
* Involved in gathering requirements from business end users and subsequently translate it into functional

specifications.
* Involved in design and development of the complete Decision Support System to be used to create reports

using Business Objects.
* Leveraged the Business Objects Universe (Semantic Layer) to make measures aggregate aware. These changes

substantially improved query performance.
* Generated various Business Objects reports such as Measure Reports, Change Reports, Highlight Reports using

Slice and Dice, Drill Down, Cross Tab, Master/Detail and complex Formulas etc.
* Created customized web reports per requirement of client and scheduled reports using Business Objects

Broadcast Agent.
* Worked extensively on PL/SQL and generated reports using Stored Procedures, free-hand SQL from Oracle

database.
* Involved in full life cycle design and development of Business Objects Reporting Application.
* Created, modified and published reports using WebI.
* Created classes, objects and filters at Universe level and resolved loop using contexts and aliases.
* Worked on cleaning the current universe in terms of naming convention and designing the better security.
* Deployed personalized Average Profitability Dashboards for the Credit Portfolio managers that provided quick

and easy visibility to their business activities.
* Maintained Visual Basic add-in scripts that provide a unique user interface for the business object reports.

The VB user interface retrieves documents, edits the data providers, and automatically fills in required prompts.
Environment: Business Objects 6.1/XI, Broadcast Agent Publisher, WebIntelligence 2.7(Reporter, InfoView), Dashboard

Manager, Informatica 6.2, PL/SQL, Oracle 9i, HP Unix 11.0, Windows NT.

Insurance BI Solution system, Aetna Healthcare Inc, Bluebell, PA

Aetna Healthcare Inc is one of the leading providers of the Health care Insurance.

Aetna e-drive is a suite of Data Warehouse and BI solutions incorporating electronic bill presentment, payment,

claim submission, claim payment enquiry and claim status enquiry systems for healthcare providers and insurance

partners. I was involved creating multiple Universes using the Designer on third party databases so that our

analysts and customers can prepare relevant reports using Business Objects and WebI portal.
Responsibilities
* Interacted with functional teams and users for finalizing the data models and reporting structures.
* Designed and developed Business Objects universes and reports for our VPs and customers.
* Gathered, analyzed, and documented business requirements.
* Acted as a liaison between business users and developers.
* Created the Repository, Users, User Groups and assigned privileges to the users using Supervisor.
* Resolved the loops, cardinalities, contexts and checked the integrity of the Universes.
* Exported the universe to the Repository to make resources available to the users.
* Created reports using universe, stored procedures, free-hand SQL as Data providers and writing the complex

queries including Sub Queries, Unions, Intersect.
* Formatted the reports to the users' requirements using all the functionalities in Business Objects like

Slice and Dice, Drill Down, @Functions and Formulas etc.
* Created Master/Detail and Cross Tab reports to view the data in an analyzed way.
* Exported the reports to the Broadcast Agent Server for scheduling.
* Created Graphical representation of reports such as Bar charts, Pie charts etc as per the End user
requirements.
* Developed full client and WebI reports.
* Created Net Sales Dashboard and chart as a derivative of regional sales metric tree to analyze current

business conditions, trends or anomalies at a glance.
Environment: Oracle 8.1.7, PL/SQL, Business Objects 5.1.5, WebIntelligence 2.6.2, Designer, Supervisor, Business

Miner, Sun Solaris, Windows NT/XP.

Graduate Teaching Fellow, The Knight Library, University of Oregon, Eugene, OR - Sep, 01 - Dec, 03

e-Asia Project

The e-Asia project of the Knight Library of the University of Oregon strives to contribute to the research and

scholarship of East Asia by building a collection of digitized e-books and a database of full text web resources.

The e-Asia project is based largely on resources held at the University of Oregon Library.
Responsibilities
* Designed and developed a complex database system to maintain a large bibliography of books and catalogs

using data modeling tool ERWin 3.5 and Relational Database SQL Server 7.0.
* Developed web applications using ColdFusion MX 6.1 in a Windows 2000 environment.
* Wrote PL/SQL query, Procedure, Cursor and triggers for implementing business rules as per client requirement

and also for maintaining Referential integrity.
* Performed DBA work like database tuning, auditing, managing rollback, tablespaces and indexing etc.
* Performed backup and recovery of database in case of database crash.
* Analyzed the system for providing customer specific requirements.
* Developed test plan to verify correct implementation of user requirements.
* Performed tests according to the test plan.
Environment: Windows NT, ERWin 3.5, SQL Server 7.0, ColdFusion MX 6.1.

Oracle Developer, State Bank of India, Guwahati, India. - May, 99 - July, 01

Integrated Banking Maintenance System

Developed an Integrated Banking Maintenance System. This system consisted of New Depositor, Interest Warrant,

Maturity, Premature & Renewal, and Enquire modules. The system was capable of calculating the annual percentage

rate, interest period, and amount due on maturity date. Banking maintenance system generated fixed deposit receipts,

duplicate fixed deposit receipts, interest warrants, duplicate interest warrants, premature withdraw receipts,

maturity receipts and monthly statements.
Responsibilities
* Studied the project requirement and designed the project.
* Created tables, views, synonyms and sequences.
* Created Database Triggers, Stored Procedure, Functions and Packages.
* Optimized queries using rule based & cost based approach.
* Used SQL *Loader for data loading.
* Modified existing forms, reports, and graphs as per the enhancement.
* Tested all the new and modified program units.
* Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the forms and

reports.
Environment: Oracle 7.3, Developer 2000 (Forms 4.5, Reports 2.5), Windows 95 and Unix.

Education
* M.S., Computer Information Science, University of Oregon, Eugene, OR.
* M.Tech., Mechanical Engineering, Indian Institute of Technology, Guwahati, India.

Awards/ Professional Affiliations
* Life member of the Indian Society for Technical Education, ISTE.
* Awarded National Merit Scholarship from class XI to B Tech.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-CA-san jose »
View all resumes in US-CA »

View other Senior BI Architect resumes