PROFESSIONAL SUMMARY

• 7+ years of experience in overall SDLC, 4+ years of experience in OBIEE (Oracle Business Intelligence Enterprise Edition)/Siebel Analytics, Oracle BI Apps-Prebuilt Analytic Packages.
• Expertise in Dimensional modeling and business process de-normalization to build star schemas.
• Expertise in complete SDLC which involves Requirement Gathering, Proof of concept, Gap analysis, Converting functional to technical Spec, Design, Development, Testing and Implementation of the OBIEE/Siebel Analytics.
• Knowledge of Informatica PowerMart 7x/8.x, Informatica PowerCenter 7.x/8.x.
• 2+ Years of IT experience in Requirement Analysis, Design, Development, Deployment and Maintenance of large enterprise VB.net and Web-Based environment, Distributed N-Tier architecture and Client/Server architecture.
• Excellent Data Warehousing experience using source Analyzer, Data Warehousing Designer, Mapping Designer - data transformation and mapping issues, Mapplet, Transformations in Informatica PowerMart 7x/8.x.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Handling Incremental Loads/Change Data Capture (CDC), Slowly Changing Dimensions and Orphan Records.
• Experience serving industrial segments like , e-commerce and Insurance, Sales and Marketing domains in business related to implementation of ERP/CRM and BI Solutions
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer).
• Extensive experience in OBIEE RPD Development, Answers, Intelligent Dashboards and Delivers/iBots
• Implementing security using LDAP, Single sign on (SSO)
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Expertise in Debugging and Performance Tuning of reports using various technical approaches like database tuning, aggregate implementation.
• Expertise working with dimensions and fact tables in the BI Apps and experience with understanding universal adaptors in order to load into BI.
• Involved in performance tuning at the DB level, OBIEE-RPD ,Dashboard Server Level
• Experience in development & customization of BI Publisher (XML Publisher) Reports.
• Worked with Oracle Utilities like Toad, Putty and expertise in SQL * Loader, SQL, PL/SQL and Shell scripting, MS Word, Visio for documentations and diagrams, and Excel spread sheets.
• Expert in using Query Optimization tools like TOAD for Oracle.
• Expertise in creating Dashboards and Reports in areas like “Supply chain Management, Order Management and Fulfillment, Inventory and Sales”

EDUCATION

• Master’s in Business administration (Systems)

TECHNICAL PROFILE

Business Intelligence: OBIEE 10.1.3.4/3/2, Siebel Analytics 7.8/7.7
Data Modeling: Erwin 3.5.5/4.2, Star-Schema Modeling, Snowflake Modeling, FACT & Dimensions
ETL-Tools: Informatica PowerCenter 6.x/7.x, PowerMart 6.x/7.x
Languages: C, C++, VB 6.0, T-SQL, PL/SQL.
Web Technologies: HTML, XML, XSLT, JavaScript, AJAX.
Designing Tools: MS Visio, ERWIN, UML.
Operating Systems: Windows 98/NT/2000/XP/2003 Server.
Reporting Tools: Hyperion Finance Reports (HFR),Crystal Reports, OBIEE Answers & Dashboards
Scheduling Tools: TIDAL, UNICENTER, CA7, DAC and Maestro
Databases: SQL Server 2000/2005, Oracle 9i/10g, DB2.
Web Servers: Internet Information Services (IIS), Weblogic.
Source Code Control System: Visual Source Safe, PVCS, CMSynergy

PROJECTS SUMMARY

FULL 360 , NY May 2011 – Mar 2012
OBIEE Developer Roles & Responsibilities:

• Worked with Business People for gathering requirements, Identified Analytics Report requirements
• Worked Extensively on Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Configured and extensively used Siebel Delivers, Schedulers and iBots.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Writing PL/SQL, T-SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Extensively used ETL to load data from source systems like Flat Files, Oracle, ODBC
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters in user interface. Configured Global Filters and Prompts in Siebel Analytics Web.
• Developed aggregated fact tables using the content tab and fragmentation.
• Hands on experience with DAC in creation of Tasks, Task Groups, Subject Areas, Execution Plan
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
• Implemented security by creating roles & web groups, External tables and LDAP
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.

Environment: OBIEE 10.1.3.3.2, UNIX Shell scripts, Oracle 10g, Informatics, UNIX, PL*SQL, TOAD

Confidential,VA Jun 2009 - Feb 2011

Roles & Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the Kimball Matrix for generating reports as per the user requirements.
• Presented the overall RPD metadata development methodology.
• Provided Weekly status reports to the senior manager.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Writing data extracts to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
• Developed Role-Based Dashboards for Region Managers, Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics for different campaigns.
• Configured advanced Navigation reports, guided navigation link, Union reports etc.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Performing Testing of the IT Defects and CR raised by the Testing team.
• Implemented security by creating roles & web groups, checks with LDAP Authentication.
• Migrate the RPD metadata & web catalog contents to Test & Production environment.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.

Environment: OBIEE 10.1.3.4, Informatica, PL*SQL scripts, Oracle 10g, Sql’s, TOAD, Unix

Confidential Dec 2006 – Apr 2009

Roles & Responsibilities:

• Worked on Data schema modeling and designed Database Schema using ERWIN tools and implemented Normalization on relational modeling.
• Worked on Oracle 8.x and VBx.x Software Installations and configurations also involved in LAN/WAN Network configurations on.
• Developed several business operations reports and involved in trouble shooting and debugging.
• Updating the customer details related to locations, Payments and upgrades etc.
• Worked with tools like TOAD for back-end RDBMS tables testing and created Stored procedures and views for business operations.
• Used Oracle RDBMS as the back-end and VB as the front-end for generating reports.
• Worked on Excel VBA programming and created complex calculations and designed Macros and pivot tables.
• Involved in the Requirements session with the Business people to gather the Requirements.

Environment: SIEBEL Analytics, Excel , Oracle 10g, Informatics, UNIX, PL*SQL, TOAD

Confidential May 2003 - Jul 2005

Roles and Responsibilities:

• Writing PL/SQL, T-SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Writing data extracts to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
• Involved in the design of the Database and Developed Triggers, Stored Procedures using SQL Server 2005 for all the interaction with the database performance tuning of SQL.
• Worked on complex reports using SQL Server Reporting Services.
• Created data entry screens with validation rules and developed Test case documents for all modules.
• Involved in data schema designing and actively involved in test case designing discussions and project scope document preparations.
• Working knowledge on Paging Concepts and Involved in implementing the both User side and Admin Side modules.
• Involved in doing unit testing, System testing and created test case documents and program specification documents.

Environment: VB 6.0, VBScript, ASP2.0, XML, Oracle 8.x, 9.x, Dev 2000, SQL Server 6.5x, HTML/DHTML, Windows 2000 and Windows servers.