Summary
Overview
Work History
Education
Skills
Work Availability
Quote
Timeline
Generic
JYOTI CHOWDHURY

JYOTI CHOWDHURY

SOLUTION ARCHITECT | DATA MANAGER
Dallas,TX

Summary

Jyoti Prakash Chowdhury Informatica Consultant/Sr Data Analyst/BI Project Manager A seasoned professional with 17 years 5 months of IT experience in Banking , Insurance ,Mortgage & Auto Loans domain .Accomplished leader in implementation of small to large scale projects with exposure to the entire Business Intelligence and Data Warehousing life cycle.

Overview

19
19
years of professional experience

Work History

Sr Data Analyst |Data Integration Specialist

First Republic Bank
03.2018 - Current
  • The project aims to enhance and strengthen FRB’s risk and regulatory reporting framework by consolidating and transforming data into one central data repository and using that as the standard place for generating reports for various metrics
  • Duties:
  • Work on enhancing and automating the reconciliation and aggregation of data from various vendors and applications into centralized datawarehouse
  • SPOC for all production support , business reporting and data reconciliation & data re-processing
  • Automation of alert mechanism for unprocessed/residual files and stale data tables
  • Automation of support metrics and trends , critical load analytics via Splunk
  • Automation , Migration and Customization of various data virtualization layers through Denodo
  • Conversion and Support of legacy SSIS , Informatica jobs migration into Python and Snowflake framework
  • Worked on building CI-CD pipeline for automation of entire development and deployment cycles using Jenkins and adoption of devops framework

Sr Data Analyst|Informatica Consultant

JPMC
10.2017 - 03.2018
  • The project deals with regulatory reporting and risk modelling platforms ,primarily in the areas of CCAR , Risk & Fraud detection
  • Duties:
  • Gathering the requirements for the data load and reconciliation from the customer
  • Preparation on data mapping , load specs document and transformation documents
  • Providing technical governance ,work estimation and schedule planning to DM
  • Analysis & reconciliation of data attributes across models ,sources ,ODS & warehouses
  • Data reconciliation and integration into Oracle/MariaDB database
  • Loading remediation data into Conformed and Semantic zone for data quality improvement .

Informatica Consultant/Sr Data Analyst

Santander Consumer USA
Bangalore, India
11.2015 - 09.2017
  • The project involves development and enhancement of the bank’s Enterprise Data Governance warehouse to address the needs of various regulatory programs (CCAR, BCBS FAS 239 etc.) as well as define and create the target state data platform that would serve the growing Business needs for better quality data, coverage and improved analytics and reporting delivery
  • Duties:
  • Data migration from various internal sources into stage , transformation of data for operational reporting and later feed to Analytical Data marts for reporting
  • Loading data into the three data layers - Delta ,Ops and Reporting
  • Adding validation checks at mapping level based on Reporting and Ops requirements
  • Generation of surrogate keys,derived columns & additional reporting columns in Informatica for operational reporting
  • Feeding summarized and aggregated transformations based on regulatory business logic and feeding to relevant data marts for analytical reporting
  • Implement data profiling and data quality rules for quality adherence
  • Manage the team work efforts , schedule , effort utilization and estimation
  • Work on the governance metrics for the client - utilization metrics , quality index , CSS .

BI Consultant - Data Analyst

Mphasis CIO
Bangalore, India
12.2014 - 11.2015
  • The Project involved competency building for some of the Platinum Customers and migration into the next set of cloud and analytics tools
  • The project has the following major stages and processes
  • Data Aggregation from various Corporate Hubs such as Corporate Data Center , Live
  • Events & Databases
  • Duties:
  • As the solution designer and Tech Lead, I am handling the following responsibility
  • Worked with business owners and technical teams to identify and document detailed requirements, process flows, and data sources reviewed and manage all changes to the requirements through a formally defined scope change process
  • Bridged the gap between business requirements and technology implementation through working with technical team and industry experts.

BI Consultant & Offshore Lead

HP CIO
Bangalore, India
11.2009 - 11.2014
OblicoreOblicoreOblicore
  • CRDW & OPSDW extracts data from various operational data sources like HPSM, OVSC, OVR, Telephony and several other tools on a daily basis through extract-transform-load (ETL) jobs into central data warehouse and the delivery of results is given to the customer in the forms of Reports , Dashboard, Scorecard
  • Duties:
  • Project Lead and SPOC for the Build & Deploy of ETL and BO
  • Participate in design & code review sessions , project planning sessions
  • Used Informatica Power Center for ETL into heterogeneous targets
  • Migrate old legacy ETL mappings from Pentaho and Data Stage to Informatica
  • Design & performance tuning of Informatica workflows and mappings at source, target and session level for optimal performance in a large scale Unix/RDBMS environment
  • Prepare deployment packages & migration of mappings, sessions, and workflows from Development to testing and then to Production environments
  • Create checklist & scripts for system wellness, involve in proactive performance management
  • Involved in L3/L4 administrative support of Informatica Powercenter & Business Objects systems and install/configuration & deployment of cluster high availability environments

BI Consultant & Offshore Lead

GM Motors
07.2006 - 10.2009

Developer

Mitsubishi Denki Information Systems
Hyderabad, India
01.2004 - 06.2006
  • The Enterprise Risk Management tool was developed in Microsoft .NET platform and catered to extraction of data from various business systems via SSIS and feeding that into SQL database .The tool would provide risk assessment based on the Enterprise COBIT framework using various reports generated by SSRS and Crystal Reports
  • Duties:
  • Analyze the requirements provided by the client and based on the standard COBIT risk management reporting framework , devise plans as to how to develop those reports
  • As the report developer, I was responsible to develop various kinds of queries to formulate tabular and extract reports in SQL and SSRS
  • Develop complex risk management scorecards and dashboard in Crystal Reports
  • Develop departmental and enterprise level drill down and drill up reports

SME

Bangalore & Hyderabad
, India
DenkidevopsDenododatawarehouseQlikviewModellerTalendAutosysCrontab
  • The project involved extraction of data from various client sources , manipulation of data inside the patented Oblicore correlational and aggregation system and loInfoviewto reporting DWH ; Reporting was done in Business Objects Infoview and Crystal Reports
  • Duties:
  • As, for Oblicore, I was responsible for end to end onboarding of clients onto Oblicore and was involved in requirement analysis, deployment and customization of code, engineering post production support, build/upgrade and other support activities
  • Was involved in analysis of business requirements with the BA & Process owners , creating technical documents for ETL and Reporting requirements
  • Customization of reports in the BO XI R2 platform and Crystal reports and creation of dashboard /scorecards in Oblicore platform

Education

MBA - International Business

IIFT
NEW DELHI,INDIA
03.2011

Skills

  • Over 14 years of experience in Data Analysis , Data Integration & Reporting
  • Specialized in data extractions from wide range of data sources like Oracle , SQL ,Teradata and SAP BW and transforming and loading into DWH using ETL tools like Informatica Powercenter, CA Oblicore, Pentaho ,SSIS and SAP BODS, Data Stage
  • Strong in databases like Oracle , PL-SQL & SQL, MySQL ,Teradata
  • Exposure to Unix, Shell scripting and batch scheduling tools like Crontab , Autosys and Control –M
  • Experienced in managing technical staff, and coordinating development activities with cross functional teams across multi locations
  • Worked extensively with Solution team for the preparation of proposal, conducting technical feasibility study, creation of SOW Have worked closely with the delivery manager for project planning and work estimation
  • Certified in ITIL V2 ,Oblicore , MCP in SQL 2005
  • Trained and Exposure in the latest technologies – Cloud , Big data & Analytics, Hadoop, Sparx, R programming, Python Programming
  • Lead and managed projects in the range of 1mn – 10mn $
  • Areas of Expertise
  • Data Migration Tools: Informatica , Talend , Oblicore ,Data Stage
  • Data Modelling Tools: MS Visio 2000,ER Studio 70, Erwin Data Modeller
  • Design / Tools: ER Studio, Erwin, MS Visio
  • Reporting : Qlikview , Business Objects XI, Crystal Reports
  • Databases: MS SQL Server , ORACLE 9i – 10g,Teradata ,MySQL
  • Big Data & Cloud : Hadoop , Sparx, Pig ,AWS , Hive ,Python , R

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Timeline

Sr Data Analyst |Data Integration Specialist

First Republic Bank
03.2018 - Current

Sr Data Analyst|Informatica Consultant

JPMC
10.2017 - 03.2018

Informatica Consultant/Sr Data Analyst

Santander Consumer USA
11.2015 - 09.2017

BI Consultant - Data Analyst

Mphasis CIO
12.2014 - 11.2015

BI Consultant & Offshore Lead

HP CIO
11.2009 - 11.2014

BI Consultant & Offshore Lead

GM Motors
07.2006 - 10.2009

Developer

Mitsubishi Denki Information Systems
01.2004 - 06.2006

SME

Bangalore & Hyderabad

MBA - International Business

IIFT

Similar Profiles

CREATE PROFILE
JYOTI CHOWDHURYSOLUTION ARCHITECT | DATA MANAGER