Rajkumar Chatterjee

Experienced Data Architect well-versed in defining requirements, planning solutions and implementing structures at the enterprise level. Analytical problem-solver with a detail-oriented and methodical approach. Prepared to offer 13+ years of related experience to a dynamic new position with room for advancement. Skilled in Data Architecture,Data Warehouse Architecture, Enterprise Data Modeling, Portfolio Management and Solution Architecture. Strong consulting skills in Data & Analytics Estate Modernization for customers across industry and geography. Proven experience of leading large teams/Units & meeting organizational growth oriented target

• Rajkumar is an experienced Data Architect driving organizations to leverage their data and enable business to implement Data Driven vision and strategy using modern Data Platforms.
• He is skilled in Data Architecture, Data Warehouse Architecture, Enterprise Data Modeling, Portfolio Management and Solution Architecture.
• Strong consulting skills in Data & Analytics Estate Modernization for customers across industry and geography.
• Additionally he have proven experience of leading large teams/Units & meeting organizational growth oriented targets.
• Technical Experience Summary: => Solution Architecture (EDW, Datamarts and Datalakes): End to end implementation and delivery on Cloud and Traditional architectures.
• Data Architecture: 3NF/De-normalized modelling, Multiple dimensional hierarchies, Dimension change tracking => Data Analysis, Data Models, Data Profiling, Requirement Analysis, Requirement to Data mapping => Also performing the role of Snowflake Architect and SPOC for the LSHCERPS cluster.
• Digital Consulting for Enterprise journey towards next generation Data warehouse/ data lake for both in premise and on Cloud.
• Defining As-Is and End State architecture for Data Architectural Transformations along road map.
• Well versed with advanced technologies like Big data, Cloud Computing and Visualization tools.
• Management Experience Summary : => Leading Multiple Portfolio's for TCS Analytics & Insights- Data Services Unit.
• Handled the role of Operational Head - A&I-DS Kolkata Delivery Centre.
• Expertise in Portfolio Management, Revenue Management, Resource Management, Competency Management => Performing role of Hiring Manager for Horizontal Unit's Eastern Region.
• Successfully steered growth for Analytics & Insights- Data Services Kolkata DC in terms of revenue and headcount growth => Delivery Management and Governance for multiple accounts with total $40 M + revenue Functional: => Life Sciences - Pharma Supply Chain, Pharma Research & Development, CAPA, GxP Compliance => Healthcare - Claims, Member-Membership, Risk Equalization => Retail - Online retail => Banking & Financial Services - Retail Banking, Investment Banking => Telecommunication Tools & Technology: Rajkumar Chatterjee - page 1 ETL Tool : Informatica, Datastage Database : Teradata, Exadata, Redshift, Snowflake Modeling : ER Studio, Erwin Cloud : Amazon Web Services, Microsoft Azure, GCP Big Data: HDFS, Hive, Hbase, Sqoop, Oozie Reporting : Tableau, Qlikview, Power BI Experience Portfolio Manager Tata Consultancy Services Jul 2013 - Present (7 years 9 months +) Data Architect.
• Involved in Data Warehouse Design & Development and Consulting & requirements gathering.
• Working on Data Modelling, PDM implementation and database design.
• Data Analysis, Data Profiling and Data warehouse optimization.
• Data integration of different MDM systems into existing warehouse.
• End to End creation/implementation of Data warehouse and Data Marts.
• Proposing Solutions for Business requirements and RFP's.
• Portfolio Manager.
• Performing Delivery Management for A&I - Data Services Kolkata Delivery Center => Performing role of Hiring Manager for Horizontal Unit's Eastern Region => Delivery Management and Governance for multiple accounts with total 20 M + revenue => Mentoring Growth of Other Eastern Region Data Services Unit.
• Also performing the role of Snowflake Architect and SPOC for Kolkata Delivery Center.
• Solution Architect.
• Solution Architecture for Data Integration and Data transformation engagements.
• Digital Consulting for Enterprise journey towards next generation Data warehouse/ data lake for both in premise and on Cloud.
• Defining As-Is and End State architecture for Data Architectural Transformations along road map => Solution Design for various source Data Integration, Defining data movement and Integration rules.
• Technical Specialist - DWBI HCL Technologies Jan 2012 - Jul 2013 (1 year 7 months) # Administrating Business Warehouse and Testing Warehouse # Doing User Management: create user, delete user, space allocation.
• Doing space management: spool space, perm space and temp spaces.
• Implementing Change request for any warehouse Change.
• Proactive monitoring for warehouse # Regularly maintaining BAR activities which are scheduled through Control-M # Moving data from Development to production and vice versa # Involved in Architectural analysis and suggesting changes in existing EDW to support business requirement.
• Rajkumar Chatterjee - page 2 # Used various tools like TD Administrator, TD manager, TARA GUI and AWS server for administrating EDW # Developed and Built Different Views and Control tables in existing EDW.
• Developing Views and temporary tables in Data mart level using Filter condition to support BO Reporting.
• Involve in weekly meetings to give updates on the status and to discuss the issues.
• Regular Housekeeping jobs like Stats collection, Purging and health checkup activities # Coordinating with ETL team, BO team and mainframe team for different issues Teradata Developer Tech Mahindra Jun 2010 - Oct 2011 (1 year 5 months) # Involved in Design Document Preparation and GAP Analysis for various source Systems.
• Involved in Architectural analysis and suggesting changes in existing EDW to support business requirement.
• Involved in writing scripts for loading data to target data warehouse for BTEQ, FASTLOAD, MULTILOAD.
• Used various tools like BTEQ, FASTLOAD, MULTILOAD as part of the Teradata scripts which are scheduled through the Tivoli Scheduler # Developed One time Load scripts to load data into EDW Granular tables # Developed and Built Different Views and Control tables in existing EDW.
• Developed and maintained stored procedures to support ETL Jobs # Developing Views and temporary tables in Data mart level using Filter condition to support BI MSTR Reporting.
• Involve in weekly meetings to give updates on the status and to discuss the issues.
• Maintain Knowledge Repository with current training materials and other documents System Engineer IBM Sep 2007 - Jun 2010 (2 years 10 months) # A technology oriented professional with more than 2.4 years of experience in Storage Engineering, Data centre & Project Management.
• Presently associated with IBM India Pvt.
• Ltd., Bangalore as Storage Administrator.
• Skilled in Administrating Distributed Backup and recovery and ensuring smooth DRM process.
• Comprehensive experience in the domain of Storage Technologies, Tivoli Storage Manager version 5x & 6x , Disaster Recovery Management and Midrange Storage Administration using IBM AIX, Sun Solaris and Windows servers as platforms.
• Proficient Knowledge in using Lotus Notes, VMware, SQL, SAN, NAS and IBM 3584 (TS3500) Tape Libraries.
• An energetic, self-motivated team member with hands on experience in Storage administration, client- server infrastructure & requirements gathering.