SUMMARY:

• Results - oriented professional with full Business Intelligence (BI) solution development life cycle (analysis, design, development, testing (QA) and implementation) experience using Oracle BI (OBIEE) tools. Excellent analytical and problem solving skills along with current technology experience.
• Self-starter, able to manage individual responsibilities and also contribute successfully to team deliveries on complex, long term projects.
• Excellent verbal and written communication skills. Able to document and present the results of analysis clearly and concisely, using effective written reports and diagrams.
• Effective management of stakeholder relationships at all levels of the business.
• Project governance, including day-to-day management and resolution of risks, issues and dependencies.
• Strong technical background and full life cycle experience gained as a Database (Oracle)/Business Intelligence analyst/developer/team lead and architect.
• Well versed in Relational (E-R)/Dimensional (Star Schema) Modeling, Data Integration analysis using Informatica, BI (OBIEE) reporting analysis, design, development and administration.
• System Integration (SIT) and User Acceptance Test (UAT) coordination.
• System & Process documentation and Power User training on the use of OBIEE components for ad-hoc analysis.

TECHNICAL SKILLS:

Language: Oracle 10g/11g Enterprise Edition (64 bit), Teradata, Microsoft SQL Server 2005/2008: SQL, PL/SQL

Data Access: TOAD 11.x/10.x., Oracle SQL Developer 1.1.3

Published Reporting: Oracle Developer 10g (Reports), BI Publisher 11g

ETL: Informatica Power Center 8.6.x/9.5.x

Data Profiling: Informatica Data Explorer 8.6.x, Informatica Metadata Manager 8.x

Analytics: (Analysis, Dashboard, BI Publisher, BI Composer etc.) OBIA 11.1.1.8.1 (Financial, Supply Chain and Order Management & Procurement and Spend Analytics), Oracle Discoverer 3.x/4.x, Business Objects XI Rel 2/3 Oracle Visual Analyzer, Tableau

Data Modeling: Erwin 7.x., TOAD Data Modeler 3.4., MS Visio

Data Analysis: TOAD for Data Analysts 2.5.x

Reqs. Management: IBM Rational RequisitePro 7.1.3.02

Application Life Cycle Management: HP ALM 11.00 (Formerly HP QC), JIRA, TestRail

Source Code Management: Rational ClearCase 2002.05, Tortoise SVN 1.5.x., MS Visual Source Safe 6.x, PVCS 7.5.1.0ERP: Oracle Apps 11i/R12, Oracle Retail 13.x (Retek)

Operating System: IBM AIX, Tru64, HP-UX, NCR UNIX, Linux, MS Windows

Appliances: Oracle Exadata & Exalytics (X-4 series)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Consultant

Responsibilities:

• BI Platform migration: OBIEE 10g OBIEE 11g
• Hyperion Interactive Reporting (IR) reports migration to OBIEE 11g/ BI Publisher 11g
• Analysis, design and development of operational reports using BI Publisher
• Business requirement analysis for OBIEE RPD design, modeling and development
• Security policy analysis and design (Metadata and Web Catalog Objects )
• Analysis, design and development of OBIEE Analysis, Dashboard, Alerts and KPIs etc. based on Relational and Multi-Dimensional (Essbase) sources
• Power/general business users training on the use of OBIEE/OBIA (Financial Analytics, Supply Chain & Order Management, and Procurement & Spend Analytics) for ad-hoc reporting
• Analysis of OBIA 11.1.1.8.1 report for retaining/retiring of custom OBIEE & Hyperion IR reports.
• Impact analysis of EBS 11i r2 upgrade on Custom OBIEE/IR reports
• Helped the Client’s Onsite IT team in day-to-day OBIEE administration including RPD & Catalog backup/migration, usage tracking, impact analysis, software patching and Oracle SR (Service Requests) management etc.
• Data validation and Data Quality process management on behalf of the Client
• Coordinated, researched and resolved the Data quality related issues during the System Integration Testing (SIT)
• Resource planning, development & retrofit status reporting for the project
• Liaison with Business users and Client’s IT team for identifying and defining In-scope/Out-of-scope requirements
• Participated in BI Solution design sessions with the Client IT team and business subject matter expert (SME)
• Coordinated with the Application Support and Project Management teams for the system deployment and project execution
• OBIEE 12c installation, configuration and deployment in MS Windows environment.
• Analysis of Tableau reports for EBS 11i EBS r12 upgrade impact.
• Workshop on use of OBIEE Visual Analyzer for Power Business Users
• Guiding and mentoring the junior resources
• System Migration Strategy,
• Source System Analysis
• High Level Design (HLD),
• System deployment plan, and
• As-Is and To-Be system presentations
• Business Users Training Manual on the use of OBIEE & BI Publisher

Environment: OBIEE 11g ( 11.1.1.7.1 )/12c, OBIA 11.1.1.8.1, Oracle 11g (Exadata)/Exalytics, Tableau 9.x, Oracle EPMS 11.2.3.x, Informatica 9.5.x, ODI 11g, MS Office 2010

Sr. Consultant

Responsibilities:

• Identification and documentation of Measures, Dimensions, Hierarchies and Aggregation Rules etc. to be used in the BI reporting solutions development
• Design, development and implementation of BI Repository Metadata layers (RPD - Logical data Model) based on Relational and Multi-Dimensional data sources (Oracle, SQL Server, Teradata & Essbase Cube) and translated BI requirements into Analytic subject areas
• Creation of logical level objects e.g., Dimensional Hierarches (Level based - Time, Ragged & Skip and Value based - Parent/Child) and Calculated Measure
• Creation of Presentation level objects - Interactive reports (Analysis) with different analytical views (e.g. Pivot Table, Graph, Filters, Prompts, Groups, Calculated items and Column selectors etc.), Key Performance Indicators (KPI) and Alerts to visualize data in many different ways as per the business requirement
• Design and c reation of Dashboard, dashboard prompts, links and integrated analysis and KPI’s into the dashboard for an effective front-end experience as per business requirement
• Design, development and implementation of published reports using BI Publisher as per the requirement
• RPD and Presentation Catalog administration including object/data level permissions and migration of RPD/Catalog to the test & production environments from development
• Users & objects level security policies design
• Customized solution for WYSIWYG Dashboard printing in PDF format (using third party PDF generator)
• Coordination with ETL (Extract, Transform & Load) team to populate data warehouse tables as per business reporting requirements
• Coordination with onsite/offshore Data Warehouse development as well as QA teams for the resolution of the issues during System Integration Test (SIT) & User Acceptance Test (UAT) phases including data quality and missing data
• Coordination with the Application Support and Project Management teams to deploy the application in Production environment.
• Power/general business users training on the use of OBIEE for ad-hoc reporting
• Created the following project artifacts e.g.:
• System Requirement (SRD),
• High Level Design (HLD),
• Application Interface Design (AID),
• Test package/Test Plans,
• Traceability Matrix (TRM), and
• Review Record documents
• Application deployment document

Environment: OBIEE 11.1.1.6.x/ 11.1.1.7.1, Teradata Ver. 1 2.00.03.33, Oracle 11g EE (64 bit), SQL Server 2005/2008, SQL, PL/SQL, MS Office 2007/2010

Sr. Consultant

Responsibilities:

• Identified, analyzed and documented various Measures, Dimensions, Hierarchies and Aggregation Rules etc. to be used in the BI reporting solution development.
• Created the following project artifacts:
• System Requirement (SRD),
• High Level Design (HLD),
• Application Interface Design (AID),
• Test package/Test Plans,
• Traceability Matrix (TRM), and
• Review Record documents
• Analyzed and designed BI Metadata layer objects and translated BI requirements into Analytics subject areas.
• Analyzed, designed and documented data presentation objects
• Analyzed and designed logical & presentation level objects
• Define security policies.
• Performed source system analysis for Data Integration using Informatica Power Center (Version 8.x)
• Conducted System Integration Test (SIT) and coordinated & supported User Acceptance Test (UAT) process.
• Coordinated with Enterprise Data Warehouse (eCDW), Business Intelligence & Adjustment Tools teams as well as eCDW QA team for the resolution of the issues (data quality & missing data) during System Integration Test (SIT) & User Acceptance Test (UAT) phases.
• Coordinated with the offshore development teams for the development efforts and resolution of issues.
• Created Short Interval Schedule (SIS) document for Application deployment.
• Coordinated Application Deployment activities with the Project Management team.
• Participated in the root-cause analysis and resolution of the day-to-day Production problems related to BI Reporting.
• Provided training to the Business Customers on the system functionalities.

Environment: Teradata Ver. 12.00.03.46, Rel. 2.00.03.33, Oracle 11g EE (64 bit), SQL, PL/SQL, Oracle EPM Suite 9.x/11.x, OBIEE 11.1.1.6.x, Informatica Power Center 8.6.1, IBM Rational RequisitePro 7.1.3.02, HP ALM 11.00 (Formerly HP QC), MS Office 2007

Confidential

System Analyst 4/Architect

Responsibilities:

• Identified various Measures, Dimensions, Hierarchies and Aggregation Rules to be used in the BI reporting solution development.
• Designed and developed BI Metadata layers and translated BI requirements into Analytic subject areas.
• Analyzed, designed and documented Extract Transform & Load (ETL) solutions for BI reporting requirements using Informatica PowerCenter Version 8.x.
• Conducted Data Profiling of Source data and Data Warehouse.
• Performed EDW Impact analysis for the Source Data Change, Data Lineage and Where-used Analysis.
• Performed System Integration Testing (SIT) of all the ETL & BI Reporting objects.
• Explored and researched enterprise source systems for the BI Reporting data elements.
• Created the following project artifacts:
• System Requirement (SRD),
• Source-To-Target Mapping,
• Traceability Matrix (TRM),
• Application Deployment Document (ADD), and
• Review Record document
• Coordinated with the client, offshore development & QA teams for the day-to-day development efforts and resolution of issues including data quality & missing data.
• Participated in the root-cause analysis and resolution of the day-to-day Production issues related to EDW/BI Reporting.
• Provided training to the Business Customers on the system’s functionalities.

Environment: Teradata V2R.06.x, Oracle 10g EE (10g - 64 bit), Microsoft SQL Server 2005/2008, SQL, PL/SQL, Business Objects XI Rel. 3.x, Informatica Power Center 8.6.x, Informatica Data Quality 8.6.x, TOAD 10.x, Teradata SQL Assistant, Erwin 7.x., TOAD Data Modeler 3.4., TOAD for Data Analysts 2.5.x, MS Office 2007

Confidential

Senior Analyst

Responsibilities:

• Managed Database Migration Tasks for multiple ISD, QS1 and Standalone Counties.
• Created Conceptual and Logical Data Models for database migration and data warehouse.
• Designed and developed BI Metadata layers (Logical data Model) and BI Reporting solutions to aid the reporting process and performed the Unit & System Integration Testing (SIT) of all the objects.
• Developed standards and procedures for the Extraction, Transformation and Load (ETL) process for data migration requirements.
• Validated target database loads against the legacy source systems.
• Developed Data conversion reports for Data Analysis and Migration.
• Developed Data Exception Reports for the Client and the development team.
• Liaison with the ETL development and QA teams for the date migration and validation efforts and resolution of issues.
• Designed and developed reports using Reporting Service as per business requirements.
• Acted as a SME (Subject Matter Expert) for ISD Counties Data.
• Created the following project artifacts:
• System Requirement (SRD),
• Source-To-Target Mapping,
• Traceability Matrix (TRM),
• Application Deployment Document (ADD)
• Participated in the root-cause analysis and resolution of the day-to-day Production problems related to database migration.
• Mentor the team members on Data Migration Issues and BI Reporting.
• Provided training to the Business Customers on the system functionalities.

Environment: Microsoft SQL Server 2005, SQL, T-SQL, Excel 2007, Word 2007, Access 2007, Erwin 7.x., SSIS, SSRS, Visio 2007, Tortoise SVN 1.5.x.

Confidential

Sr. Technical Consultant

Responsibilities:

• Identified various Measures, Dimensions, Hierarchies and Aggregation Rules etc. to be used in the BI reporting solution development.
• Designed and developed BI Repository Metadata layers (Logical data Model) and translated BI requirements into Analytic subject areas.
• Created interactive reports (Answers) and defined additional views to visualize data in many different ways as per the requirement.
• Designed and c reated Dashboard, dashboard prompts, links and integrated analysis for an effective front-end experience as per business requirement.
• Created and scheduled iBots using Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
• Developed templates and published reports in BI (XML) Publisher .
• Managed and Administered RPD and Presentation Catalog
• Designed BI security policies according to the business requirements.
• Developed standards and procedures for the Extraction, Transformation and Load (ETL) process (using SQL, PL/SQL & SQL*Loader) for data migration requirements
• Lead the off-shore development teams for the BI development tasks.
• Liaison with the client, offshore development & QA teams for the day-to-day development efforts and resolution of issues.
• Created the following project artifacts:
• System Requirement (SRD),
• High Level Design (HLD),
• Application Interface Design (AID),
• Test package/Test Plans,
• Traceability Matrix (TRM),
• Review Record document, and
• Application Deployment Document (ADD)
• Participated in the root-cause analysis and resolution of the day-to-day Production problems related to database migration.
• Mentor the team members on Data Migration Issues and BI Reporting.
• Provided training to the Business Customers on the system functionalities.

Environment: Oracle 10g (EE-64bit), OBIEE 10.1.3.x, Oracle Developer 10g (Forms, Reports), SQL, PL/SQL, XML (BI) Publisher, TOAD 9.x, Mercury Quality Center 9.0EE (Test Director), Tortoise SVN 1.5.x., Oracle Retail 13.x, MS Office 2007

Senior Technical Lead

Responsibilities:

• System Requirement (SRD),
• High Level Design (HLD),
• Application Interface Design (AID),
• Test package/Test Plan,
• Traceability Matrix (TRM), and
• Review Record

Environment: Oracle 9i/10g, SQL, PL/SQL, SYBASE 15.x, SQL Server2000/2005, Oracle Designer 10g, Business Objects Enterprise XIR2, Informatica Power Center 7.x, MS Visio, Visual Source Safe (VSS), MS Office 2003

Confidential

Senior Technical Lead

Environment: Oracle 8i (8.1.7.4), SQL, PL/SQL, Oracle Developer 10g/Designer 10g, Oracle Discoverer 4.x, PVCS 7.5.1.0, AppWorx 5.1.1

Senior Technical Lead - Database/DW.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Unix Shell, Autosys 3.4, SyncSort, Rational ClearCase, Oracle Discoverer 4.x

Confidential

Senior Technical Lead

Environment: Oracle 9i, DB2 UDB 8.1.5(AIX), SQL, PL/SQL, SQL*Loader, DB2 SQL, DB2 Load, MS Access 2000, Rational ClearCase, Autosys 3.4, SyncSort, etc.

Confidential

Senior Applications/Database Developer

Environment: Oracle 8i, MS Access 2000, Oracle Developer Suite 6i (Forms & Reports), Oracle 11i (Apps 11.5.7), Oracle Discoverer 4.x, SQL, PL/SQL, SQL*Loader etc.

Confidential

Senior Consultant - Database/DW-BI Development

Environment: Oracle 8i/9i, Oracle Developer Suite 6i/9i(Forms & Reports), SQL, PL/SQL, SABLIME- (Source Code Control System), Oracle Apps 11i