PROFESSIONAL EXPERIENCE

• Certified SAS Advanced Programmer with overall experience of Five years 6 months 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, Monarch and ACL tool
• SAS EG tool to generate datasets in order to make decision by business and Monarch & 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, Xcelsius ), ACL, Monarch, Informatica, R

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

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

Operating System: Windows 7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, TX

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

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

Confidential

Technical Lead/ Developer

Environment: ACL, Monarch, VBA

Responsibilities:

• Analyzed the existing monarch projects and developed the document for requirement gathering.
• Developed the project in ACL 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.
• 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.

Confidential

Developer

Environment: Business Object, SQL

Responsibilities:

• Understand the requirement from customer
• 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 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.