Rudra Ghosh Email and Phone Number

Working as senior Data & Analytics architect for supply chain product development, CPG , Oil & Gas, Retail, BFSI . • Responsible for converting data into captivating, elegant visual representations to help business make better, data -driven • decisions. • Strong and demonstrable capability to build compelling visualizations, Understanding of data structures and data extraction. • Build data modelling and analytics, understanding of user experience on dashboard design to fulfil business requirement. • Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /Customers. • Expertise in leading on Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data • conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence. • Experience in ETL using ADF, Databricks to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems • Good problem-solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly

• Overall Project Management, Project initiation, defining the scope, Project Planning, Execution, Monitoring and Controlling, Resource Estimation, Transition Plan, Quality and Process Compliance.• Worked as a Transition Manager with responsibilities of new project initiatives by analyzing preliminary business needs and defining factors such as budget constraints, time management and resource planning.• Responsible for interacting with Clients for requirement elicitation, understanding future goals of a business, analyze & design to implement the logic to develop the interface, testing and delivery. • Extensively engaged in documenting Business, Functional and Technical requirements.• Managed end-to-end project delivery and operations across multiple domains like Insurance, Energy, Retail, and Manufacture in Agile, Waterfall, V-Model• Certificate in Azure Cloud Computing with good knowledge on IaaS, PaaS & SaaS on Cloud architecture• Build a high-quality Data Warehousing team and design the team to scale. Build cross functional relationships with Data analysts, Product owners and Engineers to understand data needs and deliver on those needs• Strong knowledge of various data warehousing methodologies and data modelling concepts. Hands on experience using Azure data lake, Azure functions, Databricks, ETL tools.• Executing on multiple projects simultaneously within a fast-paced environment working with cross-functional teams, collaboration with on-site team and stakeholders.• Excellent problem-solving skills involving complex and ambiguous issues• Working through complex interfaces across organizational and geographic boundaries• Strong negotiation skill and expert escalation management• Understanding customer needs and converting the opportunity into the business

• Creating new and customize existing T-SQL stored procedures and SSIS packages using best practices• Create complex queries on large data sets using T-SQL• Create stored procedures, triggers, and functions• Analyze trends in key metrics• Generate code to extract, transform and load data from production data sources to the data warehouse• Performance tuning of key queries.• Debugging store procedures for any query related issue• Application performance tuning• Perform Code review and peer feedback• Think logically when solving complex business challenges• Interact with the customer and ensure understanding of business requirements

• Responsible for programming T-SQL procedures and ETL modules for G4 Analytics Business Intelligence implementations and database-related monthly production and support tasks.• Involving in Design and Development of Packages by writing stored procedures, business logic, ETL (extract, transform, and load) packages, etc. Its include acquisition of data from source systems along with data mapping / modeling to construct transformations into BI data model. • Creating new and customize existing T-SQL stored procedures and SSIS packages using best practices • Emphasizing code reuse and automation • Creating and maintaining proper documentation • Production Support for client • Reviewing and analyzing on-going customer requests (for new data elements to be brought into the existing model, for customization or cross-walking of existing data elements, for computation of new fields based on customer-provided business logic, combinations of existing data elements, etc.) • Performing basic database administration tasks such as query and index tuning, performance analysis, Database Backup, Restore, Daily maintenance etc. • Participating in the generation of routine production deliverable for clients • Further to provide analytical cubes and Reports using SSAS and SSRS to help the business decision makers to make strategic decisions.

• Assist client by providing them with process and program related data as requested • Executed SQL statements • Edited and debugged T-SQL program units • Manipulated and exported data • Created and displayed reports • Prepared required documentation • Creating primary objects (tables, views, indexes) once application developers have designed an application • Modifying the database structure, as necessary, from information given by application developers • Enrolling users and maintaining system security • Ensuring compliance with Microsoft license agreements • Monitoring and optimizing the performance of the database • Backing up and restoring the database • Support existing database reporting platform and applications to ensure operational availability and scalability.