SUMMARY

• 8+ years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of BI/Data Warehousing projects using Tableau, MicroStrategy, SSRS, Informatica, SSIS, Teradata, Oracle, etc. in Finance,Health Care, Marketing, Retail and Payroll Services industries.
• Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau9.x/8.x/7.x/6.x.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactiveTableauworkbooks and dashboards for executive decision making.
• Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts ( Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots,etc.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
• Good knowledge on JavaScript API and integration of Tableau with web applications
• Proficient in Dimensional Modeling using Kimball and Inmon methodologies for Star and Snowflake schema designs of Data Warehouse and Data Integration projects.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Designed the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non - relational or source relational to target relational.
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

Reporting Tools: Tableau(Desktop/Server), MicroStrategy (Desktop/WEB), SSRS

Data Integration (ETL) Tools: Informatica Power Center, SSIS

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

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

RDBMS: Teradata, Oracle, SQL Server, DB2, Access etc

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation: Documentum, SharePoint, HP Quality Center

Scripting/Lang..: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows 7/XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Raritan, NJ

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Participate in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
• Hands-on experience in analyzing the data and writing Custom SQL queries for better performance, joining the tables and selecting the required data to run the reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server.
• Restricted data for Particular users using row level security and user filters.
• Developed Tableau workbooks from multiple data sources using data blending.
• Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Responsible for creating dashboards using bars, stacked bars, pie charts, scattered plots, line charts, Gantt charts, and maps
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future trend of the financial performance.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Created guided navigation links for Interactive dashboards in Tableau.
• Involved in Custom Geo-Coding; By assigning geographic roles to fields not recognized by tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Involved in preparing the estimation documents, design document for new reports that are to be developed and also involved in preparing the impact analysis document for a change that is imminent.
• Effectively used data blending feature inAlteryx to combine the data from different sources like SAP Lynx, Vision etc. into a single report.
• Created PowerPoint Presentations for Business Analytics & Insights for end users.
• Extracted, tracked data and analyzed data to generate reports.
• Used advanced Excel functions to generate spreadsheets and pivot tables.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Participate in Agile/ SCRUM methodologies to monitor steer and develop project objectives.

Environment: Tableau Desktop, Tableau Server, SQL Assistant, SAP Lynx, SharePoint, Microsoft SQL Server, MS Visio, Microsoft Office Suite ( Word, Excel, PowerPoint), Alteryx Designer.

Confidential, Saint Paul, MN

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
• Collaborate with business leadership to identify potential areas of analysis
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending feature inTableau to combine the data from different sources like Adobe marketing cloud into a single report.
• Defined best practices forTableaureport development.
• Foundefficientways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Designed and developed various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
• Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
• Presented the findings, graphs to c- suite, replicating the process across variouscustomer segments.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
• 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
• Administered and provided production support for enterprise wide Tableau application consisting of multiple key functional business domains.
• Participated in the retrospective meetings and next sprint planning meetings.

Environment: Tableau (Desktop/Server), Teradata, Teradata SQL Assistant, Teradata Administrator, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite ( Word, Excel, PowerPoint).

Confidential, New York, NY

Sr. Data Analyst/ 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.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Developed business process and technical design documentation for each reporting service developed in this project.
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Designed SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Extensively involved in Data Profiling, Data Mapping and designed Packages in SSIS to extract data files to end users.
• Designed and developed various analytic reports / dashboards using Tableau.
• Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Assisted power users in Tableau dashboard development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Created various complex SQL Queries, Views, and User Defined Functions to implement the business logic.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed various performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau (Desktop/Server), MS SQL Server 2008, Oracle, TSQL, SQL BI Suite (SSIS, SSRS, SSAS), UNIX, Toad, PUTTY, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Phoenix, AZ

Data Analyst/Tableau Developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by product and by country, to measure the forecasting changes.
• Translated business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Prepared detailed technical documents from the functional specifications.
• Worked with data modelers in development of E-R modeling (Logical design) of database incorporating business logic and user requirement
• Involved in analysis of Key Performance Indicators (KPI's) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Created advance connections, join new tables, create & manage Extract and monitor Queries using SQL Assistant.
• Designed and developed Complex workbooks and Dashboards by connecting to multiple data sources using data blending.
• Extensively worked on Tableau Desktop, by creating complex reports & Dashboards on Arizona lottery data.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Designed and developed complex data Views to calculate multiple measures which can be used as data sources for Tableau reports.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI ) and Measure.
• Published of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Conducted trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Deployment of defect free code while managing the timeline set for the project

Environment: Tableau (Desktop/Server), SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, MS Office Suite (Excel, PowerPoint, Word, Visio).

Confidential, Franklin Park, IL

Data Analyst/Business Systems Analyst

Responsibilities:

• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked with data modelers in developing database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Worked with Excel Pivot tables.
• Create and Monitor workflows using workflow designer and workflow monitor.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Identify & record defects with required information for issue to be reproduced by development team.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Teradata Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatica, MicroStrategy, ErwinDB2, HP Open View, Lotus Notes, Windows XP, MS Office Suite(Excel, PowerPoint, Word, Visio).

Confidential, Roseland, NJ

Business Systems Analyst

Responsibilities:

• Involved in SDLC processes with emphasis on Analysis & Design stages
• Extensively used SQL scripts for data mapping and querying.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in Requisite Pro.
• Conducted formal and informal product design reviewsthroughout the software development lifecycle to provide input on functional requirements, product designs, schedules and potential issues. Leveraged developer background to communicate effectively with software design team, quickly gaining respect and becoming a valued, “go-to” team member on challenging test cases.
• Served as a key member of software development team as QA tester on development projects for Confidential applications. Single point of contact in a ten-member software QA testing team in developing and implementing quality
• Performed system, unit, performance, load, regression, stress and data interface testing. Provided developer teams with detailed reports on quality metrics, identified bugs/flaws and recommended fixes.
• Prevented hundreds of Thousands of dollars to Confidential Health and Welfare service engine by identifying software bug in automated system.
• Pinpointed previously undiscovered flaw in new Confidential Reporting Application,resulting in successful migration of the product from production to market
• Identified the root cause of interdependency in Confidential Virtual edge Application,leading to design an innovative parallel processing which increased the productivity by 700%
• Created and Designed databaseof documented test defects and procedures to enable accurate replication and ensure compliance with standards. Accelerated average QA testing turn-around time by 25% or more, allowing company to accept more testing projects.
• Designed and implemented automated testing tools and programsaddressing areas including database impacts, regression testing, negative testing, error/bug retests and usability.
• Documented software defects using bug tracking systemand reported defects involving program functionality, output, online screen and content to software developers.
• Delivered thorough QA testing reportsthat determined product quality and release readiness

Environment: Teradata, Oracle, Teradata SQL Assistant, TOAD, SQL, HP Quality Center, HP Quick Test Professional, HP Load Runner, Selenium Suite, C#, Test Director.

Confidential

Business Systems Analyst

Responsibilities:

• Interacted with the Business Users and Supervisors to get a better understanding of client business processes and to gather business requirements. Analyzed the Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Converted the User Requirements into Business Requirements, Functional Requirements and Technical Requirement. Also created Business Process Models from the requirement specifications.
• Created Use Case specifications, Business flow diagrams, Activity/State diagram and Sequence diagram using MS Visio, so the developers and other stake holders can understand the business process according to their perspective with possible alternate scenarios.
• Communicated extensively with the Financial Examiners and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Implemented RUP and followed iterative, Use Case driven process for requirement documentation and deployment.
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Developed Data Flow Diagrams, illustrating the flow of data into the application database Tables, along with checkpoints for testing / verification.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing. Developed user test cases and validated test results during user acceptance testing.
• Used Test Director for Defect Tracking and prioritizing defects and for enhancements after base lining the requirements.

Environment: MS Outlook, MS SQL Server 2000, Microsoft Visio, Test Director, XML MS Office Suite ( Word, Excel, PowerPoint).