SUMMARY

• Seeking a challenging Position in BI to further develop and enhance already significant skill and experience as a Business Intelligence Developer; eager to contribute creativity, talents and hard work to ensure the success of your company. Worked to in multi - tasking environment; worked independently and/or with teams to get the job done.
• Experience in Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL
• Extensive experience in implementing BI solution using SSIS, SSAS, SSRS.
• An in-depth grasp of SQL reporting, analytics and business intelligence
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS)
• Experience in Relational (OLTP) and Dimensional modeling (OLAP) concepts and created OLAP cube and Have experience in DAX query and MDX query
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Knowledge on Dimension Data Loading and Fact Data Identification
• Efficient in designing Dashboards and Map Reports with SSRS & SAP Crystal report and experience POWER BI dash board reports.
• Experience in Tableau desktop, Tableau Server and Tableau reader in various version
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS
• Very good Accounting knowledge on financial accounting, and Management accounting that is Analyze and/or prepare monthly financial information
• Team-oriented with Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

PROFESSIONAL EXPERIENCE

Sr. Tableau Developer/Business analysist

Confidential

Responsibilities:

• Technically competent and resourceful Tableau Developer with overall 7+ years IT experience in analyzing data and creating compelling visualizations to support business decision making.
• Developing, Designing and supporting interactive Dashboard reports.
• Strong experience in design and development of Tableau visualization solutions. Experience in creating reports using various charts, data bar and spark lines.
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Create workflow by Alteryx and use hyper files for Tableau
• Create unified data source for Tableau using by Alteryx
• Document business requirements
• Dashboard / report design
• Collaboration with data group for identifying data/ETL needs
• Report/Dashboard development using Tableau and other reporting tools
• Attending daily stand-ups on jira
• Demo product to stakeholders
• Facilitate User Acceptance testing
• Production support
• Support Tableau analysts embedded in the business

Environment: Oracle, MS Excel, Alteryx 2019.2, SQL Profiler and Visual Studio 2015, Tableau Desktop 2018.2, 2019 .1 and Tableau Server.

Business analysist

Confidential

Responsibilities:

• Conduct stakeholder interviews to determine business problems
• Document business requirements
• Dashboard / report design
• Collaboration with data group for identifying data/ETL needs
• Report/Dashboard development using Tableau and other reporting tools
• Attending daily stand-ups
• Demo product to stakeholders
• Facilitate User Acceptance testing
• Production support
• Support Tableau analysts embedded in the business

Environment: SQL Server 2012, SQL Server Integration services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analytical Service (SSAS) T-SQL, MS Excel, HP Vertica MS SQL Query Analyzer, SQL Profiler and Visual Studio 2015, Tableau Desktop 10.5 and Tableau Server.

Tableau/SQL Server BI Developer

Confidential

Responsibilities:

• Participated in creating reports that deliver data based on stored procedures.
• Involved in developing triggers to audit schema changes at the database level.
• Created sub - reports to present more detailed information about the summary.
• Designed and implemented stored procedures and triggers for automating tasks.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success
• Created SSIS Packages to migrate slowly changing dimensions.
• Data from various sources like flat files, to SQL Server database Using SSIS Package
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012
• Designed and develop Tableau visualization solution
• Scheduling the SSIS packages and Jobs
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices
• Developed Tableau workbooks from multiple data sources using Data Blending and develop Power BI data visualization utilize cross tab, map, scatter plots, pie and destiny charts.
• Published the dashboard reports to Tableau server for navigating the developed dashboards in web and Developed Tableau visualizations and dashboards using Tableau Desktop
• Designed and implemented SSAS solution for analytical reporting and KPI tracking across various dimensionality and Designed and developed of SSAS cubes for analytical reports
• Making a Report as per user requirement using MS Reporting Services
• Worked on improving the performance of the system
• Created permanent tables, temporary tables and table variables.
• Used Query Analyzer to optimize SQL queries
• Conducted data structure and movement evaluation
• Executed data migration in coordination of management and technical service personnel

Environment: SQL Server 2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analytical Service (SSAS) T-SQL, MS Excel, MS SQL Query Analyzer, SQL Profiler and Visual Studio 2010, Tableau Desktop 10.0, 10.5 and 18.1 and Tableau Server.

Tableau/ SQL Server BI Developer

Confidential

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Troubleshooting OLEDB connection issues in SSIS packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into database.
• Involved in re - design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server
• Performed data conversions from flat files into a normalized database structure
• Data migration (import & export) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: SQL Server 2008R2, SSIS 2008R2, SSRS 2008R2, .NET Framework, T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008 and Tableau 8.1.