Front End Sql Server

Subhendu

Email Id :

Ph: 414-***-****

Ghosh

****************@****..***

Location: Irvine, California, USA

LinkedIn:

SQL Developer with Database Designing,

**************@*******.***

****************@*****.**

Query Optimization, and API

m

Creation using Spring Boots, Node JS and

Python

Summary

Has Overall twenty-five years of experience. Experience in multiple Database technologies including Oracle, SQL Server, DB2, Teradata and Sybase. Has extensive experience in PL/SQL developing Stored Procedures. Packages, Triggers and Functions including Pipelined table functions. Has good knowledge of Oracle Database Query Optimization and complex query compiling and optimization. Has knowledge of front end and backend technologies Java, J2EE, Spring Boots, JavaScript (Nodejs and ReactJS). Has Knowledge of Cloud Technologies including Azure and AWS.

Experienced in Oracle PL/SQL development and Optimization of Complex SQL Queries.

Experienced in MS SQL Server T-SQL development and Optimization of Complex SQL Queries.

Experienced in IBM DB2 SQL development and Optimization of Complex SQL Queries.

Experienced with Python Scripting using Pandas, NumPy and Matplotlib.

Automated ETL testing framework using Python and Javascript.

Experienced in NodeJS, ReactJS, Java J2EE, JavaScript and Ajax Framework related technologies for front end development and DataStage, Informatica, SSIS (SQL Server Integration Services) for back-end development.

Experienced in Scripting Using Python and Shell Scripting.

Experienced in Azure Cloud ETL (ADF) Azure Data factory.

Experienced in Data Warehouse, Data Lake and Cloud Database Services like Snowflake. Experienced in Site Core Implementation and Customization based on Client requirements. Has worked in the capacity Development Lead, Sr Developer, Project Lead Has worked as manager on CMS projects.

Has good understanding of the full SLDC of a project.

Has extensive knowledge of Insurance, Telecom and Travel Industry domains.

Worked as Assurant Specialty Property in the capacity of a Sr Developer cum Data Quality Assurance.

Current Visa Status: GC (Green Card)

Role History

•

PL/SQL Development, Scripting (using Bash and Python), Database Designing for Data Marts --- 2023 --

current.

• Technical PM cum T-SQL Developer (Scrum Methodology, T-SQL Development and API designing

using Node JS) --- 2016-2022

• Technical PM cum PL/SQL Developer (Waterfall Model PL/SQL Development, Query Optimization and

Automation) --- 2012-2015

• Architect [2005-2011 PL/SQL Development, DB2 SQL Development, XML parsing using Java and

Database Designing with Automation]

•

Sr Developer [2003-2005]

•

Developer 1996-2004]

Education

•

Post Graduate Diploma in Computer Science and Application [1991-1993]

•

Bachelors (Mathematics) [1988-1992]

Expertise

•

Development in Multiple Technology

• Front end and Back End development

• Dimensional Modelling and Big Data Architecture

• Team Leading, Mentoring and Management

Certifications

•

IBM Quality Stage Certified

•

Teradata 12 Certified

• Azure AZ-900 Certified

• Azure DP-900 Certified

• Certified Scrum Master 2023

• SAFe 6 Agilist Certified 2023

Awards

•IBM Star of the Quarter (twice)

Experience Summary

Recent Experience (Last 10 Years)

Application Lead PL/SQL

Continuum Cloud June 2024, Oct 2024

Created pipelined functions using PL/SQL. Created stored procedures to paradise XML documents

Create Python Scripts for generating extracts to be sent to multiple clients.

Create Pandas script using Python to load tables into Data Frames and validate data.

Provided solutions for query optimization

Created and implemented materialized views for query re-writing.

Provided advice query reports for and users.

Technology Oracle 12C, JavaScript, Ajax, she’ll scripting.

Technical Lead Cum Pl/SQL Developer

American Eagle Oct 2023 to April 2024

Create multiple stored procedures, triggers and functions using PL/SQL.

Provided query optimization solutions using materialized views and query re-writing.

Developed API’S using Spring Boot calling the Oracle stored procedures and functions.

Technology Oracle, Java Spring Boot, Linux, scripting

Technical Scrum Master Cum Pl/SQL Developer (Technical PM) ---

Vialto Partners Data Platform Implementation Aug 2022 – Aug 2023

Perform Scrum Master Role including Daily Standup, Backlog Management, Sprint Planning, Backlog Refinement, and Retrospectives

Perform Project budgeting and Incremental Budgeting and project ramp up/down.

Created Technical document on Snowflake implementation and shared the details with project team.

Provided technical details on Loading Data into Snowflake using ADF (Azure Data Factory).

Created python scripts to load data to Snowflake connecting to Snowflake using region and user password parameters. This was a generaic script used to load data to Snowflake without the need for intermediate staging areas.

Created a ADF Pipeline to automatically decipher metadata from source and create a table in Snowflake with this metadata and load data into the table.

Migrate Data from Snowflake to Oracle data Marts using ADF pipelines

Create PL/SQL Packages and Stored Procedures and Triggers for Summarized data used in Reports for Power BI.

Helping team deliver reports using Power BI and provide query optimization for power BI Reports

Providing the technical inputs required to solve issues in Power BI provide Query Optimization techniques for faster Data Retrieval into Reports.

Technology (Azure Echo System, Snowflake, Oracle Python and Atacama)

oBeckman Coulter Site Core Implementation cum PL/SQL Developer Feb-2022 – July 2022

Perform Scrum Master Role including Daily Standup, Backlog Management, Sprint Planning, Backlog Refinement, and Retrospectives.

Perform Project Budgeting and Incremental Budgeting and project ramp up/ramp down.

Perform Custom Code review, provide technical solution for Integrating Marketo Into

Site Core, Creating API’S for consuming within Site Core for custom development,

Create customized Table Functions using PL/.SQL to be consumed by Site Core. Also worked on Optimizing queries used in pipeline functions .

Completely Automated JIRA reporting using custom JavaScript to interact with JIRA, get all story details, dump data into Excel and create Custom Excel graph and mail the Excels to intended recipients.

Technical solutioning of Core Site Core components.

Technology (Site Core, AWS, Oracle, Marketo,

Beckman Coulter (Phoenix Next Gen project) Cum PL/SQL Developer Jan -2020-Feb-2022

Perform Scrum Master Role including Daily Standup, Backlog Management, Sprint Planning, Backlog Refinement and Retrospectives.

Provided initial budgeting for the project and later has to do some incremental budgeting as project scope increased.

Ramped up team based on project requirement.

PL/SQL development of Oracle Packages and Stored Procedures for faster data Retrieval and processing.

Designed parameterized Table Functions using PL/SQL for faster response (using Pipelined architecture)

Created all GET API’s using Sprint Boot and PUT/DELETE API’s using Node Js.

Maintained entitlement data for APII’s for Security access and data access.

Created Nodejs script to Load Data from SQL Server to Oracle for more than fourteen tables having varying data types using AWS batch Jobs for Data migration from SQL Server to Oracle.

Perform Code Review, fix critical Bugs within SLA.

Created JavaScript Code to interact with AWS S3 Bucket to upload and download document to and from S3 Bucket as required.

Fix UAT issues on priority.

Technology (Oracle, Oracle PL/SQL, Node JS, React JS, AWS, containers, Atlassian JIRA, Spring Boots)

Assurant Specialty Property (SSP Project) cum T-SQL Developer Sep 2016 – Dec 2019

Perform Scrum Master Role including Daily Standup, Backlog Management, Sprint Planning, Backlog Refinement, Business Discussions and Retrospectives.

Project Ramp up by three members of Client request.

Propose addition budget for a period of three months.

Create Custom Report Viewer using C# and ASP.Net for viewing SSRS reports and comparing reports across environments.

Created a testing framework in Python to call some T-sql stored procedures and perform ETL validation and publish the results in excel and distribute to multiple receipents

Created table valued functions exposed as API,s for frontend tools.

Monitored query performance using query store and extended events.

Used JSON parsing using T-SQL and SQL Queries

Create Enterprise Data model for The Data Warehouse and developed SSIS jobs to populate data warehouse tables. Fine-tuned queries for SSRS reports, created custom component in C# for dynamically creating Stories in TFS (team Foundation Server).

Perform UAT fixes with SLA and guided Offshore team on development life cycle

Technology (SQL SERVER, T-SQL, C# TFS, SSRS for Reporting)

Assurant Health (Enterprise Warehouse and Data Marts Implementation) cum PL/SQL Developer Apr 2012- Aug 2016 80% Technical 20% Managerial

Performed daily Meetings with Development / QA teams, Meetings with Client Business counterparts and weekly calls with major Stake Holders

Provide detailed project plan with Budgeting details to Client and work on incremental budgets and project escalation management and project ramp up / ramp down

Provided Query Optimization for Oracle Queries, Using PL/SQL t Create Pipelined Functions for faster response and optimized Oracle response time through Indexing and Partitioning.

Created Dimensional Data Marts for Specific reporting needs.

Used Data Stage as ETL tool to populate tables in the Datamart and make the jobs run on a daily schedule.

Performed DataStage Administrator role for some duration of the project.

Provided ETL best processes to development team and fine-tuned reporting queries.

Provided solutions for Reporting using Cognos.

Architected the metadata Management using IBM Metadata Management Tool.

Provided custom Metadata Reporting for end users and business analysts for better understanding of Impact Analysis

Created proposed plan to migrate ETL jobs from DataStage to Informatica as per client requirement.

End to end implementation with a team of five developers for managed care solution. This included getting relational data from Oracle, semi structured Data in JSON format Parsed using C# and Providing reports in Custom Excel Sheets coded with Excel Macros.

Big Data Implementation using IBM Infosphere and implementing a 32-node cluster.

Moving data from Data Marts to Hadoop clusters using Hadoop tolls like Scoop and Hive

Technology (ETL DataStage, Informatica, Database Oracle, Big Data Platform IBM infosphere)

Experience Summary

Past Experiences

•Architect Cum Senior Developer Cum Project Lead 100% Technical

oAlcatel Lucent (Customer Experience Management Project) Jan-2011 – Feb-2012

Design Data Warehouse and ETL processes to store data in the warehouse.

Use ETL DataStage to populate the warehouse.

Lead a team of five developers to Develop more than fifty reports using OBIEE

Perform Code review and design best coding practices.

Analyze Source data from Portal Logs and perform Data cleansing and transformation.

Technology Used (ETL DataStage, database Oracle, Reporting OBIEE)

oZAIN Telecom Group Dashboard, Zain Telecom Jan-2009 – Dec-2011 100% Technical

Analyzing source data from fifteen different locations

Analyzing data patterns and data storage mechanism across locations.

Formulate the data pull strategy from locations using ETL connectors using DataStage.

Create Dimensional data marts (in Oracle) for end user reporting.

Lead a team of three developers for developing reports and report viewer.

Create reports and Dashboard using OBIEE and custom Java workbench.

Provide Report filters for each location and define access level for each report.

Author a custom report viewer using C# and ASP.net.

oTelstra Data Migration Project (Telstra Australia) Sep 2005 – Dec 2009 100% Technical

Enterprise Warehouse Design and implementation

Reporting data marts creation and data feed from Enterprise warehouse

Leading a team of ten members for ETL and Reporting

ETL jobs created using DataStage and Reporting using Cognos and Qlik View.

Created Batch Jobs for executing ETL jobs on a given schedule.

Technology (ETL DataStage, Reporting Cognos and Qlik View, Scheduling workflows)

•Developer and Senior Developer

oRail Europe Group (Euronet and Euronet2 Projects) Sep 1996 - Aug 2005 100% Technical

Front end development using Informix 4GL, Informix database and database scripting.

Revamp the UI using JSP, Servlets, Struts Framework

Migrate Data from Informix to Oracle.

Created OLAP cubes using Cognos and Reporting from Cubes

Creating Dashboards using JSP and Servlets

Worked in a team of ten developers.

Technology (Informix, Oracle, JAVA, Struts, Cognos, Visual Basic)

Contact this candidate