Manager Data
Resume:
Naresh K
abhhuk@r.postjobfree.com
SUMMARY
•Over all 8+ years of experience in Study, Design, Analysis, Development and Implementation of
Software Application Development under different environments including 7 years of experience in using
DSS/OLAP (Data Warehousing) tools i.e., Business Objects XI R3,XI R2, BO 6.5 and BO 5.5,
Performance Manager, Dashboard Manager, Voyager, Xcelcius, Crystal Reports, BEx Web and BO
Java SDK.
•Experience in Designing/Developing the User-Interface (Universe/Data-Model), Developing Canned/Ad-
hoc Reports, Scheduling and processing of reports using Broad Cast Agent and Supervisor.
•Hands on experience in ETL tool like Informatica for Extraction, Transformation and Loading.
•Experience in Client/Server Technology and RDBMS. Involved in Data Conversion such as Analysis,
Design, Development, Mapping, Testing and Implementation with various customers.
•Hands on experience using Oracle 8i/9i/10g, SQL Server 2000, 2005 and 2008 extensive experience in
writing SQL Queries, PL/SQL, Stored Procedures, Functions, Triggers, Exception Handling, Cursor,
Database Objects and Collections.
•Proficient in various features of ERWIN like forward engineering and reverse engineering.
•Confident, independent, good decision-making power gained over all 7 years of IT experience and ability
to adapt to new technologies very quickly.
• Able to work within an aggressive and demanding project schedule and environment.
•Excellent analytical, time management, interpersonal skills and a good team player with excellent oral
and written communication skills.
Expertise in Developing Full Software Cycle which includes Design,
Development, Report Generation, Testing, Debugging, Support and Maintenance.
Proficient in creating Classes and Objects using the available Tools and
existing designs in Business Objects Designer.
Extensively worked with Business Objects Web Intelligence (WebI) and
Desktop Intelligence (DeskI) in generating reports and analyzing them.
Expertise in handling various Business Objects Administrative tools such as
Central Management Console (CMC), Info view, Import Wizard, Report Conversion
Tool and Central Configuration Manager (CCM).
Scheduled and published reports using the Business Objects Enterprise
Server and provided access to different user groups through Info view.
Designed reports with complex formulas and custom functions.
Designed reports in Crystal Reports XI and 2008 with complex command
objects to optimize response time and performance of the reports.
Design reports with conditional formatting, suppressing, sorting and alerts.
Designed parameterized reports with Dynamic Cascading Prompts and
hierarchical groupings with summaries.
Designed reports based on Business Views and Universes with parameters,
summaries and running totals in Crystal Reports XI.
Implemented Cross-Tab reports with Drill-down Charts.
Customized and performed troubleshooting on existing reports for specific
requirements on an on-demand basis.
Designed efficient database in Oracle and MS SQL Server to suit reporting
needs of the organization.
Tested the performance of Crystal Reports for reports based on Business
Objects Universes.
Designed unlinked sub-reports and linked sub-reports based on user selection.
Created new stored procedures and modified existing ones using PL/SQL.
Created and managed reusable/shared repository objects.
Performed troubleshooting of scheduled reports that failed or produced
errors while they were run.
Interacted with end users and business analysts to gather the reporting
requirements.
Evaluated different reporting strategies to determine the best fit solution for
the business.
Assisted the end users in UAT procedures and understanding the reports
and the associated desktop/web-based applications.
End to end development and deployment of Crystal Reports on a Java-based
web application.
Created forms and report viewers in JSP for Crystal Reports running off Java
Stored Procedures.
Created database migration scripts to deploy database and reporting changes
across the different environments from Development to QA and UA.
Assisted the database and Business Objects teams in troubleshooting
issues.
Assisted Business analysts and end users with understanding and
clarifying business requirements vs. design issues.
EDUCATION:
BS in Information Technology – Anna University, India
SKILLS SUMMARY:
Operating System: Windows 98/2000/NT/ 2003 Server, XP, UNIX and Sun Solaris
BI AdminTools: Business Objects Suite, BO CMC, Creating users and groups and security
administration.
BI Developer Tools: Universe Designer, BI Tools Business Object XI R3, R2 /6.x/5.x, Dashboard
Manager, Performance Management, Voyager, Xcelcius, Crystal Reports
9.x/XI,
Business Explorer
Data Modeling: Erwin 3.5.2
ETL Tools: Informatica 5.x/6.x/7.x.
RDBMS: Oracle8x/9x/10g, MS SQLServer 2000/2005, DB2 UDB, My SQL
Languages: C/C++, Basic, SQL, Java, Shell Scripting
GUI Tools: VB 6.0, .NET, HTML, VB Script, JavaScript
EXPERIENCE:
Glostream Inc. - Troy, MI Dec 09 – Apr 11
Role: Sr.Business Objects Lead Administrator
Responsibilities:
• Designed technical infrastructure and leads the design and implementation of Business Objects
Enterprise.
• Developing and converting Business Objects code and applications on SSIS to provide data availability to
the end users.
• Involved in Upgradation of BO XI R3 from previous BO version BO XIR2.
• Done lot of BO Administration, Security, command line import utilities and Troubleshooting.
• Worked in different Business Objects experience like Linux, Windows environment.
• Implemented security in designer appropriately according to the user profiles, resolved loops, contexts
in the universe.
• Developed Dashboards and Scoreboards using Xcelcius 2008 on top of crystal reports.
• Done Integration with SharePoint and SAP in Business objects.
• Designed High availability with a two node active/active cluster data center architecture.
• Deployed Business Objects with BOJAVA XI R3 and Tomcat/Apache on windows 2003 servers.
• Installed and Configured Performance Management, Voyager on Business Objects Enterprise.
• Configured Redundant Services in XI R3 provide fault tolerance & load balancing.
• File Store (FRS) is moved and configured in to SAN, to eliminate the dependency on the availability of a
single server for access to the content.
• Installed and configured Cisco CSS routers for directing web traffic for the XI R3 Web Server
Environment.
• Configured E-mail functionality (Outbound SMTP Relay) into the XI R3 Application and users will have
the ability to send documents using E-mail and to send the output of the reports in PDF, excel or WebI
documents or as an link.
• Configured Business Objects XI R3 AD Authentication (Kerberos) on Java App servers.
• Worked with AD directory services to implement Java Info view single sign on authentication by running
SETSPN utility command.
• Configured Java Info view Single Sign on (SSO) between Tomcat apache and IIS authentication using
Vintela.
• Responsible for Administration of Business Objects XI R3 Enterprise environment for nearly 3000
users.
• Applying latest patches, service packs onto the testing and production environments under change
management process by sending communication outages to users.
• Worked with System Administrators to troubleshoot the Business Objects Services after the
application patches have been applied.
• Designed 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 like
Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the
universe.
• Created Hierarchies, complex objects using various functions, Aggregate objects in the universe.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down,
@Functions, Cross Tab, Master/Detail and Formulas etc.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Synchronized queries from multiple data providers by linking the common dimensions using merge
dimensions option in WebI XI R3.
• Created complex reports by linking data from multiple data providers.
• Developed reports using WEBI, DESKI as well as Crystal Reports.
• Tested all the reports with different scenarios like query balancing, look and feel and formatting of the
reports based on the specifications.
• Designed Metric Universe for Performance Management products
• Created metrics, goals and analytics for display in corporate dashboards for business user consumption
• Created and customized application dashboards using Application Foundation to meet the requirements
of higher level analysis.
• Developed dashboards and scoreboards for detailed analysis.
• Configured Voyager connections in CMC and developed voyager workspaces in Info view using cube as
data source.
• Migrated Business Objects WebI reports, Crystal reports, Dashboards, Analytics, Voyager workspaces,
Universes from Dev to QA to Prod using Import wizard.
• Resolving and troubleshooting Business Objects/Crystal reports 2008 issues using Heat ticket system
• Responsible for Integrating Business Objects with SAP BW with Portal Integration kit to publish the
reports onto the Enterprise using BW/R3 portal.
• Modified BW queries in the Crystal reports using BW query designer with Crystal 2008 professional tool.
• Performed Auditing of the application usage of the reports and security with Auditing tool.
• 24x7 support of the production environment.
Environment: Business Objects XI R3.1 (CMC, Designer, Desk I, Web I, Import Wizard, Publishing Wizard),
Crystal Reports 2008, Xcelcius 2008, MS SQL Server 2008, SharePoint, Linux and BO Java SDK.
Royal Bank of Scotland – Stamford, CT Feb 08 – Nov 09
Role: Lead Business Objects Administrator
Responsibilities:
• Involved in Full life cycle of Business Objects reporting Application right from requirements gathering
till the deployment of the Business Objects reporting system on to production.
• Responsible for Administration of Business Objects XI R3 Enterprise environment for nearly 2700
users.
• Involved in Upgradation of BO XI R3 from previous BO version BO XIR2.
• Filled up the BVR (Business View Requirement) doc appropriately by identifying the source data.
• Used Teradata as the data source and tested data in the reports for accuracy using the Teradata SQL
Assistant
• Done lot of BO Administration and Troubleshooting.
• Installed and configured the Business Objects environments for both development and production.
• Created repository and security domain with user groups and security implementation.
• Designed and developed Universes based on the specifications, created classes and objects.
• Defined joins and set the cardinalities between the tables and resolved loops by creating alias and
contexts.
• Worked in different Business Objects experience like Linux, Windows environment.
Extensively worked with Business Warehouse and various non-SAP database sources
in generating reports and analyzing them.
• Developed Dashboards and Scoreboards using Xcelcius 2008 on top of crystal reports.
• Done Integration with SharePoint and SAP in Business objects.
• Created custom LOV’s which help the end users while picking the values from the prompts.
• Documenting the production and development environment changes made on the web servers.
• Maintained Users and Groups Security by creating AD groups and attaching it the folders on the
Enterprise.
• Handled Business Objects bugs and issues and Interacted with Business Objects Tech Support in various
Occasions and resolved issues related to server and deployment.
• Linked the Universes to share the common components between them.
• Configured BO users logins and Security checks (Who is accessing what) verification.
• Monitoring BO server including Test (WMNTBO and WMNTBO1) running with optimal performance.
• Applied security features of Business Objects like row level, report level & object level security in the
universe so as to make the sensitive data secure.
• Created objects using business objects functions like @prompt, @select, @where, @variable.
• Organized data in the reports by using Filters, Sorting, Ranking
• Deployed and scheduled reports via Broad Cast Agent.
• Web-I Reports were created and deployed through Info View.
• Extensive Analysis has been done to Design the Universes and assigned them to respective domains.
• Created custom Hierarchies which help the end users to drill down to lower levels in the reports.
• Developing and converting Business Objects code and applications on SSIS to provide data availability to
the end users.
• Created Alerters using Business objects to highlight columns based on business criteria
• Inserted drill filters in the Web-I reports, which help the end users to run a report, based on multiple
selection criteria.
• Created canned reports and also ad-hoc reports.
• Handled Exceptional Errors and Interacted with Business Objects Tech Support in various Occasions
and resolved issues over Web Intelligence.
• Created the Audits for Failed and Partly Converted Reports during the Conversion to Web Intelligence
Reports
• Scheduled reports over Info View.
• Validated all reports converted to BOXI R3 for Consistency of Data and Discrepancies, and enhanced
them as per the User Requirements
Environment: Business Objects XI R3.0(CMC, Designer, Desk I, Web I, Import Wizard, Publishing Wizard),
Crystal Reports XI R2, Xcelcius Dashboards, Oracle 10g/9i, PL/SQL, SQL-Server 2k, Windows 2000 and UNIX, .
Trover Solutions Inc. – Louisville KY Sep 06 – Jan 08
Role: BO Administrator
Responsibilities:
• Participated in requirements gathering, analysis and structured Business Intelligence platform based on
user requirements
• Involved in Upgradation of BO XI R2 from previous BO version BO 6.5.1.
•
• Worked with System Administrators to troubleshoot the Business Objects Services after the
application patches have been applied.
• Developing and converting Business Objects code and applications on SSIS to provide data availability to
the end users.
• Implemented security in designer appropriately according to the user profiles, resolved loops, contexts
in the universe.
• Designed High availability with a two node active/active cluster data center architecture.
• Deployed Business Objects with BOJAVA XI R3 and Tomcat/Apache on windows 2003 servers.
• Created functional requirement specifications through end-user meetings and analysis of business
requirement documents.
• Responsible for Administration of Business Objects XI R3 Enterprise environment for nearly 2000
users.
• Installed Business Objects XIR2, created repository (multiple domains), users/groups and configured
Web Intelligence using configuration tool.
• Assigned broadcast agent to various groups using WebI Admin Console.
• Analyzed the existing OLTP system and designed and managed universes based on the Business
Requirements.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying
contexts and alias tables to remove cyclic dependencies.
• Used @functions like @select, @where and @prompt function to create prompts which helps the user to
select the values dynamically.
• Customized the list of values (LOV’s) which helps the end users to select the values.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better
performance.
• Regular BO repository Maintenance like Cleaning Orphaned Connection/Universe/Documents .
• Scan / Repair and Compact to all repository errors and Domain testing
• Exported universes to the Repository for making resources available to the users.
• Developed Business Objects Universes with classes, objects and condition objects and developed
hierarchies to support drill down reports
• Extensively worked on Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down
and Hierarchies for creating reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master
detail tables and formulas, etc.
• Created complex reports by linking data from multiple data providers, using free hand SQL and
functionalities like Combined Queries.
• Developed reports using both Full client and WebI. Used HTML report Panel in the process of creation
reports.
• Created complex Web I reports by linking objects from different data providers and creating local
variables in the Java report Panel.
• Worked in creation of multiple universe and document domains for Development, QC and Production
Environments.
• Tested the all the reports with different scenarios like query balancing, look and feel and formatting of the
reports based on the specifications.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast agent console
• Created template to customize style and structure of the canned reports to maintain company standards.
• Created Users, User groups and setting up the user profiles.
• Converted Desktop Intelligence reports to Web Intelligence Reports, using Conversion Tool and run
them successfully upon refreshing.
Environment: Business Objects XI R2 (CMC, Designer, Desk I, Web I), Crystal Reports 10, Xcelcius 4.5 and MS
SQL Server 2005.
DCP Midstream, Denver, CO Nov 05 – Aug 06
Role: Sr. Business Objects Developer
Responsibilities:
• Information gathering - interacted with the end user to understand the requirement and
business logic
• Installed Business Objects v6.5.1, created repository (multiple domains), users/groups and
configured Web Intelligence using configuration tool.
• Assigned broadcast agent to various groups using Web I Admin Console
• Analyzed the existing OLTP system and designed and managed universes based on the Business
Requirements
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables
applying contexts and alias tables to remove cyclic dependencies
• Used @functions like @select, @where and @prompt function to create prompts which helps the
user to select the values dynamically
• Customized the list of values (LOV’s) which helps the end users to select the values.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better
performance
• Developed Business Objects Universes with classes, objects and condition objects and
developed hierarchies to support drill down reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab,
master detail tables and formulas, etc.
• Created complex reports by linking data from multiple data providers, using free hand SQL and
functionalities like Combined Queries.
• Extensive testing and migrating the reports or objects from development to Production system.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Scheduling reports from the Broadcast Agent Server to only requested users.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Involved in performance testing of all the reports, which helped in analyzing its performance
before moving into production.
• Involved in installing Web Intelligence, creating users, user groups and categories
• Generated reports for web users using Web Intelligence and Info View.
• Created Web Intelligence documents and published them to corporate documents.
• Installed and configured Business Objects XI r2 using Tomcat and Apache as Application and
Web Servers.
• Migrating Business Objects 6.5.1 version reports to new version XIr2.
• Converted the existing full client reports to WebI reports using Report Conversion Tool.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to
BO XI environment using Import Wizard.
• Created reports using Desktop Intelligence and Web Intelligence in BO environment.
• Synchronized queries from multiple data providers by linking the common dimensions using merge
dimensions option in Web XI R2.
• Recreated repository Tables using Central Configuration Manager.
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console
• Developed Crystal Reports XI to address diverse levels of the organizational requirements ranging from
Individual employees to a complete line of operations.
• Involved in developing the financial reports for the Financial services Dept and successfully published
the highly formatted reports and met with the end user requirements
• Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I XI R2.
• Scheduled pre-canned reports through Web I XI R2 Scheduler for distribution and printing.
Environment: Business Objects 6.5.1, Web Intelligence XI R2, Broadcast Agent 6.5.1, Supervisor, Designer,
Reporter, Info View, Oracle 9i, Windows 2000/NT, SQL, PL/SQL, Visual Basic.
Eastman Kodak Company, NY Jan 05 – Oct 05
Role: Business Objects Developer
Responsibilities:
• Designed and developed Universe for reports generation
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down,
@Functions, Cross Tab, Master Detail and Formulas etc.
• Created the Reports using the Universes as the main Data providers and writing the complex queries
including Sub Queries, Unions.
• Resolved the loops, cardinalities by contexts and aliases and checked the Integrity of the Universe.
• Involved in SQL Tuning to increase the Query performance.
• Used the Broad Cast Agent server to Schedule and Monitoring the Reports.
Environment: Business Objects 6.5.1, Web Intelligence, Broadcast Agent 6.5.1, Supervisor, Designer, Reporter,
Info View, SQL, Unix (IBM AIX 5.1, Sun Solaris 8), JSP, PL/SQL, Window Server.
Target Corporation, India Jan’03-’Nov’04
Role: Data warehouse Developer
Responsibilities:
• Designed, developed, implemented and maintained Universes using Business Objects 5.5 Designer.
• Developing complex Universes using advanced features in Business Objects like LOVs (List of Values)
and prompts and resolved the loops using Aliases and Contexts.
• Prepared documentation including requirement specification.
• Designed the Data Mart model with Erwin using Star Schema methodology.
• Creating Dimensions and Facts in the physical data model.
• Documented the metadata to capture from the sources
• Created Sessions and batches to extract the data.
• Involved in the creation of jobs using work flow manager to validate schedule run and monitor the jobs.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Information is stored in table definitions in the repository and is entered using the Repository Manager.
• Used the Power center Designer to develop processes for extracting, cleansing, transforming,
integrating, and loading data into data warehouse database.
• Wrote Unix Shell Scripts to automate the process.
Environment: Business Objects 5.5 (Supervisor, Designer, Reporter, Desktop Intelligence, web Intelligence, CMC
& Info View), MS Access, SQL, PL/SQL, XML and Windows Server.
Contact this candidate