Summary

• 7 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Extensive BI and Data warehousing experience using OBIEE 11.1.1.x/10.1.3.x, OBIA 7.9.6.x/7.9.5.x, Siebel Analytics 7.x, DAC 10.1.3.4, SQL and PL/SQL.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the OBIEE Metadata Repository .rpd layers including Physical, Business Model and Mapping, and Presentation layer. Using Oracle BI Administration Tool.
• Proficient in defining Key Performance Metrics KPIs , facts, dimensions, hierarchies and developing Star and Snow Flake Schemas.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards and reports.
• Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in up gradation and migration of OBIEE between development/test/production environments.
• Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Skilled at creating and scheduling iBots/Agents in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security.
• Experienced in configuring Usage Tracking and Multiuser Development Environment MUDE .
• Proficient in Installation, configuration and administration of the OBIEE platform.
• Very strong in Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects.
• Quick learner with strong communication and people skills who can work in a team or independently.
• Self-driven and passionate performer with the team to learn new technologies and techniques.

Technical Skills:

• Reporting Tools: OBIEE 10.1.3.x, OBIEE 11g
• Languages: SQL, PL/SQL, HTML, XML, C, C , C
• Databases: Oracle 8i, 9i, 10g, 11i, SQL Server 2005/2008, SQL Plus, SQL Loader
• Web Design: HTML, CSS, XML, Dreamweaver and Adobe Photoshop
• Operating Systems: Windows 8/7/2000/XP/Vista, Unix, Linux, Macintosh
• Software/Methodologies: MS-Office Suite, Visio, MS-Project, UML, Agile and Waterfall

Professional Experience

CONFIDENTAIL

Sr. OBIEE Developer

Overview: Involved in implementing OBIEE upgrade from OBIEE 10.x to OBIEE 11g across all business verticals. The purpose of this project was to develop dashboards, which enable the users to review and discuss actionable metrics and trend information related to different domains.

Responsibilities

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Acted as a liaison between business users and BI team to facilitate understanding of business requirements.
• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
• Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.
• Created dimension hierarchies, aggregates and keys in BMM layer.
• Worked on session variables and dynamic variables along with initialization blocks.
• Configured Web Catalog Objects Dashboards, Pages, Folders, and Reports .
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Used various Time series functions to create trending reports of sales.
• The top priority reports like Monthly Net Sales, Customer Profitability, Funds Details and Credit Summary.
• Configured Agents to deliver analytics content based on schedule, automated iBot/Agent queries to obtain daily and weekly reports.
• Created schedules to seed and purge cache for cache management.
• Implemented security based on LDAP Authentication.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Administered MUD rpd, reviewed developers' rpd development before merging into MUD server.

Environment: OBIEE 11.1.1.3, Oracle 10g, Windows XP, SQL Developer

CONFIDENTAIL

Sr. OBIEE Developer

Overview: Implemented Business Intelligence Solutions for Product Partners that helps measuring company performance, getting new customers, keeping existing customers and delivering flexibility.

Responsibilities

• Understand project requirements and work towards design and development of the plan layout.
• Used Administration Tool for customizing and modifying the Physical, Business Model Mapping and Presentation Layers.
• Imported physical tables and defined relations between Physical tables at the Physical Layer.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Develop and design dashboards, reports and analysis.
• Copied existing RPDs from Server into the Local machine for testing and tuning of dashboards.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the sales/marketing/financial data.
• Created dimension hierarchies, aggregates and keys in BMM layer.
• Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management.
• Created Proactive agents iBots and configured Interactive dashboards to alert the employees as per the requirements.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.

Environment: Oracle 10g, OBIEE 10.x, SQL Plus, PL/SQL, Windows XP

CONFIDENTAIL

OBIEE Reports Tester/Developer

Overview: Responsible for designing, programming, implementing and maintaining computer information systems that provide support for functions within the Company. Perform best practices and standards for client business intelligence in the Enterprise Information Team.

Responsibilities

• Worked collaboratively with technical team, and business experts to develop solutions.
• Involved in full life cycle implementation of Analytics including installation, configuration, extension and customization.
• Used the OBIEE 10.1.3.3.x Administration tool to develop and enhance meta-data.
• Created connection pools, physical tables, defined joins in the physical layer of the repository.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Designed, built, tested, implemented and maintained new or modified OBIEE repository RPD objects for the analytics applications.
• Wrote SQL queries against Oracle 10g database and analyzed data.
• Designed multidimensional models like STAR schema and Snowflake schema.
• Developed different kinds of Reports pivots, charts, tabular using global and local filters.
• Debugged and Optimized the OBIEE Dashboard/Reports.
• Analyzed end-user query performance when implementing and tuning OBIEE.
• Managed Oracle Delivers, Scheduler iBots.

Environment: OBIEE10.x, Oracle 10g, SQL Plus, Windows XP

CONFIDENTAIL

OBIEE Reports Tester/Developer

Overview: Work with business users and IT to understand reporting requirements, articulate and develop reporting solutions by covering how to retrieve data and what elements from the data source EBS makes up the data. Understand OBIEE and BI Apps subject areas, metrics, dashboards and answer questions from the business and BI developers on how they map to ERP functionality.

Responsibilities

• Involved in Analysis and Design of the data warehouse.
• Analyzed reporting requirements for dashboard reports and adhoc reports.
• Worked extensively on repository administration tool to configure Physical, Logical and Presentation Layers.
• Configured facts, dimensions and Hierarchies.
• Documented the design for future reference.
• Installed and configured OBIEE platform across multiple tools and versions.
• Wrote SQL queries for testing and comparing the SQL result with report result.
• Performed Unit testing to validate report.
• Extensively worked on stored procedures, triggers, views and functions.

Environment: OBIEE10.x, Oracle 10g, Windows XP

CONFIDENTAIL

Oracle/PL/SQL Developer

Overview: Responsible for working as a software programmer on the COMPASS team with Assurant's Employee Benefits AEB IT team. CONFIDENTAIL is an insurance policy administration system that is used by companies around the globe to manage the administration of a multitude of products.

Responsibilities

• Worked with a team of IT developers in the initial Database Design/Data Modeling/Data approval.
• Created database objects including tables, indexes, clusters, sequences, roles, and privileges.
• Loaded data from flat files into database tables using SQL loader.
• Used the technical document to design tables.
• Generated SQL and PL/SQL scripts to install, create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Database triggers to maintain the database security.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Calculated and monitored the size and space for tables, clusters and indexes.
• Created and maintained triggers, packages, functions and procedures.
• Created users and established the application security by creating roles.
• Wrote PL/SQL Stored Procedures, Functions, views, Triggers for the application.
• Optimized the embedded SQL queries using statement level optimizer hints when essential, to adhere to the defined OLTP response time.
• Imported/Exported data from/to different databases using utilities like SQL Loader, Import/Export.
• Unit testing and monitoring performance and providing System support.

Environment: Oracle PL/SQL, SQL, SQL Plus, Oracle 10g, Linux, Windows XP

CONFIDENTAIL

Oracle/PL/SQL Jr. Developer

Overview: Responsible for the support of the development team with the new functionality implementation and change requests as needed. Excellent understanding of business rules as well as ability to solicit data requirements and translate into the database design, provide data modelling, create DDL, and support testing.

Responsibilities

• Documented functional and business requirements. Performed data modelling, use case analysis and analysis of preliminary data for the project design phase. Used user centred Design process.
• Assembled business requirements documents BRD and the functional specifications as per the user requirements and created a business workflow.
• Analyze business, functional and non-functional requirements to formulate a test strategy and test plan.
• Involved in designing the HTML pages and developing CSS Skins.
• Responsible for design and development of Web forms and other user interfaces.
• Wrote SQL queries and PL/SQL, Stored procedures to test database functionality.
• Developed automated test scripts for different modules and test case plan for the future of the project.

Environment: Oracle 8i, Flat files, MS Access, SQL Plus, SQL LOADER, and Windows XP.