Bishal Ghosh

About Bishal Ghosh

The more we do, the more we can do.”~ William HazlittThe above statement rings true for Bishal, a technical expert with the creativity and business savvy to utilize technology solutions to create cost-effective, time-efficient and highly accurate business applications and functions blending ETL and business intelligence world.• 7+ Years of IT experience in Banking & Financial domain with a strong background in Credit Card and Retail Systems.• Extensively worked on designing and implementing Enterprise Data Warehouse for Large financial clients using ETL & ELT tools like Informatica & Wherescape Red.• Vast working experience in data integration across databases like Greenplum, PostgreSQL, Oracle.• Independently perform complex troubleshooting, root-cause analysis and provided development solutions to the team.• Proficient in performance tuning of ETL design and code in Large DWH.• Well versed with Software Development Cycle (SDLC) and Agile Methodology.• Team Player with a strong work attitude, Proactive, and Good Communication skills.

Experience

1. Tech Lead Etl Consultant

   MUFG

   Dec 2015 — Present · Cincinnati, OH, US

   Some of the highlights of this role include:• Worked with stakeholders for requirements gathering, analysis, design, development, testing for N-to-N solutions and successfully implemented the project. Guided and supervised six off-shore resources.• Evaluate and design Conceptual /Logical and Physical Data Models; define logical views and physical data Security structures.• Arranged daily & weekly meetings to monitor the resources and updated the client about work progresses.• Based on business requirements wrote the Tech Specs for each process, designed ETL process as a model for each layers and provided the solutions in a mission critical situation wherever the resources stuck on. • Wrote all DDL scripts to create Tables, Views, Transaction Tables, Triggers, and Store Procedures for base tables and CDC processes in all layers.• Migrated codes from Dev to Test to Pre-Prod. Created effective Unit, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure successful execution of accurate data loading.• Extensively worked on CDC to capture the data changes into sources and for delta load. Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.• Debugged the invalid mappings and tasted Mappings, Sessions, and Workflows to figure out the Bottlenecks and tuned them for better performance. • Collaborating with team to implement projects in MPP databases such as PostgreSQL (Greenplum) and ELT tools like Wherescape RED.

Education

• West Bengal University of Technology

  Bachelor of Technology (B.Tech.)

  2008 — 2012

Skills

• Data Warehousing
• Postgresql
• Hp Quality Center
• Etl
• Hpsm
• Greenplum
• Sql
• Linux
• Extract, Transform, Load (Etl)
• Wherescape Red
• Etl Tools
• Oracle
• Requirements Analysis
• Databases
• C++
• C
• Business Intelligence
• Informatica
• Java
• Unix
• Agile Methodologies