SUMMARY:

• Having 7.8 years of Professional experience in the IT industry, Involved in working on Tableau and in MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS).
• Working in Agile methodologies and conducting standup meetings and collate deliverables.
• Experience in Business Intelligence, Banking, Sales & Marketing Strong knowledge of SSIS/SSRS
• Worked with Power Bi.
• Extensive knowledge of Power Bi installation, maintenance of Power Bi Servers on distributed environments.
• Worked with Various data models and visualizations using Power Query, PowerPivot, Powerview, Power maps.
• Implementing different query parameters and working with different data sources in Power Bi.
• Creating calculated columns using M - Query and implements a few using simple DAX Queries.
• Extensive knowledge of Tableau installation, maintenance of Tableau Servers on distributed environments.
• Worked on different phases of data visualization development lifecycle, from gathering requirements to testing and implementation
• Creating Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Created Bar Charts, waterfall charts, Heat Maps, And Geographical Maps.
• Strong knowledge of software development life cycle (SDLC).
• Strong Experience OLAP and Reporting like Tableau.
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
• Created Derived Columns to fulfill the User Requirements.
• Created Parameters to reports be more User-friendly to End Users.
• Created Dynamic, Static Dashboards with Global Filters, Context Filters, Action Links.
• Added Baselines, Trend Lines, Quick &Table Calculations, and Annotations.
• Connecting multiple data sources with the Data Blending technique.
• Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.
• Involved in design phase of BI projects.
• Strong business and application analysis skills with excellent communication and professional skills.
• Experience in analysis of source systems, defining underlying data sources and transformation requirements, design suitable data model
• Experience in interacting and requirement gathering from IT division on client side.
• Experience in conducting knowledge sharing sessions within company environment.
• Involved in design phase of BI projects.
• Working on the Enhancements of Tableau dashboards as per the change Request
• Creating users adding users to the tableau dashboards and maintaining them
• Ability to adapt to fast changing skills and work

TECHNICAL SKILLS:

Technologies: Microsoft Business Intelligence Tools (MSBI), Tableau,PowerBi.

Operating System: Windows family.

Databases: SQL Server (2008R2/2012).

ETL Tools: SQL Server Integration Services.

Reporting Tools: SQL Server ReportingServices, Tableau,PlowerBi

PROJECT EXPERIENCE:

Confidential

Environment: Power Bi, SQL Server,Api

Responsibilities:

• Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
• Power BI development and administration.
• On boarding of new data sets into data warehouse
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Preparing the design methodology and project documentation.
• Developing, publishing and scheduling Power BI reports as per the business requirements.
• To understand the business requirements and develop the reports accordingly .
• Involved in designing and analyzing the requirement analysis.
• Developing reports with report builder.

Confidential

Environment: SSIS,TABLEAU, Power Bi, SQL Server

Responsibilities:

• Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
• Working on Data Analytics
• Creating the Dashboards in Tableau for the data representation in the form of dashboards for stake holders.
• Scheduling the data refresh in the Tableau server once the data source systems are populated with the data.
• Working on the Enhancements of Tableau dashboards as per the change Request
• Creating users adding users to the tableau dashboards and maintaining them
• Creating & Testing of Tableau Reports and Schedules.
• Working on and creating ETL packages to load the data
• Designing and implementing of ETL Transformations with SSIS.
• Review test scenarios for UT, SIT,UAT and Production and Support team on defect analysis and resolution .
• Integration and Analysis of data.
• Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transform and finally load into the Target Tables.
• The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.
• Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages

Confidential

Environment: SSIS, Power Bi SQL Server

Responsibilities:

• Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
• Solution design and implementation
• Working on Data Analytics
• Creation of ETL jobs
• Testing of ETL jobs
• Working on and creating ETL packages to load the data
• Designing and implementing of ETL Transformations with SSIS.
• Review test scenarios for UT, SIT,UAT and Production and Support team on defect analysis and resolution .
• Integration and Analysis of data.
• Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transform and finally load into the Target Tables.
• The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.
• Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages.

Confidential

Environment: Tableau, SQL Server

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Integration and Analysis of data.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

Confidential

Environment: Po wer BI,Tableau,SQL Server

Responsibilities:

• Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Analyzing user requirements, validate available data and propose usable designs
• Experience in end to end development of a new set of reports, dashboards & KPI Scorecards.
• Mainly design and develop Tableau dashboards from scratch to support.
• Expertise with creating solution driven views and dashboards by developing different chart types including Line Charts, Bar Charts, Pie Charts, Scatter Plots, Histograms, Tree Maps, Heat Maps, Area Charts, Gantt Charts, and Bullet Graphs.
• Implemented Tableau features such as parameters, table calculations, sets, groups, user filters.
• Experience in connecting and extracting data from different data sources.
• Data blending to create views combining data from multiple data sources.
• Highlighted the views by Annotations (Point, Mark and Area) where ever it requires.
• Understanding and implementing best practices of data visualization. Publishing sheets and dashboards on server.

Confidential

Environment: SSIS, SSRS, Flat files, SQL Server

Responsibilities:

• Deployment and Job Scheduling of SSIS Packages based on Business Requirement using SQL Server Agent Job.
• Creating Tabular, Parameterized, Drill Through, Drill Down, Matrix and Sub Reports in SSRS.
• Doing Unit Testing and Data Validation to make sure the output data of the report is exactly matching with Data Base Queries.
• Creating Packages at Sql Server Integration service by using various tasks and transformations for fetching data from different sources and moving to different destinations. using various control flow items for each loop, for loop and data Flow transformations conditional split, multicast, derived column, lookup, union all, Merge, Merge join et

Confidential

Environment: SSIS, SSRS, Flat files, SQL Server

Responsibilities:

• Create and Modify SQL scripts to cater the requirements
• Creation and modification of SSRS reports meeting business requirements.
• Support and Resolve production incidents
• Development of ETL packages
• Support for parallel run in Merge file comparisons
• Generating Data files
• Comparing the data files generated with the actual live data