SUMMARY

• BI Architect with Administration and Development experience with data warehousing skills Alteryx/Tableau/Spotfire/Informatica/Cognos.
• ETL data modeling in development of dashboards, scorecards, visualization, and analyses using Alteryx, Tableau, Tibco Spotfire and Microsoft Office, Suite: PowerBI, PowerPivot, SharePoint and Excel.
• Implementations and Testing of Data Warehousing and Database business systems for Financial, Gas, Insurance and Non - Profit industries.
• Prepared, blend and cleanse data from multiple sources using Alteryx to design extracts for optimal use with Tableau
• Build published Tableau data sources encompassing subject areas with established meta-data for attributes providing self-service analytical capabilities.
• Expertise with Tableau in analyzing data using statistics, developing dynamic analytic applications, implementing, integrating, customizing, deploying and maintaining BI solution.
• Lead Tableau center of excellence team to guide developments teams on standard, best practices, leveraging cutting edge technologies in BI space.
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards using Tableau.
• Expert in designing Tableau dashboards / reports with complex multiples data sources (SQL, Oracle, Excel, Flat files And BigData tools) relational design and optimizing applications.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Exposure to Big Data technologies Hadoop HDFS, hive to pull Data into the BI.
• Experience Using Composite to High performance analytic data processing distributed across the widest variety of data sources data warehouses, data bases, No-SQL sources (Mongo DB), Cloudera distributions of Hadoop.
• Installed and configured R engine in Spotfire environment and deployed R Packages.
• Iron Python Scripts are executed from an action control in the HTML text area.
• Worked extensively on Information Designer, Scheduled updates, Custom HMTL templates and advanced concepts like database write back from Spotfire reports.
• Iron Python Script to set Spotfire Filters, Reset sort order, Reset marking, Show/Hide Legend and Switch View Type.
• Using Composite to Centralized control of data and metadata, and created information links in Spotfire and used in Spotfire analysis.
• Experience & Knowledge in BI tools like, Tableau, Tibco Spotfire, Cognos, Power BI and SAP Lumira.
• Ability to work in teams & independent with minimal supervision to meet deadlines.
• Team Player & Agile Project Management Skills.
• Good communication, analytical and Interpersonal skills.

TECHNICAL SKILLS

Analytical Tools: Alteryx11.5, Tableau10.2(Desktop/Sever/Reader), TIBCO Spotfire, TIBCO Statistical Services/Automation Services, Cognos 10.2, SSRS

Big Data: Hadoop, HDFS, MapReduce, Hive, Sqoop, Impala, Pig, Oozie, HBase, Pig, Zookeeper, Distributed Computing, MongoDB

Data Virtualization: Cisco Composite

IDEs/Applications: Eclipse Helios, Eclipse Indigo, JBoss Developer Studio NetBeans 6.X and above

Operating systems: Windows 2008 server, Windows 2003 Enterprise Server, XP, 2000, UNIX, OS/390.

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Languages: JAVA, VISUAL BASIC, COBOL, JCL, .Net C#, R

Database: SQL Server 2000/2005/2008 , Oracle 11g/10g, DB2, Teradata V2, DB2

Legacy systems: IBM Mainframe S/390, AS400

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Data Analyst/Senior Tableau Consultant

Responsibilities:

• Responsibility to build an Analytics reporting solution as per requirements from customers.
• Involved in review of data, query generation/resolution and data analysis, including review of draft listings to support data cleaning and interpretation.
• Manage the planning and development of design and procedures for metrics reports.
• Investigate and conducted study on forecasts, demand for products.
• Successfully interpreted data to draw conclusions for managerial action and strategy.
• Used Alteryx and tableau to test and validate data and interpretations.
• Develop rich interactive visualizations, that are intuitive, easy to use and understand using Tableau
• Prepare, blend and cleanse data from multiple sources using Alteryx to design extracts for optimal use with Tableau
• Presented findings and data to team to improve strategies and operations.
• Develop tableau reports and delegates tasks to team members.
• Produced Weekly, Monthly tableau reports to Business Executives to take decisions.
• Created different KPI using calculated key figures and parameters for Executive dashboards, summary dashboard.
• Created Scan Compliance reports for Walgreen’s using Altreyx and tableau.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Move visualizations to production through the development stages (dev/qa/prod) per existing process.
• Created robust documentation of solutions, validation conducted and operating procedures to transition support.

Environment: Tableau10.2, Alteryx11.5, Teradata, Oracle 10g/11g, SQL Developer, Toad.

Confidential, Baltimore, MD

Data Analyst/Senior Tableau Consultant

Responsibilities:

• Analyzed the source data and handled efficiently by modifying the data types.
• Gathered business requirements and designed functional and technical requirements documentation.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Developed Tableau workbooks from multiple data sources, Data blending implemented on databases and generated interactive dashboards.
• Developed Tableau to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Expertise in designing and development of various dashboards reports utilizing variousTableau/Spotfire visualizations like Dual Axis Bar Graphs Scatter Plots Pie Charts Heat Maps Bubble Charts Tree Maps Box Plots Waterfall Charts Geographic(Map) Visualization and other making use of actions other local and global filters according to the business/client requirement.
• Built dashboards for measures with forecast, trend line and reference lines.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Generated tableau dashboards for sales with forecast and reference lines.
• Generated context filters and data source filters while handling huge volume of data.
• Hands on building Filters, Groups, hierarchies, Sets, Parameters, Calculated Fields to create detail level summary reports and Dashboard using KPI's.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different users.

Environment: Tableau (Desktop/Server)10/9.1, Alteryx, SQL Server 2008/2012, Oracle 10g/11g, SQL. SQL Developer, DB Visualizer and Simfund tool.

Confidential, Houston, TX

Senior Tableau/Data Visualization Analyst

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Install, Setup, Configure Tibco Spotfire environment.
• Design & implemented migration process to dev-to-test-to-prod SPOTFIRE Environments.
• Administered SPOTFIRE programs and supported library management.
• Evaluated log files and implemented performance tuning.
• Supported SPOTFIRE logs for resolution of issues.
• Established data connections in SPOTFIRE with SQL and Oracle data sources.
• Formulated dashboard specifications and generated status reports.
• Documented and maintained practices for system installations and configurations.
• Experienced with load balanced web architecture using Apache Tomcat.
• Upgraded the Environment to 5.5 from 6.0 and 6.0 to 6.5
• Configured LDAP.
• Configured Single Sign on using Windows Authentication.
• Developed information links using Information Designer.
• Worked with Property controls, Action Controls (Iron Python Script), Document properties, Column & Data table Properties, filtering scheme, Data on demand etc.
• Collected data on various process measurements and formatted into graphs using TIBCO Spotfire software.
• Worked on Information designer, building Information links, elements, filters, joins, prompts, prompt groups etc.
• Suggested & developed various charts i.e. MAP Chart, Scatter Plot, Heat Map, Tree Map etc. Based on the data representation/visualization requirement.
• Worked on Automation Services to schedule an email job daily to the users.
• Development of the Reports in Spotfire Professional & Publishing the file to the Library.
• Installation of Statistical Services and SPLUS and TERR setup.
• Installation and set up R Programming environment
• Migrate the Spotfire Library from DEV to PROD after UAT.
• Trouble shooted many servers related issues regarding user access, performance, publishing etc.
• Worked a lot on the Web Player defining the Folder permissions for the User & Groups created.
• Integrated OpenSpirit application With Spotfire to create reports.
• Deployed geo analytics packages GeoR, ArcGIS.
• Setup connectivity between Spotfire and Open Spirit.
• Develop and maintain documentation and reference material for the users; and conduct user training to build and customize their ad-hoc reports.
• Migrated Dashboards from tableau to Spotfire.

Environment: Spotfire professional 6.5/6.0/5.x, Spotfire web player, Spotfire enterprise player, Spotfire Statistical Services, R, Spotfire Automation Services, Tableau 9.X, OpenSpirit 4.0.3, ArcGIS Desktop, SQL Server 2008, Oracle 11g, Composite, SQL. .Net C#

Confidential, Dallas, TX

Senior Tableau/BI Consultant

Responsibilities:

• Tableau project architecture, design, jumpstarting the development activities and implementation approach for LOB reporting solution.
• Translate product requirements and business questions into report requirements and visualization dashboards.
• Identifying non-functional technical requirements. Interpret business requirements to create scalable, innovative, and repeatable business intelligence reports, often using very large data sets.
• Influencing the design of databases to accommodate reporting requirements.
• Created logical measures in Tableau as per the requirements.
• Developed Customized Reports using Tableau.
• Using data transformations like pivot, un-pivot, calculate/ replace columns in Tableau for representing data as needed on the reports.
• Worked on various new Chart developments like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart
• Connecting to multiple Sources like Composite and Exadata for POC.
• Evaluated multiple BI tools and created POC using different BI tools Like Tibco Spotfire.

Environment: Tableau 8, Spotfire professional 5.x, SQL Server 2008, Oracle 11g, Composite, SQL.

Confidential, Dallas, TX

Senior Tableau/BI Consultant

Responsibilities:

• Participated in client calls to gather and analyze the requirement.
• Involved in setup for Hadoop Cluster in Pseudo-Distributed Mode based on Linux commands.
• Involved in Core Concepts of Hadoop HDFS, Map Reduce (Like Job Tracker, Task tracker).
• Involved in Map Reduce Phases by Using Core java, create and put jar files in to HDFS and run web UI for Name node, Job Tracker and Task Tracker.
• Involved in Extracting, transforming, loading Data from Hive to Load an RDBMS.
• Involved in Transforming Data within a Hadoop Cluster
• Involved Job to Load, Loading Data into Hive.
• Created Hive External tables to store the processed data from Map Reduce.
• Involved in Writing input output Formats for CSV.
• Involved in Import and Export by using Sqoop for job entries.
• Importing data from various data sources like Sql Server, Oracle, DB2 to HDFS and Hive using Sqoop.
• Created workflows using Oozie to automate the process of loading.

Environment: Hadoop, HDFS, Map Reduce, Hive, Sqoop, Oozie, Core Java, UNIX, and Oracle 11g, Sql server 2008, DB2

Confidential, Dallas, TX

Senior Tableau/BI Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created reports using List, Cross tab, and Chart templates in Report Studio.
• Developed standard reports, Charts, Drill-through Reports and Master Detail reports
• Created query prompts, calculations, conditions and Filters.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Bursting Reports and Multilingual Reports bases Using Report Studio.
• Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users.
• Also created documentation for all the processes involved like applying security for reports, deployment, portal customization etc.
• Create packages to suit the business needs and to improve the performance of the reports by defining filters, adding calculations and performing SQL tuning on the model and report level using iSeries.

Environment: COGNOS 10.2 (Framework Manager, Report Studio, Query Studio, CognosConnection), DB2, Toad, MS Excel, Windows 2008/ XP. ISeries Navigator.

Confidential, Dallas, TX

Senior Tableau/BI Consultant

Responsibilities:

• Involved in migrationofSQLServer .
• Managing the deliverables and integration with the project plans. Coordinating the tasks across offshore/onsite team members and managing changes during the development cycle.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Involved in migrating code from dev to UAT and Prod, creating build requests and maintaining code in TFS.
• Implemented Error Handling in SSIS packages and notified process results to various user communities.
• Daily tracking the status form developers and update to lead.
• Involved in unit testing, verifying new packages vs existing 2000 packages.
• Documented what are the standards we need follow thought out project.
• Trained Users/offshore developers to understand the migration process.

Environment: SQL Server 2000/2005/2008 , T-SQL, TFS 2008/2010, SSIS, SSRS, SSAS, ASP.NET, C#, Visual Studio 2005/2008, ER-Win, MS Visio.

Confidential, Pittsburgh, PA

Sr Tableau Developer

Responsibilities:

• In charge of the business requirements and gathering requirements from business users.
• 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.
• Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across it and various data sources.
• 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.
• Involved in data analysis, designing, and development of data warehouse environment.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Desktop/Server Reports.
• Worked extensively with Advance Analysis Actions, LODs Calculations, Parameters, Background images, Maps.
• Skilled in translating business requirements into technical designs and specifications.
• 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 with an ability to adapt modern technology quickly and a strong team player.

Environment: Tableau8, Oracle10g, SQL Server 2008, TOAD, SQL, windows server.

Confidential, Pittsburgh, PA

Tableau Developer

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• 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.
• Designed, developed and tested various Tableau visualizations for dashboard and ad-hoc reporting solutions.
• Redesigned the data source having data from various sources into one SQL Server and to Tableau.
• Worked closely with data architects to improve data's performance by reducing the number of calculated fields and thus optimizing performance.
• Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across it and various data sources.
• 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.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Environment: Tableau 8/9, Oracle10g, SQL Server 2008, SSIS, TOAD, SQL, windows server.

Confidential, West Desmoines, IA

Informatica Developer/Tableau Developer

Responsibilities:

• Extensively used Informatica to load data from Flat Files to DB2, Oracle to Oracle. Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
• Worked with Informatica components like designer, Work flow manager, Work flow monitor, Repository Manger
• Check data consistency/accuracy/integrity
• Understanding the requirements of client and the existing system
• Understanding of Informatica Mappings, Sessions and Workflows
• Mapping business requirements to technical specifications and design logic for implementing the same
• Development of Informatica Mappings, Sessions and Workflows
• Developing Unix Shell Scripts to automate Data loading Process
• Test the mappings and check the quality of the deliverables
• Test the mappings for compliance to required functionality and standards
• Validation of migrated data
• Designed, developed and tested various Tableau visualizations for dashboard and ad-hoc reporting solutions.
• Redesigned the data source having data from various sources into one SQL Server and to Tableau.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Bubble Charts, Bump Charts) based on client's need.

Environment: Informatica 8.6.1/8.1, Tableau 8, Oracle 10g, SQL, Toad, WINDOWS, UNIX.

Confidential, Wisconsin, WI

Research Assistant

Responsibilities:

• Worked for 12 months in the IDC (Instrumentation Design and Control) Lab with Professor and worked as Teaching Assistant for all the e - learning programs conducted by the University.
• Maintained Database of the Professors and scheduling their Programs online
• Handling Webcasts and handling the e-leaning programs offered by the university.
• Worked on SQL, Microsoft office Excel.

Environment: SQL, Microsoft office Excel