We provide IT Staff Augmentation Services!

Sas Developer/analyst Resume

TX

EXPERIENCE SUMMARY:

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

Hire Now