SUMMARY:

• Over 8+ years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of BI/Data Warehousing projects using Tableau, Micro Strategy, Cognos, Alteryx etc. in Insurance, Finance, Banking, Telecommunication, Health Care, Retail and Payroll Services industries.
• Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x/9.x/8.x/7.x/6.x.
• Advanced knowledge of Self - Service analytic / ETL tools, specifically Alteryx Designer.
• Experience with Tableau reporting/data visualization tool and integration between Alteryx and Tableau.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. 
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Hands on Experience in Writing   Python   Scripts for Data Extract and Data Transfer. 
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. 
• Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts ( Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in Developing, Designing and Support inter active Tableau dashboards.
• Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience in Confidential -SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experience in developing and debugging Stored Procedures and Triggers.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Excellent hands on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS, Alteryx.
• Experience in working with different type Dirty Data from Different sources.
• Experience in working with Data Cleansing technique in ETL procedures.
• Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), and Power view.
• Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• Knowledge Microsoft Power BI, Data Zen, DAX expressions, Power View and Power Query integrated with share point.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services, and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Excellent hands on experience in creating groups and measures, KPIs.
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

Reporting Tools:  Tableau (Desktop/Server), Micro Strategy (Desktop/WEB), SSRS,DWH, Business Intelligence.

Data Integration(ETL) Tools:  Alteryx, Informatica Power Center, SSIS.

Modeling Tools:  Power Designer, Erwin, ER Studio, MS Visio, OBIEE

SQL Tools:  Teradata SQL Assistant, Rapid SQL, Toad, PL/SQL Developer, SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), SQL* Plus.

RDBMS:  Teradata, Oracle, OLAP, SAP HANA, SQL Server, DB2, Mongo,Access etc, Hadoop, NETTEZA

UI Tools:  CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation:  Documentum, SharePoint, HP Quality Center.

Scripting/Languages:  C, C++, .NET, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML, BTEQ, JSON, CSS

Scheduling Tools:  Autosys, Control M

Operating Systems:  UNIX, Linux, Windows 7/XP/2000, 2008/2003, Windows 9x

PROFESSIONAL EXPERINCE:

Confidential,CA

Sr. Tableau Developer

Responsibilities:

• As a part of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics and Reports. 
• Involved in creating dashboards by extracting data from different sources.
• Designed and developed ETL workflows and datasets in Alteryx to be used for Reporting (ETL tool specific for creating datasets) Tableau Data Extract for BI.
• Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau.
• Used ETL (Alteryx) process to Extract, Transform and Load the data into stage area and data warehouse.
• Used Tableau Desktop Data Visualization tool for reports, integrated tableau with Alteryx for Data & Analytics.
• Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies, created drill through reports in dashboard.
• Used Alteryx for Integration and Power BI and tableau for Business Reports.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Salesforce, Oracle, Teradata and SQL Server.
• Developed LOD reports on various KPI’s.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Used Alteryx for data and analytics.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used Agile/Scrum methodology for software development.
• Connected Tableau Server to Publish dashboard to a central location for portal integration.
• Worked in dimensional modeling with Star &Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and dimension tables.
• Developed robust analytical systems using MS Power BI (Excel 2013), Power Pivot (DAX), Power Query (M) and Power Map.
• Development and Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Manages platform admin functionalities including installations/configuration, upgrades, patches, change management, performance tuning, standards/ best practices, mentoring, metadata management, cluster/distributed management, cache/ history management, user management, scheduling.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Desktop 8.x/9.x,Tableau Server, Alteryx, MS Office Suite, Alteryx, Oracle, SQL Server, SQL Server Analysis Services (SSAS) Salesforce, POWER BI, CSV, MS Excel.

 Confidential, Richardson, TX

Sr. Tableau Developer

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.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Blended data by using Alteryx.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and 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.
• Worked on Power BI for analytics.
• 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.
• 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 7 & 8.1, Tableau 8.2/8.3/9.0, Tableau Server, MS Office Suite, Mongo DB, Oracle SQL Server R2, Power BI, MS Excel

Confidential,CA

Sr. Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created static reports (dashboards) in the areas of Bookings, Revenue, Forecast, Budget & Expense, Profit & Loss, Headcount and other adhoc reports for business leaders.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Reporting by Regions, Products, Departments, Cost categories for various reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Gathered data using SQL Server, Oracle Business Objects, MS Access and other internal Cisco tools
• Proactively evaluated business landscape and requirements and identified explicit and implicit needs.
• Used Alteryx ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Identified business critical issues using GAP analysis and help the team make right choices and create business solutions for review by top management.
• Analyzed, designed and optimized business processes for better performance and reporting.
• Supported tasks and activities for business operations and project management teams.
• Interacted and built relationships with internal (business, technical, sales) teams and vendors / partners to drive project and provide support.
• Created executive level presentations using Microsoft Power Point.

Environment: Oracle 10g, SQL, Mongo DB, MS Excel 2011, MS PowerPoint, MS Project, Tableau 8.2/8.3

Confidential, NYC, NY

DWBI Developer

Responsibilities:

• Analyzed the specifications provided by the clients and developed specification documents for reports as per client requirements.
• Involved in migration of reports from Cognos 8 to Cognos 10.
• Involved in designing and creating various models and publishing packages in Framework Manager.
• Created different filters and calculations in Framework Manager that can be effectively used while reporting.
• Created star schema grouping for better understanding of the model & facilitate multi-fact (cross-fact) reporting.
• Created complex, multipage reports using most of the Cognos functionality (such as Prompts, Conditional Formatting, and Conditional Rendering).
• Created dashboard from scratch that included drill-through, filters, calculations, graphs, crosstabs, lists, conditional blocks, and master detail relationship.
• Performed optimization on the existing reports to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for the users.
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Created cubes in Transformer using Framework Manager IQD’s, packages and report studio reports as a source.
• Experience working on Cognos Administration with expertise in installation, configuration, Troubleshooting and setting up security for Cognos 8.4 environments.
• Responsible for creating user groups and roles to manage security in Cognos Connection and access rights of the reports for the end users.
• Involved in administration tasks like scheduling - single report scheduling.
• Resolved the performance issues of the reports.
• Created test cases for unit testing of the reports.
• Deployed packages and reports from development to QA and then Production servers.
• Trained the end users to effectively use the reporting tool (Query Studio) to build and customize their ad-hoc reports.

Environment: Tableau Desktop 8.4/8.6, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel Oracle 10g, MS Office

Confidential, Parsippany, NJ

ETL consultant /System analyst

Responsibilities:

• Validated the ETL Scripts in the Target Database (DB2) for creating the cube before migrating it to SQL Server.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in Test link.
• Prepared Test Strategy document, System Test Plan, Performance Test Plan, Traceability matrix and Test Summary Reports
• Involved in developing test cases to test DB2 scripts (Bteq, multiload, fast load).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
• Extracted data from Oracle and upload to DB2 tables using DB2 utilities FASTLOAD. Extensively Built external mapping to transfer data from SQL Server database to DB2 Data Warehouse. This includes writing SQL Statements.
• Coordinated in implementing ETL using complex stored procedures on SQL 2005 Server.
• Acted as first point of contact for all critical issues related to data mapping and data sourcing
• Responsible for testing Initial and daily loads of ETL jobs.
• Data filing and Tableau Dashboard Design & Development and create Architect workflow.
• Point of contact for the client data testing, data accuracy and accuracy of functionality.
• Coordinating with source system owners, day-to-day ETL progress monitoring and maintenance of daily Informatica batch schedule run on a nightly basis.
• Defects were identified, provided documentation to the development team for debugging.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• Analyzed the business/system requirements specifications, and prepared Test Plan and Test Cases for Functional, Integration, Regression, SIT, End-End and UAT Testing
• Participated in project planning, release, daily stand up meetings.
• Customer process relation
• Data mapping and Data replication process.
• Index fax and email document in Captiva tools, Citrix.
• Create work flow process application Diagram and data processing diagram (Visio-basic)
• Involved in maintaining the test environments, like requesting data loads, data base backups, requesting the deployments, trouble shooting issues for QA team.

Environment/Tools: MS Project, DB2, Oracle 9i, Informatica Power Center, Business Intelligence tool: Micro strategy, Claims Processing, Manual Testing, Autosys, MS, Test link, Captiva, Shovel data tools, postgresql, DB2 management studio

Confidential,CA

MS SQL Server Developer

Responsibilities:

• Gathered requirements from business users.
• Developed user requirements documents based on functional specification.
• Designed simplified data modeling solutions using Erwin data modeler.
• Designed DDL scripts to develop database schema and database objects.
• Designed DTS package and scheduled the jobs for batch processing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT Data Mart to build dimensions and load data to fact tables.
• Optimized SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the database performance.

Environment: SQL Server 2000, Visual Basic 6.0, and ASP. NET, Windows NT