Customer Service Sql Server
Resume:
Sateesh T
Email: *******.****@*****.*********: 720-***-****
SUMMARY
* ***** ** ********** ** Information Technology.Including Business Requirement Gatherings,
•
Analysis, Design, Data Modeling, Development, Testing and Implementation of Data
warehouse/Business Intelligence using OBIEE 10.x/11g and SQL server 2005/2008
Extensive experience in implementing Business Intelligence and Data Warehousing solutions
•
for various clients across diverse business segments.
Strong understanding of dimensional Modeling, star and snowflake Schemas and ETL
•
processes that is the key to data Consistency and integrity.
Experience on OBIEE 11g Administration using Weblogic Administration console and Oracle
•
Enterprise Manager Fusion Middleware Control.
Experience in installing, configuring and administering the different versions of OBIEE and
•
Web Logic Server on windows environments.
Expert in developing Oracle BI Repository (.rpd)which consists of: Physical Layer, Business
•
Model and Mapping Layer, Presentation Layer.
Expert in developing Interactive Dashboards, Reports with drill-down capabilities using page
•
and dashboard prompts and other Web Catalog Objects such as Filters, Folders, iBots & BI
Publisher reports.
Expert in setting up and managing security in OBIEE 11g, 10g.
•
Implemented Data Level Security, Object Level Security and LDAP authentication.
•
Integrated OBIEE 11g with HTTP Server
•
Experience in setting up Multi User Development (MUD) environment.
•
Expertise in tuning performance by utilizing aggregate tables, materialized views etc
•
Experience in Administering the OBIEE environment including Installation, Configuration and
•
Setting up Authentication mechanism.
Profound Knowledge of Software Development Life Cycle and Software Testing Life Cycle.
•
A self-starter with excellent technical & communication skills and having radical and tactical
•
problem solving approaches.
Excellent problem solving and inter-personal skills with strong technical background.
•
Quick learner, able to work with conflicting priorities, excellent team player with the ability to
•
meet deadlines under pressure.
Technical Skills:
Business Intelligence: OBIEE Suite10.x/11g (Administration, Answers, Dashboards, Oracle BI
Publisher, BI Delivers, Web catalog Administration, Analytics Server administration), Oracle
Business Intelligence Applications (OBIA) 7.9.X
Databases: MSSQL server 2000/2005/2008, MS Access, Teradata
ETL Tools:Informatica power center 7.x/8.x/9.x, MSSIS, DAC
Data modeling: Dimensional Modeling, Star-Schema, Snow flake Modeling, Erwin 3.X
Languages: SQL, PL/SQL, C, C++ Web Technologies HTML, XML, JavaScript
Operating Systems: Windows 8, Windows vista, Win 95/98/2000/XP Windows server 2003.
WORK EXPERIENCE
OBIEE Developer
Virtela, Greenwood Village, COJune 2012 to Present
Virtela's comprehensive suite of managed services allows companies to connect their offices
globally, secure the network and applications, make applications run faster, and offload
management of their IT infrastructure.The company had to implement financial, procurement and
HR modules of BI applications to help better organize and quick decision-making. Virtela is
upgrading the existing OBI applications from its current version to the new OBIEE 11g and
developing new functionality in addition to the existing one.
Responsibilities:
• As a Developer, my role has provided me a wider scope in the life cycle of the project from
Creating and Analyzing the Business Requirements, Gathering New Business Requirements
from the respective Stakeholders.
• Participated in complete life cycle of the project from project initiation, to development, to
production support and maintenance.
• Worked on OBIEE Administration tool for customizing the Physical layer, Business layer,
Presentation layer and modifying it according to the business requirements.
• To create RPD, connection pools, import physical tables and define joins in the Physical
Layer.
• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies) &
Logical objects in Business Model Layer, and creating the Presentation catalogs in
Presentation Layer.
• Created Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design
the dashboards.
Created Security settings in Oracle Administration Tool to set up groups, access privileges
•
and query privileges and also managed security for groups in BI Answers.
Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-
•
downs and links to exploit the full benefit of Analytics in providing reports.
Created & saved several BI Publisher reports by selecting an Answers request as Data
•
Source.
Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table
•
execution path by making use of hints, Creation/Re-building of Indices and Cache
Management.
Worked on Oracle 11g, SQL Server 2008 for getting the financial data.
•
Created comprehensive and easy-to-understand Documentation (Functional Specifications,
•
Technical Specifications and Mapping Documents) of the complete implementation of the
Customer Sales Business modules (Reports, Dashboards, Security and Star schema)
Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the
•
Data warehouse to the values in the Reports/Dashboards, documented the test results.
Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Oracle BI Publisher,
Oracle Delivers, Windows XP, SQL server 2008 and Microsoft SharePoint.
OBIEE Developer
Cummins Inc, Columbus, IN June 2011 to May 2012
Cummins Inc. is a global corporation of complementary business units that design, manufacture,
distribute and service Engines and related Technologies, including Fuel systems, controls, air
handling, filtration, emission solutions and electrical business systems. The project was to gather
employees' details and maintain the staff information in one database. We also have maintained
personal record of the employees and generating the reports monthly, quarterly, half year and
yearly basis.
Responsibilities:
• Involved in user requirement and requirement specification from users.
• Documenting business requirements, functional specifications and test requirements.
• Involved in RPD Development, Oracle BI Server and Oracle BI Answers.
• Identified and Designed Star schema for fact & dimensional tables and created alias for the
dimensional tables when necessary.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle
BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions and involved in
Configuration of Web Catalog Security and Cache Management.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters and provided customized prompts to avoid excessive data showing up in the
reports.
• Identified Financial Analytics facts, dimensions & star schema models of workforce profile
subject area.
• Used catalog manager to migrate custom dashboards, requests, filter and prompts to
Integration & Prod environments.
Environment: OBIEE 10.1.3.4.1/11g, SQL server 2005/2008, Oracle BI Publisher, Windows XP,
WSr.
OBIEE Consultant
Unilever Best Foods, NJ January 2010 to May 2011
Unilever is a consumer goods company with world famous brands. The company wanted all its
data to be globally adequate for the entire decision making. Oracle Consumer goods were being
implemented which needed some configurations to the custom RPD and Catalog.
Responsibilities:
Gathered the requirement, Designed, Developed and Tested Physical Layer, Business
•
Layer and Presentation Layer of OBIEE • Worked on Custom built sources within the
Company to get understanding on the Data which in turn provides the insight on
Requirement
Worked on High Level Design Solution required for creating OBIEE Metadata Layer (RPD)
•
Worked on OBIEE Administration Tool End - to - End, which includes importing data,
•
creating connection pools to multiple data sources, developed Physical Layer, Business
Model and Mapping Layer and Presentation Layers.
Setup Multi User Development Environment (MUDE) in OBIEE
•
Worked on RPD, Creating Level based Hierarchies, Level Based Measures, and time
•
series measures, Creating Aliases, Creating Logical Table Sources, Created Initialization
Blocks and Variables, Data Level Security, User Level Security
Worked on OBIEE Analytics Module which includes developing the Reports and
•
Dashboards for Requirements provided by the Stake Holders.
Created complex Analysis reports in OBIEE using the Answers Module • Created
•
Dashboards, Dashboard Prompts, Navigational Reports, Guided Navigation Reports,
Automated iBot Queries, Customized BI Publisher Reports
Developed Mappings and Workflows and executed them on multiple sources using various
•
Transformations and loaded the data into targets. ‘
Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4/11g, Data
Warehouse Administration Console (DAC), Oracle BI Publisher, Oracle Delivers, Windows XP,
SQL Server 2005.
OBIEE Consultant
HSBC Bank - Kolkata, West Bengal December 2008 to January 2010
OBIEE Platform Solutions was implemented for providing interactive Dashboard access to
strategic business information on services, finance and top of the house from the company-wide
data warehouse analytical information in mortgage at HSBC Bank, a leading financial services
company.
Responsibilities:
Worked closely with Business Analysts in understanding the Analytics requirements and
•
created Business Models for generating Reports as per the requirements
Responsible for creating Proof of Concept (POC) with Oracle data sources.
•
Created and Administered the Physical Layer, Business Model and Mapping Layer and
•
Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-
•
Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters
using Oracle BI/Siebel Analytics Web
Extensively used Repository Variables, Session Variables and Initialization Blocks for
•
Configuring the Data and user Security
Created Filters and provided customized prompts appropriately to avoid excessive data.
•
Developed Accounting and Collection Time Series Object (Oracle BI Time-Series
•
Functions) for comparing the Billings, Collections and Adjustments.
Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool
•
and verifying the Permissions of the users in Siebel Analytics web
Enforced Row Level Security for Managers to View the Reports pertaining to their Region
•
Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance
•
Gains.
Performed Tuning of Dashboards/Reports by aggregate navigation, and cache
•
management.
Worked on OBI Delivers and configured iBots to deliver Analytics content based on a
•
schedule.
Worked extensively on Oracle BI Publisher and provided the capability to download the
•
reports in the user defined formats
Responsible for unit testing, integration testing of the reports generated using Siebel
•
analytics.
Environment: Oracle Business Intelligence 10.1.3.3, Oracle Delivers, Windows XP, SQL Server
2005, MS Access and MS Excel.
Database Developer
Hewlett-Packard, India February 2006 to November 2008
HP- Compaq is a technology company which operates internationally. This Business Intelligence
application was intended to develop a data warehouse and a reporting system, which effectively
reports customer behavior for marketing campaigns, analyze sales from the website and epos, it
also monitors and reports order management issues at the sales call center and customer service.
This improves decision making for financial, marketing management, customer service teams.
Responsibilities:
Analyze data model and requirements from an Application Architecture Repository and
•
Framework standpoint.
Developed custom reports/Ad-hoc queries using Oracle analytics and assigned them to
•
application specific dashboards.
Created and Administered the Physical Layer, Business Model and Mapping Layer and
•
Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance
•
Gains.
Used windowing functions in Oracle to analyze data and generate reports.
•
Developed different kinds of reports (pivots, charts, tables).
•
Created groups and added users to the groups and granted privileges explicitly and
•
through group inheritance.
Environment:Oracle Business Intelligence 10.1.3.2, SQL server 2005, Windows NT 2000/XP.
EDUCATION
Bachelor of Science (4 years degree)–Osmania University, India
Contact this candidate