SUMMARY

• 8+ years of IT experience in Data analysis, Tableau developer, Business System Analysis, Implementation and Maintenance of Business Intelligence and Data Warehousing.
• More than 5 years of TableauExperience in enterprise environment including report / dashboard design, development, maintenance and support using of Tableau Desktop and Tableau Server.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.2,9.x, 8.x, 7.x and other BI technologies like Business Objects.
• Highly Proficient in Agile, Iterative, and Waterfall software development life cycles.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• In depth understanding of the Gap Analysis i.e., As - Is and To-Be business processes and strong experience in gathering requirements and converting these requirements into Technical Specifications documents.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements.
• Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, custom geo coding, Actions, LOD, Adhoc Calculations, etc.
• Integrated Tableau into Front-End Web Application using JavaScript API to call parameters and filters as well as individual sheets.
• Strong understanding of application development, Software Development Life Cycle (SDLC) methodologies with in depth understanding of gathering requirements, Analyzing, Development and part of pre-and post-production support of various software development.
• Time tested ability working with scrum development team that are self-organized and cross-functional teams. Extensive experience in handling disputes as well as resolve it in a robust and productive manner.
• Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Alteryx, Informatica, MicroStrategy, Tableau and Database technologies.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleaning and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Possess strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

TECHNICAL SKILLS

Databases: SQL Server 2012, MS Access, Oracle 9i/12

Visualization Tools: Tableau, Qlikview, Power BI

Business Intelligence Tools: SAS Enterprise Miner, XL Miner, Cognos, SAP Business Objects

Methodologies: Agile, Waterfall, RUP, RAD

Software Applications: MS Visio, Toad for Oracle

BI Tools: ETL, Informatica, SSIS, SSRS

Modeling Tools: MS Visio, iGrafx, Rational Rose

Requirement Management: RTC, DOORS, VersionOne

Process: Use Case Diagrams, Activity Diagrams, State DiagramsOthers MS Project, MS Office, Teradata, DB2, STAR Team, IBM, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

Tableau Developer / Data Analyst

Responsibilities:

• Analyzed requirements and provided optimized system solutions and system design documentations, developed detailed project plans and tracked the performances, managed and controlled the scope.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Gathered SSRS reports requirements and created in Tableau.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL Server to tableau.
• Hands on experience implantation proactive tableau environment health check, performance threshold alerting and automating redundant Tableau maintenance activities.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Effectively used data blending feature in Tableau.
• Experience in creating Business Impact Analysis strategies for client’s applications.
• Developed automated processes to support statistical analysis and data-mining using Excel and SQL.
• Developed predictive models, applied statistical and machine learning methods for trend and anomalous patterns detection.
• Strong communication and stakeholder management skills
• Experience in conducting Business research and solving business problems.
• Developed Reporting and Procedural Standards.
• Experience BRAC Security models on BI layer.
• Able to design and develop in PostgreSQL, Informatica ETL and Oracle PL/SQL
• Recognized and resolved the issues related to client methodology and support.
• Created a Multidimensional database for generating automated reports using SSAS
• Conducted review sessions on a regular basis with Quality Assurance and development teams for preparing status and delivery of operational reports.
• Participated in contract renewal process by analyzing and translating client demands into efficient software solution.
• Able to design and model Postgresql based data structures
• Tested Business to business connectivity using Oracle’s Siebel CRM system and enhanced Trouble to resolve journey of a passport and visa client.

Environment: Tableau, Alteryx, Google Analytics, SQL, PostgreSQL, Oracle, MS Access, Microsoft office Suite (Office, Excel, PowerPoint)

Confidential, Cincinnati, OH

Tableau Developer /Data Analyst

Responsibilities:

• Worked according to the software development life cycle.
• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to server.
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
• Effectively used data blending feature in Tableau and Developed formatted, complex reusable formula reports.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Able to performance tune the environments
• Experience in creating Business Impact Analysis strategies for client’s applications.
• Developed automated processes to support statistical analysis and data-mining using Excel and SQL.
• Developed predictive models, applied statistical and machine learning methods for trend and anomalous patterns detection.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (Customer).
• Interacted with the sampled customers to know their viewpoint of what an online application has to offer them and designed use cases based on it.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
• Knowledge of Teradata would be an added advantage
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Implemented SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Developed PL/SQL Business Functions and calling into the Cognos Tools Designed and Developed Power Prompts for Web Users For Flexible Querying.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Involved in defining the source to target data mappings, business rules, and business data definitions.
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse.
• Worked extensively with the ERwin Model Mart for version control
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Document various Data Quality mapping document. Perform small enhancements (data cleansing/data quality).
• Performed data analysis on the existing data warehouse’s of AFS, ACBS and infolease.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment: Tableau Desktop 9.0/8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel, MS Office 2007, MS Visio 2003, Cognos, Agile, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook.

Confidential, Palo Alto, CA

Business System Analyst / Tableau Developer

Responsibilities:

• Contributed to the overall execution, communication, and control of the project
• Employed Rational Unified Process (RUP) framework for efficient execution of the project
• Conducted JAD sessions with business stakeholders for gathering requirements for the new upgraded platform; estimated project resources, timing, and sequence of deliverables
• Used UML/Object-oriented design to gather and document business and system requirements; prepared entity relationship diagrams, class diagrams, and activity diagrams to supplement written documentation
• Automated monthly excel reports into Tableau workbooks and dashboards.
• Consolidated multiple Tableau workbooks into a single workbook for the company sales division for a better understanding of data at glance.
• Wrote test plan and executed various levels of User Acceptance and Operational Acceptance testing using test cases to prove that the system conformed to specifications of business and quality requirements
• Able to design and develop in PostgreSQL, Informatica ETL and Oracle PL/SQL
• Worked with technical leads on service delivery teams to update operational procedures and resolve all issues pertaining to operational readiness.
• Hands-on development in assisting users creating and modifying worksheets and data visualization dashboards.
• Well documented the entire process of working with Tableau desktop and in evaluating business requirements.
• Worked on QA documentation and submitted it for accuracy and compliance.
• Involved in logging defects on HPQC.

Environment: s: Tableau Desktop, MSBI Tools (SSRS, SSAS, SSIS), Microsoft Office, Oracle, SQL developer, Microsoft SQL server Management studio, Rational Rose, MS Visio, Mercury Quality Center, HPQC, MySQL

Confidential, Minneapolis, MN

Business Analyst/ Business System Analyst

Responsibilities:

• Understanding the business process workflow and requirements gathered in the inception phase of the project. Used MS Visio and Enterprise Architect for the modeling.
• Performed detailed requirements analysis and data analysis, created visual representation of dataflow process and architectural design of the application.
• Prepared the Business Requirement List (BRL) and the User Requirement List (URL).
• Studied the business and technical process flows and modeled the as-is and to-be scenarios. Conducted Gap analysis and Impact analysis of the to-be model.
• Coordinated with the vendor business team and acted as a liaison in building a fully integrated Client system.
• Documented User Requirements with MS Word and Quality Center as editing tools. Created High level Use Cases, and developed detailed Scenarios and Sequence diagrams describing how actions are to be carried out.
• Worked with development team to create design documentation related to system specifications including components like balances, account details, user interfaces, security and control, performance requirements, and data conversion.
• Collaborated with the users on User Acceptance Testing (UAT) and facilitated error tracking and correction.
• Closely worked with QA team in delivering detailed Test Plan, Test Cases and Scripts.
• Developed and documented training manuals and materials.

Environment: SQL, Oracle 12, MS SQL, SQL Server, Jira, PL, MS Visio, MS Project, Documentum, Epic, Onbase, SharePoint, HP Quality center and ALM, Rational Requisite Pro, MS Office, MS Access, Excel.

Confidential, NY

Data Analyst

Responsibilities:

• Involved in the meeting with Business process owners and SME (subject matter experts) for Requirements gathering in definition stage.
• 24x7 Production database and applications support.
• Installed, configured, and maintained Oracle 10g.
• Upgraded databases from Oracle 9i, 10g to 11g.
• Took the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports.
• Performed data loads and routine updates on an ongoing basis.
• Develop database application forms using oracle in coordination with SQL tables and stored procedures.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Monitored progress against business functionality, requested objectives to ensure that projects meet the specific release criteria.
• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Facilitated the Customer in defining the high level functional requirements and needs.
• Wrote use cases and Activity Diagrams.
• Developed test plan, test scenarios, test cases, test scripts and traceability matrix
• Worked directly with software engineers to ensure clear communications on requirements and defect reports.
• Interacting with other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.

Environment: SQL, MS Excel, Microsoft Project, Oracle, SQL Server, Jira, MS Visio,, MS Word, MS Access, EPIC, FACETS, Rational Rose, and Rational Requisite Pro.