Ashok Roy Email & Phone Number

• Having more then 17 years of experience in handling Data Warehousing and Business Intelligence projects in Banking & Finance (Credit Risk) and Pharmaceutical (Labeling and Artwork) donain.• Evaluating technology stack for building Analytics solutions finding right strategies, tools for building end to end analytics solutions.• Design and Developed real time streaming pipelines for sourcing data from files, relational databases,data lakes, for analytics.• Good knowledge on Hadoop Architecture and its ecosystem.• Having extensive knowledge on Big Data technology experience in Storage, writing queries, processing and analysis of data.• Strong understanding on NoSQL database like Hbase, MongoDB.• Experience in AWS S3, EC2, Athena, Glue, RedShift, RDS, EMR cluster.• Experience on working with Apache Sqoop and Flume for Ingesting data into Bigdata from different source system.• Experience in creating and loading data into Hive tables with appropriate static and dynamic partitions, intended for efficiency.• Worked on various Hadoop file formats like Parquet, ORC & AVRO file.• Experience in Data Warehousing applications, responsible for (ETL) of data from multiple sources into Data Warehouse• Experience in optimizing Hive SQL queries and Spark Jobs.• Implemented various frameworks like Data Quality Analysis, Data Governance, Data Trending, Data Validation and Data Profiling with the help of technologies like Bigadata,Data Stage, Spark, Python.• Skilled in Visualization and creating Dashboards using Tableau, Power BI, Qlik Sense and Python.• Experience in Credit Risk & Financial data.• Industry knowledge in Equities, Fixed income, Securities lending, derivatives, Loans and deposit systems. - Expertise in Basel II, Dodd-Frank S165, Basel III, Securities Lending, VaR.• Extensive experience in analyzing and documenting business requirements (BRD), data requirements, system functional specifications (FRD) .• In-depth knowledge of the various components of the testing methodology that includes the creation of test strategy document, use cases, detailed test cases, and test scripts.• Having experience in delivering the highly complex project with Agile and Scrum methodology.• Quick learner and up-to-date with industry trends, Excellent written and oral communications, analytical and problem-solving skills and good team player, Ability to work independently and well-organized.-

Listed skills include Sql, Credit Risk, Peoplesoft Financial, Peopletools, and 30 others.