SUMMARY:

• 7+ 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.
• 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).
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS) and defined Data Source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Expertise in Normalization/De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Developed Merge jobs in Python to extract and load data into MySQL database.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets 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 using SAS enterprise miner.
• Extensive knowledge of advanced SAS/STAT procedures 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.
• 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.
• Used Test driven approach for developing the application and Implemented the unit tests using Python Unit test framework.
• 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 reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Experience in creating Ad-hoc reports, subscription reports by using Report Builder in SSRS.
• Extensively used Teradata, SQL, BTEQ for the backend process to build the business rules
• Performing Ad Hoc reports by using Oracle, Teradata, BTEQ, and UNIX.
• Performing Ad Hoc reports using Oracle, Teradata, Bteq, and UNIX.
• Oracle Developer including SQL, PL/SQL, SQL*Plus Editor.
• Database analysis tools Teradata SQL Assistant, TOAD and ERwin. Data cleansing tool WinPure.
• Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
• Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.
• Formulated procedures for integration of R programming plans with data sources and delivery systems.
• Provided technical assistance for development and execution of test plans and cases as per client requirements

TECHNICAL SKILLS:

Programming: R, Python, SAS, Hive, Cobol,CICS,VSAM,JCL,Mainframe

SAS Tools/ Procedures: SAS/EG, SAS Enterprise miner, 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

NOSQL: HBase, Cassandra, MongoDB, Accumulo

Databases: Microsoft SQL server 2005/2008 , Oracle 10g, MySQL, DB2, Teradata,IMS,PUTTY,Oracle SQL Developer

Operating System: Unix, Mac OS and Windows, Mainframe,Z/OS

Machine Learning: R,Python

BI tools: Qlikview, Tableau, MSBI (SSIS, SSAS, SSRS),Data Cleaning,Data Blending, ETL, Data Wrangling, Data Mining, Data A-B Testing, Database design

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Sr . Data / SAS Analyst

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.
• Wrote Python scripts to parse XML documents and load the data in database.
• Used Python to extract weekly information from XML files.
• Developed Python scripts to clean the raw data
• Developed live reports in a drill down mode to facilitate usability and enhance user interaction
• Query Data from Hadoop/Hive & MySQL data sources to build visualization in Tableau.
• 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 advanced SAS Macros, PROC SQL, UNIX (Korn Shell) 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 as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL and SAS/STAT.
• Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Extensive use of Proc freq, Proc Report and Proc Tabulate for reporting purposes.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. 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 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.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.

Environment: Windows 8, SAS v9.4, SAS/EG, Python, SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, Oracle, Teradata, MS-Excel, Tableau 8.2, Qlikview 9.0 SR2.

Confidential, Indianapolis, IN

Sr. SAS/Data Analyst

Responsibilities:

• Worked with informatics department and I was responsible to build predictive models using clinical, survey, or administrative data in support of Informatics analytical projects.
• Extensively used Teradata-SQL Assistant and Advanced query tool to write SQL queries.
• Worked with various complex queries with joins, subqueries, and nested queries in SQL queries.
• Coded complex SQL queries 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.
• Built various graphs for business decision making using Python matplotlib library.
• Updated and manipulated content and files by using python scripts.
• Connected a Python based script to Teradata using the ODBC driver on Unix
• Extracted 3 years’ 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 datasets for analysis.
• Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• 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.
• Extensively used SAS enterprise miner and developed predictive models in decision tree, interactive decision tree, gradient boosting, 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.
• 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 compiled 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, SAS v9.4, SAS Enterprise miner, Python, SAS/BASE, SAS/ODS, SAS/MACRO, SAS/EG, SAS/SQL, UNIX, MS SQL, TERADATA, Teradata SQL Assistant, Access, Excel, Tableau 8.0.

Confidential, Fairfax, VA

Sr. Data Analyst

Responsibilities:

• Participated in list production for customer campaigns across a variety of products and marketing
• Coordinated with marketing department to finalize the list of individuals to whom the loan can be forwarded so that targeted campaign can be launched.
• Developed Macro programs to clean, validate and update data to perform data analysis and generate reports.
• Modified existing datasets using Set, Merge, and Sort, formats, functions and conditional statements.
• Debugged, Created maintained and documented adhocs reports on demands.
• Used options like DROP, KEEP and RENAME to work with some variables.
• Debugged, Created maintained and documented ad-hoc reports on demands.
• Used Teradata/SQL, Oracle, UNIX Shell Script, SPSS, STATA, R, MS Office (Especially advanced in Access, Excel VBA/Pivot Table & PowerPoint), and exposure to Business Objects.
• Provided database support to modeling and production team.
• Performed QA audits to ensure that all delivered files were validated by matching the output results to the business requirements.
• Created Tableau workbooks, dashboards using stack bars, Pie charts, bar graphs, scatter plots, geographical maps, Gantt charts.
• Generating code for HTML using VBA creating a new CustomUI.xml file for both PowerPoint and excel template
• Importing/exporting large amounts of data from files to Teradata and vice versa.
• Utilized ODBC for connectivity to Teradata & MS Excel for automating reports and graphical representation of data to the Business and Operational Analysts.
• Created various types of Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos
• Generated various Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos
• Analyzed Business Requirement Document LLDs and HLDs of both clients systems from technical and business perspectives.
• Responsible for creating and delivering recurring as well as ad hoc marketing campaign programming within strict timelines while under constantly changing requirements using SAS, SAS SQL, and Teradata SQL in a UNIX environment with Oracle, Informix, and Teradata relational databases.
• Worked on data pull and preparation of the customer list using SAS for marketing campaigns - Home Mortgage Non performing
• Queried QMF in IBM Mainframe Environment for data analysis
• Used FTP(File Transfer Protocol) to transfer files across platforms
• Analyzed the web based Product Offering Engine financial applications for the creation of credit card campaigns & involved in Mobile Payment Application
• Using SQL queries, extracted data for metrics reporting from a variety of systems, Including Loss Mitigation, Recovery and Business Banking.
• Conducted Consumer Lending analysis to evaluate financial risk and loss and to predict default loan performance.
• Developed analytical processes, statistical models and quantitative approaches, leveraging SAS ad hoc and automated reporting capabilities.

Environment: Teradata, Oracle 11g, Teradata, UNIX, Tableau, Qlikview, Hyperion Brio, Business Objects

Confidential, Newark, NJ

Sr. Data Analyst

Responsibilities:

• Worked with Healthcare 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/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, record stables and rebuild indexes.
• Created database objects, tables, indexes, writing procedures, SQL scripts.
• 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, SAS EG, SAS EBI, 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, 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.
• Wrote scripts in Python for automation of testing jobs.
• 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.
• 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 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. • Scheduled the published dashboards from Tableau Server on weekly basis.

Environment: Windows XP, SAS EG, Python, SAS 9.1.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle, MS SQL, Unix, Tableau 5.

Confidential, Wilmington, DE

Sr. Data Analyst

Responsibilities:

• Analyzed business needs and developed Technical Specifications based on interaction with Managers 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, SQL Joins and other statements for reporting.
• Use of PROC IMPORT procedure to import excel file into SAS.
• 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 Macros and procedures like Proc 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, SAS v9.2, SAS/EG, SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, MS-Excel, MS SQL Server 2005/2008, SQL Server Management Studio, T-SQL, Business Intelligence Development Studio (SSRS/SSIS/SSAS), Oracle 9i.

Confidential, Kansas City, MO

SAS Programmer/Analyst

Responsibilities:

• Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales organizations.
• Performed statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS and SAS tools.
• Integrate results of the Marketing Mix Analysis, Price Elasticity and other advanced analyses into business planning process.
• Assist in the creation of quantitative and qualitative primary research and present the findings.
• Ability to dig into raw data to find and evaluate actionable insights that will help the organization.
• Analyze and interpret significant results based on data summaries.
• Work closely with different Marketing Groups in designing and analyzing the data.
• Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.
• Perform Metadata (Information Map, OLAP, Enterprise Guide) development
• Direct the development, testing and maintenance of SAS-EBI reports
• Provide support for, and automation of, routine SAS-EBI stored procedures.
• Create Data Dictionary and migrate the data when shifting to new version of SAS.
• Perform statistical analyses and QC statistical output.
• Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g., PROC FREQ, PROC REPORT).
• Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.
• Provide SAS Programming support and technical assistance in the accurate development and intermediate steps required.
• Modeling SAS data stores (SAS OLAP / SAS OLAP Cubes) required to support business intelligence and reporting needs.
• Assist in Optimization of Performance for SAS OLAP Cubes (SQL to SAS, SAS OLAP Build Time,SAS OLAP slice and dice, SAS OLAP aggregations, partitioning, etc…)
• Present statistical results using the appropriate graphs, charts, tables and written reports.
• Creating ad-hoc reports.
• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Formatted HTML, RTF and PDF reports using SAS output delivery system ODS.
• Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.
• Tested and debugged existing MACROS.
• Used SAS DATA NULL and PUT statements to create the customized reports.
• Develop new macros for report generation using SAS/Macros as per the customer’s requirements.
• Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.
• Default Report output is HTML and provided the options of WORD & EXCEL formats using SAS/ODS statements.
• Used FTP to download SAS Formatted Data into EXCEL AND CSV format.
• Retrieving Millions of Records Using different Procedures.
• Used base SAS and SAS/SQL to generate tables.
• Used PROC compare to compare the data before and after editing
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports

Environment: SAS 9.1.3/9.2, BASE/SAS, SAS Enterprise Guide, SAS/MACRO, SAS BI,SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, Teradata, UNIX and Windows XP.

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.
• 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 subreports, 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.