Ssrs Tableau,Power BI

NIROSHA.V

Contact: +1-929-***-****

Email:adl1yg@r.postjobfree.com

Professional Summary:

Overall 4+ years of experience in SQL Server 2005 and 2000 Database Design, Development and Implementation IT /IT-es service.

Experience with SSIS, SSRS Sisense, Tableau &Power BI.

Experience with SSRS, Import/Export and Backup/Restore of store procedures and adhoc reports

Good understanding with Reporting.

Extensive knowledge of Normalization and Relational Database Management Systems.

Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.

Technical Skills:

SQL Server Tools : Export & Import (DTS), SSIS, SSRS

BI Tools : Tableau Software, Sisense

RDBMS : MS SQL Server 2000/2005, 2008

Programming Languages : SQL

Internet Technologies : HTML

Productivity Applications : MS Word, MS Excel, MS Access, MS FrontPage

Reporting Tools : SSRS, Sisense, Tableau, Power BI,

Managing Skills

Ability to develop reports.

Effective Team Leadership

Excellent Organizational & Interpersonal Communication Skills.

Adherence to Quality Standards & Approach in all activities.

Resolving and tackling intra team conflicts.

Adopt changes in organizational dynamics.

Vendor Management

Education Qualification

EDUCATION

Master’s in information technology from UNIVERSITY OF MADRAS, Chennai, May 2015

Bachelor of Computer Science from UNIVERSITY OF MADRAS, Chennai, May 2012

MSBI Tool – Took a FastTrack Course.

GAVS Technologies Private Limited Oct 2019 To Feb 26

Client : JBFC & SCO Family of services

Domain : Healthcare

Roles : BI Tool (Tableau & Power BI)

Responsibilities:

Understand the Requirements and Functionality of the application from specifications.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Utilized Tableau server to publish and share the reports with the business users.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

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.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.

Provided 24/7-production support for Tableau users.

Extensive usage of Tableau Version 10.5 Hyper feature for faster data ingests and analytical query processing on large or complex data sets. Also, Viz in Tooltip, and Power Trendlines.

Proficient in data visualization, Reporting, Analysis, Pie Charts,Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

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

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

WIPRO INFOTECH Sep 2015 to Oct 2016

Client : FIRST DATA CORPORATION

Project Name : Gift Card project

Role : Report Designer

Project Description: This project generates business reports, presenting the various transactions carried out via gift cards. It offers flexible online and scheduled reports which manage the gift card transactions for multiple user groups along with interactive dashboards.

Responsibilities:

Played an Important role in developing reports using SQL Server.

Created Stored Procedures, triggers, views, temp tables for data manipulation & reporting.

Developed SSRS using Visual Studio.

Strong knowledge of SQL including queries, views and stored procedures, SSRS and SSIS.

Create ad-hoc reports upon request.

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services).

Using SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.

Development of different types of reports like Parameterized reports, Drill down reports, Ad- hoc reports, Snapshot reports and Sub reports.

Scheduled jobs for backup and created alerts for Error reporting.

Create packages to suit the business needs and to improve the performance of the reports by defining filters, adding calculations and performing SQL tuning on the model and report level using Oracle database.

Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.

WIPRO INFOTECH Feb 2013 to Sep 2015

Client : SIFY

Project Name : FORUM Support

Role : Regional Coordinator

Project Description: Wipro is involved in Managing and Monitoring the Rollouts for Client.

Handling FMCG application roll out projects over pan India and coordinating with different corporates like GSK, TATA, Perfetti, ITC, Kellogg’s etc.

Responsibilities:

Handling FMCG application roll out projects over pan India and coordinating with

different corporates like GSK, TATA, Perfitte, ITC, Kellogg’s etc.

Review SLA with customer

Manage outbound and inbound calls with customers/partners regarding renewal

quotes, products, pricing, programs, up/cross selling, New Projects etc.

Ensure accurate maintenance of all existing FMCG customers, opportunity and

forecasting data in CRM (Salesforce.com).

Plan and deliver tasks and oversee a process/project within the agreed timescales.

Scheduling project roll-out plans and Planning implementation schedules and

resource allotment

Prepares User requirement documents and participates in pre & post

implementation support.

Develop and maintain effective relationships with Clients, colleagues and

customers.

Regular follow-up with Engineers in submitting their claims.

Approving Engineers claims and process it to the partners for payment.

Coordination with the partners for claims a releasing the advance for engineers.

Follow-up with the Engineers in submitting their Sign off and checklist.

Contact this candidate