Associate Analyst

Vanessa Lopes

Email: ***********@*****.***

Phone No:407-***-****

Summary

• Around 1 year of experience in in gathering requirements, designing, implementation, building, testing and customizing reports in OBIEE11g and OBIA

• Expertise in design and development of Oracle Business Intelligence (OBI) Administration tool Repository(RPD) at three layers (Physical Layer, Business Model & Presentation Layer) configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Web Catalog Objects (Dashboard, Pages, Folders, Reports, Prompts)

• Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data model

• Knowledge on languages like HTML, SQL, PL/SQL AND XML

• Strong analytical, problem solving, and inter-personal and communication skills coupled with an intense customer-centric attitude

• Result oriented, committed and hard working with an ability to grasp new technologies, tools and undertake challenging tasks

SKILLS

Languages: Java, HTML, CSS, JSP, XML

Operating Systems: Windows 7, 8.1, 10, MacOSX 10.11 El Capitan

Database: Relational databases: My SQL, MS SQL, PL/SQL

Tools: ORACLE SQL, Oracle Business Intelligence EE(OBIEE) 11g, Oracle Data Integrator (ODI) 11g, OBIAPPS, Oracle Business Intelligence Applications(OBIA), MY SQL, Informatica, Tableau

Project Management: MS Office Suite, MS Project, MS Visio

WORK EXPERIENCE

Jade Global (Sept 2017 – Present)

Client: TD BANK

Period: June 2018 – Present

Role: Developer

Responsibilities:

• Collaborated with corporate executives to identify the mapping in Informatica, performed complexity analysis of mapping.

• Migrated the mappings from Informatica to ODI, performed testing

• Coordinated with Offshore Team

• Performed Data Load

Client: Keystone

Period: June 2018 – Present

Role: Support

Responsibilities:

• Provided support on developed reports and dashboard

• Updated data load every month

Client: PEP BOYS

Period: Nov 2017 – Apr 2018

Role: Developer/Support

Responsibilities:

• Gathered and analyzed business end user data and identified solutions strategies for report and dashboard requirements

• Designed and developed of Oracle Business Intelligence (OBI) Administration tool Repository (RPD) at three layers (Physical Layer, Business Model & Presentation Layer) configured Interactive Dashboards with drill-down capabilities using global and local Filters, Web Catalog Objects (Dashboard, Pages, Folders, Reports, Prompts)

• Wrote manuals as needed and created documents for presenting to client and end users

• Provided support on developed reports and dashboard

• Coordinated with Offshore Team

First Flight Courier Service (Feb 2015 - May 2015) Operations Executive

• Analyze and manage large quantities of data and identify trends to provide meaningful insights

• Kept track of delivery system and efficiency within a given region

• Extracted data from existing data source and performed ad-hoc queries using SQL

• Performed in depth analysis on data & prepared daily, weekly, biweekly, monthly reports of delivery/shipping in MS Excel

• Played a key role working closely with other associates and Regional level Manager

• Resolved difficult issues with guidance of manager while maintaining positive rapport with customer

Graduate Project

Master’s Project

• Designed a mini website for hospital management developing Java, HTML5, Java script, CSS, JSP, and

• MYSQL as the database

• In this project the doctor was able to view entire patient history, also confirm or reject patient’s appointment, give solution to their problems and the patient could post their problem online, book appointment, give their feedbacks

• Successfully completed project in Java, for which I created GUI for blood bank system

• Also completed database project using MYSQL for hospital management

Environment: MySQL Workbench, MS PowerPoint, MS Excel, Eclipse, Tomcat Server

Credit Card Fraud Detection

• Designed a mini-portal depicting online store using HTML, HTML5, Java Script, CSS and Oracle as back-end database

• In transaction process, applied Credit Card Fraud Detection Logic which consisted of security based questions and other necessary security checks

Environment: Oracle, MS PowerPoint, MS Word, Net Beans, Tomcat Server

EDUCATIONAL QUALIFICATIONS GRADUATION

Master of Science in Computer Information Systems – Florida Institute of Technology, (May 2017)

Bachelor of Engineering in Computer Science – Xavier’s Institute of Engineering (May 2014)

EXTRA-CURRICULAR ACTIVITIES (Aug 2016)

Member of Florida Tech Orientation team (Panther Prep Leader)

• Responsible to help new students’ easy transition into life at Florida Tech

• Direct link to the inside world of Florida Tech, friend/mentor to help with students’ college experience

• As a new student going through Orientation, conducted daily meetings to answer any questions, show them around, escort them to their daily scheduled activities, and get the new students excited for an awesome college experience

• Participating and assisting with the organization, planning, and implementation of orientation activities like assisting in check-in of students, parents, and guests as they arrive, eating meals with students and also conducting campus tours for parents and students

INDEPENDENT COURSEWORK

• Completed project on data visualization using tableau and developing an interactive, dashboards, storyboard using function like table calculations, graphs, gnatt charts, parameters. The project was analyzing the data and presenting it in a meaning form so that the client can understand. (Udemy)

• Completed course on data integration and transformations in OD11g interfaces Understand the use of ODI11g development objects with methods and concepts illustrated from real projects. Master the key concepts of ODI 11g’s physical and logical architecture and the use of Knowledge Modules and data models. (Udemy)

• Completed course on Informatica Power Center 10x/9.X(Udemy)

Contact this candidate