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.
• Hands on experience in configuring and using ecosystem components likeBigdata, HDFS, MapReduce, Oozie, Hive, Sqoop, Pig, Flume, Hbase and Zookeeper.
• 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 throughStored 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).
• Expertise in Normalization/De-normalization techniques for effective and optimum performance in OLTP and OLAP.
• Hands on experience in SAS programming for extracting data fromFlat files,Excel spreadsheetsand externalRDBMS (ORACLE, MySQL, DB2, Sybase) tablesusingLIBNAME and SQL PASSTHRU facility..
• Expertise in Data Manipulations usingSASdata step, such asSASFormats/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 using SAS enterprise miner.
• Extensive knowledge of advancedSAS/STATprocedures including PROC REPORT,PROC TABULATE,PROC CORR, PROC GLM, PROC ANOVA, PROC LOGISTIC, PROC TTEST, PROC GPLOT, PROC REG, PROC FREQ, PROC MEANS, PROC UNIVARIATE.
• Expertise in creating mapping models to map the business models with the star schema logical database models using SAS Information Map Studio, and store in metadata server that enables business users to readily generate the analytical reports using SAS Information Delivery portal and SAS Web Report Studio.
• Hands on experience using BI tools like SAS Data Integration Studio and SAS Marketing Operations. Strong knowledge on SAS HPA architecture
• 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 inTableauusing 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 inTableau.
• Created Dashboards style ofreportsusingQlikviewcomponents 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.
• Experience in creating Ad-hoc reports, subscription reports by using Report Builder in SSRS.

TECHNICAL SKILLS

Programming: C, C++, JAVA, R, Python, 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

Hadoop/Bigdata: HDFS, Map Reduce, HBase, Pig, Hive, SOLR, Sqoop, Flume, Puppet, Oozie, Zookeeper

NOSQL: HBase, Cassandra, MongoDB, Accumulo

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/SQLscripts for data manipulation, validation and materialized views for remote instances.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop 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 usingSAS/Base.
• Query Data from Hadoop/Hive&MySQL data sources to build visualization inTableau.
• Facilitated the automation process for the Delinquency Report -This report was required to run on a monthly basis
• Created Macros and used macros created by other users.
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• Validated regulatory finance data and created automated adjustments using advanceSASMacros, PROC SQL, UNIX (KornShell) and various reporting procedures.
• SAS/STAT procedures such as UNIVARIATE, FREQ, and MEANS were used to carry out analyses and the SAS REPORT procedure is generally used to display results.
• Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such asSAS/Base,SAS/Macros,SAS/Graph,SAS/SQL andSAS/STAT.
• Experience in documenting data mapping from source to target.
• Developed statistical reports with Charts, Bar Charts, Boxplots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Extensive use of Proc freq, Proc Report and Proc Tabulate for reporting purposes.
• 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.
• Working as first point of contact for science team users in case of any issues with SAS products while connecting to servers, or running code in batch mode or issues with servers while performing grid testing.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop. Involved in creating Tree Map, Heat maps and background maps.
• 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 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.
• 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.
• Created Dashboards style ofreportsusingQlikviewcomponents like List Box, Slider, Buttons, Charts and Bookmarks.

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,Qlikview9.0 SR2.

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.
• 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.
• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers, SQLJoins and other statements for reporting.
• Use of PROC IMPORT procedure to import excel file into SAS.
• Also created and maintainedSASdatasets 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 createdTables 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 usingSAS/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 theSASprograms onUNIXplatform to process and extract terabytes of data from different data warehouses and prepare datasets for ad-hoc analysis and business reporting.
• ConstructedSASprograms onUNIXplatform to clean the data according to the specifications.
• UsedSAS Macrosand procedures likeProc SQL, Proc Transpose, Proc Univariate, Proc Means, Proc Freq.
• Developed and designed different SAS programs to analyze financial data.
• Extensively used procedures like PROC FREQ, PROC SUMMARY, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT to make reports.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/ STAT, and SAS/GRAPH.
• Created the New Dimensions, Shared Dimensions, and Time Dimensions and implemented those dimensions while generating Cubes from SSAS.
• 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, SQLServer Management Studio, TSQL, Business Intelligence Development Studio (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 inSQLqueries.
• Coded complexSQLqueries 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/SQLlike 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 fromSASusing Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT (tab delimited) and .CSV (comma delimited) files intoSASdatasets for analysis.
• Extensively usedSAS/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.
• Performed tasks for software installations, windows security patch installations and license renewal on LINUX SERVERS. Worked on Data warehousing. Worked on Analysis, Development, Design, Testing and Reporting of ETL tools.
• Released the reports through UNIX shell scriptingevery month based on requirement.
• Involved in writing code using BaseSAS&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.
• UsedSASProcedures like PROC FREQ, PROC SUMMARY, PROC MEANS, PROC SQL, PROC SORT, PROC PRINT, PROC Tabulate, PROCUNIVARIATE, PROC PLOT and PROC REPORT to generate various regulatory and ad-hoc reports.
• Created reports in the style format (RTF, PDF and HTML) usingSAS/ODS.
• Built complex formulas in Tableau for various business calculations.
• Developed Geo/Area Maps to show details on which states have more patients 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 inTableauDesktop and published them toTableauServer 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, Newark, NJ

Sr. Data Analyst/ SAS programmer

Responsibilities:

• Worked with Health care data which includes membership 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/SQLpackage 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 withSAS/BASE,SASEG,SASEBI,SAS/MACRO etc. in windows and UNIX environment.
• Prepared detailed summaries and reports for the pharmacy and health claims data usingSASData 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.
• Performed QC and Edit Checks using various procedures and Macro facility. Coded Independent Programs for validation of analysis dataset.
• 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 ofSASMacros 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.
• Extensive Use of Data Null techniques for producing highly formatted and highly customized reports.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Created and used multipleSASstored processes to generate high level summaries with conditional highlighting throughSAScode 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. • Scheduled the published dashboards from Tableau Server on weekly basis.

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 CreatingComplex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drilldown Reports.
• Experience in writing custom code expressions in SSRS.
• Designed & created OLAP Cubes with Star schema using SSAS.
• 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.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and also Perspectives within the OLAP cube.
• 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.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• 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.
• Created the logical and physical data modeling using Erwin tool.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• 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.