Siddharth Chaturvedi
PL/SQL DEVELOPER
Details
adzt7v@r.postjobfree.com
Skills
PLSQL development
Database Administration
PL/SQL, XML, Sharepoint, T-sql
Data Warehousing
ETL Development
Linux shell scripting
Data Modeling
Profile
Over 11 years of extensive experience working with major technical projects across various products and service organization as a Database and ETL developer. Have a strong knowledge on Oracle database with languages like Oracle PL/SQL, JavaScript, UNIX shell scripting. Experience with Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications. Expert in Transactional/Dimensional Data Modeling. Experience in managing multiple projects.
Employment History
Database Analyst at BC Public Service, Victoria
DECEMBER 2020 — PRESENT
●Handles production database and perform data fixes to keep data in check.
●Write complex SQL queries to create reports requested by business from BC Registries.
●Created complex PLSQL packages to send emails to the clients once they register on the application.
●Worked on oracle job scheduler.
●Perform DBA activities for SQL server databases for analytic team handling sensitive data.
●Manage user profiles and authentication for mainframes environment.
●Create batches for BC Registries using shell scripts.
Senior Consultant at Fujitsu, Victoria, British Columbia
SEPTEMBER 2019 — OCTOBER 2020
●Worked as a DBA as well as database developer for client applications.
●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.
●Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects.
Analyst Professional at BT E-serv India Private Limited, Bengaluru
JANUARY 2018 — SEPTEMBER 2019
●Lead ETL team as a Senior Solution Designer.
●Translate Business Requirements to Conceptual and Logical Data Models
●Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of requirements and/or from a Logical Data Model
●This involved lot of PLSQL packages and functions to move data from staging to data mart.
●Participate in mapping of Logical to Physical Data Models and vice versa
●Evaluate other Modeler’s logical and/or physical data models for adherence to modeling
●Manage multiple assignments simultaneously, whether working independently or in teams
●Identify, recommend and implement emerging Modeling and IT trends, tools and solutions
●Review junior team members’ data models
Senior Consultant at Oracle Financial Services, Bengaluru
SEPTEMBER 2016 — JANUARY 2018
●·Work on the enhancement of the standard product FlexCube, which is used by multiple banks worldwide.
●·Work with Nedbank one of Oracle’s leading banking client to understand their banking structure and business requirements and customize the standard product FlexCube based on their policies and regulations using JavaScript and PL/SQL.
●Involved in Jobs Monitoring.
● Involved in Backup, Recovery and database maintenance activities
●Involved in database design and performance tuning
●Oracle database administration tasks - Software Installation, Database
Setup, Database Upgrade, Patch Application, Space Management, SQL
Tuning, Backup & Recovery.
Senior Member Technical Staff at MetricStream Infotech, Bengaluru
DECEMBER 2015 — SEPTEMBER 2016
●Most of the workflow logic was implemented in Oracle PL/SQL, with front end being Java/JSP.
●Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
●Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
●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.
●Building Reports according to user Requirement.
Senior Software Engineer at Accenture Services Private Limited, Bengaluru
NOVEMBER 2010 — NOVEMBER 2015
●Developed applications using Oracle PL/SQL, Microsoft SQL, JAVA, JavaScript.
●Involved in data migration using tools like Informatica 9.5 and SQL loader.
●Handled various accounts like FIAT and AztraZeneca for Accenture.
●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.
Education
Bachelor of Engineering, Rajiv Gandhi Technical University (University of Technology of Madhya Pradesh), Bhopal, India
SEPTEMBER 2006 — JUNE 2010
Courses
SAFe Practitioner
Oracle Cloud Infrastructure Foundation Associate, Oracle
Oracle Cloud Infrastructure 2019 Certified Architect Associate, Oracle
MAY 2020