Seshagiri.R.Achar

E-Mail: giri.achar@gmail.com Ph: +91 9701215751

PROFESSIONAL SUMMARY:

 3+ Years of IT Experience in Data Warehousing.
 Thorough knowledge on data warehouse concepts.
 Hands on exposure in Datawarehousing using Business Objects (Designer, Business Objects).
 Designed & developed various universes, reports, Documents, charts and graphs using Business objects.
 Knowledge in OLTP tool Informatica.
 Having good knowledge in Oracle 8i.
 Self-motivated, adaptive to new technologies, team player with good interpersonal and communication skills.

TECHNICAL SKILLS:

ETL Tools : Informatica 5.1/6.1
OLAP : Business Objects 6.5
Programming : C, C++, SQL
Operating System : Win NT/ 2000/ XP
Database : Oracle.

EDUCATIONAL DETAILS:

 Master of Science (Operation Research & Statistical Quality Control) from Sri Krishna Devaraya University in 2004.
 Bachelor of Science from Sri Krishna Devaraya University in 2002.

PROFESSIONAL EXPERIENCE:

 Working as a BO Developer in Polaris, Hyderabad from Nov 2005 to till date.
 Worked as an ETL Developer in Innova Solutions, Hyderabad from May 2004 to Oct 2005.










Project #1:

Client : FAIRFAX
Operating System : Windows 2003 Server
Tools : Business Objects 6.5, Oracle 8i
Role : Team Member

Description:

Fairfax is a store in North America the main function of Fairfax inventory store is to buy different products from different suppliers in the form of categories and pass all the products which are purchased from suppliers to the customers according to their Orders. The ordered products ate sent through shipment. Ordered products are delivered by employees of Fairfax. To know the actual function done by year-wise, monthly as well as about the orders.
The reporting tool is Business Objects business intelligence software.

Responsibilities:
• Specified the Joins and checked the cardinalities.
• Resolved loops by creating Aliases and Context. Performed the Integrity checking
• Created different types of reports like tabular, cross tab and Charts
• Created Reports based on the RDD specifications provided by the client.
• Created the reports using Business Objects based on Data Providers like Universes and Freehand SQL etc..
• Modifying the existing Universes, Adding new objects.
• Created Alerters using Business objects to highlight the columns based on business criteria.

Project #2:

Title : Creditor MI
Client : Norwich Union, an Aviva company
Operating System : Windows 2003 Server
Tools : Business Objects 6.5, Oracle 8i
Role : Team Member

Description:
Norwich Union Insurance is a leading in selling insurance to variety of customers across UK, the data mart is build to capture all the creditor information for strategic reporting.
Responsibilities:
• Analysis of reporting requirements.
• Developed Universe using Designer module in Business Objects.
• Specified the Joins and checked the cardinalities.
• Resolved loops by creating Aliases and Context. Performed the Integrity checking
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.

Project #3:

Title : Sales Data Mart for Disney Auctions
Client : Walt Disney, USA
Operating System : Windows NT
Tools : Oracle 8i, Business Objects 6.5
Role : Team Member

Description:

The warehouse maintains Disney’s auction data, and maintains Sales, Inventory Transactions data and Vendor details for various products. Hierarchy is maintained for Product and Time dimensions.

Responsibilities:
• Data Extraction.
• Developed Universe using Designer module in Business Objects.
• Created Multi-Dimensional reports using Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers using Business Objects reports.
.
Project #4:
Title : Marketing Information, DWH
Client : CFL (Classic Foods Limited), USA
Environment : Oracle 8i, Informatica Power Center 6.1

Developed business intelligence solution for CFL USA, CFL is in the business of manufacturing goods and beverages with factories all over the globe. This has many products with different flavors and the product sale is through many channels like CSD, institutional and Dealership including North America, Africa, Asia pacific and Europe. For better enhancement and decision support we store all region data into a centralized data warehouse, which extracts data from different sources or database and store it in a well managed format so that reporting on historical data like comparison and growth over previous period and drilling will be faster and easier.
Responsibilities:
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, and Expression Transformations in Informatics.
• Involved in creating, editing, and scheduling of the Sessions in Informatics.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Tool.
• Optimizing Various Mappings and Sessions to resolve bottleneck.