SUMMARY

• Certified Tableau professional with 8+ years of IT Experience in Business Analysis, Data Warehousing, Data Mining, Data Analysis focusing on Design, Development, Implementation and Testing of Business Intelligence and Data Analytics applications.
• 4+ years of experience in data discovery, data visualization, data analysis, and report development using various versions of Tableau (Desktop/ Server/ Public/ Reader/ Online) (9.x/8.x/7.x).
• Expertise in interacting with end users, functional/technical experts and identifying, analyzing and developing the reports that meet the business needs.
• Experienced in all activities of full life cycle implementation including Requirement analysis, Data Modeling, Design, Specification development, Reporting, Web publishing, Portal integration, Performance tuning, Testing, Documentation.
• Proficient in conducting Gap Analysis, Designing data flows and communicating the trade - off decisions on product features based on technology and customer requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Hands on experience in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Extensively providedtechnicalandanalyticalexpertise in responding tocomplex,specializedreport requests requiringhigher-level data analysisanddata management services.
• Incrementally delivered Business Process Data Marts (Greenfield) that enjoy continued uptake throughout the Reporting, Operations and Management areas
• Delivered and managed Data Dictionary (Greenfield) to unify Business and Technical Definitions of Business Elements.
• Expertise in analysis, design and implementation of database applications using Teradata, Netezza, DB2, Oracle and SQL Server database technologies.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
• Strong knowledge of business/process data flow in organizations and experienced in data modeling Concepts.
• Experience in working on development of Business Objects Web Intelligence, Desktop Intelligence Reports.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center as ETL tool on Oracle, DB2 and SQL Server Databases.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization,Business ProcessAnalysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Excellent communication, interpersonal and analytical skills with ability to manage and work effectively to meet deadlines in fast paced environment.

TECHNICAL SKILLS

Analytical Tools: Tableau 10.x/9.x/8.x/7.x (Desktop/Server/Public/Reader), Business Objects, SSRS

ETL Tools: Informatica, DataStage, SSIS

Databases: Teradata, Netezza, Oracle, SQL Server, MS Access

SQL Tools: Toad, Teradata SQL Assistant, PL/SQL Developer

Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

Scripting Languages: PL/SQL, SQL, Unix shell scripting, Java, C, HTML, XML

Testing Tools: Mercury Test Director, IBM Rational Tester, QTP

Operating Systems: UNIX, Linux, Microsoft 2008/2003

Others: AutoSys, Amazon Redshift, Control M, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, La Mesa, CA

Data Modeler / Tableau Developer

Responsibilities:

• Use the available education system data from multiple sources including: student information systems, assessments, human resources, state test, other education technology tools and behavior management systems to create dashboards on the business intelligence tool Tableau in order to help educators better understand relationships between various factors and educational outcomes.
• Conducted data cleaning and Tableau analysis on enrolled students to track their performance and generated insights which were used to inform strategic recommendations on improving student’s performance.
• Conducted weekly reporting and analysis on key performance metrics of the district demographics to examine performance trends across the district and present results to key stakeholders, providing guidance on how to use the data to make strategic decisions.
• Newly Implemented environment with rapidly changing directives and customer needs, Collaborated with the DBA to develop data marts specific to projects. Data marts will be eventually provided to teammates and users both as OLAP cubes and SQL views built from the underlying star and snowflake schemas.
• Worked on all stages of the data warehouse development lifecycle: gathering requirements, data structure design, development of ETL (Extract Transform Load) processes, and ongoing support.
• Developed automated processes utilizing BI tools to integrate data across key systems, simultaneously increasing data quality and eliminating the need for manual work.
• Designed actionable Tableau data quality reports that are used daily by district and school administrators.
• Provided ETL and data analytics support for Ed Tech Services at Grossmont, leveraging BIML, SSIS, and Tableau.Monitored daily refresh of the published data on the Tableau server. Created and ran stored procedures for the automation of jobs on the SQL Server. Collaborated with users which include Principals, Teachers, Executives and department staffs to analyze user requirements.
• Lead projects with time sensitive data reporting requirement by automating the complete reporting process starting from collection of data down to the delivery of the information in different formats using the subscription and data driven alerts features using different BI tools such as SSRS and Tableau.
• Trained all levels of users, developers on the use of developed products and as well as developing process of BI tools.
• Implemented user level filter setting to provide different data access permissions to District Administrators, School Administrators, Teachers and other departmental specific users.
• Configured the Tableau server with the version updates, new feature releases, automated process with use of REST API.
• Validated the dashboard performance against the SIS to QC the data accuracy of the dashboards.

Environment: Tableau (Desktop/Server/Prep/Public) 10.x/9.x/8.x, SQL Server, Java API, SQL, Microsoft Office Suite, Infinite Campus, PeopleSoft, Business Plus, Alteryx, Talend, Microsoft Server Data Tools

Confidential, Atlanta, GA

Tableau Developer/Data Modeler

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.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Developed dashboards by extracting data from different sources in Tableau using parameters, sets, groups and calculations.
• Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as DB2, Oracle, and MS Excel.
• Extensively used data blending in Tableau to integrate data from different sources.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Performed Tableau Server admin duties; add users/groups from Active Directory; instances in Tableau Server.
• Enabled authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.

Environment: Tableau (Desktop/Server) 9.x/8.x, Oracle, DB2, SQL Server, Java API, SQL developer, Informatica, SQL, Microsoft Office Suite.

Confidential, Palo Alto, CA

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked as Tableau developer/SME in standardizing Tableau for shared service deployment.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Worked with Tableau administrator in installing Tableau Server in Dev, QA, UAT and Prod environments.
• 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.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPad, iPhone, and other smart mobile phones.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• 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.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: s: Tableau (Desktop/Server), SAS, IBM DB2, Windows Server, ClearQuest, ClearCase, Oracle 11i, Netezza, Excel, JAVA, J2EE, TSQL, UNIX, Linux.

Confidential, Greenwood Village, CO

Data Analyst/ Data Modeler

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.
• Involved in creating interactive, parametrized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop /Server), Oracle, SQL Server, DB2, SSIS, SQL, Toad, Unix, MS VISIO, Control-M, Erwin, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Providence, RI

Business Systems Analyst

Responsibilities:

• Interacted with Functional/End-users to gather requirement for core reporting system by understanding exceptional features and created Business requirement package (BRP’s) to successfully implement Business logic.
• Conducted JAD sessions with users and business clients to gather specific requirements and expectations and implement effective Data Modeling and ETL design.
• Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mockups for reporting.
• Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing / verification.
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Developed source to target data mapping document containing all the Business required fields along with the source rules, target rules, database, table names and transformation rules.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Designed various analytical reports, dashboards in SSRS on Sales, Finance data as per end user requirement.
• Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.

Environment: Oracle, SQL Server,SSIS, SSRS, ERwin, TOAD, SQL, Share Point, TFS, Agile-Scrum, UNIX, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook).

Confidential

Systems Analyst

Responsibilities:

• Involved in interacting with the Business Users and the Business Analysts to understand the requirements for development.
• Preserving quality data by implementing team-wide standard and independent QA processes, maintaining proprietary data collection programs, and resolving any data anomalies.
• Understanding core products by researching industry trends, knowing the base data used in all delivered reports, and keeping track of current and potential clients.
• Ensuring all deadlines and responsibilities are met.
• Effectively understanding and conveying the business issues and data challenges of both internal and external clients, as well as the industry as a whole.
• Translating questions and problems from clients into an analysis and solutions.
• Performing in-depth, cross-team feasibility checks.
• Utilizing current industry trends in order to create new analyses and products that are useful to clients.
• Becoming an expert in comScore Marketing Solutions products as well as the comScore syndicated product suite.
• Successfully coordinating between multiple internal teams and third-party data vendors to create and fully realize a new product or suite of reports.
• Meeting with external clients as needed.

Environment: SQL Server 2005, MS Excel, MS Access, Enterprise Manager, Management Studio, SQL Profiler,SSRS, Microsoft Office Suite.