PROFESSIONAL SUMMARY:

• Qualified professional with 8 years of extensive IT Experience as a Data Analyst, Business Analyst, and Data Modeler especially in Data Warehousing and Business Intelligence applications in Healthcare, Finance, Automobile and Wholesale industries.
• Adept in business process improvement, re - engineering, change request management, review process, and reporting escalation.
• Highly Proficient inAgile, Test Driven, Iterative, Scrum and WaterfallSoftware Development Life Cycle (SDLC).
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Proficient in creating Use Cases, Data Flow Diagrams, Sequence Diagrams, Class Diagrams, State Transition Diagrams, ER Diagrams etc.
• Strong understanding ofData Warehouseconcepts, Star Schema, Snowflake Schema, Business ProcessAnalysis, Physical andLogical data modeling.
• Hands on experience inpublishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Highly proficient in design and development ofprototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
• Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filtersand creating Dashboards for key Performance Indicators.
• Experience in creating Data Blending by merging data from different datasets. Created visualizations using Scatter plots, Gantt Charts, Bubbles,Geographic Map,Histograms, Bullets, Heat maps and Density Chart.
• Expert in creatingCalculations (Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Extensive experience in usingTableau (Desktop/ Server), Teradata, Informatica Power Center, Business ObjectsEnterprise, Business ObjectsData Integrator, SQL Server, Oracle11g, and DB2.
• 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 inperformance tuning of loading the OLTP Transactions and integration of the data intoDataWarehouse (EDW)and Data Marts.
• Expertise in Dimensional Tables.
• Experience in designing 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.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Extensively involved inReverse-Engineeringand Business Rules Extraction, Expert inproject planning,strategic planning,systems analysisandtroubleshooting,qualitycontrol, forecasting, scheduling, planningandtracking 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:

BI Tools: Tableau( Desktop/Server/Mobile/Public), Crystal Reports XI, XCelsius, Business Objects, SSRS

ETL Tools: Informatica, Data Stage, SSIS

Databases: SQL Server, Oracle, MS-Access, DB2, Teradata, Oracle.

Database tools: SQL Enterprise Manager, TOAD, Teradata SQL Assistant

Applications: Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio

Scripting Languages: C, C++, HTML, SQL, PL/SQL, XML, VB

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

Design/Version Control: UML, Rational rose

Operating Systems: Windows Server 2000/2003/2008, Windows 98/2000/XP/VISTA/7, OS 400

PROFESSIONAL EXPERIENCE:

Confidential, Lexington, MA

Sr. Data Analyst / Sr. Tableau Developer

Responsibilities:

• Involved in defining the whole project life cycle, following RUP methodology. Developed a vision plan that defined the primary goals and objectives of the project. Analyze business requirements and segregated them into high level and low level
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Assisted Project Manager in developing design and specification, according to the requirement and information gathered during JAD sessions and other forms of information gathering methods.
• Designed and constructed real time dashboards for sales and marketing teams using Tableau.
• Implemented report development methodology for operational analytics group.
• Provided business intelligence guidance to business operation analyst groups.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies.
• Creating data blending while designing a dashboard reading data from different datasets.
• Extensively worked on Tableau dashboard and SQL query optimizations and response monitoring.
• Used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Motion Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Worked with Advance analysis Actions, Drill-Down Analysis, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.1 in Dev, QA, and Production environments.
• Deployment of Tableau reports, creating project folders and assigning user/group permissions.
• Worked creating Aggregations, Calculated fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• 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.
• Createdactionsinworksheetsanddashboardsforinteractivityandtocomparedataagainstdifferentviews.
• Created and managed tableau server groups and permissions.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Designed and developed aggregate data extracts for larger tables and configured schedulers on the server to refresh the data.
• Restricted data for particular users using Row level security and User filters.
• Consulting with business partners on reporting requirements and deciding business strategies for slice and dice analysis.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Conduct demonstration for business users and interacted with end users.
• Actively participated in clarification meeting with the Clients.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop 8.2/8.1/8.0, Tableau server/administrator, SQL developer, SQL 2008, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0

Confidential, El Segundo, CA

Sr.Data Analyst/ TableauDevelope r

Responsibilities:

• Gather and analyze the business requirements and then translate them technical specifications.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Involved in modifying Oracle stored procedures and performance tuning of various tables.
• Develop procedures, functions and packages to implement the system’s business logic using PL/SQL
• Involved in end to end process with respect to campaign management flow.
• Involved in fine tuning SQL overrides for performance Enhancements.
• Involved in performance tuning for better performance by identifying the different performance bottlenecks.
• 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.
• Designed various kinds of the transformations were used to implement simple and complex business logic to load the tables in staging area using data integrator.
• Designed and created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality. Created hierarchies, prompts and aggregate awareness
• Involved in creating data models and building data marts. Used SSIS to load tables and run the batch process.
• Analyzed and improved performance of several ad-hoc reports (bug fixing) using Oracle SQL/PLSQL.
• Designed and developed customized interactive reports and dashboards reports using Tableau Desktop and published the same to Tableau Server.
• EffectivelyusedDatablending,groups,combinefields,Dual Axis,aggregatedfieldsand spotlighting to compare and analyze data in different perspectives.
• Createdparameters,quickfilters,contextfiltersandSetstodisplaytopresult setwhich changes dynamically.
• Experienceincreatingsets,joins,hierarchies,filters,globalfilters,table calculations, calculated measures and parameters.
• ExperienceincreatingvariousviewsinTableaubydifferentchartssuchasmaps,bars,lines,crosstab, packet bubbles, scatter plot, heat maps and highlight tables.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Definedbest practices for Tableau report development.
• Extracted data from various sources, used ETL load scripts to manipulate, concatenate and clean source data.
• Published the developed dashboard reports on theTableauServer so that the end users having access to the server can view the data.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Developed Parameter based reports, Drill-down reports, Matrix reports, Charts and Tabular reports and enabled ad-hoc reporting with report builder.
• Executedand tested requiredqueries and reportsbefore publishing.
• Creating test case for each data view in the Tableau.

Environment: Tableau 8.0/8.1, SQL Server 2008/2008 R2, T-SQL, SSIS, SQL Server Management Studio, Oracle, Unica.

Confidential, Issaquah, WA

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.
• 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 various dimension and Fact tables to migrate Legacy data from various sources to New Consolidated Enterprise Data Warehouse.
• Physical design of data record data files and databases.
• Extensively involved in Data Mapping and Data Modelling and participated in domain model analysis and preparation of logical business model using UML.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time
• Designed and developed complex mappings using various transformations in Designer to load data from Flat Files, Oracle 10G into the target Teradata.
• Prepared Dashboards using calculations, parameters in Tableau and also created Dual Axis, Data blending for merging data between two data sets, created calculated fields, groups, sets and hierarchies etc.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc. Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logon’s and security checks.
• Provided on-going production support for Tableau End Users in the final stages of the project.
• Trained the users to use reporting interface and to create ad-hoc reports based on their needs.

Environment:Tableau Desktop /Server, Teradata, Oracle 10g, Informatica, SQL Developer, SQL 2008,Autosys, MS Visio.

Confidential, Racine-WI

Data Analyst/ Business Systems Analyst

Responsibilities:

• Involved in Full life cycle design and development of Business Objects Enterprise Applications
• Involved in gathering the requirements from BusinessManagers for reports development
• Designed and developedUniversesas per report requirements of Businessanalysis
• Identified the Metrics and sub metrics, Key performance indicators(KPI’s) for Dashboard development
• Worked onmultipledata providers to develop the dashboards coming from different sources
• Involved in bug fixing for invalid data flows, Work flows and projects, testing of Stored Procedures and Functions, Testing of Data Integrator jobs, and the Target DataWorked withContexts and Aliasesto resolve theLoops in Universes
• Managed Users, Groups and their access privileges on the documents
• Extensively worked with BODI Transformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, and Pivot
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by contexts
• Creating various UDF’s in the database for data retrieval in complex reports
• Monitoring the daily job scripts for loading the data about business transactions from source systems to EDW
• Designed Stored Procedures while generating the reports and tested them against Oracle Database
• Identified critical areas of business risk and modified business processes to reduce risk by using the Risk-Management Process
• Identifying & Managing risks, Resource analysis, Cost analysis, Post project analysis & coordination among cross-functional teams & follow-up with clients for settlement of project based issues
• Design, develop, test and enhance the Informatica mappings with changes in the business requirements. Reverse engineer business requirements from already developed mappings.
• Data Profiling to help identify patterns in the source data using SQL and Informatica and thereby help improve quality of data and help business to understand the converted data better to come up with accurate business rules.
• Tuning SQL query performance, working with data warehouses, managing metadata, and developing Web services using DB2
• Used Data Integrator Administrator for scheduling the jobs and validation of the jobs before executing them

Environment: Oracle 9i, Teradata, Informatica Power Center, Business Objects Xi3.1, Xi r2, Crystal XCelsius 2008, QAAWS, Designer, Desktop Intelligence, Web Intelligence, SQL Server 2005, Windows X P

Confidential

SQL Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program and Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Performed optimization of indexes and queries by using index tuning wizard to enhance the performance.
• Performed extensive database activities such as data modeling, database design, data analysis, validation and Data migration (import & export/BCP) from Text to SQL Server.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinated post-implementation events such as testing and configured replication server.