SUMMARY:

• 7+ 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.
• Expertise in developing Tableau (Desktop/Server, Mobile)6.0,7.0,8.0,/9.0/,9.1/,9.2/,9.3/,10.0/10.1,Teradata, Teradata SQL Assistant, Microstrategy, Teradata Administrator, SAP HANA,Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Modeling Tools Power Designer, MS Visio.
• Experience in customizing standard reports as well as developing custom reports in Oracle Applications using Oracle Reports Builder.
• Established consulting firm specializing in data integration, Microsoft business intelligence, data warehousing, SSRS, SSIS, ETL solutions, and more.
• 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.
• 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.
• Good in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Worked on projects related to d3.json.
• Experience in designing & developing OLAP cubes using KPI's, calculated fields, dimensions and also by Implementing Hierarchies.
• 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:

BI Reporting Tools: Tableau Desktop 10.0,9.0, 8.0, 7.0, 6.0, Tableau Server10.0, 9.0, 8.0, 7.0, 6.0, Tableau Public, Tableau Reader,Cognos,MIicrostrategy,SAP BO.

ETL Tools: MY SQL Server 2008,SSRS,SSIS, Data Stage

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

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

Application Packages: MS Office 2013/2010/2007.

Operating Systems: Windows, Mac, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Senior Tableau Developer

Responsibilities:

• Responsible for gathering business requirements, doing gap analysis and documenting them textually or within models.
• Created Tableau stories, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on Symbol maps, Bubble chart, Drill down analysis using tableau desktop.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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.
• Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
• Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
• Extensively used SQL scripts for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau Server 6, 7, 8 Tableau Desktop 6, 7, 8, Oracle 10g, SSIS, Informatica, MS SQL Server 2008, Share Point(ETL),SSRS, UNIX, SQL Server 10g, Erwin, MS VISIO,AWS, Microsoft Office Suite.

Senior Tableau Developer/Admin

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.
• Developed new reports as per Oracle Applications development standards and customized existing reports in the PO module according to the client's requirements.
• 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.
• Created tables, views in Teradata, according to the requirements.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Reduced Teradata space used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.
• 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, Oracle SQL developer, SSIS, SSRS,MS Office Suite, Teradata.

Tableau Developer

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
• 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, SSIS,Datastage, Teradata, SQL Assistant, Business Objects,Microstrategy, PG admin,AWS, SQL, PL/SQL, MS Project.

Tableau Developer

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.
• Prepared the test cases for system testing.
• 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.
• Come up with test data and test scenarios for the tables where there was no data available from the source.
• 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.
• Developed multiple axes crosstab report for conditional coloring to raise a red flag on potential fraud cases.
• 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, Cognos,Oracle 11g, PL/SQL, SQL *Plus, SQL Loader, Oracle Sql developer, Excel

Tableau Developer

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 V6, Tableau server V6, SAP HANA,IAM Web based reports (IAM), Oracle SQL, Base SAS, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft Office 2007

SQL Developer

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,Oracle SQL, MS Access 2007, MS Excel 2007, BIDS (DTS Designer), Windows XP platform, Office Visio 2007, SQL Profiler, Index Tuning Wizard.