SUMMARY

• 6+ years of Industry experience as a Data Analyst in a Data warehousing environment.
• Experience asTableauDeveloper, SAS programmer, data discovery, data visualization, data analysis, report development and SQL developer for Insurance, Media and Communication, Financial verticals.
• Excellent knowledge in Data Analysis, Data Cleansing, Data Verification and identifying data mismatch.
• Tableau BI reporting experience using Tableau Desktop version 7x/8x/9x, Tableau Server, and Tableau Reader creating worksheets, Graphs, Charts and dashboards.
• Hands on designing and deploying rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized dashboards using Tableau.
• Experience in SAS, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT and SAS/ODS procedures.
• Extensive experience writing complex SQL queries reading data from Data warehouse tables in Oracle, Teradata,Db2.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of ETL tools such as SAS. Experience in testing and writing SQL statements.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. Chaired and conducted JAD sessions with business and technical teams.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing, system testing and defect tracking using Clear Quest.
• Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.
• Thorough knowledge in SAS programming Macro Facility,SAS Procedures,SAS formats, SAS functions, SASstatements,SAS Informats, merging SAS Data set, Preparing data, Producing reports, storing and managing data in SAS.
• Experience performing ETL (extract transform load) using SAS programming.
• Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status
• Sound statistical knowledge of predictive solution models including linear, multiple regression models.
• Adeptness to organize information, communicate and present research findings in a clear and useful manner.
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed strong analytical, problem - solving skills and document function/process flows.
• Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

BI Tools: Tableau 7x/8x/9x, SAS 9.2, R, Excel Analysis ToolPak

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

Testing Tools: Mercury Quality Center, Rational Clear Quest

RDBMS: SQL on Oracle 10g/11g, DB2, Teradata 14

Programming: SQL, Python

Environment: Windows (2000, NT, XP,7), Unix

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), Microsoft Share Point, Teradata 13.10/14 SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Rhode Island, Providence

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Created RTM (Requirements traceability matrix) for mapping Requirements
• Extracting data from the database by writing SQL queries and using SAS/Access, SAS/SQL procedures
• Converted tables and flat (text) files intoSASdatasetsafter performing ETL.
• Pulled data from multiple data sources like Oracle, Mainframe, Teradata, flat files into SAS and Used sorting and merging techniques on the input data sets for Data Preparation, to get the required output and then writing the code usingSAStools.
• Created Macros and developed SAS programs for Data cleaning, Validation, and Analysis using newly created as well as existing macros.
• Developed user-defined formats and informats to integrate the data and created visually compelling and actionable interactive reports and dashboards.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Utilized advanced features ofTableausoftware like link data from different data sources together on one dashboard to filter data in multiple views
• Created individual Worksheets and incorporated it into Dashboards with the appropriate filters.
• Involved in designing of code and set up timelines for the project.
• Scheduled frequency and time to refresh data for the data sources are published or extracted to server
• Use experience and knowledge of line of business and trends to determine materiality of variances in the analysis and reporting process
• Carrying out the project work by contributing ideas, opinions and new information, review meeting with the team members & responsible for the work undertaken by team members.

Environment: - Oracle 11g, DB2, Tableau 9x, SAS 9.2, MS office, Clear Quest, Control-M, TOAD, Windows 7, Linux.

Confidential, Rhode Island, Providence

Responsibilities:

• Involved in gathering analyzing and documenting business requirements functional requirements and data specifications.
• Worked with business analyst to understand business requirements and created functional specifications documents along with mapping documents.
• Understanding the warehouse Start Schema Model and wrote SQL queries joining multiple dimension and fact tables.
• Analyzed the data using statistical features intableauto develop Trend Analysis reports.
• Created visually compelling and actionable interactive reports and dashboards in Tableau and worked on performance tuning of Tableau.
• Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.
• Migration of existing reports (custom sql) from Oracle to Teradata.
• Involved in extensive DATA validation by writing several complex SQL queries on Teradata SQL Assistant and Involved in back-end testing.
• Created individual Worksheets and incorporated it into Dashboards with the appropriate filters.
• Scheduled frequency and time to refresh data for the data sources are published or extracted to server.
• Troubleshoot any performance issues or bottlenecks.

Environment: Tableau 8x/9x, Oracle 11g, Mainframe, DB2, Quality Center 8.2, Control M, Teradata 14, Teradata SQL Assistant

Data Analyst

Confidential, Texas

Responsibilities:

• Worked with Business users to analyze the data specifications and developed relationship between source data and worked with data modeler to build tables from different source data.
• Developed custom SQL queries to minimize the data to improve the performance in Tableau.
• Created Macros and developed SAS programs for Data cleaning, Validation, Sorting, Merging and Analysis.
• Experience in designing and development of Tableau visualization solutions and Created Business Requirement documents and plans for creating dashboards.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Utilized advanced features ofTableausoftware like link data from different data sources together on one dashboard to filter data in multiple views.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Tested reports and uploadedtableaudashboards on to server and provided production support for tableauusers.

Environment: Tableau 7/8, Oracle 10g, SAS 9.2, TOAD, Windows XP, Windows 2007 Server, UNIX, MS Office, Rational Clear Quest, MS Access, MS Visio

Data Analyst

Confidential

Responsibilities:

• Experience with analyzing large datasets and preparing reports using tools like Advance Excel Analysis tool.
• Involved in writing SQL queries and pulling data from various oracle tables using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Experience using data cleansing techniques, Excel pivot tables, formulas, and charts.
• Performed statistical analysis like regression and Time Series analysis to forecast the data in Excel data analysis tool
• Cleaning, shaping and changing formats of the data according to the Client/Analyst requirement using SAS programming.
• Undertaking data collection, business analysis; develop models, report preparation and final presentation to the management.
• Research data from OneSource, Hoovers, Reuters, Google finance and Yahoo finance.

Environment: Oracle 10g, SAS, R, TOAD, MS Excel, MS Office, MS Share Point, MS Access, MS Visio