SUMMARY:

• Over 6+ years of experience in Statistical Analysis Software (SAS) for developing and implementing various applications.
• Solid Experience and Excellent command in various SAS procedures and tools like SAS/BASE, SAS/MACROS, SAS/ODS, SAS/ACCESS, SAS/ CONNECT and SAS/SQL in Mainframe and UNIX operating systems. Also worked in SAS EG for reports.
• Solid understanding and proficient use of various procedures like proc SQL, proc report, proc freq, proc means, proc contents, proc dataset, proc append proc import, proc export, proc print, proc sort.
• Expertise in storing and managing data in SAS files, merging SAS data sets, using ARRAYS and MACROS, SAS procedures (PROCs), PROC SQLs, SAS Formats and informats.
• Excellent command in writing complex script for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS on Mainframe
• Experience in using various MS office tools for analyzing, arranging and presenting data
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Good knowledge in software engineering methodologies
• Extensive experience in preparation of reports, tables, listings and graphs
• Strong leadership, interpersonal and oral/written communication skills
• Ability to work independently as well as collectively & willing to relocate
• Works in ITIL environment
• Exposure to Bigdata technology: Hadoop, MapR, Hbase, PIG,HIVE

TECHNICAL SKILLS:

Operating Systems: MVS Z/OS 1.13, Windows, Linux

Hardware: Z10 EC Multi-CPU Sysplex, Z196

Databases: DB2, MySQL

Programming Languages: JCL, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/ODS, SAS/ACCESS, SAS/ CONNECT and SAS/SQL

Tools: MICS, SMF, OPCA, TSO, Infoman, SAS EG

Other Skills: Perform/Predict, Excel, Technical Team Leadership, Customer Needs Assessment, Strategic Planning, Technical Training/Mentoring, Requirements Definition, Business Consulting, Forecasting, Risk Assessment, Project Scoping, Business Case Development

PROFESSIONAL EXPERIENCE:

SAS Programmer

Confidential,Green Bay, WI

• Extracted, updated and deleted data from DB2 Server using SAS/ACCESS and SAS/SQL
• Used PROC IMPORT to convert raw data files in different formats to SAS data sets
• Used PROC EXPORT to convert SAS data sets to formats specified by the end-user
• Read raw data files with missing values using TRUNCOVER and MISSOVER options
• Created SAS reports in external locations using DATA NULL statement with FILE and PUT statement
• Generated reports using BASE SAS procedures - PROC PRINT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY
• Created large data sets employing MERGE and SET statements in the data step
• Utilized SAS/ODS to create reports in PDF, RTF and HTML format
• Combined data vertically using SET statements, PROC APPEND and SET operators in PROC SQL
• Combined data horizontally using data step merge and by using match merging, in-line views in PROC SQL
• Conducted extensive data checks to ensure the reliability of data summarized and analyzed data employing pivot table and pivot chart in Excel
• Performed several statistical functions using SAS/STAT procedures and created one-way and Multi-way tables
• Created mailing lists of targeted customers using PROC FORMS
• Environment: SAS, SAS/BASE, SAS/ODS,, SAS/ACCESS, Mainframe MVS, MS OFFICE,

Capacity Planner

Confidential

• Designed and coded a wide variety of SAS programs to evaluate z/OS CPU, I/O and storage performance statistics. These programs extracted and utilized a variety of source data, including: MICS and raw SMF records.
• Classified the mainframe workload based on various job name standards.
• Monitoring and analyzing DB2, Batch and CICS workloads. Have the business updated about these workloads by providing various reports.
• Providing user usage reports to the business and users by dumping SMF records.
• Generated various chargeback reports (MICS, SAS) to business and departments based on the workload.
• Worked on sizing upcoming workload (jobs) based on its past consumption of CPU.
• Involved various scheduling workloads based on the system availability and the workload preference.
• Provided performance analysis for various UNIX servers by using some UNIX scripts and some HP performance agents.
• Timely monitored system busy status and kept informed the Operation/Business team to have the system utilized its max.
• Closely worked with vendor (HP) on increasing and decreasing MIPS based on current/future workload.
• Provided correct and clear mainframe cost forecast (Budget) for upcoming finance year to the finance team. This has completed by meeting various business department and their growth on next fiscal year.
• Worked with OPCA application to setup capacity jobs to run on regular time period.
• Involved in troubleshooting and performance fine tuning.
• Involved in MIPS optimizing projects by providing various reports to identify the correct work job.
• Worked with vendor for Z/OS upgrade and disaster recovery programs.