Business Analyst Oracle Database

SHILPA KONER

Experience: *.*+ years in Oracle Analytics Cloud, DW, OBIEE & BIP Reporting, AWS, Integration/ETL-Informatica, IICS & ODI, PLSQL.

Current Designation: Business Analyst- Oracle, AWS

Contact: +1-214-***-****

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

PROFILE SUMMARY

Professional with around 7.5 years of IT experience, having sound knowledge of Oracle Database, OBIEE, ETL-Informatica, IICS & ODI, PLSQL and AWS.

Primarily involved in project support for OAC, OBIEE-12c and Oracle Data-warehousing, ETL-Informatica/IICS, ODI, PLSQL, Teradata and AWS.

Exposure experience in ETL Tools - Informatica 9.x and 10.x, IICS, ODI.

Report development experience with OBIEE.

Good knowledge in Data Modeling / Dimensional Modeling and RPD Design.

Proficient in SQL, PL/SQL, BTEQ script used for ETL Deployment.

Involved in Techno-Functional role to gather requirements from Oracle HR module in ERP to build Enterprise-wide Oracle BI / DW solutions and Management Information reporting solutions and supported Unit and Functional Testing.

Have worked on Projects for client: Archer, NHS -ESR.

Have worked on AWS S3, IAM, Amazon Quick Sight, AWS Glue, Athena, Redshift.

Possess good communication skills and client and team management skills.

ROLES ANDRESPONSIBILITIES

Experienced in Developing Procedures, Packages and Function in PL/SQL

Well versed in working with Oracle SQL, PL/SQL, Oracle Apps, ETL-Informatica/ IICS and OBIEE, BI Reporting, Teradata.

Experience in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.

Expert in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variable.

Experienced in working with ETL Tools such as Informatica Power Centre/ IICS in creating Source/Target definitions, building Mappings, creating, and monitoring Sessions/Workflows.

Experienced in ODI mappings and scheduling, monitoring mapping session.

Experienced in DAC scheduling tool.

Data load framework is being used to load the from S3 location to cloud Datawarehouse.

Experienced in creation of technical requirement documentation.

Having experience to create scheduling Cron job using Batch script/Shell script.

Having experience in Patch deployment and DB refresh activity.

Experienced in Change management.

Experience in creating database object such as Table, Views, Macro, Procedure in Teradata.

Good presentation, communication & analytical skills.

Sound knowledge of Data Warehousing concept, Dimensional Modeling, Star and Snowflake schema, Data Analysis and ETL process.

EDUCATION

Bachelor’s Degree (B.E) in Computer Science& Engineering from University Institute of Technology, Burdwan University, 2016

TECHNOLOGIES

Reporting Tools: Oracle Analytics Cloud (OAC), OBIEE 11g/12c, BIP, Quick Sight

Programming Languages: SQL, PL/SQL, Python, C, C++, Java (Primary), Batch Script (Primary), Shell Script (Primary)

ETL Knowledge: Informatica 9.x and 10.x, ODI 12c, IICS

Database: Oracle, MySQL, Teradata

Cloud Services: AWS S3, Glue, Lambda, SNS, Snowflake, Redshift and Quick Sight

Oracle Applications–HR and other Modules

Operating Systems: Windows, Linux

CERTIFICATIONS

AWS Certified Data Analytics - Specialty (DAS-C01)

Oracle Cloud Infrastructure 2022 Certified Foundations Associate

Oracle Cloud Infrastructure 2021 Certified Foundations Associate

Oracle Business Intelligence Foundation Suite 11 Certified Implementation Specialist (1Z0-591)

Oracle Data Integration 12c Essentials (1z0-448)

Microsoft Certified: Azure Fundamentals (AZ-900)

IBM Certified Advocate Cloud V1

Oracle Cloud Platform Enterprise Analytics 2021 Certified Specialist(1Z0-1041-21)

Microsoft 365 Certified Fundamentals (MS-900)

EXPERIENCE

IBM Consultant: Consultant (Sep -16 to Present)–7+ years

TRAINING

Oracle Financials Cloud: Enterprise Structures with GL IMP Ed1 PRV from Oracle University

Oracle Financials Cloud: Receivables to Collections IMPI Ed1 PRV from Oracle University

Oracle Financials Cloud: Procurement Implementation Ed3 PRV from Oracle University

Oracle Financials Cloud: Financials Reporting Ed3 PRV from Oracle University

Oracle BI 12c: Administration / Implementation

Teradata for Data Analytics

AWS Data Analytics

Oracle Data Integrator 12c: Integration and Administration

Oracle PLSQL and SQL training

Python for Data Science training

Hadoop Programming and Foundation- Level 1

ASSIGNMENT

Feb 2019– Jan 2024– NHS-ESR Project (5 years)

Solution Environment:

OBIEE, OAC, Informatica, IICS, ODI, PLSQL, AWS, Oracle HCM

Roles and Responsibilities:

Creating and submitting status report to upline managements.

Analysis, Design, Implementation and documentation and BI specifications that incorporate OBIEE/OAC development standards best practice as well as ongoing support Data Warehouse.

Working with ETL Tools such as IICS in creating Source/Target definitions, building Mappings, creating, and monitoring Sessions/Task flows.

Worked on performance tuning of various OAC Report/Dashboard.

Worked on ODI components like Designer, Operator, Topology and Security components.

Delivering custom and prebuilt with customized reporting elements in OBIEE.

Created physical, logical schema and contexts for ELT process.

Creation SDE, SIL, PLP mapping and workforce in Informatica.

Worked in production support environment as well as Test Environment for project, bug fixes, maintenance requests, enhancements etc.

Creating complex SQL script to load data using Informatica.

Design RPD star schema/ snowflake schema and having good concepts in OLAP, OLTP, SCD types.

Design PLSQL database object Triggers, Procedures, Views, Function etc.

Performing Onsite Offshore Co-ordination on day-to-day basis on deliverables and inter-team interaction on need basis.

Design, build and operationalize large scale enterprise data solutions and applications one or more of AWS data and analytics service in combination with- Kinesis, S3, Glue, Lambda, RDS, Snowflake and Quick sight.

Developed end-to-end data analytics framework utilizing Amazon Redshift, Quick Sight, Glue and S3 enabling business to obtain KPIs faster with reduced costs.

Mar 2017–Feb 2019– Archer- Project (2 years)

Solution Environment:

OBIEE, OAC, Informatica, ODI, PLSQL, DAC, AWS, Oracle Apps–HR and Other Modules

Roles and Responsibilities:

Primary focus on developing customer solutions using Oracle's analytics offerings: Oracle Analytics Cloud, Oracle Data Visualization, RPD Design, OBIEE and Autonomous Data warehouse (ADW).

Working with ETL Tools such as Informatica Power Centre in creating Source/Target definitions, building Mappings, creating, and monitoring Sessions/Workflows.

Delivering custom and prebuilt with customized reporting elements in OBIEE.

Creating Functional Data for Oracle HR–Learning and Certification, Core HR, Absence, and other Modules

Providing support to analytics, dashboard and operational reporting capabilities by documenting issues and fixes.

Designing a resilient framework using Amazon Web Services, which involves read/streaming from the producer/source through Kinesis Data Stream to ingest the data to client specific storage (S3) and process it through Glue and finally upload it into Redshift to analyze using Quick sight.

Design and Develop ETL process using Glue to load data from S3 to Redshift.

Creating complex SQL script to load data using Informatica.

Designing Reports and Dashboards modifications in OBIEE to meet additional client's business needs for analytical and operational reporting elements to migrate Discoverer reports.

Design RPD star schema/ snowflake schema and having good concepts in OLAP, OLTP, SCD types.

Design PLSQL database object Triggers, Procedures, Views, Function etc.

Creating BI Dashboard Report and Prompt.

Creating new task in DAC to run ETL mappings.

Creation SDE, SIL, PLP mapping and workforce in Informatica.

Creating new mapping and scheduling ETL run process in ODI.

Worked in production support environment as well as Test Environment for project, bug fixes, maintenance requests, enhancements etc.

Contact this candidate