SUMMARY

• 7+ years of experience in IT as a Programmer/Analyst with profound experience in Financial, Retail, Mortgage and Health care industries.
• Expertise in BASE SAS programming,SAS /Macros programming and debugging, experience in teh skills inSAS /BASE,SAS /MACRO,SAS /SQL,SAS /GRAPH,SAS /ACCESS,SAS /ODS.
• Utilized Enterprise Guide and its functionality to create project flows which could include aspects of data access, manipulation, summarization, and report generation to a variety of output formats and channels.
• Experience in analysis, design, development, testing and implementation of SAS programs, Macros and report generation tools.
• Strong experience in coding using SQL,SAS /SQL,SASmacros.
• Modification of existing SAS programs and creation of new programs usingSASmacros to improve ease and speed of modification as well as consistency of results.
• Experience in using different relational database management systems like DB2, Teradata and Oracle.
• Experience working on different operating systems (Unix, Windows)
• Created and customized Macros for use in data cleaning, initialization, creation of analysis, datasets and report generation for business.
• Followed System Development Life Cycle (SDLC) methodology for teh design, development, implementation, and testing of variousSASmodules.
• Experience in creating test scenarios to find errors and confirm programs meet specifications. Program Documentation and Review.
• Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel, MS Visio, MS Project Management, Lotus Notes and MS Outlook.
• Excellent communication, analytical, interpersonal, presentation and problem solving skills.Experience in updating and creating documentation of code, guidelines, and high level documentation.
• Writing "Edit Check" programs for data validation. Creation and validation of Analysis Datasets.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels. Ability to work effectively both as an individual and as part of a team.
• Exceptionally well organized. Enthusiastic, innovative and challenge oriented.
• Ability to quickly adapt to new applications and platforms.

TECHNICAL SKILLS:

Operating System: Windows 95/98/2000/XP/07/Vista, DOS

Data Base: Oracle, DB2, Teradata, Sybase.

Statistical Packages: SAS 8.x 9.x (BaseSAS,SAS /STAT,SAS /SQL,SAS /MACROS,SAS /GRAPH, SAS /ACCESS,SAS /ODS),SASEnterprise Guide.

Application Software: Platforms Windows and UNIX.

Programming Languages: SAS, SQL, C, C++, Core JAVA.

PROFESSIONAL EXPERIENCE:

Confidential, AZ

SAS Programmer

Responsibilities:

• Converted teh weekly, bi - weekly, monthly and quarterly reports from ad-hoc database to new data warehouse usingSAS, SQL and Macros with better and accurate values.
• Experience in creating reports inSASEnterprise Guide v4.2/4.3
• UtilizedSAS /ACCESS to extract data from Sybase and other relational databases for analysis.
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE, UPDATE and PROC SORT.
• Designed, developed, tested and debugged new MACROS and modified teh existing macros according to teh enhancements in teh business.
• Worked on edit check programs to maintain data consistency and data validation.
• Production Job Scheduling and Monthly Run.
• Worked on ad-hoc requirements and later converted them as monthly and quarterly reports.
• Developed and maintained teh regular codes and made some amendments as per teh business changes.
• Written effective new codes to get teh required analytical summary data.
• Transformed teh statistical data in various formats (excel, access) intoSASdata sheets. Provided statistical programming expertise in teh production of analysis, tabulations, reports and listings.
• Developed programs for cleaning, transforming and modifying teh data daily.
• Used baseSASandSAS /SQL to generate tables.
• Generated teh production reports and submitted with key observations and recommendations.
• ValidatedSASdata sets using PROC MEANS, PROC FREQ and PROC UNIVARIATE.
• Formatted HTML, RTF and PDF reports usingSASoutput delivery system ODS.
• Responsible to write theSASprograms to perform teh QA analysis/testing.

Environment: BaseSASv9.2,SAS /Macros,SAS /SQL,SASOLAP Cube Studio 4.2,SASEnterprise Guide v4.2,SAS /ACCESS,SAS /STAT, Sybase, Windows XP, UNIX, Project Management, UE Studio.

Confidential, Milwaukee, WI

SAS Programmer

Responsibilities:

• UtilizedSAS /ACCESS to extract data from Oracle and other relational databases for analysis.
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE and PROC SORT.
• Tested and debugged existing MACROS.
• Extensively used PROC REPORT and PROC TABULATE to create reports.
• Generated safety tables, which also involved in analyzing data and generating Reports.
• Created reports using teh DATA NULL and teh PROC REPORT for teh submission as per teh regulations and company standards.
• ValidatedSASdata sets using PROC MEANS, PROC FREQ and PROC UNIVARIATE
• Formatted HTML, RTF and PDF reports usingSASoutput delivery system ODS
• Worked with automation team to automate teh reports usingSAS /DDE and VB macros.
• Prepared extensive summary for clinical data research data.
• Performed quality control checks on tables, listing etc. generated by other team members.

Environment: SAS /BASE,SAS /MACRO,SAS /Access, Enterprise Guide,SAS /STAT, MS-Excel, Visio, ORACLE, Windows XP.

Confidential, Los Angeles, CA

SAS Programmer

Responsibilities:

• Converted teh weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse usingSAS, SQL and Macros with better and accurate values.
• Experience in creating reports in SAS Enterprise Guide v4.2/4.3
• UtilizedSAS /ACCESS to extract data from Sybase and other relational databases for analysis.
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE, UPDATE and PROC SORT.
• Designed, developed, tested and debugged new MACROS and modified teh existing macros according to teh enhancements in teh business.
• Worked on edit check programs to maintain data consistency and data validation.
• Production Job Scheduling and Monthly Run.
• Worked on ad-hoc requirements and later converted them as monthly and quarterly reports.
• Developed and maintained teh regular codes and made some amendments as per teh business changes.
• Written effective new codes to get teh required analytical summary data.
• Developed programs for cleaning, transforming and modifying teh data daily.
• Used baseSASandSAS /SQL to generate tables.

Environment: Windows XP,SAS9.1,SAS /Macro,SAS /ODS,SAS /SQL,SAS /STAT, Excel, Proc SQL, PCSAS, Teradata, ETL.

Confidential

SAS Programmer

Responsibilities:

• Develop, enhance & execute complex programs and reports with proper documentation.
• Comprehend production codes, undertake diagnosis, resolution of complex issues and improve teh efficiency of processes and programs.
• Develop business domain expertise, rudimentary project based business knowledge and good theoretical knowledge of tools likeSAS, MS office Independently delivers end to end on complex projects and assist in developing and testing new information infrastructure.
• Manage end-user expectation in teh delivery of projects within agreed timelines and as per agreed quality standards.
• Independently executes standard processes, implements predefined algorithms and corrects identified problems.
• Maintaining large data sets, i.e. reading in data from various sources in various formats to create SASdata sets and/or ASCII files.
• Documenting teh process, i.e. documenting all teh possible information about teh application like SASprograms, DATA files and source.
• Preparing project plan for teh execution.
• Independently interacts with business partners to understand business need and translates to technical specifications. Assist in developing and testing new information infrastructure.
• End to end project management and hands on delivery when required.
• Take ownership and actively manage project timelines. Execute standard reports, processes, files, and implements predefined algorithms
• Sets up QA/QC framework and ensures adherence and constant improvement.
• Develops business and technical knowledge of team members and identifies opportunities of improvement.

Environment: SAS, BASE/ SAS,SAS /MACRO,SAS /SQL,SAS /CONNECT,SAS /ACCESS, SAS /ODS, Oracle, Teradata, DB2, UNIX and Windows 2003/XP.