SUMMARY:

• 8 years of robust professional experience in Data collection, Data Extraction, Data Cleaning, Data Aggregation, Data Mining, Data verification, Data analysis, Reporting, and data warehousing environments.
• Extensive experience in querying languages using SQL, PL/SQL, T - SQL, SAS, HIVE.
• Proficient in Data Analysis with sound knowledge in extraction of data from various database sources like MySQL, MSSQL, Oracle, Teradata and other database systems.
• Expertise in developing advanced PL/SQL code through Stored Procedures, Triggers, Cursors, Tables, Views and User Defined Functions
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Hands on experience in SAS programming for extracting data from Flat files,Excel spread sheets and external RDBMS (ORACLE, MySQL, DB2, Sybase) tables using LIBNAME and SQL PASSTHRU facility..
• Expertise in Data Manipulations using SAS data step, such as SAS Formats/Informats, Merge, Procedures like PROC APPEND, PROC DATASETS, PROC SORT, PROC TRANSPOSE.
• Experience in developing predictive models like Decision trees, Interactive decision tree, Gradient boosting, Regression, Neural networks etc.
• Proficient in writing macros to create SAS data sets, tables, report and graphs from Procedure Output and automatically send to various destinations (including HTML, RTF, PDF, Printer and Listing) by using SAS ODS statement, as well as convert various file types to SAS Datasets.
• Automate the process of data extraction, transformation and processing using shell scripts.
• Experience in developing programs by using SQL, SAS & shell scripts and scheduling the processes to run on a regular basis.
• Worked in creating different Visualizations in Tableau using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports.
• Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated Fields, Sets, Groups, Parameters in Tableau.
• Created Dashboards style of report susing Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting using relational and multi-dimensional data.

TECHNICAL SKILLS:

Programming: C, C++, JAVA, SAS, Hive, UNIX, Java script, Html, Xml

SAS Tools/ Procedures: SAS/EG, SAS Enterprise miner, SAS Integration studio, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ODS, PROC/PRINT, CONTENTS, MEANS, CHART, PLOT,TABULATE, SUMMARY, SORT, SQL, FORMAT, FREQ, UNIVARIATE, T-TEST, IMPORT, EXPORT AND DATASETS

Predictive Analytics: Decision tree, Interactive decision tree, Regression, Gradient boosting, Neural networks etc

Databases: Microsoft SQL server 2005/2008, Oracle 10g, MySQL, DB2 and Teradata

Operating System: Unix, Mac OS and Windows (95, Vista, XP, 7, 8, 8.1, 10)

BI tools: Qlick view, Tableau, MSBI (SSIS, SSAS, SSRS)

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Sr. Data Analyst/SAS programmer

Responsibilities:

• Worked with the analysis teams and management teams and supported them by providing variables based on their requirements.
• Involved in extraction, transformation and loading of data directly from different source systems (flat files/Excel/Oracle/MSSQL/Teradata) using SAS/SQL, SAS/macros.
• Extensively read different forms of Input files like CSV and other formatted files using In-file, Proc Import and documented using SAS scripting to develop data cleaning operations.
• Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages,Functions and Triggers using SQL and PL/SQL.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.
• Validated regulatory finance data and created automated adjustments using advance SAS Macros, PROC SQL, UNIX (KornShell) and various reporting procedures.
• Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL and SAS/STAT.
• Developed statistical reports with Charts, Bar Charts, Boxplots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Used SAS/ODS to generate reports on HTML web format as well as in RTF and PDF.
• Creating EG projects from multiple SAS programs Building queries using EG Building Graphical reports using existing SAS programs Knowledge of EG console management Create reports using point and click.
• Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Created reports using analysis output and exported them to the web to enable the customers to have access through Internet.

Environment: Windows 8, SASv9.4, SAS/EG, SAS DI Studio, SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, Oracle, Teradata, MS-Excel, Tableau 8.2.

Confidential, Norwalk, CT

Sr. Data Analyst/SAS developer

Responsibilities:

• Analyzed business needs and developed Technical Specifications based on interaction with Mangers and Development Teams. Worked with the analysis teams and management teams and supported them by providing variables based on their requirements. Involved in gathering, understanding and validating the project specifications.
• Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks.
• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQL Joins and other statements for reporting.
• Also created and maintained SAS datasets that are extracted from an Oracle, MS SQL Database using SAS/ACCESS and extensively used Proc SQL to manipulate the data.
• Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats, Functions and created Tables and Listings for the same.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base
• Used data step options like KEEP, DROP and RENAME as a part of storage efficiencies. Data set options IF, WHERE, MISSOVER, TRUNCOVER etc. were used in reading raw data files.
• Built shell scripts to execute the SAS programs on UNIX platform to process and extract terabytes of data from different data warehouses and prepare datasets for ad-hoc analysis and business reporting.
• Constructed SAS programs on UNIX platform to clean the data according to the specifications.
• Used SAS Macrosand procedures likeProc SQL, Proc Transpose, Proc Univariate, Proc Means, Proc Freq.
• Extensively used procedures like PROC FREQ, PROC SUMMARY, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT to make reports.
• Hold responsibility for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX Queries, Perspectives, KPI's, Scorecards and Dashboards.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports using SAS.
• Designed and implemented a variety of SSRS reports such as Parameterized, Drill Down, Drill Through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements using both Tabular and Matrix report formats.

Environment: Windows XP,SASv9.2, SAS/EG, SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, MS-Excel, MSSQLServer 2005/2008, TSQL, (SSRS/SSIS/SSAS), Oracle 9i.

Confidential, Philadelphia, PA

Research Analyst/ SAS programmer

Responsibilities:

• Worked with informatics department and I was responsible to conduct health services research and build predictive models using clinical, survey, or administrative data in support of Informatics analytical projects.
• Extensively used Teradata-SQL Assistant and Advance query toolto write SQL queries.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQLqueries.
• Coded complex SQLqueries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus.
• Extracted 3 year data from different databases (Teradata/MS SQL/Oracle) using SAS/SQL.
• Imported and Exported data files to and from SAS using Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT (tab delimited) and .CSV (comma delimited) files into SAS data sets for analysis.
• Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• Used SAS DI studio for data transformation and has ability to schedule and deploy code from SAS DI.
• Released the reports through UNIX shell scripting every month based on requirement.
• Involved in writing code using Base SAS & SAS/Macros to clean and validate data from tables.
• Involved in designing the project and process flow diagrams.
• Worked and interacted through the project with business team on Web Report Studio to develop business reports.
• Extensively used SAS enterprise miner and developed predictive models in decision tree, interactive decision tree, gradientboosting, regression and neural networks.
• Based on scores, Selected best model and used model on new data to predict likelihood of hospitalization for next six months.
• Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Used SAS Procedures like PROC FREQ, PROC SUMMARY, PROC MEANS, PROC SQL, PROC SORT, PROC PRINT, PROC Tabulate, PROC UNIVARIATE, PROC PLOT and PROC REPORT to generate various regulatory and ad-hoc reports.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Developed Geo/Area Maps to show details on which states have more Confidential ts who are hospitalized using Tableau.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future trend of the financial performance.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server with Quick Filters for on demand needed information with just a click of a button.

Environment: Windows 7,SASv9.4,SAS Enterprise miner, SAS/BASE,SAS/ODS,SAS/MACRO,SAS/EG,SAS/SQL, UNIX, Oracle, MS SQL, TERADATA, Teradata SQL Assistant, Access, Excel, Tableau 8.0.

Confidential, Tampa, Florida

Sr. Data Analyst/ SAS programmer

Responsibilities:

• Worked with Health care data which includes details and various claims of the members.
• Gathered data from Oracle, SQL Server and reporting requirements from business.
• Extracted data from oracle database using SQL pass- through facility.
• Develop Oracle PL/SQLtriggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, recordstables and rebuild indexes.
• Created database objects, tables, indexes, writing procedures,SQLscripts.
• Created complex and reusable Macros and used existing macros for Data Cleansing, Validation analysis and Report generation.
• Provided statistical programming expertise in production of high level Reports using proc report.
• Comprehensive skills in working with SAS/BASE, SASEG, SASEBI,SAS/MACRO etc. in windows and UNIX environment.
• Prepared detailed summaries and reports for the pharmacy and health claims data using SAS Data step and various statistical procedures like proc sql, proc summary, proc report,Proc Tabulate, ODS statements and Proc Template to generate output formats in HTML Excel and RTF.
• Used putty to communicate with the data on the Unix server. Wrote Unix commands to tar, zip, unzip files and move files from one to other directory etc.
• Extensive use of SAS Macros in the creation of new programs as well as modification of existing programs to improve ease and consistency of results.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.
• Performed Pharmacy Claims data analysis for in-network/out-of-network claims.
• Performed Pharmacy/Health enrollment analysis and reporting.
• Performed Participating/Non-participating provider data analysis.
• Perform pharmacy claims data extraction and analysis to produce reports evaluating the potential financial impact associated with implementation of medical policy claim edits.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Created and used multiple SAS stored processes to generate high level summaries with conditional highlighting through SAS code by using call define statements in proc report.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web. .

Environment: Windows XP,SASEG,SAS9.1.3,SAS/BASE,SAS/MACROS, SAS/ACCESS,SAS/SQL, Oracle, MS SQL, Unix, Tableau 5.

Confidential

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks
• Involved in Extraction, Transformation amp, Loading (ETL) process and used Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drilldown Reports.
• Experience in writing custom code expressions in SSRS.
• Created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joins for applications.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or cube processing or other ETL jobs didn't interfere with each other. Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Followed agile methodology and coordinated daily scrum meetings.
• Performed data cleansing for accurate reporting. Thoroughly analyzed data and integrate different data sources to process matching functions
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).

Environment: windows XP, MS SQL Server 2005/2008, SQL Server Management Studio, MSBI (SSRS, SSAS, SSIS), MS Excel, T-SQL, ERWIN.