Manager Data
Resume:
Ganesh Sivakumar
Datawarehouse
Architect/Business Intelligence Manager
Phone: (203-427-
5148) email: ********@*****.***
Certification
. Business Objects Certified Professional (BOCP) - SA201 - 95/100
. Business Objects Certified Professional (BOCP) - SA301 - 94/100
. Business Objects Certified Professional (BOCP) - SA401 - 100/100
Achievements
. Project Management and Six Sigma Experience
. Integrated SAP BW 7.0 version and Business Objects XIR3 in portal
. Datawarehouse Architect/Business Intelligence Lead
. Migration of Business Objects 5.1.2 & 6.5.1 to XI 3.1
. Technically Trained Cognos/Microstrategy Specialist
. Technically Trained in XIR2 & 3.1 Server Administration and
Architecture
. Technically Trained in Datastage Parallel and Server modules
. Business Objects Application Foundation Certification
. Rewarded as the years Best Contractor in "The Hartford"
. Implementation of Business Objects Live Office and Intelligent
Question in Pfizer
Summary
. Seasoned Data warehouse professional with versatile experience in
multiple BI tools.
. Proficient in Central Management Console (CMC), Desktop Intelligence,
Web Intelligence, Dashboard Manager, Performance Manager, Xcelsius
2008, Import Wizard, Publisher and Designer of Business Objects XI 3.1
and Crystal Reports 2008.
. Installation and Configuration of Business Objects XI R2 & XI 3.1
Servers
. Developed crystal Xcelsius portfolio dashboard's for UBS Global Asset
Management
. Created CTI & Yardi reports for UBS Global Real Estate
. Deployed Clarity reporting environment for United Health Group
. Implemented Data Federator and designed universe against data
federator as a source.
. Mentoring Mergers, Integration Business Intelligence Projects for
Healthcare Industry.
. Expert in Mentoring Operation Excellence Six Sigma Projects.
. Migration of Business Objects 5.1.2 & 6.5.1 to XIR2
. Datastage Administration experience with Designer, Manager, Director
. Experience in working with ETL tool - Datastage parallel and server
modules.
. Involved in determining the data needed to address business user's
analytical requirements and design data models to support their
analysis
. Translated business requirements into data mart design and developed
ETL logic based on these requirements using DataStage 7.5
. Designed Configuration File and used Parallel Extender (DataStage XE)
for splitting the data into subsets and to load data, and resource
optimization to achieve maximum job performance
. Developed job control routines for batch processing in DataStage BASIC
. Involved in performance tuning of the ETL process and performed the
data warehouse testing
. Business Objects architecture design included the Business Objects
Universe and Reporting Application Design.
. Define multi-tier Business Objects architecture capable of supporting
all existing Data warehousing.
. Develop test-driven development (TDD) strategy guiding use of the
testing Unit.
. Versatile in Performance Management Tools such as Application
Foundation. The versatility is garnered by creating Dashboards and
Scorecards using Dashboard Manager and Performance Manager Modules.
. Proficient in design, development, deployment and administration of
Business Objects Supervisor, Designer, Business Objects (Reporting),
Web Intelligence, ZABO, Broadcast Agent, Console, Business Objects
(Full Client) SDK, Designer SDK etc.
. Extensive experience in Study, Analysis, Design, Development,
Implementation, Deployment and maintenance of Data warehouse and
business Intelligence applications.
. Application Foundation Lead and Architect - Role - Installation,
Administration, Development in Application Foundation
. Expertise in building Universes and creating Ad-hoc/Canned Reports
using Business Objects and Web Intelligence. Also experience in
retrieving data using Business Objects Universes, Personal Data Files,
Stored Procedures, VB procedures and Free Handed SQL methods.
. Customized configuration of business Objects - Web Intelligence by
fine tuning and Optimization for good performance.
. Upgrading of Business Objects 5.x to 6.x
. Expertise in Client Server application design using Oracle stored
procedures, Oracle Developer Forms 4.5/5.0/6.0, Oracle Reports
2.5/3.0/6.0 and Oracle Discoverer 3.1.44
. Developed data loading plans to seamlessly automate the data loading
procedures from multiple data sources (Informix, Sybase, MS Access,
FoxPro, dbase, Oracle) into Data Warehouses.
. Have experience in ETL using the Data Integrator 6.5 tool. The
experience is amassed by extracting data for reporting needs from
various databases like Oracle and SQL server.
. Experience in Data Warehousing using ETL tools like Informatica
PowerMart, Informatica PowerCenter, and Oracle Warehouse Builder.
. Experience in Converting 1NF Relational Tables to 2NF Relational Table
and 2NF Relational Table to 3NF (Normal form).
. Participated in JAD (Joint Application Development) sessions as
Architect, Trainer and Developer.
. Worked with strong users based Insurance company.
. Strong working experience on Data Migration applications, directly
responsible for the Extraction, Transformation and Loading of data
from multiple sources into Data Warehouse.
. Database design with Erwin and module design with Designer 2000
. Experienced in the writing of Transact SQL, SQL Sybase Stored
Procedures and PL/SQL code.
. Strong experience in Data Modeling using Dimensional Data Modeling,
Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions
Tables, Physical and Logical Data Modeling, Erwin 3.x/4.0, Oracle
Designer, Sybase Power Designer.
. Extensive experience with database performance evaluation and tuning.
SAP BW Summary
. Functional and Technical expertise in SAP BW and involved in multiple
life cycle SAP BW implementations from the blue print to the go-live
stages
. Extensively worked in the customization and implementation of SAP BW (FI-
CO, SD, CRM, CO-PA, PCA,CCA,OPA and MM modules)
. Experienced with BW-BPS (Business Planning and Simulation) in creating
components like planning area, planning levels, planning applications and
in creating web entry layouts,WIB(Web interface builder) etc.,
. Interacted with business analysts, end users, functional experts and
management to identify and analyze the requirements and developed
necessary reports in SD, CRM and FI/CO modules.
. Performed extensive standard and generic extractions such as LO Cockpit,
LIS, CO-PA,
and FI-SL extractions.
. Expertise in Backend Business warehouse components like Extractors, Data
Sources, Infosources, Info Objects, Update Rules, Transfer Rules, ODS
Objects, Info Cubes, Info Packages, Roles and Authorizations.
. Extensive experience in front-end Business Warehouse Components like
Queries, Calculated Key figures, restricted key figures, Structures,
Variables, Exceptions, Conditions, RRI - Jump queries,BEX designer and
Web Application Designer (WAD)/Templates,VBA etc.
. Evaluated statistical performance and suggested recommendations to BASIS
for optimization. Improved data load process and query performance by
doing compression, aggregates, partitioning.
. Experience as an ABAP Programmer - Enhanced standard Data Sources,
programmed user exits for Data Sources and variables start routines,
customized transfer and Update Rules using ABAP routines.
. Exposure to SAP Best Practices and full life cycle project experience
utilizing the ASAP methodologies
. Experience working on projects encompassing all the phases in the life
cycle of software development including requirements elicitation, design
and analysis, coding and implementation, testing, quality assurance,
documentation, and end-user training
Education
> Masters of Science, New Jersey Institute of Technology, Newark, NJ
> Bachelors of Science, MIT, Anna University
Experience
> 9 Years of Experience in Information Technology
> 7 Years of Intense Experience in Data Warehousing Techniques
> 7 Years of Professional Experience in Reporting tools like Business
Objects, SAP BW, Cognos and Crystal Reports.
> 5 Years of Professional Experience in ETL tools like Datastage,
Informatica, Data Integrator.
> 5 Years of Professional Experience in Data Modeling tools like Erwin,
Oracle Designer.
Technical Skills
Performance Application Foundation (Dashboard Manager, Performance Manager)
Management 6.1(B), 6.5.1, XI R2
Tools:
Reporting and SAP BW 7.0, 3.x, BO (Business Objects) 5.1.x, 6.1(a/b), 6.5.1, XI
Analysis R2, XI 3.1 ;Web Intelligence 2.7, 6.1(a/b), 6.5.1,XI R2 MS-Analysis
Tools: Services, Cognos, Microstrategy, Brio(Hyperion)
ETL Tools: Data Integrator XIR2, Informatica, Datastage
Methodologies: Star Schema design, Snowflake Schema, Relational design.
RDBMS: TeraData, ORACLE 8/9i, MS-SQL Server 2000, Sybase ASIQ 12, DB2,
MS-Access 2003, AS 400
Programming PL/SQL, HTML, XML, Jscript, VB Script and VBA.
Languages:
Environments: IIS 6, Apache Tomcat, Terminal Client Windows 2000 Server/ NT /XP
/98, UNIX, WebLogic
Professional Experience
UBS Global Asset Management, CT
March 08 - Present
Datawarehouse Manager/ Business Intelligence Architect
Environment: Business Objects XI 3.1/XIR2/6.5.1/6.1/6.1.3/5.1x, Application
Foundation XIR2/6.5.1/6.1/6.1a, Windows 2000/NT, Sybase, Teradata, Oracle
8i, MS SQL
Business Objects Modules: CMC, CCM, Desktop Intelligence, Performance
Management, Designer, Supervisor, Full Client, ZABO, Application
Foundation, Set Analyzer, Xcelsius, Data Integrator
Architect Responsibilities:
. Successful Migration of Business Objects 6.5.1 to XI 3.1
. Planning and Installation of Business Objects XI R2
. Install and Configure CMS Cluster on multi CPU machines
. Installation and Configuration of CMS, Connection Server, Page Server,
Cache Server, Report Application Server, Destination Job Server,
Reports job server, Program Job server, Web Intelligence report
server, Web Intelligence job Server, List of Values Job server, Input
File Repository Server and Output File Repository Server.
. Configuration of Auditor Database
. Enable and configuring Email : SMTP server
. Enabled Windows AD user group for external users and LDAP group for
Internal users
. Enabled reports to schedule and notify to email
. Installed IIS as web server
. Used Import wizard to migrate Crystal Reports from Crystal Enterprise
9.0 to XiR2
. Integration of BO enterprise with Windows AD user group to enable
Single Sign on
. Enabled Security settings for each user group.
. Enabled security restrictions at folder level & Category level
. Give Technical Support to Users related to BO Reports Deployment.
. Created reports using Crystal Reports
. Implemented LDAP Authentication on XIR2 SP2 & XI 3.1
. Implemented Data Federator and designed universe against data
federator as a source.
. Business Objects architecture design included the Business Objects
Universe and Reporting Application Design.
. Building Architectural views to analyze the Environment and to do an
Environment Analysis for the Business Intelligence team.
. Manage Business Intelligence Team towards successful analytical
deliverables
. Implemented Crystal Xcelsius dashboards to enhance the portfolio
decision metrics
. Developed crystal Xcelsius 2008 portfolio dashboard's for UBS Global
Asset Management
. Created CTI & Yardi reports for UBS Global Real Estate
Lead Responsibilities:
. Lead three Business Intelligence projects successfully from start till
the post production support and Training.
. Involved in gathering requirements with the Business users,
understanding the business and helping the data modeling team in
designing a data mart/warehouse according to the BI requirements.
. Designed Business Flow and technical flow for all the projects.
. Developed standards for BI processes for the IT department
. Developed report standards in accordance with the user requirement.
. Managed a team of developers to develop an optimal universe as well as
reports.
. Designed the test plans and carried them out efficiently.
. Designed Production deployment plans for each project and carried them
out successfully.
United Health Group, Trumbull, CT Feb 06
- March 08
Business Intelligence Architect & Lead
Environment: Business Objects XIR2/6.5.1/6.1/6.1.3/5.1x, Application
Foundation XIR2/6.5.1/6.1/6.1a, Windows 2000/NT, Sybase, Teradata, Oracle
8i, MS SQL
Business Objects Modules: CMC, CCM, Desktop Intelligence, Performance
Management, Designer, Supervisor, Full Client, ZABO, Application
Foundation, Set Analyzer.
Architect Responsibilities:
. Successful Migration of Business Objects 5.1.2 & 6.5.1 to XIR2
. Implemented Active Directory Authentication on XIR2
. Business Objects architecture design included the Business Objects
Universe and Reporting Application Design.
. Building Architectural views to analyze the Environment and to do an
Environment Analysis for the Business Intelligence team.
. Use of existing corporate methodologies as well as helping to define a
new set of methodologies for the planning/developing phases.
. Used Six Sigma Standards for the Documentation of the procedures.
. Define multi-tier Business Objects architecture capable of supporting
all existing Data warehousing.
. Develop test-driven development (TDD) strategy guiding use of the
testing Unit.
. Specify an effective migration strategy from Business Objects 6.1 to
6.5.1
. Recommend agile methodologies to support Business Objects Environment.
. Propose guidelines for proper use of off-shore development resources.
Migration Responsibilities:
United Health Group has 2 legacy versions of Business Objects 5.1.2 & 6.5.1
that needed to be migrated to Business Objects XIR2.
Business Objects 5.1.2 had all the Classic Datawarehousing business
segments (200 Corporate documents, 15 Universe and 1000 Personal
Documents).
Business Objects 6.5.1 had all the new Analytical Datawarehousing reports
(50 Corporate Documents, 100 Personal Documents and 5 Linked Universe).
Migration Challenges:
. Business Objects 6.5.1 migration was not very complicated it was a
direct migration of all the objects to XIR2 CMS.
. Security model was totally new by leveraging both the 5.1.2 and 6.5.1
security model into a single global security.
. Business Objects 5.1.2 was a challenge from the start since Business
Objects stopped the support from Dec 2003 - I did the migration of
these documents directly from 5.1.2 to XIR2 and with a 80% success
rate
. Issues with Business Objects linked universe while migrating to XIR2
and was successfully migrated in Phase I.
Success Story:
. Phase I of the migration is completed and moving towards the next
milestone.
. Moved from User level security to Object level security in XIR2.
. Single Global Security and Authentication for users from multiple
environments.
. Excellent Architecture and 20% more users with same CPU & Hardware.
. Cost reduction from the single license agreement.
. Converted all the DeskI Reports to WebI reports to have single module
maintenance.
. Reduced the access request tickets from 10 request /day to 1/day.
Lead Responsibilities:
. Lead three Business Intelligence projects successfully from start till
the post production support and Training.
. Involved in gathering requirements with the Business users,
understanding the business and helping the data modeling team in
designing a data mart/warehouse according to the BI requirements.
. Designed Business Flow and technical flow for all the projects.
. Developed standards for BI processes for the IT department
. Developed report standards in accordance with the user requirement.
. Managed a team of developers to develop an optimal universe as well as
reports.
. Designed the test plans and carried them out efficiently.
. Designed Production deployment plans for each project and carried them
out successfully.
. Lead a team of Business Objects developers in a Migration Life cycle
project for United Health Group.
. Implemented Decision Support for all the technical environments in
United Health Group.
. Standardizing the project to be a part of operation excellence (Six
Sigma).
Administrative Responsibilities:
. Creating User and Groups in CMC and maintaining the CMC, CMS and CCM
environments.
. Publishing reports via CMC environments using profiles to all the user
community.
. Supporting the Input file repository and output file repository
environment.
. Administration of Business Objects Enterprise using CMC.
. Involved in Full Business Objects Life Cycle.
. Design, create and Modify required reports and published.
. Data Analysis of reports by doing data matching.
. Constant interaction with the vendor support.
. Design and modify Universes using Designer
. Created database schema.
. Use of Aggregate awareness, Derived Tables and Index Awareness in the
Universe
. Use of Java Platform for creating Reports / Modify Reports.
. Done fiscal refresh of reports in Desktop Intelligence mode and
created reports using Web Intelligence and Desktop Intelligence.
. Creation of Dashboards analytics and Scorecards using Dashboard
Manager for forecasting.
. Created Goals using Performance Manager.
. Designed and Created reports with Crystal Reports XI R2.
. Installation and Configuration of XI R2 Job Server, CMS, Page Server,
Report Application Server (RAS), and Cache Server.
. Given Future Direction to the reporting environment.
. Integration BO enterprise with external SSO credentials.
. Give Technical Support to Users and Mentoring the team members.
. Planning, Implementing, Deploying, Testing and Training in XIR2.
. Successfully implemented row level and object level security model to
United Health Group XIR2.
. Interacted with the end-users and business analysts to identify and
develop business requirements and transform it into technical
requirements and ultimately responsible for delivering the solution.
. Identified and Mapped Source & Target data.
. Administered & Delivered strategies for the Data Mart design as well
as Extraction Transformation Loading (ETL) Mechanism using Data
Integrator 6.5.1
. Installation and Deployment of Application Foundation (Dashboard
Manager, Performance Management). The installation involved Creation
of Repository Domain tables, Defining Calendars, Setting Security and
Apache/Tomcat configurations.
. Used the Business Objects Services Administrator to monitor and
control all the servers and modules extensively.
. Monitor Web (Apache) and Application Server (Tomcat) and troubleshoot
any Business Objects integration errors.
Datastage Responsibilities:
. Worked on Datastage Parallel and server modules
. Involved in low-level design and developed various jobs and
performed data loads and transformations using stages of DataStage
and pre-built routines, functions.
. Designed and developed reporting Datamarts using PL/SQL from ODS
for reports generation.
. Enhanced the existing Jobs for performance improvement and
applied reject strategy in the jobs to capture missing records.
. Used PL/SQL, Shell Scripts and SQL for update and load of history
data into Data warehouse.
. Production Support and maintenance of Data warehouse monitored
Nightly Batch process (DataStage Jobs). Verified the logs for failure
and fixed the failures.
. Used the DataStage client tools to develop processes for
extracting, cleansing, transformation, integrating and loading data
into data warehouse database
. Involved in Root Cause Analysis for the production problems during
the Nightly Batch process.
Pfizer, NY
Oct 05 -Feb 06
Business Objects Specialist and Assistant Tech Lead
Environment: Business Objects XIR2/6.5.1/6.1/6.1.3/5.1x, Application
Foundation XIR2/6.5.1/6.1/6.1a, SUN Solaris and Windows 2000/NT, Sybase,
Teradata, Oracle 8i, MS SQL
Business Objects Modules: Supervisor, Designer, Full Client, ZABO,
Application Foundation, Set Analyzer.
Architect Responsibilities:
. Business Objects architecture design included the Business Objects
Universe and Reporting Application Design.
. Building Architectural views to analyze the Environment and to do an
Environment Analysis for the Business Intelligence team.
Administrative Responsibilities:
. Interacted with the end-users and business analysts to identify and
develop business requirements and transform it into technical
requirements and ultimately responsible for delivering the solution.
. Identified and Mapped Source & Target data.
. Administered & Delivered strategies for the Data Mart design as well
as Extraction Transformation Loading (ETL) Mechanism using Data
Integrator 6.5.1
. Installation and Deployment of Application Foundation (Dashboard
Manager, Performance Management). The installation involved Creation
of Repository Domain tables, Defining Calendars, Setting Security and
Apache/Tomcat configurations.
. Used the Business Objects Services Administrator to monitor and
control all the servers and modules extensively.
. Monitor Web (Apache) and Application Server (Tomcat) and troubleshoot
any Business Objects integration errors.
. Manage shared Storage space and user documents in Business Objects
server.
. Monitor the Business Objects Server resources - CPU/ IO/Disk
space/Memory etc during Business Objects uptime.
. Manage Business Objects connectivity to the Repository and Database
using the appropriate TNS entries.
. Activate and monitor fail over of Business Objects during application
crash.
. Running supervisor scripts for creating users/groups. Monitoring and
cleaning of the repository by running SQL's on the repository
database. Creating connections for universes for various databases.
. Defined a Broadcast Agent for the group.
. Troubleshooting various server issues for ex: Monitoring service
dependencies.
. Administered Production Migration.
The Hartford Financial Group, Hartford, CT
Mar 04 - Sep 05
Business Objects Specialist and Assistant Tech Lead
Environment: Business Objects XI/6.5.1/6.1/6.1.3/5.1x, Application
Foundation XI/6.5.1/6.1/6.1a, SUN Solaris and Windows 2000/NT, Sybase,
Teradata, Oracle 8i, MS SQL
Business Objects Modules: Supervisor, Designer, Full Client, ZABO,
Application Foundation, Set Analyzer.
Architect Responsibilities:
. Business Objects architecture design included the Business Objects
Universe and Reporting Application Design.
. Building Architectural views to analyze the Environment and to do an
Environment Analysis for the Business Intelligence team.
. Use of existing corporate methodologies as well as helping to define a
new set of methodologies for the planning/developing phases.
. Used Six Sigma Standards for the Documentation of the procedures.
. Define multi-tier Business Objects architecture capable of supporting
all existing Data warehousing.
. Develop test-driven development (TDD) strategy guiding use of the
testing Unit.
. Specify an effective migration strategy from Business Objects 6.1 to
6.5.1
. Recommend agile methodologies to support Business Objects Environment.
. Propose guidelines for proper use of off-shore development resources.
Administrative Responsibilities:
. Worked as Business Object Architect XI for creating and managing the
Enterprise reporting portal.
. Involved in Managing CCM & CMC server components in enterprise portal
like input, output file repositories, Event and Job servers.
. Central Management console was extensively used for folder, group and
User management purpose on daily basis.
. Created required number of filters, processing extensions for
scheduling and implementing the security at user and group level.
. Implemented the user authentication at BO enterprise level after
importing the user data from LDAP server.
. Involved on daily basis to support the user community for over 250
reports running on enterprise reporting portal. And Supported over
2000 user community.
. Configured required SMTP for distributing the reports scheduled for
user groups in .pdf, .xls.rtf etc format.
. Involved in strategizing and collecting data from different sites and
transforming them to the Sales and Marketing data mart
. Data validation done during the load from source to target database
. Key Person for Creation of User Administration and New Reports with
Formatting or standard templates, Applying sorts, cumulative,
calculations, breaks, and ranking to data and Opening, modifying,
saving and sharing existing reports.
. Created design for running multi flavor reports like - Date, Weekly
and Monthly as well.
. Creation of Universe in the Designer, connection to the Database,
class and objects, joins, resolve loops using context and alias,
custom hierarchies.
. Distributing Documents inside and outside of the business
administration for scheduling the Reports (like rep, pdf, excel, text,
rtf and html format).
. Manipulating data through various presentation styles such as charts,
cross tabs, slice and dice, alerts, prompts, nested loops, and filters
. Developed reports and performed web-based ad hoc queries with Web
Intelligence that include detailed map information from ESRI ArcGIS
Server
I. Market Insights
. Universe built with 95 tables, 12 Alias, 8 Context.
. 35 WebI Reports and 20 Full Client Reports
. Adhoc Universe - Maintaining more than 200 Adhoc Reports.
. Gathered User requirements for the WebI reports.
. Built Universe with 95 tables, 12 Aliases, 8 Context.
. Responsible for the Designing the universe by creating the Business
Objects data model selecting/joining tables, indicating cardinalities,
creating aliases to resolve the loops, subdividing into contexts and
creating the objects which are grouped into classes.
. Generated reports using WebI 6.1a
. 35 WebI reports were generated and links were given to each report to
jump from one report to another.
. Executed supervisor scripts for user, user group creation, assigning
privileges etc.
. The Drillable Reports were created in WebI. The reports designing
involved the understanding and creation of Hierarchy in Universe. The
reports were then provided with Drillable Filters to see lower grain
data. These reports were also provided with 'ALL' value prompts inside
the List of Values.
. Customized configuration of business Objects - Web Intelligence by
fine tuning and Optimization for good performance.
. Scheduled Reports using broadcast Agent.
. Created the reports (Master/Detail, Cross tab, Chart templates) in
Business objects and Web Intelligence using the universes as the main
data providers and writing the complex queries including sub queries.
. Worked on the Broadcast Agent module for distribution process.
II. ISD Scorecard
. Migrated AF 6.1.3 to 6.5.1
. Prototype AF 6.5.1
. Built audit universe and reports based on them, using the security
domain audit tables to monitor all the user sessions.
. Built a BCA universe and reports based on them, using the BCA audit
tables to monitor the scheduled jobs.
. Built macros to publish the audit reports to a shared drive as PDF and
excel documents.
. Installed Web Intelligence (Thin Client) and set up the Cluster and
Nodes.
. Implemented Application Foundation -Dashboard Manager, Performance
Manager, Business Objects 6.1.3
. The roles performed were Dashboard/Scorecard Design and Development
using Performance Manager and Dashboard Manager
. Built Special Universes for Application Foundation
. Separate Universe for linked WebI Reports.
. Gathered User requirements for the ISD Scorecard KPI's.
. First Project in Application Foundation Environment for "The
Hartford".
. Built special Universe for Application Foundation with 23 tables, 12
Alias.
. Built 5 KPI's for the Goal Analysis and Performance Evaluation of ISD
group.
. Built 50 Dashboard using 200 Metrics and 50Sets.
. Built 25 WebI reports to link from the Analytics to a detail report.
. Introduced new technology to "The Hartford"
. Worked with all the Analytics like - Interactive Metrics, Speedometer,
Traffic Lights, Navigation List and Compound Analytics.
. Conducted Surveys in ISD team, Scorecards were built according to the
scores.
. Integration of Set Analyzer with Business Objects
. Generation of Sets, Models, Population, Metrics
. Generated trend Metrics, Interactive Metrics, Speedometers
. Added Custom Dashboard Styles by providing company LOGO and skin as a
background to Application Foundation.
. Defined Goals against Metrics. The Goals were then assigned to Roles
within organization. Embedded Goals within Dashboards. Availability
of Goals was extended by adding guided analysis.
. Rules and Alert were defined against Goals.
. The settings and Refreshing of Goals were automated.
. Successfully Completed with the Phase I and continued working with
Phase II.
. Upgraded from AF 6.1.3 to 6.5.1
. Migrated all the Dashboards and Scorecards from 6.1.3 to 6.5.1.
. Generated a Prototype of AF 6.5.1 using all the new Analytics like
Tree Analytics, Drill Speedometer, Sliced Metrics, Map Analytics and
Text Analytics.
. Presented the Prototype to the Business Objects and The Hartford.
. Continuing to work in Phase II with the latest Analytics in AF 6.5.1
Datalan Corporation (Partner of Business Objects), NY, USA
Jan 04 - Mar 04
Business Objects and Application Foundation Specialist
Environment: Sybase, Oracle 8i, MS SQL, Business Objects 5.1/6.1/6.1a,
Application Foundation 6.1/6.1a, UNIX Shell Script, AWK, PERL, HP-UX, SUN
Solaris and Windows 2000/NT
I. Morgan Stanley - Set Analyzer and Application Foundation
. Analyzing the Specifications of the Project. Installation and
Deployment of Application Foundation (Dashboard Manager, Performance
Management).
. The installation involved Creation of Repository Domain tables,
Defining Calendars, Setting Security and migration of the existing
WebI deployment from IIS to Apache/Tomcat configurations.
. Designed Business Metrics by defining Key Performance Indicators (KPI)
by defining Tables, Measures and Filters as basis for Metrics. The
Metric Universe took into consideration multiple Fact tables and
multiple Data Sources.
. Secured Dashboard Manager using Business Objects Supervisor. Also,
extended its functionality to add custom security.
. Linked Business Objects documents to analytics by value passing
navigation technique. (OpenAnalytics.jsp)
. Enhanced Dashboards using Maps and Metric Trees and embedded them in
Dashboards. Also, added navigation capabilities to these components.
. Added Custom Dashboard Styles by providing company LOGO and skin as a
background to Application Foundation.
II. Clayton - Prototype Model
. Analyzing the Specifications of the Project
. Responsible for the Designing the universe by creating the Business
Objects data model selecting/joining tables, indicating cardinalities,
creating aliases to resolve the loops, subdividing into contexts and
creating the objects which are grouped into classes.
. Created the reports (Master/Detail, Cross tab, Chart templates) in
Business objects and Web Intelligence using the universes as the main
data providers and writing the complex queries including sub queries.
. Worked on the Broadcast Agent module for the distribution process
. Generated the reports for the web users using the Web Intelligence 2.x
Info View crated prompts and frame management using JSP.
. Prototype Reports generation and Integration with JSP.
III. JP Morgan Chase - Message Dashboard Prototype Model
. Analyzing the Specifications of the Project
. Creating Customized Universe and data population in the Database
. Creating Reports in Full Client module
. Publishing the reports to the corporate documents
. Strategic use of Inbound and Outbound messages for the Message
Dashboard
. Hyperlinks to multiple tables from master dashboard
. Integrating reports with JSP for the prototype model.
FannieMae, Washington DC, USA
Oct 03 - Jan 04
Business Objects Specialist
Environment: Sybase, Oracle 8i, Business Objects 5.1/6.1, Application
Foundation 6.1, UNIX Shell Script, AWK, PERL, HP-UX, SUN Solaris and
Windows 2000/NT.
Single Family & Multi Family
. Responsible to optimize the master commitment balance to maximize the
most efficient of Capital.
. Installation of Business Objects 6.1 / Administration
. Installed WebIntelligence (Thin Client) and set up the Cluster and
Nodes
. Customized configuration of business Objects - Web Intelligence by
fine tuning and Optimization for good performance.
. Involved in installation of Broadcast Agent, Broadcast Agent
Publisher, Auditor
. Installation of Application Foundation 6.1a/ Administration
. Configuration of Business Objects & Application Foundation
. Generated various reports as per the client's requirements
. Created database connections and created Repository and domains
. Analyzed the existing database and designed the Universes using
Business Objects Designer Module.
. Upgrading V5 to V6 in business Objects.
. Created Universe, Classes, Objects, Measure Objects, Conditions, Joins
. Involved in resolving the loops, cardinalities, contexts and checked
the Integrity of the Universes.
. Creation of Dashboard and Score Cards using Dashboard Manager.
. Monitoring Business Metric.
. Managing Enterprise Performance.
. Created the reports using Business Objects functionalities like
Queries, Slice and Dice, Drill down, @Functions, Cross Tab,
Master/Detail and Formulas etc.
. Worked on the Broadcast Agent module for the distribution process
. Involved in Separate Logical and Physical models support using ERWIN.
. 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.
. Attended Trouble shooting and knowledge transfer.
. Overall Maintenance and Administration of Business Objects and
Application Foundation.
Student Experience
World Bank Group, Washington DC, USA - Internship NJIT
Sep 02 - Sep 03
Business Objects Developer
Environment: ORACLE 8i, Informatica-Power Mart 5.1/PowerCenter 5.1,
Business Objects 5.1/ 6.1, SQL, PL/SQL, Erwin, TOAD, SQL*Loader, UNIX Shell
Script, AWK, PERL, HP-UX, SUN Solaris and Windows 2000/NT.
. Responsible for presenting the Data Warehousing concepts and tools to
their prospective clients
. Created and facilitated presentations and demonstrations for Business
Intelligence tools (Business Objects) and ETL tools (Informatica).
. Installed WebIntelligence (Thin Client) and set up the Cluster and
Nodes
. Generated various reports as per the client's requirements
. Created database connections and created Repository and domains
. Analyzed the existing database and designed the Universes using
Business Objects Designer Module.
. Migrate V5 to V6 in business Objects.
JP Morgan, NY, USA-Internship
Jan 02 - Aug 02
Business Objects Developer
Environment: Business Objects 5.1, Designer, PL/SQL, Discoverer 3.1.4,
Unix, Informatica PowerCenter, EJB, Servlets, XML and Oracle8i, J2EE,
Erwin.
BO Development:
. Initial reports developed in the Oracle Express.
. Responsible for the Designing the universe by creating the Business
Objects data model selecting/joining tables, indicating cardinalities,
creating aliases to resolve the loops, subdividing into contexts and
creating the objects which are grouped into classes.
Wipro Technologies
May 00 - Jan 02
Business Objects Developer
Contact this candidate