Developer Data
Resume:
Venkat S
Id:************@*****.***
Summary:
. 7+ years of Multi-Skill experience in System Designing, Analysis,
Application Development, Maintenance, Implementation, Project
Management and Database Administration on Oracle9i 8i, Oracle7.3, SQL
Server 2000, 7.0 platforms which Include 5+ years of extensive
experience of handling Data Warehouse project from analysis to
implementation stage.
. Over 1 Year of Experience in SAP Business warehouse reporting and Data
Extraction using SAP Rapid Marts.
. Knowledge of Business Objects Integration with SAP BI 7.0
. Over Six years experience in Implementation of Relational Database
(OLTP) and Data Warehousing Systems (OLAP) using Oracle, Business
Objects, Informatica and Datastage
. Five years of Business Objects, experience using Business Objects
Administration, Web-Intelligence, BO Developer Suite using SDK,
Application foundation,.Broadcast Agent, Auditor, Web Admin tool,
Supervisor, Designer, Web Intelligence/Info view
. Data warehouse experience is varied from Data Analysis, Dimensional
Data Modeling, Data Extraction Transformation & Loading (ETL), Building
Cubes, Creating Meta layer, Data Mining, End User Reporting; Web based
Reporting & Implementation, Creating Test scripts and user signoff
documents.
. Conducted End User Training on Business Objects
Reporter,Designer,WebIntelligence,Supervisor& BCA.
. Being Part of full life cycle of DW Project, gathered hands on
experience on Evaluation, Installation, Development, Maintenance and
Implementation of ETL tools such as Ascential (Ardent / Informix) Data
Stage & Data Integrator.
. Successfully developed and implemented various Data Modeling and
Reporting need for OLTP and OLAP using Power Designer, Designer
2000, Erwin, Business Objects, Web intelligence with SDK,Crystal
Reports XI, VB 6.0 and MS Access.
. Strong technical background, and posses excellent analytical &
Communication skills, Creativity, Leadership qualities, Team spirit &
above all a Positive attitude to shoulder successfully, any
responsibility or challenges.
Technical Skills:
Reporting Tools Business Objects XI r2/r1/6.5.1/6.1b/5.x/4.x,Crystal
Enterprise,Crystal reports (Desinger,Reporter,Supervisor),Web Intelligence/ Infoview 2.x,Broadcast Agent,
Auditor,Performance Management, Application Foundation
5.x,Webi SDK,BO SDK using ASP and JSP.
ETL Datastage 4.x/5.x/6.x, Informatica 6.0(Power Mart & Power
Center)
RDBMS DB2,Oracle 9i/8i/7, MS SQL Server 2000, DB2, MS-Access.
Internet J2EE, XML, Java Beans, Servlets, JSP, ASP, VBScript,
JavaScript
Languages Java2, PERL, C++, C, VB, Shell Scripting
OS Sun Solaris UNIX, Windows NT/2000.
Servers WebLogic Application Server 6.1 / 5.1 /
4.5,WebSphere 4.0.2/3.02, TOMCAT 3.2.1.
Tools ER-Studio 7.3.2.ERwin 4.1/4.0, MS Project, TOAD 6.5 and
SQL Navigator 4.1
Work Experience
CONOCO PHILLIPS NOV
09 to Present
BO Developer
Responsibilities:
. Installed and configured Business Objects Enterprise XiR2 Professional
edition in test and production environments.
. Troubleshooting the Business Objects 5.1.7 installation issues.
. Migrated Business Objects 5.1.7 version reports to Business Objects
Enterprise XiR2.
. Migrated Crystal Reports to BO XIR2.
. Tested the Business Objects XIR2 migration to ensure the reports are
functioning as per expectations
. Created new security for the migrated reports and users.
. Scheduled the crystal reports to users by email
. Resolved issues that were raised during the scheduling
. Created a document for the migration of Business Objects 5.1.7 to
Business Objects XI R2
. Wrote a Business Objects best practices document
. Utilized the capability of Aggregate Awareness to improve on query
performance
. Created Hierarchies on Region and Time classes and created customized
LOVs.
. Resolved the Loops by using Aliases and Contexts.
. Created customized prompts, cascading prompts and GUI based prompts with
VBA macros also developed the customized tool bars & functions to export to
excel.
. Developed Statistical Process Control Charts -SPC Analysis and standard
control charts, hazard plots, and automated reports.
. Designed, developed and maintained dashboard using Excel
. Generated various Drill down reports and Alerts. Business Intelligence
reports using Web Intelligence module.
. Generated ad hoc and canned reports for Business objects.
. Created reports for various portfolios using universe as the main data
provider.
. Created & tested reports using Business Objects functionality like
Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
. Created graphical representation of reports such as Bar charts, Pie
charts as per End user requirements.
. Developed Desktop Intelligence and Web Intelligence reports.
Environment: Oracle 9i/10g, Business Objects 5.1.7, Business Objects
Enterprise XI R2 Professional, Business Objects Designer, Web Intelligence,
and Desktop Intelligence, Windows XP/2003
Wells Fargo
Jan'08 -Oct'09
BO Developer
Responsibilities:
. Working with database connections, SQL joins, cardinalities, loops,
aliases, views, aggregate conditions, parsing of objects and
hierarchies.
. Designed Test cases for UAT of Reports for end users.
. Prepared user documentation for hand on training for en user
community.
. Designed Production System support and handling opened user cases.
. Tuning of SQL queries for better performance.
. Creation of different types of reports, such as; Master/Detail, Cross
Tab and Chart (for trend analysis). Use of filters, conditions,
calculations, etc.
. Involved in gathering business requirements & functional requirements
& data specifications.
. Upgraded Business Objects from xi r2 to xi 3.1.
. Upgraded repositories and migrated all reports and universes.
. Migrated web intelligence server, BCA & Auditor by split method.
. Designed Universes for the data Marts.
. Designed Prototypes for BO Suite xi 3.1 for Enterprise wide.
. Creation of reports like Reports by Period, Demographic reports and
Comparative Reports.
. Use of Analyzer and Explorer to view reports from different prospect
(Slice and Dice and Drill down).
. Macro coding using VBA for scheduling of documents thru BCA Server and
BOSDK.
. Scheduled reports to run and refresh daily using Broadcast Agent
Server.
. Testing of Reports and deploying over web.
. Installed Involved and configured Broadcast Agent Server, Auditor on
AIX system.
. Implemented Application Foundation and designed Dashboards &
Scorecards.
. Implemented Dashboard manager & designed plan analytics & predictive
analytics.
. Implemented web intelligence in distributed (clustered) Environment.
. Installed web intelligence with web logic as application server.
. Actively involved in gathering server sizing requirements for
software/hardware.
Environment: Business Objects XI 3.1(Designer, Reports, CMC), Web
Intelligence, AIX 5.1,TOAD, Oracle 9.2, VBA, PL/SQL., WEBI SDK, Application
Foundation.
ZIONS Bank, UT Mar'06-
Jan'08
Business Objects Developer
Responsibilities:
Finance Reporting Information Analysis (Data Warehousing)
. Designed & Implemented security architecture for Financial Group.
. Designed Universes and implemented Linked Universes technology.
. Designed Universes against Oracle warehouse.
. Written BO SDK, VB code for automation of Execution of reports.
. Implemented report bursting with Broadcast Agent Server and attached
vb macros.
. Designed universes for ad-hoc reporting capabilities.
. Designed and documented Meta data dictionary.
. Developed Complex Security set up for end users with Supervisor.
. Defined categories of documents for different level of groups.
. Installed the BO&WEB Intelligence on cluster environment.
. Developed several Oracle stored procedures and functions for reports.
. Installed BCA server on distributed environment.
. Implemented report bursting feature.
. Designed Universes for Financial Billing system and Order processing.
. Worked on Linked Universes by kernel approach.
. Designed Universe for Ad-hoc reporting.
. Maintenance of development & Production environments.
. Developed Full client reports and webi reports.
. Scheduled full client reports and webi reports.
. Customized webi by using WICOM component.
. Linked webi reports for different hierarchies.
Environment: DB2 UDB 6.1, macros, VBA, BOSDK, Business Objects 5.1, Web
Intelligence 2.6, ZABO, BCA & WI COM
American Re Insurance, NJ
Mar'05-Feb'06
Business Objects Developer
Responsibilities:
. Responsible for fitting Business Objects into the Information
Architecture of the company as well as supporting business users and
developing new and maintaining existing Universes.
. Installed and configured Web Intelligence & Broad cast Agent server on
AIX 4.3
. Developed CAN reports with PIE charts, BAR charts.
. Upgraded business objects from 4.1.4 to 5.0.
. Migrated repositories and domains and all user security structures.
. Migrated reports, scripts and universes and web intelligence 2.0 to
2.5.
. Designed universes with BO designer and implemented row level
restrictions with supervisor.
. Designed VB interfaces and integrated BO Full client reports.
. Written VBA macros and BOSDK for automation of execution of BO reports
. Scheduled reports with BAS.
. Plan, coordinate and execute Business Objects 5.0 deployment for End
users
. Train user community in basic and advanced Business Objects reporting
skills.
. Provide ongoing administration for the Business Objects 5.0
environment.
. Customized webi prompts
. Developed Budget reports for different level of users.
. Developed Budget vs. Actual reports for different periods in Oracle
reports.
. Created power users for different departments and assigned as
Designers and Supervisors
. Defined several categories for different set of reports.
. Implemented report bursting by using BAS.
Environment: Oracle 8.0, Business Objects 5.0, web Intelligence 2.5, ZABO,
BCA VBA, BOSDK
L&T Bombay., India.
Nov'03- Mar'05
Customer Revenue Reporting and Information System
Oracle Developer
This project was a MIS system developed for a power distribution company.
The system took care of the billing and reporting for the end customers.
The system was used to print and send bills to the end customers and also
track the payments. The system also generates management reports, which are
summary reports of all customers.
Responsibilities:
. Oracle 7 development DBA
. Installing Oracle 7 on Win NT 4.0 servers
. Developing Prototypes and analyzing.
. Involved in Logical and Physical Data base design
. Creating and managing the Databases
. Creating Users, Granting Roles, Privileges
. Controlling User Privileges and Roles
. Tuning application and writing efficient codes.
. Developing screens and report using Forms4.5/Reports2.5
. Designing and developing Packages and procedures in PL/SQL.
. User acceptance testing, training, Database and application tuning
Environment: Oracle 7.3, SQL, PL/SQL, Forms 4.5, and Reports 2.5, HTML
Contact this candidate