SUMMARY

• 8+ years of IT/BI experience in the fields of Business/Data Analysis, ETL Design and Development, Data Modeling, and Report Development with over 3+ years of solid experience in Tableau.
• Strong experience in Business Intelligence, Data Warehousing, and Data Mining applications in health care, retail, marketing, and financial industries.
• Proficient working with Tableau Desktop, Server, Reader, Online, Public, and Mobile in different versions of Tableau 9.x, 8.xand 7.x.
• In depth knowledge of SDLC phases such as Requirement analysis, design, development, implementation, deployment and maintenance with strong understanding of methodologies such as Waterfall, Iterative and Incremental, Evolutionary prototyping, and Agile.
• Strong experience with Scrum methodology and well versed in writing user stories.
• Experience in gathering and writing detail business requirements and translating them into technical specifications/System Requirements Specifications (SRS) and design identifying interface and business process specifications.
• Experience in conducting Joint Application Development (JAD) sessions with End - Users, Subject Matter Experts (SME's), and Development and QA teams.
• Experience in developing interactive reports and dashboards by making use of actions, local and global filters, table calculations, calculated fields, groups, sets, hierarchies, and parameters in Tableau.
• Experience in assisting users to create and modify worksheets and data visualization dashboards in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Experience in designing stunning visualizations using Tableau charts such as Pareto, Waterfall, Bar graphs (Stacked, Side- by- Side), Lines (Continuous, Discrete), Geo maps (Symbol, Filled), Scatter plots, Pie-charts, Histograms, Bullets, Tree Maps, Heat maps, and Highlight tables etc.
• Experience in embedding Tableau reports and dashboards on external websites using JavaScript API.
• Strong experience in Business and Data Analysis, Data Profiling, Data Cleansing, Data Migration, Data Integration, and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star and Snow-Flake Schemas, Fact and DimensionTables, and Physical and Logical Data Modeling using ERwin.
• Coordinated Technical Reviews, developed System requirements. Supported status reporting and conducted UAT with the cross-functional business teams to ensure the system was aligned with the vision of the business teams.
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBA's, Developers, and QA/QC Analysts during the design phase.
• Extensive experience in Extraction, Transformation and Loading (ETL) of data from different source systems such as flat files, Excel, Oracle, and MS SQL server.
• Outstanding experience in creating Source to Target (Data Mapping) documents, writing data extract scripts/programming of data conversion and researching complex data problems and generating analytical reports/dashboards.
• Possess strong knowledge of database management in writing SQL queries using complex joins, grouping, aggregation, nested subqueries, and resolving key performance issues.
• Involved in training of end-users and documenting training manuals.
• Analytical, methodical and resourceful approach to Problem Solving, Root-Cause Analysis, Impact Analysis and providing corrective actions to meet business requirements.
• Focused troubleshooter and a team player with excellent interpersonal and communication skills. Ability to work cohesively with developers, testers, and other team members.
• Excellent leadership and communication skills.

TECHNICAL SKILLS

Databases: Tableau (Desktop/Server/Reader/Public/Online/Mobile), Micro

BI Tools: Strategy (Desktop/Web), SSRS, and Crystal Reports

ETL Tools: Informatica, DataStage, and SSIS

Requirements Management: Requisite Pro and Microsoft Office (Word, Excel)

Microsoft Project: Microsoft Office, Visible Analyst, and Lotus Notes

SQL Tools: Teradata SQL Assistant, PL/SQL developer, Toad, SQL Server Management Studio

Defect Management Tool: Mercury Test Director and HP Quality Center 10.0

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow Flake Schema, ETL, OLAP, Complete Software Development Life Cycle, CMMI Compliance, Waterfall, Agile, and Iterative

Scripting Languages: SQL, PL/SQL, VizQL, C, C++, HTML, COBOL, JavaScript, and XML

Data Modeling: Power Designer, ERwin, ER Studio, and MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts and End-Users to gather business requirements and translated business requirements into technical design documents/report visualization specification design documents.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Analyzed requirements for various reports, dashboards, and scorecards.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current, and forecast sales data.
• Mentored business power users to create reports/dashboards using Tableau Desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
• Involved in creating interactive, parameterized 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.
• Utilized Data story telling in Tableau to provide more dynamic and more effective stories from the hidden insights locked in the data.
• Created prompts, customized calculations, conditions and filters (Local, Global) for various analytical reports and dashboards.
• Created and modified interactive dashboards and developed guided navigation links within interactive dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports and dashboards.
• Published the developed dashboards and reports on theTableauServer so that the end-users having access to the server can view the data.
• Scheduled frequency and time to refresh data when sources are published or extracted to server.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and data marts.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversaw the performance of design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau Desktop/ Server,MS Project, Teradata, Teradata SQL Assistant, SQL, PL/SQL, SQL Developer, Informatica Power Center, SQL Server, Control-M.

Confidential, Deerfield, IL

Sr. Tableau Developer

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports.
• Extensively used Visio to create Use Case Diagrams and Activity Diagrams.
• Developed and maintained high level overview of the project and designed flows using MS Visio.
• Created and modified Business Intelligence analytical reports using Tableau.
• Responsible for creating metrics, filters, calculated fields, and parameters using Tableau Desktop.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Extensively used Tableau Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Created various actions in database such as action filters to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources, and Highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and published the same on Tableau Server, allowing executive management to view past and current performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
• Created SQL scripts for testing and validating data on various reports and dashboards and handled performance issues effectively in Tableau.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Used MS Excel to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracked schedule and had clear communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page.
• Involved in Onsite and Offshore coordination to ensure the completeness of deliverables.

Environment: Tableau (Desktop/Server), Oracle, Teradata, SQL Developer, Teradata SQL Assistant, HP QC, SQL, PL/SQL, T-SQL, Microsoft office 2007.

Confidential, Providence, RI

Tableau Developer

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.
• Conducted gap analysis for re-engineering and upgrading the current system where ever necessary.
• Developed, derived, and clarified functional specifications and use cases.
• Analysedbusiness requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional, Technical).
• Translated business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Designed the conceptual and business process models.
• Implementation of new systems including the integration of the new system with existing systems.
• Analysed the Source System data and understood the business requirements.
• Extensively involved in data mapping and data modelling, and participated in domain model analysis and preparation of logical business model using UML.
• Extensive interactions with the client and the management teams to understand the requirements and provide data to create campaigns using UNICA Affinium tool.
• Documented detailed business requirements for campaigns.
• Worked with campaign development team to identify bottlenecks that could hinder progress of development.
• Created Tableau scorecards and dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with advance analysis actions, calculations, parameters, background images, and maps.
• Used Trend Lines, Statistics, Log Axes, Groups, Hierarchies, and Sets to create detail level summary report and Dashboard using Tableau Desktop.
• Performance Management, Portfolio Management, and Risk Management to support strategic planning, goal setting, enhance decision making, and improve customer service.
• Confer periodically with both business unit and technical programmers throughout the increments in entire lifecycle of the project in order to track progress, identify changes, and ensure changes are communicated to both the business unit and technical staff.
• Involved in writing Test Cases, procedures, reports, and approval of software release.
• Monitored the project during Development phase and involved in User Acceptance Testing (UAT) once the change requests are released from system testing.
• Design and development of analytic reports.
• Deployment of defect free code while managing the timeline set for the project.

Environment: Tableau 6.0, Informatica Power Center, Oracle, MS Access, TOAD, SQL Developer, PL/SQL, UNIX,Mercury Quality Center, WindowsNT4.0

Confidential, NYC, NY

Data Analyst/ Data Modeler

Responsibilities:

• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Created the conceptual model for the data warehouse using Erwin data modeling tool.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with Business users, App Developers and Information architects to make sure all the requirements are fully covered.
• Analyzed large number of COBOL copybooks from multiple mainframe sources (16) to understand existing constraints, relationships, and business rules from the legacy data.
• Worked on rationalizing the requirements across multiple product lines.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Implemented Agile Methodology for building an internal application.
• Created the logical model for the EDW with approximately 75 entities and 1000 attributes using Erwin.
• The logical model was fully attributed till 3rd normalization and contains both current and history tables.
• Data model is divided into number of sub models for the ease of understanding and comprehension.
• Reviewed the logical model with application developers, ETL team, DBAs, and testing team to provide information about the data model and business requirements.
• Worked with ETL team to create source to target mappings (S2T).
• Worked with DBA to create the physical model and tables.
• Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
• Had brain storming sessions with application developers and DBAs to discuss about various denormalization, partitioning, and indexing schemes for physical model.
• Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.

Environment: Erwin, QMF, COBOL copybooks, Mainframe DB2, SQL Server, SQL*Loader, Mercury Quality Center, Informatica Power Center.

Confidential, Plano,TX

Business Systems Analyst / Data Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Worked with business, product, and architecture teams to develop the overall roadmap for the platform.
• Evangelized the concept and benefits of a service-oriented architecture to business and product teams, as well as worked with the technical teams to understand business perspectives.
• Provided ongoing management support to ensure that the roadmap delivers to the requirements, and served as an ongoing liaison for addressing and resolving changes as the roadmap evolves.
• Translated business requirements into services specifications, and assisted with exposing the company’s business logic and data through Web services.
• Developed the System Requirements Document (SRD) from the Product Requirement Document (PRD) based on the input from various customers and helped the architecture and development teams to better understand the requirements.
• Acted as a liaison between business staff and technical staff to articulate needs, issues, and concerns.
• Built Screen Mockups for various user interface screens based on the requirements.
• Trained and mentored end-users on Web usage, Power users on Desktop; day-to-day coordination with the users on ad hoc requests for reporting and analysis.
• Worked extensively on developing Facts, Attributes, Metrics, Report Filters, Templates, Compound Metrics, Filters, Custom Groups, Templates, and Consolidations using MicroStrategy Desktop.
• Involved in testing the reports using MicroStrategy.

Environment: MicroStrategy, Oracle, Rational Software Tools, SQL, MS Visio, MS Office Suite.

Confidential

ETL Developer/SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment, and user training.
• Involved in Physical/Logical design of database, creating and managing the database and all the database objects.
• Designed and developed forms using Visual Basic with ODBC.
• Designed and developed reports using Crystal Reports.
• Developed E-R diagrams (logical and physical using ERwin) mapping the data into database objects.
• Designed and developed various complex reports.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Involved in dimensional modeling to design data warehouse.
• Identified the measures, dimensions, and defined cubes to enable decision makers to drill through the detail data.
• Used the calculated members in the fact tables to improve efficiency.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Created roles, assigned permissions and users/groups to roles to limit the access for the users.
• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products for customer satisfaction
• Preparedfunctional specificationsfor user requirements.
• Experience in writing, testing, and implementation of the PL/SQL triggers, stored procedures, functions, and packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Createdentry forms/reportsfor various modules. Createddatabases, loaded initialization data, generated users, and assigned rolesandaccess.
• CreatedTables, Indexes, Table Spaces, Views, Synonyms,andIntegrity Constraints.
• Involved in creation ofschema objects, rolesandprivileges.
• Prepareduser manual and technical documentsfor the end user.
• Prepared executables for system deployment and led the release of applications following
• Experience in UNIX work environment, file transfers, job scheduling, and error handling.
• Maintenance and support for the system. Involved inend user training.

Environment: Oracle 9i, Server 2000, PL/SQL, TOAD, SQL, SQL Server Management Studio, SQL Server Integration Services (SSIS), Crystal Reports, Erwin,XML