SUMMARY

• Overall 8+ years of IT experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment .
• Sound knowledge of BroadCasting, Food Science, Manufacturing, Health Care, Insurance and Financial industries.
• Certified Tableau Desktop 9 Qualified Associate with extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.x, 8.x, 7.x and other BI technologies like Business Objects, Alteryx, Informatica etc.
• Expertise in designing and developing dashboards using Tableau 9.x/8.x/7.x (Desktop/Server) using data from multiple sources like Oracle, SQL Server, Teradata, DB2 and Flat Files.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
• Interaction with the Power Users &Business users during the various stages of the project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart - Box (Drill Down, Drill up & Cyclic Grouping), Heat Maps, Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations ( Detailed and filled in maps), etc.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Actions, Parameters etc., in Tableau.
• Extensively worked with various database systems like Oracle, Teradata, MS Access, Flat files, XML and SQL Server.
• Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experienced in working with Data modelers to translate Business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• 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, strategic 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

Analytical Tools: Tableau (Desktop/ Sever/ Reader), Business Objects, SSRS, SSAS, Google Analytics (Adobe Site Catalyst).

ETL Tools: Data Stage, Informatica, Alteryx, SSIS

Databases: Teradata, Oracle, DB2 UDB, MS-SQL Server

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

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management: TFS, Documentum, Visual Source Safe, Share point, Ultra Edit

Defect Management tool: Mercury Test Director, HP Quality Center

Methodologies: Kimball/Inmon, Agile, Iterative

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

Languages: SQL, PL/SQL, JavaScript, HTML, Perl, XML.

Operating System: Windows, UNIX (HP-UX, Solaris, AIX), Linux

Scheduling Tools: Control M, AutoSys, ESP Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Tableau Developer/Data Analyst

Responsibilities:

• Involved in Agile methodology (Scrum) from requirements gathering to maintenance and monitoring the progress.
• Worked with Architects and Business Analyst to understand architecture design and business logic.
• Worked extensively on analyzing data cubes and reports which are used in Pentaho reporting.
• Work on Mondrian OLAP Database which was deployed in cloud and exposed as an AWS.
• Transformed MDX (Multidimensional Expressions) query from cubes to SQL.
• Developed customized calculated fields from cubes in Pentaho and integrated fields to SQL in Tableau.
• Developed interactive Dashboards and reports using Tableau server.
• Developed multiple test cases for calculated fields and developed SQL.
• Compared Dashboards and reports developed in Tableau with Pentaho reporting.
• Translated business requirements to technical design specification documents.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• 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.
• Provided tableau training on the Survey dashboards built to the end users.
• Extensively involved in doing user acceptance testing (UAT).

Confidential, Hopkins, MN

Sr. Tableau Developer/ Data Analyst

Responsibilities:

• Work with the businesses and project team members (Architect, Solution Designer, and SME’s) to understand and create reporting solutions. This includesprototyping potential solutions, or modifying existing work to meet new or changing needs through the use of development standards, processes, and tools available to the team.
• Conducted JAD sessions, interacted with the End users on a regular basis for resolving issues pertaining to the reports, attending weekly status meetings.
• Understanding of using structured data, dimensional models or cubes and various forms of ETL for reporting.
• Created data mapping documents for the worksheets to be built.
• Designed and Developed data mapping procedures ETL-Data Extraction, Data Analysis and Loading process for integrating data using Informatica.
• Designed and developed a business intelligence dashboard using Tableau software allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Analyze business requirements from Black Box Testing perspective, business process an system architecture/design
• Maintained documents for change request and implemented procedures for testing changes.
• Actively tracked schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports
• Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company.
• Created and edited the update schedules, managed scheduled update tasks on Tableau server.
• Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, and geographical maps.

Environment: Tableau 9.x/8.x, Oracle, SQL Server, Toad, Informatica, Power Designer, Mercury Test Director, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Scranton, PA

Sr. Tableau Developer/Data Analyst

Responsibilities:

• Gathering requirements from business users for the development of Tableau visualization solutions.
• As part of the agile process need to attend the scrum calls and daily catchup meetings to discuss on daily updates.
• Synthesized and translated Business data needs into creative visualizations in Tableau
• Added value by providing innovative solutions, and delivering improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Organized demos to the product /Stake holders for POC dashboards.
• Involved in end to end implementation of reporting projects.
• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Built reports in Tableau using advance functions like LOD, Parameters, Sets, Groups, and Quick table calculations.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• Develop visually informative dashboards, customized reports based on business requirements and UI specifications.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Refreshed the Tableau Extract in production server using scheduler
• Worked in user management, group management and permission management for accessing dashboards based on security requirement
• Performed unit testing on dashboards.
• Involved in giving the training to end users about the product functionalities and features.
• Closely worked and supported the UAT and QA testing team.
• Executed and tested required queries and reports before publishing.
• Provide prompt and complete resolution to technical challenges and business issues.
• Supported a broad base of the organization's users of the data and reporting platforms with excellent customer service and incident management skills.

Environment: Tableau (Desktop/Server)V9.1/8.2, Oracle, Teradata, SQL Server, Adobe Marketing Cloud, Alteryx, TOAD, Teradata SQL Assistant, AutoSys, MS VISIO, MS Office (Word, Access, Excel, Outlook).

Confidential, Chicago, IL

Sr. Tableau Developer/Data Analyst

Responsibilities:

• Involved in full life cycle of Reporting starting from the authoring phase, the Management phase all the way to the Delivery phase.
• Responsible for requirement gathering from business and prepared the requirement specification document.
• Understand and discuss the BI (ETL and Reporting) requirements with the Business Unit and preparing the detail design documentation according to the standards.
• Designed and developed Tableau reports to ensure all the business requirements are met and provide enhanced Solution that meets client needs.
• Developed mock up reports for business users.
• Identified and created the datasets for the report generation, written the queries and stored procedures for reports, also identified parameters to be added in the reports as per the business requirement
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and extracts.
• Scheduled data refreshes (Complete refresh and Incremental refresh) on extracted source data in Tableau.
• Generate dashboards to provide trending of data using statistics and KPI’s for top management.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives using advance Tableau functionalities like Actions, Parameters, Groups, Background Images, Context filters, etc.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Blended data from multiple sources transformed and exported to Tableau through Alteryx.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Worked with Tableau administrators in integrating fully interactive Tableau views on external websites through Java API scripting.
• Designed strategies for securing the reports created depending upon the level of sensitivity of information that the report contained.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.

Environment: Tableau (Desktop/Server) V8.3/8.1, Teradata, Oracle, Java API, Alteryx, SQL Developer, SQL, XML, Flat files, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint)

Confidential, Charlotte, North Carolina

Data Analyst/ Tableau Developer

Responsibilities:

• Gathered Business Requirements by Conducting User interface sessions and documented their query, business analysis & reporting needs. Understood data and business logic with reports.
• Understanding source systems and Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica
• Optimized performance by tuning the Informatica ETL code as well as SQL.
• Finding Work arounds for the application front end that dynamically hides selected areas of the dashboard on Tableau depending upon user privileges.
• Helped client reporting teams migrate from traditional static Excel reporting to a more interactive and powerful Tableau dashboard solution.
• Analyzed relational database model according to business requirements to create Tableau associative data model.
• Created dashboards utilizing Tableau functionality like sets, parameters, groups etc.,
• Extensively created dashboards with multiple worksheets, linear graphs, pie charts and crosstab.
• Research and troubleshoot technical problems and provided ongoing Tableau based application consultation to the development team.
• Worked on data validations and worked with peer for code review
• Provided demo of Tableau functionality for prospective Line of Business and actively involved in training end users on Tableau functionality.
• Extensively used data blending, embed functionalities in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.

Environment: Tableau (Desktop/ Server), Teradata, Oracle 11g, SQL Server 2012, Informatica Power Center, Toad /PLSQL Developer and Sun Solaris

Confidential, Raleigh, NC

Business Systems Analyst/Data Analyst

Responsibilities:

• Worked with project manager, traders, and other stakeholders to define project scope, plan, and requirements.
• ConductedJADsessions with the stakeholders, end users and SME, to determine the criticalbusinessprocesses and identify key functional requirements for system adhering to the financial regulations and policies.
• Implemented change management after the application is in production and ensured the changes moved into production via DBA and ETL and were implemented in production with all approvals
• Involved in preparing Logical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Identified businessprocess and developedbusinessprocess flow diagrams for loan preapproval, loan application and loan process with the help ofMS Visio.
• Performed GAP analysis of current new account opening processes and compare with proposed system enhancement.
• Used Rational Rose to design Use Case diagrams, Activity diagrams, and Sequence Diagrams to simplify thebusinessprocess for stakeholders and developers
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• Designed complex report Published to Crystal Enterprise for end users to view, schedule, and share reports over the web (Info View).
• Created documentation and test cases, worked with users for new module enhancements and testing. Conducted logical data model walkthroughs and validation.
• Used Crystal Reports to generate reports from different databases of different asset classes like equities, bonds, derivatives, and commodities, for all business needs.

Environment: Business Objects, Informatica, Erwin, SQL, PL/SQL, MS Office (Word, Power Point, Access, Excel, Outlook), Lotus notes, Oracle 9i, SQL Server 2005/2000

Confidential 

SQL Developer

Responsibilities:

• Promote emphasis on tools and process to facilitate analytics
• Involved in the development of system test plan which included scope, objectives, resources, timelines etc. of the testing effort.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Analyzed the reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application with SharePoint as backend.
• Handled unit and system integration testing
• Prepared a help guide to system usage for the convenience of end users.
• 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 from the legacy systems 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.
• Assured that all Artefacts are in compliance with Department’s SLC Policies and guidelines.
• Used Test Director for Defect Tracking and prioritizing defects and for enhancements after base lining the requirements.

Environment: Oracle, SQL Server, Putty, SQL/PLSQL and Windows 2000.