| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateDINESH THOUTAM PHONE NUMBER AVAILABLESQL/SSIS/SSAS/Power BI Developer EMAIL AVAILABLELINKEDIN LINK AVAILABLEProfile SummaryHighly motivated SQL BI Engineer with 3 years of experience developing, implementing, and maintaining data solutions in on-premises environments. Proficient in T-SQL, SSIS, SSAS, SSRS, DBT, Power BI, DAX, Azure Data Factory, Azure Data Lake, Azure Analysis Services, and Azure SQL Server using ADF Pipelines. with hands-on experience in creating and optimizing complex SQL queries, Store procedures, Views, triggers, User Defined Functions, developing ETL packages, and building data models for effective reporting. Demonstrated expertise in automating data workflows, integrating data from multiple sources, and ensuring data accuracy and consistency through robust validation processes. Strong background in database design, performance tuning, Skilled in collaborating with cross-functional teams to gather requirements and deliver efficient, scalable data infrastructure that enhances data visibility and supports data-driven decision-making. Eager to leverage my technical skills and collaborative approach to tackle new challenges and contribute to innovative data initiatives.Skills Programming Languages: T-SQL, Python, C#, C++. RDBMS: MS SQL Server, SQL Database & DW. ETL Tools: SSIS (SQL Server Integration Services). Tools: Microsoft Visual Studio, SQL Server Management Studio. Reporting Tools: SSRS (SQL Server Reporting Services), Power BI.Professional ExperienceEmployer - Mega IT Corp, Dallas, TXClient Acuity Brands, Atlanta, GA 06/2023 05/2024SQL/SSIS/SSAS/SSRS/Power BI developerEnterprise Data Integration and Reporting Project:Contributed to the development of a comprehensive data integration and reporting solution for a major enterprise client. The project aimed to centralize data from multiple OLTP systems into a unified Data Warehouse, enabling enhanced analytics and reporting capabilities. By integrating disparate data sources, the project sought to streamline data management processes, reduce data redundancy, and provide a single source of truth for business intelligence needs. This centralization facilitated more accurate and timely reporting, improved data quality, and supported advanced analytical queries. Additionally, the solution aimed to enhance data visibility for stakeholders, enabling data-driven decision-making through interactive dashboards and reports. Overall, the initiative was designed to transform the client's data infrastructure, making it more scalable, efficient, and capable of supporting future business growth and innovation.Responsibilities:Extracted and integrated data from various sources into an intermediate staging database using SSIS (SQL Server Integration Services) ETL tools.Developed and maintained SSIS packages to validate, extract, transform, and load data from OLTP systems and DSR (Staging Database) to the Data Warehouse.Created and optimized complex stored procedures and utilized triggers to capture and manage deleted and updated data in OLTP systems.Utilized Joins, correlated and non-correlated sub-queries to execute complex business queries involving multiple tables and calculations across different databases.Developed and enhanced Tabular models on SQL Server Analysis Services (SSAS) to facilitate efficient and insightful Power BI reporting.Implemented data quality checks and validation processes within SSIS packages to ensure accuracy and consistency of the data.Conducted performance tuning of SQL queries and SSIS packages to optimize data processing speed and efficiency.Documented ETL processes, data flow diagrams, and database schemas to ensure clarity and maintainability for future development and troubleshooting.Assisted in designing and developing interactive dashboards and reports in Power BI, enhancing data visibility and decision-making capabilities for stakeholders.Contributed to the design and implementation of data warehousing solutions, ensuring scalability, performance, and data integrity.Implemented SSIS package security measures to protect packages and managed their execution, monitoring, and maintenance.Generated SQL Server Reports for Management using SSRS, covering tasks from requirement gathering to report implementation and maintenance.Executed querying and manipulation of multidimensional cube data through MDX Scripting in SSAS, ensuring data accuracy and consistency.Designed multi-dimensional cubes using SSAS and devised DW schemas, optimizing data storage and retrieval processes.Developed and optimized Dynamic SQL queries to generate custom reports based on user-defined parameters, improving reporting efficiency by 30%.Utilized DAX extensively for Tabular cubes and Power BI, addressing varying levels of complexity in measures and requirements.Client TCS, Bangalore, India 03/2021 12/2022Jr. SQL Database DeveloperResponsibilities:Assisted in the development, implementation, and maintenance of SQL databases, ensuring data integrity and optimal performance through routine updates and modifications.Created and modified SQL queries to retrieve, update, and manage data as required by the business, ensuring data accuracy and relevance for reporting and analysis purposes.Developed complex SQL stored procedures, Triggers, User Defined Functions, Views, and Indexes in SQL Server 2019, optimizing data retrieval and manipulation processes.Developed and maintained SSIS (SQL Server Integration Services) ETL packages for data extraction, transformation, and loading, automating data workflows to integrate data from various sources into the SQL database.Supported the optimization and tuning of SQL queries and SSIS packages, conducting performance analysis to enhance database and ETL processing efficiency.Participated in database design sessions, collaborating with senior developers and business analysts to ensure the database structure met business requirements and facilitated efficient data retrieval.Collaborated with senior developers and business analysts to gather and clarify requirements, translating business needs into technical specifications for database development and ETL processes.Implemented parameterized Dynamic SQL scripts for data manipulation and maintenance tasks, ensuring flexibility and performance in database operations.Demonstrated hands-on experience in creating new Repositories including Development, Test, UAT, and Master in Azure DevOps, and managed code check-in/check-out processes using Azure DevOps server.Designed complex SSAS solutions encompassing multiple dimensions, perspectives, hierarchies, measure groups, and KPIs to analyse performance at both Strategic Business Units and corporate levels.Created numerous cubes, dimensions, and business critical KPIs using SQL Server Analysis Services (SSAS), representing aggregations hierarchically and employing custom groupings for performance analysis.Leveraged extensive experience in Dimensional modelling, Data cleansing, Data Staging, and SSAS to ensure data accuracy and reliability.Implemented Row-level security in cubes using DAX expressions to restrict data access based on user roles and regions within SSAS.Developed complex SSRS Reports incorporating Sub Reports, Matrix/Tabular Reports, Charts, and Graphs to meet diverse reporting needs.Managed report subscriptions and schedules within SSRS, ensuring timely delivery of reports to stakeholders.Leveraged Global variables, Expressions, and Functions in SSRS to customize reports based on specific requirements.Created Parameterized Reports, cascaded Reports, linked Reports, demonstrating comprehensive knowledge of report server architecture in SSRS.Leveraged Power BI to explore data across various visualizations, enabling comprehensive data analysis and insights generation.EducationMaster of Science: Computer Science, 04/2024Kennesaw State University Kennesaw, GA Graduated with 3.6 GPA Majored in Data Science |
