Analyst Programmer Resume Phoenix, AZ - Hire IT People

SUMMARY

Six years of experience in software design, analysis, development, maintenance, implementation and support as SAS Developer.
Extensive experience in BASE SAS, SAS Macros, SAS SQL in Mainframe and Windows environments.
Experience in designing, developing, enhancing and modifying SAS programs.
Expertise in Data Cleaning, Data Archival, Data Migration and Ad - Hoc Reporting utilizing SAS.
Experience in creating SAS Datasets and manipulating the data for the preparation of reports and tables.
Experience with concatenating, interleaving, and merging SAS datasets.
Experience in performing statistical analysis of data and reporting with SAS.
Expertise in ISPF, TSO and submitting the SAS script on Mainframe (MVS) using JCL
Experience in BFS.
Excellent problem solving skills for delivering useful and compact solutions.
Strong communication skills and ability to work individually and in a team.
Good Knowledge of ETL process
Extensive experience in the SAS functions such as DATE functions, NUMERIC functions, CHARACTER functions and the functions used in MACRO’S

TECHNICAL SKILLS

Operating Systems: OS/390, Z/OS, Win 98/NT/2000/XP

Programming Languages: SAS, JCL, COBOL, SQL

Databases: SAS Files, MS SQL, Teradata and DB2

Tools: TSO, ISPF, SPUFI, Changeman and Fileaid

SAS Software Products: SAS v 6.12/8.2/9.1 , Base SAS, SAS/Macros, SAS EG

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Analyst Programmer

Responsibilities:

Technical lead of the project which involved client, onshore and offshore team members
Developed SAS programs with the use of Base SAS and SAS/Macros to implement new models
Created SAS reports using Teradata table in SAS EG
Extensively used Teradata SQL assistant
Analyzed large data sets consisting of millions of records
Processed different kinds of inputs from the source files
Extensively used SAS procedures like Print, Sort, SQL, Means, Summary, Freq etc. and extensively used DATA NULL for reporting purposes
Generated reports in various client specified formats and provided documentation
Created output in CSV files and generated reports in excel spreadsheets

Environment: SASv9.1, Teradata, SQL, Unix, WinNT

Confidential

Analyst Programmer

Responsibilities:

Technical lead of the project which involved client, onshore and offshore team members
Involved in the client interaction, requirements gathering, analysis and documentation
Participated in design discussions and prepared the required documents
Developed SAS programs with the use of Base SAS and SAS/Macros to implement new models
Enhanced and modified the existing SAS codes
Debugged Macro Errors
Extensively used JCL
Analyzed large data sets consisting of millions of records
Imported data from different teams using NDM/FTP
Investigated data issues based on the defects and issues logged
Actively involved in all phases of the project life cycle.
Involved in client interaction, requirements gathering, impact analysis, data quality analysis, estimating the required effort, design and hands on coding.
Processed different kinds of inputs from the source files
Responsible for overseeing the design and development
Developed SAS programs using Base SAS and SAS/Macros
Extensively used SAS procedures like Print, Sort, SQL, Means, Summary, Freq etc. and extensively used DATA NULL for reporting purposes
Moved data set across platforms (from PC to Mainframe and Vice Versa)
Generated reports in various client specified formats and provided documentation
Created output in CSV files and generated reports in excel spreadsheets
Imported data from different teams using NDM/FTP
Investigated data issues
Improved the execution time
Implemented code review and unit test results review and code walkthrough process
Actively involved in conducting the system integration testing, regression testing,backend testing, user acceptance testing and end-to-end testing.
Responsible for implementation planning for the production move
Helped prepare the test cases, test plans, and unit testing plans
Prepared release communications in a timely and effective manner to the appropriate audience
Extensive used the SAS functions such as DATE functions, NUMERIC functions, CHARACTER functions.
Reviewed and streamlined outdated SAS code to eliminate errors and improve functionality
Optimized performance using Data Validation and Data cleaning Statistical procedures like PROC FREQ, PROC MEANS, PROC FORMAT, PROC TRANSPOSE, PROC SUMMARY and PROC COMPARE
Served as a point of contact between the business users and technical members of the team

Environment: SASv9.1, Mainframes JCL, SQL, WinNT

We provide IT Staff Augmentation Services!

Analyst Programmer Resume

Phoenix, AZ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship