Name : Imran S

Email : adwp2b@r.postjobfree.com

M-Number : 469-***-****

SUMMARY

Almost 6 years of experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau and Power BI.

Experience in working with Tableau Desktop, Tableau Server, Alteryx and Tableau Reader in various versions of Tableau 2021.3.8,2019.4/10x/9x/8x/7x.

Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.

Created various types of charts like Heat Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop, Power BI and Excel to provide better data visualization.

Worked as a Senior Data Analyst having good experience on T - SQL, SQL Server, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), QlikView, HTML5, CSS3 and XML.

Profound understanding of Enterprise Data Warehouse including OLTP/OLAP, Dimension/Fact tables, Top-down/Bottom-up models, Star/Snowflake schemas.

Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.

Experienced business analyst specializing in requirements analysis and SDLC documentation, Waterfall, UP, Agile and Scrum methodologies. Business Process Re-engineering (BPR) experience in full life cycle.

Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon Redshift services.

Extensive Tableau Experience in Enterprise Environment and Tableau Admin and Architect.

Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Reviewed SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

MS Office Suite Skills, especially SharePoint, PowerPoint and Excel (including pivot tables, charts etc).

Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.

Utilized Informatica Power Center to accomplish full phases of data flow from source data (Oracle, SQL Server, flat files) being analyzed before extracted to transformation.

Hands on Experience in Writing Python Scripts for Data Extract and Data Transfer.

SKILLS

TECHNICAL SKILLS:

BI Tools: Tableau 9x, 10x (Desktop, Server, Public), Business Intelligence Development Studio (SSRS), SSIS, Alteryx, AWS Redshift, Qlik sense, Power BI, Crystal Report, Cognos.

ETL tool: Informatica Power Center 7/8, SQL Server Integration Services (SSIS), OLAP (Cubes).

Databases: Teradata, SQL Server, MySQL, Hadoop/HBase, Hive, MS Access, Oracle 12c, Snowflake, Vertica, DB2.

Applications: Microsoft Office, MS Visio, Visible Analyst, Share point.

Languages: SQL, T-SQL, PL/SQL, C, JavaScript, Python, R (BIGDATA).

Web Scripting: XML, HTML, XHTML, Visual Studio 2003/2005

Web Tools: MS-Front Page, Dream Weaver.

PROFESSIONAL EXPERIENCE

NAL EXPERIENCE

American Express, Pheonix,AZ Mar 2021 – Present

Data Analyst / Tableau Developer

Responsibilities:

Worked on Tableau dashboards to provide visualizations for internal management and Power BI for external stakeholders.

Extensively used SSMS TO create, modify database objects such as tables, views and stored procedures.

Used Alteryx for data and analytics.

Resolved long running SQL queries in tuning SQL for better performance.

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

Created and maintained SQL database object such as tables, views, indexes and store procedures with SQL Server Management Studio (SSMS).

Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Designed, developed and tested various power BI and tableau visualizations for dashboards by connecting from different databases.

Generated database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints.

Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.

Wrote complex SQL queries, modified stored procedures, and used indexed views to efficiently retrieve data from the database

ENVIRONMENT: Tableau Desktop 2021.3.8, power BI, T-SQL, Tableau Server, SQL Server Management Studio 18.11(SSMS), SSIS, Alteryx 2021.4, AWS redshift, Oracle SQL Developer 21.4.2, Jira, Microsoft Office Suite (Word, Excel, PowerPoint).

Kaiser Permanente, San Diego, CA Jul 2020-Mar 2021

BI Developer

Responsibilities:

Involved in the development of data Sourcing, system Interfaces, ETL, stored procedures and data visualization.

Coordinated with project team members to ensure technical design strategies outlined in solution architecture.

Worked on high level architecture included with ETL phases involved with data blending, data cleansing, validation and enrichment.

Extensively used Alteryx for ETL functionality connected with different databases.

Extensively used data blending, embed functionalities in Tableau.

Used and created various visualizations in reports like scatter plot, bar graphs, grant charts, heat maps, geo maps allowing end users to utilize full functionality of dashboard.

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

Created Informatica Power Center mappings to execute necessary data transformation tasks to be loaded to database table for later possibility analysis use.

Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Used T-SQL in SQL Server Management Studio (SSMS) to develop Stored Procedures, User-Defined Functions and views.

Retrieved data from different data sources like oracle, sql server, excel samples and moved to Alteryx for ETL functionality.

ENVIRONMENT: Tableau Desktop 2020.4,T-SQL, Tableau Server, SQL Server Management Studio 18.8(SSMS),SSIS, Alteryx 2020.4, Snowflake, Oracle SQL Developer 20.2.0, Jira, Microsoft Office Suite (Word, Excel, PowerPoint).

Capital Group, Irvine, CA Nov 2018 – Jul 2020

Tableau Developer / Data Analyst

Participated in Regulation of financial Project and requirements gathering and translate business requirements into report visualization specifications design documents.

Tableau Server architecture and configuration and experience with Tableau customizations responsible for gathering requirements and creating functional specifications.

Creating users, groups, projects, Data connections, settings as a tableau administrator

Using Tableau Prep for Data preparation and combine them into single source of data using joins and unions.

As a Tableau Developer designed, developed, prototyping the various dashboards using tableau desktop 2019.3 version. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering ranking, Top-N Analysis, hierarchies).

Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.

Developed Scripts to load data into Hive and work with multiple data connections including Hadoop/Hive and by data blending.

Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

Creating SQL agent jobs after successful development of ETL packages and SQL codes.

Used Python Scripts for Data Extract and Data Transfer.

ENVIRONMENT: Tableau Desktop 2019.4, 10x, Tableau Server, SQL Server 2008/2008 R2, Python, Tableau Prep, SharePoint, MS Visio, Hive, spark, Agile, Jira, Microsoft Office Suite (Word, Excel, PowerPoint).

EFI, Fremont, CA Nov 2017 – Oct 2018

Data Analyst / Tableau Developer

Conducted Data Analytics in consumer finance business and partnered with cross functional teams to support management and decision making.

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

Blended data by using Alteryx.

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Used Agile/Scrum methodology for software development.

ENVIRONMENT: Tableau 9.x, Business Object 5x,Alteryx, MS SQL Server, SSIS, SSRS, Query Analyzer, SQL Profiler, Amazon Redshift.

Kohls, Milpitas, CA Apr 2016 – Jul 2017

BI Analyst/Data Analyst

Involved in developing Functional Design document based on client requirements.

Connected BW data by using Tableau server.

Involved in developing dashboards using Tableau.

Make use of data modeling techniques in designing the data marts project.

Involved in creating database objects such as tables, views, procedures, triggers, functions using PL/SQL to provide definition, structure and to maintain data efficiently.

Created Source to Target mapping documents detailing Source rules, Target rules, Transformations required, Error handling etc., and worked with the team of ETL developers to implement the same.

Designed database tables to feed Promotions, Campaigns, Customer, Sales data for effective targeting and direct marketing campaigns.

Performed incremental extracts for OLAP database.

Developed Tableau dashboards with combination charts for clear understanding.

Environment: Tableau, SQL, PostgreSQL, Oracle, MS Access, Microsoft office Suite (Office, Excel, PowerPoint)

EDUCATION:

Bachelor’s in computer science from JNTU - 2014, India.

Master’s in computer science from UCM- 2016, Missouri.

Contact this candidate