Summary
Overview
Work History
Education
Skills
LANGUAGES
Timeline
COURSES
Generic

DEVENDRA MARANI

Toronto,Canada

Summary

Results-driven ETL Developer with over 10 years of experience in transforming data integration through advanced ETL processes. Proficient in T-SQL, SSIS, SSRS, SSAS, MS Dynamics 365, Dynamics NAV, and Power BI, with a proven ability to convert complex datasets into actionable insights that drive informed decision-making. Committed to leveraging technical expertise and project management skills to foster strategic business growth and enhance technological innovation. Recognized for a collaborative approach that aligns data solutions with organizational objectives.

Overview

10
10
years of professional experience

Work History

ETL Specialist Lead Developer and Tester

Virtusa
12.2019 - Current
  • Business Connect application is a credit origination and risk management solution used by Bank of Montreal. Business Connect helps the bank employees to track and streamline all the processes in Data gathering, Credit analysis, Credit Decisioning, Document generation, Closing, Funding, Booking stages of the loan origination process.
  • It has an admin module which helps the bank to customize the application up to 80% as per the business needs. Workflow is the heart of the system as the various tasks in the loan origination stages are routed to the respective bank employees through workflow only.
  • The application also has reporting and document generation functionalities using Crystal Reports and Document Server technologies.
  • CLIENT DESCRIPTION:
  • Client: Bank of Montreal (BMO)
  • Location: Toronto, Canada
  • The Bank of Montreal is a Canadian multinational investment bank and financial services company.
  • Founded in Montreal, Quebec in 1817, its head office remains in Montreal, with its operational headquarters and executive offices located in Toronto, Ontario since 1977.
  • One of the Big Five banks in Canada, it is the fourth-largest bank in Canada by market capitalization and assets, as well as one of the ten largest banks in North America.
  • Roles & Responsibilities:
  • Creating the SSIS Packages to get the data from multiple data sources like excel, csv, txt, PLSQL and SQL databases and storing into Master tables.
  • Created end-to-end data warehousing solutions using Microsoft SQL Server, SSIS, SSAS, and SSRS, resulting in efficient data storage and retrieval.
  • Pioneers novel ETL scripts, revolutionizing data transformation workflows. Implements cutting-edge solutions for complex integration challenges.
  • Expertise in defect tracking in tool(i.e., Jira, ALM, etc.)
  • Expertise in Test Case Preparation and Execution.
  • Having knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc.
  • Collaborates with cross-functional teams to troubleshoot and resolve data issues promptly.
  • Analyzes complex datasets to improve data accuracy and reliability, supporting business decisions.
  • Develops ETL scripts that streamline data transformation, leading to significant time savings.
  • Optimizes ETL processes, enhancing data flow and integration efficiency. Conducts in-depth analysis of complex datasets to improve accuracy and reliability.
  • Develop and maintain data models using SQL Server Data Tools (SSDT) and ensure they are optimized for performance and scalability.
  • Create and manage multiple data marts tailored to specific business needs on prem environment, enabling efficient access to targeted datasets and improving decision-making processes.
  • Develop and optimize complex ETL processes using SQL Server Integration Services (SSIS) to load data from diverse sources into data warehouses and data marts, ensuring high data quality and consistency.
  • Design the documents (HLD and LLD) and test cases for the data validation and Business requirement documents.
  • Collaborate with business analysts and stakeholders to understand data requirements and translate them into logical and physical data marts.
  • Liaised with client stakeholders to capture and refine project requirements, ensuring alignment with business objectives.
  • Ensure accurate and timely data flow between different systems and the data warehouse.
  • Monitor and optimize the performance of data warehouse queries and ETL processes.
  • Develop the SSIS packages to move data from multiple sources to SQL Server, SQL Server to GUI, Oracle to SQL etc.
  • Integrate data from various sources, including databases, flat files, APIs, and external systems.
  • Write Stored procedures, views to pull data from multiple staging tables to master tables.
  • Developed OLAP cubes and tabular data marts in SSAS to support multidimensional data analysis, enabling advanced reporting and business insights.
  • Prepare the templates to capture data to verify whether data moved correctly or not
  • On monthly basis update the variable values as containing of the current month.
  • Prepare and design the SSRS reports by using SQL Server Reporting tool to identify the Cash inflow and Outflow based on Location and Brach.
  • Develop multiple SSRS & Power BI reports on daily basis.
  • Technical expertise with Microsoft .NET technologies such as C#, .NET Framework, ASP.NET.
  • Work on Improving the performance of the packages by applying SSIS techniques.
  • Schedule SSIS packages Using SQL Server Agent in SSMS
  • Create SSIS package configuration files and deploy the packages into target server like Development and QA environments.
  • Ensure data accuracy and consistency by implementing data validation, cleansing, and governance policies using SQL Server Data Quality Services (DQS) and Master Data Services (MDS).
  • Debug and Validate the Data flows and Control Flows on all SSIS packages
  • Partnered with stakeholders to capture requirements and design data models. Created comprehensive documentation, aligning data architecture with business objectives.
  • Engineered robust data warehouse solutions using Microsoft SQL Server. Developed and maintained SSIS packages for efficient data migration from diverse sources.
  • Crafted stored procedures and views for multi-table data extraction. Prepared detailed design documents and test cases, ensuring thorough project documentation.
  • Engineered robust ETL processes using SSIS, optimizing data migration from diverse sources to GEM databases, enhancing data quality and consistency.
  • Designed and implemented tailored data marts, improving access to targeted datasets and empowering data-driven decision-making across the organization.
  • Partnered with stakeholders to capture requirements, design data models, and document architecture, ensuring alignment with business objectives.
  • Worked with business users to validate data accuracy and ensure reports aligned with NAV chart of accounts and dimensions.
  • Participated in report testing, validation, and troubleshooting during Jet Report development.
  • Exposure to Jet Analytics cubes for analyzing multi-company and consolidated reporting data.
  • Collaborated with senior team members in automating monthly reporting processes using Jet Reports.
  • Learned to integrate Jet Reports with Excel pivot tables and Power BI for enhanced visualization.
  • Work on Exception Handling process for each SSIS Package.
  • Generate the Power BI Dashboards on Weekly and Monthly based on client Requirement
  • Capture the error information by using configurations and logging files on SSIS packages.
  • Coordinate with the offshore team to monitor the jobs status, Training sessions with advanced features on the technology in offshore hours.
  • Conducts in-depth analysis of complex datasets, enhancing data accuracy and reliability to support informed business decisions.
  • Partners with cross-functional teams to swiftly identify and resolve data issues, facilitating seamless communication between technical and non-technical stakeholders.
  • Optimizes ETL processes, leading to significant time savings and measurable improvements in data quality and integration efficiency.
  • Meticulously designs and executes ETL tests, implementing rigorous quality control measures to ensure data integrity throughout the pipeline.
  • Develop complex ETL processes using SSIS, optimizing data flow from diverse sources to master tables, enhancing data integrity and accessibility.
  • Create end-to-end data warehousing solutions with SQL Server, SSIS, SSAS, and SSRS, significantly improving data storage and retrieval efficiency.
  • Develop and optimize complex ETL processes using SSIS, ensuring efficient data integration from diverse sources into master tables for enhanced analytics
  • Create end-to-end data warehousing solutions with SQL Server, SSIS, SSAS, and SSRS, driving efficient data storage and retrieval for improved decision-making
  • Design and maintain scalable data models using SQL Server Data Tools, continuously improving performance to meet evolving business requirements
  • Develop tailored data marts for specific business needs, facilitating targeted data access and fostering cross-functional collaboration
  • Implement robust ETL processes, meticulously integrating data from various sources including Excel, CSV, TXT, PLSQL, and SQL databases
  • Develop and optimize ETL processes using SSIS, integrating diverse data sources into master tables for efficient data warehousing solutions.
  • Crafted SSIS packages to extract data from diverse sources, including Excel, CSV, TXT, PLSQL, and SQL databases, ensuring accurate data consolidation in master tables.
  • Partnered with cross-functional teams to troubleshoot and resolve issues, enhancing the efficiency of BMO's loan origination process across multiple stages.
  • Leveraged expertise in test case preparation, execution, and defect tracking using Jira and ALM, ensuring high-quality deliverables for the Business Connect application.
  • Pioneered advanced ETL scripts, revolutionizing data transformation workflows and implementing cutting-edge solutions for complex integration challenges.
  • Developed end-to-end data warehousing solutions using SQL Server, SSIS, SSAS, and SSRS, optimizing data storage and retrieval processes.
  • Expertly managed defect tracking using Jira and ALM, ensuring thorough test case preparation and execution throughout the software test lifecycle.

MSBI Developer

Virtusa Polaris
04.2015 - 12.2019
  • Company Overview: Bank of Montreal is a fully service based company. BMO is a bank to maintain the cash inflow and outflow of the merchants. The main objective is to do the analyze in various aspect such as Revenue and Cash inflow and outflow based on daily, weekly, monthly basis. BMO can analyze the data by comparing with previous monthly, quarterly and easily understanding of growth, margin of the revenue. BMO get the transaction details based on US and Canada regions and produced reports to the customers on daily basis.
  • Data migration from multiple sources/databases/applications to GEM databases using SSIS packages and SQL queries.
  • Design, implement, and optimize ETL processes using SSIS to extract, transform, and load data from various sources into the data warehouse.
  • Develop and maintain comprehensive data warehouse solutions using Microsoft SQL Server, ensuring robust data storage, retrieval, and processing capabilities.
  • Create and manage multiple data marts tailored to specific business needs, enabling efficient access to targeted datasets and improving decision-making processes.
  • Develop and optimize complex ETL processes using SQL Server Integration Services (SSIS) to load data from diverse sources into data warehouses and data marts, ensuring high data quality and consistency.
  • Creation of SSIS Packages to get the data from Master tables.
  • Partnered with business stakeholders and data analysts to capture requirements, design data models, and document the architecture of data warehouses and data marts, ensuring alignment with business objectives.
  • Preparing design documents (HLD and LLD) and test cases.
  • Designing SSIS packages to move data from multiple sources to SQL Server, SQL Server to GUI etc.
  • Writing Stored procedures, views to pull data from multiple tables.
  • Implement query optimization, indexing, and partitioning strategies in SQL Server to enhance the performance of data warehouses and data marts, reducing query execution times and improving data retrieval speeds.
  • Apply Microsoft SQL Server security features, including encryption, auditing, and role-based access control, to safeguard data within data warehouses and data marts, ensuring compliance with data privacy regulations.
  • Prepared templates to capture data to verify whether data moved correctly or not
  • Monthly need to update the variable values as containing of the current month.
  • Preparing SSRS reports by using SQL Server Reporting tool to identify the Cash inflow and Outflow based on Location.
  • Created multiple SSRS reports on daily basis.
  • Improving the performance of the packages by applying SSIS techniques.
  • Scheduling SSIS packages Using SQL Server Agent in SSMS
  • Creation of configurations, Deploying packages to target server.
  • Debugging and Validating the Data flows and Control Flows
  • Implemented Exception Handling process for each SSIS Package.
  • Generated the Reports Weekly and Monthly basis as per the Client Requirements.
  • Implemented configurations and logging on SSIS packages.
  • Developed and optimized MSBI solutions, enhancing data-driven decision-making. Streamlined ETL processes, resulting in substantial efficiency gains and improved data quality.
  • Pioneered novel BI reporting techniques, revolutionizing data visualization. Implemented cutting-edge MSBI tools, driving actionable insights and fostering data-centric culture.
  • Spearheaded MSBI projects, delivering robust solutions that significantly boosted operational efficiency. Consistently met tight deadlines, ensuring timely deployment of critical BI systems.
  • Extracted financial, sales, inventory, and vendor data from Microsoft Dynamics NAV SQL database using SSIS and T-SQL queries.
  • Designed SSIS packages to automate daily/weekly data extraction from NAV tables (e.g., General Ledger, Customer Ledger, Vendor Ledger, Item Ledger, Sales Header/Lines).
  • Applied data cleansing and transformation rules to handle NAV-specific data formats (e.g., dimensions, posting dates, currency codes).
  • Built ETL pipelines to integrate NAV data into a centralized Data Warehouse for reporting in Power BI / SSRS.
  • Implemented incremental load logic (using Change Tracking / Modified Date in NAV tables) to avoid full loads and improve performance.
  • Developed error handling and logging frameworks within SSIS packages to track NAV data load issues and automate retries.
  • Performed data validation & reconciliation between NAV source system and target warehouse to ensure financial accuracy.
  • Optimized SQL queries and stored procedures on NAV tables (which can be large and complex) to enhance ETL performance.
  • Collaborated with functional consultants to understand NAV business processes (Finance, Sales, Procurement) and translate into ETL rules.
  • Migrated historical data from NAV ERP to Dynamics 365 Business Central / SQL Server Data Warehouse as part of ERP modernization.
  • Partnered with cross-functional teams to align MSBI solutions with business objectives. Facilitated knowledge transfer sessions, enhancing team's overall MSBI proficiency.
  • Meticulously designed and implemented complex MSBI architectures, ensuring data integrity and system reliability. Conducted thorough QA processes, minimizing errors in BI outputs.
  • Optimized ETL processes using SSIS, enhancing data warehouse efficiency. Designed tailored data marts, enabling targeted dataset access for improved decision-making.
  • Partnered with stakeholders to capture requirements and design data models. Created comprehensive documentation, aligning data architecture with business objectives.
  • Engineered robust data warehouse solutions using Microsoft SQL Server. Developed and maintained SSIS packages for efficient data migration from diverse sources.
  • Crafted stored procedures and views for multi-table data extraction. Prepared detailed design documents and test cases, ensuring thorough project documentation.
  • Engineered robust ETL processes using SSIS, optimizing data migration from diverse sources to GEM databases, enhancing data quality and consistency.
  • Designed and implemented tailored data marts, improving access to targeted datasets and empowering data-driven decision-making across the organization.
  • Partnered with stakeholders to capture requirements, design data models, and document architecture, ensuring alignment with business objectives.
  • Worked with business users to validate data accuracy and ensure reports aligned with NAV chart of accounts and dimensions.
  • Participated in report testing, validation, and troubleshooting during Jet Report development.
  • Exposure to Jet Analytics cubes for analyzing multi-company and consolidated reporting data.
  • Collaborated with senior team members in automating monthly reporting processes using Jet Reports.
  • Learned to integrate Jet Reports with Excel pivot tables and Power BI for enhanced visualization.

Senior Developer

Virtusa
04.2017 - 10.2017
  • Company Overview: Dynamic CRM shall be extended to be the common platform for the secured viewing and updating of information. The records in the platform shall be modeled to be compatible with the schema adopted by the Common Data Hub and shall be able to represent the data in the Common Data Hub accurately. Records which are modified will go for approval and the approval should be done by record owning team or team member. CRM get data from legacy applications then moved to centralized location. Dynamic Navision is a supplier to provide the account, customer and transactional data
  • Data migration from multiple sources/databases/applications to centralized database using SSIS packages and SQL queries.
  • Extract Data from Dynamic Navision on prem servers to SQL servers using SSIS tools.
  • Extracted financial, transactions, and vendor data from Microsoft Dynamics NAV SQL database using SSIS and T-SQL queries.
  • Designed SSIS packages to automate daily/weekly data extraction from NAV tables (e.g customer and their transaction ledgers).
  • Applied data cleansing and transformation rules to handle NAV-specific data formats (e.g., dimensions, accounts dates, currency codes)
  • Built ETL pipelines to integrate NAV data into a centralized Data Warehouse for reporting in Power BI / SSRS.
  • Implemented incremental load logic (using Change Tracking / Modified Date in NAV tables) to avoid full loads and improve performance.
  • Developed error handling and logging frameworks within SSIS packages to track NAV data load issues and automate retries.
  • Performed data validation & reconciliation between NAV source system and target warehouse to ensure financial accuracy.
  • Optimized SQL queries and stored procedures on NAV tables (which can be large and complex) to enhance ETL performance.
  • Collaborated with functional consultants to understand NAV business processes (Finance, Sales, Procurement) and translate into ETL rules.
  • Migrated historical data from NAV ERP to Dynamics 365 Business Central / SQL Server Data Warehouse as part of ERP modernization.
  • Develop and maintain comprehensive data warehouse solutions using Microsoft SQL Server, ensuring robust data storage, retrieval, and processing capabilities.
  • Create and manage multiple data marts tailored to specific business needs, enabling efficient access to targeted datasets and improving decision-making processes.
  • Develop and optimize complex ETL processes using SQL Server Integration Services (SSIS) to load data from diverse sources into data warehouses and data marts, ensuring high data quality and consistency.
  • Implement indexing, partitioning, and query optimization techniques in SQL Server, improving data retrieval speeds by up to 50%.
  • Creation of SSIS Packages to get the data from Master tables.
  • Worked closely with business analysts and stakeholders to gather requirements and document data warehouse architecture and ETL processes using SQL Server Data Tools (SSDT).
  • Worked with business users to validate data accuracy and ensure reports aligned with NAV chart of accounts and dimensions.
  • Participated in report testing, validation, and troubleshooting during Jet Report development.
  • Exposure to Jet Analytics cubes for analyzing multi-company and consolidated reporting data.
  • Collaborated with senior team members in automating monthly reporting processes using Jet Reports.
  • Learned to integrate Jet Reports with Excel pivot tables and Power BI for enhanced visualization.
  • Preparing design documents (HLD and LLD) and test cases.
  • Designing SSIS packages to move data from CRM to SQL Server, SQL Server to CRM etc.
  • Writing Stored procedures, views to pull data from multiple tables.
  • Prepared templates to capture data to verify whether data moved correctly or not.
  • Spearheaded cutting-edge software solutions, driving technological advancements and enhancing system efficiency for diverse client projects.
  • Optimized code performance, resulting in substantial improvements in application speed and user experience across multiple platforms.
  • Fostered strong team relationships, facilitating seamless knowledge transfer and promoting a culture of continuous learning and growth.
  • Conducted in-depth system analyses, identifying critical areas for improvement and implementing strategic solutions to complex technical challenges.
  • Ensured meticulous code quality through rigorous testing and debugging processes, significantly reducing post-deployment issues.
  • Developed data warehouse solutions using SQL Server, optimizing ETL processes with SSIS for efficient data integration from diverse sources.
  • Partnered with business analysts to gather requirements, document architecture, and create tailored data marts for improved decision-making.
  • Designed SSIS packages for seamless data movement between CRM and SQL Server, ensuring accurate and consistent information across platforms.
  • Spearheaded cutting-edge software solutions, driving technological advancements and enhancing system efficiency for diverse client projects.

Developer, Enterprise Architect Group-BI(EAG BI)

Virtusa Polaris
05.2016 - 04.2017
  • Company Overview: Virtusa Polaris is a fully service based Company. EAG BI Dashboard is a tool for analyzing the business Revenue, Head Count and Attrition within the organization. The main objective is to do the analysis in various aspects such as Revenue, Attrition and sales pipeline. Senior managements will be able to view the summary of Revenue, Human capital & sales pipeline. They can analyze the data by comparing with previous monthly, quarterly and easily understanding of growth, margin of the organization. Trend analysis is available for Human Capital like Head Count, Billable & Non Billable Head Counts.
  • Understanding the Business structure and analyzing of Business Data.
  • Creation of SSIS Packages to get the data from Master tables.
  • Create Data warehouse with robust technology concepts with the faster data retrieval and enhanced security levels.
  • Using of transformations Like Derived Column, Execute SQL Task, Lookup, Conditional split, Copy Column, Data Conversion and sort transformations to get the data from master tables and pushed into the staging tables.
  • Creation of Cubes with multiple number of Dimension and Fact tables.
  • Creation of Calculations based upon the associate Head counts, Project Organic Type, Employee Heritage and project codes.
  • Preparing of dashboards by using of Power View and Power BI to analyze the margin and growth of the company.
  • Monthly need to update the variable values as containing of the current month.
  • Implement query optimization, indexing, and partitioning strategies in SQL Server to enhance the performance of data warehouses and data marts, reducing query execution times and improving data retrieval speeds.
  • Need to find the Organization Profitability and Revenue by quarterly and monthly.
  • Preparing SSRS reports by using SQL Server Reporting tool to identify the Project, SBU, Location & Practice levels of Delivery Rigor Index, Net promoter score and Zero defect Density.
  • Preparing SSRS reports to identifying the Employee Delivered Revenue (EDR).
  • Used Power BI tool to create Dashboard.
  • Monthly need to update the variable values as containing of the current month.
  • Developed and optimized BI dashboards for revenue, headcount, and attrition analysis, enabling data-driven decision-making for senior management.
  • Created robust data warehouse solutions, implementing advanced SSIS packages and cube structures for enhanced data retrieval and security levels.
  • Streamlined reporting processes using SSRS, providing critical insights on project performance, delivery rigor, and customer satisfaction metrics.
  • Implemented query optimization techniques, improving data warehouse performance and significantly reducing query execution times.
  • Pioneered the use of Power BI for comprehensive trend analysis, facilitating strategic planning and growth forecasting for the organization.
  • Developed and optimized SSIS packages for efficient data extraction from master tables, enhancing data warehouse performance and security levels.
  • Created Power BI dashboards for real-time visualization of company growth and margins, facilitating data-driven decision-making for senior management.
  • Implemented query optimization techniques in SQL Server, significantly reducing execution times and improving data retrieval speeds in data warehouses.
  • Developed SSRS reports to track key performance indicators across projects, locations, and practices, driving continuous improvement in delivery quality.
  • Developed robust data warehouse solutions, optimizing query performance and enhancing data retrieval speeds for improved business intelligence capabilities.
  • Created Power BI dashboards to analyze company growth and margins, enabling senior management to make data-driven decisions on revenue and human capital.
  • Implemented advanced SSIS packages, leveraging various transformations to efficiently extract and load data from master tables to staging environments.

Developer, Management Information System (MIS Analytic’s)

Polaris
04.2015 - 04.2016
  • Company Overview: Polaris is a fully Product & service based Company. Management Information System (MIS Analytic’s) Dashboard is a tool for analyzing the business Revenue, Head Count and Attrition within the organization. The main objective is to do the analysis in various aspects such as Revenue, Attrition and sales pipeline. Senior managements will be able to view the summary of Revenue, Human capital & sales pipeline. They can analyze the data by comparing with previous monthly, quarterly and easily understanding of growth, margin of the organization. Trend analysis is available for Human Capital like Head Count, Billable & Non Billable Head Counts.
  • Understanding the Business structure and analyzing of Business Data.
  • Develop and maintain comprehensive data warehouse solutions using Microsoft SQL Server, ensuring robust data storage, retrieval, and processing capabilities.
  • Create and manage multiple data marts tailored to specific business needs, enabling efficient access to targeted datasets and improving decision-making processes.
  • Develop and optimize complex ETL processes using SQL Server Integration Services (SSIS) to load data from diverse sources into data warehouses and data marts, ensuring high data quality and consistency.
  • Creation of SSIS Packages to get the data from Master tables.
  • Using of transformations Like Derived Column, Execute SQL Task, Lookup, Conditional split, Copy Column, Data Conversion and sort transformations to get the data from master tables and pushed into the staging tables.
  • Creation of Cubes with multiple number of Dimension and Fact tables.
  • Creation of Calculations based upon the associate Head counts, Project Organic Type, Employee Heritage and project codes.
  • Preparing of dashboards by using of Power View and Power BI to analyze the margin and growth of the company.
  • Monthly need to update the variable values as containing of the current month.
  • Need to find the Organization Profitability and Revenue by quarterly and monthly.
  • Preparing SSRS reports by using SQL Server Reporting tool to identify the Project, SBU, Location & Practice levels of Delivery Rigor Index, Net promoter score and Zero defect Density.
  • Preparing SSRS reports to identifying the Employee Delivered Revenue (EDR).
  • Drove project success through efficient coding practices and proactive problem-solving. Consistently delivered high-quality software within tight deadlines.
  • Fostered strong team relationships, facilitating knowledge sharing and cross-functional cooperation. Contributed to a positive work environment.
  • Applied data-driven insights to refine development processes, resulting in improved code quality and reduced debugging time.
  • Anticipated future tech trends, integrating forward-thinking methodologies into development practices. Positioned team for long-term success.
  • Developed data warehouse solutions using SQL Server, optimizing ETL processes with SSIS for efficient data management and improved decision-making.
  • Created Power BI dashboards for analyzing company margin and growth, enabling senior management to visualize revenue, human capital, and sales pipeline trends.
  • Managed complex ETL processes, utilizing various SSIS transformations to ensure high data quality and consistency in staging tables and master data.
  • Worked closely with business units to understand organizational structure, analyzing data to provide insights on revenue, attrition, and sales pipeline performance.
  • Developed and maintained data warehouse solutions using SQL Server, optimizing ETL processes for enhanced data quality and consistency.
  • Created tailored data marts, enabling efficient access to targeted datasets and improving organizational decision-making processes.
  • Implemented Power BI dashboards for analyzing company margin and growth, providing actionable insights for senior management.
  • Managed complex SSIS packages, utilizing various transformations to extract and load data from master tables into staging environments.

Education

Bachelor of Technology -

JNTU Anantapur
Anantapur, Andhra Pradesh

Skills

  • ETL
  • SSIS
  • SSRS
  • SSAS
  • SQL Server
  • PLSQL
  • T-SQL
  • AML
  • GITHUB
  • MS Dynamic CRM
  • Dynamic Navision
  • Python
  • Airflow
  • TFS
  • JIRA
  • Power BI
  • Informatica
  • C#
  • NET
  • ASPNET
  • Crystal Reports
  • Talend
  • Data Warehousing
  • Database Design
  • Performance Tuning
  • Project Management
  • POWERAPPS
  • Incident Management
  • Data Cleansing

LANGUAGES

English

Timeline

ETL Specialist Lead Developer and Tester

Virtusa
12.2019 - Current

Senior Developer

Virtusa
04.2017 - 10.2017

Developer, Enterprise Architect Group-BI(EAG BI)

Virtusa Polaris
05.2016 - 04.2017

MSBI Developer

Virtusa Polaris
04.2015 - 12.2019

Developer, Management Information System (MIS Analytic’s)

Polaris
04.2015 - 04.2016

Bachelor of Technology -

JNTU Anantapur

COURSES

  • DEC 2019 - PRESENT
  • ETL Specialist at Virtusa
  • APR 2015 - DEC 2019
  • MSBI Developer at Virtusa Polaris

Similar Profiles

CREATE PROFILE
DEVENDRA MARANI