SUMMARY

• 9 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, Power view, 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

Operating System: Windows family.

Technologies: Confidential Business Intelligence Tools (MSBI)

Databases: SQL Server (2008R2/2012).

ETL Tools: SQL Server Integration Services.

Reporting Tools: SQL Server Reporting Services, Tableau, Power Bi

Cloud: AWS

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Developing of dashboards on Power BI.
• On boarding of new data sets into data warehouse
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Documenting the new changes and implementing them in new different environments like PROD, SIT, UAT.
• Working with different data sources and accumulating the data for the creation of dashboards.
• 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 POWER BI Desktop.
• Managing full AWS Lifecycle, Provisioning, Automation and Security.
• Migrating existing on-premise application to AWS.
• Setting up and administering multi-tier computer system environments.
• Configure and fine-tune cloud infrastructure systems.
• Performing software upgrades. Kernel patching, errata patches.
• Develop scripts for automating Cloud/server functions.
• Establish metrics, monitor carefully the utilization of AWS resources by using sophisticated Amazon CloudWatch.
• Perform on-premise resources backup by making use of AWS Services.
• Deploy automation infrastructure by using the AWS Cloud Formation techniques.
• Optimize resources and work on resource tagging to share the cost and plan for budgeting and reporting.

Environnent: SSIS, SQL, POWER BI, AWS.

Confidential

Power BI Developer

Responsibilities:

• Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
• Trouble Shooting ETL workflow and working on the databases that bug has been raised.
• Developing of dashboards on Power BI.
• On boarding of new data sets into data warehouse
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Documenting the new changes and implementing them in new different environments like PROD, SIT, UAT.
• Working with different data sources and accumulating the data for the creation of dashboards.
• 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.

Environnent: SSIS, SQL, POWER BI.

Confidential

Power BI Developer

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.

Environnent: Power Bi, SQL Server, API.

Confidential

Power BI Developer/ Tableau Developer

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.

Environnent: SSIS, TABLEAU, Power Bi, SQL Server.

Confidential

Power BI Developer

Responsibilities:

• Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
• Solution design and implementation
• Working on Data Analytics
• Creation, 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.

Environnent: SSIS, Power BI, SQL Server.

Tableau Developer

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.

Environment: Tableau, SQL Server.

Confidential

Power BI Developer

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) wherever it requires.

Environment: Power BI, Tableau, SQL Server.

BI Developer

Confidential

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.

Environment: SQL, SSIS, SSRS.

Confidential

BI Developer

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.

Environment: SQL, SSIS, SSRS.