SUMMARY

• Over 8 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Certified Tableau Desktop Qualified Associate with extensive experience inTableau Desktop, Tableau Server,Tableau Reader and Public in various versions (10.x/9.x/8.x/7.x) of Tableau.
• Expertise inRequirements gathering/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Proficient in Building compelling, interactive dashboards inTableauthat answer key business questions.
• Extensive experience in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• EstablishedBest Practicesfor EnterpriseTableauEnvironment and application intake and development processes.
• Outstanding experience in creating different visualizations using Bars,Area, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps, Box and Whisker Plots,Highlight tables, and other making use of Calculated fields,Actions, Parameters, Sets,Quick, Context,and b according to the end user requirement.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations Expertise in using Trend Lines, Statistics, and Log Axes, Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Expert in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Good experience on LOD expressions Comparative Sales Analysis, Customer Acquisitions, etc.
• Hands on experience in creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Strong experience inTrouble Shooting, Performance tuning of reportsand resolving issues withinsource data and reports.
• Expert in writing SQL Queries using joins, derived tables, sub - queries, correlated subqueries for validating data on reports and also for generating data extracts to suffice source data requirements in Tableau.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas.
• Outstanding data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems and generating analytical reports/dashboards.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Demonstrated ability to self-motivate and be flexible within a fast-paced environment

TECHNICAL SKILLS

BI Tools: Tableau (Desktop/Server/Reader/Public)10.x/9.x/8.x/7.x, MicroStrategy, SSRS

ETL Tools: Alteryx, Informatica, DataStage, SSIS

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint, Excel)

RDBMS: Teradata, Hive,Oracle, SQL Server, DB2, Sybase, MS Access

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

Change Management: HP Open View, CA Service Manager

Document management: SVN, GIT, Visual Source Safe, Share point, Ultra Edit, Documentum

Defect management tool: HP Quality center, Remedy

Programming Languages: HTML, SQL, PL/SQL, XML, javascript, Python

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr.Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in gathering the requirements and identifying the key performance metrics for the end users.
• Designed new data sources for developing analytical reports from multiple data sources like Microsoft SQL Server, SharePoint, Excel and Service now.
• Designed and Developed new reports / dynamic dashboards and enhancements to existing reports and capabilities in alignment with business needs.
• Created innovative dashboards that are visually appealing and showcases a powerful story
• Involved in working with and mentoring the developers to create views and dashboards in Tableau Desktop.
• Created complex LODs and Table calculations for the reports and blended data from different Excel files.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Worked on designing and developing various reports using different chart visualizations like Gantt charts, bar graphs, pareto charts andbullet graphs.
• Setting user access, creatingnew Schedule's and checking the task's daily on the Tableau server.
• Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server to tableau.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Good SQL programming skills with the ability to create SQL views and write SQL queries

Environment: Tableau 10.0 (Desktop/ Server), MS SQL Server, SharePoint, SQL,ServiceNow, Microsoft Office Suite (Word, Access, Excel, Outlook, PowerPoint).

Confidential, Monroe, MI

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources from Apache Hive, Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Customized the Tableau Server Home page and designed own Reporting landing Page to give the user feel of a web portal.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Created dashboard using parameters, sets, groups and calculations.
• Assisting users in creating and modifying worksheets and data visualization dashboards.
• Created several types of visualizations using Sets, dynamic sorting etc.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Apache Hive, Oracle SQL Server and MS Excel.
• Utilized Alteryx to integratedata frommultiple databases into a DW data model.
• Actively involved in testing new/upgraded features like new analysis tab, Level of Detail expressions, Data Interpreter, Split function, smart Geo maps, etc. in Tableau 9.0
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Involved in adding user’s to the Tableau Server and licensing the user’s based on their role in the project.
• Created User Groups based on the user role in the Project and provided the Access to the Groups.
• Created Different Schedules based on the requirement and used to create tasks to refresh and Subscriptions to the reports.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards in Development Environment to make sure data was accurate as per the business requirements before moving the Reports to Production.
• Worked on Tableau Server Customization to make user comfortable with look and feel of the portal by using Tableau Database.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: Tableau9.x/8.x (Desktop/ Server),Hive,Alteryx, Oracle, SQL server, SQL, UNIX, SQL developer, CA Service Manager, Microsoft Office Suite (Word, Excel, PowerPoint)

Confidential, West Chester, PA

Sr.Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Worked with the Business users to understand the business and convert the business requirements into technical specification documents.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Used Data Densification features like turning on and turning off Domain Completion and Domain Padding.
• Increased extract performance by aggregating data and rolling up dates when creating extracts.
• Implemented responsive web design by using Vertical and Horizontal containers in dashboard.
• Worked with Tableau Administrator to implementcontent security for site, project, and object with windows AD integration.
• Developed dashboards inTableauDesktop and published them on toTableauServer that allowed end users to understand the data on the fly with the usage of quick filters for on demand-needed information.
• DevelopedTableauvisualizations to support ad-hoc analysis.
• Designed and developed different visualizations like side by side bars, Scatter plots, Stacked Bars, Heat Maps, Geo Maps ( Summary and Detail), Pie, Line, Area, etc. depending on the best fit for a given business requirement.
• Created various complex SQL queries, calculated fields using Table Calculations functions(Effective and Relative Compute Using), Aggregate functions, Date functions, Logical functions, Windowsfunctions, etc. for solving complex business issues and solved Optimize issues in Dashboards.
• Worked extensively with Advance functionalities like Actions, Background Images, Page Navigation, Filters (Quick, Global, and Context), Parameters, Groups, Hierarchies, Sets, Bins etc. to facilitate advance analytics to Business Users.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Created story points to provide clear insight of dashboard usage.
• Implemented user level and row-level security to define data access restrictions for users.
• Responsible for Deploying and Maintenance ofTableauDashboards on Server
• Created a TDE files to improve the performance of visualization calculation inTableauDashboards.
• Schedule TDE Reloads on Server and Troubleshoot errors and failures.
• Responsible for Deploying and Maintenance of dashboards onTableauServer.

Environment: Tableau 8.x (Desktop/ Server), Teradata, SQL,Teradata SQL Assistant, Documentum, SharePoint, Lotus Notes, MS Office Suite (Word, PowerPoint, Excel, Visio).

Confidential, Charlotte, North Carolina

Tableau Developer / Sr. Data Analyst

Responsibilities:

• Involved in System Analysis & Design of the Enterprise Data Visualization Architecture
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.
• Involved in extensive client interaction in understanding report requirements, documenting Business Requirements, converting user requirements into functional and technical requirements.
• Responsible for all technical aspects of analyzing, modeling, integrating, testing, and creating prototype, Reports and Dashboards using Tableau.
• Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks for Confidential ’s Analytical Projects and Data Visualization teams.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Designed and implemented near-real-time monitoring Dashboards for Tableau Server and Visualization users.
• Designed Self-Refreshing Activity Monitoring Dashboards for Information Analytics & Innovation Portal
• Prototyped Visualization of Time Series and Data Transparency in tableau for customer, Plan and benefits data Integration.
• Optimized Tableau Workbooks and Background Tasks for Targeted Interactions Analytics.
• Successfully administered user, user groups, and scheduled instances for reports in Tableau.
• Improved performance by tuning Operational Dashboards for Oracle and SQL Server based Data Warehouse
• Defined best practices for Tableau report development.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Worked on various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
• Designed, Developed, and integrated stored procedures to generate the special reports according to client’s need.
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance

Environment: Tableau 8.x/7.x ( Desktop/Server), SQL Server 2008/2012, Oracle, SQL SSIS, HP Open View, Microsoft Office Suite ( Word, Excel, PowerPoint)

Confidential, Newark, NJ

BI Analyst/ Data Analyst

Responsibilities:

• Liaison for project managers, managers, directors, and stakeholders.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Designed reporting database layers which consolidated data from multiple data sources ensuring data consistency and data quality by handling basic data cleansing and standardization of data elements
• Performed Data Profiling to assess the quality of data from various sources.
• Worked on the Business Intelligence tool evaluation process and presented findings and recommendations on Tableauas a reporting tool to the management.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Designed and developed various reports and dashboards as per user requirements using Tableau Desktop and published the same on Tableau Server.
• Extensively worked on creating calculated fields and Analysis functions depending on the user requirements.
• Extensively used advanced filtering capabilities for creating Dashboards.
• Worked on Tableau reports/ dashboards in Tableau 7.0 using various functionalities like global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Worked on design and development of Tableau visualization solution.
• Designed and developed various reports using different chart visualizations like Line diagrams, Bar, Pie, Area, Geo Maps, Crosstab etc., to assist business users in making strategic decisions to further improve existing campaigns.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Mentored power users in Tableau dashboard development.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.

Environment: Tableau 7.X (Desktop/ Server), Teradata, SQL Server, TOAD, PLSQL Developer, SQL Developer, Informatica, Microsoft (Word, PowerPoint, Excel, Outlook).

Confidential, New York, NY

Data Analyst/ Business Systems Analyst

Responsibilities:

• Played a key role in gathering and documenting Business requirements.
• Conducted Requirement walk-through meetings with key stakeholders.
• Participated in technical walk-through meetings to develop the functional design for the implementation.
• Performed detailed requirement analysis and created data mapping documents
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Designed the conceptual data and business process models.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modelling techniques in designing the data marts.
• Created data mapping/ source to target mapping documents to facilitate ETL development.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Designed and developed mappings and workflows in Informatica to extract data files for third party vendors.
• Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
• Involved in modifying Teradata stored procedures and performance tuning of various tables.
• Assist business partners in decision-making, by analyzing the reporting process from end to end.
• Worked with MicroStrategy Architect to create Facts, Attributes, Relationships and Hierarchies.
• Perform application testing loading, reporting interfaces to BDW to verify all systems are in place and operational and the data restored is correct.
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
• Deployment of defect free code while managing the timeline set for the project.
• Confer periodically with both business unit and technical programmers throughout the increments in entire lifecycle of the project in order to track progress, identify changes and ensure changes are communicated to both the business unit and technical staff.

Environment: Teradata, Oracle, ERwin, Informatica Power center, MicroStrategy(Desktop/ Web)SQL Plus, SQL Developer, Teradata SQL Assistant, TOAD, SQL, MS Office (Word, PowerPoint, Excel).

Confidential, Richardson, TX

Business Systems Analyst/Data Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Worked with users and coordinated with actuate developers to understand and capture data/reporting requirements.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Worked with Project team to determine technical and development impact of a project.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
• Modeled use-case diagrams in Rational Rose to show end-user interaction with the personal information, loan information & property information modules.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• 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.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Designed and developed a business intelligence dashboard using SSRS, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales across different markets.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using SSIS.
• 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: MS SQL Server, SQL Server Management Studio, SSIS, SSRS, Power Designer, MS VISIO, Microsoft Office Suite (Word, Access, Excel, Outlook, PowerPoint).

Confidential

Software Engineer

Responsibilities:

• Involved in developing the fee structure and fee models for the billing module
• Participated in technical review meetings and involved in creating technical, functional specification documents
• Responsible for performance fine-tuning of queries
• Extensively used error and exception handling techniques for validation purposes in code
• Responsible for looking the expiration dates and updating the AQ messages
• Created and maintained triggers for maintaining history for auditing purposes
• Involved in writing complex queries for generating different billing reports as per client needs
• Created shell scripts for loading data using SQL* Loader
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
• Used Toad extensively to debug, test SQL and PL/SQL scripts, procedures, functions, triggers
• Create and develop highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures
• Involved in Oracle PL/SQL code review and modification for the development of new requirements
• Coded and tuned Oracle PL/SQL and SQL throughout the development wherever needed
• Created Job schedulers using DBMS job schedule for generating billing at defined intervals
• Created test cases
• Conducted unit testing for the modules created

Environment: SQL Server, KSH, DBI/DBD, PL/SQL, Oracle 9i, Sun Solaris, Windows, Toad.