SUMMARY

• Over 16 years of dynamic career reflecting pioneering experience in gathering Business Requirements, assessing & developing Business Intelligence Program strategies, designing and implementing Business Intelligence Information & analytical solutions using MSBI(SSIS/SSRS/SSAS), Power BI and SQL Server
• Good Experience in dashboard designing using Power BI with large data volumes from various data sources (SQL Server/Teradata)
• Strong hands on experience implementing data visualization and analytics using Power BI DAX
• Experience in Power BI administration and access provisioning
• Experienced in Extraction Transformation Loading, from different data sources by using multiple transformations provided by SSIS. Such as Data Conversion, Conditional Split, Lookup, Derived Column, Sort, Merge and Union all.
• Proficient in creating various types of reports like complex drill - down, drill-through reports, matrix reports, sub-reports and charts using SQL Server Reporting Services (SSRS) based on relational and OLAP databases.
• Experience in working with SSAS in creating cubes, setting up roper hierarchies for better cube performance and deploying of analysis services
• Experience in building Multidimensional/Tabular SSAS Cubes and Dimensions with different architectures and data sources for Business Intelligence and writing MDX/DAX queries.
• Experience in MS SQL Server Migration/Upgrade from SQL Server 2008 to SQL Server 2014.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, User defined functions, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Experience in creating database, tables, SQL joins, indexes, user-defined functions (UDFs), views, stored procedures and triggers using T-SQL.
• Experience with query optimization & performance tuning using tools such as SQL Profiler, Performance Monitor, and Database Console Command (DBCC) and Trace Flags to solve performance issues like dead locks and long running queries.
• Strong knowledge of Data Warehousing methodologies including Multidimensional, Tabular, Star and Snowflake schema concepts
• Strong knowledge in SQL Server 2008/2012/2014/2016
• Ability to work in groups as well as independently with minimal supervision.
• Excellent verbal and written communication and interpersonal skills.

TECHNICAL SKILLS

Data Warehousing: SSIS, SSRS, SSAS, OLAP, OLTP, Physical & Logical Data Modelling, Power BIDatabases: SQL Server 2008/2012/2014/2016 , Oracle, Teradata

Operating Systems: Windows 2000 Professional Server, UNIX

Software Engineering Methodologies/Tools/Technologies: Mercury Quality Center, Software Testing, software design, Rational Rose UML, Structured Modelling, Waterfall model, Agile methodology, scrum, Remedy, Service now, Control-m, Autosys, Visual Studio, TFS, SVN, JIRA, Visio

Development/Productivity Tools: SQL*Plus, Visual Source Safe

SQL Server Data tools: ALM, Jira, Visual Basic 6.0/Visual Studio 2008/Visual Studio 2010/2015/2017

Languages: VB.NET, C#, Java Script, TypeScript, VB Script

PROFESSIONAL EXPERIENCE

Confidential

Analytic Consultant

Responsibilities:

• Creating new/modifying SSIS packages to flow into the reporting system
• Designing SQL Server data base performance tuning on the existing reports in Power BI/SSRS
• Implemented data transformations using SSIS from in order to load external data to the existing organizational format
• Modified/Created new stored procedures and user defined functions based on the customer request for the reports in SSRS/Power BI
• Designed Power BI reports to in corporate the existing SSRS reports for the weekly reports

Technology/Tools: SQL Server 2016/2019, SSRS, SSIS, Power BI, TFS

Confidential

Analytic Consultant

Responsibilities:

• Creating new/modifying existing SSRS/Power BI reports based on daily/weekly/monthly and quarterly basis
• Designing SQL Server data base by adding/modifying tables, views and performance tuning on the existing stored procedures
• Implemented row level security for Power BI reports based on the hierarchical structure using DAX
• Worked on the data performance tuning for existing SSRS reports
• Implemented data transformations using SSIS from in order to load external data to the existing organizational format
• Modified/Created new stored procedures and user defined functions based on the customer request for the reports in SSRS
• Develop data models for OLAP systems for the CIB
• Created various types of reports such as drill down reports, drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using Report Designer/Report Builder based on the requirements and uploaded on Report Server

Technology/Tools: SQL Server 2019, SSRS, SSIS, SSAS, Power BI, TFS

Confidential

Business Intelligence Developer

Responsibilities:

• Creating new/modifying existing SSRS/Power BI reports based on FSG customer/end users
• Create/modify stored procedures/user defined functions for fetching the data to SSRS/Power BI reports as per FSG standards
• Performed data profiling and cleansing using SQL Server and SSIS
• Maintaining and supporting the existing SSIS applications
• Generated SQL queries for the ad hoc report request from the business team
• Modifying the existing SSAS cubes based on the business requirements
• Implemented Partitioning and aggregation in the existing SSAS cubes for better performance of end user reporting

Technology/Tools: SQL Server 2012/2014/2016, SSRS, SSIS, SSAS, Power BI, TFS, Oracle/PL SQL