PROFESSIONAL SUMMARY
Overall 8 years of experience in analysis, design, development, implementation and testing of Enterprise Wide Applications, including 6+ years of experience in Oracle BI Enterprise Edition 11.1.1.5/10.1.3.x and Siebel Analytics 7.8/7.7/7.5, Expertise in complete lifecycle implementation of Data Warehouse / Datamart with Star Schema. Strong experience in full life cycle project design and development implementing Siebel Analytics. Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, FACT and Dimensions tables, and Physical and Logical data modeling. Expertise Configuring Repository, Create/Manage Dashboards, Reports/Answers and Building Physical, Business Model and Presentation Layer. Experience in Creating Dimensional Hierarchies, Level Based Measures and Time series Functions. Expertise in Creating Filters, Global Prompts in Dashboards, Presentation Variables, and Narrative Views to filter the data. Experience in installation and configuration of Siebel Analytics and administering permissions, privileges to users based on their groups and responsibilities. Expertise in creating and modifying metadata repository using Siebel Administration Tool to suit user’s requirements. Performance Tuning Analytics Dashboards / Reports and Data Warehouse database. Solid foundation in Oracle PL/SQL Procedures, Packages, Functions, Good Knowledge of database experience using Oracle 11g/10g/9i/8i/7.3, MS SQL Server 2000, MS Access 2000/7.0, TOAD, PL/SQL, SQL and SQL*Loader, SQL Navigator. Associated with Business Analysts/Product Managers to convert the Business Requirements into Data Specifications. Excellent team player with strong analytical, communication and presentation skills. TECHNICAL SKILLS
BI Tools/Analytics : OBIEE 10.1.3.x, Siebel Analytics 7.8.4/7.7.1/7.5
OLAP : OBIEE 11.1.1.5/10.1.3.4
Databases : Oracle 11g/10g/9i/8i/7.3, MS SQL Server 2000/7.0/6.5, MS Access
Other Database Tools : SQL Developer, Toad
Scripting Languages : Java Script, VB Script
Languages : C, Java, SQL and PL/SQL
Operating Systems : Windows XP/00/NT/98/95, Linux, Solaris
Web Technologies : HTML, DHTML and XML
Applications : MS Word, Excel, Outlook, Lotus Notes 7, FrontPage, and PowerPoint
Academic Background:
BE in mechanical engineering
PROFESSIONAL EXPERIENCE
Client: Confidential,RI JUN 11- Till Now
Role : OBIEE Senior Developer.
The goal of the project is to work with oracle Business Intelligence Enterprise Edition 11.1.1.5 to create the reports for the Commercial Lending systems for Citizens Bank (RBS). The reporting is mainly dealt with Obligations (Loans), Obligors (Customers) and financial Instruments. The data grains are across different levels of future, current and participant obligations.
Responsibilities:
Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository. Developed technical solutions to business problems in the OBIEE repository. Imported data from Oracle to OBIEE and developed all the three layers. Interacted with Procurement and Operation/Maintenance business representatives for gathering the OBIEE Reports/Dashboards requirements and to define business and functional specifications The online tools consist of mainly Generating Reports to give better understanding of the financial position of the investors to the Advisors. Also part of data migration from development to staging and then staging to Production environments Enhance performance by creating Aggregate tables and managing Cache using OBIEE Administration tool. Implemented various security features at various levels. Performed migration as well as back up of OBIEE repository and web catalog for different environments. Created Session & Repository Variables to achieve desired functionality. Created web-groups for security purpose with access privileges. Extensively worked on IBots using OBIEE Delivers to create alerts based on results. Customized Reports look and Feel using Column Formatting, Conditional formatting. Customized Dashboard reports using drill-down capabilities. Environment: OBIEE 11.1.1.5/10.1.3.4, Oracle 10g, Toad 8.5.1, Informatica 8.x.
Client: Confidential,CA OCT 08 – APR 11
Role: OBIEE Consultant
Responsibilities:
Performed GAP Analysis to gather functional mapping by coordinating with the Business Users. Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository. Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Subject Matter Experts (SMEs), Business Analysts and Users. Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository. Developed Custom tables to populate Brand, Category, Class, Region, Product, and Time Dimensions and Fact and Aggregated Facts. Developed Business models to represent business logic for Market Measurements. Created logical tables and defined the complex joins for a business model. Created dimension hierarchies. Developed measure and dimension based aggregates to improve query performance. Developed custom logical columns and calculated measures using expression builder. Created presentation catalogs with restricted access to various business users. Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance. Created comprehensive and easy-to-understand Documentation 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. Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) for performing the Marketing Trends analysis using Siebel Analytics Web. Expertise in debugging and optimizing Dashboards / Reports. Working With Reports & Customer Requirements Worked Extensively on Answers to create the reports as per the client requirements. Environment: Oracle OBIEE 10.1.3,Informatica 8.x, Oracle 10g, Toad 8.5.1, DAC
Client: Confidential,NC FEB 08 – SEP 08
Role: OBIEE Developer
Responsibilties:
Analyzed existing reports and developed functional and technical mappings. Worked closely with the business users to identify various KPI\'s and designed solutions to enhance business decision-making. Participated in documenting Business Requirements Documents and Functional Specifications. Responsible for gathering the Meter Reads Billings Management Business Requirements, preparation of Requirement Specifications documents and performed the Gap Analysis. Implemented the session partitions (Database and Informatica) for performance issues. Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Warehouse per gaps. Created Aggregated Tables to improve the Performance of the Reports. Developed Custom warehouse tables to populate Account, Proposal, Product, Opportunity and Time Dimensions and Fact and aggregated Facts. Managed Security privileges for each subject area and dashboards according to user requirements. Worked Extensively on Siebel Answers to create the reports as per the client requirements. Slice and Dice data using filters and used pivot/charts for better presentation. Configured Intelligence dashboards using links/images for conditional and exceptional reporting. Customized the appearance and texts of the various objects in the user Dashboards and answers. Maintained iBots and default mail server for error reporting over the intranet framework. Developed OLTP and custom OLAP tables to perform ETL using Informatica. Maintained staging tables to perform the refresh load and full load effectively. Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Environment: Siebel Analytics 7.8, Informatica 7.1, Oracle 9i, Toad and Windows XP
Client: Confidential,Texas JAN 07 – JAN 08
Role: Siebel Analytics Developer/ OBIEE Developer
Responsibilities:
Installing Siebel Analytics and configuring the connection parameters with SQL Server, Oracle9i. Developing the prototype subject area and sample reports to demonstrate the capabilities of Siebel Analytics Map Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model. Perform Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions, Created materialized views to fasten slower queries with complex joins in them. Identify Data Sources (Siebel & Enterprise DW) & Extension columns - Identify Siebel OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas. Design & Develop Siebel Dashboards. Established access rights for pages in the Dashboard for different user groups Performed custom formatting with html tags in Dashboard Create/Modify Metadata repository (.rpd) as per the data requirements by using Siebel Analytics Server Admin tool. Build Repository at 3 layers – Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs), create presentation folders, test and validate the model. Design & Customize Siebel Answer Views & charts, Create & save Filters, Create Charts & Tables in Siebel Answers Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders. Created Users and user groups in Siebel Analytics web Configure & publish iBots to deliver analytics content based on schedule, automate iBot queries to obtain Daily & weekly Transactions to all Departments in Organization by Email. Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc Environment: Siebel Analytics 7.7.1, Informatica 6.2, SQL Server, Oracle9i and Windows NT.
Client: Confidential,India OCT 04 – DEC 06
Role: SQL Developer
Responsibilities:
Understand and evaluate UNIX, SQL and or Data Modeling. Develop underlying data models and databases. Develop, manage and maintain data dictionary and or metadata. Ensure compliance of standards and conventions in developing programs. Design, develop and implement complete life cycle of data warehouses. Translate business requirements into software applications and models. Resolve and troubleshoot complex issues. Maintain and manage all versions of data models for production, testing and developing databases.
Environment: Oracle 9i, SQL SERVER, Flat Files, SQL, PL/SQL, Windows NT.
Privacy Policy
