Front End Back

Subhendu Ghosh Email Id – ********.*****@******.***

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

Location: Irvine, CA, USA LinkedIn:

www.linkedin.com/in/ghoshsubhendu123

Summary

Has More than twenty Years of Experience Project Development/Managing/Delivering using Front End and Back End Technologies. Well versed with Java J2EE, JavaScript, Strong Experience in PL/SQL development.

NodeJS, ReactJS, Ajax Framework related technologies for front end development and DataStage, Informatica, SSIS(SQL Server Integration Services) for back end development. Proficient with BIG data technology including Cluster Setup, Pig Latin, Scoop, Scala with Spark. Experience in Site Core Implementation and Customization based on Client requirements Has worked in the capacity Development Lead, Sr Developer, Project Lead, Project Manager over the years. 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. Currently working as Onsite Coordinator/Dev Lead / Senior Developer in Beckman Coulter CERTIFIED SAFE 6.0 and CSM (Certified Scaled Agile 6.0) Worked as SAFE 6.0 Scrum Lead in more than one project Current Visa Status: GC (Green Card)

Role History • Technical PM (Scrum Methodology) 2016-current

• Technical PM (Waterfall Model) 2012-2015

• Architect with Project Management [2005-2011]

• 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

Awards • IBM Star of the Quarter (twice)

Experience

Summary

Recent Experience (Last 2 Years)

Tata Consultancy Services (Jan 2025 to Current)

Scrum Lead Cum Development Lead (MetLife)

MetLife Modernization Project

Support and mentorship on Java and Java Sprint Boot for Junior Developers

Created Spring Boot services for calling Bulk API to consume data

Interface with external Application Like Corro, UIS, Fineos etc for getting Disability Data

Maintain Scrum Schedule and Modify Backlog as necessary

Provide Status report on Progress to Stakeholders Continuum Cloud June 2024 to Oct 2024

Functional Manager Cum Application Lead PL/SQL

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. Last 12 Years --- Working for Zensar Technologies INC

• Technical Development Lead

o American Eagle POS development and Monitoring Oct 2024 – April 2024

Perform enhancement and upgradation of JMC POS system for catering to AEO’s functionality.

Lead Team in Monitoring Processing Logs using Graphana and notifying of any issues.

Perform Performance tuning of Queries executed Against PostGres DB.

Help developers build queries for reports using Power BI

Performing the Role on Deployment lead with a Team of four members

Technology (GCP, Postgress, Spring Boot, Java, Node JS, Angular)

• Technical Scrum Master (Technical PM)

o Vialto Partners Data Platform Implementation Aug 2022 – Sep 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).

Helping team deliver reports using Power BI and providing support to access data using Python.

Providing the technical inputs required to solve complex issues in Power BI and Snowflake.

Technology (Azure Echo System, Snowflake, Python and Ataccama) o Beckman Coulter Site Core Implementation 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 API’s using Swagger and manage access control on API’s. These APIs are consumed by Site Core.

Technical solutioning of Core Site Core components.

Technology (Site Core, AWS, Oracle, Marketo, Eloqua) o Beckman Coulter (Phoenix Next Gen project) 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.

Create API’s using Node Js and managing API access controls.

Created react components using reach functional and framework as ANTD.

Create Pl/Sql table functions, stored procedures and functions to be consumed by Node js API’s.

Creared scripts using node js and deployed as AWS batch Jobs for Data migration from SQL Server to Oracle.

Perform Code Review, fix critical Bugs within SLA, Worked on automating File Upload/Download on AWS S3 Bucket, Fine Tune application and Fix UAT issues on priority

Technology (Oracle, Node JS, React JS, AWS, containers, Atlassian JIRA) o Assurant Specialty Property (SSP Project) 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

Provisioning around fourty eighty nodes for setting up a Hadoop clusters. Configuring Hive for adhoc Queries, Using Scoop to migrate data from Hadoop clusters to SQL server data Marts.

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

• Technical PM (Waterfall Model).

o Assurant Health (Enterprise Warehouse and Data Marts Implementation) Apr 2012- Aug 2016

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

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 migration of ETL jobs from DataStage to Informatica as per client requirement.

End to end implementation with a team of five developers 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

o Architect Cum Senior Developer Cum Project Lead

o Alcatel Lucent (Customer Experience Management Project) Jan-2011 – Feb-2012 – Working for Connectiva Systems

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) o ZAIN Telecom Group Dashboard, Zain Telecom Jan-2009 – Dec-2011 – Working for Connectiva Systems

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 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. o Telstra Data Migration Project (Telstra Australia) Sep 2005 – Dec 2009 for IBM India Pvt Limited

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 --- Working for Data Core Systems o Rail Europe Group (Euronet and Euronet2 Projects) Sep 1996 - Aug 2005

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