SUMMARY

• Over 6 years of experience in developing Statistical Analysis and reporting applications in Financial and Telecommunication environments using SAS Software.
• Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ETL, SAS/ACCESS, SAS/QC, SAS/ETS.
• Experienced in Data management, data extraction, manipulation, validation, purification and analyzing LARGE sized data.
• Proficiency in writing maintainable, supportable, and well - documented SAS codes.
• Extensive programming experience with Proc Sql, Proc Report, Proc Print, Proc Means, Proc Freq, Proc Summary, Proc Tabulate, Proc Datasets, Proc Format, Proc Transpose, Proc Plot, Proc Chart, Proc Compare, Proc Append, Proc Import, Proc Export, Proc Explode, Proc Printto, Proc GChart, Proc Anova, Proc GPlot, data manipulations, informats, formats and SAS/STAT procedures.
• Extensive experience with merging, concatenating, and interleaving SAS datasets.
• Extensive experience in using PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically.
• Expertise in writing utility macros.
• Experience working on operating systems like Windows, UNIX, and IBM Mainframes.
• Good noledge of financial, sales and marketing data related to banking industry like account and transitional data, maturing CD’s and reports like line of business reports, lead generation list and direct mailing lists.
• Experience in writing JCL programs for batch submissions.
• Good working noledge of producing custom Excel reports using Data Null and Dynamic Data Exchange (DDE) technique.
• Excellent problem solving skills for delivering useful and compact solutions. Always keen and eager to face up to challenges by means of innovative ideas.
• Strong communication skills and ability to work individually and in a team.

TECHNICAL SKILLS

Statistical Software: SAS (Base SAS, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ODS, SAS/ACCESS, SAS/IntrNET, SAS/ETL, SAS/GRAPH, SAS/ENTERPRISE GUIDE)

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, DOS, IBM OS/390

Languages: SQL, PL/SQL, COBOL, JCL, Visual Basic, C, C++

Databases: Access, Oracle, Sybase, SQL-Server.

Software Packages: MS Office, Crystal Reports, Developer 2000, MATLAB, AutoCAD 2000

Web Technologies: HTML, Java Script, Front Page

PROFESSIONAL EXPERIENCE

Confidential, NY

SAS Programmer

Responsibilities:

• Analyzed current Mainframe environment.
• Installed and customized SAS.
• Migrated and made changes in SAS programs, to make them work in Unix without losing their functionality.
• Migrated SAS datasets from Mainframe to Unix.
• Made changes in SAS programs in Unix as per teh requirement.
• Created pseudo code of teh jobs (SAS programs) for teh easy understanding of code by teh non technical reviewers.
• Prepared documentation of code for Business Analysts.
• Identified teh input and output SAS files in JCL for teh purpose of documentation.
• Wrote shell scripts and awk scripts to track jobs running.
• Wrote Macros to develop a concise code.
• Modified teh existing SAS programs to save time and resources.
• Trained users to work in SAS.
• Involved in testing phases like unit testing and sub system testing.
• Maintained teh production jobs in Unix environment.
• Wrote JCL programs for submission of different SAS programs and data in batch files to teh mainframes (OS390).
• Created ad-hoc reports and graphs as per teh requirements of teh users.
• Involved in teh risk and loss analysis.
• Involved in updating and maintaining teh databases like Sybase and Oracle.
• Involved in platform independent application development using MQ Series.

Environment: Unix (HP-UX11), SAS V9 (in Mainframe and Unix), Shell Scripts, awk scripts, BASE SAS, SAS MACROS, SAS/ACCESS, SAS/CONNECT, SAS-SQL, MVS, JCL, Sybase, Oracle.

Confidential, Waco, Texas

SAS Programmer

Responsibilities:

• Performed SAS programming required for data analysis and reporting in Unix environment.
• Experience with developing ETL Processes using Base SAS Data Step processing code (writing ETL code in SAS).
• Created routine Customer mailing list for Direct Mailing and Telemarketing.
• Generated listing in Ad-hoc upon request by Client/Vendor using SAS, SQL and DB2 program.
• Extensively used proc SQL for creating ad-hoc reports and graphs as per teh requirements of teh users.
• Proc SQL, Proc Import, Proc Export were used to retrieve data from databases like Oracle, and Excel.
• Used SQL extensively to check teh data integrity, data verification and validation.
• Load flat files in to Teradata RDBMS using Loading tools.
• Created tables, views in Teradata, according to teh requirements.
• Involved in teh risk and loss analysis.
• Involved in updating and maintaining teh databases like Sybase and Oracle using SQL.
• Involved in teh design of teh data warehouse.
• Responsible for configuring teh ODBC drivers to connect to oracle database from SAS, which facilitated teh extraction of data.
• Involved in dynamic data exchange of data between different remote systems.
• Developed macros and views to integrate complex business rules.
• Developed Stored procedures for managing complex business logic.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for teh products purchased every month.
• Conducted individual account and household level analysis.
• Created Data Models for different level of Marketing based on teh reports.
• Presented teh results and statistical reports in PowerPoint for marketing staff.
• Used SQL and PROC SQL Pass Through Facility to work with Oracle, DB2.
• Worked with Enterprise Miner for marketing campaigns doing statistical analysis.
• Moved data set across platforms (from PC and Mainframe to UNIX and Vice Versa).

Environment: BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT, SAS/CONNECT and SAS/ACCESS, SAS/ENTERPRISE MINER, RDBMS, ORACLE, NCR Teradata, MVS, UNIX, Windows NT.

Confidential, Melville, NY

SAS Programmer

Responsibilities:

• Wrote teh programs in SAS and SQL to generate teh reports.
• Created base macros to run reports. Created standard reports to use across studies.
• Wrote base programs to set up data.
• Was responsible for data entry and conversions; data validation and corrections; uploading/downloading data from/to PC; statistical analysis of data for use in litigation cases; creating permanent formatted SAS data sets for present and future analysis.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting data between SAS and Oracle.
• Data validation by checking data distribution and by comparison to a standard data.
• Prepared implementation plans, and test plans.
• Designed and Developed different report templates based on teh user specifications.
• Developed reports using PROC REPORT, DATA NULL and SAS MACRO.
• Adhoc reports were created using teh SAS procedures.
• Created reports using ODS statements and PROC TEMPLATE to generate different output formats like HTML, PDF and EXCEL to view them in teh web browser.
• Ran report programs and downloaded teh results into EXCEL for data analysis.
• Produced Graphical reports showing PIE and BAR charts for analysis while providing teh drill down capabilities.
• Used SQL and PROC SQL to work with DB2.
• Moved data sets across platforms from PC to UNIX and Vice Versa.
• Extensively used SAS/BASE, SAS/CONNECT, SAS/SQL, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ACCESS and SAS/MACROS for programming.

Environment: SAS 8.1, JCL, SQL, BASE/SAS, SAS/MACRO, SAS/ ACCESS, SAS/ CONNECT, SAS/ ODS, SAS/ SQL, SAS/ENTERPRISE MINER, MVS, AIX, Windows NT, SAS/REPORT, SAS/SQL SAS/STAT, UNIX Confidential

Confidential, Atlanta, GA

SAS Programmer

Responsibilities:

• Wrote analysis plans including specifications for tables, listings, and graphs.
• Extracted raw data and created datasets.
• Converted Oracle data tables into SAS data files using SAS SQL.
• Extensively used TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOT procedures.
• Extensively used SAS/BASE, SAS/CONNECT, SAS/SQL, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ACCESS and SAS/MACROS for programming.
• Manipulated large data sets. Responsible for data entry and conversions, data validation and corrections, uploading/downloading data from/to PC.
• Used SUBSTR and SCAN functions, searched for strings using INDEX function and created new formats using PROC FORMAT.
• Used editor to make local and global changes to programs.
• Copied, moved, deleted, compared, renamed, spooled, printed, and browsed files in SAS.
• Designed and Developed different report templates based on teh user specifications.
• Developed statistical reports using PROC REPORT, DATA NULL and SAS MACRO.
• Adhoc reports were created using teh SAS procedures.
• Created reports using ODS statements and PROC TEMPLATE to generate different output formats like HTML, PDF and EXCEL to view them in teh web browser.
• Ran report programs and downloaded teh results into EXCEL for data analysis.
• Used SQL and PROC SQL to work with DB2.
• Moved data sets across platforms from PC to UNIX and Vice Versa.
• Produced Graphical reports showing PIE and BAR charts for analysis while providing teh drill down capabilities.
• Created graphs using PROC GPLOT. Created permanent formatted SAS data sets for present and future analysis, infilling several datasets and sorting and merging by common variables.

Environment: Windows NT, SAS V8.0, Oracle 8.1, Sun Solaris 2.8, SAS/SQL, SAS/BASE, SAS/Graph, SAS Macro, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL.