Vasavi

SAS Progremmer

Employer Details:

Ganesh

ac6iz7@r.postjobfree.com

972-***-****

Experience Summary:

SAS Programmer with overall experience of 5 years working with SAS and SAS tools emphasizing on analysis, program development, QC and validation in real time industries on Windows and UNIX environment

Experience in requirements gathering, Process Flow, Work Flow design and development of functional specifications and system design specifications for client engagements and co-ordinating with Client partners

5 years’ hands-on experience with SAS & SQL. Developed Business Reports for decision making, automating and optimizing the SAS jobs. It helps forecast team to prepare the forecast plan.

Created Ad-hoc and summary reports using report and tabulate procedures

Performed data validation and developed study specific edit checks specifications.

Extensive experience with insurance product data analysis: product change analysis & Debit Card withdrawal analysis, creating tables, listing and generating reports and graphs.

Performed Data Mining using advanced SAS techniques like Proc Freq, means and univariate and compare.

Implemented BASE SAS, SAS SQL, SAS MACROS and PROC Statements. Created safety and efficacy Analysis/Derived Data sets from raw data sets. Helped to show the products trend in these multiple years.

Expertise in writing complex SQL queries, connecting multiple sources like Oracle, DB2, Netezza via SAS

Ability to analyse complex SAS codes

Have a good knowledge in SAS Performance Improvement techniques

Extensive knowledge in claims processing,underwriting, policy maintenance, policy maturity processing

Developed Proof of Concept in 'R' programming language

Experience in Insurance domain knowledge by analysing data from prominent reinsurers

Provided value added Benefits to the customers through automation/optimization of the UDA/Reports.

Monitor the SAS jobs and do the analysis on the Job failure, find the appropriate solution

Good exposure in SAS EG and ACL tool

SAS EG tool to generate datasets to make decision by business and ACL used for Data mining purpose

Automated the manual process in VBA(in both Excel and Access DB), it reduced manual intervention.

Collaboratively working with team and reach the customer expectation

Proactively taking the necessary action if needed

Reviews and edits requirements, specifications, business processes

Technical Skills

Tools : SAS EG, Control M Workload automation tool, WINSCP, Putty, Business Object (IDT, WebI,), ACL, Monarch, Informatica, R

Languages : SAS, VBA, SQL, Shell script, JCL, VB Script, Java

Database : MySQL, MS Access, IBM DB2, Netezza, Oracle

Operating System: Windows 7, UNIX

Professional Experience:

Project : UDA Clearing House Oct 2016 to Present

Client : Cigna, CT

Role : SAS Developer/Analyst

Environment : SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/ODS, Excel/Access 2000, UNIX, Mainframe, DB2, Netezza, SAS 9.2, SAS 9.4

Project description

UDA Clearinghouse -Designing and developing the application based on the user needs and requirement. Generating reports from huge dataset based on the customer needs/requirements. Handling the product information across multiple CoSA like Bank, FASG & PNC.

Responsibilities

Gather requirement from client. Generate the report based on the customer requirement using SAS concepts.

Performed quality checks on the existing table, listing and figures, Tested and debugged SAS programs against data.

Involved in code changes when the source data migrated from one platform to another (DB2 to Netezza)

Responsible for extracting the data, cleaning, manipulating, transferring and managing data in SAS.

Experience in entering, analyzing and coordinating data, generating tables, listings, graphs, and reports.

Extracted data from Oracle/DB2/Netezza table, performed quality checks, validated the data, and created SAS datasets. Modifying data using SAS code by importing, sorting, merging, and restructuring.

Analyzing the data sets, generating statistical reports using PROC tabulate, PROC report

Experience in data transformation and edit checks and experience in analyzing Case Report Form data.

Automate the process in SAS, then moving SAS jobs to control M. Continuously monitoring Jobs in the queue and troubleshooting the problems occurred in the SAS jobs

Applied advance SAS techniques on insurance products data to help forecast team to predict plan value.

Monitoring Control M Jobs - Used Control M Automation Tool to monitor the jobs and trigger it

Worked in real time data - PNC, Bank and FASG products

Debugging and correcting the syntax and semantic errors in the code.

Getting transition of the UDA sets from the process owners, analyzing, identifying and prioritizing the UDA/Reports, working on the key access issues needed to run the reports and finally creating the process documents for all the transitioned UDA’s.

Provide the Primary/Secondary support for the UDA/Reports transitioned.

Provide value added Benefits to the customers through automation/optimization of the UDA/Reports.

Prepare the test case for automation

Facilitate meetings with multiple stakeholders to understand the UDA

Harmonize & communicate with Clients for business clarifications and requirements

Responsible for delivering reports in SAS, Mainframe and Excel

Optimizing long running job in SAS and Mainframe

Involved in new initiatives and Proposal

Collaborate with other developers and deliver the migrating UDAs accordingly

Support Project Management activities like IPMS and Audit

Test and Defect Management in SAS/Excel Report Execution

Causal Analysis for defects in the report

Training new joiners regarding the process management and application usage

Producing Weekly Status Reports

Preparing Project Summary reports and Root Cause Analysis Report

Project : Monarch to ACL/SAS Migration Sep 2015 - Sep 2016

Client : Oasis outsourcing, GA

Role : SAS Developer

Environment : ACL, Monarch, VBA, SAS, Mainframe

Project description

Migrating Monarch projects into another platform (ACL & SAS). Analyse the existing monarch projects, understand the logics used in the Monarch tool, migrating the project into new technology called ACL and SAS. In ACL/SAS, tried to fasten the execution hours and provided the accurate result.

Responsibilities

Analyzed the existing monarch projects and developed the document for requirement gathering.

Developed the project in ACL/SAS with some improvisation.

Involved in testing and Bug Fixing Activities.

Experience with Gap Analysis to check the compatibility of existing systems with new business requirements.

Analyzing the requirements if users want to changes the existing projects or create the new one.

Scheduling the developed code in control M to avoid manual execution

Coordinating with offshore team to make sure there is no delivery slippage.

Preparing the status reports for the clients.

Conducting the UAT with end user for the migrated projects.

Project : Dashboard Migration Sep 2013 – Aug 2015

Client : Daiwacm, NJ

Role : SAS Developer

Environment : Business Object, SQL, SAS

Project description

The dashboards are designed to capture the KPIs to measure the performance on each MSR level. The single sign on feature enables to view all the metrics on all the hierarchy level. The dashboard shows an aggregated level and also the monthly breakdown of the KPIs which comprise Call performance of the organization.

Migrating the SAS jobs to BO reports and Dashboards.

Responsibilities

Understand the requirement from customer

Analyze the SAS codes to see the migrate the SAS jobs to BO reports and dashboards.

Prepared design documentation and KPI metrics and developed Universe design, reports and dashboard

Involved in Universe design.

Developed WebI reports, generated QWAAS

Designed graph in Xcelsius dashboard based on the user requirement in an interactive manner

Dynamically pulled the data based on the user input by integrating QWAAS in the dashboard.

Optimized the long running reports in SAS and WebI

Coordinating with offshore team to make sure there is no delivery slippage.

Preparing the status reports for the clients.

Conducting the demo meeting with end user to get signoff for the dashboard.

Contact this candidate