Data Warehouse Business Intelligence

************@*****.*** RAJIB SARKAR Ph: 502-***-****

Professional Summary

Oracle certified database consultant with over 25 years of experience in Telecom, Healthcare, and Finance domain. His areas of expertise include Production support, Data Warehousing, Database Administration, Enterprise Data Management, Business Intelligence, and Database Designing, Database and Application Migration.

Highlights

Database Management: Relational database design and development using various database objects such as stored procedures, stored functions, packages, TYPE objects, triggers, cursors, ref cursors, parameterized cursors, view, materialized view, PL/SQL collections and XML Parsing packages, Database optimization. Data Security.

Analytical/User-Interface Tool: Front-end development using Oracle Forms & Reports, created basic Analytical report using tableau.

ETL Development: Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions using various versions of Informatica

Database/System administration: System and Database capacity planning and implementation, Backup strategy planning and implementation. Operating system (HP-UX to Linux) migration, SAN migration (HP to EMC) Tablespace transport (using conversion), post upgradation performance benchmarking.

Data Warehouse: Dimensional modeling using star and snow flake schema, development cycle of Data Warehouse, including requirements gathering, design, implementation, maintenance and performance optimization.

Business Process Outsourcing: Offshore-Onshore coordination, Escalation process, People management.

Technical Skills

Databases: Oracle (7, 8, 8i, 9i, 10g, 11g,12c,19c), Netezza (7.0, 7.2), DB2 (10.5), MS SQL Server 2008,

Languages: SQL, PL/SQL, T-SQL, Java

Dev Tools: Developer 2000 (forms and report), SQL*Loader, Apex (HTMLDB), Toad

Platforms: Linux ES/AS (Red Hat), UNIX (HP-UX)

ETL Tools: Informatica PowerCenter (9.0.1/8.6.1/8.1/7.0)

Others: Shell scripting, Autosys, Control-M, Erwin

Professional Experience

Bank of America/Mitchel&Martin May 2024 – Current

Sr. Application Developer Jersey City - NJ

CSAR ( Comprehensive Source for Analytics and Reporting) is an Enterprise-wide Authorized Data Source of Sales Performance data for Institutional Sales. ESAR reporting is provisioned through a VerticaM Datawarehouse platform to two BI platforms Tableau(CSAR Tableau) and Cognos (SAR.BI). The CSAR data also makes up the majority of the data available on the Production tabs of Compass (Sales CRM Platform) Users Groups: CSAR caters to users across the globe. (AMRS / EMEA / APAC)

Coordinating and Managing weekly Release using Git Hub.

Coordination and managing operating system and ETL tool upgradation for the entire systems which consist of 12 servers including QA and Production.

Developed and optimized stored procedures, functions, and SQL queries in Snowflake, resulting in an enhanced report generation process that saved 20 hours of work weekly.

Environment: PL/SQL, Oracle 19c, Toad, JIRA, SharePoint, shell, Putty, informatica and UNIX

Department of Health/New Jersey March 2023- Oct 2023

Senior Database Developer

Electronic Case Reporting (eCR) is the secure creation and transmission of case reports from an electronic health record (EHR) to public health agencies for disease tracking, case management, and contact tracing. Like traditional reporting, eCR captures critical patient and clinical data regarding demographics, comorbidities, immunizations, medications, and other treatments.

Spearheaded the migration of massive datasets totaling over 5TB from a legacy data warehouse to Snowflake, ensuring seamless transfer with no downtime

Understanding the project by going through the existing code, gathering scope of improvement.

Creation of database packages for delivering complex report using XML Utility.

Python & Oracle development within Regulatory reporting.

Optimization of existing queries and reports using AWR utility.

Creating Python programs using “cx_Oracle” functions to execute oracle packages.

Environment: PL/SQL, Oracle 19c, Toad, JIRA, SharePoint, Python

Bank of America/ TEKsystems Feb 2022- March 2023

Application Architect Jersey City

Data Retention Framework, is part of Global Risk Management policy of Bank which ensures that expired data, based on judiciary is deleted, This project was created to identify data across the platform according to the jurisdiction of the data and erase from the system.

Implemented complex ETL pipelines in Snowflake that allowed for the ingestion and transformation of diverse data sources, enhancing the analytical data foundation.

Creating informatica workflow for data extracts and load from outbound and inbound data

Creating shell scripts on Unix server, for file watch and job execution

Environment: PL/SQL, Oracle 12c, Toad, JIRA, SharePoint, shell, Putty, informatica and UNIX.

Client Network Services Inc/nTech Solution July 2020 – Feb 2022

Sr. Oracle Database Engineer Michigan(Remote)

Michigan has many healthcare programs available to Michigan residents (children, families and adults) who meet eligibility requirements. Medicare and Medicaid are two different government-run programs that were created in 1965 in response to the inability of older and low-income Americans to buy private health insurance. This project was developed to aid and assist the Michigan staff members to enroll the members in the different programs available to Michigan residents.

Creating the PL/SQL packages/procedures, functions, tables, views, various SQL queries and triggers for different business modules in CHAMPS. Generating the data extracts in different data formats for clients using TOAD, SQL Plus and SQL Developer.

Tuned the SQL queries/Procedures using Explain plan, TKPROF and Trace utilities.

Created dashboards based on user’s specifications using tableau 2021

Environment: PL/SQL, Oracle 12c, Toad, JIRA, SharePoint, shell, Putty, subversion and UNIX.

Bank of America/Data Inc. Sep 2019 –Mar 2020

Sr. Application Developer Jersey City - NJ

This application provides bank’s performance dashboard to the top management using historical data as well as real-time data feed from the stock markets at three minutes interval. Reports are categorized by geography as well as various organization units. Creation of database packages for delivering complex business report using DBMS_SQL Utility.

Taken part in Informatica repository rebuild for production parallel environment

Rebuilding SQL Queries for Business Reports using new relational data model

Environment: Oracle 12c, SQL, PLSQL, Toad, Linux, Informatica Power Center 10.2

CVS Health/Randstad Technologies May 2018 – Jun 2019

Oracle Developer Florham Park – NJ

Project SPARCS was designed to allow users to create and submit invoices for billing, apply payments to charges and manage patient accounts. which used to create and fill orders. Now these two systems have to manage also PBM (Pharmacy Business Management) for Anthem and all existing functionality has to be segregated for CVS (existing) and Anthem (new) using newly created entity – Organization Banner.

Analysis, Designing, Developing and Modifying of modules using Oracle SQL and PL/SQL, Forms.

Part of migration plan and developed Migration strategy and Packages for data-load in staging, cross referencing and DataMart tables.

Environment: Oracle 12c, SQL, PLSQL, Toad, Linux, Oracle Forms & Reports 9i

Inpensa Inc. Sep 2017 – Apr 2018

Oracle Developer Florham Park – NJ

Connected Capital Planning platform helps businesses streamline operations and costs related to short and long-term capital investment programs by enabling users to define, plan, and track all financial activities. It offers a host of features such as capital appropriation requests management, performance monitoring, multi-year capital planning, governance and integration management and more.

Analysis, Designing, Developing and Modifying of modules using Oracle SQL and PL/SQL

Tuned the SQL queries/Procedures using Explain plan, TKPROF and Trace utilities.

Migration from legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table

Environment: Oracle 12c, SQL, PLSQL, Toad

Bank of New York Mellon / Visul Softtek LLC Nov 2016 – Aug 2017

Programmer- Consultant Brooklyn, NY

Mortgage Industry Standards Maintenance Organization – Is a web-based application with a dedicated network communications facility to provide Ginnie Mae Issuers and Custodians with a timely, accurate, reliable and paperless method for: New Pool Processing, Investor Reporting, Certifications.

Developed advance PL/SQL packages for masking sensitive data using partial data Redaction.

Developed PL/SQL package for Audit Logging on sensitive data retrieval using Java in Informatica

Environment: Oracle 11g, UNIX, Informatica Power Center 9.1, Java

Bank of America/IRIS Software Mar 2016 – Oct 2016

Sr. PL/SQL Developer Pennington, NJ

Award Choice System – Is a corporate equity compensation program that provides executive stock option management services for companies and their employees. This system works with different type of awards such as Stock options, Performance awards, Dividend-equivalent units.

Created Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Involved in the continuous Enhancements and fixing of production problems.

Coordinated and delegated and reviewed the deliverables with Offshore team.

Environment: Oracle (11g/12c), SQL, PL/SQL, SQL Developer, Toad, SQL*Loader, Shell Scripts

Thomson Reuter/TCS Feb 2014 - Oct 2014

Project Lead Eagan, MN

Data Quality maintenance of the legal system. It also included application server migration from non-strategic to strategic data centers. Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.

As an Information Architect, involved in gathering of data requirements through facilitated sessions or Use Cases, and designing data models based on those requirements.

Formulated a comprehensive data migration plan with data structures and movement evaluation and field mappings.

Conducted data structures and movement evaluations.

Implementation of Real Application Clusters (RAC), and backup strategy using RMAN

Performed initial data migration, subsequent delta migrations and validated the data been converted

Environment: Oracle 12c, Red Hat Linux 7.01, Informatica 9.1

Kaiser Permanente/TCS Sep 2011 – Jan 2014

Sr. Tech Lead Portland, OR

“CLEAR Solutions” project converted existing ICD (International Classification of Diseases) 9th revision system into ICD-10 compliance system and developed a system which maintains data and process consistency across all the regions.

Roles & Responsibilities:

Requirement, Design analysis and development of ICD9 - ICD10 Conversion and Reporting Solution.

Performance tuning, problem determination and resolution during the development life-cycle.

Environment: Oracle 10g, HP-UX, Informatica 9.1

Humana Inc/TCS Oct 2010 –Aug 2011

Technical Lead Louisville, KY

The project setup a scoring process to rate a doctor’s performance based on the visiting history of the member patient. It also included development of a system to process bank remittance advice to the provider based on the customer information.

Roles and Responsibilities:

Created Materialized Views and partitioning tables for performance improvement.

Developed UNIX shell scripts to perform a nightly refresh of the test system from Production

Created packages SQL*Loader scripts to load data into the temporary staging tables.

Environment: Oracle 10g, SQL, PLSQL, Linux, Netezza, Informatica, Erwin

Kingfisher Plc/TCS Jan 10 – Oct 10

Database Architect Southampton, UK

The “Database Stabilization” project stabilized an unstable and poor performing database, which encompassed database designing, performance tuning, data modeling, Materialized View creation and re-coding / regeneration of existing logic and code.

Designed the database structure, created new Oracle Database instance and provided support for both Test and Prod environment.

Review of Business-Critical Database to proactively identify space issues, performance tuning

Experienced in tuning of ERP jobs, time/CPU consuming SQL Queries

Implemented backup using RMAN, Shell Scripts

Environment: Oracle 10g, SQL, PLSQL, HP-UX, Erwin

Eli Lilly & Co/TCS Oct 2008 – Dec 2009

Sr. Application Lead/Developer Indianapolis, IN

Development of a Global Manufacturing Datamart (GMDM) to provide the reporting solutions for all the manufacturing sites. The Global Manufacturing Datamart got loaded from Manufacturing Data Integration (MDI), Laboratory Information Management system (LIMS), MAXIMO (GMARS), Pharmaceutical Manufacturing execution system (PMX), TrackWise, Process automation (PA) and other systems.

Roles & Responsibilities:

• Creation of PL/SQL Packages, Procedures and Functions for data migration to GMDM.

• Involved in writing UNIX shell scripts, PL/SQL procedures, Pre-session and Post- Session Scripts.

Tuned complex Stored Procedures for faster execution and Developed database structures

Created Materialized Views and partitioning tables for performance reasons.

Environment: Oracle 10g, SQL, PLSQL, Linux, Informatica 9.1

British Telecommunication Group Plc/TCS Jan 2005 – Oct 2008

Technical Architect / Database Administrator Kolkata, India / London, UK

Various projects encompassing Operating System (HP-UX to Linux) and SAN (HP San to EMC) migration for Oracle 10g, database, Tablespace transport using RMAN conversion, Oracle Database and OWB upgrade, Performance benchmarking for post upgradation, Database designing for QA and production.

Roles & Responsibilities:

Planned and Migrated Database version from Oracle 9i to Oracle 10g

Creating performance benchmark for post up-gradation. Database designing for test and production

Planned and design database migration plan for operating system (HP-UX to Linux) using tablespace transport.

Planned and design migration plan for storage system SAN (HP San to EMC)

Implementation of Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Oracle Data Guard.

Preparation of RMAN full and incremental backup script.

Designed and developed automatic alert system to monitor performance.

Performed advanced DBA functions: Physical DB design, linked server definition and security, Day-to-day DBA monitoring and business needs analysis

Environment: Oracle 10g, SQL, PLSQL, Linux, HP-UX

Prior Professional Experience

Simplex concrete and piles 2004- 2005 Database and System Administrator Kolkata - India

Shrachi securities Limited 2000-2004 Manager EDP Kolkata - India

Stanco Informatics 1998-2000 Oracle developer Delhi - India

Technical Summary

Sr. Database/ETL developer

PL/SQL concepts like Bulk collect and ForAll, Dynamic SQL, Records, Arrays and Exception Handling

Migration of data using SQL*Loader/External table to migrate from non-Oracle Databases.

Designing and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts.

Deployment of mappings using various transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.

Deployment of reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.

Development of slowly changing dimensions to keep full history to the target database.

Performance tuning of mapping and sessions by optimizing source, target bottlenecks and implementation of pipeline partitioning.

Scheduling various daily and monthly ETL loads using Control-M, Tidal and Autosys.

Writing Unix shell scripts to run and schedule batch jobs.

Database Administrator/Technical Architect

Operating system (HP-UX to Linux) and SAN migration (HP to EMC) for Oracle database (10g), Tablespace transport (using conversion), Oracle DB and OWB upgrade, Database designing for test and production.

Installation and configuration of 10g Database and 10g Application server in EMC CX-300 SAN storage device on the basis of virtual IP for proper functioning of Red Hat cluster Suite.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.

Configured RMAN for full and incremental backups and used RMAN to create standby databases, for recovery, to migrate database from file system to ASM

Experienced in using 11g features Data Pump, Flash - Back Recovery, AWR, ASM, ADDM, ASMM, Grid control, and Recycle Bin.

Plan, Implement and test disaster recovery using RMAN and custom written shell scripts.

Create and maintain oracle Data Guard configuration for disaster recovery and to manage planned maintenance.

Strong working experience in Install/Upgrade and Migration, troubleshooting of Oracle script files creation (using SQL, PL/SQL) for creating, maintaining, tuning the database, tuning the parameters as and when the situation demanded.

Database monitoring and tuning, application and queries using AWR,ASH,ADDM, OEM

Experience in taking logical backups of data using oracle data pump utilities expdp and impdp to move Oracle data from a database or schema to another.

Project Leader

Recommending technology strategy to rationalize technology portfolio.

Managing global teams of over 40 resources in various projects.

Overseeing analysis of requirements, design analysis and creation of prototype for various reporting solutions.

Handling client to sort out various issues including periodic status meeting.

People management including offshore-onshore coordination.

Educational Summary

Degree and Date

Institute

Major and Specialization

Master of Science – 2009

Sikkim Manipal University

Computer Science

Contact this candidate