CV Debayan Mitra
- 1. DEBAYAN MITRA | 902 905 8000 | mdebayan89@yahoo.in DEBAYAN MITRA Mumbai,India | 902 905 8000 | mdebayan89@yahoo.in Education B.TECH | 2007-2011 | W.B.U.T. 揃 Major: ELECTRONICS and TELECOMMUNICATOIN ( CGPA 7.35) HIGHER SECONDARY | 2006-2007 | WBCHSE 揃 Major: Science from Jodhpur ParkBoys High School with 80.8% marks Skills & Abilities ROLE 揃 Software Developer working as Data Modeler and Developer in DWBI domain 揃 Total work experience of 3.4 years. Worked entirely in Informatica PowerCenter and PLSQL 揃 As data modeler, responsibilities include analyze and understand sourcedata and designdata marts to transform and store the data and extract information for reporting purpose as required by end user 揃 Also worked as ETL developer. Role was to create workflows in Informatica PowerCenter to extract data, apply business logic and load data marts, cubes, generate flat files etc. to be consumed by end applications / users. 揃 Excellent knowledge in DWBI concepts 揃 Experienced working in all phases of SDLC ( requirement gathering , analysis, development and testing) SKILLSET 揃 Primary: InformaticaPowerCenter 9.5 , PLSQL 揃 Scripting: UNIX, PERL 揃 Database: SQL SERVER 2008 R2, ORACLE 11g 揃 Scheduling: Informatica PowerCenter (Workflow Manager),IBM Tivoli Maestro INDUSTRY DOMAINS 揃 Presently working in Banking and Financial Services domain for AXIS Bank as a Data Modeler 揃 Previously worked in projects for US based Insurance firm MetLife. COMMUNICATION AND CLIENT DEALING 揃 Excellent communication skills having dealt with a wide variety of professionals as part of a unified team of experts from diverse technologies 揃 Currently deployed at client location (Axis Bank, Mumbai) and involved in direct client dealing.Proven ability to drive the project from providing technicalsolutions to managing time and resources in the project. LEADERSHIP AND RECOGNITIONS 揃 Groomed resources working in my project in Informatica PowerCenter 9.5 and UNIX 揃 Currently working as standalone resource in a data mart designing project and driving the project alone for TCS 揃 Won POBfor outstanding contribution in project RPI 揃 Won client appreciation from Axis Bank. Requested TCS to retain me in the ongoing projects of AXIS Bank.
- 2. DEBAYAN MITRA | 902 905 8000 | mdebayan89@yahoo.in PROJECTS CORPORATE BANKING DATA MART | TCS AXIS BANK | AUG 2015 揃 Corporate Banking data in AXIS Bank resides in a standalone SQL Server 2008 揃 Project scope includes to design a data mart that will cater to all the reporting needs which are being handled by the SQL server database and at the same time provide greater flexibility for analytical purposes like incorporating all the corporate banking instruments in the data mart like transaction banking, liabilities etc. RBO DATA MART | TCS AXIS BANK | JAN 2015 JUL 2015 揃 RBO Data mart is built to cater to the risk analysis reports and performance assessment parameters of all branches of AXIS Bank 揃 Analyzed source data,understood the requirements and developed dimensions and facts to cater to the reporting needs 揃 Created a data mart which is platform independent and fully parameterized toprovide maximum flexibility BROKER DEALER- SAGE | IGATE - METLIFE | 2014 揃 SAGE was about merging four source channels into one single channelacting as a source system for MetLife 揃 Analyzed source data and existing target database and designed newdatabase tables to accommodate all the existing data after they have been merged into a single channel. 揃 Provided design solutions to implement logic from different channels 揃 Impact analysis for downstream applications after merging of all data BROKER DEALER- RPI | IGATE - METLIFE | 2013-2014 揃 RPI deals with the records of the Representatives or Brokers of MetLife. 揃 On ETL front scope involved hardening of codes which is converting existing SQL/UNIX/Perlscripts into Informatica codes 揃 Analyzed the existing UNIX/PERL/SQL scripts and designed approach and solutions for Informatica code to handle the existing logic 揃 Created mappings and conversion code in Informatica Power Center and used UNIX scripts to execute the workflows CSSG VARICENT IMPLEMENTATION | IGATE - METLIFE | 2013-2014 揃 CSSG is an Incentive process aimed at providing web based central repository view data. 揃 On the ETL front scope included extraction of data,apply business logics specific for each feeds and load the data into the ODS wherefrom IBM Varicent tool will pullthe data for calculation of incentives. Also created UNIX scripts to execute workflows and used Maestro scheduler to trigger these UNIX scripts automatically CRDM | IGATE METLIFE | 2012-2013 揃 Corporate Relationship Data Mart (or CRDM) deals with the batch insurance policy data of MetLife. Source data comes in flat files which are first loaded into staging tables then to the persistent staging tables after applying all the business logics. Then the finalmart tables are loaded from these persistent staging tables 揃 Developed Informatica mappings and workflows to extract , transform and load the data 揃 Unit testing and data validation to ensure that code meets the business requirements 揃 Prepared documents including LLDs and UTCs Hobbies and Interests: 揃 Singer and music enthusiast and a foodie by heart! 揃 Cooking and photography are my favorites. Also like to play table tennis and watch movies very much.