Data Project
Resume:
Venkatapathi Raju Penmethsa
Business Objects Administrator/Architect
PROFESSIONAL SUMMARY:
• Over 7 years of experience in all phases of Data Warehouse lifecycle development & production support
applications using Internet, Web and Client Server Technologies in N Tier Architecture.
• Has been engaged with GE since last 8 years and is currently the Sr. Business Objects XIR3.1 Administrator at
GE Corporate Shelton CT.
• Has hands on experience in setting up a new XI environment which includes installation, IIS Tomcat Bridge, SSO
configuration etc., tomcat tweaks, Security setup for various user groups/universe, Setting up server
parameters/Business Objects services parameters to ensure best performance, Installing fixes and patches for
issue resolution,building best practices documents, white papers on various version control tools like NOAD and
LCM, Building the DR environment and documentation for the same.
• Performed BI content upgrade from Business Objects 6.5.1 to XIR2 and from XIR2 to XIR3 which included sizing,
planning etc.
• Experienced in Business objects administration, performance tuning, trouble shooting and security
design/implementation.
• Good experience in developing Reports/Universes using Business Objects XI R3.1/R2/6.5.1/6/5i, Crystal
Reports Xi/10/8, BCA, ZABO, OLAP, Info view, Oracle 8i/9i, Stored Procedures, SQLServer 2000,
DB2,Teradata and MS Access.
• Expertise in building universe/reports for various projects like eTandl(Travel and living), Sourcing Metrics and
enhancements for projects like GIS service DWH, Healthcare Accounting.
• Expertise in reporting Tools Business Objects 6.5.1, Business Objects XIR2, Business Objects XIR3.1, and ETL
tool Informatica 6.x, 7.x and 8.1.1.
• Has developed few mappings using various transformations. He has extensively worked on workflow properties
like job scheduling, recovering sessions and managing dependencies. He has good knowledge of quality process,
data warehousing concepts and data modeling. He designed and developed considerable number of components
in Informatica.
• Well versed with Oracle RDBMS (Versions 8i, 9i). He has worked extensively on analysis, design and
development of PL/SQL modules. He has extensive knowledge of PL/SQL code development which involves
creation of procedures, functions, triggers, synonyms, packages, transactions, cursors (parameterized and
dynamic), oracle system tables and exception handling.
• Extensive exposure in software lifecycle, Application Software Design, Development, Documentation, debugging
and Implementation.
• Extensive exposure to Object Oriented Design and Programming.
• Well experienced in developing Database components and SQL/PL SQL.
• Experience in manual & automated testing and writing Test Cases, Test Data, Test Scenarios, Test Procedures,
Test Plans and Test Scripts
• Exceptional analytical and communication skills proven by effective interaction with management, team members,
functional owners and users.
• Proven Strengths Expertise in business analysis, applications programming and trouble shooting. Self motivated
and team work skills.
• Ability to learn Tools and Technologies very quickly, correctly and apply them in correct manner.
• In recognition to his Deep BO administration Knowledge and his efficient support to BO users with direct exposure
to US clients have got him various client appreciations in the form of mails awards. For efficient and full stretch support
provided for HR3 (which comprises of 8000 users) .Was appreciated by the clients in GE Energy and was awarded Pat on
Back award.
Page 1 of 6
Venkatapathi Raju Penmethsa
Business Objects Administrator/Architect
• Has also been awarded with Pat on Back award for Smooth upgrade from Business Objects XIR2 to Business
Objects XIR3.1.
EDUCATION:
• Bachelor of Engineering from Vishweshwariah Technological University.
TRAINING AND CERTIFICATIONS:
• Business Objects 6.5.1,XIR2, XIR3.
• Data warehousing.
• Diploma in Japanese Language from Bangalore University.
• Business Objects Data Integrator.
• Oracle, PL/SQL Developer.
• Informatica 6.5.1 Training
TECHNICAL SKILLS:
Languages Domain Knowlege
JAVA, C++, C, VB 6.0 Data Ware Housing Business Intelligence
Tools & Technologies Databases
Business Objects 6.5.1, Business Objects Oracle 9i,10g,11g
XIR2,Business Objects XIR3.1,Live office Microsoft SQL Server 2000
Version control tools: LCM,NOAD Java™ Messaging Service (JMS)
ETL tools: Informatica 6.5.1/7.1.3/8.1.1
Operating Systems App Servers and Web Servers
Windows 95/NT/2000,2003,XP,7,2008 WebSphere™ Application Server 5.x/6.x/7.x
MS DOS IIS
Apache Tomcat Server 4.x/5.x/6.x
WORK EXPERIENCE
Page 2 of 6
Venkatapathi Raju Penmethsa
Business Objects Administrator/Architect
Business Objects Developer
Project: GE Corporate Tandl DW
Client: GE, USA
About Client/Project:
Travel and Living Data mart originally provides end to end reporting solution for all the travel details of GE Infrastructure
employees i.e. for Energy, Oil & Gas, Aviation, Rail and Water. The Global T&L warehouse after completion is aimed at
providing the reporting and Dashboards to all the employees of GE belonging 60 Businesses
The Global T&L warehouse data security mainly focuses around ability to quantify data with respect to employees and their
Roles.
Responsibilities:
• Building the universe and reports as per the requirement.
• Modification/enhancements for reports/universes as per the requirement.
• Creation of Business Objects reports using the universe as the main data providers and writing the complex
queries including sub queries, Unions, Intersection and Aliases.
• Performance tuning to reports.
• Universe restructuring by removing all the unwanted/unused tables in the reports.
• Provide support for XI Migration team.
• Involved in migration of personal documents of users.
• Provide status updates to Customer and to drive the offshore team calls.
Environment: Database: Oracle 8i
Tools: Business Objects 6.5.1.
.
Business Objects Administrator
Project: GE Energy Enterprise Data Warehouse
Client: GE Energy, USA
About Client/Project:
GEE (GE Energy) started the strategic initiative to build a Business Intelligence Center of Excellence that would cater to the
BI requirements of various business entities within GEE. This involves outsourcing the strategy, process methodology,
design, development, coding, testing, integration, deployment and support of the Enterprise Data Warehouse on an onsite
offshore model.
The applications, systems, and infrastructures are located primarily in Atlanta and Schenectady while there are various other
instances present across the globe. This will allow GE to deliver of Enterprise Data Warehousing Solution to a large user
community within GEE.
General Electric Power Systems (GEPS) Enterprise Data warehouse is one of the largest data warehousing projects in the
world currently in progress. The objective of the project is to build an Enterprise wide Data warehouse Solution for GEPS,
Page 3 of 6
Venkatapathi Raju Penmethsa
Business Objects Administrator/Architect
which consists of Design, Development, Coding, Testing, Integration, Deployment and Maintenance of the Enterprise Data
Warehouse and also to coordinate their various sources of information for better decision making.
The primary objective includes providing enterprise wide data warehousing solutions for top level executives and to a large
extent for operational users also. This will allow GEPS Management to continue to analyze the organized data. GE Power
Systems Data Warehouse is built upon integrated legacy system data feeds received from many GE based business data
sources. This process involved creation of various individual data marts and merging those data marts for final digital
cockpits.
The applications, systems, and infrastructure are located in Atlanta, Schenectady, and Cincinnati. This will allow GE EDW to
free internal GE resources from their current assignments and reassign them to new projects aimed at the coordination and
delivery of this Enterprise Data Warehousing Solution to a large user community within GEPS. This enterprise Data
Warehouse project consists of around 213 data marts. GEPS EDW Data warehouse project is also the proud winner of the
prestigious Data warehousing Institutes prestigious Award “Best Practices in Data warehousing” for the year June 2002
Responsibilities:
• Creating groups and migrating all 5.1 universes and Reports to 6.5.1 repository. Adding users to repository,
Categories, BO Connections and Security group as part of Maintaining Business Objects Repository.
• Setting up/Maintaining Business Objects security.
• Business Objects server administration.
• SSO Implementation.
• Migrating universes/reports from Development > Test > Production
• Administer users and security settings in a multi client hosted environment
• Meeting with customers and internal stakeholders to determine ongoing requirements
• Translate requirements into database and universe design enhancements.
• Maintain documentation on universe and related environments.
• Creation of ad hoc queries and reports
• Scheduling reports and broadcasting to different users based on the security profile each user carry
• Define and apply ‘best practices’ for performance and usability of universe
• Install, Configure and Patch Business Objects software on Windows platform.
• Perform Business Objects upgrades and new releases.
• Manage multiple client Business Objects universes/
• Resolve customer support issues by phone and internet.
• Design reviews for new universes/reports.
• Planning backups for repository, NAS and server.
• Setting up DR systems.
• Involved in Biz team meetings with analyst for unclear, missing and new requests or functionalities from Biz team.
Environment: Database : Oracle 8i
Tools : Business Objects 6.5.1,Oracle PL/SQL, Informatica 7.1.3/8.1.1,Unix, Toad
Sr. Business Objects Administrator/Architect Aug 07 Till Date
Project: GE Corporate Enterprise Data Warehouse
Client: GE Corporate, CT
GE is one of the world’s leading suppliers of technology to the energy industry. GE is into various businesses such as GE
Advanced Materials, GE Commercial Finance, GE Healthcare, GE Infrastructure, GE Transportation, NBC Universal to
name a few. The project known as COG HR contains all the information of the GE Employee’s including their salary and
compensation details. They have a centralized database for this, known as Oracle Human resource (OHR).
Page 4 of 6
Venkatapathi Raju Penmethsa
Business Objects Administrator/Architect
The applications, systems, and infrastructures are located primarily in Cincinnati and Alpharetta while there are various
other instances present across the globe. This will allow GE to deliver of Enterprise Data Warehousing Solution to a large
user community within GEE.
Has been engaged with GE Corporate since last 4 years (client location) and is currently supporting Business Objects
XIR3.1. He has hands on experience in setting up a new XI environment which includes installation, IIS Tomcat Bridge,
SSO configuration etc, Tomcat tweaks, Security setup for various user groups/universe, Setting up server
parameters/Business Objects services parameters to ensure best performance, Installing fixes and patches for issue
resolution,building best practices documents, white papers on various version control tools like NOAD and LCM, Building
the DR environment and documentation for the same.
As lead BO administrator was involved in migrations from Business Objects 6.5.1 to Business Objects XIR2 and also from
Business Objects XIR2 to Business Objects XIR3.1. He has be awarded with Pat on Back award for his commitment
towards the project.
Responsibilities:
• Installation and configuration of business objects patches and upgrades.
• Creation and maintenance of BOXI security groups and content.
• Installation, configuration and use of BOXI administration tools such as Auditor and third party
monitoring tools.
• Troubleshooting /tuning CMS and server tuning parameters for BOXI 3.1 environment.
• Coordination and communication of planned upgrades, enhancements and maintenance outage windows
in collaboration with the Analytic teams. This includes scheduling, coordination of testing and production
readiness planning. Patch and upgrade business objects as needed (including hot fixes).
• Managing change control process and Performance monitoring and tuning of the environments to ensure
smooth operation, to identify and resolve manage performance issues and to drive best practices and
maintain constant uptime.
• Troubleshoot issues with Developer tools and server side objects performance issues and to drive best
practices and maintain constant uptime
• Support the Developers and Users who run reports on the business objects site.
• Keep up with licensing and ensure that we maintain compliance and request more as needed.
• Meet with customers and internal stakeholders to determine ongoing requirements.
• Suggest and keep up to date with new software tools and processes Translate requirements into
database and universe design enhancements.
• Involved in migration of BO 6.5.1 to XIR2, Involved in migration from XIR2 to XIR3.1
• Interacted directly with end users and helped them in the migration process.
• Analyzed, designed, built and tested reports while working directly with end users and technical members of a
data warehouse team.
• Involved in creating reports/designing universe and its deployment.
• Formatted the Reports to meet the user requirements using Multi Dimensional Analysis like Slice & Dice, Drill
Down.
• Worked on Web Intelligence to develop and publish thin client reports.
• Maintaining the access & security of users.
• Providing Business Intelligence (BI) solution & related components: interfaces, conversions, HW/SW oversight
• Understands business challenges & translates them into requirements/solutions. Provides Solution Performance
(analysis/tuning) & works across business/technology teams to ensure alignment between business solution
definition & systems architecture for the organization.
• Interacted with Business Analysts and end users to develop standard and ad hoc reports according to functional
specifications.
Page 5 of 6
Venkatapathi Raju Penmethsa
Business Objects Administrator/Architect
Environment:
Database:
Oracle 9i, Oracle 10g, Oracle 11g
Tools: Business Objects 6.5.1, BO Supervisor 6.5.1, Web intelligence6.5.1, Business Objects XIR2, Business
Objects XIR3.1, Java.
Operating System: Windows 2003, Windows XP,Windows 7,Windows 2008
Key Achievements:
• Designed a Java user automation piece which automatically adds users.
• Migrated XIR2 to XIR3 successfully. Involves 180 universes, 17000 reports, security and 16000 users.
• Proposed robust security model for different groups based on their requirement. A common security model was
approved for most of the groups except for few of the groups which had a special requirement.
• Designed Data privacy pages for different groups. (Involves customization of the BO login page).
• Got a Pat on the back for the best support 2008 and 2010.
• Got Pat on the back for submitting a white paper on the best promotion tool which includes NOAD and LCM.
• Got various client appreciations for best support/quick turnaround time.
• Best practices document.
• Building DR system and the documentation for the same.
• Setting up backups for repository database/server. Setting up therapeutic reboots for servers.
PERSONAL DETAILS:
Name : Venkatapathi Raju Penmethsa
Official Email Id: ******.*********@**.***
Personal Email: ****.*****@*****.***
Passport No : E8211936 Valid up to: 05/11/2014
Type of Visa holding: H1B Valid
Location
Client location: 3 corporate drive, Shelton, CT USA
Contact Numbers
Mobile: 203-***-****
Work: 203-***-**** ext.: 6366
Page 6 of 6
Contact this candidate