Vijay Shanmugam

• Working as the Senior Business Intelligence Consultant in a client-facing role. Responsible for Development and Support of Business Intelligence Applications and helping the end users to get insights from the data
• Designed, customized, Automated and optimized BI Dashboards, Reports, KPI Scorecards for specific visualization tasks using Microsoft Power BI and SSRS.
• Evaluated trends of Business using Power BI, SSRS to understand competitive environments and to derive current strategies and applied problem-solving skills to analyse and resolves issues which impacting business operations and goal achievement
• Collected data from wide-ranging sources, including SAP BW, SQL Server, Oracle, Big data - Hadoop, SAP Hana, CSV, excel etc., and handled massive quantities of business intelligence data, and managing as much as 300 gigabytes.
• Proficient in developing and debugging Microsoft SQL Server, DAX, SAP HANA and Hive Queries and Led Power BI development initiative as Subject Matter Expert and primary point of contact between Stakeholders and developer for smother process.
• Expert in using Advanced calculation in Data set and Proven skills in writing DAX queries for KPI’s, Measures and for other Power BI functions
• Experienced in creating different visualizations using Bars, Lines, Pies, Maps, Graph, Bubble, Tree Map and Histogram.
• Ensuring accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution.
• Review and Integrate BI application requirements, including functional, security, integration, performance, quality, and operations requirements
• Played a key role in the Migration of Reports and Dashboards from QlikView and other legacy systems to Power BI and SSRS. Provided technical guidance and solutions to peer technical teams
• Built library of Models and reusable knowledge-based assets to produce consistent and streamlined business intelligence results using Power BI and MSBI to improvise current business process to business stakeholders.
• Identified process inefficiencies through gap analysis and created the Planned, designed and implemented diverse business intelligence solutions.
• Monitored and optimized SQL server and Power BI dashboard performance by writing the SQL and DAX optimization techniques like index creation, partition creation, converting snow flake model to Star schema model, incremental techniques etc
• Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards using waterfall and Agile technologies and tracked the same using Jira and TFS.
• Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues and conducted cross-functional team of business analysts, developers and technical support professionals to determine comprehensive list of requirement specifications for new applications.

• Working as the Business Intelligence Consultant in a client-facing role. Responsible for Development and Support of Business Intelligence Applications and helping the end users to get insights from the data
• Identifying requirements and providing best solutions to users involving evaluation & definition of scope of project and finalization of project requirement
• Review and Integrate BI application requirements, including functional, security, integration, performance, quality, and operations requirements
• Expert in Developing and Building visualizations using Power BI Desktop and Power BI Service. Efficient in creating a Data model with Calculated Columns, Measures, Calculated tables using DAX, Clean and Transform data with the Power Query Editor
• Customized and Designed advanced visualizations and optimize Power BI dashboards with a focus on usability and performance. Configured and Setup Gateways for Data Sources, Published the Reports and supporting dashboards
• Implemented Row Level Security by defining various constraints for each defined role. Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs, multiple scorecards to display information required by different departments and upper level management along with slicers and dicers enabling end-user to make filters.
• Creating matrix reports, parameterized reports, drill down reports, drill through reports, sub reports and linked reports using SSRS and Power BI
• Design and Develop ETL and ELT solutions to migrate the data from heterogeneous sources like Flat files, Oracle, Netezza to Azure Data Warehouse using SSIS.
• Utilized advanced Microsoft excel functions like PivotTables, VLOOKUP, INDEX/MATCH, Data Tables for Data analysis and Reporting
• Driving end-to-end execution of assignment from kick-off till the end of contract period and ensuring closure of issues/ clarifications raised by users
• Involved in the Migration of Reports and Dashboards from COGNOS to SSRS and Power BI. Provided technical guidance and solutions to peer technical teams
• Enhanced report performances by tuning the slow performing queries, join structures, applying indexes, avoiding parameter sniffing.
• Creating Data driven report subscriptions and schedule it to run daily, weekly, monthly based upon the user needs

• Working as a Technical Lead, Mentoring and supervising a team of developers for SQL BI and database objects such as SSIS packages, SSRS Reports, Tables, Store procedures, Functions, Views and Indexes using T-SQL for Microsoft Dynamics CRM project.
• Designed CRM Online batch migration approach to read data from Azure Blob Storage using SSIS Packages and deployed it on Azure.
• Responsible for setting up of Azure Blob storage, Data Factory V2 on Azure portal, Configuration of SSIS Integration Runtime and SSIS Packages Deployment on Azure.
• Manage the team in building data integration packages for ETL processes and reports in Business Intelligence platform.
• Actively engage in design discussions for all Business Intelligence and database initiatives.
• Design and execute Business Intelligence solutions including ETL and Reporting requirements using SSIS and SSRS respectively. Identify client needs and propose solutions.
• Developed technical roadmaps and led proof of concept (POC) on the SQL Database and BI tools. Project concluded with the delivery of POC findings and recommendations to upper level management and stakeholders.
• Led and participated in projects, managed escalations, assigned work, and interfaced with program office on service delivery improvements.
• Developed strategy recommendations, detailed project plans, and conducted weekly senior executive briefings
• Conducted multiple in-house trainings on technical and functional areas of data integration and reporting for Dynamics CRM Platform.
• Implemented the best practices for improving the performance of CRM Database and Data migration solutions.
• Optimized SQL queries and stored procedures increasing application effectiveness without increasing memory requirement. Automated tasks using Windows Task Scheduler and SQL Server agent jobs.
• Designed and developed software architecture and created the technical design documents.

• Designed and Developed SSIS packages for Loading Data from Different Sources like Excel Files, Flat Files, Sybase IQ, Oracle, Teradata, SQL Server into Microsoft Dynamics CRM
• Responsible for the Design, Development and Implementation of mappings /transformations based on source-to-target specifications, Defining ETL (extract, transform, load) development standards and conventions
• Actively engage in design discussions for all Business Intelligence and database initiatives. Identify client needs and propose solutions.
• Expertise in using SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, Send Mail etc.
• Extensive experience in implementing Data Cleansing, Duplicate Detection and Data profiling techniques
• Implemented Parallelism logic in the Data Flow Tasks to improve the performance of long running SSIS Packages Optimized the Packages on various aspects and achieved greater improvements.
• Created and Scheduled Automated Jobs for Various SSIS ETL Process using SQL Server Agent and Windows Task Scheduler.
• Developed and deployed the SSRS reports to CRM Server for the end users and enhanced the existing reports as per client requirements.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Expertise in using Execution Plan, DMV’s, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created Database Maintenance plans, Developed SQL Objects for Database Archiving and Purging activities and Scheduled jobs for it.
• Actively worked in multiple projects on Database, SSRS and SSIS related areas simultaneously.
• Designed High Level Technical Documents for the Standards followed in the Software Development Process. Used Visio for diagramming in the design phases.

• As a part of MIS Team, Designed and Developed SSIS Packages to Migrate Data between different heterogeneous sources such as Flat file, Excel, Sybase ASE, Sybase IQ, Oracle and SQL Server 2012 and created data mappings to load the data from source to destination.
• Expertise in Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Experience with SSIS performance tuning using Performance Counters, Error handling, Event handling, Checkpoints, Logging.
• Designed the Data Warehouse for Corporate Data Mart Project using Sybase IQ and SSIS.
• Managed to design the ETL Specifications document, Data Mapping document, operational procedures, deployment guides, and End user documents to support End to End phases of the project.
• Optimized Relational Database management system and managed it.
• Created the automated jobs for the activities such as database backup processes, Database maintenance plans, and SSIS Packages using SQL Server Agent job.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.

• As Application developer, I’ve been involved in Coding, Testing, Bug Fixing and other quality processes (CMMI) based on the organization standards.
• Understanding the business requirements and then translating them into technical requirements.
• Involved in writing SQL queries- Sub queries, Correlated Queries, Dynamic Queries, Stored Procedures, Functions-User Defined Functions, System Functions, Ranking Functions, Triggers, CTE, Temp Tables, Indexes- Clustered indexes, Non Clustered Indexes, Joins, Constraints, Cursors, Performance tuning, Error handling.
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
• Involved in Performance Tuning and Query Optimization in SQL Server.
• Used SQL Profiler for Performance monitor and to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, reporting on SQL Server 2008 using SSIS, SSRS.
• Involved in Creation, Development and Deployment of SSIS packages.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS
• Involved in Installation, Configuration and Deployment of Reports using SSRS
• Preparing Technical Specification Document, High Level Design Document, Detailed Design Document.
• Involved in requirement gathering and design and development process for the new requirements as well as change requests.