Data Engineer Oracle Plsql

Siddharth Chaturvedi

Data Engineer

● Handles production Oracle database and perform data fixes to keep data in check.

● Write complex SQL queries to create reports requested by business stakeholders.

● Worked on few Database Admin activities to maintain our production oracle databases.

● Worked on advanced Oracle PLSQL functionalities to create and schedule daily batch jobs.

● Worked on PowerBI desktop and reporting server to modernize the reports currently being used.

● Handled data migration from old system to the modernized systems consisting of Postgres.

Senior DBA at Fujitsu, Victoria

September 2019 — October 2020

● Worked as a DBA to create and maintain number of Oracle and SQL server databases.

● Worked on Dataguard configuration for implementing and maintaining standby databases.

● Worked on SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.

● Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.

● Maintained disaster recovery using Database Backups RMAN

(Full/Incremental backups) .

● Worked on LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces. Technical Lead at BT E-serv India Private Limited, Bengaluru January 2017 — September 2019

● Lead a team of ETL/BI developers.

● Ensured the data models were reviewed and updated consistently to ensure compliance with standards and to aid system integration efforts.

● Led change control meetings with business and developers to discuss proposed changes and understand at what level they applied.

● Hiring and training new team members for the team.

● Handling team activities involving team of different contractors from Details

300 Six Mile Rd, Victoria, V9B

5Y3, Canada, 250-***-****

siddharth.chaturvedi18@gmail.c

om

Skills

Oracle

PLSQL

Database Administration

Data Analysis

ETL

SQL

Informatica PowerCenter

Microsoft Power BI

Shell Scripting

Profile

Over 14 years of experience in IT industry involving Software Analysis, Implementation, Coding, Development, Testing, Maintenance and Project Management with focus on Oracle databases and related technologies. Experience with PowerBI development with a proven track record in BI, Datawarehouse, Lead multiple projects as Technical Lead, Data Architect and IT Engineer. Proficiency in SQL, PLSQL, relational data modeling, Informatica, PowerBI, Database Administration etc.

Employment History

Senior Database Analyst at BC Public Service, Victoria December 2020 — Present

different locations as being a single point of contact.

● Reviewing codes and data mappings.

Team Lead at Oracle Financial Services, Bengaluru

September 2016 — January 2017

● Understand the requirements, functional design document, ETL requirements from the BA/ onsite counterparts.

● Analyze for gaps, check feasibility from the design perspective and seek any clarifications (iterative process).

● Understand the functional/ non functional requirements.

● Participate in client calls and prepare the clarification list to seek clarifications.

● Prepare the list of requirements and seek review inputs from the key stakeholders.

● Update requirements traceability matrix.

● Create impact analysis document (for simple change) to understand the impact on the existing functionality, as required.

● Provide inputs to testing strategy, configuration, deployment, hardware/software requirement etc.

Senior ETL developer at MetricStream Infotech, Bengaluru December 2015 — September 2016

● Implemented workflow logic in Oracle PL/SQL, with front end being Java/JSP for user applications.

● Develop the mappings using needed Transformations in Informatica tool according to technical specifications.

● Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

● Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

Senior Software Engineer at Accenture Services Private Limited, Bengaluru

November 2010 — November 2015

● Developed backend logic using Oracle PL/SQL, Microsoft SQL, JAVA, JavaScript.

● Involved in data migration using tools like Informatica and SQL loader.

● Managed Oracle 11g/12c databases using traditional DBA methodologies like RMAN, EXPDP/IMPDP, database clone/refresh.

● Worked on SQL performance tuning for maximum performance of reports.

● Handled various accounts across multiple domains. Education

Rajiv Gandhi Technical University, Bachelor of Engineering, Bhopal September 2006 — June 2010

Courses

SAFe Practitioner

Oracle Cloud Infrastructure Foundation Associate, Oracle Oracle Cloud Infrastructure Certified Architect Associate, Oracle

Contact this candidate