SUMMARY

• To obtain a challenging position and further apply my knowledge of business analysis, technology, leading practices, engineering and management to improve efficiency, customer satisfaction, and profitability of both my organization together with those associated with it and to continue the perpetual process of learning and skills enhancement.
• Extensive experience in analyzing and documenting business requirements and system functional specifications including use cases.
• Experience in working with Web Technologies, HTML, XML, Content management, Report design.
• Experience in developing wireframes, story boards and screen designs.
• Excellent knowledge in the analysis, design, and re - engineering of system applications and business processes, using established system analysis, business and system process design, research, and implementation methodologies, diagramming data and process mapping, applying Unified Modeling Language (UML), and the implementation of performance measures.
• Experience in Tableau Administration/development and architecture.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring.
• Experience in creating SQL queries from scratch,and modify/enhance existing SQL queries.
• Practical understanding of OLAP(cubes) and Enterprise Data Warehousing methodologies and concepts, including star, snowflake data models and have implemented BI on top of them
• Experience extracting and manipulating data from relational databases with advanced SQL, stored procedures, ETL tools or other data manipulation language.
• Strong understanding of industry business processes related to service product lifecycle, Quote to Cash, sales, order fulfillment, Order management, Scheduling, Demand planning, billing and service cycle Analytics.
• Experience in architecting tableau environment to achieve high scalability and high availability.
• Experience working with Business Intelligence tools like DOMO, Business Objects (BO), Microstrategy, Tableau 8,9,10 and 10.5 versions, OBIEE.
• Experience working with Oracle, MS SQL server and Teradata.
• Very strong in data visualization and dashboard building using guided analytics.
• Experience in data extraction, manipulation, and presentation experience
• Experience with advanced MS Excel features like Vlookups, Pivot Charts/Tables and formulas
• Adept in written correspondence, reports, implementation requirements, project status reports, oral presentations with PowerPoint etc.
• Self-starter and ability to adapt by learning new things quickly.
• Excellent verbal/written communication skills and can perform well both independently and as a team player.
• Experience working with testing tools like Quality center, Jira and Rally tools.
• Extensive experience in acting as a liaison between client and IT department to relate expectations, oversee progress, and resolve conflicts. Adept at reducing development costs and providing traceability of projects.
• Specialties: Process mapping, use case modeling, Change Management, requirement gathering and data analysis, documentation, project management of software development and implementation, quality assurance testing, Business case preparation, provide user training, Migration Cut over plans, reports development, troubleshooting.
• Ability to quickly master new concepts/applications & identify operational deficiencies and system improvements. Strongly self-motivated, willing to assume responsibilities & very detail oriented. Excellent at communication, analysis & presentation.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, MAC OS, Windows XP/Vista/7

Software Packages: MS Office (Word, Excel, PowerPoint, Visio, Project), Rational Rose.

Programming Languages: HTML,SQL, PL/SQL, T-SQL Java,Python 3.7

Database Servers: MS Access, Oracle 9i/10g,SQL Server05/08, Postges sql

Competencies: Salesforce.com, Siebel CRM, e-Discovery( Litigation Hold, Data Mapping), EDI

Processes/Technologies: Agile, RUP, UR&D, Clear case, Change Management, Use Cases, Workflow, and UML.

BI Tools: DOMO,BO,OBIEE,Alteryx,Tableau 6,7 and 8.1 and 8.2 versions,10.5 QLIK view, Microstrategy

PROFFESIONAL EXPERIENCE

Confidential, San Jose

Business Intelligence Architect/Administrator(Tableau,OBIEE,Alteryx,Oracle,)

Responsibilities:

• Responsible for Architecting/Administering of Tableau/OBIEE and Alteryx tools.
• Responsible for data Modelling, Data integration and creation of data marts.
• Responsible for generating and building sales and marketing dashboards.
• Responsible for Performance tuning of data sources in tableau and RPD’s on OBIEE.
• Responsible for Building and designing Complex dashboards on tableau 10.5 and OBIEE.
• Responsible for performance tuning of workbooks and dashboards on both Tableau and OBIEE.
• Responsible for creating snapshot tables, Aggregate tables and views.
• Responsible for creating dataflows from source systems to target systems via datastage.
• Responsible for writing Complex sql queries on Oracle for data integration and datasources for tableau
• Responsible for scripting using python for automated user provisioning
• Responsible for End to end implementation of Tableau,OBIEE and Alteryx.
• Responsible for providing user trainings and supporting in UAT.
• Responsible for data mapping, data validation from source to target systems.
• Responsible for creating ETL flows.

Confidential, San Jose

Sr BI Data Analytics Engineer/Architect

Responsibilities:

• Responsible for building Analytics using Tableau 10.3 and 10.5 connecting to SNOWFLAKE database.
• Responsible for identifying insights and perform data discovery using data related to customers interactions with Verizon IPTV.
• Responsible for performing ETL using Snowflake database.
• Responsible for connecting to different data sources like MEMSQL, SNOWFLAKE and perform data transformations and build visualizations with the same as per reporting requirements.
• Responsible for performance tuning of dashboards and queries.
• Responsible for maintaining SNOWFLAKE Data sources, tableau server and perform upgrades on tableau server.
• Responsible for building ETL flows and creating tables and up load data from different data sources.
• Responsible for architecting tableau server for high availability, scalability.
• Responsible for migrating back up data to Amazon AWS S3.
• Responsible for generating/creating extracts using Alteryx from source systems MEMSQl and Splunk
• Design and develop ETL workflows and generate extracts using Alteryx etc.
• Responsible for user creation, Project creations and security on tableau server.
• Responsible for Presenting visualizations to all user groups across organizations.
• Responsible for creating GIT repository and source code management.

Confidential, San Ramon

Tableau platforms Engineer/Architect

Responsibilities:

• Responsible for e-e implementation/Administration/maintenance of Tableau Server/worker/Load balancer and development of Tableau reports and dashboards.
• Responsible for Capacity planning and high availability setup.
• Responsible for Resolving architectural and performance related issues on tableau dashboards.
• Responsible for building dashboards connecting to Hive using Hive sql.
• Responsible for Automation of server tasks using PowerShell and Python.
• Responsible for supporting tableau issues across all geos for different stakeholders.
• Responsible for supporting ETL jobs and administering Talend server.
• Responsible for building dashboards by connecting to Pivotal Greenplum, Hadoop HIVE SQL.
• Responsible for troubleshooting and resolving issues related to data and Tableau.
• Responsible for Onboarding new customers and provide training accordingly.
• Responsible for Windows Administration.
• Responsible for working with new customers by doing POC s on their data sources.
• Responsible for setting up Kerberos authentication for tableau server on windows and Mac.
• Responsible for integrating data sources on Amazon web services (AWS) cloud with tableau.
• Responsible for setting up web data connectors on tableau server.

Confidential, San Rafael, Ca

Senior BI Consultant/Architect,

Responsibilities:

• Responsible for end to end implementation/Administration/maintenance and development of Tableau reports and dashboards.
• Responsible for gathering requirements and understanding the source systems to implement Marketing reports and dashboards.
• Responsible for integrating tableau dashboards into webpage/portal using Javascript API.
• Responsible for development of Reports and Dashboards using Tableau.
• Responsible for Automating backups and alerts using Amazon cloud watch.
• Creating users, groups and pages and implementing security on cards.
• Responsible for creating complex queries and calculations in tableau on top of Amazon Redshift
• Responsible for writing SQL queries to pull data from sources.
• Maintaining weekly/monthly/quarterly metrics for topics/projects
• Responsible for pulling data from Amazon Redshift.
• Design an develop ETL workflows and generate extracts using Alteryx etc.
• Responsible for providing training and preparing KT documents.
• Responsible for providing technical support for Tableau internally.
• Responsible for administering servers and automated publishing activities via tabcmd.
• Responsible for Architecting Tableau server for achieving High Availability, High scalability, Heavy extract usage.
• Responsible for data modelling and implementing security on reports for external customers.
• Analyzing and trouble-shooting technical issues related to reporting.

Confidential, San Jose, Ca

Digital marketing data Analyst

Responsibilities:

• Responsible for end to end implementation/Administration/maintenance and development of DOMO/Tableau reports and dashboards.
• Responsible for gathering requirements and understanding the source systems to implement Marketing reports and dashboards.
• Responsible for building social metrics from Facebook, Twitter, LinkedIn, community and YouTube.
• Responsible for development of Reports and Dashboards using DOMO,Tableau.
• Responsible for Building Digital Marketing reports and dashboards.
• Responsible for building SRLS, SALS, SQLS conversion rate, cost per lead metrics.
• Responsible for creating Campaign ROI funnel, Revenue trend, pipeline trend and Marketing influence on revenue by QOQ, YOY, Current quarter and last quarters.
• Responsible for creating users, groups and pages and implementing security on cards.
• Responsible for creating data flows, data fusions, drilldowns and beast mode calculations in DOMO.
• Responsible for creating data sources using domo workbench and pushing on to DOMO server.
• Responsible for writing SQL queries to pull data from sources.
• Maintaining weekly/monthly/quarterly metrics for topics/projects
• Responsible for pulling data from Marketo, google analytics, Google AdWords, Salesforce and excel files to build Campaign ROIs by GEO, Lead source engagements, touches etc.
• Responsible for writing SOQL queries to bring data from Salesforce.
• Responsible for building social metrics from Adobe site catalyst (OMINTURE) using DOMO.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.

Confidential, Pleasanton, CA

Tableau Architect (Lead/Administrator)

Responsibilities:

• Performed requirement analysis of large-scale business systems and translated requirements into Statement of Work, Business Requirement Documents, Use Cases, Functional Specifications, Project Proposals, Testing and Post Implementation Plans.
• Responsible for gathering requirements and understanding the source systems to implement EDW/MDM/BI.
• Responsible for Data Modelling and Data Analysis.
• Responsible for implementing Tableau in distributed environments across organization.
• Responsible for development of Reports and Dashboards using Tableau.
• Responsible for tool evaluation for Data Integration and Data Visualization.
• Responsible for Building Sales, Marketing and Finance reports and dashboards.
• Maintaining weekly/monthly/quarterly metrics for topics/projects
• Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing training to Business users in using Tableau.
• Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
• Design an develop ETL workflows and generate extracts using Alteryx etc.
• Performed administrative and support activities across Tableau infrastructure including security administration, installation, and configuration of Tableau Server.
• Defined best practices during implementation and integration
• Responsible for documentation related to Tableau server architecture and report development.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons.
• Outlined and implemented security at all levels, including the site, project, group, workbook, and user level.
• Refined and enhanced the technical architecture to keep pace with changing business demands and new Tableau software releases.
• Analyzed, troubleshoot, and tuned product performance or deployment issues when required.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.
• Responsible for presenting Weekly release status using PowerPoint.
• Responsible for building Reports/Dashboards related to Sales, Marketing and finance using Tableau.
• Responsible for building Cohort analysis and customer Segment comparison using tableau data visualization.
• Responsible for converting all excel reports in to Tableau reports and dashboards.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Experience in working with Tableau Desktop and Tableau Server.(Versions 6,7 and 8.1)
• Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters.
• Experience in creating Different maps, dual axis charts.
• Experience in creating Dashboards by connecting to different data sources like Google Analytics, Salesforce and different data sources.
• Responsible for installing Tableau server for DEV, QA and Prod environments.
• Experience in using TABADMIN
• Experience in building views using PostgreSQL database
• Responsible for creating sites, users, groups and projects in tableau server.
• Managed multiple parallel projects to identify business goals, envisions the solutions, develop strategy; define project scope, implementation phases, estimate resources and timelines.
• Responsible for the quality of data within Salesforce
• Regularly perform data de-duping and cleanup procedures
• Audit, uncover and resolve data integrity issues
• Support developments to enhance and improve data collected

Confidential, Mountain view, CA

Business/BI Analyst-Tableau Lead

Responsibilities:

• Managed multiple parallel projects to identify business goals, envisions the solutions, develop strategy, define project scope, implementation phases, estimate resources and timelines.
• Evaluated the utilization of autonomous CRM systems to integrate the lead generation, tracking and streamline the sales lifecycle.
• Experience working with Business Intelligence tools like Business Objects (BO), Microstrategy, OBIEE and Salesforce.com.
• Responsible for both functional and non functional requirement analysis.
• Responsible for presenting project scopes and training users on different new functionalities and enhancements.
• Preparing Process Governance and solution governance models using MS Office(PowerPoint)
• Facilitated integration of business requirements, produced functional specifications and design documents, and partook in the implementation of those specifications.
• Consolidated independent CRM systems which reduces data duplication and simplified system interaction.
• Worked on Tableau, to prepare dashboards and do Data Analysis.
• Experience in working with Tableau Desktop and Tableau Server.(Versions 6 and 7)
• Experience in designing and developing dashboards
• Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters.
• Experience in creating Different maps, dual axis charts.
• Experience in creating Dashboards by connecting to different data sources like Google Analytics and different data sources.
• Responsible for installing Tableau server for DEV, QA and Prod environments.
• Experience in using TABADMIN
• Experience in building views using Postgres sql database.
• Responsible for creating sites, users, groups and projects in tableau server.
• Responsible for Providing training to Business users in using Tableau
• Provided database technical support for sales force and managed data integrity: data collection, entry, analysis and tracking.
• Responsible for developing wireframes, story boards, screen designs.
• Served as liaison between business users and project team by assisting the business in identifying, understanding and documenting requirements.
• Gathered and analyzed business processes and customer requirements through surveys, interviews and Joint Application Development (JAD) sessions and translated them into system requirements.
• Executed detailed functional decomposition analysis to redesign the existing process flows for increased efficiency and utility.
• Co-ordinate and manage the Change request Control Process for the project by facilitating one-on-one interviews, group meetings and corresponding through emails with work stream owner to discuss the impact of change request on the project.
• Responsible for generating project plans and updating weekly project status reports.
• Participated in the bug review meetings and updated requirement document as per business user feedback and change in functionalities of the application.

Environment: Tableau, Microstrategy, Siebel CRM, MS Project, UML, RUP, MS Office, MySQL,.net, Rational, Windows 2003/XP, Requisite Pro, JIRA,Rally

Confidential, San Jose, CA

Business/BI Analyst

Responsibilities:

• Performed requirement analysis of large-scale business systems and translated requirements into Statement of Work, Business Requirement Documents, Use Cases, Functional Specifications, Project Proposals, Testing and Post Implementation Plans.
• Maintaining weekly/monthly/quarterly metrics for topics/projects
• Identifying data for any new projects/analysis and Responsible for data quality, accuracy and timelines.
• Data backup and up to date data maintenance, Testing and verification of data
• Ability to summarize millions of transactions within limited time
• Provides meaningful analysis based on available data
• Deep dive into data to perform multilevel analysis and Foresee further analysis and be ready and Communicate any delay or challenges
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Experience working with Business Intelligence tools like Business Objects (BO), Microstrategy, OBIEE.
• Experience in working with Tableau Desktop and Tableau Server.(Versions 6,7 and 8.1)
• Experience in designing and developing dashboards
• Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters.
• Experience in creating Different maps, dual axis charts.
• Experience in creating Dashboards by connecting to different data sources like Google Analytics, Salesforce and different data sources.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Experience in creating Dashboards by connecting to different data sources like Google Analytics, Salesforce and different data sources.
• Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing training to Business users in using Tableau.
• Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.
• Managed multiple parallel projects to identify business goals, envisions the solutions, develop strategy; define project scope, implementation phases, estimate resources and timelines.
• Experience with creating advanced reports in Salesforce.com.
• Responsible for the quality of data within Salesforce
• Audit, uncover and resolve data integrity issues
• Strong understanding of Salesforce.com best practices, security, and functionality.
• Experience in Process governance and SIPOC process.
• Prepared Project scope documents and story document to prioritize the scope items for next releases.
• Responsible for partnering with Customer Support to develop a roadmap for new initiatives.
• Accountability for project scope, schedule, and quality of releases in alignment with strategic business initiatives.
• Designing and delivering scalable Salesforce.com solution utilizing Knowledge, Communities, and Communities technologies.
• Experience in Seeking out innovations in process improvement, better utilization of resources, product enhancements, improved communications and faster issue resolution.
• Experience Preparing user training materials (e-learning, job aides, user manuals)
• Responsible for preparing business case for new project or scope items.
• Good Working knowledge on Excel, PowerPoint and Visio to generate reports, presentations and Process flows.
• Have Knowledge on IB 360(Data repository of Opportunity info and Install base details from Teradata) and front end Qlikview which users use to do analysis of data.
• Facilitated integration of business requirements, produced functional specifications and design documents, and partook in the implementation of those specifications.
• Devised and prepared concise and effective User Stories
• Interacted with the “End-Users” by interviewing them and preparing appropriate questionnaire to better understand their needs
• Managed client expectations on all project deliverables and requirements, while working with cross-functional teams
• Identified Use Cases from requirements. Created UML Diagrams including Use Case Diagrams, Activity Diagrams/State Diagrams, Sequence Diagrams, and Collaboration Diagrams using MS-Visio
• Worked with project teams in preparing functional requirement specifications (FRS), software design documents (SDD) and user interface design
• Experience with data warehouse as Business Analyst
• Responsible for providing requirements by working with end-users to identify, understand, assess, prioritize, document and communicate requirements, risks, dependencies and potential roadblocks.
• Responsible for both functional and non-functional requirement analysis.

Environment: Quality Center, Water fall methodology, Oracle 10g, PL/SQL, Windows7, BAVA tool, TOAD, CITRIX