PROFESSIONAL SUMMARY:

SAS Programmer with 7 years of experience in Analysis, Design, Development, Testing and Implementation of Statistical models and applications in Windows and UNIX Client/Server environment.

• Extensive working experience in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/Access, SAS/SQL in UNIX and Windows environments.
• Extensive programming experience with PROC SQL, PROC Report, PROC Tabulate, PROC Transpose, PROC Plot, PROC Chart, PROC Datasets, PROC Format, PROC Print, SAS/STAT procedures such as PROC Corr, PROC Reg, PROC GLM, PROC ANOVA, PROC Freq, PROC Means, PROC Univariate.
• Experienced in performing various business analyses like Product performance, Customer behavior, and Market performance.
• Experienced and Sound knowledge of working with Health Claims Data (Medical, RX, eligibility).
• Knowledge ofMedical Claims Processing Systems, Medical Coding, i.e. ICD-9, CPT, HCPCS.
• Experienced in generation of various canned periodic and ad-hoc reports for business users.
• Experienced in UNIX Korn Shell scripting for automation of processes.
• Proficient in using Oracle, DB2, SQL, SQL Server, MS Access, and Excel.
• Experienced in development of documentation like FRD, Technical Specifications from BRD and Process/Program flow.
• Experienced in using SAS to import/export data to external file formats like flat, Excel, XML files.
• Thorough knowledge in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Thorough knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, and MS Excel.
• Excellent written and verbal communication skills, self-motivator and a good team player.
• Capable of quickly grasping and applying new concepts / technologies and the ability to impart knowledge to others on technical topics.
• Capable of problem solving and delivering realistic and practical solutions. Enthusiastic, innovative and challenge oriented.
• Expertise in doing thepeer reviewsfor the work requests handled by the team and guiding them with the better approaches possible.

SKILLS:

SAS Skills: SAS V6.12, V8, V9.1, V9.2
SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ACCESS, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS/ANOVA, SAS WAREHOUSE ADMINISTRATOR, SAS ENTERPRISE GUIDE, SAS ENTERPRISE MINER
Database Platforms: Oracle 8/9/10g, PL/SQL, SQL Server 2000, MS ACCESS, DB2
Operating Systems: UNIX, Windows 98/XP/2000, Win- NT, Win-XP
Analysis/Design Tools: MS Office, MS Project, Visio, ERWIN, MS Front Page
Languages: C++, HTML and XML

EDUCATION:
Bachelor of Science in Information Technology

PROFESSIONAL EXPERIENCE:

Confidential, CA Jan ‘10 – Till date SAS Consultant

Washington Mutual Bank is United State’s largest savings and loan association. Washington Mutual Bank’s principal activities are to provide financial services to consumers and small businesses such as retail banking, mortgage lending, consumer lending, business banking, business lending, insurance services, credit card services, commercial real estate mortgage and consumer investment services. Washington Mutual operates more than 2,600 retail banking, mortgage lending, commercial banking and financial services offices. I worked in Credit card division of the company. Project involved analysis of marketing campaign.

Responsibilities:

• Developed end-to-end reporting based on business requirements.
• Acted as primary liaison between business users and IT project team for business case, business requirements documentation, performed quality assurance testing.
• Solved complex issues and implemented solutions to enhance productivity, improve quality and customer satisfaction.
• Obtained and maintained familiarity with policies and procedures.
• Developed and maintained data preparation and validation routines to support more complex data mining.
• Developed programs using BASE SAS, SAS/SQL and SAS MACROS to generate new reports.
• Programmed in SAS for the development of a large reporting System using SAS/ACCESS to accessing DB2 relational tables.
• Created and consolidated reports using several internal and external sources through the development of standard macros.
• Generated codes in order to develop and deliver current business solutions through the automation of consulting processes, providing ideas to create more efficiency within the team.
• Data preparation, cleaning, manipulation, and visualization. Extract data from relational databases and perform complex data manipulations. Also conducted extensive data checks to ensure data quality.
• Worked with team members to understand market and client specific needs for development of new consulting solutions or refinement of existing services.
• Presented and communicated results of data mining efforts in a manner consistent with the target audience and business needs.
• Document all SAS programs developed and write other documentation as needed. Identify and share best practices for key topics.
• Responsible for transfer of technical knowledge to facilitate implementation of the business solution provided.

Environment: SAS/Base, SAS Macros, SAS/ODS, SAS/Access, UNIX, SAS/GRAPH, DB2, TERADATA, AUTOSYS, MS-EXCEL, EXCEED and MS-VISIO.

Confidential, Feb’ 08 – Dec’ 09
SAS Programmer Analyst

Humana Inc., headquartered in Louisville, Kentucky, is one of the nation's largest publicly traded health benefits companies. Humana offers a diversified portfolio of health insurance products and related services - through traditional and consumer-choice plans - to employer groups, government-sponsored plans, and individuals.

Responsibilities:

• Involved in requirement gathering and functional documentation preparation.
• Based on the requirements and the specifications, created SAS programs for the generation of datasets.
• Used data step programming to extract the data from raw files sent by the customers and carriers (insurance providers).
• Used SAS date in formats, functions, statements and options to extract the data from files that are sent in different layouts.
• Used SAS procedures (FREQ, SUMMARY), SAS functions and user defined macros to test the accuracy and validity of data.
• Different carriers send their data in different formats and layouts. Wrote SAS programs to convert various types and formats of data, sent by the carriers, to BCBS standard layout.
• Used SAS data step, PROC SQL, PROC APPEND, PROC DATASETS and extensively used data step merge to merge the claims data against the eligibility information sent by the customer.
• Wrote macros and procedures to check the quality of the data before and after the eligibility merge.
• Used SAS data step functions, formats, statements and procedures like PROC FORMAT and to map the variables to the customer’s needs.
• Involved in writing code using BASE SAS and SAS/Macros to extract clean and validate data from oracle tables.
• Used the SAS Access engine to retrieve the data into SAS from the database.
• Used SAS PROC SQL Pass through facility to work with oracle database.
• Responsible for converting the Business rules to SAS datasets and to Load the data in to the data warehouse.
• Performed validation/quality control check of SAS programs.
• Work on formalizing the Data Transfer Plan which involved extensive interaction with the user for the definition of the technical data output specifications.
• Prepared reports directing SAS output to HTML files using output delivery system facility (ODS).
• Extracted data from various sources like Flat Files, Oracle into SAS.
• Responsible for developing new projects and supporting existing applications.
• Used shell scripting for scheduling of jobs.

Environment: SAS/Base, SAS Macros, SAS/ODS, SAS/Access, UNIX, SAS/GRAPH, DB2, TERADATA, AUTOSYS, MS-EXCEL, EXCEED and MS-VISIO.

Confidential, MN Mar’ 06 – Jan’ 08
Programmer Analyst

Test data privacy are to minimize the risks of unauthorized disclosure of U.S. Bank Customer Confidential and U.S. Bank Confidential information, and support legal, regulatory, and contractual requirements. Several compliance obligations and Cardholder Information Security Program (CISP)/ Payment Card Industry (PCI), require the protection of the Personally Identifiable Information (PII), which includes U.S. Bank Customer Confidential and U.S. Bank Confidential information used and stored in testing environments.

Responsibilities:

• Created SAS macros to consolidate and streamline the data.
• Wrote SAS graphic routines to display customer satisfaction survey maps.
• Provided full development support for ADHOC analysis and reporting using Business Objects.
• Did data analysis using SAS procedures like PROC SQL, PROC FREQ, and PROC SUMMARY in order to support the marketing team in analyzing the consumer behavior and market trend.
• Coded and reused SAS macros and VBA macros with Excel.
• Performed Quality Assurance on other SAS program systems.
• Created process-flows and system-flows using MS-Visio
• Enhanced the logic of existing version.
• Coded new programs using BASE SAS, SAS/SQL and SAS MACROS to generate new reports.
• Programmed in SAS for the development of a large reporting System using SAS/ACCESS to accessing DB2 relational tables.
• Transformed the data between different platforms using PROC IMPORT and PROC EXPORT.
• Preparation of unit and system integration Test Plans.
• Preparation of test data and verifying test results in R&D and UAT environment.
• Problem identification of production issues and Bug-fixing
• Coded and reused shell scripts and SAS macros.
• Provided ADHOC programming and Database Administration.
• Coded number of SAS programs and macros to do System Testing.

Environment: SAS/Base, SAS Macros, SAS/ODS, SAS/Access, UNIX, SAS/GRAPH, DB2, TERADATA, AUTOSYS, MS-EXCEL, EXCEED, Oracle and MS-VISIO.

Barclays Bank is the leading international bank in India. Responsible for acquisition modeling in the emerging markets of India. As it was not easy to buy geographical and demographic data In India, customer data was built internally by gathering demographics and general information of card members pertaining to diverse products to extract information about solicited and non-solicited responders over a period of time.

Responsibilities

• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
• Analyzed data using various statistical PROCEDURES like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
• Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
• Generated HTML, Listings, EXCEL and RTF reports for presenting findings of various statistical PROCEDURES using PROCEDURES like PROC REPORT, PROC PRINT, PROC FREQ and also SAS ODS.

Environment:SAS/BASE 8.2, SAS/ACCESS, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT, SQL, ORACLE