Business Objects, Datawarehousing Resume

Title
Business Objects, Datawarehousing

Primary Skills
Business Objects, Teradata, Oracle, Data Integrator

Location
India-Bangalore (will consider relocating)

Posted
Jun-09-09


A dynamic professional with almost 8yrs of IT experience developed from a solid background in Reports Designing, Database Designing, Data Modeling, Performance Tuning, ETL-BODI & Reporting tools(BO), Worked extensively on Oracle, MS-SQL, MySQL and Teradata with front ends like BO and web.

TECHNICAL SKILLS:
Databases : Oracle 9i, Teradata, SQL Server 2000, MySQL MS Access
Programming Languages : SQL, PL/SQL
Tools : Business Objects Reporting, Data Integrator & Set Analysis
Crystal reports/Web-PHP
Operating Systems : Ms-Dos, Ms-Windows 2000 /2003 server, Linux /Unix


Accenture Services Pvt Ltd :

I have joined Best Buy(Client) as for an ETL Project Tax Data Retention (TDR) for Best Buy Finance, which has multiple data sources like Ciris, Sabrix, Vertex. Tools used for this project are Informatica, Teradata & Business Objects.

AOPO:Aligned Operational Performance Objectives:

This project is about the generating a detailed Profit & Loss A/c w.r.t Budgets/Forecasts/Actuals report in BOBJ which has almost 2000 objects and to be viewed by Best Buy's Finance Decision makers. The entire report has data at Monthly, Quarter & Yearly levels, with Date, Channel, Operating Group etc as Filters. Also there are several filters defined to restrict the report run time. Tools used for this project are Teradat Data, Business Objects, TVA Cycle Results.

After getting the business requirements from Onsite visit for 3months, we have developed the biggest report for Best Buy in a duration of 21days and successfully delivered.
BBYM: Best Buy Mobile:- A short term project to populate the base tables in EDW for a a new product launched by Best Buy. Tools used Informatica & Terdata Data-BTEQ, Maestro & Wrapper Scripts.
Overall Project Management: Co-ordinating with business people for regular Business requirement clarifications, Estimating Resources required/man hours to execute the above projects along with preparing weekly/daily status reports.

Essbase Cube: This is one of the critical projects of Best Buy Finance,which extracts data from Warehouse and sends the extracts to Business in a Structured format thru SFTP. Tools used are BTEQ, TPT, Wrapper Scripts, SFTP & Maestro.
With an intelligent Batch Job Architecture starts extracting data after regularly monitoring the updation of Finance related database tables executes the Batch. The entire Batch process is scheduled for four times in a day which executes automatically at intervals. Once data is extracted, there is a DQA Check BTEQ which performs the data quality fixes and thereby loading into Staging Table. After loading into a Stage Table, TPT extracts data in a Transpose format as per the business requirement, the extract file transferred to the Business Location by SFTP to a windows folder from Unix Box. After successfull transmission of the extracts, the next batch job renames the existing file with a date for archiving.


Client/Company: Accenture Services Project: WaMu Project Duration: Oct. 2007 - Nov. 2007
Role Description
Responsibilities
* Designing the BO reports' Layouts.
* Data modelling w.r.t Marketing Resource Management Implementation.
* Data mart design as per the reports.
* Universe design for the MRM reports.
* Managing a team of 7 members w.r.t. the team's activities, assigning tasks & deliverables.



Wipro Technologies: Jan-07 --Sep07 - Data warehousing
• Database Design & Data Modeling for Intel Health Care
• Preparing a schema model for Data warehousing
• Providing support for existing Data warehousing applications.

Bharti Airtel: Team Leader for Data warehousing / OLAP -Nov 05 --Jan-07:

• Creating universes, users, views, daily database updations by retrieving the data from various data sources as per the requirement of day to day Telecom business requirement.
• Customizing new reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Standardizing the reports by minimizing the manual intervention with the help of stores procedures & Packages.
• Publishing new reports to the users from the central data warehouse.
• Maintenance of Database -- adding data files, archiving, backup & recovery.
PROJECT DETAILS:
Project Name : Revenue per sub/MOU/Pulse
Role : Team Leader
Duration : Sep -06 to Dec-06. -- 4months
Environment : Business objects, Oracle
Team Size : 4
Description :

To develop a platform where business heads & regional heads can monitor the performance of a region/area (eg Region->State-City-Zone-Area Manager-Account Manager)
Responsibilities:

? Identifying the Scope of the reports as per the respective region
? Identifying the data sources required to generate the high level business performance report.
? Synchronizing all the data sources (like Lotus notes, Arbor, CDR, Oracle Financials-GL) to get merged in a single data warehouse.
? Designing the database & Normalizing different tables into a standard data structure.
? Due to heavy size of the databases of difference sources, table partitions have been used to enable quick processing of queries.
? Merging different tables into a single materialized view to keep up the pace.
? Implementing the business logic to calculate the revenue/mou per sub, of each region/area.
? Developing a web portal where request for drill downs and analysis of the overall reports with a ticket id & expected solution in hours based on the category.
? Creating Universes as per the required reports in BO with the help of Designer.
? Creating users & granting access to use & publish reports thru BCA.
Project Name : Revenue Analysis
Role : Team Leader
Duration : April -06 to Sep-06. -- 6months
Environment : Business objects, Oracle, Teradata
Team Size : 4
Description : Post acquisition of a customer/account, the account has be tracked on daily for revenue usage-DEL & DSL. E.g. Oracle corporation will 1000 dels and to monitor the performance of that account some daily tracking of revenue is important to measure the growth in the business.
Responsibilities:
? Identifying main corporate accounts out of the entire sub-base of customers.
? Segregating the accounts into classes as per the business requirement and depending on their revenue generation.
? Automating the entire process of new corporate account acquisition & assigning the master code as per the respected group.
? Data modeling & staging of the CDRs at regular intervals and there by loading to the database.
? Cleaning the data as per the required format with the help of cursors on daily basis.
? Designing the revenue analysis reports structure with the help of SQL queries & views.
? Testing the reports in the business objects & there by releasing them to the users.
? Publishing the reports with the help of BCA in business objects.

Project Name : Sales & Marketing Reports
Role : Team Leader
Duration : Dec-05 to March-06. -- 4months
Environment : Business objects, Oracle
Team Size : 4
Description :
The system is developed to automate the entire process of reporting thereby helping top managers to watch sales online. This was created with the details of data related to sales Representatives-SAF-DEL & DSL, Billing & Credit Control-Arbor, and CDR & DSL Usage .
Responsibilities:
? Analysing business requirement and drill downs required for development of the project
? Documenting the requirement and the database design
? Designing table structures and materialized views for publishing the reports.
? Staging the data for cleaning & accuracy from the production server to warehouse at a schedule time with the help of stored procedures.
? Designing the universes required to get the data in the desired format to get published.
? Developing the reports in Business Objects using complex SQL queries & materialized views.

Dalmia Consumer Care Pvt Ltd May-03 to Nov-05.

Worked as Regional IT Executive for South - Oracle Database & SQL Developer
Installing Oracle 9.2.0 at the central data warehouse and creating databases for daily Sales tracking
Project Name : ERP Implementation
Role : Regional IT Executive
Duration : Feb-04 to Oct-05-- 1yr 8months
Environment : Oracle -- VB . NET
Team Size : 2
Description

To develop an ERP which can track both primary & secondary sales upto the distributor level, online sales tracking, customer & payment tracking, stocks & delivery of stocks to the customers

PROJECT DETAILS:
Responsibilities:

• Identifying the business logic for the ERP implementation.
• Finalizing the project with the vendor
• Preparing documents related to the business logic & the production
• Interacting with the client to get the desired output within the specified time
• Updating the client with the respective departments requirement
• Preparing docs for the changes in the ERP
• Writing SQL stored queries for the web based ERP along with vendor for final optimization with the database.
• Tuning the ERP queries developed by client to generate correct output
• Backup & disaster recovery management for the ERP & its performance
• Developing the web a web based application to track offline sales tracking with the help of Oracle & PHP.
• Designing web based reports up to the least granularity.
• Testing both web reports & ERP for production
• Implementing the ERP at all 4 locations across south India.

Project Name : IT Infrastructure Mgmt
Role : Regional IT Executive
Duration : Jun-03 to Dec-03-- 6months
Environment : Windows 2003 Server, Oracle, Linux
Team Size : 2
Description
To develop a new setup of IT infrastructure in entire southern region at four locations, with a capacity of almost 450 users.
PROJECT DETAILS:
Responsibilities:

• Identifying the different locations & the respected no. of users.
• Procuring hardwares -- servers & LAN/WAN Implmentation
• Vendor finalization for VPN Connectivity
• Installing Windows 2003 server & Oracle 9i as database
• Creating users and defining policies for database users.
• Granting access to the different tables & creating views as per the requirement.
• Backup & disaster recovery management
• Database Monitoring for space utilization & Table Space Administration.
• Backing up Archive Redo Logs
• Business continuity and disaster recovery planning

Gillette India Ltd- SAP-ERP Implementation, Business Objects/Oracle 8i Aug 2000 to May-03
Project Name : SQL Developer
Role : IT Executive
Duration : Aug-2000 to May-03
Environment : Windows NT Server, Oracle, Unix
Team Size : 1
Description
To support entire IT setup of Gillette at East zone
• Maintaining IT infrastructure across East Zone with 380 users
• SAP Implementation across East Zone with almost 120 users
• Giving dump thru SQL queries to MIS team for daily business reports
• Understand the business requirement & fine tuning the sql queries.
• Client Architecture, configuration and maintenance.
• SAP-Business Objects training to all the users
• Exporting the output in excel to the users to generate MIS reports.
• Transporting data East zone related to the local server for faster access to Oracle
• Daily updations in the database



Mukund International Pvt. Ltd
Aug'99 to Aug '2000 - Systems Administrator
Responsibilities • Maintaining Active directory-creating users/LAN/WAN/TCP/IP
• Windows NT server & Client Administration
• Backup and recovery policies
• Maintaining antivirus updates
• Managing the data communication network of MIPL
Environment Windows NT/ Win 98 / Microsoft Exchange

Educational Qualification : Presently undergoing MCA from ICFAI University.
B.Com (Burdwan University, West Bengal)


Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Bangalore, India | Resumes in India

View other Business Objects, Datawarehousing resumes, Programmer / Developer resumes