SUMMARY

• Around 12+ years of experience in Analysis, Design, Development and Implementation of Business Intelligence Projects and 8+ years wif Tableau.
• Experience in working wif Tableau Desktop, TableauServer, Tableau Online, and Tableau Reader in various versions ofTableau2020.x, 2019.x, 2018.1.4, 2018.1/10.5/10.4/10.3 /10.2/10.0/9.3/9.1/8.2/8.0.
• Proficient in Tableaudata visualization tool to analyze and obtain insights into large datasets create visually compelling and actionable interactive reports and dashboards.
• Deep experience wif design and development of complexTableauvisualization solutions.
• Mastered teh ability to design and deploy rich graphic visualizations wif Drill Down and Drop - down menu option and Parameterized using Tableau.
• Worked on Netezza database to connect Tableau Desktop
• Responsible for creating SQL datasets for Tableau and Ad-hoc reports.
• Good experience in Data Science tools and techniques like Python, R, SQL, NoSQL, and Tableau wifin teh IT industries.
• Expert in Understanding teh Technical Specification and creating and modifying teh SSIS packages according to teh Business requirements. Experienced working wif Database Architecture for Design and Development of Data models and Data warehouse
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R2/2012
• Worked on Data analysis by using NumPy and SciPy libraries in python to filter unstructured data to structured format.
• Expert on creating multiple kind of reports in Tableau like Tabular Reports.
• Experience in Data Warehouse applications using Informatica, Oracle, Teradata, DB2, MS SQL server on Windows and UNIX platforms.
• Good noledge in development of ETL and programs using various tools like Alteryx, Oracle PL/SQL.
• Exported data as TDE to Tableau server from Alteryx to create ad-hoc reports in Tableau.
• Expertise in creating Power BI Embedded Reports
• Experience in installing Tableau Server on both on-Premise as well as teh Cloud, using Amazon EC2 instances in AWS
• Extensive usage of AWS for connecting to data sources on cloud using Amazon Redshift.
• Worked on several interactive dashboards wif Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing wif support for existing security using several visualization techniques.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification, Identifying data mismatch and import and export of data using ETL tool.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Published Tableau dashboards on Tableau Server, Tableauonlineand embedded them into portal.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Created Operational Dashboards to track information throughout teh course of daily operations, understanding teh status of production, machine utilizations, web traffic, or other critical systems.
• Used Tableau’s flexibility to build a tabbed application wif wide range of options like quick filters, calculated fields, LODs, dynamic interaction, flexible ad-hoc capability in various functional areas like Health & life science, finance.
• Used Tableau’s flexibility to build a tabbed application wif wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
• Performance tuning for teh Tableau Visualizations and Tableau server for more than 250 concurrent users.
• Experience working on Agile Methodologies.
• Good understanding of Enterprise Data Warehouse Power insight data.
• Optimize teh VizQL server processes to handle loading and rendering views for Tableau Server.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex
• Experienced in writing queries, stored procedures and functions using.
• Able to communicate across both technical and business-oriented professionals.
• Excellent interpersonal communication, problem solving, documentation, good understanding of business process management and business analytical skills wif an ability to adapt modern technology quickly and strong team player.

TECHNICAL SKILLS

Visualization Tools: Tableau Desktop 2018.1.4/10. x/9.x/8.x, Tableau Server 10.x/9.x/8.x/7, Tableau Reader, SAP BO, Web Intelligence, Power BI, Crystal Reports, Deski Reports

ETL: Informatica SSIS Center 8.1.1/7.1.2 , DataStage 7.5, ODI

Tools: SQL Assistance, Erwin 4.0, SQL Developer, TOAD, Pl/SQL Developer Tidal Enterprise Edition and MS Visio, MS Excel

Databases: Teradata,Oracle 10g/9i/8i, MS SQL Server 2000/2005 and IBM DB2.

Cloud Services: AWS, S3, Redshift, EC2, GCP

Languages: SQL, Python, HTML

PROFESSIONAL EXPERIENCE

Confidential, NYC NY

Sr. BI Consultant

Responsibilities:

• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Designed several business dashboards using Power BI, Tableau Desktop, Tableau server and hosted them across teh client servers.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment
• Responsible for creating SQL datasets for Power BI and Ad-hoc reports.
• Experienced in creating multiple kind of reports in Power BI like Tabular Reports.
• Writing python script to automate teh data from Teradata to cloud Environment.
• Experience in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling
• Created scripts to createnew tables, views, queriesfor new enhancement in teh application using TOAD.
• Createdindexes on teh tables for faster retrieval of teh data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Worked on Performance tuning of report wif huge queries using concurrent query execution for better performance of report.
• Involved in reviewing business requirements and analysing data sources from Snowflake, Excel/Oracle, SQL Server /AWS for design, development, testing, and production rollover of reporting and analysis projects wifin Tableau Desktop
• Designed and Developed ETL workflows for datasets in Snowflake.
• Configured Check Points, Break points, Event Handlers and Logging to teh SSIS packages.
• Proficient in creating Stored Procedures, Views, Functions and Triggers in T-SQL for designing and Developing SSIS packages.
• Worked on change requests, identifying teh defects and working on resolution, processing on SSIS Packages.
• Experience in Developing and Extending SSAS Cubes, Building teh Dimensions, Deploying, Processing SSAS objects, Cubes wif Snow Flake Schemas and Star Schema using SQL Server Analysis Services (SSAS)
• Dimensions and Calculated Measures, Partitioning and building MDX queries.
• Handled Performance Tuning and Optimization on SSIS and MDX, wif strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Connected to teh AWS Redshift and Snowflake directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Worked on latest Tableau version 2020.4 and 2020.2.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau.
• Writing python script to automate teh data from Teradata to cloud Environment.

Confidential, Herndon, VA

Sr. BI Developer

Responsibilities:

• Designing and developing data warehouse and analytics-based solutions for users using combination of Tableau, Alteryx, and AWS redshift. AWS glue.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Created scripts to createnew tables, views, queriesfor new enhancement in teh application using TOAD.
• Createdindexes on teh tables for faster retrieval of teh data to enhance databaseperformance.
• Designing and developing ETL workflows and datasets inAlteryx
• Developedtriggers in PL/SQLandmaster tablesfor automatic creation of primary keys.
• Converted Cognos and Micro Strategy reports to Tableau following all teh best practices.
• Used combination of Python and R for predictive analytics.
• Large data sets manipulation, data cleaning, quality control, and data management (Python, R, SQL).
• Working noledge of software development methodologies such as waterfall, agile, lean, XP, etc.
• Experience wif Statistical analysis, Stat packages mainly in R/python.
• Large data sets manipulation, data cleaning, quality control, and data management (Python, R, SQL).
• Worked wif various datasets and analysed data using python/R and used different regression models for datasets.
• Worked on creating schemas and connecting tableau to AWS Red shift and Hive.
• Extracted large volumes of data from various data sources and loaded teh data into target data sources by performing various kinds of transformations using SQL Server Integration services (SSIS)
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into teh SQL Server data warehouse using SSIS.
• Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved teh issues associated wif ETL Data Warehouse Failure.
• Used python to extract financial data from various sources and integrated them into one single data set.
• Experienced in web scraping using Beautiful Soup package in Python.
• Connected to Micro Strategy Connector from Tableau Desktop and used teh data to build Dashboards
• Followed SCRUM (Agile) methodology and developed dashboards wif value-added products
• Predictive analytics using Alteryx and mapping geographical data using Alteryx
• Used workflows in Alteryx and published to Alteryx server for frequent data loads dat feed Tableau reports
• Connected to teh AWS Redshift and Snowflake directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Created Users Groups, Projects, Workbooks and assigned Access levels in Server
• Tested dashboards to ensure data was matching as per teh business requirements and if there were any changes in underlying data.
• Developed Tables, Views, Packages and Materialized Views connecting to backend DB whenever they were needed.

Confidential, Mclean, VA

Sr. Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Teradata SQL Server for design, development, testing, and production rollover of reporting and analysis projects wifin Tableau Desktop (2018.3, 2019.2).
• Design, development and deployment ofTableaureports onTableauDesktop 2018.3,2019.2
• Gathered user requirements, analyzed and designed software solution based on teh requirements.
• Experienced in creating Prototypes, Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI).
• Created worksheets by creating join/data blending, custom SQL and data source filters.
• Used techniques like data blending which brings data from multiple data sources into a single view in Tableau.
• Connected to theOracle and Share Point fromTableauto access data warehouse and quickly perform visual analysis.
• Designing and development of Tableauvisualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved as a technical expert providing input to application design regarding production using and administration requirements.
• Import data into Power BI using different ETL methods, SQL Azure, Direct Query, and Restful API. Generator build relational model wifin Power BI generate marketing Campaigns metrics related to landing pages, Email Analysis and visitors.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations based on teh design specifications.
• Troubleshoot and performance tuned complex ETL mappings to reduce teh session run time.
• Improve Reports performance in tableau using extracts and context filters.
• Involve in ETL applications, data feeding, cleansing, archiving and re-modeling.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for teh weekly and monthly dashboard reports on Tableau Server.
• Mastered teh ability to design and deploy rich Graphic visualizations wif Drill Down and Drop-down menu option and Parameters using Tableau.
• Performance monitored and tuned teh Tableau reports.
• Experience in creating Parameterized reports and tabular reports using MS Excel.
• 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.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Creating New Schedule's and checking teh task's daily on teh server.
• Worked extensively wif Advance Analysis Actions, LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Evaluated bug fixes and identified teh changes from 2018.3 to 2019.2 and digested teh customer accordingly.
• Mentored business power users to create reports/dashboards using tableaudesktop.
• Engaged in publishing teh developed reports to productionTableauserver environment.
• Experience in creating Schedules for dashboards to refresh automatically.
• Created report schedules, data connections, projects, groups in Tableau server.

Confidential, Quincy Boston, MA

Data Engineer/ Data Analyst

Responsibilities:

• Involved in reviewing and gathering report requirements and analyzing data sources form Excel/Teradata SQL Server for design, development and analysis projects wifin Tableau Desktop (2018.1.4, 2018.1)
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Worked wif Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed various Mappings wif teh collection of all Sources, Targets, and Transformations using Informatica Designer.
• ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.6.1.
• Created worksheets by creating join/data blending, custom SQL and data source filters.
• Used techniques like data blending which brings data from multiple data sources into a single view in Tableau.
• Used advanced joining and manipulation using Alteryx.
• Used Alteryx to transform unstructured data to structured format and export as TDE format to support ad-hoc reporting for various user needs
• Used designing, building, and testing several complex workflows in Alteryx
• Teh Resource will be responsible to triage requests, gather user requirements and ultimately facilitate ad hoc report / data requests wif a quick turn-around time
• Resource will be responsible for maintaining documentation of database workflows, requirements, policies, and procedures as they relate to Business Intelligence Reporting
• Enabled teh cycle of visual analytics wif Tableau and Alteryx together
• Designing and development of Tableauvisualization solutions and create teh documentations for teh end users.
• Performed dual responsibilities at a time, in one project worked as a team lead and in second project worded as a independent developer.
• Involve in ETL applications, data feeding, cleansing, archiving and re-modeling.
• Worked broadly wif filters, context filer, cascading filter, quick filter Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for teh weekly and monthly dashboard reports on Tableau Server.
• Mastered teh ability to design and deploy rich Graphic visualizations wif Drill Down and Drop-down menu option and Parameters using Tableau.
• Performance monitored and tuned teh Tableau reports by using teh calculations at query level and accomplish teh actions at teh level of performance recordings.
• Experience in using teh “Tab Migrate Utility” promoting teh workbooks and data sources from one environment to another environment.
• 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.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Creating New Schedule's and checking teh task's daily on teh server.
• Worked extensively wif Advance Analysis Actions, LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Experience in creating tickets forsign off of report approval from peer reviewer, QA analyst, business approver, team lead
• Used teh ALM Desktop Client and Mercury to keep teh track of all fixes in reports.
• Plan and implement teh overall analytics and business intelligence strategy

Confidential, Jersey City, NJ

Tableau Data Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects wifin Tableau Desktop (10.5, 10.4/10.3/10.2/10.1/9.3/9.2 ).
• Writing complex SQL queries for checking teh counts and for validating teh data at field level (Oracle, DB2, Teradata).
• Analyzed data using SQL, R, Python, Spark and present analytical reports to management and technical teams.
• Used Python Matplotlib packages to visualize and graphically analyses teh data.
• Design and development of analytical projects designed to understand key business behaviors dat drive customer acquisition, retention, and engagement
• Converted teh business logic usingAlteryxtools such as (Dynamic input, Block etc)
• Created teh macros and wrapper macros wif in theAlteryxas part of business logic implementation.
• Generated teh intermediary outputs into theAlteryx(.yxdb) and Tableau (.tde) files
• Published final outputs of theAlteryxmacros to Tableau server.
• Worked on creating various Tableau dashboards (rich in visual) as per teh business requirements.
• Linked teh .tde (Tableau data extract) file onto teh tableau server, so it refreshed every time
• Worked on regression by building a comparisonAlteryxWF which automates teh regression process by comparing teh results of Excel application againstAlteryxWF results
• Connected to theAWS Red shiftdirectly fromTableauto access cloud data warehouse and quickly perform visual analysis.
• Designing and development of Tableauvisualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved as a technical expert providing input to application design regarding production using and administration requirements.
• BI work stream projects in teh implementation and use of new BI software tools and systems.
• Involve in ETL applications, data feeding, cleansing, archiving and re-modeling.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for teh weekly and monthly dashboard reports on Tableau Server.
• Mastered teh ability to design and deploy rich Graphic visualizations wif Drill Down and Drop-down menu option and Parameters using Tableau.
• Performance monitored and tuned teh Tableau reports.
• 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.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Creating New Schedule's and checking teh task's daily on teh server.
• Worked extensively wif Advance Analysis Actions, LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Evaluated bug fixes and identified teh changes from 10.3 to 10.4 and digested teh customer accordingly.
• Mentored business power users to create reports/dashboards using tableaudesktop.
• Plan and implement teh overall analytics and business intelligence strategy
• Partner wif teh Technology teams to deliver a stable and highly available reporting platform.
• Analyzed user and business requirements attended periodic meetings for changes in teh application requirements and documents.

Confidential, Newark NJ

Tableau Developer/Data Analyst

Responsibilities:

• Worked in teh agile methodology-using Scrum, which TEMPhas its primary focus on teh management part of teh software development in small iterations of four weeks sprint.
• Worked on editing data connections and changing data sources in Tableau
• Handled tableau admin activities like granting access to users, managing extracts and installations.
• Created worksheets by creating join/data blending, custom SQL and data source filters.
• Used various join types (left, inner, right, outer joins) based on business requirements.
• Used techniques like data blending which brings data from multiple data sources into a single view in Tableau.
• Designed teh architecture of Tableau security by customizing teh access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Understand teh Requirements and Functionality of teh application from specifications.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Experience in TableauServer Installation, Configuration, Maintenance, Security, creating users, groups, projects, assigning access levels.
• Worked on Setting up Tableau Server on AWS.
• Provide ad-hoc analysis of compensation outcomes, investigate data discrepancies, and respond to field support calls concerning incentive compensation data.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Confidential, Birmingham, AL

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data form Excel/Oracle SQL Server for design, development, testing and production rollout of reporting and analysis projects wif Tableau Desktop.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop dat were presented toBusiness Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Designed, Developed and modify Interactive Dashboards and Creating guided navigation links wifin Interactive Dashboards.
• Created Action filters, Parameters and calculated Sets & Bins for preparing dashboards and worksheets.
• Working wif Business Analysts to streamline any data issue which involves Unit Testing of all teh worksheets.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions, Table calculations & LODs.
• Utilized Tableau server to publish and share teh reports wif teh business users. Also involved in administration tasks such as providing access to teh users and adding them to teh specific group.
• Given training/demos to users on Tableau Desktop for development and Tableau Server.
• Created Side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings wif teh Client subject matter experts to acquire functional business requirements.
• Experience in creating report schedules, data connections, projects, groups inTableauserver.
• Experience in creating custom admin views to monitortableauserver activities on periodic basis.
• Creating reports involving Multiple Data providers, Merged Dimensions, Synchronization, Combined Queries, Sub queries.

Confidential, Columbus, GA

SAP Business Objects Developer

Responsibilities:

• Designed and built new universes as per teh user requirements by identifying teh required tables from Data mart and by defining teh universe connections.
• As a part of Universe development, created classes, different kinds of objects, cardinalities, strategies, resolved teh loops using aliases and contexts.
• Arranged and supervised teh training sessions for business users to get them acquainted wif Info view and Web intelligence. Developed training materials for Business Objects and Documentation of teh environment, as well as migration and administration processes.
• Design, build and publish a set of webi reports and dashboard wif interactive analytical capabilities.
• In CMC, created users and assigned profiles.
• Tested teh Universe model for integrity and user acceptance.
• Designed and implemented summarized Universe for easier and faster Reporting.
• Checked teh integrity of teh Universes.
• Generated reports (master/detail, cross tab, chart) wif Business Objects Webi.
• Publishing reports online for web users and creating access to reports online (via Info View) using Webi.
• Migrating universes from teh test domain to production domain.

Confidential, Jersey City, NJ

SAP Business Objects Developer

Responsibilities:

• Interacted wif Business Users to understand requirement details based on project scope to develop Universes and Reports accordingly.
• Created complex business reports using custom formulas, context operators
• Merge dimension, combined queries and sub - queries.
• Created universe on top of data marts using star schema data model.
• Designed and Built teh Universes, Classes and Objects in Business Objects XI R2.
• Involved in enhancing and converting few of excel macro reports to Crystal reports.
• Created dashboards for analyzing statistical finance data using Xcelsius.
• Exported teh universes to teh Repository to share teh resources among teh users
• Created different types of reports such as Master/Detail, Cross Tab and Charts in Desktop intelligence and Webi.
• Designed and developed different type of Crystal Reports, Created Cross Tab, and Top N Reports for highlighting significant data, sub reports wif drill-down capabilities.
• Documented test cases and test scripts along wif technical specifications.