SUMMARY

• Overall 6+ years of IT experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of BI/ Data warehousing projects.
• Proficient inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6.x/7.x/8.x/9.x. extensively participated in Tableau 10 Beta testing.
• Experienced in application design using Unified Modeling Language (UML), Sequence diagrams, Case diagrams, Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD).
• Proficient in the formal elements of a software development life - cycle (SDLC) including requirements analysis, design (UML modeling), and familiarity with Waterfall and AGILE methodologies.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements
• Extensively worked on gathering requirements and authoring Business Requirement Documents (BRD) into System Specific Design Documents and identifying interface and business process specifications.
• Proficient in conducting Gap Analysis, Business Process Re-engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
• Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas).
• Outstanding knowledge in designing and developing Data Marts using Kimball/Inmon methodologies
• Extensive knowledge in schema objects (Facts, Attributes, Hierarchies, Transformations) and in developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, DrillMaps, and Templates).
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization,Business ProcessAnalysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameterized view selections in Tableau.
• Experience in supporting data analysis on the Amazon Web Services (AWS) cloud.
• 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 9.3,9.2, 8.x/7.0, SQL Server Reporting Services SSRS

ETL Tools: Informatica Power Center 9.1.0/9.0.1 , 8.6.1, 8.1/7.1.2/6.2 , SSAS, SSIS

RDBMS: Teradata, MSSQL Server 2008/2005/2000 , Oracle (10g/9i/8i), MSAccess, IBM DB2 ( 8.2/8.0)

SQL Tools: Toad, SQL Developer, Teradata SQL Assistant, SQL Explorer, Clear Quest

Others: Amazon EC2, Agile

Operating System: Linux, Windows XP, Server 2003, Server 2008.

Scripting Languages: C, C#, JAVA, SQL, PL SQL.

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Sr. Tableau Developer/ Sr. Data Analyst

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.
• Develop, derive and clarify functional specifications and Use cases.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Designed the conceptual and business process models.
• Worked on full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Designed and developed Scripts to load data into tableau and work with multiple data connections including SQL Server, IBM DB2, Netezza, and Excel using data blending.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Rich Graphic visualization/dashboards to enable a fast read on sales and key business drivers and to direct attention to key area
• Created workbooks and Dashboards using calculated metrics, sets for different visualization requirements
• Designed dashboards with multiple actions and drill down functions to make it available for business users, with ability to filter and dig in detail into KPIs and thereby analyze data for marketing and promotions.
• Worked with large volumes of datasets and loading delimited files into tableau Server Sources.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Worked with string functions, date calculations and swapping dimensions with parameters.
• Deployment of defect free code while managing the timeline set for the project.

Environment: Tableau Desktop 9.3/9.2/8.x, Tableau server / Administrator, Oracle, tabcmd.

Confidential, Bala Cynwyd, PA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Created the AS-IS and TO-BE process flow diagrams.
• Developed business, functional and/or technical requirement specifications adhering to standard requirement templates.
• Experienced in eliciting, defining, writing, and managing business specifications, technical specifications, and other project documentation for applications development.
• Assess, research, analyse and document sponsor/stakeholder needs.
• Performed and documented gap analysis.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Defined functional business requirements, analysed client requirements, and generated workflow processes.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Worked on Proof of Concepts (POC) presentation and review with project and IT lead along with developingTableauDashboards.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Designed and developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Performed analysis using dual axis, data blending in tableau.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Migrated Reports & Dashboards from Development to Testing and to Production Environment using Import Wizard.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Modified applications according to the user’s requirements.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.
• Created the templates for test plan, test cases, process flow diagrams etc., for System Testing and User Acceptance Testing.

Environment: Tableau (Desktop/ Server), Teradata, Oracle, UNIX, SQL, Teradata SQL Assistant, Autosys, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Irvine, CA

Data Analyst

Responsibilities:

• Interaction with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Used UML and Visio for creating Activity diagrams, Sequence Diagrams.
• Identified the objects and relationships between the objects to develop a logical model in Erwin tool.
• Used Erwin for relational database and dimensional data warehouse designs.
• Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
• Translated the logical model into physical model using Forward Engineering technique in Erwin tool for both OLAP and OLTP systems.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Worked with Master Data Management architects to develop data models.
• Writing complex queries using Teradata SQL.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL mappings in Informatica.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Extensively used SQL Server Reporting Services (SSRS) and Tableau in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through reports, Dashboards and modified the existing Dashboards using Cognos Report Studio.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

Environment: Tableau, SSRS, Teradata, Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatica Power Center, Erwin, Power Designer, DB2, MS Office Suite (Word, Excel, PowerPoint)

Confidential

SQL Developer

Responsibilities:

• Oversee installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.

Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access.