Analyst/Developer (SAS, SQL and Tableau)

Summary:

*+ years of IT Experience as an Analyst with Data Warehousing, Business Intelligence, Tableau, SAS, SQL, Quality Analyst, Microsoft Office.

Experience in Requirements Elicitation, analyzing, communicating, documenting and validating the requirements.

Knowledge of SDLC Methodologies like Agile Scrum, Kanban and waterfall.

Knowledge of Healthcare industry, Auditing, Casualty and property, Finance and Retail industries.

Experience in Business analysis, Data analysis, Impact Analysis, GAP Analysis, Process Re-Engineering, Data Profiling and Data validation.

Good understanding of ETL processes, Data Modelling and Reporting processes.

Expertise in writing SQL Queries and involved in ETL/Report Testing.

Knowledge of Quality Assurance (QA) - unit testing, system/functional testing, regression testing, integration testing and UAT testing.

Published best practices in SAS, checklists, Data Validation and involved in writing testcases, test plans, test scripts and test strategy/test scenarios.

Having knowledge 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.

Facilitated training sessions, created presentations and brain storming sessions product, system and process improvements.

Experience in training Business users through online and demo sessions.

Exposure to Amazon web services (AWS).

Having knowledge of Relational Data architecture, RDBMS Concepts which includes Relational, Dimensional Models, Data warehousing and Tableau architecture.

Knowledge of creating datasets in Alteryx by integrating data from different data sources.

Strong Written, Verbal Communication Skills, Excellent Analytical, Problem solving skills, logical and Programming Skills.

knowledge with agile ceremonies like stand-up, grooming, planning, retrospective.

Involved in Creation of SAS Datasets from raw data using joins, set, merge, creating SAS Reports along with charts and Graphs as per requirements from the Clients in Finance, (Retail stores like JCPenney, Walmart) and extensively used Advanced SAS, Base SAS, SAS/SQL, SAS/Macro, SAS/Graph on Analysis, Design, Implementation and Testing of various projects for Financial Statement Audit.

Knowledge in creating Visualizations, interactive Dashboards and Packaged Workbooks, Stories as needed using Tableau Desktop and publishing on Tableau Server, creating Reports with appropriate design and layout as per requirements from End-user using Tableau and SAS, publishing dashboards from tableau server to UAT and Production servers, Refresh Schedules on tableau server.

Skilled in Tableau Desktop for Analysis and Data Visualizations and practiced different Visualizations using SHOW ME functionality and other manual charts like Butterfly charts, donut charts, pyramid charts, funnel charts, pareto charts, waterfall charts, density charts using Tableau Public.

Knowledge in incremental and full refreshes for data sources on Tableau server.

Knowledge in performance tuning of the tableau server, workbooks and tune the processes/Complex Workbooks for better performance, knowledge of Tableau Report Performance Optimization.

Knowledge in using published data sources, Live Connections, Tableau Data Extracts TDEs, Joining and Data blending techniques.

Knowledge of LOD (level of detail) calculations, Quick Table calculations, Sets and Groups, Filters and Parameters, KPIs (Key Performance Indicators), Action Filters, User Filters, Trend analysis, Advance analysis and forecasting in tableau.

Knowledge of Tableau Server commands like Tabadmin and Tabcmd.

Quick learner and good performer both in team and independent job environments.

Having knowledge of Relational Data architecture, RDBMS Concepts which includes

Relational, Dimensional Models, Data warehousing and Tableau architecture.

Interacted with Business Users for Requirements Elicitation, discussing any necessary changes in Business requirements and Enhancements.

Understanding of HIPAA Compliance in healthcare systems, Health care standards ICD, EDI Claims/Transactions, Benefits and claims processing for Medicare and Medicaid services, HIX, HIM, CMS, data mapping, Claims Adjudication Process, Healthcare claims processing, HEDIS, Member Enrollment, Eligibility and Clinical Edits.

SKILLS SUMMARY

Databases

Oracle, SQLServer, Teradata, Hive, Amazon Redshift, Netezza, Spark, MYSQL, MS Access.

Database Tools

SQL Developer, SQL Plus, Toad, SQL Assistant, Hue, SQL Server Management Studio, MYSQL Workbench.

Reporting Tools

Tableau 10.5,9,8.2,8.1/8.0/7.0, SAS 9.3/9.0/8.0, Business Objects

Power BI, SSIS, SSRS.

Languages

PL/SQL, SQL, Unix shell scripting, C, C++

Data warehousing Tools

Informatica, Erwin, Alteryx

Operating Systems

UNIX, Linux, Microsoft windows

Test Management and Documentation Skills

JIRA, VersionOne, Quality Center, ALM, MS Visio and Sharepoint

PROFESSIONAL EXPERIENCE

Client: Genpact Analytics March 2007 – April 2009

Role: SAS Analyst

Followed Waterfall Methodology for Software Development Life Cycle.

Interacted with Business users, created business requirements documents and developed Technical design documents related to Creation of SAS reports.

Knowledge to acquire, manage, manipulate and analyze structured/unstructured data and generated SAS reports. Extracted the data from various multiple disparate data sources such as relational

Databases, CSV files and Excel documents, transformed the data into appropriate format and

importing/reading the data so that it is available for analyzing and creating reports.

Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS Enterprise Business Intelligence platform, and using SAS Enterprise BI tools such as Enterprise Guide, Data Integration Studio, Information Map Studio, OLAP Cube Studio, Web Report Studio, System Management Console, DataFlux Data Management Studio.

Extensively used different procedures in SAS like PROC FREQ, PROC UNIVARIATE, PROC PRINT, PROC REPORT, PROC DATASETS, PROC CONTENTS, PROC PRINTTO, PROC SQL, PROC TABULATE, PROC REG, PROC MEANS, PROC SUMMARY, PROC TEMPLATE, PROC TRANSPOSE, PROC CHART, PROC RANK, PROC IMPORT, PROC EXPORT, PROC FORMAT, PROC PLOT, PROC GLM for Statistical Analysis and for creating reports.

Creation of vertical, horizontal bar charts, pie charts and line charts using SAS/GRAPH, PROC GPLOT, PROC GCHART and other SAS procedures.

Having Experience working with large datasets.

Writing programs, SAS coding and generating daily, weekly, monthly reports for both PLCC and Dual (Co-brand cards) using SAS, writing Test Cases with different test scenarios and Data Validation.

Understanding the business needs and generating different Reports accordingly which are useful to analyze the business effectively.

Proficient in writing SQL queries to extract data from different databases.

Creation of new datasets from raw data files using Import Techniques and modifying existing datasets using Set, Merge, Sort, Update for Analysis in SAS. Extracted data from different sources like Oracle, Netezza and text files using SAS/Access, SAS SQL procedures and created SAS datasets.

Worked extensively with different functions in SAS like Input, Put, Substr, compress, scan, trim, length, index, date functions, different statistical calculations like mean, avg, min, max, standard deviation, median, and other functions as well.

Extensively used different statements in SAS like infile, file, Keep, drop, merge, rename, libname, filename, data step, proc step techniques, set, if-then-else statements to execute different functions.

Extensively used SAS/SQL, SAS/Graph, SAS/STAT, Base SAS, SAS Macros and Advanced SAS Programming, SAS dates.

Automation of entire process SAS/Excel for complex and critical reports which has reduced the manual effort (reduced chances of errors) and increased the productivity.

Created macro programs using SAS Macros to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.

Using Output Delivery system(ODS) to output the results from multiple SAS procedures to different reports in HTML, PDF and RTF formats which can be printed.

Worked extensively with Forecasting using Proc Forecast, Proc Timeseries, Proc sgplot for trend and seasonal analysis.

Performed Testing, data validation of the results in SAS by validating the numbers using SQL against the data in the database to maintain data integrity.

Client: Deloitte Jan 2006 – Feb 2007

Role: SAS Analyst

Organized meetings, interacted with Business users for Requirements Elicitation.

Followed Waterfall Methodology for Software Development Life Cycle.

Involved in gathering/Elicitation, documenting and validating business requirements.

Contributed for the development of internal tool by writing SAS codes/programs used to test journal entries for fraud. While working with development team used different procedures, different features and functionalities in SAS. Worked with different clients especially for Northeast region in United States in performing SAS99 journal entry testing including error debugging and self QA.

Extensively used SAS/Base, SAS/SQL and SAS/Macro while developing this JEDAR tool. Working with BASE SAS and SAS tools emphasizing on Analysis, Design, Development, Implementation and Testing of various projects for financial statement audit.

Created Critical reports which include Fraud Analysis (Suspicion of Fraud) and identifying data trends, Anomalies in data using Scatter Plots, regression plots in PROC GPLOT.

Proficient in writing SQL Queries to extract data from different databases.

Education: Bachelor’s in technology in Computer Science and Systems Engineering.

Contact this candidate