SUMMARY:

• 8+ years of Strong experience in IT experience including Data Analysis, Design, Development and Testing. Fully committed to work and can able to handle pressure while simultaneously delivering good quality of work.
• Access the feasibility of systems enhancement or process changes and their impact on HR and ancillary systems.
• Expertise in developing Tableau (Desktop/Server, Mobile)6.0,7.0,8.0,/9.0/,9.1/,9.2/, 9.3/10.2/10.4/2018.1, Teradata, Teradata SQL Assistant, SharePoint, Python, Teradata Administrator, Informatics, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Modeling Tools Power Designer, MS Visio.
• Responsible for managing the HR Systems Self - Service portal with over 90,000 end users.
• Designed and Developed dashboards, worksheets and stories which are helpful in clear data analysis using Tableau Visualizations like Bar graphs, Tree Maps, Heat Maps, Box Plots and Geographic Visualizations.
• Good in Troubleshooting, Performance tuning of reports and can resolve issues within Tableau Server and Reports.
• Experience in Developing, Designing and Support inter active Tableau Interactive Dashboards and Storyboards.
• Worked on various reporting objects like Sets, Groups, Attributes, Hierarchies, Filters, Calculated fields, Parameters, Prompts, and Transformations etc.
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Very Familiar with concepts and also worked with SDLC and also worked in Agile methodology to meet customer expectation, timelines with quality deliverables.
• Good in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Worked on projects related to d3.json.
• Developed reports using SQL Server Data Tools(SSDT/SSIS).
• Understanding and implementing best practices of data visualization.
• Implemented agile methodology (SRCUM) in the projects which involved daily SCRUMS.
• Experience in designing & developing OLAP cubes using KPI's, calculated fields, dimensions and by Implementing Hierarchies.
• Good at Extraction Transformation and Loading (ETL) processes using DataStage 9.1/8.7/8.5/8.1/8.0//7.5.2/7.1/7.0
• Involved in team work for delivery requirements and estimates with Data Warehouse team, ETL team and Project Managers.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, Logical and Physical Database Design.
• Result oriented, self-motivated, team player, ability to work independently.
• Good communication skills and also can quickly adapt to new technologies by self learning.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop 2018.1,10.4,10.2, 9.0, 8.0, 7.0, 6.0, Tableau Server 2018.1,10.4,10.2, 9.0, 8.0, 7.0, 6.0, Tableau Public, Tableau Reader, Informatica.

ETL Tools: MY SQL Server 2008, Data Stage, SSDT

RDBMS: MS SQL Server 2005, CSV, MS Excel, MS Access.

Languages: Python, PL/SQL, SQL, XML, HTML, Perl, Java Script.

Application Packages: MS Office 2013/2010/2007, Oracle BI Applications, MS SharePoint

Operating Systems: Windows, Mac, Linux.

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer

Confidential, PA

Responsibilities:

• Created customized and interactive Tableau dashboards using multiple data sources - Oracle, SQL Server, CSV files
• Understand the business needs so that it can translated to open questions to solved insights that motivate entire team to do more.
• Took board requirements and transferred into fast developed prototypes and working solutions
• Provided expertise developing Tableau reports dealing with predictive results from analytical trending and modeling
• Participated in design reviews, code reviews, brainstorming sessions and QA bringing an open mind to work and a helpful eye for others.
• Defined and communicated best practices for report development
• Worked with data architects to define report performance optimized data models
• Developed detailed data mapping and end-to-end process flows and worked with big data analytics, automation and machine learning technologies
• Strong Data Analytics skills with an ability to analyze datasets with Microsoft Excel or Tableau and worked with customers to define KPIs for monitoring process improvement
• Downgraded all the existing workbooks from Tableau 10.4 to Tableau 10.2 in order to publish them on the Fresenius Tableau Server.
• Worked with customers to define reporting needs and implement Tableau reports to satisfy needs
• Provided recommendations for data presentation within reports/dashboards
• Identified opportunities to increase the efficiency of the reporting process - including automation of existing manual datasets

Environment: Tableau Server 10.2, 10.4, 2018.1, Tableau Desktop 10.2, 10.4, 2018.1, MS SQL Server 17.4, Oracle 10g, MS VISIO, Microsoft Office Suite.

BI Developer

Confidential, Milwaukee, WI

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 within Tableau
• Desktop.
• Install, upgrade and configure database solutions through OBIEE tools.
• Develop data access queries through Oracle BI tools.
• Generated Reports using procedures and views for faster execution and Migrating reports from one version to another.
• Also, created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map by color that was broken into cities allowing business user to understand.
• Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business
• 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.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Applied Cascading Prompts and Multi Level Prompts on dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and
• Reports.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Server 6, 7, 8 Tableau Desktop 6, 7, 8, Python, Oracle 10g, MS SQL Server 2008, SSDT, Share Point, TFS, Informatica 9.1, UNIX, SQL Server 10g, MS VISIO, Microsoft Office Suite.

Tableau Developer/Admin

Confidential, WA

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 within Tableau Desktop.
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed Oracle BI Metadata repository using BI Administration tool.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map by color that was broken into cities allowing business user to understand.
• Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Subject Matter Expert(SME) and also worked with statistical programmers in order to secure that data views are precise.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business 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.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 9, 8 & 7, Tableau Server, OBIEE 10.1.3.4, Oracle 10g, SQL, MS Office Suite, Teradata.

Tableau Developer

Confidential, Salem, OR

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
• Worked closely with business users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed HIVE scripts to analyze data.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server and can view the data.
• Scheduled frequency and time to refresh data when sources are published or extracted to server.
• System administration and programming skills such as storage capacity management, performance tuning
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in ipads, iPhones, and other smart mobile phones.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 8,OBIEE, Oracle 10g, Teradata, SQL Assistant, Python, Perl, Business Objects, PG admin, SQL, PL/SQL, MS Project.

Tableau Developer

Confidential, Detroit, MI

Responsibilities:

• Used DataStage ETL tool to load data from flat files and source tables to the staging, dimension and fact tables.
• Created DataStage parallel jobs and sequencers to load data into dimensionally modeled schemas (star and snow flake schemas) using Ralph Kimball methodology.
• Coded SQL, Pl/Sql queries for data validation, data massaging, data analysis and data loading.
• Created tables in Oracle database for all the schemas designed.
• Designed, developed and tested the DataStage jobs using Designer and Director based on business requirements and business rules to load data from source to target tables.
• Modified the existing job with new functionality in the code.
• Used several stages like Sequential file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator, Peek, Transformer, Sort, Remove Duplicates, Copy, Lookup, Join, Merge, Filter, Datasets, Oracle connector during the development process of the DataStage jobs.
• Used partitioning techniques such as round-robin, hash etc to process data in parallel and improve performance.
• Used parameter sets to create and maintain job variables.
• Monitor DataStage jobs using Director and troubleshooting using logs.
• Performed fine tuning, Trouble shooting, bug fixing and defect analysis in DataStage Jobs.
• Used error handler process Jobs to capture look up failure, duplicates and data type errors and these errors are captured to an error log detail table.
• Deploying the code into all other test environments and making sure QA to pass all their test cases.
• Resolving the defects which have been raised by QA.
• Established best practices for DataStage jobs to ensure optimal performance, reusability, and restartability.
• Created Dashboards and reports using Tableau.
• Created custom Geo-mapping, Bullet charts, Bars and Stacked bar charts, line charts, text tables, bubble charts, pie charts, scatter plots, header metrics etc.
• Managing projects, data sources and extracts on tableau server.
• Used advanced functions such as table calcs and LOD (level of detail) calculations wherever required.
• Defined best practices for tableau environment to standardize maintain consistency and improve efficiency.
• Publishing dashboards as tabs to group dashboards for every program.
• Comprehensive tableau testing for reconciling measures and other values between database and Tableau environment (views and dashboards).
• Reviewing and suggesting improvements for dashboards and visualizations developed.

Environment: DataStage 8.0, Tableau 8 Desktop & Server, Oracle 11g, PL/SQL, SQL *Plus, Data Stage, Excel.

Tableau Developer

Confidential

Responsibilities:

• Involved in Exploring, Designing, Building, Testing & Deployment of the high level dashboards for Marketing Decision makers.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Developed Complex Web based reports using IMS analysis manger and published same with security actions.
• Developed new reports and enhancing existing reports in Tableau environment.
• Presented IAM reports and Tableau Dashboards to the higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Recommended and took lead on new ideas of implementation/developing of IAM Web reports involving responsibilities towards getting dashboard requirements, design, document, develop and test front end dashboards and reports.
• Provided support to different levels of Tableau developers.
• Involved in Creating and Managing security rules for dashboards and views.

Environment: Tableau Desktop 6, Tableau server 6, Perl, IAM Web based reports (IAM), Base SAS, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft Office 2007

SQL Developer

Confidential

Responsibilities:

• Gained real time experience right from SQL Server 2005 installation and supporting data architecture a lot with schema objects like tables, views, clusters, indexes, procedures, triggers maintaining referential integrity.
• Assisted the architects in setting up of logical and physical data models, generated DDL scripts and maintained metadata.
• Modifying and bug fixing stored procedures for workload drop off on to visual studio and normalizing tables with redundant data attenuation.
• Naming convention for database standards, managing transaction log and space requirements with table partitioning.
• Gained knowledge on data cleansing, validation and normalizing concepts.
• Porting old data into new database using BCP and BULK Insert task.
• Involved in daily code drops and archives on the production databases during windows maintenance.
• Running (DBCC) consistency checks and fixing data corruption in application databases.
• Performance tuning with re-indexing and updating statistics using SQL Profiler and Index Tuning Wizard.
• Developed table valued functions and indexed views during data migrations from staging databases to enterprise warehouse
• Developed and automated packages with data scrubbing on data from File and Database systems retrieved based on file/sheet/table names for data population on staging server.
• Configured SQL Server agent and created jobs to schedule packages on daily and weekly basis for maintaining database.
• Interacted with team lead and administration on technical clarifications.

Environment: MS SQL Server 2008/2005, MS Access 2007, MS Excel 2007, BIDS (DTS Designer), Windows XP platform, Office Visio 2007, SQL Profiler, Index Tuning Wizard.