Post Job Free

Resume

Sign in

Sr Developer & Analyst

Location:
Grand Rapids, MI, 49512
Salary:
$90K
Posted:
October 23, 2011

Contact this candidate

Resume:

Srikanth Vegasina

Email: neak4d@r.postjobfree.com

510-***-****

Summary

• 9 Years of experience in IT Industry and End –to–End (Business Users Requirements, Systems Analysis, Design, Development, and in Testing) implementation of Siebel Analytics / Oracle Business Intelligence Enterprise Edition (OBIEE).

• 4 years of experience in Oracle Business Intelligence Enterprise Edition (Answers, Dashboard, BI Publisher).

• Extensive experience in BI Publisher, which includes working on report development objects like data templates and RTFs.

• Configuring metadata and building Oracle Business Intelligence Repository consisting of three layers (Physical Layer, Business Model & Presentation layer) and creates business reports.

• Extensive experience in configuring Interactive dashboards with drill-down capabilities, Security Setup, Metadata Objects and Web Catalog objects.

• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules Time Series.

• Expertise in complete life cycle implementation of OBIEE with Star and Snow flake schema.

• Experienced in DAC to configure, monitor and schedule ETL routines.

• Configured and modified several mappings from multiple sources like Siebel CRM, PeopleSoft, Oracle 10g, Oracle Financials 11i, XML, flat files and loading data to OLAP systems.

• Expertise in Oracle PL/SQL Programs, Procedures, Functions, Triggers and other objects.

• Excellent communication skills and experience working with the business users.

Educational Qualification

PGDCA (Post Graduate Diploma in Computer Applications)

BE (Bachelor of Engineering).

Technical Skills

BI Tools OBIEE 10.1.3.x, Siebel Analytics 7.7

RDBMS Oracle 10g/9i/8i, SQL Server 2000/2005

Languages SQL, PL/SQL, C#, Java

Operating Systems Windows 2000/2003/NT/XP/98/95, UNIX, Linux

Tools TOAD, SQL Developer, SQL *Plus, PL/SQL Developer, People code, PS Query.

Web Technologies HTML, XML, CSS, JavaScript, Vb.NET

Other Tools Informatica Power center 8.x DAC

ERP PeopleSoft 9.0Finance/HRMS, Oracle EBS ,Seibel CRM

Project Synopsis

Client: Amway, Grand Rapids, MI

OBIEE Developer April 2010 – Till Date

Description: This project is for ANA (Amway North America), Implemented Oracle Business Intelligence for Sales and Financial.

Responsibilities:

• Reviewed Technical design document.

• Worked with DBA on database architecture design and data model design for Data warehouse and Data Marts.

• Created/Modified/ Customized Metadata repository (.rpd) and Configured Metadata Objects using OBIEE Admin tool.

• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and created customized repository variables for the users.

• Developed several Interactive Dashboards with drill-down capabilities, pivot tables, charts, and tabular reports using OBIEE Answers.

• Worked closely with Users, to resolve ongoing Production Problems by reviewing design changes made to production systems.

• Created custom JavaScript and HTML templates for implementing additional web interface to OBIEE Dashboards

• Designed and developed security settings like data visibility based on position and login of the User in a Stand-Alone environment.

• Configure and scheduled iBots for daily sales trend reports.

• Designed and developed the various Sales and Marketing Trends Dashboards/Reports that are Dynamic & Interactive with drill-down capabilities and filters and cache monitor using Siebel Analytical Web.

• Converting Micro Strategy reports in to OBIEE.

• Created reports for Executive Directors on Dashboard for Daily and Monthly Revenue and

Renewal and Activation Details.

Environment: OBIEE 10.1.3.4.1, OBIEE (RPD, MUD, Answers and Dashboard) SQL Server 2008,

Seibel CRM, AS 400 , Oracle EBS , Micro Strategy Desktop 9.0.1

Client: New York State Govt. Albany, NY

OBIEE Developer Sep2010 – March 2011

Description: SFS, New York State Financial System, Implemented GL, AP, AR Financial Analytics.

Responsibilities:

• Worked closely with the PeopleSoft Functional Team in understanding the requirements and created the business model for generating reports as per the user requirements

• Modelling activities which included star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. Established the logical joins/Keys required to support drill-down aggregation.

• Configured charts, views, filters in user interface. Configured Global Filters and Prompts in OBIEE Web.

• Developed several Interactive Dashboards with drill-down capabilities, pivot tables, charts, and tabular reports using OBIEE Answers.

• Developed many BI Publisher reports (with parameters) with different layouts using BI Publisher plug-in for MS-Word.

• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Query Tables, Table execution path by making use of hints, Creation / Re-building Of Analysis of Business Requirements.

• Created RTF templates in Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.

• In BI Publisher, created Layouts and exported report output in PDF, EXCEL.

• Create reports on BI Publisher and Dashboards for GL, AP, and AR.

Environment: OBIEE 10.1.3.4.1, BI Publisher, BI Office Plug-In, PeopleSoft 9.o Financial, PeopleSoft Query, SQL Developer, SQL, Oracle 11g, Windows.

Client: BART, Oakland, CA Oct2009 – Aug2010

OBIEE Developer

Description:

This is project is for BART (Bay Area Rapid Transit) , We implemented GL and AP Financial Analytics and HR (Absence , Compensation , Work profile) , Operating Expense ‘s and Spend per Headcount ( Regular and Temp employees ) showing different Reports sliced , Diced and Secured across Management .

Responsibilities:

• Reviewed Functional Design Document and Technical Design Document.

• Worked closely with Business Analyst, Discussed and Gathered the Analytics requirements from different user groups.

• Worked in repositories Physical Data Layer, Business Model and Mapping Layer and Presentation layer using Siebel Analytics Administration Tool.

• Customized the logical tables and columns, defined the Analytics dimensions, aggregation and levels.

• Created Dimensional Hierarchy, level based Measures and Aggregate navigation in BMM layer.

• Implemented security by creating users groups, creating session variables and initialization blocks and associating catalog objects with the created groups.

• Configured Repository and session variables to get dynamic reports and dashboards.

• Configured charts, views, filters in user interface. Configured Global Filters and Prompts in Siebel Analytics Web.

• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Query Tables, Table execution path by making use of hints, Creation / Re-building Of Analysis of Business Requirements.

• Developed many Time-Series objects for tracking and performing the trend analysis of new card uses.

• Created RTF templates in Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.

• Design and developed Dashboards like Revenue, Expenses, Hire to retire with three levels of aggregation drilling across using Dashboards Links, Guided Navigation.

• Used OBIA packaged solution and customized it as per business requirement

Environment: Oracle Business Intelligence EE- 10.1.3.4.1,BI Publisher, Informatica Power Center 8.6.1, DAC, (OBIA)BI Apps 7.9.6 , Oracle 10g, SQL Developer , PeopleSoft 9.0 ,Windows, Unix .

Client: McKesson, San Francisco, CA Aug2008 - Sep2009

OBIEE Developer

Description:

McKesson executives receive (Daily Operating Report) .The DOR reports allow the executives to view operational key performance indicators such as Revenue, Expenses, Cost of Sales. It also shows a breakdown of these three reporting areas into “Divisions. The requirements from the executives are to have interactive dashboards with “navigation” capabilities for Revenue, Expenses and Cost of Sales areas of various Business Units. The requirements include the comparison of Week Ago and Month-to-date metrics. To meet this requirement we created the dimensions and facts required and did RPD development by creating new measures, logical columns and finally dashboard development using OBIEE.

Responsibilities:

• Worked closely with the Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.

• Installed and configure Informatica/DAC environments for BI Apps Order Management

• ETL Design mappings, sessions and workflows using Informatica. Designed Custom ETL execution plans, subject areas, and tasks using DAC

• Created dimension hierarchies and assigned levels and custom aggregation rules for each level.

• Involved and developed various steps to improve the performance of the queries used in the reports by having aggregate tables.

• Designed and Configured Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager.

• Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs Revenues and contact Relationship Management to analyze the financial services center statistics.

• Created reports for order to cash, Including Invoices, Sales Effectiveness and Customer reports and created Hierarch for Product etc.

• Developed custom reports/Ad-hoc queries using Siebel Answers and Filters.

• Used workflow manager extensively to create tasks, worklets, and workflows and executed the tasks.

• Used DAC to configure and monitor the sessions and also ran weekly loads to update the data within the data warehouse.

• Extensively worked in developing and configuring Facts mappings and Dimension mappings for the generating data in data warehouse

• Involved in the unit testing, integration testing of the reports generated using Siebel Analytics.

• Involved in various enhancements to the reporting.

Environment: Oracle Business Intelligence EE- 10.1.3.3.3, Oracle EBS, Informatics 8.x

DAC, BI Apps 7.9.5, Oracle 10g, SQL Developer, Windows.

Client: Pacific Gas and Electric Company, CA Oct 2007 –July 2008

OBIEE Developer

Description:

The Customer Services Management Analytics solution will enhance decision-making process regarding Operation Enhancements of PG&E personals. The system will allow Customer Relation Management Team to perform data analysis and track the solutions provided to subscribers as well as to report to California Public Utilities Commission (CPUC).

Responsibilities:

• Reviewed Functional design document and Technical design document.

• Worked with DBA on database architecture design and data model design for Data warehouse and Data Marts.

• Created/Modified/ Customized Metadata repository (.rpd) and Configured Metadata Objects using Siebel Analytics Server Admin tool.

• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and created customized repository variables for the users.

• Built Prototype reports from Excel spreadsheet during the requirement phase to visualize the reports and clarify the requirements.

• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.

• Designed and developed security settings like data visibility based on position and login of the User in a Stand-Alone environment.

• Created custom JavaScript and HTML templates for implementing additional web interface to OBIEE Dashboards.

Environment: OBIEE 10.1.3.2, Oracle 9i, Toad, Windows 2003 server.

Client: SBI Cards, India Nov2006 –Aug007

Siebel Analytics

Description:

The Project is used by Call Center department for management of customer interaction, Operations department for forecasting the resource requirements and Marketing department for analyzing the trends & events.

Responsibilities:

• Involved in gathering the reporting requirements from Call Center, Operation and Marketing departments.

• Interacted with the Business users to indentify the process metrics and various key dimensions and measures.

• Analyze, Design and Developed Analytical Metadata repository (.rpd) that consists of physical layer, multiple business model / layers with dimensions & time series objects, presentation layers with catalogs, external table security using session variables, LDAP authentication, assigning catalog objects & Web modules to users & groups etc.

• Designed and developed the various Service Request, Marketing Trends Dashboards/Reports that are Dynamic & Interactive with drill-down capabilities and local & global filters and cache monitor using Siebel Analytical Web. Extensively used Siebel Delivers and iBots.

• Developed many Time-Series objects for tracking and performing the trend analysis of new card uses.

• Used workflow manager extensively to create tasks, worklets, and workflows and executed the tasks.

• Involved in the error checking and testing of the ETL procedures using informatica session log

And workflow logs.

• Extensively worked in the performance tuning of the ETL procedures and processes.

• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

• Performed Unit testing and Integration testing to validate Dashboards/Reports.

Environment: Siebel Analytics 7.7, Informatica 7.x, Oracle9i, PL/SQL, TOAD, Windows. UNIX.

Client: ING Vysya Insurance, India Mar2005 –Oct2006

PL/SQL Developer

Description:

The Branch Office Support System automates the way branch offices operate. The BOSS system enables the Branches of IVLI to take a fast decision on the new business initiatives. The various modules in this project involve the client module, Branch module, and Head Office Module. The Underwriting module makes easy the process of Insurance Policy application evaluation.

Responsibilities:

• Participated in Requirements review

• Developed the SQL queries to create tables and Views.

• Developed PL/SQL procedures, functions, Triggers using TOAD.

• Loaded Data using SQL loader and developed the control files for the same.

• Developed custom reports using SQL*Plus.

• Wrote and executed test plans, maintained versions of change components to ensure accuracy and update.

• Worked with workflow monitor to run and monitor the sessions , workflows and worklets to

Ensure the data loading into Enterprise data warehouse.

• Tested the software using many methodologies like Functional Testing, Load testing, and Regression Testing. Tuned few queries to resolve Performance issues.

• Used SQL Loader to dump the data provided in the form of flat files from the legacy system into normalized staging tables.

Environment: Oracle 9i, TOAD, SQL Loader, SQL server 2000,Windows

Client: HDFC BANK, India July2003 – Febl2005

Loan Tracking System

PL / SQL Developer

Description:

The project mainly focuses on the servicing loans, tracking the current instalment payment status and other accounting information. The other modules are CPV (Custom Person Verification) and Credit approval information for personal loan and car loan.

Responsibilities:

• Effectively communicated with Business Users for data requirement and data analysis and properly documented.

• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for weekend batch processing.

• Involved in creation and updates of several SQL packages and Procedures.

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables

• Created Staging Tables to handle import data.

• Implemented various Exception handling cases for proper flow of data into database

• Implemented PL/SQL scripts using Ref cursors in order to load data dynamically and implemented incremental loading of the data.

• Used Complex SQL queries and Inline views, Materialized views, Global temporary tables for reporting purposes.

Environment: Oracle 8i, PL/SQL, SQL*Plus, SQL*Loader, TOAD. Server2000, Windows2000.

Bharathi Mobitel Limited. Aug 2002-June 2003

Employee Management System

Software Developer

Description:

Implemented the project to maintain company employee information and various needs of Reporting, this was focused extensively on the customization of HRMS using VB 6.0 for their Client.

Which consists of all the details of the employees, is maintained. This is mainly divided into 5 modules viz., Master details, salary details, Training details, Work Permit tracking, Shift & attendance details. The master detail module contains all the personal information about the employee. The Salary module contains all the information regarding employee salary structure, which can be accessible to Accounts Department only. The training & development module contains all the information regarding associate trained which program. The Work permit module contains all the information regarding associate onsite visits. The shift & Attendance module contains all the information about shift allowance, leaves and comp-offs.

Responsibilities:

• Involved in Creating Entire Development Life Cycle of Project (Analysis, Design, Development and Testing) of the Global Placement System.

• Used Vb as the front-end with sqlserver as a back end through SQL connection

• Designed pages using framework tools and some are used controller tools

• Written Java Script functions for client side validations and common style sheet file which is used in all web pages to make the font size and style consistent across the site.

• Extensively used ADO for data retrieval and database updates for the application.

• Involved in the unit testing and the documentation of the project.

Environment: VB6.0, Sql Server 2000, HTML, Java Script.



Contact this candidate