Mayukh Dhar
Summary
- Having over 10 years of expertise in designing business documents and development for the banking and telecom domains.
- Strong working knowledge of key concepts in PL/SQL, such as procedures, functions, triggers, cursors, joins, exception handling, bulk SQL, dbms_prof, dbms_hprof, etc.
- Highly analytical business analyst with a background in identifying business needs and determining solutions to business problems. Strong skills in data analysis, project management, and strategic planning, coupled with the ability to communicate effectively with stakeholders at all levels.
- Decent knowledge of Azure cloud, Power BI, Word, and Excel.
Overview
10
10
years of professional experience
Work History
Business Analyst
Society Generale
05.2022 - Current
- Currently, I am working on a migration project, and the migration is happening from Mainframe technology to Big Data (Spark, Scala, and Cloud).
- So, to understand the existing legacy requirements, I decipher the existing COBOL code, and prepare the technical design document or mapping for the developers to code.
- Collaborate with the Business Solutions team to gather new requirements, and groom them for technical implementation.
- And since I am handling a team of four people, I have been reviewing the technical design documents of my peers to drive the accuracy of the project.
- Assigning JIRAs and validating the developers' changes by performing regression testing and load testing.
Senior Consultant/Business Analyst
Oracle Financial Services
09.2021 - 02.2022
- Project Overview: I worked for the Citi Bank client to support the product team, from where I gathered requirements and prepared the LLDS.
- Worked in Oracle Forms (a tool used to build screens) both as a developer and business analyst.
- Also involved in the client (Business) requirement CA/CFT calls, drafting the LLDs, and assigning the user stories to peers for development.
- Code review and sign-off before deployment.
- Worked closely with stakeholders to identify business issues.
- Performed a cost and benefit analysis on proposed solutions to determine effectiveness by suggesting data modeling.
Senior Software Engineer/Business Analyst
Virtusa Pvt Ltd
04.2019 - 08.2021
- Project Overview: The client was British Telecom, a migration project from PLSQL (2-tier architecture) to Java microservices (3-tier architecture) and post-migration support for the same E2E functionality on another existing component.
- As a DB Lead, I was handling a team of four people. Since it was a migration project from PL/SQL to Java (microservices), I have hands-on knowledge about microservices architecture.
- I have developed component designs for major stories.
- I have built the entire database in Oracle using complex procedures, functions, triggers, DBMS jobs, materialized views, logs, and collections as per business requirements.
- As it was a migration project, I understand the ongoing functionality and the best approach to accommodate it in the new application.
- To understand the interfacing components of the existing system, understand the efforts and approach required to implement the same.
- To support the lifecycle of the entire E2E functionality and provide the code changes and support in case of any issues in E2E testing or production testing.
- Also, to interact with the business to understand the desired requirements and how they could be accommodated, and accordingly present them to the team.
Software Engineer
HCL Technologies
02.2015 - 02.2019
- I joined as a fresher and was trained in Unix, SQL, and PL/SQL.
- I have worked for the customer, Deutsche Bank, as a PL/SQL and Unix resource.
- Learned about implementing, configuring, and documenting the business requirements and challenges.
- I have written cron jobs in shell scripts and indexes for faster fetching.
- Adequate domain knowledge of the banking system and agile methodology.
- Firsthand Experience on Data Warehousing Concept Joined.
Education
BTECH - Electrical & Electronics Engineering
United College of Engineering & Research
Prayagraj05-2013
Skills
- SQL
- PL/SQL
- LINUX/UNIX/C
- AZURE CLOUD
- COBOL
- SPARK/SCALA
- MS Word/Excel
- ORACLE 12c
- SQL Management Studio
- SQL Developer
- TOAD
- JIRA
- GIT
- Power BI
Timeline
Business Analyst
Society Generale
05.2022 - Current
Senior Consultant/Business Analyst
Oracle Financial Services
09.2021 - 02.2022
Senior Software Engineer/Business Analyst
Virtusa Pvt Ltd
04.2019 - 08.2021
Software Engineer
HCL Technologies
02.2015 - 02.2019
BTECH - Electrical & Electronics Engineering
United College of Engineering & Research
Similar Profiles
Aravind ChagantipatiAravind Chagantipati
Lead SERVICE ANALYST - RESILIENCY MANAGER at Societe Generale Global Solutions Center Pvt Ltd, Bangalore | Bangalore, INDIALead SERVICE ANALYST - RESILIENCY MANAGER at Societe Generale Global Solutions Center Pvt Ltd, Bangalore | Bangalore, INDIA
Shadab HyderShadab Hyder
Delivery Manager at Societe Generale Global Solution CenterDelivery Manager at Societe Generale Global Solution Center
Alice IrimiaAlice Irimia
Executive Assistant at Societe Generale Global Solution CentreExecutive Assistant at Societe Generale Global Solution Centre
Corinne ClayCorinne Clay
Business Analyst at Bristol City CouncilBusiness Analyst at Bristol City Council
PRASANTH K SINGUPRASANTH K SINGU
Business Analyst at SailPointBusiness Analyst at SailPoint