SUMMARY

• Over 8 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and teh 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 halp users to identify critical KPIs and facilitate strategic planning in teh 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 teh 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 teh 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 teh requirements and identifying teh key performance metrics for teh 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 teh developers to create views and dashboards in Tableau Desktop.
• Created complex LODs and Table calculations for teh 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 and bullet graphs.
• Setting user access, creating new Schedule's and checking teh task's daily on teh 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 TEMPeffectively used data blending feature in tableau.
• Good SQL programming skills with teh 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 teh Tableau Server Home page and designed own Reporting landing Page to give teh 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 teh data on teh fly with teh usage of quick filters for on demand needed information.
• Involved in adding user’s to teh Tableau Server and licensing teh user’s based on their role in teh project.
• Created User Groups based on teh user role in teh Project and provided teh Access to teh Groups.
• Created Different Schedules based on teh requirement and used to create tasks to refresh and Subscriptions to teh reports.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Tested dashboards in Development Environment to make sure data was accurate as per teh business requirements before moving teh Reports to Production.
• Worked on Tableau Server Customization to make user comfortable with look and feel of teh 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 teh Business users to understand teh business and convert teh 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 implement content security for site, project, and object with windows AD integration.
• Developed dashboards inTableauDesktop and published them on toTableauServer that allowed end users to understand teh data on teh fly with teh 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 teh best fit for a given business requirement.
• Created various complex SQL queries, calculated fields using Table Calculations functions (TEMPEffective and Relative Compute Using), Aggregate functions, Date functions, Logical functions, Windows functions, 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 teh performance of visualization calculation inTableau Dashboards.
• 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 teh Enterprise Data Visualization Architecture
• Actively involved as part of a team for gathering and analyzing teh 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 teh business logic.
• Designed, Developed, and integrated stored procedures to generate teh special reports according to client’s need.
• Interacted with teh users and troubleshooting teh problems involved with teh reports, dashboards and problems related to teh 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 teh quality of data from various sources.
• Worked on teh Business Intelligence tool evaluation process and presented findings and recommendations on Tableauas a reporting tool to teh 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 teh same on Tableau Server.
• Extensively worked on creating calculated fields and Analysis functions depending on teh 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 teh 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 teh best process distribution for different projects.
• Mentored power users in Tableau dashboard development.
• Build test cases and tested teh Reports/Dashboards by comparing teh SQL Output on teh Data warehouse to teh values in teh Reports/Dashboards, documented teh test results.
• Performed Unit testing, integration testing to verify teh 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 teh functional design for teh 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 teh project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Oversee teh performance of Design to develop technical solutions from Analysis documents.
• Designed teh conceptual data and business process models.
• Identified teh key facts and dimensions necessary to support teh business requirements. Develop teh logical dimensional models.
• Make use of data modelling techniques in designing teh data marts.
• Created data mapping/ source to target mapping documents to facilitate ETL development.
• Assisted teh DBA in converting teh logical models to physical.
• Conduct Design discussions and meetings to come out with teh 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 teh 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 teh data restored is correct.
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Monitoring teh project during Development phase and involved in User acceptance testing (UAT) once teh change requests are released from system testing.
• Deployment of defect free code while managing teh timeline set for teh project.
• Confer periodically with both business unit and technical programmers throughout teh increments in entire lifecycle of teh project in order to track progress, identify changes and ensure changes are communicated to both teh 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 teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Translated teh business needs into system requirements by communicating with teh business on non-technical level and with teh 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 teh scope of teh project, gathering business requirements, doing gap analysis and documenting them textually or within models
• Gathering and documenting teh requirements that are critical to teh business mission and using those requirements to design application software.
• Modeled use-case diagrams in Rational Rose to show end-user interaction with teh 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 teh application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for teh 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 teh 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 teh 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 teh project on teh 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 teh fee structure and fee models for teh 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 teh expiration dates and updating teh 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 teh development of new requirements
• Coded and tuned Oracle PL/SQL and SQL throughout teh development wherever needed
• Created Job schedulers using DBMS job schedule for generating billing at defined intervals
• Created test cases
• Conducted unit testing for teh modules created

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