VIJAY S

E Mail: adhart@r.postjobfree.com Phone: +971-********* LinkedIn: www.linkedin.com/in/svijay3187

Possess excellent problem solving, communication and presentation skills with capability to attain career growth in Database Development as BI Lead, whilst making mark within a reputed organization in IT industry

Core Competencies

Database Development

SQL Server Integration Services

Business Intelligence/ Data Migrations

SSRS Reporting / Data Visualizations

Proof of Concept (POC) Development

Performance Tuning

Requirement Gathering

Process Enhancement

IT Service Management

Statistical Analysis

Trainings and Team Leadership

IT Skills

Database: SQL Azure Datawarehouse, SQL Server 2008, SQL Server 2012, SQL Server 2014, Sybase IQ, Netezza Datawarehouse, Oracle

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (Tabular model), Power BI, Azure Data Factory, COGNOS

Software: SQL Server Management Studio, Microsoft Visual Studio, Power BI Desktop, Database Engine Tuning Advisor, SQL Server Profiler, Toad for Oracle, KingswaySoft SSIS Integration Tools, Attunity connector for Oracle and Teradata

Programming: T-SQL, DAX, C#

Source Code Tools: Team Foundation Server

Profile Summary

Qualified Engineering Professional offering around 10 years’ experience in data analysis, design, development and integration

Worked as Microsoft Business Intelligence Developer by leveraging the functionalities of SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and Power BI

Wealth of expertise in creating Power BI reports and dashboards using Data visualizations like Bar chart, Line chart, pie charts, forecast charts

Developed Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI

Proven experience in creating DAX Expressions, create date to yearly columns and implement partitions in Tabular Models,

Created dashboards and presented to end users from variety of large datasets for statistical analysis, quality metrics, forecasting and risk assessment. Publishing reports and dashboards in Power BI server and scheduling the dataset to refresh for upcoming.

Exhibited excellence in Global Enterprise Data Conversion, BI Strategy, MDM, Data-Warehousing, Power BI Enterprise, Data Management & CRM Data Management across Banking Sectors

Conducted the data mapping, data analysis, data extraction, transforming and loading (ETL) using SQL Server Integration Services (SSIS) along with the functional expertise in analysing multiple data sources, data investigation, cleansing, profiling, applying business transformation & data integration into Data Mart

Possess development skills in SQL/T-SQL Objects, Database, tables, Stored Procedures, Functions, Views, Triggers, Cursors, User Defined Functions, CTE’s

Functional experience in Azure Data Factory, Azure Blob Storage, Azure SSIS Integration Runtime, SSAS cubes, Dimensions and measures design

Skilled in creating and configuring SQL Jobs, Maintenance plans, Database Backup/Recovery, Notification Alerts, SQL Mail Agent, and Scheduling SSIS Packages

Experienced in large project contract understanding, engagement scope and managing the engagements in line with the contractual obligations, development and deployment of overall strategy

Team-based management style coupled with the zeal to motivate peak individual performances along with exceptional leadership & training skills

Organisational Experience

Since Jun’20 OSN, Dubai, UAE as Business Intelligence Consultant \ Data Engineer

Projects Undertaken:

Client: OSN, Dubai, UAE Project Title: OSN Business Intelligence Domain: Media and Broadcasting

Key Result Areas:

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.

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

Apr’15 – May’20 VeriPark Software Solutions, Dubai, UAE as BI Lead

Projects Undertaken:

Client: First Bank of Nigeria (FBN), Nigeria Domain: Banking and Finance

Roles & Responsibilities:

Implemented the Data Migration of core banking data from source system to CRM using SSIS. Developed reports for Sales and Case Management modules. Implemented various Power BI dashboards, analytics reports to visualize sales performance, case performance and other key metrics that are used by the management and employees across multiple departments

Client: Barclaycard, London

Roles & Responsibilities:

Developed ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS and Power BI. Managed and developed existing and new ETL strategy to populate the data from various source systems using SSIS. Refreshed staging tables with ETL. Scaled SSIS to make it work more reliable.

Key Result Areas:

Worked as the Technical Lead for the management of a team of 10 members for SQL BI and database objects like SSIS packages, SSRS Reports, Power BI, Tables, Store procedures, Functions, Views and Indexes using T-SQL for Microsoft Dynamics CRM Project

Spearheaded the business intelligence vertical & providing assistance to the IT team in the implementation of suitable BI tools & Information system for the company

Architected designed & developed BI solutions while maintaining scalability, performance & availability and implementing global IT vision, IT strategy, policies, initializing IT investment & optimizing current resource

Develop and deploy dashboards, visualizations and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the Power BI reporting platform, web portal, mobile, tablet devices, widgets and email

Efficiently developed advanced calculations on MS Power BI Desktop. Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI

Developed:

oAnalysis reports and visualization using DAX functions like table function, aggregation function and iteration functions using Power BI.

oSSIS packages to migrate data from heterogeneous data sources by leveraging transformations like Lookup, Derived Column, Conditional Split, Aggregate, Sort, Data Conversion, Merge, Merge Join, Multicast, Loop Containers, Union All

oCustomized reports and dashboards for Microsoft Dynamics CRM using SSRS and Power BI

oTechnical roadmaps and leading proof of concept (POC) on the SQL Database and BI tools; concluding the project with the delivery of POC findings and recommendations to upper management and stakeholders

oStrategy recommendations, detailed project plans, and conducting weekly project progress meetings

Reviewed ETL mapping / workflows and engaging in design discussions for all Business Intelligence and database initiatives

Developed and Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS and Power BI

Administered Azure Blob storage, Data Factory V2 on Azure Portal, Configuration of SSIS Integration Runtime and SSIS Packages Deployment on Azure

Formulated new reports within the agreed time frame and performing modification of existing SSRS Reports & committing code changes in reports in TFS via Visual Studio

Optimized SQL queries and stored procedures increasing application effectiveness without increasing memory requirement; automating tasks using Windows Task Scheduler and SQL Server agent jobs

Monitored daily error logs for the failed SQL Agent Job and resolve the issue and scheduling standard and data driven subscription

Created numerous queries involving multi-table joins, unions, correlated sub-queries, CTE’s, recursive CTE’s, views, stored procedures, functions, cursors, for diverse business requirements

Developed high quality technical design documents in accordance with established company standards and development guidelines

Reviewed and analysed the effectiveness and efficiency of existing systems and developing strategies for improving or further leveraging these systems

Feb’14 – Nov’14 Matrix Solutions, Kuwait as SSIS Consultant

Key Result Areas: Domain: Banking and Finance

Acted as the 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

Conducted 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

Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture.

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

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

Previous Work Experience

Aug’10 – Jan’14 Ramco Systems Ltd., Chennai as SQL Server Developer

Key Result Areas: Domain: ERP

Acted as the Application Developer and was involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application

Designed the Application Database by Creating Tables, writing SQL queries, Stored Procedures, Functions, Indexes, Triggers, Constraints, Cursors, Error handling

Improved the performance of database by fine-tuning the Stored Procedures, SQL Queries and User Defined Functions

Used SQL Tools like SQL Profiler, Database Engine Tuning Advisor, DMV Queries and Execution plans for performing Performance tuning and Query Optimization

Implemented and delivered of MSBI platform solutions to develop and deploy ETL, reporting on SQL Server 2008 using SSIS, SSRS

Diagnosed application support issues, debugging, defect fixing, testing and providing solutions, which are adhering to the SLA’s of customers

Academic Details

2008: Bachelor of Technology in Information Technology from Anna University

Personal Details

Date of Birth: 3rd January 1987

Languages Known: English and Tamil

Marital Status: Married

No. of Dependents: 2

Nationality: Indian

Passport No.: Z4686329

Visa Status: Employment Visa in UAE

Driving License: Indian DL

Permanent Address: Chennai – 600100, Tamil Nadu, India

Address: Al Barsha 1, Dubai, UAE

Contact this candidate