SUMMARY

• Over 6 years of programming experience as an SAS Developer with PL/SQL and Tableau in Analysis, Design and Implementation of Business Applications.
• Strong knowledge on Predictive Modeling and Customer Segmentation Modeling.
• Over five Years of experience with skills in SAS, Teradata and Oracle SQL programming performing qualitative and quantitative analysis in the work capacity of data mining and statistics.
• Worked and have hand on Experience on SAS DI Studio 4.4, SAS BI Dashboard 4.3.
• Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/Assist, SAS/Connect, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS, SAS ETL and SAS/ODS.
• Expertise in working with SAS EG, SAS Web Report Studio, SAS Information Map Studio, SAS XML Mapper, SAS Proc, DB2.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Deep understanding of Healthcare and gaming data reporting requirements and analysis.
• Experience in various integration options using Tableau Desktop, Tableau Server and Tableau Reader to minimize overall end user licensing requirements.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and proficient in Tableau 10.x/9.x/8.x (Desktop, Server, Online).
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Experienced in SAS Version 9.3 Development.
• Extensively used data blending, embed functionalities in Tableau.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Experienced administering and maintaining Tableau Server.
• Knowledge in data warehousing and business intelligence concepts, design principles.
• Experience in RDBMS development including SQL, PL/SQL.
• Experience with Data flow diagrams, Database normalization techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i/11i/R12, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER, OBIEE and Oracle workflow.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, and Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Extraction and creation of database tables using SAS/Access, SAS/SQL from large scale databases.
• Experience in gathering business requirements, evaluating data sources, translating requirements into specifications, application design, technical and business writing and testing various methodologies.
• Provide management/ business partners with inferences of complex multivariate data into a meaningful Portfolio Reports to assist in the decision making process.
• Extensive knowledge and practical skills in all facets of database management and data analysis with a talent for creative thinking and conceptualization.
• Highly motivated, Organized Team player with excellent analytical, communication and leadership skills.
• Experience in Working on Interactive SAS on UNIX Environment.
• Formulation of detailed business requirements. Developed programs inSAS,Accessand SQL.

TECHNICAL SKILLS

SAS Skills: SAS/BASE, SAS/MACRO, SAS/SQL,Web Report Studio, SAS/ACCESS, SAS/ODS, SAS BI, SAS 9.3,SAS 9.4,SAS Information Map Studio, SQL, PL/SQL, UNIX and UNIX Shell Scripting.

SAS Process: Print, Means, Tabulate, Univariate, SQL, Report, Freq, Sort, Summary, SAS/STAT, SAS/GRAPH Format, Import

Tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader, Import, Export, HP Quality Center 9.2, IBM Data Stage 8.1.2, Talend Open Studio 4.1.2.,Informatica.

SAS Procedures: Report, Print, Freq, Means, Summary, Univariate, Sql, Sort, Transpose Contents, Options, Import, Export, Format, Anova, Reg, Gplot.

Database: Oracle, SQL Server, MS Access, DB2

Programming: Basic C, SQL, PL/SQL, HTML

Operating system: Windows (95/98/2000, XP, NP), UNIX, MS DOS

Applications: MS Word, MS Excel, MS PowerPoint, MS Access, Outlook.

Reporting Tools: Tableau (Desktop/Server), Micro Strategy (Desktop/WEB), SSRS, DWH, Business Intelligence.

PROFESSIONAL EXPERIENCE

Confidential, Rochester,MN

Sr. Data analyst & Tableau developer

Responsibilities:

• Performing analysis of complex claims within the Processing System
• Using advancedSAS tools automate the reporting systems to generate daily and monthly reports
• Work with the business areas to identify and implement opportunities for process improvement that impact performance, quality, and/or profit through the delivery of business intelligence, analysis and/or reporting
• Support various business initiatives by utilizing analytical, development and SAS skills to create BI reports utilizing various data sources, such as, Facets, Care Advance, Enterprise Data Warehouse (EDW), and external data sources
• Created data sets for analysis using database and analytic tools like Tableau and Qlikview
• Connecting Tableau server to publish dashboard to a central location for portal integration.
• Connecting Tableau server with share-point portal and setup auto refresh feature.
• Creating visualization for logistics calculation and department spend analysis.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricting data for particular users using Row level security and User filters.
• Developing Tableau visualizations and dashboards using Tableau Desktop.
• Developing Tableau workbooks from multiple data sources using Data Blending.
• Participating in various enterprise business initiatives to support business reporting needs and investigation of data that shows a pattern or indicates a significant variation from expected
• Conducting examination and explanation of complex data relationships that answer questions identified either within the department or by other departments.
• Generating graphics that effectively describe, explore and summarize analysis for communication to appropriate parties
• Wrote Output Delivery System SAS Procedures to publish reports as HTML pages to the web assisted data mining team to extract data patterns and trends from health care data
• Using procedures like PROC Freq, PROC Means, PROC Sort, PROC Print, PROC Tabulate, PROC UNIVARIATE and PROC Report.
• Adapted code according to the client requirements and implemented necessary code updates for production reports
• In corporate critical thinking skills and judgment in the process to determine best course of action for each inquiry/problem
• Knowledge on HIPPA compliance guidelines and strong knowledge of ICD-9, ICD-10 codes
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Extensively generated Monthly standard reports using MS Excel and Pivot tables, spread sheet to
• Developing SQL* loader scripts to load data in the custom tables.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Created dashboard views from provider information data to members.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Creating UNIX Shell Scripts for automating the execution process.
• Developing PL /SQL code for updating payment terms.
• Creating indexes on tables and Optimizing Stored Procedure queries.
• Extensively used PROC REPORT, SAS/ODS to generated Adhoc reports for business partners
• Involved in writing code using Base SAS, SAS/Macros and SAS Enterprise Guide to clean and validate data from oracle table.
• Preparing claim status reports for department and worked closely with team members to ensure that problems claims were resolved timely, and results was documented and shared with the team and departments.

Environment: SAS/BASE, SAS/MACROS, Tableau Desktop 9.3, SAS/ACCESS, SAS/SQL,Web Report Studio,SAS Dashboard, Oracle 9.3,Oracle 11g, SQL*Plus, SQL*Loader, PL/SQL, TOAD 9.5

Confidential, Memphis, TN

Senior SAS &Tableau Developer

Responsibilities:

• Performed unique programming techniques for data validations and overlap analysis
• Designed Macros in EXCEL to review the results from the SAS run
• Frequent usage of PROC functions like PROC means,PROC sort, PROC print, PROC Report
• Usage of more effective programming functions and procedures to reach the goals that were made in the work assignment.
• Query built in SAS to connect with TERADATA to retrieve the customer information in EDW(Enterprise Data Warehouse)
• Provided Tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters.
• Worked on Creating various plots and drill down analysis using Tableau desktop.
• Worked on scheduling reports, managing data sources and refresh extracts. Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau. Generated Tableau dashboards with combination charts for clear understanding.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Creation of Multiple tables that retrieves and holds huge customer information like CUSTOMER AT LOCATION with account creation dates and timestamps from TERADATA
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus.
• Used SAS extensively for match merge, append data validation, and data correction and cleansing
• Performed database imports, exports and data synchronization across the environments
• Generated SAS/MACROS and stored procedures for reusability and to minimize data
• Run Batch files for loading database tables from flat files using SQL*loader.
• Develop new reports and modify existing reports as per the client requirements
• Team meet up to explain new techniques in SAS and EXCEL macros to cut down the time and narrow down the data which consumes more time for manual reviews to finalyze the data validations
• Extraction data from the SQLServer 2012 using SAS/Access, SAS SQL procedures for the analysis datasets
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/SQL, SAS/PL SQL and SAS/GRAPH
• Interact with Business Analysts to understand Functional requirements and developed Technical specifications
• Integrated data using SAS Data Integration Studio (SAS ETL Tool) for an end-to-end SAS data-mart solution for analytics and reporting

Environment: TERADATA,SAS/BASE, Tableau (Desktop/Server),SAS/MACROS, SAS/ACCESS, SAS/SQL,SASDashboard,Oracle 9.3,Oracle 11g, SQL*Plus, SQL*Loader, PL/SQL,EXCEL,EXCEL/MACROS

Confidential, Los Angeles, CA

Data Analyst

Responsibilities:

• Respond and resolve ad hoc requests from application and business users
• Involved in various discussions with the team/client for business requirements, developing estimated timelines or updating management on deviations to these estimates
• Created permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau.
• Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Extensive use ofSASENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks
• Exp knowledge of advanced SAS/STAT procedures including UNIVARIATE ANALYSIS & REGRESSION.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT,PROC TABULATE, and PROC REPORT
• Used SAS extensively for match merge, append data validation, and data correction and cleansing
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/SQL, SAS/PL SQL and SAS/GRAPH
• Interacted with Business Analysts to understand Functional requirements and developed Technical specifications
• Integrated data using SAS Data Integration Studio (SAS ETL Tool) for an end-to-end SAS data-mart solution for analytics and reporting
• Provided support for existing data intake and ETL scripts
• Provided guidance and recommendations for systems that update, or enhance the SAS-DI ETL tool
• Create database objects like tables, views, indexes, sequences and triggers
• Prepared program Specification for the development of PL/SQL procedures and functions.
• Created Custom Staging Tables to handle import data.
• Created custom triggers, stored procedures, packages and functions to populate different database.
• Used SQL Loader, UTL to make flat file for SQL Server Dept., Collections, Bulk Collect, Ref-Cursor then again copy those data into another 30 tables and run procedure for enabling primary and foreign key.
• Worked on Spool data from data ware house in flat file. It was about 30 files and extract those data using SQL loader in to 30 tables and check those data using a validation checking function.
• Developed SQL* loader scripts to load data in the custom tables.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Created UNIX Shell Scripts for automating the execution process.
• Developed PL /SQL code for updating payment terms.
• Coordinated with the Client Data Management and Data Services Teams for successful creation of SAS/ETL script
• Extensive usage of ODS statement for creating RTF, HTML and Excel files
• Implement ETL using SQL Loader, SAS and SQL / PL
• Write wrapper UNIX Shell scripts for execution of BTEQ and SAS scripts using CRONTAB and AUTOSYS options
• Performed extensive end-to-end Code Testing
• Performed database imports, exports and data synchronization across the environments
• Develop new reports and modify existing reports as per the client requirements
• Production maintains, support and enhancements to existing applications

Environment: SAS 9.3, SAS/BASE, SAS/MACRO, Information Portal, Information Map Studio, SAS/SQL, UNIX,PL/SQL, Jasper Server 1.2, 3.0, JDBC, Servlets2.5, Web Services, Java Script,Oracle reporting tool, Toad.

Confidential

Data Analyst

Responsibilities:

• Created SAS Data sets fromTeradata tablesand performed weekly andusingSAS/BASE andSAS/SQLfor the various in-house business departments.
• Converted Teradata data tables intoSAS data setsusingSAS SQL ‘Pass through
• Facility’ and uploaded SAS files into ORACLE tablesusingSAS exportprocedures such as‘DBLOAD’. Involved in automation for BAU Campaigns and extensively usedmacrosto automate the process.UsedShell scriptsto automate the process.
• Used data step options likekeep, drop, rename, compressas a part of storage efficiencies. Data set options if, where, missover, truncover etc. were used in reading raw data files.
• Developed highly efficient BTEQ programmes and coded audit checks for accuracy.
• Used extensivelySAS ODSto create waterfall reports.
• Extensively used macrosto increase the efficiency and accuracy of the application.
• Wrote scripts for back up and running batch files and perform quality assurance and validation on the transported data and reports.
• Performed Data analysis mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.
• Developed SQL* loader scripts to load data in the custom tables.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Created UNIX Shell Scripts for automating the execution process.
• Developed PL /SQL code for updating payment terms.
• Design, Development and testing of Reports.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce required Reports.
• Prepared customized reports to help client provide a strong competency inunderstanding risk and accordingly perform better client selection and client satisfaction.

Environment: Base SAS, SAS MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/AF, Windows 2000,PL/SQL, Oracle reporting tool.