Anuradha P

Summary of Experience

·         Over 8+ years of experience in Analysis, Design, Development and Implementation of Data Warehousing

and Database applications using Tableau Desktop & Server

·         Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into

Functional/technical requirements.

·         Experience in creating Scorecards, Dashboards using Tableau Desktop 8.3/8.2/8.1/8.0/7.0, Publish dashboards to Tableau Server.

·         Worked extensively with Advance analysis Actions, 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

·         Expert in Writing Stored procedures, functions, triggers and Views in SQL.

·         Experience in using different relational database management systems like DB2, Teradata, SQL Server and Oracle.

·         Experience in using various MS office tools for analyzing, arranging and presenting data.

·         Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments.

·         Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows

·         Experience in mortgage lending lifecycle, including origination, sale/servicing, default management/loss mitigation is a major plus.

·         Ability to develop program models for estimating loan loss levels which helps for CCAR stress testing

·         Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.

·         Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review.

·   Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS

   Enterprise Guide

·         Experience in analysis of data using different statistical procedures.

·         Strong experience in coding using SQL, Procedures/Functions, SAS macros.

·         Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis

·         Strong experience in data mining, database, analysis, and problem solving skills

·         Experience in statistical and methodological concepts and techniques

·         Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.

·         Extensive experience in preparation of reports, tables, listings and graphs

·         Strong leadership, interpersonal and oral/written communication skills

·         Ability to work independently as well as collectively & willing to relocate

·         Professional, proactive, collaborative, conscientious and results-oriented individual.

 

Technical Skills

Languages	SAS, SQL, C, C++, Core JAVA.
Platforms	Windows, Mainframes and UNIX.
Reporting Tools	Tableau 6.0. Tableau 7.0, Tableau 8.0/8.1/8.2/8.3.
Statistical Packages	SAS 8.x 9.x (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS Enterprise Guide.
Databases	SQL 2005,2008 ,Oracle, DB2, Teradata
Others	MS office, MS Visio, MS Project Management, Hyperion, VBA macros.

Professional Summary

Johnson & Johnson, NJ                                                                                              May 2013 – Till Date

Tableau Sr Developer

Responsibilities:

·         Working with Business analyst in converting data over to Tableau using SQL/SAS/Excel data over to tableau reports and Dashboards.

·         Involved in installation of Tableau desktop 8.2, Tableau server Application software

·         Creating users, groups, projects, Data connections, settings as a tableau administrator.

·         Creating New Schedule's and checking the task's daily on the server

·         Maintaining server activities, user activity, and customized views on Server Analysis.

·         Involved in installing tabcmd to schedule the report's and setup email reports using command lines.

·         Created Business requirement documents and plans for creating dashboards.

·         Involved in creating ad hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.

·         Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps,

Gantt charts using show me functionality.

·         Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.

·         Worked extensively with Advance analysis Actions, 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 organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

·         Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended

·         Deep experience with the design and development of Tableau visualization solutions Analyzing , developing, testing and debugging the code by using various SAS techniques like SAS SQL, SAS MACRO and system options like SYMBOLGEN, MLOGIC according to the requirements that are dynamic for meeting the need of modeling team that supports the CCAR Submission.

·         Developing new code and modifying the existing complex code to extract the data from various data sources like DB2, ORACLE.

·         Creating the SAS Datasets form raw data by using Proc SQL and various Joins to be available for production.

·         Creating SAS datasets by sub setting the production datasets according to the requirement from the modeling team.

·         Extensively used Informats, formats and indexes in creating the Snapshot datasets for portfolios like Home equity.

·         Providing data-analytical support on strategies for CCAR Stress testing

Environment: Tableau Desktop 8.3/8.2/8.1/8.0, Tableau server / Administrator, tabcmd, SQL developer,   

                         SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, SAS, Windows 2007 server, java  

                         1.5 platform, Teradata, Microsoft Office 2007, Microsoft Excel, PowerPoint, UNIX, DB2

American Express Weston, FL                                                                                     May 2011- April 2013

Tableau Developer/Support Specialist

Responsibilities:

• Created several dashboards that captured Operational Performance, Financial Performance, Information Security, Talent Management and Project Performance metrics
• Migrated content from Production, QA to Development Environment
• Used Actions extensively to link and filter sheets for easier navigation in Dashboards
• Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, IPad)
• Worked in Tableau environment to Create dashboards like weekly , monthly , daily reports using tableau

desktop & publish them to server

• Manage Production, Test and Development environments including installation of patches, security administration and access controls.
• Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal reports,
• Created extensive joins for data blending from several different data sources
• Helped customize Tableau Server with Company Logo and Company Pop-Ups
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Attended meetings with Data Warehouse team, ETL team and Project Managers to track deliverable status

·         Performing complex data management, mapping and query development

·         Identification and integration of data from a variety of sources       

·         Data fetching by going against different source systems like DB2 and Oracle

·         Assist with the design and development of analytic datasets

• Liaise between business users and Tableau support team.
• Work with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Advocate the use of Tableau solution and help educate business users to facilitate early

      adoption of the tool

• Collected data on various process measurements and formatted into graphs using Tableau

Software.

• Building, publishing interactive reports and dashboards, report scheduling using Tableau

Server.

Environment: Tableau Desktop 7.0 , Tableau server / Administrator, tabcmd, SQL developer, SQL 2008,Oracle 10g, Microsoft Excel 2007, MS Access , Windows 2007 server, java 1.5 platform , Teradata, Microsoft office 2007.

PNC Bank, Pittsburgh, PA                                                                                                  Oct 2008 – Apr 2011

Data Analyst

Responsibilities:

·         Design, implement, and maintain large SAS data mart and experience with data mapping.

·         Follow Business Requirements Document (BRD) to develop codes for projects independently and be accountable.

·         Created several Complex Dashboards and set up the Interactivity between different charts in the dashboard using Tableau Desktop 6.0

·         Migrated few of the SAS Reports to Tableau Visualizations

·         Created Parameters/Sets and set up custom filters using Tableau Reporting for various client needs

·         Created several Out of the Box charts using Tableau built in functions and based on Parameters

·         Design, implement, and support infrastructure providing secured access to large datasets

·         Automate data load and data analysis programs with a goal of improving efficiencies across  different Service lines like  Credit Card, Infrastructure, Banking, Customer Care and Sales

·         Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse using SAS, SQL and Macros with better and accurate values.

·         Analyzed complex datasets and created different visualizations using Tableau for detailed Analysis.

·         Prepare tables summarizing descriptive statistics and analyses

·         Used SAS PROC SQL Pass through Facility to work with Teradata database.

·         Develop data mapping and transformation rules and detailed designs based on system and business requirements

·         Analyze source data / file structures, technical Metadata, profile source data

·         Understanding of Business/Risk Management concepts. 

·         Explain data variables and derivations to Business Analysts, reconcile month end data for key statistics.

·         Worked on edit check programs to maintain data consistency and data validation.

·         Performance tune the application to meet operational production requirements

·         Design and code functions of the application in accordance with the standards and architectural guidelines

Environment: Tableau 6.0, Base SAS v9.2, SAS/Macros, Microsoft Excel,SAS/SQL, SAS OLAP Cube Studio 4.2, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, Mainframes ,UNIX, Teradata

Walt Disney Company, Orlando, FL                                                                                   Jan 2007 – Oct 2008

Satyam Computers (Implementation Partner)

SAS/SQL Programmer

Responsibilities:

·         Developed programs using Base SAS & SAS/Macros to extract data from oracle tables.

·         Used complex macro statements, stored processes and procedures like Proc SQL, Proc Means, Proc Freq, Proc Tabulate.

·         Manage end-user expectation in the delivery of projects within agreed timelines and as per agreed quality standards.

·         Independently executes standard processes, implements predefined algorithms and corrects identified problems.

·         Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.

·         Extensively used Proc Report to create complex reports.

·         Created Drilldown reports using Proc Reports.

·         Used Style attributes and altered formats, fonts, foreground colors, background colors in Proc Reports

·         Created customized reports using compute blocks and Call Define statements.

·         Created HTML and PDF reports using SAS - Output Delivery System ODS

Environment: SAS/BASE, SAS/STAT, SAS/SQL, UNIX, SAS/MACRO, SAS/ACCESS, SAS/ODS, MS Access, DB2, Excel, PowerPoint.

Satyam Computers, India                                                                                                   Aug 2006 - Dec 2006

Statistical Analyst

Responsibilities:

·         Reading data from different sources like .csv, excel, tab delimited files.

·         Perform various business checks on the source data to confirm whether data is correct or not.

·         Compare the source data with historical data to get some statistical analysis.

·         Perform transformations like Merge, Sort and Update etc..to get the data in required format.

·         Generate Reports in user required format by using ODS and PROC Report.

·         SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc Univariate.

·         Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ODS, SQL Server 2005, DB2, UNIX.