Maneesha Madagoni

Sr. Power BI Developer/Microsoft SQL Server /MS BI/SSRS/SSIS/TSQL Developer

Email: ad4qow@r.postjobfree.com Contact: 469-***-****

PROFESSIONAL SUMMARY

8+Years of Experience in the IT Industry which includes designing, development and implementation in Power BI Desktop and Power BI Service with SQL SERVER and worked on the Power BI Reports & Dashboards.

Experienced in using standard visualizations like Slicer, Card, Stacked column chart, Clustered column chart, Line and stacked column chart, Line and clustered column chart, and Map etc.

Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.

Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.

Advance data modeling using DAX, power query/edit query in Power BI desktop, and working with custom visuals.

Coordinated and participated in weekly estimation meetings to provide high-level estimates for backlog items.

Experience in configuration and maintain report manager and report server for SSRS deployed and scheduled the reports in report manager.

Power BI Tools – Power BI desktop, Power pivot, Power query, Power view, Power map, Power BI dashboard, calculated columns and calculated measures using DAX, data modeling.

Generated complex Transact SQL(T-SQL) queries, Sub queries, Co-related sub queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs).

Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.

Expertise in creating Workflows based on Functional Specification Document.

Proficient in optimizing SQL queries, performance tuning using SQL Profiler, and understanding execution plans.

Periodic reporting is done daily, weekly, monthly, and quarterly, which helps the client by using the reporting Services (SSRS), POWER BI.

Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI, and Excel to provide better data visualization.

Expert in generating on-demand and scheduled reports for business analysis or management decisions using

SQL Servers Reporting Services (SSRS) and POWER BI.

Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.

Highly proficient in the use of T-SQL for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.

Worked with DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.

Extensive knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.

Reporting Services (SSRS 2008r2/2012/2014/2016)

Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Experience in developing various kinds of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.

Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

Experience in developing Crystal Reports and Knowledge in Tableau reports, Power BI.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.

Integration Services (SSIS)

Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.

Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.

Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.

Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.

Experience in Reporting services, Power BI (Dashboards Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services.

Involved in various data migration projects from Oracle to CRM and data Migration from 2012 to 2016 by using SSIS.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.

Analysis Services (SSAS)

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.

EDUCATION DETAILS:

MASTERS – Northwest Missouri state university

BACHELORS – JNTU-H

TECHNICAL SKILLS

SKILLS

TOOLS

SQL Server Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Data Tools

Databases

MS SQL Server 2012/2008/20x05/2000, Oracle 10g/9i/8i, DB2, Teradata, MS Access, Denodo

Business Intelligence

MSBI, Power BI, Tableau, MS Excel

Cloud

Azure, AWS, Google cloud (GCP)

Programming Languages

C, C#, VB.Net, SQL, T-SQL, Power Shell, Visual Basic, Snowflake, M language

Web Technologies

ASP.NET, ADO.NET

ETL Tools

Data Transformation Services, SQL Server Integration Services (SSIS), Informatica, Denodo

OLAP Tools

SQL Server Analysis Services (SSAS)

Scripting

HTML, DHTML, XML, JavaScript

Reporting Tools

SQL Server Reporting Services (SSRS) 2012/2008, Crystal Reports, Qlik View, Tableau, Power BI, Crystal Reports XI/X/9/8.

Application Packages

MS Outlook, MS Office

Operating Systems

Windows 2003/2008, Windows 7, Windows NT, Windows 2000, XP

Version Control

Team Foundation Server, VSS, SVN

WORK EXPERIENCE

Client: US Bank, Minneapolis, MN Sep’2023 – Present

Role: Sr. Power BI Developer / SQL Developer

Responsibilities:

Involved various stages of project activities such as from dev to production.

Gathering the client requirements effectively, coordinating the team and making sure the outcomes are delivered on time.

As Part of the migration 100 plus SSRS reports moved Power BI workspace.

Converted stored procedures on Snowflake as part of the migration Process.

Solved the issues related to Production Tickets like defects and Change requests.

Created various SSRS, Power BI reports.

Supported daily activities, tracked the project activities on each stage effectively.

Worked extensively building Power BI Dashboards with quick insights into KPIs and Advance analysis actions, Calculations, Parameters, Maps and Scatter plots, Predictive Analysis using Python and R integration.

Developed Packages to load the data using slowly changing dimensions.

Used Trend Lines Statistics and Log Axes, Groups hierarchies, time intelligence to create detailed and summary level reports and Dashboards with KPIs using Power BI.

Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps, Gantt charts using show me functionality.

Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.

Managed a repository of re-usable data visualization templates and views.

Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes that can be presented to customers for feedback.

Conducted Training sessions for Power BI users and created the documents for end user support.

Worked on all activities related to the development, implementation, administration, and support of ETL

Processes.

Scheduling the Dashboards to refresh in Power Bi Desktop.

Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis. Performed capacity planning and growth prediction for client audit data.

Stayed up to date with the latest data visualization trends and best practices and applied this knowledge to continuously improve the effectiveness and impact of data visualizations.

Designed and developed interactive dashboards and reports in Power BI to visualize and communicate business insights to stakeholders.

Used bookmarks feature which enables the ease to jump to respective report tabs with one click.

Imported custom themes and page backgrounds for rich visual effects.

Performed end to end testing on the reports and packages developed to ensure data quality is met.

Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.

Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files. Troubleshooting reports issues, ETL job failures, optimizing query performances.

Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server.

Created many calculated columns and measures using DAX in Power BI based on report requirements.

Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation

Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Created, Maintained & scheduled various reports in Power BI like Tabular Reports.

Explore data in a variety of ways and across multiple visualizations using Power BI.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Designed and built-up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.

Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Used Microsoft Team for communication and Agile Scrum.

Responsible for creating databases, tables, cluster/non-cluster indexes, constraints, views, stored procedures.

Responsible for develop and build the Reports/Dashboards and deploy into SSRS service.

Involved and creating various types of SSRS reports like Tabular, matrix, drill down, drill through, parameter reports, cascading reports, sub reports, chart reports.

Design and Develop data models and date warehouses in Snowflake.

Develop and maintain ETL processes to move data from source systems to Snowflake.

Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, Power BI Gateway, Azure, SharePoint, Microsoft Office, Outlook, Microsoft Teams, Skype for Business, SQL Server 2017, SQL Server Analysis Services (SSAS 2019), DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8, Snowflake, SQL Server Reporting Services.

Client: Advanced Bionics, Los Angeles, CA Mar’2021 - Sep’2023

Role: Sr. Power BI Developer / MS SQL Developer

Responsibilities:

Worked closely with various teams across the company to identify and solve business challenges.

Gathering and Analyzing requirements of clients, understand and convert them into solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation, and implementation.

Import Data from different data sources to create Power BI reports and Dashboards.

Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements.

Transform, define, navigate the data from data source and perform merge and append queries using Power Query.

Performed transformations like Pivoting, Unpivoting and Splitting of Columns using Power Query.

Created different drill down reports using Power BI Desktop.

Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.

Created hierarchies in Power BI Reports using visualizations like Bar Chart, Line Chart.

Worked with both Import and Direct query mode to import data into Power BI for creating reports.

Used Power BI Gateways to keep the dashboards and reports up to date.

Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.

Creating and managing schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements.

Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.

Troubleshooting reports issues, ETL job failures, optimizing query performances.

Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2, Salesforce and Intacct.

Created many calculated columns and measures using DAX in Power BI based on report requirements.

Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.

Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Created, Maintained & scheduled various reports in Power BI like Tabular Reports.

Explore data in a variety of ways and across multiple visualizations using Power BI.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Created measures, calculated columns in Power BI Desktop to show good data analysis techniques.

Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.

Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Service, Power BI Gateway, SAP HANA BW, SAP S4,

SharePoint, Microsoft Office, Visio, Outlook, Snowflake, Microsoft Teams, Skype for Business, MS SQL Server 2016/2012, MS SQL

Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Data Gateway, DAX, T SQL, SQL

Profiler, XMLA, MS Excel, Excess, Windows 10.

Client: OPTUM, Springfield, IL Mar’2020 - Feb’2021

Role: Sr. Power BI Developer /SQL/SSRS/SSIS Developer

Responsibilities:

Working with Power query for intrinsic and Reusable Parameters with Static/ Dynamic dropdown values.

Involved in requirements analysis and data analysis to derive the business logic, validation of data mappings.

As a Power BI developer responsible for the design, development, and production support of interactive data visualizations.

Created Power BI Dashboards using different types of Slicers and different visualizations like Bar Charts, Line Charts, Pie Charts, Clustered Chart etc.

Created stored procedures, SQL Joins and T-SQL Queries to implement business rules and created data sets required for power BI reports. Also used Azure data cubes data to import data to Power BI.

Responsible for building reports in Power BI from Scratch.

Handled data coming from various data sources and destinations like excel, flat files, csv files.

Exposure to MS SQL 2008 and SQL 2012 databases

Hands on experience in writing SSIS packages & exposure to SSRS and SSAS.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.

Possess knowledge of Data Warehousing and Business Intelligence concepts, Dimensional Modeling.

Have expertise on Database designing Tools, Data Modeling skills.

Responsible for maintaining cubes using SSAS and populate cubes with data.

Performance tuning of the SQL Server.

Used ServiceNow for resolving incident tickets and creating change management tickets for production changes.

Worked in developing Tabular model for Dashboard and Generating the power view Reports.

Create Power BI dashboard reports as per the business requirements from the legacy reports.

Monitor and maintain SQL jobs and Power BI reports for data accuracy and worked on performance improvement of the reports.

Used Microsoft Power BI Power Query to extract data from external sources.

Worked on Data visualization and Data analyzation using Power BI.

Developed custom reports and developed them on server using SQL Server Reporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.

Implemented parameters in reports for user input fields as per business requirements.

Created the Dashboards with Tiles and pins from reports, insights and shared it to user groups using Power BI Apps.

Performed various complex calculations and created custom measures using Data Analysis expression (DAX).

Worked with Power BI Report Server for Paginated reports and using Report builder tool.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SVN (source control), MS Visual Studio.NET, C #, TFS, Visual Studio 14.0/VB.net, VB Script, ETL and Windows 2012 Server, ServiceNow.

Client: Northern Trust, Chicago, IL Aug’2019 – Mar’2020

Role: Power BI Developer / SQL Developer

Responsibilities:

Worked in Agile/SCRUM and Software Development Life Cycle (SDLC) environment.

End-to-end development from gathering requirements to deployment of SSRS reports.

Designed and developed data warehouse & data marts using multi-dimensional models - star and snowflake schemas.

Processed data from disparate data repositories and loaded it into those dimensionally modeled Datawarehouse.

Created complex SSIS packages using various transformations and tasks like Sequence Containers Script, for loop and For Each Loop Container, Execute SQL Task, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, Flat file source and destination, OLE DB source and destination, excel source and destination, XML source etc.

Created various Stored Procedures to implement slowly changing dimensions with Merge Statement to validate the data from the source and update/insert the records into target tables.

Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible.

Created calculated fields, Parameters, Filters to develop user-friendly, interactive, and actionable reports and

dashboards.

Requirement Analysis and modelling of data in Power BI for real time dashboards and other reports

Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query, Power View & Power BI.

Continued maintenance and development of bug fixes for the existing and new power Bi reports.

Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps, Gantt charts using show me functionality.

Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor & Power Query Formula Language (M).

Used Trend Lines Statistics and Log Axes, Groups hierarchies, time intelligence to create detailed and summary level reports and Dashboards with KPIs using Power BI.

Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.

Created the Schedule refresh for Datasets in Power BI Pro version.

Debugged SSIS Packages using Data Viewers and Breakpoints. Used various transformations like derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.

Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.

Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages. Preparing Dashboards using calculations, parameters in Tableau.

Performed Provider analysis and gave useful Insights about deposit details from the Power BI dashboards. Created report schedules on Tableau server.

Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed dashboard reports using Reporting Services, Report Model using Report Builder.

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report). Created drill down and drill up in worksheets in tableau.

Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Involved in trouble shooting of performance issues which were associated with Tableau reports.

Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server.

Experienced in working with agile methodology.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Experienced in Data visualization and Data analyzation using Power BI.

Installed On premise data gateway and scheduled daily data refresh in Power BI.

Involved in publishing of various kinds of live interactive data visualizations dashboards and reports according to the business requirements using SQL Server Reporting Service

Strong attention to detail, documenting business and technical requirement based on user interviews.

Establish standards and best practices for dashboards and related technologies for the project.

Environment: Microsoft Windows 2008 Advanced Server, Microsoft SQL Server 2014/2012/2008R2, SSIS, SSRS (SQL Server Reporting Services), OLAP, Oracle SQL Developer.

Client: Capital one, Plano, TX Jul’2018 – Aug’2019

Role: SQL Developer / Power BI Developer

Responsibilities:

Created so many dashboard reports, user parameters, slicers and other visualizations.

Used visualizations like Column Chart, stacked chart, Pie chart, Slicers, Donut Charts, Row Cards, Multi Row card, Line Chart.

Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert.

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

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.

Managed upgradation of DTS packages to SSIS packages.

Used the SSIS Import/Export, migrate the Heterogeneous Databases such as Access database, Oracle and flat files to SQL server 2014.

Worked in developing Tabular model for Dashboard and Generating the power view Reports.

Configured SQL mail agent for sending automatic emails when a SSIS package fails or succeeds.

Developed multi-dimensional objects (cubes, Dimensions) using SSAS.

Expert in creating Star schema cubes using SSAS.

Involved in analyzing, designing, building & testing OLAP cubes with SSAS 2014.

Responsible for maintaining cubes using SSAS and populating cubes with data.

Involved in development of ASP.NET/ C# / SQL Server Web Applications.

Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.

Understanding source systems and customer requirements.

Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.

Worked with Dashboards style of reports using all the Power BI components.

Worked with Pages and Page Visualizations in Power Bi Desktop.

Charts are used in making reports more user-friendly in analysis purposes.

Experience in creating complex SSIS packages using proper control and data flow elements with error handling.

Developed User interactive Reports as business needs.

Sharing the reports with Business users with the help of Content packs.

Created new SQL objects like tables, Views, Functions, stored procedures Server scripts.

Environment: MS SQL Server 2012/2008R2/2008/2005, SSIS2008R2, SSRS 2008R2, SSAS 2008R2, Microsoft Access, Power BI, Windows 2003 Standard Edition, SQL Server Integration Services (SSIS), Windows 2000 Advanced Server, VSS, SQL Diagnostic Manager.

Client: Billion Apps, Hyderabad, Telangana Aug’2016 - Jul’2018

Role: SQL BI Developer

Responsibilities:

Responsible for installation and configuration of SQL server 2005 /2000 database.

Developed Logical and physical data model and mapped the data into database objects.

Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).

Responsible for deploying/scheduling SSIS packages as per schedule.

Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.

Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. Created ETL packages using SSIS to extract data from different data sources reformats the data and load the reformatted data into destination tables.

Developed several stored procedures to handle large amount of data manipulation.

Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL Server Reporting Services (SSRS) 2008/2012

Interacted with the Business Admin and gather the requirements and analyzed them.

Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS).

Purchasing, setting up, and configuring a Tableau Server and MS-SQL 2012 server for Data warehouse purpose.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.

Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Created Database and Database Objects

Contact this candidate