Oracle PL/SQL Developer

Sourish Mukherjee

Developer

Address BJ-***, Sector II, Salt Lake, Kolkata, West Bengal, 700091

Phone 962-***-****

E-mail **********@*****.***

Data is my penchant forte! With over 4 years of programming experience as an Oracle PL/SQL Developer in analysis, design and implementation of business applications using the Oracle Relational Database Management System (RDBMS), I have been involved in all phases of SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Seeking a position to utilise my skills and abilities in a challenging environment that offers professional growth while being resourceful, innovative and flexible.

Skills

SQL, PL/SQL

Excellent

Oracle Forms & Reports

Very Good

Google Cloud Platform

Good

Tableau

Good

SSIS

Good

C, C++, Unix Shell Scripting

Good

Work History

2019-03 - Current

Google Big Query Analyst

Cognizant, Kolkata, West Bengal

Interpreting customer business needs and translate those needs into requirements

Analyse and understand data flow in source systems and implement the same logic in Google BigQuery

Design and develop high performing data solutions in Google BigQuery

Tune and modify existing scripts/solutions to improve performance

2017-11 - Current

PL/SQL Developer

Cognizant, Kolkata, West Bengal

Develop SQL queries and stored procedures to build and maintain application using Oracle Forms & Reports

Involved in Software Development Life Cycle (SDLC) process by analysing business requirements and understanding the functional workflow of information from source systems to destination systems

Create database objects like tables, views, stored procedures, functions, packages, cursors, ref cursors, etc

Perform transactional level recovery using Flashback transaction query

Perform DML, DDL, operations as per the business requirement

Resolve production issues by modifying backend code as and when required

2016-11 - 2017-11

SSIS Developer

Cognizant, Kolkata, West Bengal

Transforming and loading financial and statistical data from source system into SQL Server through ETL packages

Build extract, transform and load (ETL) process to migrate data from multiple types of data sources (SQL Server, Oracle etc.) to destination database server by using SSIS packages

Source the missing data into QA and production environment. Trace the process back with the help of SSIS packages and add new SSIS packages for new source

Implemented the UPSERT logic with the help of Hashkey, which compares the records in two different environments, every time the SSIS package runs

Understand the data entities in different environments

Prepare SSIS package and TSQL code for different interfaces

Prepare data mapping document for source to target entities

2016-06 - 2016-11

Tableau Developer

Cognizant, Kolkata, West Bengal

Create computer system and data visualisation solutions to improve business procedures

Create dashboard reports, collaborate with other developers and attend feedback sessions to improve systems

Developing, maintaining and managing reporting, analytics, dashboards and other BI solutions

Performing and documenting data analysis, data validation and data mapping/design

Reviewing and improving existing systems and collaborating with teams to integrate new systems

Conducting unit tests and developing database queries to analyse effects and troubleshoot any issues

2016-01 - 2016-06

Data Migration Analyst

Cognizant, Kolkata, West Bengal

Migration of data from two legacy systems to target system

Requirement gathering for data migration and data upload to target system

Study the general and entity specific rules

Mapping source entities and attributes to the target bulk upload template for each entity type

Highlighting data correction that is needed with respect to entities and predecessors, for successful migration

Work with client users and application owners to gather details around the databases and associated details for upgrade process

Test/verify migrated data

2015-09 - 2016-01

Cognizant Academy Training - PL/SQL Developer

Cognizant, Kolkata, West Bengal

The training was focused on utilising the procedural language extension for SQL in Oracle relational database and the close integration of TSQL into SQL environment

2015-09 - 2016-01

Cognizant Academy Training - SSIS

Cognizant, Kolkata, West Bengal

This training covered the basic concepts on performing data integration and transformation and obtaining results after applying different types of transformations

2015-09 - 2016-01

Cognizant Academy Training - SSAS

Cognizant, Kolkata, West Bengal

The training covered topics on building a tabular model using SQL Server Data Tools in Microsoft Visual Studio 2010 and integrating data from multiple sources into a single, logical view of information

Education

2011-09 - 2015-08

Bachelor of Engineering: Instrumentation Technology

M.S. Ramaiah Institute of Technology - Bangalore

CGPA - 7.7

Captain of College Football Team

2010-05 - 2011-05

High Secondary School Certificate

Delhi Public School - Panipat Refinery

Represented school in various co-curricular activities

2008-05 - 2009-05

Secondary School Certificate

Delhi Public School - Panipat Refinery

Passed with 84% marks

Software

Windows/MacOS Proficient

Excellent

PL/SQL Developer

Excellent

Tableau

Very Good

Microsoft Excel

Good

Languages

English

Native

Hindi

Native

Bengali

Native

Certifications

2019-05

Developing Applications with Google Cloud Platform Specialization

2019-05

Google Cloud Platform Fundamentals: Core Infrastructure

2019-04

Data Engineering on Google Cloud Platform Specialization

To view the certificates, click here!

Interests

Music

Cooking

Videography/Photography

Sports

Trainings

Google Cloud Platform

Understand the various offerings by GCP

Deploy and run services on managed platforms such as App Engine and Container Engine

Securely maintain application states with Cloud Storage, Datastore, and Bigtable

Leverage StackDriver monitoring and debugging to minimise downtime and mitigate issues without impacting users

Integrate with best-in-class big data solutions such as BigQuery, Dataflow, and Pub/Sub

Tableau

Learn data visualisation through Tableau 10 to analyse and visualise data

Learn to connect Tableau to variety of datasets

Understand types of Joins and how they work

Work with Data Blending in Tableau

Visualise data in the form of various charts, scatterplots, maps and create interactive dashboards for projects

Create table calculations, work with parameters

Export results from Tableau into PowerPoint, Word, and other software

Work with Timeseries data

Understand Aggregation, Granularity, and Level of Detail

Adding Actions to Dashboards (filters & highlighting)

Assigning geographical roles to Data Elements

Transferable Skills

Possess a positive ‘can do' attitude and a willingness to grasp opportunities

Strong organisational and planning skills

Organise material and information in a systematic way

Creative and perceptive

Willing to experiment with new approaches or ideas

Excellent communication skills - both written and verbal

Effective in dealing with different kinds of people

Promote ideas effectively without tearing down competing ideas

Well-developed interpersonal skills with ability to create an instant rapport with colleagues/clients

Take action to achieve a goal beyond what is called for

High efficiency with ability to prioritise work schedules in a busy environment

Ability to function independently and as part of a team with minimum supervision

Contact this candidate