SUMMARY

• Over 10 years in Design and Development and Application Support. An Experienced SAS professional with demonstrated hands on experience in Data warehousing, Application development using SAS 9.1 and SAS/EG 5.1,
• SAS DI, SAS /SQL and Business Objects reporting. Exposure in different technologies gives complete understandability of all the layers of entire application
• Certified as Base SAS programmer from SAS institute 7 Years’ experience in Financial and Banking area in collections department
• 3 Years’ experience in Healthcare/Pharma experience in data analysis Market Mixed Modeling
• Hands on experience on Tableau 9.3, Business Objects reporting. Migrated SAS reports to BO and also created Adhoc reports using Business Objects Webi tool.
• Knowledge on SAS ETL, Reporting using SAS - BI and Stored Process.
• Expert in Data warehouse and Data Mart Design estimations, resource planning, development and deployment.
• Connected to Teradata, Oracle, DB2 and Netezza databases using SAS/ACCESS explicit SQL pass-through facility and libname statement in both UNIX and windows environments.
• Delivering high quality work on Clinical Trials, health care, Insurance data and Banking analysis and reporting
• Understanding the Business Process, Client Interaction and Gather new report requirements for different business process, drawing out a plan for releases of the new reports and enhancements for the reports requested by the users and planning work for subsequent releases.
• Developing advanced macros based on algorithm to pull the data from the SAS server
• Data preparation Cleansing, Standardization, Duplication, Formatting using SAS
• Willing to learn and adapt to new environment. Working experience with UNIX and WINDOWS environments. Optimize SAS code for better performance, Document business rules and publish across to the Business, Process Automation and Model enhancement on demand
• Knowledge on forecast/ Predictive analysis based on historical data can produce accurate estimated values
• Good knowledge on SDTM and Adam concepts

TECHNICAL SKILLS:

Tools: SAS/BASE, SAS/MACRO, SAS/ODS, SAS/SQLSAS Enterprise Guide V 5.1SAS/DI Studio, SAS Management Console, Platform process manager. Control-M

SAP Business Objects / Tableau: Basic knowledge on Hadoop, SDTM AND Adam concepts

Databases: ORACLE, Sybase, SQL Server, Netezza, Teradata

Operating System: Unix-Linux, Win2000/XP/NT, DOS, IBM-AIX

PROFESSIONAL EXPERIENCE

Confidential San Antonio, TX

SAS Developer Analyst

Software used: SAS EG, Tableau 9.3, SAP Business Objects XI R4,R3 Crystal Reports2008, 2011, 2013, Dashboard

Responsibilities:

• Understanding the Business Process, Client Interaction and Gather new report requirements for different business process, drawing out a plan for releases of the new reports and enhancements for the reports requested by the users and planning work for subsequent releases.
• Creating technical design document, existing BI system framework document and application functional document
• Effort estimation for implementation of projects, change requests and enhancement requirements
• Performing Detailed Design, Develop, Assist in development, Integration and Deployment of the Bank processes.
• Responsible for creating BO universe and Bo reports for strategic solution and responsible for coding based on technical specifications using SAS Enterprise Guide and SAS Macros and self-service reporting to provide tactical solution
• Creating Adhoc reports using Tableau
• Responsible for incorporating optimization techniques on BO Universe and BO reports and SAS Processes to reduce processing time and increase code efficiency.
• Responsible for Production support of business-critical BO reports and dashboards and scorecards to ensure data availability per defined SLA
• Responsible for co-ordination and integration between onsite and offshore development teams and to steer knowledge transfer sessions with offshore team
• Validate Ad-hoc report requirement scenarios and deployment testing before releasing to stakeholders
• Bug fixing of any error occurs during report validation and track the defect to identify the root cause of the issue.
• Production defect analysis and code debugging to ensure RTS (Return to service) and business continuity
• Analyzed the data using SAS/STAT procedures PROC FREQ, PROC MEANS, PROC SUMMARY

Confidential, TX

SAS Developer

Software used: SAS/Base, SAS/Macros, SAS/EG 4.3

Responsibilities:

• Understanding the Existing ETL SAS process and confirm the Source and Target mappings for Universe development.
• Involved in creation of automated self-service reports using Excel Pivots to
• Retrofit existing manual processes.
• Extracted data from Oracle and flat files as per implemented Business logic and loaded into targeted Staging database.
• Developing parallel jobs Using stages likeDataset, Sequential file, Copy, Join, Modify and Transformer Etc.,
• Responsible for preparation of Technical Specification Documents.
• Meet with Business team and gather the requirements
• Create analysis and design documentation for Architects approval
• Post development activities such s move the scripts into production and scheduled jobs
• Maintenance and support.

Confidential

SAS Developer & Enhancement

Software used: SAS/DI Studio, SAS Management Console, Platform process manager

Responsibilities:

• Metadata was established on server in UK to maintain different source systems data like SAP for Sales and TURBO for insurance. SAS ETL connects to metadata and pulling data by using different filters. Once data is pulled and applied transformations to feed target systems like REPO, SFDC(Sales force dot com). Jobs are developed in SAS/DI studio and scheduled in management console. Process flow manager is a tool where job status can be monitored. Apart from this weekly reports generated by using SAS/BASE.
• Developed various SAS documents like Run book and SAD are explaining over view of project and SAS activities.

Confidential

SAS Developer

Software used: SAS/Base, SAS/Macros

Responsibilities:

• Developed advanced macros to pull the data from the different servers like Mainframes and transforming as a derived dataset
• Merge all datasets as a single customer view for different policies and products for standardize. Finally loading single customer view data into BA SAS Unix server

Confidential

SAS developer

Software, O/S Tools used: SAS/Base, SAS/Macros, SAS/EG

Responsibilities:

• Developing an advanced SAS algorithm to come up with automation for the College Savings Plan 529 Product. Developing advanced macros based on algorithm to pull the data from the SAS server and transforming as a derived dataset for standardize the process and finally loading into various libraries for generating reports to identify active member segments and similar segments in the non-active member group, for whom the client wanted to develop a sales campaign.

Confidential

Process Analyst

Software, O/S Tools used: SAS/BASE, SAS/MACROS, SAS/EG and SAS/SQL

Responsibilities:

• Data extracting, modification and validation before being used for reporting
• Generate daily, weekly, monthly and yearly reports by using SAS/EG. Automation by using SAS macros. Twelve-member team was involved in the development, validation and automation of reports generated for weekly, monthly and yearly by using.

Confidential

Process Analyst

Software, O/S Tools used: SAS/BASE, SAS/MACROS and SAS/SQL

Responsibilities:

• Program routine data displays, such as data listings, in accordance with approved statistical analysis plan and shell displays for clinical research studies.Code is to be written using Base SAS programs, SAS procedures and standardized macros.
• Validating derived datasets based on the Standard datasets.
• Generating, QC & Validation of Listings and tables using SAS.
• Validating Macros as per the request sent by the clients and writing test cases to the requests.
• Developed SAS program code and / or modify existing programs to load and analyze the data from the source and created listings & Tables.