Sagar Bhadra

About Sagar Bhadra

10 plus years of experience in Application design, analysis, development & maintenance including one year as a Module lead in BI DW Project under Client ICICI Lombard Re-Insurance (TCS).• Have worked primarily in Financial Services and Insurance Domain.• Technological forte is Teradata-BI, Oracle PL/SQL, ETL Data Warehouse, UNIX shell scripting (awk, sed, grep), Excel VBA scripting.• Expertise in ETL BI, Oracle DML, DDL, Procedures, Functions, Triggers, Index, Sequence, Packages, Views, sql loader utility etc.• Prepared Multi-load/Fast-load scripts to load data from load ready files. Extensively used BTEQ utility to process data in WH. • Experience in Teradata BI, Unix Shell Scripting and Ab-initio BRE.• Expertise in Automation Process and have developed many tools designing the front end using Excel vba scripts which includes run time DB connection (Teradata) and running the shell scripts and generates HTML reports and further mail to the intended recipients.• Basic knowledge of working on Data Visualization Tool Qlikview as have done the trainings and completed hands-on assignments on same as part of Accenture’s Multi Skill Program. • Exposure to Big Data applications like HIVE, Apache Spark, Kafka and HDFS. Experienced in spark streaming to process JSON/unstructured files in production environment using kafka, implementing RDD architectures and transformations. Hands on in working with partitions and bucketing in hive. • Excellent Communication, problem solving, documentation skills, proven analytical skills that facilitates a high-level collaboration among co-workers in a team-oriented and rapidly changing business environment.• A Quick learner, Self-starter, highly motivated individual possessing strong analytical power, Problem-solving abilities.

Experience

1. Senior Manager

   Morgan Stanley

   Feb 2023 — Present · Mumbai, IN

   Interacting with Users and Performed requirement analysis, developed software and deployed in production.Developed and supported Basel Capital Calculation,EAD, PE, LEQ, Stats calculation processing via batch and using adjustment.Worked on inhouse Automation Orchestration tool for running Adjustment/Proucts Calculation and Rollup Process.Worked on Aggregation of exposures from different Products across Party Level/LE Level/Country/Industry level Rollups.Worked on PE-Aggregation process to calculate various Time less and Time based stats based on simulation data received from upstream and providing reports to Finance for review.Worked on Curator inhouse tool to curate data into MEMSQL for PowerBI Dashboard building.Worked on CI/CD Jenkins Pipelines migration process.Created a generic Utility to have Fillforward process which can help reduce overhead of ops while dealing with upstream.Worked on converting existing framework into Spark SQL.Worked on creating a framework for downstream process in python. Analyzed and converted Legacy Informatica code to python.Analyzed the query performance and designed the loading process schedules.Shell Scripting to load tables and call Autosys Jobs.ETL-Designed Extraction, transformation and loading (solution using Python, SQL)

Education

• S.k.somaiya Vinay Mandir

  High School, Computer Science

  2006 — 2008

• University of Mumbai

  Engineer's Degree, Computer Engineering

  2008 — 2012

Skills

• Xml
• Microsoft Office
• Html
• Mysql
• Windows
• Java
• Pl/Sql
• C
• C++
• Teradata Data Warehouse
• Sql
• Qlikview
• Javascript
• Oracle
• Plsql
• Css