SUMMARY

• 9 years of extensive BI Experience across Insurance, Banking and Financial services domains as a potential Developer and Analyst.
• Expertise in SAS with experience in Base SAS, Advance SAS, SAS/ACCESS, SAS/STAT, SAS/SQL, SAS Enterprise Guide.
• Hands on Experience in Data Quality Assessment, Data Profiling, Data Segmentation, Data Integration, Data analysis, Data modeling and Data Validation.
• Extracted data from SQL Server into data marts, views, and/or flat files using SAS/SQL.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down, drop down menus with parameterization using Tableau.
• Different data sources used for Dashboards include SAS Datasets, Oracle, Excel files, data Extracts, Custom SQL files.
• Excellent understanding of machine learning techniques and algorithms, such as k - NN, Naive Bayes, SVM, Decision Forests, etc.
• Skilled in Dimensional Modeling and ability to provide input in model development.
• Used SAS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Supported SAS processes in a production environment.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflakes modeling, fact and dimension tables modeling of data.
• Familiar with entire software development life cycle (SDLC) and various project methodologies such as Agile and Scrum Methodology.
• Experience in building complex SAS Data sets using various computational techniques.
• Experience in building/developing complex Reports using different Procedures.
• Experience in Data visualization tools like Tableau.
• Strong experience in identifying and mitigating potential risks in various business cycles, helping client monitor their business controls on a continuous basis.
• Excellent project management skills with demonstrated analytical, problem-solving, decision-making skills and the ability to drive results.

TECHNICAL SKILLS

SAS Product Experience: Base SAS, SAS Stored Process, SAS/ACCESS, SAS/Connect, SAS/Macros & SAS/STAT (only ODS).

Tools: SAS EG, Tableau, Python, R

Databases: SQL Server, ORACLE 10g/11g, MS Access, Teradata and OLAP

Operating System: Windows 10/ 8/7/Vista/XP, UNIX, Mainframes

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SAS Programmer Data Analyst

Responsibilities:

• Gathering user requirements analyzed and designed software solution based on the requirements
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis of projects within SAS
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level
• Creating database objects like tables, views, procedures, triggers, functions using SAS/SQL to provide definition, structure and to maintain data efficiently
• Building, publishing customized interactive reports and dashboards, report scheduling using SAS Procedures and SAS Macros
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Restricting data for users using Row level security and User filters
• Developing Tableau visualizations and dashboards using Tableau Desktop
• Working on Tableau workbooks from multiple data sources using Data Blending
• Migrated reports from Excel to SAS

Confidential, San Francisco, CA

Sr.SAS Data Analyst

Responsibilities:

• Report Vintage level analysis to the pricing strategy team
• Extracted raw data from Teradata using Pass through Facility and used SAS/Access to read it and ran statistical analysis using SAS/Stat.
• Performed report/universe optimizations in greatly reducing the run time of reports
• Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Developed, modified and generated Monthly and Quarterly Business Review (MBR) reports summarizing business activity using Proc Univariate, Proc Copy, Proc Transpose, Proc Report, Proc Tabulate and Proc Summary.
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (Proc append) from the existing source tables.
• Extensively worked with complex and huge datasets, and generated reports in various formats such as PDF, RTF, HTML and list files using SAS ODS facility
• Customizing the existing Macros according to the need and requirement, testing and debugging the Macros and creating more complex and reusable Macros
• Acquire knowledge and was involved in developing SAS Fraud Framework for Barclay Card
• Provided technical support to all team members during project execution
• Performed reports/dashboards performance optimization
• Involved in User Training of Tableau dashboards
• Helped in testing and impact assessment on dashboards with changes to the data warehouse
• Created test documents that help in validating reports and dashboards in QA.

Confidential, San Antonio, TX

Sr. SAS Developer

Responsibilities:

• Worked in conjunction with business analysts to develop, test and implement new production audit opportunities and trends
• Supported SAS processes in a production environment
• Focus on driving productivity and quality to aide business partners in achieving and exceeding monthly goals
• Provided production support for UCH
• UNIX Shell scripting for scheduling jobs on production
• Analyzed client's data files for quality, quantity, and accuracy
• Used SAS/SQL skills to identify data anomalies which may impact our processes
• Performed proof of concept analyses
• Developed, collected and analyzed metrics and data to formulate fact - based decisions and proactively implemented process improvements
• Used metrics, excellent time management skills and leadership skills to ensure business objectives and goals are met
• Developed and pioneered approaches to emerging industry trends
• Collaboratively worked on application architecture design, enhancements, and decision-making
• Organized and executed multiple re-occurring and one - off tasks and projects at one time

Confidential

SAS Programmer

Responsibilities:

• Involved in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Developed Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Developed Utilities for reading and writing files in ETL process
• Data analysis, reports using SAS procedures and SAS/Macros
• Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes
• Provided technical support for SAS Users
• Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/ExcelXP to get the output in multiple sheets

Confidential

SAS Developer

Responsibilities:

• Worked in an Onshore-Offshore model working with local client employees as well as global associates
• Data archival and Data migration, ad-hoc reporting and code utilizing SAS on Mainframes
• Worked on analysis of JCL scripts for IBM MVS Mainframes to understand different Procedures and Jobs executed
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC, TABULATE and PROC REPORT.
• Used the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access)
• Best Performer at IBM for Dun and Bradstreet Project for Q3 of Year 2009