Expertise in SAS and Business Objects suite of products. More than 8 project
experiences of business intelligence and Business Analyst experience.
More than 4 years of sales experience.
? Data Integrator expert.
? Has extensively worked on dashboards.
? Has exposure to Crystal Xcelsius.
? More than 7 years of experience in developing Business Intelligence solutions for clients
in the Retail Sales, Finance, Healthcare and Insurance industries. Known to be a top
end consultant who meets the client requirements for cost and delivery. ? Involved in training end users, business users and customers on how to create modify and
interpret BO reports and WEBI reports.
? Extensive knowledge in Business Objects XI/6.x. This includes experience with
Designer, Reporter, OLAP reporting tools. Good experience at generating Ad-Hoc
Reports as per client requirements.
? Have expertise in creating complex reports by linking data from multiple sources. Have
also got expertise in functionalities for BO like Slice and Dice, Drill Down, Master Detail
? Working Knowledge of Web Intelligence, Info View and Dashboard Manager.
? Experienced in Extracting data from Star Schema and snowflake schema. ? Strong skills in interfacing Business objects with Databases like Oracle, SQL Server and
? Assist and manage the design, prototyping, development, testing, and production support
of multiple universes.
? Expertise in the use of ETL tools. Worked on several transformations such as Filter
Transformations, Joiner Transformations, Rank Transformations, Stored
Procedure Transformations, and Expression Transformations in Informatica. ? Expertise in performance tuning for mappings dataflows and workflows in Data Integrator.
? Good knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling,
ETL Processes, Data mining, Data audits and Web reporting features of data
? Data Modeling experience using ERwin.
? SAS9 certified Consultant.
? Expert in Data Mining techniques.
? Good understanding of regression and forecasting techniques.
? Extensively worked with BASE/SAS, SAS/ODS, SAS/GRAPH, SAS/STAT,SAS/ETS,
? Understand how to load type-1, type- dimensions, fact and aggregate tables using SAS
? Good exposure to SAS/OLAP.
? Good understanding of SAS/Warehouse Management system.
? Knowledge of SAS/Macros.
OLAP Business Objects XI/6.x/5.x, Web Intelligence 6.1a/2.7x/2.6,
DATABASES Oracle 8i/9i, MS SQL 7.0/2000, MS-Access 97/2000
DATA MODELING Erwin 4.1/4.0/3.5
OPERATING Windows 2X/NT/9X SYSTEMS
Informatica PowerCenter 6.2/5.1.2/1.7, PowerMart 6.0/5.2/4.7.2, Data ETL Tools Integrator XI/184.108.40.206, SAS Data Integration Studio 3.4
ORACLE TOAD, SQL*LOADER UTILITIES
LANGUAGES SQL, PL/SQL
STATISTICAL SAS TOOLS
Duration: September 2008- present
Environment: Data Integrator, Business Objects XI(Business Objects Edge series)
Project description :the client is making a data warehouse as part of the reporting
solution using Business Objects.
? As a Business Objects consultant, do an in depth analysis for the universes and
the ETL processes for the client. Our task was to align the processes to optimize
the overall query performance. For the ETL processes we needed to carry out an
overview of the tasks that were done.
? Do the initial load of various dimensions and fact tables.
Duration: August 2008-present
Environment: SAS, Excel, Data Integration Studio
Project description: The client needs to import the data from Excel, do an analysis of the
same and then export it in the xml format to the SAS meta data server.
As a SAS developer I am responsible for the whole process of ETL, meta data analysis of
data from Excel to SAS. I am also coding business logic within the Data Integration studio.
After the generation of the SAS targets, we are exporting them into Xml format for us to
be able to communicate with the Metadata Server.
Client : Targeted Genetics, Seattle, Washington
Duration: May 2008-June 2008
Environment: SAS, SQL Server
Project description: The client needs to make a decision on whether to purchase SAS or
SQL Server. The consultant was involved in helping the client make the call.
Role:As a senior analyst the role of the consultant was as following:
? Talk with the senior managers about their reporting requirements
? Develop an user matrix for the reporting features and how those reporting
features shall be addressed by various reporting tools.
? Develop a consolidated decision matrix.
Duration: April 2008-May 2008
Environment: Data Integrator XI, Business Objects XI
Project description: The client is working in the field of medical claims and wishes to make
a data warehouse and data marts for reporting purposes
Role: As an ETL developer, I was involved in the following:
? Setting up of Data Integrator environment
? Initial load of facts and dimensions As a report developer I was involved in the following:
? Making up of 2 universes
? Designing prototype reports for the client.
Client: Freshdirect, New York
Duration: December 2007-March 2008
Environment: Data Integrator XI, Oracle 9i
The project entailed translating the source system into a data ware house using the “data
vault” methodology. The Data Vault methodology involves making hubs, links and satellites.
Role: As an ETL developer the following were the tasks assigned to myself.
? Make the initial load and incremental load data flows for the load of hubs, links
? Help in scheduling of jobs and solving any errors that may come during the
process of execution.
? Loading of large link and satellite tables using extensive SQL coding. Creation of
artificial partition in the database using the “row_id” function within Oracle.
All in all the developer populated more than 1000 hubs, links and satellites during the
project. The developer was involved in more than 80% of the data flow creation in 2 of the
4 months of his project execution.
Client : IMC Auto Parts, Los Angeles
Duration: June 2007- December 2007
Environment: Business Objects XI, Data Integrator XI, SQL Server 2005, I-series
This task involves making a sales data mart from the IMC source data from I-series. Thereafter a
daily sales report(a highly complex report) along with a set of 10 more reports were made as part
of the project.
? Understood the reporting requirements by analyzing each report the client had given to
? Designed a de normalized data mart for sales reporting (including conformed
? Designed two universes with features including aggregate awareness. Also used derived
tables for ease of querying.
? Designed ETL for the initial and incremental load of dimensions, fact and aggregates.
? Designed a complex report that had more than 120 variables.
? Worked on 8 other reports as part of the project.
Client : East Texas Medical Center(Tyler, Texas). This partnership is being carried out in
partnership between Fusion Consulting(Gold Partner of Business Objects) and
Wayquest(Gold partner of Business Objects)
Duration: March 2007- June 2007
Environment: Business Objects XI, Data Integrator XI, SQL Server 20065
This task involves developing a data mart for the general ledger of ETMC. The candidate has
been involved in developing a prototype data mart for ETMC in SQL Server 2005.
? Understood the reporting requirements by analyzing each report the client had given to
? Bulk inserted the AS/400 tables into SQL Server.
? Designed normalized entities and populated them using hard coded SQL.
? Developed dimensions and populated fact and aggregates for a sub set of the companies.
All the above steps were done by hard coding in SQL server.
? Developed data flows for populating the dimensions and the fact. Developed a
consolidated income statement for all 33 companies. Drill down, drill through, group by
parameters were developed and incorporated within the data mart.
Client: Conagra Foods, Omaha Nebraska
Duration : February 2007-March 2007
Environment : Business Objects 6.1, Microsoft Access, Oracle 9i
The task involves working through the SAP(BW) materials hierarchy and the Wilkies system
hierarchy and making a mapping logic between the two. The tasks also involve changing some
Business Objects reports and universes. The task which had been allocated a time slot for 3
months was finished in 3 weeks.
? Analysis of the Business Objects universe.
? Extensive analysis of the data to check where are the gaps in terms of the reporting
? Understanding of the SAP-BW product hierarchy and the Wilkies product hierarchy.
? Modeling of the product relationships using Microsoft Visio.
? Data analysis done using Excel and Microsoft Access.
? Working through the universe and removing duplicate relationships.
Client: WAMU, Seattle, WA
Duration: November 2006 –February 2007
Environment: Business Objects XI, SQL Server 2005, Oracle 9i
The tasks involved were the development of a prototype for the client for the Debit transactions.
Thereafter a first cut of the final product has been made along with certain target reports. The
developer is in the process of making a metric universe, making metrics, analytics and
customizing dashboards. All in all in the first 8 weeks the developer was involved in the
production of a prototype and first cut of the final product.
? Development of the star schema and the required fact and dimension tables.
? ETL of the dimension and the fact tables using hard coded SQL. The SQL generation
includes but not limited to the production of the date dimension and 4 other dimensions.
Hereafter the fact was populated with the help of outer joins
? The aggregations were done in the fact. Extensive use was made of the case, Open
query functionality while producing the fact.
? Production of the basic reports to meet the client requirements.
? Making a metric universe and production of the required metrics. Usage of those metrics
within various analytics specified by the client.
Client: Mayo Clinic, Rochestor, MN
Duration: February 2006- October 2006
Environment: Business Objects XI, Data Integrator 11.5.1, SQL Server 2000, DB2 UDB 8.x
This prototype project involves developing a prototype for the client for the appointment system.
The consultant has been involved in the logical modeling sessions, source mapping and
requirement gathering sessions. Through this process the consultant has developed a good
understanding of the appointment process. All the above steps have been conducted using
CIBER’s standard methodology.
? ETL for the dimension, fact tables and aggregate tables using Data Integrator.
? ETL of the staging area tables. The data mart was populated directly from the staging
area for the purpose of the prototype.
? Conducting training sessions with the client to explain the process and the intricacies of
Data Integrator and the universe creation process.
? Development of a semantic layer and making basic reports using WEBI.
? Optimizing the semantic layer for ease of use by the end users.
? Making of metric universes and declaring classes and objects within the same.
? Making metrics as per the client requirements.
? Developing jobs for incremental load, type-1 and type-2 dimensions, error tracking and
job logging within Data Integrator. This was done for Phase-2 of the project. The
candidate developed a template that could be replicated for incremental and full upload
jobs with/without input timestamps. Extensively used table comparison, history preserving,
map, key generation, query and validation transforms for the same.
? Developed the incremental load strategy without the use of MAP_CDC transform.
? Populated tables in the data warehouse using the incremental load strategy.
? Investigated and implemented various new features of Data Integrator such as Metadata
Exchange, Meta data reports, audit functionality and debugger.
? Worked with Universe Builder to expedite the universe development. st? Have done an initial load of 44 tables for data warehouse and data mart for the 1 phase
of the project within a short period 3 weeks.
Client: AFLAC, Columbus, GA
Duration: November 2005-February 2006
Environment: Business Objects 6.5.1, Data Integrator 220.127.116.11, ERwin, Visio, MS SQL Server
The project involved generating reports from the relational databases that were used to capture
data for e-mails and website access. In due course of the task the consultant was required to
understand the end user requirements and carry out the appropriate tasks.
? Understand the end user reporting requirements. In this task extensive co-ordination with
the Business Analysts was done.
? A comprehensive data model based on star schema from the relational model was
developed. The consultant was involved in design of the dimension, fact and the
? From the relational tables the dimension, fact and the aggregate tables were populated
using Data Integrator. During the course of this task, extensive parsing of the data was
done since the data in one of the data sources was in a highly de normalized form.
? Extensively used Table Comparison, Key generation, Look up, Lookup_ext, index and
substring functions in Data Integrator.
? Initialization scripts for the Full and incremental load were written.
? Universe based on the data mart was developed and the objects used for reporting were
? Documentation of the whole process was done.
Client: Cingular Wireless
Duration: August 2005-October 2005
Environment: Business Objects 6.5, Oracle 9i, TOAD, Windows NT, PL/SQL, Teradata
The project involves working on developing and modifying the free hand SQL reports for the
client’s inventory, accounts payable, accounts receivable and shipping reporting systems. Many reports that were worked upon had data coming from multiple data providers, viz. Oracle,
Compass and WMS. The project entailed adding the location information and checking the
reports for correctness and validity.
? Understanding the intricacies of the schema for Inventory, Accounts Payable and
Purchase order. Understanding the joins between various tables and the problems and
issues that may arise thereof.
? Understanding the SQL code and flow of data in each of the reports.
? Identifying which data providers in a particular report need to be modified in a particular
? Developing strategies to work with Oracle 9i, Compass queries and WMS queries.
Applying the necessary modifications in each report. Changing the original SQL code
? Linking the multiple data providers to give the necessary output.
? Developing documentation to improve upon the present reports to better serve the client
? Testing of the modified reports to check whether they give the required output.
? Documenting the improvements possible in present reports.
Client: George Washington University, Washington D.C.
Duration: June 2003- June 2005
Environment: BASE SAS, SAS/GRAPH, SAS/STAT, SAS V8.2, Enterprise Miner
The projects involved working with Customer relationship data and understanding the
effectiveness of the mailing campaigns. On another project we looked at the prevalence of the
disease codes across United States. I also worked on a forecasting assignment involving Coke
bottle sales and the sale seasonality.
? Understand the source data from Excel using pivot tables.
? Use the Enterprise Miner to perform regression, decision trees and neural network
? Use Base/SAS to perform forecasting analysis
? Extensive use of PROC MEANS, PROC SUMMARY, PROC PRINT, PROC
? Extensive use of SAS/ODS to convert reports from html to pdf.
? Extensive use of functions within SAS such as SUBSTR, INDEX.
? Worked with importing flat files in various formats into SAS datasets
? Extensive use of DATA_NULL_ for debugging.
? Understand how to load type-1, type-2 dimensions, fact tables and aggregates tables
using SAS DI.Understood how to do an initial and incremental load using SAS.
? Developed an understanding of SAS/ Warehouse Management to develop drill downs,
? Developed basic understanding of SAS/EIS to develop various kinds of reports.
? Used @Risk software to understand the risk profile for various clients.
Other clients include Riggs Bank, Calvert Foundation, Citibank and University of Maryland and
Sales Manager, Philips India Limited.
Was involved in commercial sales of lighting fixtures in India for a period of 4 years from 1996-
2000. Coordinated and worked with a sales force of more than 10 people in metros such as Delhi
? Masters in Business Administration (MBA) from George Washington University
[Specialization in Business Intelligence and Supply Chain Management].
? Bachelor’s in Electronics Engineering.