Resume

Sign in

Oracle Data

Location:
Seattle, Washington, United States
Salary:
120000
Posted:
August 27, 2018

Contact this candidate

Resume:

Aditi Gupta

**** **** *** **, *******, WA *****

USA: +1-704-***-****

Email ID- ac6tll@r.postjobfree.com

LinkedIn - https://www.linkedin.com/in/aditi-g-23328414/

Summary

Soon after my post-grad in computer applications, I was exposed to Business Intelligence (BI) and Data Analytics at Accenture, where I joined as a software developer. Since then, the BI bug had hit me, and I had the first-hand experience to see how BI products help clients make informed decisions. Accenture sent me to Australia in Sydney to work as a BI consultant, and I loved this transition. I worked directly with the business at major Australian clients – National Broadband Network and Telstra. Since then, I had some great business analysis and data analysis experience in business intelligence applications. I feel great motivation in delivering business intelligence solutions that help my clients make informed decisions.

Technical Expertise

Business Intelligence (BI) – Oracle BI, Oracle BI Apps, Tableau, Oracle CRM on-demand,

Data warehousing – Informatica, Oracle Data Integrator, DAC,

SQL, PL/SQL, Mercurial, IBM Clear Case, QTP, RTC, Remedy, SPLUNK,

Fieldglass and Workday– HR management products,

Trained in Python

Professional Experience

Collabera Inc - Starbucks February 2018- Present

Oracle BI Apps Systems Analyst

Responsible for gathering reporting requirements, ensuring that the appropriate dimensions and facts were conformed to the existing BI Apps model, assist with the database design, and performing testing and QA. Also, I am responsible for training and communication with super users.

• Guide development team in providing the solutions in OBIEE 11g, and ODI 11g

• Gather business requirements and provide functional specs to BI Apps ODI and OBIEE developers

• Data modelling, testing, QA for technology solutions

• Ongoing training and communication with super users

• Ongoing communication/roll out/prioritization with business owners

Saras America Inc

Business Intelligence Analyst; September 2017- January 2018

Responsible for managing delivery of client facing reporting packages using data analytics and Oracle Business Intelligence tool to ensure consistent processes and methodology across the landscape, working with business teams.

Korn Ferry FutureStep - NBN May 2017 – September 2017

Senior Business Intelligence Consultant

Responsible for managing end-to-end delivery of client facing reporting packages using data analytics applications such as Oracle Business Intelligence 12c, Tableau and Field glass to ensure consistent processes and methodology across the landscape, working directly with business leaders.

Collaborated with the client HR team and leading the data analytics to provide insights into recruitment trends using OBIEE 12c reports in Oracle BI and streamline hiring process.

Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models using tools OBIA/BI Apps 7.9.6.3 with Informatica 9.x

Created monthly/quarterly KPI and operational reporting for the client and performing assessment on a Analytics & Reporting platform (OBIEE 12c) to enable self-service reporting for the users

Hosted the brainstorming sessions to identify the integration points from Field Glass to Oracle DV and Tableau.

Worked with Field Glass team to refine the available KPI & SLA reports to meet HR team’s requirements.

Worked with solution architects to translate business needs into data models supporting long-term solutions.

Environment: OBIEE 12c, Tableau, OBIA/BI Apps 7.9.6.3 with Informatica 9.x

Tech Mahindra - Telstra June 2016– May 2017

Portfolio Technical Business Analyst

End to end delivery of automation project for business process change management and infrastructure management, managing predictive analysis and forecasting reports in OBIEE and logging onto Splunk.

Performed strategic assessment of enterprise-wide BI application for OBIEE 11g and 12c. Developed and tested use cases and conducted preliminary analysis of pricing strategy, security and performance assessment.

Spearheaded the requirement gathering workshops with enterprise architects to align the inter-company location matching processes with the client’s main vendor, using OBIEE to create exception reports.

Analyzed various BI tools including OBIEE and Splunk for providing a matrix as an input to IT Architects so that Architects can recommend the best suitable tool.

Worked with developer, testers, business teams and architects to ensure during each phase of OBIEE Reports delivery.

Analyzed the business requirement and capturing business rules used in existing BI/DWH ODI and Datastage ETL jobs and OBIEE reports.

Analyzed the business requirement and translating it into data flow mappings, which are used for ODI mappings development

Documented or updated the understanding functional and technical solution in OBIEE including data mapping and metadata details.

Worked with support teams to understand the pain points in ODI highly load failures causing location mismatches.

Documented outbound and inbound data extract details as preparation for data re-modelling.

Validated business data objects for accuracy and completeness to ensure the solution is meeting business requirements.

Analyzed and documented end-to-end data flow, predictive analytics, forecasting of increasing data on business processes/infrastructure and transformation rules.

Worked on the Splunk’s predictive analytics and forecasting reports generated to display the coordination between business data, batch job and infrastructure dependencies.

Environment: OBIEE, ODI, Informatica, Splunk.

NBN Co

Role: Data Modeler March 2016 – June 2016

Project: Enterprise Location Management System

Remediated the data mismatches within the Enterprise location management system by half, using ODI integrations, VBA code and advanced excel plugin in OBIEE; identified and documented all the location management discrepancies.

Identified the issues with existing ELMS’s code in ODI to resolve the issues with the addressing data (using String modelling) which is coming from various source systems.

Created daily reports in OBIEE to display the stats of incoming, outgoing and remediated addressing data.

Performed reverse engineering of physical data models from databases and SQL scripts to resolve the spelling issues in street names.

Analyzed the business requirement, translated it into process and process mappings.

Analyzed Enterprise location management system to identify the pain points due to which addressing data was collected in quarantine.

Environment: ODI, OBIEE, Linux.

Accenture (December 2010 – February 2016)

Role: Business Intelligence Consultant November 2015 - February 2016

Project: Enterprise Location Management System

Led a team of four members on OBIEE reporting implementation using PNI as a source to provide around 20 new reports to Senior Executive customers, working directly with Managing Director; Helped Accenture to renew the contract for this application. Awarded ‘Accenture’s Excellence’ for client satisfaction.

Hands on experience in delivering technical solutions related to Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, Oracle BI Scheduler and Oracle BI Delivers, Oracle BI Application module such as HR, Finance, Procurement, SCM, GRC, construction, Primavera P6 etc.; Trained and mentored ten users on technical concepts of Oracle BI.

Managed deployments and delivery on OBIEE, ODI, DAC and Informatica applications.

Led international Customer Relationship application (CRM) team (3 in India and 2 in Australia) and coordinated with cross-functional teams and vendors for a project - complete overhaul of company’s Oracle customer relationship reporting (Oracle CRM on-demand reporting) system. Implementation resulted in multiple new features, stable application, and less down time for customers.

Managed the service level agreements of all the changes, incidents and problems for the client. Prepared weekly and monthly reports for the client and senior management

Led a team of 5 Technical and Business analysts to deliver both functional and technical enhancements to Oracle BI Reports, focusing primarily on ODI ETL.

Performed detailed data analysis using reverse engineering of physical data models from databases and SQL scripts in ODI for major production issues to identify the gaps between as-is functionalities.

Requirement gathering through client interactions and workshops and preparation of Business Case, Business Requirements Document, Business Process Specification documents.

Liaising with the Product Owners and other Business Analyst within the program to deliver end-to-end solution which meets the requirements listed in the BRD and other documents such as regulatory compliance rules, legal agreements, RFPs from prospective clients.

Creation of Functional Specification Document, User Interface screen specifications and modelling using Unified Modelling Language, Entity Relationship diagrams, Use case methodology etc.

Preparation of User stories and Requirement Traceability Matrices with clear acceptance criteria based on criticality index assigned for each requirement.

Conducting walk through meetings - Functional explanation sessions for developers to ensure the technical solution meets the requirements and specifications.

Organized and hosted weekly meeting platform leads of client to prioritize the delivery.

Provided weekly measures to Accenture senior management.

Worked on ODI 11g and PL/SQL related technical solutions with offshore team.

Mentored and trained onshore new joiners graduate as part of daily activity.

Environment: ODI, Oracle PL/SQL, Advanced Excel

Role: Campaign Management Coordinator December 2014 - November 2015

Project: Campaign Management

Coordinated the campaign management process for client team by bridging the gaps in ODI solutions.

Managed the service level agreements of all the changes, incidents and problems for the client. Prepared weekly and monthly reports for the client and senior management

Led a team of two offshore technical Analysts, and ensuring successful run of NBN’s weekly campaigns.

Coordinated with relevant stakeholders, offshore teams and third party organizations to resolve any issues in running weekly campaigns.

Performed sessions and discussions with business and detailed data analysis for major issues to identify the gaps between as-is functionalities to refine the data model.

Identified underlying areas of risk in weekly campaign process.

Organized and hosted bridge calls in case of major issues identified in weekly campaign run with Client, NBN Campaign management, Third Parties (such as Digital Alchemy).

Environment: ODI, Data Stage

Role: CRM BI Lead Technical Lead July 2013 - November 2015

Project: Customer Channel

Led international Customer Relationship application (CRM) team (3 in India and 2 in Australia) and coordinated with cross-functional teams and vendors for a project - complete overhaul of company’s Oracle customer relationship reporting (Oracle CRM on-demand reporting) system integrated with Oracle EBS. Implementation resulted in multiple new features, stable application, and less down time for customers.

Managed the service level agreements of all the changes, incidents and problems for the client. Prepared weekly and monthly reports for the client and senior management

Led a team of two technical Business Analysts, and ensuring quality solutions.

Coordinated with relevant stakeholders, offshore teams and third party organizations.

Performed sessions and discussions with business and detailed data analysis for major issues to identify the gaps between as-is functionalities to refine the data model.

Worked in collaboration with the design, test and product teams to produce solutions.

Provided high level strategic, analytical direction and vision.

Managed Oracle CRM upgrade projects (once in three month) starting from scheduling to successfully production upgrade. Also, I was point of contact for post upgrade issues.

Identified underlying areas of risk in upgrades and CRM on demand’s releases.

Prioritized tasks in accordance with corporate goals as part of my role.

Organized and hosted workshops with key stakeholders to demonstrate new upcoming features during upgrades.

Responsible for demonstrating the prototypes of new features as part of these workshops.

Environment: Oracle CRM on Demand, Data Stage, ODI, Tableau, Eloqua

Role: Oracle Business Intelligence Consultant June 2012 - July 2013

Project: Overall Business Intelligence solutions for Client NBN

Led a team of four members on OBIEE reporting implementation using Oracle Global Risk and Compliance as a source to provide around 20 new reports to Sr. Executive customers, working directly with Managing Director; Helped Accenture to renew the contract for this application. Awarded ‘Accenture’s Excellence’ for client satisfaction.

Hands on experience in delivering technical solutions related to Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, Oracle BI Scheduler and Oracle BI Delivers, Oracle BI Application module such as integrated with Oracle EBS modules HR, Finance, Procurement, SCM, GRC, construction, Primavera P6 etc.; Trained and mentored ten users on technical concepts of Oracle BI.

Managed deployments and delivery on OBIEE, ODI, DAC and Informatica applications.

Managed the service level agreements of all the changes, incidents and problems for the client. Prepared weekly and monthly reports for the client and senior management

Gathered requirement for Business Intelligence and Data warehousing solutions for OBI Apps in Oracle integrated modules - HR, Finance, Procurement, SCM, GRC, Construction and Primavera P6 areas.

Responded quickly to client requirements on day to day basis.

Documented the requirement into quality Functional Designs.

Worked with the design, test and product teams and produced solutions.

Created and reviewed Technical Design Documents.

Created logical and physical data models using OBIEE’s three-layer repository model.

I was responsible to explain complex technical issues in a way that non-technical people may understand.

Performed sessions and discussions with business and detailed data analysis for major issues to identify the gaps between as-is functionalities to refine the data model.

Prioritized tasks in accordance with corporate goals.

Converted data into business intelligence reports.

Coordinated User testing and performance testing with key stakeholders before each release.

Conducted workshops for key stakeholders to demonstrate new upcoming features during upgrades.

Performed the root cause analysis of a problem and then ensuring that it is resolved through the most appropriate solutions.

Worked with offshore teams (5 members) on technical solutions related to OBIEE 11g, ODI 11g, and Informatica.

Worked on in delivering technical solutions related to Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, and Oracle BI Delivers.

Managed the SLA’s of all service delivery items like changes, incidents, problems.

Environment: OBIEE, Informatica, ODI, DAC, Oracle GRC

Role: OBIEE Consultant December 2010 - June 2012

Project: Overall Business Intelligence solutions for Client NBN

Hands on experience in delivering technical solutions related to Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, Oracle BI Scheduler and Oracle BI Delivers, Oracle BI Application module such as Oracle EBS integrated modules - HR, Finance, Procurement, SCM, GRC, construction and Primavera P6 etc.; Trained and mentored ten users on technical concepts of Oracle BI.

Managed deployments and delivery on OBIEE, ODI, DAC and Informatica applications.

Managed the service level agreements of all the changes, incidents and problems for the client. Prepared weekly and monthly reports for the client and senior management

Hands on experience in developing solutions related to Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, and Oracle BI Delivers, Oracle BI Webserver, Oracle BI Enterprise Manager.

Worked with administrators, users and analysts to maintain exchange of reporting requirements of HR, Finance, Procurement, SCM, GRC, Construction, and Primavera P6 areas.

Performed sessions and discussions with business and detailed data analysis for major issues to identify the gaps between as-is functionalities to refine the data model.

Developed and deployed dashboards, analytics reports in OBIEE, ETL solutions, OBIEE Security matrix.

Created logical and physical data models using OBIEE’s three-layer repository model.

Design and place data in layers varying to physical, business and presentation of OBIEE repository.

Identified and troubleshooting production faults and critical issues.

Provided remedial measures to the production issues or process failure.

Trained the administration team on new OBIEE, BI and ETL tools.

Prepared weekly and monthly reports and present walkthrough sessions to the management.

Planned end to end and performing all deployments of OBIEE, ODI, DAC and Informatica as part of this role.

Trained in ITIL concepts to perform this role by offshore Senior Service Delivery Manager.

Environment: OBIEE, Informatica, ODI, DAC, Oracle GRC

Education

Banasthali University - Rajasthan, India; Master’s Degree in Computer Applications - scored a competitive 72%

Internship: Designed Klystron collector (specialized linear-beam vacuum tube) using simulation software ANSYS, considering stress and convention parameters.

TMIMT University – Moradabad, India; Bachelor’s Degree in Computer Applications

Volunteering & Personal Achievements

Corporate Citizenship in Accenture India - Bangalore & Chennai; Aug 2009 – Jun 2012

Volunteer – Skills to success program: Vocational skill trainings and self-help to women and kids from disadvantaged member of society.

Corporate Volunteer at “Dress for Success” in Sydney, Australia; Jun 2013 – Jun 2015

Organised fundraising events, imparting clothing, styling and presentation skills to women wanting to enter or return to the workforce.

Accenture Celebrating Excellence Numero UNO award in 2011

Accenture ‘Above and Beyond’ award in year 2012 and 2013

Completed coursera course Learn to Program(Python): The Fundamentals in June 2017

Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist certified with competitive 80% August 2017

Received client recognition for the on time project delivery in July 2018

**As an Australian Citizen, I am eligible for the E3 visa which is specifically for Australian professionals working for US employers. (This visa works similarly to the Canadian TN Visa and requires 1 form to be completed being the Labor Condition Application (LCA –US State Dept. Info)



Contact this candidate