Summary

• Over 15 years of experience as Information Technology Professional.
• 6 years of Techno-functional experience in Oracle Business Intelligence OBIEE 11G, gathering Business Requirements, Analysis, Design and Development, Performance tuning, Full Life Cycle.
• Experience with OBIEE intelligence OLAP reporting, BI Publisher, Enterprise Manager, OBIEE Administration Console DAC and Oracle Analytic modules in 11G.
• Experience in OBIA 7.9.6.4 Oracle Financial Analytics, Procurement Spend Analytics, HR Analytics modules
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Created, Modified and Developed BI 11G Metadata repository- three layers Physical Layer, Business Model Mapping layer Presentation Layer Designed and customized administrating database objects like Tables, Views and Indexes.
• Extensive Data Modeling experience in Star Schema design, Fact and Dimensions tables, Physical and logical data modeling
• Proficiency working in OBIEE 11.1.1.6.0,11.1.1.7, Oracle 11g Development and Administration environments with hands on SQL PL/SQL.
• Experience in creating, modifying, and administering Analytics Intelligence Dashboards with drill down capabilities using global and local filters in BI Analysis/Answers, creating Alerts using OBIEE Delivers.
• WebLogic performance tuning.
• Excellent proficiency in data and object security to meet business Requirements.
• Sound knowledge in Data upload using SQL Loader oracle utility.
• SDLC experience Gathering Business User Requirements, System Analysis, Design, testing, and implementation , creating connection pools, mapping, measures, elegant BI reports with experience earned from Technology, Finance, Healthcare and Manufacturing industries
• Proficient in working in an MUDE environment, Weblogic Console administration tools in creating User Groups as well as working with multiple data sources delivery of elegant BI reports
• Excellent verbal and written communication and listening skills, with strong attention to details
• Excellent track record in demonstrating strong analytical and problem solving skills.
• Team player and an individual contributor with steep learning curve and good interpersonal skills.
• Extensive experience with interacting with business management at all levels.
• Ability to multitask good prioritization, time management and organizational skills.
• Strong ability to build effective relationships with a variety of personalities.

Technical Skills

Experience:

Confidential

Role: OBIEE Developer

Responsibilities:

• Requirement Gathering interacting with Business users conducting interviews to gather, analyze and document user needs, business processes, identifying reports/KPIs and other requirements then successfully roll out deliverables.
• Used the OBIEE Admin Tool to develop the three layers in the Repository. RPD
• Worked in a Multi User Development Environment MUDE , pulling RPD from versioning tool to common directory and making changes to meet business requirements.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository using Star Schemas.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Used Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Worked on OBIEE Analytics to create the reports as per the client requirements including compound views, table, charts, drill downs for the Global Organization.
• Expertise in designing and developing custom reports using OBIEE Analytics and making them available in Dashboards.
• Implemented drill in place so that users could view data at the granular level and make effective decisions concerning the business.

Environment: Oracle Bi 11g Enterprise Data Warehouse, OBIEE Administration

Confidential

Role: OBIEE Developer

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Used the security manager in Analytics Admin tool to setup Users and Groups
• Formatted column output and modifying column data using formulas
• Developed reports / Dashboards with different Analytic Views drill-Down / dynamic, Cascading styles Sheets, Pivot Table, Charts, Tabular with global and local filters. Formatted requests using sorts, filters and prompts
• Responsible for creating users and groups with appropriate security details in Administration Console.
• Created dimensional hierarchies, aggregates, and keys in the BMM layer.
• Setting up reports to run at scheduled time for cache seeding to improve Query Performance using Caching.
• Configured Security at the repository level, Catalog level and the application level.
• Performed validation of data in the reports and dashboards against source systems.
• Participated in complete life cycle of the project.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in OBI Analytics Administration Tool.
• Enhanced Query performance, by analyzing modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Set up Scheduler and configured Job Manager.
• Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting up External Table Authentication.

Environment: OBIEE 11g, UNIX, Putty, SQL Developer, WebLogic, Windows 7 Enterprise, Windows Server 2003

Confidential

Role: OBIEE Developer

Responsibilities:

• Participated in OBIEE and OBIA Oracle BI Applications
• development analysis
• Participated in the development Requirements analysis
• Participated in the development of the Technical design solution
• Development and unit testing
• Participated in the development of the build instructions and work closely with the Ops team to deploy the solution
• Participated in the full lifecycle of BI project efforts. Developed and documented a technology roadmap through collaboration with the IBM GBS business sectors.
• Participated in lead RFP responses, sales activities, POC's and business decisions
• Evaluated requirements, working with BI team and project managers to provide solutions to end users
• Worked with Business Intelligence team to develop a BI Platform that conforms to consistent methodologies, standards and industry best practices
• Assisted with developing and nurturing the overall logical physical Data warehouse/Data-mart data model and data architectures
• Worked to develop and ensure an effective deployment of business functional specific semantic/metadata layer
• Ensured that all of the products and data within the platform were built and integrated as a cohesive unit, ensuring proper documentation
• Provide technical support to members of the BI team to deliver on-time, on-cost, on-requirements and on-quality
• Performed trouble shooting and break-fix for all defects.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11G, BI Analytics, BI Console, BI Enterprise Manager, Windows 7 Enterprise.

Confidential

Role: OBIEE Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Participated in the conversion of ATE branches into enterprise system by Interacting with business representatives for requirement analysis and to define business and functional specifications.
• Created/Modified Metadata repository .rpd by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers.
• Designed the Repository Physical layer by defining joins and configuring the Connection Pool settings and created the Star Schema in Business Model.
• Extensively worked on Data marts different subject areas for decision support based on the needs of a given department and setting up LDAP ADSI authentication.
• Managed the Analytics Cache environment.
• Configured Dimension tables.
• Specified the aggregation levels and configured measures in the Business Model Layer and mapped to Multiple Logical Source tables.
• Design, development and configuring of custom reports/Dashboards with different Analytics views compound layout, Pivot table, chart, table with local and global filters using Siebel analytics.
• Proficient in using the time-series functions to support historical time comparison analysis.
• Experience in creating reports, adding filters, creating prompts, and creating pivot tables using OBI

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11G, BI Analytics, BI Console, BI Enterprise Manager, SQL, Windows XP Professional and Windows 7 Enterprise

Confidential

Role: OBIEE RPD Developer

Responsibilities:

• Requirements gathering from users through meetings, understanding business model and end user/ executive objectives.
• Used the OBIEE Admin Tool to develop the three layers in the Repository. RPD
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository. Also Created Alias tables and deployed opaque views at the database level as necessary.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized CRM analytics module to use in reporting.
• Worked on OBIEE Answers to create the reports as per the client requirements including compound views, table, charts
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Created Complex Joins, Alias Tables and Views.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11G, BI Analytics, BI Console, BI Enterprise Manager

Confidential

Role: OBIEE RPD Developer

Responsibilities:

• Requirements gathering from users through meetings, understanding business model and end user/ executive objectives.
• Used the OBIEE Admin Tool to develop the three layers in the Repository. RPD
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository. Also Created Alias tables and deployed opaque views at the database level as necessary.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized Siebel CRM analytics module to use in reporting.
• Worked on OBIEE Answers to create the reports as per the client requirements including compound views, table, charts
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Created Complex Joins, Alias Tables and Views.
• Data Sources: Oracle 11g Enterprise Data Warehouse, Operational Data Store ODS

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11G, BI Analytics, BI Console, BI Enterprise Manager.

Confidential

Role: - Network Administrator

• Deployed and provided support for Windows 7 and XP desktop images, profiles, configurations, upgrades and hospital's applications.
• Technical Lead for hospital's desktop technology refresh.
• Supports enterprise systems management of the desktop computing environment, including: asset management, software delivery, security updates, patch management SCCM and remote control support through the existing solutions.
• Maintained and monitored that all computing environment has current Symantec Endpoint Protection software installed and encryption process completed on all drives to meet security standards.
• Analyze, log, track and complex software and hardware matters of significance pertaining to networking connectivity issues.
• Provides Level 2 3 technical support, break-fix/troubleshooting and serve as an effective escalation point for the Desktop Support team, including the operating system, desktop business applications, hardware configurations, peripheral devices and all supporting processes.
• Composed and wrote documentation clearly in order to provide systems or program specifications, project status reports, work plans, documentation, training or user manuals and correspondence.
• Ensured service performance meet or exceeded business expectations and was delivered in accordance with SLA's.

Confidential

Role: - Network Administrator

• Performed hardware and software installations and provided high-level customer care, training, and technical support.
• Assembled and installed a wide array of computer systems, workstations, and peripheral hardware.
• Troubleshoot hardware, software and network connectivity issues.
• Installed and support Servers, Desktop PC and Peripheral equipment. Monitored and trained end-user to ensure stable working environment and a trouble free infrastructure.
• Installation and support of all Hardware and Software upgrades.
• Assisted other department consultants with difficult application problems and maintained list of VIP 24 x 7 applications requiring special attention.
• Provided on-site training for customer employees.
• Training employees in various computer related topics.
• Maintain, submit Service Ticket Calls and log into Remedy database.

Confidential

Role: Network Engineer / WAN Engineer

• Participate in LAN/WAN network planning activities.
• Coordinate LAN/WAN network implementation projects maintain project control plan and report project progress to management.
• Perform and coordinate cable installations.
• Coordinate projects with vendors, telecommunication companies, customers, other divisions of the Information Services Department and other entities as required.
• Perform and coordinate fiber optic cable installations.
• Manage and support Layer2/Layer3 devices.
• Prepare standards and guidelines for network implementation and identify appropriate techniques and procedures for cable and equipment installation, maintenance, monitoring and performance improvement.
• Travel to offsite locations to perform related work transport equipment and materials to and from remote work sites and respond to emergency situations.