Aditya Chatterjee

ADITYA CHATTERJEE Email:- Tel: - Career Objective To utilize my technical knowledge and analytical ability in an organization that offers professional growth while being resourceful, innovative and flexible. Profile Summary 3.5 Years (Jan, 2016 – Present) Working as a Software Development Analyst in Accenture Solutions Pvt Ltd 3.5 Years of experience in IT industry with strong experience in ETL environment. Competent knowledge of Data Warehousing , Data Integration and Business Intelligence (BI). Hands-on experience in designing the requirements of the application in DataStage Designer and Developing Jobs, Sequencers. Hands-on experience on PIG Scripting, HIVE on IBM Big insights platform. Competent knowledge of writing Complex SQL’s and Shell Scripting Proficient in analyzing and translating business requirements to technical requirements Delivery achievements in terms of following coding standards, peer review of code, writing unit, system test cases and Effort estimation for defect resolution Good understanding of the principles of Data Warehouse using Fact Tables, Dimension Tables, Star Schema modeling and Snowflake Schema modeling. Team player, Motivated, able to grasp things quickly with analytical and problem solving skills. Good Knowledge of working in AGILE Projects. Developed multiple Excel Based Utility Tools to Automate Existing Processes and Introduce Checks in existing Processes. Technical Purview Big Data System: Hadoop 2.0, Spark 2.3 Cloud Computing: Amazon Web Services (EC2,Cloudformation;Lambda,Glue,) Languages: Python, SQL, Shell Scripting , PIG Scripting ,HIVE, Visual Basic for Applications (VBA) Excel Macros. Database: Oracle 11G , DB2 (10.5,11.1) Operating system: Windows , LINUX ,AIX ETL Tool: IBM Datastage (7.5,8.1 ,8.7,11.3) Development Model: Waterfall/Agile Technical Certifications: AWS Certified Solutions Architect Associate Employment History 3.5 years (Jan, 2016 – Present) 1.) Organization:Accenture Solutions Pvt. Ltd Designation :Software Development Analyst Period:Jan 2016 - Till Date Project Work A.) Accenture Solutions Pvt. Ltd Jan 2016 - Till Date 1. Project Name: Risk Data Platform (RDP) (May 2016 – Jan 2018) Client: Citizens Bank U.S Role : Associate Software Development Analyst Team Size Environment Used : : 9 Datastage 8.7/11.3, Oracle 11G, IBM DB2 11.1,Autosys , IBM BigInsights , PIG,HIVE Risk Data Platform (RDP ) is one of the most critical Part of Citizens Bank’s Financial Data Warehouse . RDP framework comprises of 84 Source System containing data related to Commercial loans, Student loans, Mortgage, Safe Deposit Box i.e. Data associated with a certain element of Risk. Based on the business requirement, these source systems have been integrated in to the Data Warehouse for further risk modeling data analytics and regulatory reporting. These source systems have been integrated to Data warehouse using Data stage Parallel Jobs and sequence jobs. Also Unix Shell scripts have been designed to trigger these sequence Jobs and populate the Audit and Control tables. Autosys is being used as the scheduling tool for RDP applications. Responsibilities Participate in discussions with client on mapping specification transition and ETL issues Analyzing and translating business requirements to technical requirements Involved in code and document review Collaborated with analysts to decide the ETL/ELT methods and overall data flow architecture. Analysis and bug fixes of issues raised during System Integration (SIT) and UAT cycles Interfacing with Operations and Business for development and deployment of new projects Optimizing /modifying queries to get desired business data and increase the performance. Involved in code and document review Creation of Datastage Jobs, Complex SQL’s , PIG Scrips and Hive Queries B.) Accenture Solutions Pvt. Ltd Jan 2016 - Till Date 1. Project Name: Autodesk Data Platform (Jan 2018 – Till Date) Client: Autodesk Role : Software Development Analyst /Big Data Developer Team Size Environment Used : : 15 Amazon Web Services (AWS), Spark (2.3), Python (Pyspark), AWS Lambda, Glue, EC2, EMR, S3, Hadoop 2.0,Hive,Pig. ADP is the Data Platform for Autodesk. The ADP team could be broadly classified into two more teams. With multifaceted responsibilities including making the data storage GDPR compliant to facilitating services for the Data Engineering and Data Science teams of Autodesk the ADP can indeed be considered as the lifeline of the Autodesk team. Data coming in from a variety of sources and very high in volume would have to be dealt with in Big Data environment to ensure on time data delivery to downstream. Responsibilities Participate in discussions with client on data ingestion requirements Present AWS and Big Data based solutions to the client to carry on data ingestion, platform provisioning activities etc. Drive the delivery and participate in regular standup calls with the client as a part of the Agile Model of Development along with timely completion of deliverables in each sprint. Provide solution architecture to the problem statement in terms of AWS Services and Big Data Technologies. Provide Production Support for the deliverables. Academic Credentials Bachelor of Engineering from KIIT UNIVERSITY, Bhubaneswar scoring 84% Marks in 2015. ISC (XII) from Calcutta Boys’ School scoring 79.5% Marks in 2011. ICSE (X) from Calcutta Boys’ School scoring 82.83% Marks in 2009. Personal Dossier Father’s Name : Gouranga Chatterjee Date of Birth : 17th November, 1992 Passport No : H- Address :120 Muktaram Babu Street Kolkata 700007 (Permanent Address) Declaration I declare that above-mentioned information particulars are true to the best of my knowledge and belief. I fully understand that any information if found incorrect may lead to cancellation of my candidature. Place : KOLKATA Aditya Chatterjee Date :