Sandeep Maditeti

***** **** **** ******

Centreville,VA 20121

M: 571-***-****

E: acq7me@r.postjobfree.com

Career Objective

I eager to use my strong customer service experience and communication skills to provide outstanding service to a range of clients. I am keen to develop new skills to complement my studies and to progress in the software industry.

SKILLS INVENTORY

Having experience in OBIEE 11.1.1.5, 10.1.3.x, which includes Administration tool, Intelligent Dashboards, Answers, Delivers, iBots, Oracle BI Publisher.

Extensive experience in designing Star & Snowflake Schema, Slowly Changing Dimensions, Facts, Dimensions tables.

Experience in using OBIEE Answers for creating different Requests, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts.

Installed and configured different versions of OBIEE & Informatica.

Very strong experience in building Siebel Analytics/OBIEE Repository (.rpd file) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer) using Administration Tool.

Experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures and Repository Variables.

Experience in security tasks like creating user groups, users and managing users by setting up their privileges and profiles.

Experienced in upgrading the Meta data (rpd) and catalog from OBIEE10g to 11g.

Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, COBOL files, XML, DTD, XSD files, legacy system files etc.

Expertise in Business Model development with various functionalities like Hierarchies, Measures, Aggregation Rules and Time Series.

Experience in implementing Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables.

Strong expertise in Implementing MUD (Multi User Development) Environment.

Good hands on experience in using BI Publisher to create reports from BI Answers, BI server.

Working experience in using OBI Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.

Knowledge over BI Publisher on converting Oracle Interactive reports, crystal, or actuate to BI Publisher.

Expertise in converting and using Oracle pre-build Rpd’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) according to business requirements

Expert in writing SQL queries, creating different PL/SQL Objects, Fine Tuning the code, and also in using SQL*Loader for loading data into Data Warehouse/Data Mart.

Experience in preparing Technical Documentation & Training Users on DW/BI Products.

Experienced in Debugging, Optimizing and Performance Tuning of Oracle BI (Siebel Analytical) Dashboards / Reports to improve performance at Database.

Education

Masters in Computer Science With Distinction

North Western Polytechnic University, Fremont, CA

completion date : April 2015

Bachelor of Technology(Computer Science) With Distinction

Jawaharlal Nehru Technological University, India

completion date : April 2013

Key Skills

Interpersonal skills

I have extensive experience in customer service, which has helped me to develop strong interpersonal skills. I get along well with others and always conduct myself with the utmost professionalism.

Communication skills

I am a confident communicator, having developed strong verbal communication skills in my customer-facing roles. I am able to clearly provide information and interact with customers in a friendly manner.

Ability to work in teams

I have worked in team environments for over three years. In my current position, I work with a small team of eight staff who specialize in print and copy projects. We are a self-managed team who coordinate all customer projects in our department to deliver a great result to the customer.

Multi-tasking

The Copy Jet print and copy department is a busy environment in which I have had to quickly develop the ability to effectively multi-task jobs in order to manage my various responsibilities. I am able to manage my time and work without supervision.

Technical Skills

Operating Systems : Linux, UNIX, Windows XP, Windows NT, Windows 2000, MS-DOS

Technology : Build and Release Management /Quality Testing/ OBIEE

Languages : Java 1.5, Struts, Servlets, JSP, HTML, JDBC, Hyperion, Crystal reports, ASP.net. I-Report, Python

Other Languages : XML, HTML, XSL, XSLT, CSS

Scripting : JavaScript, Shell Scripting,,SQL Scripting

Databases : MS-Access, MYSQL 5.0, Oracle 9i/10g/11g, SQL Server 2000, DB2

IDE & Dev Tools : Eclipse2.3, My Eclipse 5.1, Rational Application Developer7.0, Toad

Version Control : Subversion, SVN, Puppet

SDLC & Testing : Agile Methodologies, Scrum Process, Manual Testing, JIRA

Employment History

June 2014 - July 2015

OBIEE Developer, USM Business Systems

Fairfax, Virginia

Responsibilities :

Involved in the installation of different OBIEE components.

Created a multi-user developer environment (MUDE) to enable multiple developers to work on one repository.

Worked on OBIEE publisher to publish the reports in different formats.

Configured and scheduled iBots to deliver the weekly and monthly reports.

Involved in developing the dimensional modeling of STAR schema with fact and dimensional tables.

Designed and developed the Metadata Repository (.RPD)(Semantic layer) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer using connection pool,

Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.

Created Aggregated Tables and configured the content in Business Model Layer to use the Aggregate tables for better performance.

Business requirement gathering, understanding business objectives and analysis.

Involved in Capturing User Requirement using technical specs.

Creating reports and publishing them in the dashboards using answers

Involved in the removing the duplicate hierarchies and duplicate fields in the business layer when extract a query from the physical layer

Performed OBIEE Administration – including creation of Users and cache management

Implemented caching to improve performance

Granting access to users and maintain security by using database authentication and authorization.

Developed various report templates for different types of formatted reports.

Created Alias Tables, Views and Dimensional Hierarchies.

Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.

Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.

Developed 11 Dashboards / 53 Reports using different Views (Table, Pivot Table, Chart and Column Selector), with guided navigation and dashboard and page prompts.

Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization’s and product’s hierarchies

Extensively used SQL queries, Procedures, Triggers.

Develop and maintain the documentation to support the team and business

Responsible for the fixation of the errors in data as part of testing

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.1, Windows XP, UNIX/LINUX, BI Publisher, Oracle 11g/10g, SQL, PL/SQL, and TOAD 9.7.2

May 2013 – December 2013

SQL Developer, Copy Jet

Hyderabad, India

Responsibilities:

Understand and evaluate UNIX, SQL and or Data Modeling.

Design and develop T-SQL procedures, query performance tunings and SSIS packages.

Develop underlying data models and databases.

Develop, manage and maintain data dictionary and or metadata

Ensure compliance of standards and conventions in developing programs.

Create complex analytic queries on large data sets

Create stored procedures, triggers, and functions

Analyze trends in key metrics

Generate code to extract, transform and load data from production data sources to the data warehouse

Performance tuning of key queries.

Maintain uptime demands on the BI system

Design, develop and implement complete life cycle of data warehouses.

Translate business requirements into software applications and models.

Resolve and troubleshoot complex issues.

Perform and execute data extraction, transformation and loading using ETL tools.

Maintain and manage all versions of data models for production, testing and developing databases.

Create Reports and Dashboards Related to the Project Requirements.

Experience on Writing the pl/sql stored procedures, triggers, functions .

Interests

Learning new Programming skills and scripting languages.

Attending Seminars and Conferences to gain Knowledge on new Technologies

Surfing Net regarding the new Technologies Available in the market

Contact this candidate