Name: A S M Fakhruddin

Contact: +1-917-***-****

Gmail: ad43r0@r.postjobfree.com

LinkedIn: http://www.linkedin.com/in/a-fakhruddin17

Location: Sayreville, New Jersey

A Professional team player with Ms in Business Analytics and bachelor’s degree in Accounting and Financial. Able to communicate with all level of people face to face or over the phone. Flexible and can do approach to work and aim to go always extra mile for an organization. Technical proficiencies include Microsoft Office (Excel, Word, Access, PowerPoint, Publisher, and Outlook), Adobe Photoshop, Print Shop, IBM Notes, ETL package transfers, SAP, SAS, Alteryx, Tableau (Desktop and server), Python, Minitab, Monument Xpress (health care), Cactus (Credentialing) QuickBooks, TAHP master,Reuters and HRP.

Around 8 years of experience in Business Requirement Analysis, Application, Designing, Development, Implementations, and Testing of Database business systems and Business reports.

Extensive experience in Tableau Desktop, Power BI and TSQL.

Worked on several interactive, real-time reports using drilldowns and customizations with multiple data sets.

Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Acts as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).

Worked on creating multiple level Cascading Prompts for both static and dynamic parameters.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

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

Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.

Designed a Tableau Site in Tableau Server for business purposes and then managed projects, content, and gave permissions according to business usage of the project.

Migrated Tableau Server from On-premise to a virtual machine (VM) in the AWS cloud.

Consulting on Snowflake Data Platform Solution Architecture, Design, Development and deployment focused to bring the data driven culture across the enterprises

Manipulated the data from sources using tools like summarize, join, union, filter, formula, etc. in Alteryx (ETL) to create an extract.

Used Snowflake functions to perform semi structured data parsing entirely with SQL statements.

Comprehensive knowledge and experience in process improvement, normalization/denormalization, data extraction, data cleansing, data manipulation.

Expertized in creating specifications documents from source to Target systems.

Operating Systems

Windows(NT,2000/03/XP/Vista/7), Mac(10.4/10.5/10.6), Linux (Red Hat), UNIX (Solaris, AIXv5.2, SunOS 5.10,)

Databases

Oracle 11g/10g/9i/8i, Siebel, MS SQL Server 2005/2008/2008 R2, DB2, MYSQL, Greenplum, Redshift, Netezza, Teradata.

Skills

Tableau Desktop 2020/2019/18/10.0/9.3/8.0, Tableau Server 2019/10.0/9.3/9.2, Alteryx Designer 2018.x, MS SQL Server, DB2, Teradata. AWS Cloud, Power BI, Snowflake.

Tools/Methodologies

Visual Studio, MS Project, SQL Profiler, Tortoise SVN, Agile.

Data Visualization Tools

Tableau, Business Objects, SQL Server Reporting Services (SSRS)

Development skills

SQL, SSIS/SSRS, Tableau

Bachelor in Business Studies, National University

Masters in Business Analytics, Southern New Hampshire University

Responsibilities:

Working with a team of Architects, Developer Consultants - to design, build and enhance Software solutions.

Working on Software Development Life Cycle (SDLC) that include duties like providing documentation on

,design, testing and migration from development to production.

Working on designing, developing and responsible for implementation in Snowflake.

Experienced in coding Finance project for auditing purposes using Snowflake.

Querying, managing data and create data programmability objects with Transact-SQL and implement error handling and transactions for the source databases.

Implement error handling with Transact-SQL, implement transaction control in conjunction with error handling in stored procedures.

Responsible for writing reports to support the launch and monitoring of strategic initiatives. This includes:

develop and maintain timely and accurate reports utilizing facilities Madhok, CCMS, Excel, Access, Tableau, Alteryx, SAS and SQL, and other report writing tools available.

Design Power BI reports using MS SQL server and in supporting services MDX technology of the analysis services.

Utilize Power BI to create various analytical dashboards that depicts critical KPIs, with slicers and dicers enabling end-user to make filters.

Assists with the development of the data model(s) for the data warehouse. Provides recommendations for all data strategies and out of scope processes.

Act as the liaison between Business Stakeholders, Developers, Infrastructure teams and project management groups

Develops business intelligence (BI) processes, data, interfaces, and interactivity to provide key performance indicators, dashboards, analytics, and decision support software. Analyzes user needs and reviews system specifications for circumstances requiring routine skill.

Provide continued maintenance and development of bug fixes for the existing and new Power BI reports and develop custom calculated measures using DAX in Power BI to satisfy business needs.

Need work with Business Analysts and Data analysts and define Mapping documents and design processes for various sources and targets.

Reviewing the story cards with the Requirements Analyst, estimating the stories, following the Scrum methodologies.

Worked on project documentation which included the Functional, Technical and ETL Specification documents.

Environment: Tableau (Desktop/Server) 10.0/9.3/8.2, Microsoft SQL, Server Reporting Services (SSRS), Oracle SQL Developer, Visual Studio.

Responsibilities:

Experienced in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.

Creating Reports in Tableau based on Snowflake Connections.

Linear process approach to Prototypes Analyze, Design, Develop and Visualize and maintenance of source data in Enterprise data warehouse through business knowledge.

Created test project and POC on application that includes strategy, scenarios, cases, data, metrics and documented the knowledge gathered from test process on the applications.

Querying, managing data and create data programmability objects with Transact-SQL and implement error handling and transactions for the source databases.

Developing and reviewing SQL queries with use of join clauses (left/right/full outer join) and construct multiple JOIN operators using AND, OR in Custom SQL.

Implement error handling with Transact-SQL, implement transaction control in conjunction with error handling in stored procedures.

Construction of Data Definition Language (DDL) and Data Manipulation Language (DML) statements on supplied tables and data.

Analyze and optimize on business process by working on user areas and identify problem in existing software and create a clear headway for smooth operations.

Interacted with Business Analysts and Data Modelers and defined Mapping documents and design processes for various sources and targets.

Configuring security for dashboards in reports by creating a groups and publish the reports to web page and tableau server.

Experienced in designing technology roadmap for Tableau, product installation and implementation development of insightful dashboards, serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.

Blended data from multiple database connections into Tableau report by selecting primary keys from each database for data validation.

Connected Tableau to different data sources like MySQL, Oracle, Teradata, Snowflake and PostgreSQL.

Demonstration of the Tableau dashboards and its functionality to the business users for the self-service business intelligence.

Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Developed donut charts in Tableau and implemented complex features in charts like creating bar charts in tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Experienced in creating Tableau dashboards using advance tableau functions like calculated fields, LOD (Level of Detail), Adhoc calculations, and table calculations etc.

Expert in Tableau analytics like reference lines, trend lines, forecasting and Drag & Drop analytics.

Accessing on premises data by connecting to a data server using data gateway and measuring performance using recorder and KPI.

Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 2018.3 to Tableau 2019.4 and then to 2020.3.

Worked on performance activities like maintenance activities like Logs Cleanup and Archiving Log files in prescribed intervals, which helped business members.

Environment: Tableau 10.x/9.x/8.x (Desktop/ Server), Teradata SQL Assistant, Oracle SQL Developer, MS SQL Server, Oracle, Windows, Visual Studio.

Responsibilities:

Working with business users and business analyst to understand the business requirements.

Worked in migrating the existing dashboards, backups and active directory of Tableau server.

Created user filters depending on business (LOB) requirement for each county within the region for Inpatient and Outpatient data.

Perform maintenance activities like Logs Cleanup and Archiving Log files in prescribed intervals, used for Business continuity during a Disaster.

Acts as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).

Using Tableau Desktop published the developed dashboards to the Tableau server and managed user security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access.

Worked along with the business team on Tableau Server Administrative functions, upgrade, configuring, License management, Backup of Servers and Load Balancing techniques.

Experienced in Server Worker Nodes Installation & Configuration and Setting up Tableau Primary and Worker Nodes (drivers, patches, command line utilities, etc.)

Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Worked on Designing Tableau Server dashboards using "workgroup" PostgreSQL database of the Tableau Server repository.

Working on several interactive, real-time dashboards using drilldowns and customizations with multiple data sources.

Writing SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.

Working in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers etc.

Converting client requirements into physical and logical data models as part of Data Analysis initiatives.

Environment: Tableau(desktop/server) 8.2/8.1/7.0, Microsoft SQL Server, Oracle SQL developer, Microsoft Excel 2010, SSRS, SSIS, Visual Studio.

Data analyst/ Tableau / BI Developer Professional

Professional Summary:

Technical Skills:

Education:

Work Experience:

Tufts Associated Health Plans Inc (Healthcare), Boston, MA

HealthCare Data Analyst Jan 2022 to Till Date

Thyrocare Bangladesh Ltd (Healthcare), Dhaka, Bangladesh

BI / Data Analyst Jan 2016 to Nov 2021

Dataquest Tech Ltd (IT Industry), Dhaka, Bangladesh

Tableau Developer Apr 2014 to Dec 2015

Contact this candidate