Senior consultant
Deloitte Touche Tohmatsu
Total years of experience :12 years, 2 Months
Designed and implemented a comprehensive data architecture using a full spectrum of cloud technologies to support business intelligence and data analytics initiatives. Developed data models and database designs to support application development, ensuring optimal performance and data integrity.
•Collaborated with cross-functional teams to gather requirements and define project scope, ensuring alignment with business objectives, finalize the data mapping, data tools for migration purpose and meeting with other team members to find the best solution for data migration and understanding the logic behind data movement from source to target.
•Designed and implemented a complex data pipeline/ Metadata driven pipeline using Azure Synapse Pipeline to automate the ingestion and processing of large volumes of data from various sources. Developed and executed test plans, ensuring the quality and reliability of the implemented systems.
•Developing scripts in Azure SQL, notebook framework in PySpark, integrating ETL/ELT for data movement from legacy system to D365 and DWH using Azure synapse Analytics, working in Metadata driven Pipeline and designed data validation framework, enterprise data lake solution. Integrate Common and physical Data model with Erwin both for legacy and D365 entity model.
•Exposure with various software development methodologies and practices such as Test-Driven Development, Continuous Delivery, Scrum and Agile. Experience with the following technologies, or equivalents: GitHub, Azure DevOps
•Led a data engineering team with both onshore and offshore in the successful implementation of a new CRM system; Conducted training sessions for end-users, ensuring smooth adoption and utilization of the new systems. Managed/Conducted project timelines, resources, cost analysis, budgets, and ensuring successful project delivery within scope and on schedule.
Tools: MS SQL Server, MySQL, ETL tool- SSIS, ADF, Azure Synapse analytics, Visual Studio, Dynamics CRM, Erwin
Designation: Senior Consultant/Techno-functional Lead
• Designed and implemented a comprehensive data architecture using a full spectrum of cloud technologies to support business intelligence and data analytics initiatives. Developed data models and database designs to support application development, ensuring optimal performance and data integrity.
• Worked on early-stage business projects, discovery eforts, and engagement initiated by Business relationship management, to provide appropriate architecture deliverables, such as stakeholder analysis, capability analysis, risk/value analysis and technical analysis.
• Collaborated with cross-functional teams to gather requirements and define project scope, ensuring alignment with business objectives, finalize the data mapping, data tools for migration purpose and meeting with other team members to find the best solution for data migration and understanding the logic behind data movement from source to target.
• Designed and implemented a complex data pipeline/ Metadata driven pipeline using Azure Synapse Pipeline to automate the ingestion and processing of large volumes of data from various sources. Developed and executed test plans, ensuring the quality and reliability of the implemented systems.
• Developing scripts in Azure SQL, notebook framework in PySpark, integrating ETL/ELT for data movement from legacy system to D365 and DWH using Azure synapse Analytics, working in Metadata driven Pipeline and designed data validation framework, enterprise data lake solution. Integrate Common and physical Data model with Erwin both for legacy and D365 entity model.
• Exposure with various software development methodologies and practices such as Test-Driven Development, Continuous Delivery, Scrum and Agile. Experience with the following technologies, or equivalents: GitHub, Azure DevOps
• Led a data engineering team with both onshore and ofshore in the successful implementation of a new CRM system; Conducted training sessions for end-users, ensuring smooth adoption and utilization of the new systems. Managed/Conducted project timelines, resources, cost analysis, budgets, and ensuring successful project delivery within scope and on schedule.
• Performs tasks required to conform to the companys configuration management and software release processes.
• Demonstrated proficiency in OLTP/OLAP, Analysis and E-R modelling, developing database structures - Star schemas and Snowflake schemas used in relational, dimensional, and multidimensional modelling.
• Hands-on experience in tuning mappings/queries, identifying and resolving performance botlenecks in various levels such as sources, targets, mappings, and sessions.
• Establishes and leads ETL work at the client site to meet client requirements and business needs.
• Determines ETL strategy; selects tools and techniques, including data cleansing tools, and/or data management systems to provide the solution to data and client issues and other maters of significance and to meet business needs.
Tools: MS SQL Server 2016, MFT, Tableau, ETL tool - SSIS 2016, Visual studio 2017, SSIS, SSRS, Confluence, Jira, Visual Studio 2017, Visual Studio 2019, GIT
Designation: BI/SQL Developer
• Managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Created SSIS package to transfer data between OLTP and OLAP databases. Analyzed, Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Responsible for reporting and data analysis for both internal and external stakeholders. Providing support for critical production systems in accordance with SLA
• Independently analyzing, solving, and correcting issues in real time, providing problem resolution end-to-end and support teams across the organization, including Finance, Product Management, Sales Operations, and Legal/Compliance.
• AML and transaction monitoring data warehouse design and development and integration with an automated reconciliation vendor (Blackline)
Tools: MS SQL Server 2016, Tableau, ETL tool - SSIS 2016, Visual studio 2017, MYSQL, PowerBI, SSRS, Open Reports, Datalake, Hive- Tahoe, Jira, Confluence, GitHub
Designation: Integration Developer
• Designing data structures and developing data integration processes, data migration from 2008 to 2017 version of SQL/Azure and upgraded ETL process.
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL Datawarehouse environment. experience in DWH/BI project implementation using Azure DF
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools) worked on Azure suite: Azure SQL Database, Azure Data Lake (ADLS), Azure Data Factory(ADF) V2, Azure SQL Data Warehouse, Azure Service Bus, Azure key Vault, Azure Analysis Service(AAS), Azure Blob Storage, Azure Search, Azure App Service, Azure data Platform Services.
• Experience with Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory (ADF) and SSIS
• Created SSIS package to transfer data between OLTP and OLAP databases. Analyzed, Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Independently analyzing, solving, and correcting issues in real time, providing problem resolution end-to-end
• Demonstrated experience building workflow and collaboration solutions with tools such as SharePoint Designer, MS Flow, PowerApps, Power Automate, Power BI, UI Path (RPA Developer)
• Exposure with various software development methodologies and practices such as Test-Driven Development, Continuous Delivery, Scrum and Agile. Experience with the following technologies, or equivalents: GitHub, Azure DevOps
• Worked with Azure transformation project and Azure architecture decision and migrate SQL Server database to Microsoft Azure Cloud.Design & implement data security and governance policies and standards
Tools: MS SQL Server 2016, MFT, Tableau, ETL tool - SSIS 2016, Visual studio 2017, PowerApps, Power Automate
Designation: Database Analyst/ Programmer
• Proficient in implementing complex SQL/Access queries, Schema Designing, Normalization, and Performance Tuning, data modeling, query optimization, designing stored procedures, triggers, debugging, managing indexes.
• Conducted data preparation, and outlier detection in data warehouse, created data modelling using MS SQL server 2008 R2, 2012, 2016 so that can be used by diferent applications.
• Create complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules and updated SQL packages from SQL 2005 to SQL 2012.
• Designed and developed SSIS packages, automated ETL processes using SSIS to load historical table, store procedures, configuration files, tables, views, functions, database backup and shrinking log files; implement best practices to maintain optimal performance.
• Implementation of High availability using SQL-SERVER 2012 and 2016. Ensured availability of environment with replication (Failover Cluster / Always-on) to recover environments in case of disaster.
• Administrated Dynamics 365 environment by refreshing, exporting, promoting code and upgrading the platform for business uses.
Tools: MS SQL Server 2016, MFT, Tableau, ETL tool - SSIS 2016, Visual studio 2017, Dynamics 365
Designation: Software Engineer
• Managed all phases of testing including development of test plans, scenarios, data, and test scripts for facilitation of System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Developed optimized solutions using SQL Server which improves data fetching from schema by 20%
• Fixed bugs and introduced new features which improved functional behavior by 30%.
• Worked on changing User Interface of desktop application with PB Ultimate Suite
• Designing data flow, process flow and modeling framework of ongoing stakeholder solutions that boost up software development.
• Conducted GAP analysis using ArchiMate to document the workflow model in As-is and To-Be state.
Tools: Sybase 12, PowerBuilder 12.5, TFS 2012 Professional, ArchiMate
Designation: Senior Software Engineer
• Facilitate monthly meetings with clients to document requirements and handle ERP solutions.
• Developed ETL process by SSIS from versatile data sources used in production reporting for marketing teams.
• Dealt with business intelligence using SSRS and SSIS.
• Defined data warehouse (star and snowflake schema) to generate normalized data with reduced noise that facilitate report generation performance by 75%.
• Created Tables, View, Indexes, Stored Procedures and Functions using SQL Server 2008 R2. Performed Backup and Restore databases, set up full and incremental backup (SQL Server 2008 R2 and MySQL)
• Designed SSIS package to extract patients data from Database which boost up the processing speed by 60%.
• Expertise in writing T-SQL Queries, PL-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
• Worked as Deputy Team lead in Ongoing service delivery team.
Tools: Tableau, MS Ofice, SSIS, MS SQL Server 2008 R2, 2012
Designation: Software Engineer
• Applied data mining techniques to fetch normalized data from big dataset.
• Assisted in creating monthly utilization reports that increased performance by 20%.
• Used SSIS and SQL for data collection, analysis, and critical report generation to provide solutions to stakeholders.
• Used Business Intelligence to create KPI for designing and developing analysis reports, charts, scorecards and dashboards for pharmaceutical companies.
• Designed and implemented a snowflake -schema Data Warehouse in Microsoft SQL Server based on the existing data warehouse. Investigated existing OLTP database schemas to support users reporting requirements including data drill-down and data aggregation.
• Handled the responsibilities of assisting CRM business analysts for developing and implementing business management strategies that improved project quality by 30%.
• Developed and managed scripts and processes to extract, transform and load data (ETL) for the Business Intelligence (BI) application. Used SQL Server and Excel to perform ad-hoc data reporting for multiple business areas.