PROFESSIONAL SUMMARY:

• Over 8 years of experience in IT Industry and 7 yrs. in ETL and Business Intelligence Applications/OBIA/BI Apps using Oracle Business Intelligence (OBIEE).
• Experienced in Full Systems Development Life - Cycle Implementation of Various Oracle/ETL /OBIEE Projects.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Proven experience in implementing complete software life cycle involving various phases of design, development and implementation of Data Warehouses & Data marts with OLAP Tools
• Expertise in Data Modeling (design, analyze and implement) conceptual, logical and physical data model, Data conversion and Data integration specialization in the area of Data Warehouse and Business Intelligence.
• Experience in OBIEE/BI Apps OBIA with Loyalty Analytics, Sales Analytics
• High proficiency in SQL and relations Database, hands on in SQL developer and Toad.
• Proven Experience in Software development cycle (SDLC), Design documentation, Unit/Functional testing.
• Proven experience in Agile Project Management and Defect tracking tool Jira.
• Good domain knowledge & experience in Business Intelligence & Data Warehousing in CRM based Applications.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution.
• Extensive BI and Data warehousing experience using reporting Solutions and Informatica PC 9.0.1, 8.1/7.x/6.x.
• Have experience in managing and provide direction for the onshore & offshore teams in support of development activities.
• Highly competent in Analysis, Design & Development phases.
• Analyze business requirements and translate them into functional and technical design specifications and implementation plans.
• Experience in different Analytics Reporting tools OBIEE and Tableau.
• Worked on QA Activities and UAT to ensure the readiness of the applications.
• Good team player with excellent communication, written and presentation skills with strong aptitude to learn new technologies.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/ 10.1.3.4.1, 11G, DAC, DAC 7.9.4 / 7.9.6 / 7.9.6.1 / 7.9.6.2/ 10.1.3.4.1 .

ETL Tools: Informatica Power Center 8.6.1/ Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1/Informatica Cloud

Agile Methodology Tool: Rally

Defect Tracking Tool: Jira

Siebel Applications: Siebel7.X/8.0,Siebel Call Center

Utilities: MS Office Suite (Word, Excel, PowerPoint,Visio)

CRM Verticals: Siebel eSales, Siebel e-Pharma, Siebel CallCenter,Microsoft Dynamics CRM

Operating System: Windows 95/98/2000/XP, UNIX, AIX OS, MS-DOS

DBMS: Oracle 10g, Oracle 11g, IBM DB2, SQL Server

Version Control Tools: Clear case, Visual Source Safe

Siebel Analytics: Siebel analytics 7.7 / 7.8

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, Texas

Data Architect/Lead

Responsibilities:

• Lead an OBIEE configuration team or development team, ensuring design, development and testing work is completed to standard and on time.
• Designing and maintaining technical and functional documents for Oracle Loyalty application
• Configured Oracle BI Applications Informatica, DAC and OBIEE, implemented Oracle out of the box Prebuilt Loyalty analytics Apps.
• Captured and documented Management Information/Business Intelligence requirements from clients, via interviews or workshops, ensuring suitable balance of business needs and delivery feasibility.
• Managing/coordinating on-shore and off-shore OBIEE Development Teams.
• Hands on OBIEE (10g/11g/12c) to generate genuine reports for the stake holders.
• Worked on OBIEE upgrade from OBIEE10g Application to OBIEE11g and then to OBIEE 12c.
• Involved in business meetings and working closely with the business analysts to gather user requirements and did thorough Data Analysis.
• Worked on migration, deployment and performance tuning of repositories.
• Developing the ETL /OBIEE Report detail design documents for each target tables(Fact and dimension tables)/workflows/Reports
• Interacting with the business analysts to get the business Requirements, reporting needs and creating Business Requirement Document.
• Highly professional in SQL and Informatica PC to populate data to Oracle System, performed performance tuning.
• Created the metadata in OBIEE RPD for reporting purpose.
• Development of Dashboards and Reports for different Business groups
• Developed Mappings, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules.
• Performed Unit/System Testing, worked with users for UAT and done Performance tuning according the users feed back

Technologies Used: OBIEE 10.1.3.4.1, OBIEE 11.1.1.9.0, OBIEE 12.2.1.1.0, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1, Informatica cloud,BI Apps 10g/11g/12c Loyalty

Confidential, Texas

ETL Developer/Lead

Responsibilities:

• Involved in R&D, model, design and Develop the process to setup dependency between Informatica Power Center (In-house) and Informatica Cloud process.
• Designed Mapping Specifications based on the Transformation rules to load the data from source to the Staging.
• Designed and developed Informatica Mappings/Sessions/Workflows to load data from Source systems to Staging DB.
• Understanding the Business Process of the application and prepared flow diagrams/ERD
• Worked closely with Business for the requirements and manage offshore and onsite Dev/QA team
• Created test cases in Rally and provided the tasks to the QA team members
• Managed Rally and acted as a scrum master
• User demo for the BU and noted the enhancements as per the user feedback
• Performed Unit and System and functional Testing

Technologies Used: Informatica Power Center 9.6.1, Informatica cloud

Confidential, Texas

Data Architect/BA

Responsibilities:

• Analysis of Siebel Data
• Development of new ETL Mappings to load data from Siebel to the OBIEE
• Implementation of object level and position based data level security
• Development of OBIEE RPD
• Development of Dashboards and Reports for different Business groups
• Modification of reports based on end user feedback
• Generated test data for unit and system testing of ETL and OBIEE code
• Unit and System Testing, Performance testing
• Deployment of code to production
• Performance Tuning

Technologies Used: OBIEE 10.1.3.4.1, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1

Confidential

OBIEE Consultant

Responsibilities:

• Preparation of Informatica mapping based on the requirement.
• Creating of Task, Workflow in Informatica.
• Creating DAC Tasks to run the Informatica Workflows
• Creating the metadata in OBIEE RPD for reporting purpose.
• Preparing Dashboards to meet the client requirement
• Creation and Scheduling iBots Reports

Technologies Used: OBIEE 10.1.3.4.1, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1

Confidential

BA/QA Resource

Responsibilities:

• Understanding the Business Process of the Airline domain/functionalities.
• Direct interaction with the client for the knowledge transfer and to understand the functionalities.
• Creating the Data flow/ BRD for this project.
• Provide KT to the other team members.
• Performed QA activities to ensure the readiness of the system

Technologies Used:.NET