Ankit Chachra

ANKIT CHACHRA Hadoop Certified | Microsoft BI Certified | Tableau Certified Seeking a challenging position in the domain of Big Data / Hadoop / Business Intelligence / Data Analytics / AI / ML Profile Summary -+91 - Delhi/NCR linkedin.com/in/ankitchachra  Currently designated as Big Data Engineer (II) at Fractal Analytics - enabling development and deployment of highly scalable data engineering and consulting solutions across many Fortune 500 corporations  Seasoned solutions architect with rich experience in leading and working across multiple platforms and domains like Bigdata at scale, AI, ML, Cloud, Management Consulting, Business Consulting, Data Analytics, BFSI, CPG etc.  Keen on understanding the business flow before implementing cutting edge DWH/BI techniques to solve data challenges  Previously designated as Big Data Developer L2 at Adobe Inc. and Associate L2 – Technology at Sapient  Microsoft Power BI Certified – Cleared the Microsoft 70-778 Exam for Analysing and Visualizing Data with Power BI  Tableau certified – Cleared the Tableau Developer and Tableau Data Scientist courses hosted by Tableau Software  Hadoop Certified – completed a 6-month extensive course from one of Delhi/NCR’s leading training institutes in 2018  A competent professional with qualitative experience in managing and designing end-to-end Data and ETL Pipelines using Spark, Python, Hive, PySpark, SnapLogic - having worked with a variety of data sources like Salesforce, SQL Server, MySQL, SharePoint, HDFS files, CSVs and TSVs – whilst also performing Hadoop cluster management on a regular basis  Hands on experience in writing neat and optimized ETL scripts and workflows with Spark, Hive and Oozie respectively and expertise in developing and orchestrating UNIX shell scripts to deliver overall functionality  Capable of creating sharp reports and dashboards using interactive data visualization tools like Power BI and Tableau.  Initially designated as a Senior Software Engineer at HCL Technologies Ltd. and worked for Citigroup Inc. - a leading investment banking and financial services corporation –and collected useful knowledge of the BFSI domain Tools and Platforms  Big Data  PySpark  HDFS  Oozie  MS SQL Server  Hadoop  Python  Sqoop  Hue  Agile / Jira  Hive  Power BI  Flume  UNIX  Spark  MapReduce  Tableau  SSAS  Zookeeper  Java – Core Organisational Experience Oct 2019 – P resent Big Data Engineer (II) Fractal Analytics        Solving real-world Big Data and ETL challenges by building fast, optimized and scalable data lakes, dashboards and solutions for some of the top brands in the world Leading data engineering for multiple Analytics and Consulting projects for Visa client in their CEMEA region by delivering best-in-class engineering solutions based on Big Data and cloud Spearheading creation and optimization of data lakes by designing ETL workflows in PySpark and Hive QL Successfully delivered a number of highly scalable and optimized solutions on Visa’s Cross Border Business Development Strategies to different Issuers/ Merchants in the CEMEA region Redefining storytelling in Data Consulting and Analytics – by being actively involved with the business stakeholders and then building data pipelines and dashboards that help track customer journey for Visa across different functions Using highly optimized transformation and storage techniques in Hadoop and Spark frameworks for working on multiple transactional data sources for Visa, each of which have row-count of 80+ billion and storage size of 10 TB Spot Award – May 2019 for development and productionization of Visa’s Cross Border solution Apr 2019 – Oc t 2019 Big Data (Hadoop and BI) Developer L2 Adobe        Functioned as part of the Performance Management Group (PMG) at Adobe Systems India on products like ACS Insights (Adobe Customer Solutions) and Adobe Experience Manager (AEM) Enabled Adobe’s Worldwide Sales & Field Operations unit to derive key insights for upcoming opportunities Worked actively on both, Data Engineering as well as Data Analysis domains by leveraging tools like SnapLogic, Hive, Spark and SSAS Tabular Developed comprehensive data pipelines, cubes and models to enable data-informed decision-making across the organization, leveraging best-in-class Big Data technologies Designed ETL workflows in Hive and Spark post consuming data from a different number of source (Salesforce, PSA, Amazon S3) and handled hundreds of datasets each having row-count over 40M and storage size over 20GB Worked on a number of different platforms like Sqoop and SnapLogic for data extraction and data download, Java for data cleansing, Hive and for data transformation, modelling and joining, Oozie for designing and scheduling workflows and UNIX shell scripts for automating different stages of data gathering and ETL Designed and delivered final solutions in forms of cubes, reports and dashboards in Power BI and Tableau Apr 2018 – Apr 2019 Associate L2 – Technology Publicis Sapient             Worked under the Business Intelligence domain which handles data and performs business analysis for Sapient’ s parent company - Publicis Groupe - one of the world’s largest marketing and communications companies Functioned as a part of the Bigdata and Hadoop Development Team which works on a Cloudera Hadoop production cluster with tools like Hive, Sqoop, Oozie, Hue, Tableau, and Power BI etc. Worked extensively on Apache® Hive which included loading data into Hive, designing managed and external tables to optimize performance, developing Hive queries for processing data, implementing query optimization techniques, creating queries for incremental and full load to hive tables, solving performance issues with understanding of joins, grouping and aggregations and how Hive translates the queries to MapReduce jobs Worked on Apache® Sqoop which included writing scripts and jobs to import data from HDFS to RDBMS and export data from RDBMS to HDFS using parameters to load historical data as well as incremental data to HDFS Successfully delivered over 80 dashboards and reports with Power BI and Tableau – while also performing data transformation at visualization level and writing DAX queries to achieve best results Practice of developing UDFs in Java as and when necessary to use in Hive and Pig queries Adept at reading and reviewing Hadoop log files and fixing and troubleshooting the issues found to make sure the jobs run continuously without effecting the application Accustomed to concepts like data ingestion, pipeline design, data modelling and data mining, machine learning, advanced data processing, data cleansing and analysis of transactional data Developed MapReduce jobs with focus on optimization on no. of mappers, reducers, combiners, partitioners etc. Possess a strong analytical curve and able to deliver critical business insights based on data by creating dashboards and reports with interactive views, trends and drill downs Top Performer (Enterprise Applications BI Unit) – Q4 2018 Top Performer (Enterprise Applications BI Unit) – Q1 2019 Aug 2014 – July 2017 HCL Technologies Ltd. Senior Software Engineer        Worked under the Banking, Financial services and Institutions (BFSI) domain for Citi Group Inc. (Client) in its leading market-sensitive division known as Citi Markets and Securities Services Technology (MSST) Operated as a part of Citi's Global JUAT Investor Services team (since July 2015) as a Subject Matter Expert for ITRS Monitoring Tool. Other roles included development, testing and support for UNIX and Windows based applications Practiced In-depth Incident management procedures i.e. hosting technical and operational bridges, handling major incidents with potential service or business impact with regular reporting to IS leads and Managers Practiced Problem Management procedures by tracking the underlying problems , finding RCA’s , implementing short term resolutions , finding long term resolutions, setting up monitoring’s/alert and publishing Post Mortem reports HCL LiveWire Award – Quarter October - December 2014 HCL SPOT Award – September 2015 HCL LiveWire Award – Quarter October-December 2015 Trainings and Courses Hadoop and Bigdata Oct 2017 – Mar 2018 : Croma Campus Pvt. Ltd. Certifications and Assessment Examinations       Microsoft Power BI Certified and Tableau Certified Google Cloud Certified Professional Cloud Architect (Certified at Qwiklabs) 2015 - ITRS University: Foundation in Geneos v3 from the ITRS Group Ltd, London, UK. 2014 - .NET framework certification (including ASP.NET, ADO.NET, and advanced .NET) from Ducat Education. eLitmus Percentile (2014): Problem Solving – 95, Quantitative Ability – 91. AMCAT Percentile (2014): Computer Science – 100, Logical– 90, Computer Programming – 88, English – 100. Education- B. Tech (Computer Science and Engineering) from Maharishi Dayanand University, Haryana, with 71% Senior Secondary (12th) from Faith Academy Senior Secondary School (CBSE), Delhi, with 81% Higher Secondary (10th) from Faith Academy Senior Secondary School (CBSE), Delhi, with 88% Achievements in co-curricular activities and personal interests     Obtained State Rank: 9 and International rank: 121 in the International Mathematics Olympiad 2008 Represented the School and College Football Teams at various Zonal Tournaments Administered many Technical Fests at PDMCE, Maharishi Dayanand University from 2011 to 2014 Avid interest in playing and following football (I am the admin member of the Chelsea FC India Supporters Club – Delhi). Other interests are listening to Rock and R&B Music and following Formula1 and tennis