SUMMARY:

• Senior SAS Consultant with SAS base and advance certified, having over 6.5 years of SAS/SQL programming/analysis experience on Windows and UNIX environment with knowledge on methodologies, applied in Health care, Financial and insurance sectors.
• Experience in all phases of Software Development Life Cycle (SDLC) including Requirements, Analysis/Design, Development and Testing.
• Extensive experience in SAS/SQL programming and data analysis on Windows, UNIX and Mainframe environments.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT
• Extensive experience in working with Base SAS (MACROS, Proc SQL , ODS), SQL, SAS Grid, SAS Enterprise Guide, Enterprise Miner , SAS/ ACCESS and SAS/DI in UNIX, Windows environment.
• Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions.
• Experience in agile and waterfall project management methodologies to produce high - quality deliverables that meet or exceed timeline and budgetary targets
• Experience in designing SAS VA, Tableau reports using VA Data builder, VA Explorer, VA Designer, VA Viewer and creating custom reports in SAS VA.
• Worked on analysis of JCL scripts for IBM MVS Mainframes to understand different Jobs.
• Responsible to create and modify JCL and to create and run SAS Mainframe jobs and analyze SAS Mainframe reports
• Experience in handling client meetings for updating current projects and to discuss on further projects.
• Have strong experience on working with Data which includes various Healthcare claims and Membership.
• Experience in Base SAS, SAS Enterprise Guide, enterprise miner, SAS/AML, SAS/Stat, SAS Macros, SAS/Graph, SAS/Connect, and SAS/Access on Windows and Unix platforms and competence in carrying out statistical analysis of large-scale data
• Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results
• Quality assurance procedures of other programmers' work, validating, debugging, documenting and optimizing SAS programs for QC and QA
• Using ODBC to connect SAS System with relational database management systems, such as Microsoft SQL, SSRS, and Oracle, to retrieve data and create SAS datasets
• Experience with export SAS Results to different formats such as XML, PDF, Excel using SAS/Export, SAS/ODS for reporting and presentation.
• Experience working with marketing team to conduct exploratory data analysis and Expertise in statistical, quantitative and analytical data in financial sector
• Leverage technology and business process skills to generate innovative solutions to address client business problems. Possess strong ability to quickly adapt to new applications and platforms.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/BI, SAS/DI, SAS VA, SAS/ODS.

Databases: SQL server, Oracle, IBM Informix, Teradata SQL Assist.

Operating Systems: Windows, UNIX, Linux.

Languages: JCL

Other Tools: MS Office, Tableau, SSRS, SQL, Putty, Reflection, SAS VA, Reflection, Teradata SQL Assist.

WORK EXPERIENCE:

Senior SAS Programmer/ Data Analyst

Confidential, Wilmington, Delaware

Responsibilities:

• Implement solutions to meet high end business needs using SAS.
• Extensively worked on AML (Anti Money Laundering) data and generated monthly and quarterly reports.
• Extensively used Enterprise Guide, miner/Mainframe Platforms to get connected to various database and other flat file resources to collect information on ALERTS and CASES.
• Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse using SAS, SQL and Macros with better and accurate values.
• Complete analysis of transactional information to identify risks, trends, and potential suspicious activity related to Anti-money laundering and other criminal activities
• Analyzed customer spending patterns, and purchase frequency to create clusters for customer relationship management (CRM)
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE, UPDATE and PROC SORT.
• Gathering Business requirement through meeting and conferences with clients and suppliers.
• Worked on pre-defined roles of Tableau, SAS VA, SAS DI to view, analyze the reports on a bimonthly basis
• Perform a 60 days observation and conduct RCA on all the suspicious accounts before submitting the SAR report to the client.
• Decreased the run time of the existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS variable values instead of multiple IF statements.
• Connected various databases (DB2, Teradata SERVER) such as development and production database (Teradata on UNIX) using SAS/ACCESS
• Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Creation and maintenance of mainframe execution JCL (jobs) to support system replacement project in User acceptance (UAT) and Production environments.
• Worked with the client to develop marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics.
• Develop credit risk analysis model based on FICO score and categorize the customers.
• Experience in implementing fraud management system to prevent credit and debit card frauds and protect customers from fraud.
• Produced risk-rating scores for multiple investments using the company's proprietary risk rating engine as well as personally generated models and techniques.
• Managed multiple projects in a fast-paced environment meeting milestones and deliverable dates with no supervision.
• Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data.

Environment: SAS EG, SAS Enterprise Miner, SAS BI, Mainframe (Reflection), Tableau SAS EM, SAS DI, Microsoft SQL, IBM Informix, SSRS visual analytics, Putty, Teradata, Oracle, MS office.

Senior SAS Consultant

Confidential, Portland, OR

Responsibilities:

• Experience with analysis of Claims Data, Membership Data, and Sales Rep data in healthcare industries.
• Design and select appropriate SAS procedures for each statistical analysis, test-run SAS program on mock data to ensure smooth analysis implementation.
• Responsible for developing and submitting JCL jobs in Mainframe to complete various Weekly, monthly and quarterly processes.
• Implementation of end-to-end ETL Process for IBM mainframe Operating System.
• Responsible to create and modify JCL and to create and run SAS Mainframe jobs and analyze SAS Mainframe reports.
• Lead and managed Health Risk Assessment project which electronically fed data files from vendor.
• Analyze the Add & Term reports of each region using SAS tools like PROC FREQ, proc tabulate , proc report , Proc mean, Proc transpose .
• Creating PHI(Personal Health Information) reports in HTML, PDF and RTF formats using SAS/ODS facility
• Used SAS VA, SAS DI to represent the categorization of patients based on the Add & Term results
• Involved in Gathering and Analyzing Business Requirements and Detail Technical Design of ETL.
• Produce reports to identify potential patients that meet the requirement for defined parameter.
• Produce and manage annual hospital performance review packets. The packets will include membership, revenue, and cost analysis for the hospital.
• Maintain relationship with around 1500 suppliers so as to know the current market scenario and to help our client with the best possible supplier.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Develop an understanding of relevant business processes, goals, and strategies for each individual healthcare client in order to provide comprehensive data analysis.
• Attend weekly meetings with the client to update the progress and to recommend required changes.
• Integrated analytic code written in Base/SAS, SQL, and SAS/Stat to create a point-n-click reporting environment.
• Maintain a healthy bridge between my team and client as a we never missed any deliverable nor had any escalations.
• Independently digging through the root cause of problems in Data, backend tables, databases, SQL code or SAS programs and describing the nature of technical issue.
• Provide proper validation, including testing and documentation (e.g., requirements document, program validation), in accordance with company standards.

Environment: SAS Base, SAS/SQL, SAS/STAT, Reflection, Epic Systems, Web Portal, IBM Informix, Teradata SQL Assist, ETL, Oracle SQL developer, MS office, UNIX, Windows, SAS/Access Oracle, PUTTY.

SAS Programmer/ Data Analyst

Confidential

Responsibilities:

• Assists in maintaining the company’s credit facilities and relationships including credit renewals, refinancing, future planning, and fulfilling all reporting and compliance requirements.
• Independently create, execute, maintain, and validate programs that transfer data across multiple data management systems or operating systems.
• Coding SAS/SQL programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
• Performed market research client on loan request information in commercial lending, BSA/Anti-Money Laundering (AML) Administration and third-party applications.
• Design and develop stored procedures, functions, views and triggers to be used in the ETL process
• Assists in long-term planning and budgeting processes, especially in the areas of cash and credit functions.
• Built summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC FREQ .
• Used SAS VA for designing end report in more creative way to the client by using all the features like network diagram, information maps, etc.
• Analysis included Behavioural model, Customer Profiling, Segmentation, Trend Analysis, and Predictive Modelling, Optimizing open-ended offers, etc.
• Created and Automated Daily, weekly and monthly analysis on the sales of all product categories
• Perform Data analysis, statistical analysis; generate safety and efficacy tables, listings and graphs using Base SAS, SAS Macros.

Environment: SAS BI, Windows, web portals, SAS visual analytics, Teradata, MS office, Tableau, Oracle Sql developer.

Data Analyst/ SAS

Confidential

Responsibilities:

• Worked with researchers to create analytic files using administrative health care data.
• Designed and developed SAS DQI codes for the Vendor transition (VT) and target by drug Campaigns.
• Created different types of summery tables and listings tables using PROC MEANS, PROC TABULATE, PROC REPORT.
• SAS Utility/Macro creation for global use, involved in Coding analyzing, Report generation and testing programs using SAS/Base, SAS/Macro, SAS/STAT and SAS/SQL to the Client requirements.
• Extensively used Data Null and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files
• Create, execute, maintain, and validate programs that generate listings, tables and figures using SAS programming, macros, SAS/GRAPH, and SAS/STAT
• Perform secondary research to identify potential suppliers in the market and to analyze the latest trends of our incumbents.
• Make recommendations with regard to the storing of relevant benchmarks, reference data, and metadata needed for state of the art Data Quality Analytics program.
• Communicated very well throughout the team for implementation and changes of codes
• Maintained proper work instructions of various processes and updated as and when required.

Environment: SAS, SQL, Teradata, MS Office, Databases, PUTTY, SAS/BASE, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/ODS, ORACLE, Windows, Excel, SQL