PROFESSIONAL SUMMARY

• As results - driven Tableau Developer wif Data Analytics experience focused on UI Visualizations, Business Intelligence (BI), Data Modeling, Analysis and Reporting.
• Experienced in Creating dashboards wif different Charts and Graphs in Tableau for best analysis.
• Experienced in writing SQL queries to import large volume Tables from Database Warehouses.
• Good Experience wif Software Development Life Cycle(SDLC) Agile methodologies.
• Worked on Tableau Desktop, Tableau Server, and access to different data sets for reporting.
• Experienced in working wif different databases and using Tableau as Business Intelligence and Reporting tool.
• Experienced in importing files from Database and Warehouses using SQL and reporting tools for Analytics and Reporting.
• Experienced in writing SQL queries to Performance tuning, Create Tables, Insert Values, Triggers, Stored Procedures.
• Resolved the various data missing using filters and Identifying the Key Performance Indicator(KPI) and Variables while Tableau reporting story line.
• Experienced in developing Calculated fields wif Dimensions and Measure's in Tableau, SAS BI.
• Experienced in creating and viewing system and user defined Stored Procedures and functions Using SQL Server.
• Worked on other reporting tools for data visualization and Reporting.
• Experienced in writing Functional Requirement Document (FRD) and Business Requirement Document (BRD) by gathering user requirements in Acceptance criteria.
• Experienced in gathering requirements from stakeholders and developed Dashboards and publish in Tableau Server.
• Connected Tableau to SQL Server and imported Huge Tables of Data by performing SQL queries for the Analysis and Reporting.

TECHNICAL SKILLS

• Agile
• SAS 9.4
• Tableau Desktop
• Tableau Server
• ETL
• Data Analysis
• SQL Oracle UI
• Data Visualization
• Data Modeling
• Data Warehouse
• Data base mapping
• Reporting BI.

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Tableau Developer

Responsibilities:

• Performed Data Analytics using Box Plot, Trend Lines, Reference Line, Reference Band and Forecasting in Tableau Reporting for Business Intelligence SAS BI.
• Developed and maintain project definitions and accurately describe the outcome, key performance indicators(KPI), business cases and high-level plans using Tableau.
• Performed various Advanced Table Calculations, Calculated fields, Aggregations and KPI’s for the Tableau analysis.
• Constantly observing ways to improve monitoring, discovering issues and deliver better values to the UI in Tableau Data Visualization.
• Created different Folders, Sets, Groups, Parameters and added constraints for the best Visualizations.
• Experienced working in teams and performing specific tasks in Tableau to Level of Details (LOD) types of Fixed, Include, Exclude for Data Analysis in the Level of granularity.
• Worked on interpreting multi-dimensional data using Pages, Sizes, Details, Color’s in Scatterplot.
• Used various filters to remove out layers, null records, Context filters to multiple worksheets for the best visualization.
• Experience in ETL and Connecting to SQL Server and Oracle DB to import tables and performed Transformations, Source to Target Mapping using SQL.
• Created effective user stories wif supporting artifacts including but not limited to document use cases in Tableau Story line, showing functional requirements or product specifications.
• Document the requirements from the stakeholders and Product Managers and interpret them in the best visualizations.
• Proficient in using Hyper Extract Connection for importing large volume of data and perform visualizations wif high system performance.
• Worked wif Metadata and defined field data types and definitions.
• Created SQL Stored Procedures, Functions, Triggers wif the tables in SQL Server.
• Created different Graphs, Heatmaps, Tree Maps, Scatterplots using multi-dimensions for the best visualizations.
• Good Experienced in working wif Agile/scrum Software Development Life Cycle(SDLC).
• Experienced in importing datasets from SQL Server using SQL and working wif SSIS for integration and other reporting tools for data visualization, Analysis, and reporting.

Environment: Agile, Tableau Public, Tableau Desktop, Tableau Reader, UI, Tableau Server, Oracle, SQL, SQL Server, SDLC, ETL, Training, Documentation

Confidential, Durham, NC

Tableau Developer

Responsibilities:

• Worked on importing huge volume of clinical datasets and using Tableau as Business Intelligence (BI) tool.
• Created User friendly environment in the story line after the Data is analyzed and reported in Tableau Visualizations.
• Experienced in working wif Software Development Life Cycle following Agile methodologies.
• Performed various Statistical Analytics and Reporting in Tableau, while importing data sets from SQL Server using SQL.
• Created Stored Procedures, Triggers and Packages and Inserted values in SQL Server and Oracle DB.
• Coordinated meetings, take meeting minutes, and follow-up on all action items for meeting wif multiple members and potentially Business Partner members.
• Worked on Data Analysis in different level of granularity based on LOD types Fixed, Include and Exclude Statements and advanced table calculations.
• Forecast, notify, and follow-up wif the project leads, product owners, and management for outstanding order status, business unit requests, and any issues dat arise in the Tableau Reports generated after Analyzed the Data for Business Intelligence (BI).
• Worked on SAS BI for the quick transition time and System Performance to Generate Statistical reports using PROC’s.
• Performed various transformations, aggregations and data mapping between tables using SQL.
• Experienced in Extract Transform Load of Large volume of datasets using ETL and performing various SQL queries.
• Added filters to remove the Null values and Hide the Unused Variables for data Analysis and to improve the Performance.
• Created Folders, Sets, Groups, Parameters on worksheets and Dashboards for the best Reporting practices and UI.
• Connected Tableau Desktop to SQL Server, Amazon Redshift and Imported Multiple datasets and Performed Data Blending by mapping relationships.

Environment: Agile, JIRA, HP ALM, Tableau, SAS BI, SQL, SQL Server, Amazon Redshift, BI, ETL, SDLC, SharePoint, MS-Office.

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Imported different Source files into ETL and performed various data transformations for the Target tables.
• Worked wif SAS for data analytics, reporting and Statistical analysis.
• Performed data Cleansing activities to remove the duplicate records, out layers and null values in ETL.
• Experienced in data mapping in staging area in ETL and Load into Data warehouse.
• Proficient in writing various SQL queries and performing data integration by joining multiple data tables using Primary Key and Foreign key relationship.
• Designed different Fact Tables and Dimensional Tables using relationships in Data Warehouse.
• Worked wif data warehouse connecting wif different data marts and cubes in data modeling following database schemes as per project requirement.
• Act as the liaison between the technical team, the external customer and product management.
• Worked wif Agile/Scrum Methodologies in the Software Development Life Cycle (SDLC).
• Created Stored Procedures, Constraint’s using SQL for the better system performance.
• Good experience wif SAS in performing large dataset analysis using SQL and other PROC statements.
• Partner wif Quality Assurance by writing acceptance criteria and working wif the team to execute.

Environment: HP-ALM, Visio, SQL, SAS, SQL Server, ETL, Reporting BI, MS-Excel, MS-Word

Confidential, Tarrytown, NY

Data AnalystAugust

Responsibilities:

• Proactively consult, deliver, and support IT services and software applications.
• Manage the overall operational and technical aspects of the IT and business partner’s.
• Suggested Software tools based on the current Business requirements.
• Experienced in using Tableau and other reporting BI tool for best Statistical Analysis and understanding Market demands.
• Experienced in Extract Transform Load(ETL) Data Tables from Relational databases to Database Warehouse.
• Experienced in using different SQL queries, working wif the Databases systems.
• Performed Source to Target Mapping(STM) using different types of Transformations.
• Assisted wif project Leader to ensure schedule, cost, resource, and quality goals are achieved, including project scheduling, estimating, forecasting, risk management, communications, change management, and financial performance.
• Experienced in using Tableau for the Data Visualization and Analysis wif project Leader.
• Provide multi-level presentations on program updates, project cycle, and expected results to companywide organizational Senior Analysts and Leaders.

Environment: Data Mapping, Agile, Scrum, Tableau, Clinical Trails, HP QC (ALM), Database schema, XML to database queries, SQL.