SUMMARY: -

• 7Years of total IT experiencein Business Intelligence solutions with expertise in Tableau BI Products (Tableau Desktop, Tableau Server and Tableau Reader)
• Worked on latest in-memory Analysis, data analysis, data visualization and data discovery tools such as Tableau BI 7x/8x.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Experience in designing stunning visualizations usingtableausoftware and publishing and presenting dashboards on web and desktop platforms
• Consistently delivered results in various stages ofSoftware Development Life Cycle(SDLC).
• Expert level with developing Scorecards and Dashboards in Tableau following best practices.
• Have been working with various data sources such asOracle, SQL Server, Teradata,ODBCand flat file sources.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableauServerandReports.
• Experience inInstallation, Configuration and administrationofTableauServer in amulti-serverandmulti-tierenvironment.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Experienced in Business Intelligence (Cognos), Data Warehousing and Dashboards.
• Develop and deliver dynamic reporting solutions using SQL Server 2005/2008/ Reporting Services (SSIS/SSRS)
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Expertise in using Version controllers likeTFS, Visual SourceSafe andClear Case.
• Involved in various activities of the Software Life Cycle in Tableau suite of products.
• Self-starter with drive, initiative and a positive attitude.
• Strong analytical & good communication skills.
• Hands on experience with BI projects, KPIs, Scorecards, Dashboard design and managing end user experience
• Strong familiarity with Hadoop, Cassandra, Hive and Pig as well as ERP systems like Oracle EBS R12 and JDE
• Expert SSIS, SSAS, SSRS
• Data mining and quality assessment skills

TECHNICAL SKILLS:

Specialties: Data Visualization, Business Intelligence (BI), Software Management andData Collection.

BI Tools: Tableau7.0,Tableau8.0/8.1,Cognos 8.4/10.1, Informatica

Data stage, Microsoft SQL Server: Relational Database

Server 2008/2005,: Oracle 8i/9i/10g/11g, MS- Access, DB2, Teradata.

Tools and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio

Scripting Languages: SQL, PL/SQL, C, C#, Java, HTML, XML, XSL

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Tableau Developer/SQL Server Developer

RESPONSIBILITIES:

• Gathering, Understanding and analyzing the report business requirements with BRD, report Inventory and converting the report business requirements to report technical requirements with FSD and Data mapping document, Design diagram, Solution design diagram and mock ups.
• Owned, responsible and accountable for the business, functional, technical, documentation, design (mock up, wireframe and, proto type), pipelining, base lining, Gap analysis, reverse engineering, development, testing and UAT of the whole project in 3 environments RT (Run Time) Dev.\Staging and PROD of all requirements of the 3 layers of the project as a Clarity Analyst (Source level), Tableau Analyst (Project level and Systems) 11 Sources, Composite middle and Tableau Reporting level).
• Liaison between the client business departments and the project management and Technical development teams to share the business report expectations knowledge and needs.
• Prepared the Report Inventory, Report Mapping doc,report business requirement document (BRD) and the report Functional Specifications Document (FSD) for all the 3 tiers source, data and Analyzed the business and functional requirements of the various source systems, middle data composite fields and destination reporting Tableau fields.
• Presentation so all objectives, goals, functionalities could be captured.
• Involved actively in Inception, elaboration Phases and prepared vision statement and initial data models and flows that contained Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Act as a Tableau BI end to end life cycle implementer involving in Data Analysis (Tableau Analyst), Dashboards development (Tableau Developer) and Dashboards Administration (Tableau Admin).
• As a Tableau Analyst, using Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also to slice and dice the data, for analyzing the data of patterns, trends and fashions of various KPIs,Measures using various graphs,charts,indicators, and gauges.
• Understanding the tool capabilities of CA Clarity PPM tool and Composite data virtualization tool.
• Majorly focused on Tableau BI tool and to bring the new requirements from Clarity system and then to end tableau dashboards and closely worked with the clarity development team and Composite team acted like an end - to - end Tableau Implementer (Tableau Analyst, Tableau Developer and Tableau Admin) throughout the project.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
• Act as Tableau Developer (for designing and developing, proto typing the various dashboards using tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts, Refreshing extracts, Tableau Layout designing, Tableau Work sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters),ranking, Top-N Analysis, hierarchies)
• Interacted closely with the Business users along with the administration and management to gather the report business requirements, report types and report formats.
• Involved with business to sign off the report requirements and freeze out the report requirements and phases to facilitate the project to move in a right direction.
• Closely worked with the Program manager, Project manager, business teams, and technical folk’s collaborate with regular reviews.
• Met with business client groups to determine report requirements and goals. Utilized agile methodology to configure and develop process, standards, and procedures and create report business requirement Document and Report Inventory.
• Worked closely with the other CA Clarity PPM production team for the clarity system impact analysis and gap analysis for the new clarity requirement, clarity and existing data models by pulling the data to Tableau Presentation layer to make the data visual for the data analysis.
• Act as a Tableau Administrator, using Tableau Server for publishing the developed dashboards to server,authentication,authorization,security,Tableau Extracts scheduling and refreshments, User Management9Adding users and Groups), Content Restriction to users, to content based on access level as a Tableau Content Administrator.
• Extensively working with User stories and user acceptance criteria, release planning, iteration planning and tracking in RALLY tool for the Tableau Report requirements.
• Created Mock-ups and Proto types in PPT for the Tableau Project\Program level dashboard with good look and feel and presented them to business for the approval.
• Assisted Project Manager in documenting the progress of the project and any possible roadblocks.
• Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.

Environment:TableauDesktopV6/V7,TableauServer,MS Office Suite,Oracle SQL ServerR2, SSIS & Excel

Confidential

Tableau Developer

Responsibilities:

• Created visually compelling and actionable interactive reports and dashboards using Tableau 8.0/8.1/8.2.
• Created ad hoc reports to users in Tableau 8.0/8.1/8.2 by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Implemented Data blending on Multiple data sources and generated interactive dashboards.
• Generated tableau dashboards for Leadership Team with forecast and reference lines of Targets.
• Built Dashboard using various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems
• Built Active Reports in Cognos 10.2 for Business Offline Reporting and Executive Demo presentations
• Built Complex Reports having child reports, HTML items in Report Studio
• Extracting the data tables using custom generated SQL queries from Excel files, Access & SQL database and providing extracted data as an input to Tableau.+
• Created Tableau scorecards and dashboards using stacked bars, scatter plots, Geographical maps & Gantt charts using show me functionality.
• Worked extensively with Advanced Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Groups, Hierarchies and Sets to create Detail & Summary Reports and Dashboards using KPI's
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created incremental refreshes for data sources on Tableau server.
• Created, Organized, Customized Analysis and Visualized projects and Dashboards for Senior Executives.
• Deployed Tableau Server in clustered environment by adding worker machines.
• Supervised VizQL processes to monitor performance and system stability.
• Involved in License Management S
• LA's with Tableau support, Administered users, user groups, and scheduled instances for reports in Tableau.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Defined Best Practices for Tableau report development.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Developed canned / Ad-Hoc reports and complex dashboards in Tableau as needed.

Environment:TableauDesktop,TableauServer,MS Office Suite,Oracle SQL ServerR2, SSIS & Excel

Confidential, Tampa, FL

SQL SERVER Developer/SSIS Developer

Responsibilities:

• Installed SQL Server 2000 Servers, multi instances.
• Database Programming in Visual Basic 6.0, MS SQL Server 2000.
• Planned and Scheduled the Online/Offline Backups, Maintained Backups and Restore.
• User Management creating groups and policies in Active /directory, Maintained User data and File System.
• Created and maintained mail and database accounts with client user support.
• Configured and maintained servers with Active Directory integration.
• Performed optimization of indexes and queries by using index tuning wizard to enhance the performance.
• Performed log-shipping process between servers.
• Performed extensive database activities such as data modeling, database design, data analysis, validation and consistency check.
• Used triggers and constraints to maintain the consistency of the databases.
• Used DTS packages to perform Data Transformation tasks like bulk copy and bulk transfer of data and used BCP utility to perform these tasks.
• Implemented Business logic using stored procedures.
• Designed and developed tools for business requirements using stored procedures.

Environment: MSSQLServer 2008r2, T-SQL,SSIS/SSRS2008r2, Visual Studio 2008r2, Erwin 8.0.

Confidential

SQL Server DEVELOPER

RESPONSIBILITIES:

• Created Complex SQL queries, Derived tables, common table expressions (CTEs), complex stored procedures, views, indexed / materialized views, generating Cross Tab Tables (Pivot), full text Search, Distributed Queries, user defined functions (UDF), Cursors and Database triggers. Extensively involved in designing (Logical and Physical) of customer database.
• Migration of DTS - SSIS packages.
• DTSxChange tool to profile, convert & Monitor DTS and SSIS packages.
• Designed data flow & control flow tasks which DTSxChange unsuccessfully converted.
• Performed Unit testing of the converted packages.
• Produced Ad-Hoc reports for testing purposes.
• Supported specific user groups with reports based on necessary business requirements.
• Created XML, PDF, and EXCEL files using SSRS.
• Used Pull delivery to allow employees to grab any of the reports they need and in whichever format they desire.
• Used sub-reports and linked reports to produce results based on many different datasets.
• Formatted the reports to display only the information that was important to the user.
• Modified and created Stored Procedures to facilitate the datasets required by reporting services.
• Wrote complex queries and stored procedures in T-SQL to meet new business requirements.
• Optimized the existing queries to improve performance using SQL Profiler tools.
• Used to support the data processing engine in database intensive operations like query Performance tuning, parallel query algorithm by writing stored Procedures.
• Measured the existing size of the data on the relational side, plan for growth (addition of new data everyday) for a year.
• Communicated with the team members on regular basis. The change requests had to be made for all the implementations.
• Created different types of reports like drill down reports, drill through reports and linked reports to answer different business questions.

ENVIRONMENT:SQL, T-SQL,SSRS,SSIS, Oracle 10g/91, ETL Informatica, DB2

Confidential

Business Analyst

Responsibilities:

• Captured the scope of the project by defining the boundaries, Critical to Quality objectives (CTQ's) and the purpose.
• Worked extensively with SME's including heads in areas of Credit risk, Processing, Closing and expertise in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRD and FRD.
• Conducted Gap Analysis by creating process flows highlighting the differences between the Current (As Is) environments versus the Target (To Be) environment.
• Created the Business Requirements Document (BRD) to clearly define each business goal in terms of meaningful and structured functional requirements along with detailed process flows (using Visio) and respective SIPOC analysis.
• Facilitated brainstorming sessions and conducted meetings to elicitrequirements from the Business partners, Sponsors and Users.
• Facilitated Joint Application Development (JAD) sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Created Use Cases to support the High Level Design document in Analyze phase.
• Followed the Waterfall Model of software development implementing the Six Sigma methodology.
• Created conceptual wireframes to assist the developers in better understanding of the requirements.
• Supported the CIT and SIT testing teams for creating test plan and scripts.
• Created the UAT Plan and test scripts and participated in UAT.
• Created the TraceabilityMatrix to map the functional requirements with test scripts, wireframes and High Level Design (HLD).
• Used Mercury's Quality Center to track the enhancements, changes and defects.
• Trained Users by documenting and giving presentations regarding the changes and new functionalities and managing it with the help of configuration management.
• Created Release Notes prior to each implementation.
• Created and maintained Meeting Minutes / Issues Log and ensured timely resolution of all outstanding items.
• Acted as a liaison between Technology and Business for clear and better communication.

Environment: PL/SQL, Rational Rose, Requisite Pro, UML, SQL Server, Excel, Oracle CRM, Visio.