Professional Profile

• Senior BI/Data Analyst with 6 years of experience in supporting large multi - national BI environments and data sets.
• Techno-Functional experience including Business Intelligence, Data Analysis, Data modeling, Data Warehousing, QA and Support.
• Experienced in all phases of Software Development Life Cycle from requirement gathering & analysis through design, development, testing, training, implementation and support.
• Result Oriented, quick learner, organized and committed, excellent proven ability to reach goals, strong oral and written communication skills, organizational, problem­solving, prioritization and analytical skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Core Java, Javascript(basics)

Databases: Oracle 10g, Oracle 11g

ERP Source System: Oracle EBS, Demantra, JD Edwards

BI Reporting Tools: OBIEE 11g/10g, OBI Applications 7.9.6.x, MUD RPD, OBI Publisher 11g/10g, Oracle Confidential, Workday

ETL/ELT Tools: Informatica Power Center 9.1.x, 9.0.1, 8.6.x, DAC 11g/10g, ODI 10g/11g

Oracle ERP Modules: Accounts Receivables, Supply Chain and Order Management, Inventory, Project Accounting and System Administrator

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Responsibilities:

• Data cleaning and loading the data in the txt files to the Oracle Database.
• Created custom tables and wrote the SQL queries to extract, transform and load the data in the custom tables.
• Requirements gathering for enhancement requests for new dashboards.
• Problem resolution as well as incident management
• Worked on fixing the Issues in the reports faced by the users.
• Interacted with users, and understood their requirements.
• Fixed issues in reports, exported directly to Box from SQL.
• Fixed issues in the Expense Detail report, not populating the required records.
• Built ad-hoc reports to fix the issues in the OBIEE reports.
• Created a Union report for the users as, the Natural Account column was not present in the subject area for the Secondary Ledger.
• Provided trainings to several users, who were new to OBIEE.
• Worked on providing OBIA Data Security to the Users, from different departments and different regions.
• Created an OBIEE User Guide for the novice users to understand and work on the OBIEE.
• Worked on the Oracle Confidential, to support a user in creating Dashboard prompts and Dashboard pages in Confidential .

Confidential

Senior BI/Data Analyst

Responsibilities:

• Requirements gathering for enhancement requests for new dashboards.
• Problem resolution as well as incident management, including raining SR
• Providing user training and noledge sharing sessions to Land O Lakes, Equinox technologies.
• Worked on the Production Monitoring and resolving various issues.
• Worked on the BI - Oracle Enterprise Transportation Analytics (FTI) - Naming
• Convention Change, for this change to get reflected in its respective OBIEE reports and dashboards.
• Worked on the Service Request - Ship Qty vs Order Qty Logic Change.
• Added the logic, to load the Ordered Quantity based on the Requested Date and display records dat are 13 weeks prior and 52 weeks later TEMPthan Request date in the Demantra table.

Confidential

Senior BI/Data Analyst

Responsibilities:

• Worked in the requirements gathering phase to work on the ETL customization.
• Determined the type of customization to be performed, to load the data in the reports.
• Added the logic, to load the data in the client's reports.
• Worked on the ETL customizations and loaded the data in the warehouse tables.
• Created Execution plans to load the data in warehouse tables.
• Created Interactive OBIEE reports.
• Worked on the Supply Chain and Order Management ETL customizations, along with Inventory and Accounts Receivables ETL customizations.
• Worked on the MUD RPD, customizations of the RPD.
• Reconciliation of the data by writing the EBS queries for the warehouse tables
• Monitored the Full Load ETL in the UAT instance.
• Fixed the ETL issue, while run in Full Load.

Senior BI/Data Analyst

Confidential

Responsibilities:

• Monitored the ETL in Production and UAT environments.
• Performed data validation for report mismatches in OBIEE 10g and OBIEE 11g.
• Monitored the Ibots in Production environment.
• Noted the ETL and reports response times for a particular dashboard before and after tables compression so dat the performance of the reports can be noted.
• Checked the services for OBIEE, Informatica, DAC and Database in Prod, QA, DEV and Test instances.
• Performed Unit Test on a mapping to populate and validate data in reports.
• Implemented the rtf template to display report in BI Publisher.
• Sent this BIP report to the client and the on-site for further enhancements.
• Documented the work on BIP, so dat it can be helpful for my colleagues.
• Implemented the logic to populate deduction amounts in 3 different buckets (121-150 days, 151-180 days and 181+ days respectively.)
• Moved this report to the QA10g, Production and QA 11g instances respectively.

Confidential

Responsibilities:

• Created custom tables, custom ETL mappings to populate the tables.
• Created custom Informatica mappings to populate the target tables.
• Created interactive reports and dashboards in OBIEE.
• Created new tasks, subject areas, assignment of phases and Custom execution plans in DAC.
• Involved in running and monitoring the full and incremental load execution plans.
• Worked on RPD, interactive dashboards and reports for Order Management, Service Contracts and Oracle Projects modules respectively.
• Worked on UAT issues for the developed reports, interactive dashboards, taking backup of the RPD and moving the RPD from Dev to Test, ETL mappings and DAC objects into Test.
• Prepared migration documents for Informatica and DAC, technical design documents.
• Involved in RPD, Informatica, DAC migration from DEV to TEST.
• Customized few standard Oracle mappings and monitored the ETL run.