Computer Programer Data Entry Specalist

Computer Programer Data Entry Specalist

Username: Ganesh
Register Now to Contact Ganesh
Already Registered, Click to Contact Ganesh

Member Since: April 27, 2010

Employment History:

Ganesh Sivakumar
Datawarehouse Architect/Business Intelligence Manager

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 XIR2
• Technically Trained Cognos/Microstrategy Specialist
• Technically Trained in XIR2 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, Xcelcius, Import Wizard, Publisher and Designer of Business Objects XI R2 and Crystal Reports XI R2.
• Installation and Configuration of Business Objects XI R2 & XI 3.1 Servers
• Developed crystal Xcelcius 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
• 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 Management Tools: Application Foundation (Dashboard Manager, Performance Manager) 6.1(B), 6.5.1, XI R2

Reporting and Analysis Tools: SAP BW 7.0, 3.x , BO (Business Objects) 5.1.x, 6.1(a/b), 6.5.1, XI R2, XI 3.1 ;Web Intelligence 2.7, 6.1(a/b), 6.5.1,XI R2 MS-Analysis 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 Languages: PL/SQL, HTML, XML, Jscript, VB Script and VBA.
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, XCelcius, 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
• 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 Xcelcius dashboards to enhance the portfolio decision metrics
• Developed crystal xcelcius 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

Educational History: