SUMMARY

• Over 7 years of experience in the IT industry, proficient in working on Development, Test and Production.
• Over 6 Years Experience working with SAS 9.0, 9.1 and 9.2 as a SAS Developer/Analyst.
• Strong SAS programming background using various SAS components like SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS and SAS/ACCESS.
• Capable of analyzing extensive data sources and generating comprehensive reports using SAS combined with SAS Business Intelligence tools.
• Substantial Knowledge of SAS - Business Intelligence, SAS Enterprise Guide 4.1, SAS Enterprise Miner 7.1, JMP 9, SAS OLAP Cube studio 9.1, SAS Information Map Studio 3.1, SAS Data Integration Studio 3.4 and SAS Management Console 9.1
• Experience in writing complex and efficient algorithms using advanced SAS programming techniques like Merging SAS Data sets, writing Macros, SAS Formats & Informats, SAS Functions and SAS procedures like Proc Freq, Univariate, Means, Summary, Tabulate, Import, Export, Copy, Print, Contents, Compare, Report, Ttest, Gplot, Format, Sort, Transpose and Proc SQL.
• Experienced in converting SAS datasets to various file types (including HTML, PDF, Excel, CSV and ASCII) as well as converting various file types into SAS datasets.
• Knowledgeable in various data Extraction, Transformation and Loading (ETL) techniques; worked on SAS-BI(Business Intelligence) Multi-Tier Client/Server environment.
• Extensive knowledge in database modeling, management and data access/analysis. Specifically experienced in relational databases and SQL programming in MySQL, Oracle 10g, MsSQL, DB2.
• Good understanding of Business Analysis skills; experience in collecting and documenting software requirements from clients coupled with developing Design Documents (LLD and HLD).
• Performed exceptionally working independently as well as in a team with excellent interpersonal, analytical, problem solving and communication skills.
• Handled multiple projects with speed and accuracy even working independently with minimal supervision.
• A fast and ardent learner capable of adapting to new domains, technologies, concepts and environments.
• Experienced in all the SDLC phases with exceptional performance in Development, Documentation, and Testing, Implementation, Training, support and Maintenance in various projects.
• Thorough experience using MS Word, MS Excel, PowerPoint and MS Access.

TECHNICAL SKILLS

SAS: SAS 9.1, SAS 9.2, Base SAS, SAS/Macros, SAS/Access, SAS/Graph, SAS/STAT, SAS/CONNECT

SAS: JMP, Enterprise Guide, Enterprise Miner, SAS/BI (SAS/E-GUIDE 4.1, SAS/DIS 3.4, SAS/OLAP 9.1, SAS/IMP 3.1)

RDBMS: Oracle 10g, MySQL, SQL Server, DB2

Programming: C++, Java, Python, SQL, SAS, Visual Basic

Operating Systems: UNIX, Windows, Mainframe z/OS

Architecture: Data warehousing concepts

Mainframe: COBOL, JCL

ETL Tool: Informatica

Scripting: UNIX Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Blue Bell, PA

SAS Programmer

Responsibilities:

• Performed ETL on Oracle and DB2 databases to extract and prepare data for analysis and reporting
• Data processing and validations were done extensively on the SAS datasets using edit check programs
• Involved in standardizing reporting procedures for graphical and tabular reports
• Used advanced SAS tools to automate the reporting systems to generate daily and monthly reports for advanced premium, policy risk-in-force count, monthly claim count, claim recovers, claim outstanding reserves, paid claim reports, outstanding loss, agent commission etc.
• Used SAS Procedures to generate Ad-hoc reports such as renewal policy count reports by state, agent commission report by agent type based on clients requirements
• Wrote Output Delivery System SAS Procedures to publish reports as HTML pages to the Web
• Assisted data mining team to extract data patterns and trends from sales data
• Developed and maintained the SAS code for Acquisition models, X-Sell and Up-Sell marketing models, segmentation and targeting and campaign optimization
• Used procedures like PROC FREQ, PROC Means, PROC Sort, PROC Print, PROC Tabulate, PROC UNIVARIATE and PROC Report
• Data Fixing and Batch monitoring and performing troubleshooting of various issues ranging from batch programs

Environment: Windows XP, SAS 9.13, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, HTML, Teradata, Unix.

Confidential, Nashville, TN

Sr. SAS Programmer

Responsibilities:

• Utilized both financial analysis and computer science skills in a multidisciplinary Position of financial quantitative analyst, which involved data modeling, econometric analysis, risk modeling and data analytics using SAS and SQL.
• Played a key role in data analysis and data modeling (model design, development, and model implementation) using SAS. Handled huge datasets, of over 80 million records.
• Developed SAS programs extensively using Base SAS, SAS/EG, SAS/Macros and SAS/GRAPH.
• Demonstrated high level of competency in statistical and analytical principles, tools and techniques and supported the advancement of the “best-in-class” analytical capabilities.
• Analyzed merchant loan data and built several rule based models, using base and advanced SAS, to track the performance of merchants. Presented and implemented my own data models and reporting templates, which provided a better picture of the performing and non-performing loans.
• Developed a model that helps the Account Management team to make monthly and annual product renewal decisions. Built pattern recognition statistical tools (scanners) to analyze the data patterns and trigger notifications if a merchant’s loan performance is abnormal or undesirable (based on risk models). Profiled all the merchants based on 4 years of data and tracked the out-of-pattern behavior from the merchants. The model improved loan approval decision making and reduced loan risk and improved profitability.
• Developed and scheduled various daily reports to run automatically using Crontab.SAS. Used ODS Tagsets and PROC REPORT to color code the rows in the excel output.
• Coordinated with offshore team in India to support underwriting decisions.
• Tracked the card member behavior by analyzing the credit risk probabilities.
• Presented various designs and data models to senior executives responsible for risk management and business development.

Environment: SAS 9.1.3, SAS/EG, SAS/Base, SAS/Macros, SAS/Access, SQL, SAS/CONNECT, Crontab.SAS, ODS Tagsets, PROC REPORT, FTP, SAS-OLAP, Cobol - Flat Files, UNIX & Mainframe z/OS

Confidential, NY

Sr. SAS Developer/Team Coordinator

Responsibilities:

• Gathered and analyzed the business requirements and developed prototypes of the data models.
• Built cubes using SAS OLAP Cube Studio, designed dimensions, measures, levels, hierarchies for report generation based on multiple KPIs.
• Extracted data from the database with over 35 million records using SAS/Access, SAS SQL procedures and created SAS datasets.
• Joined several tables residing in different platforms using SAS Proc SQL to gather relevant data for measuring performance of the businesses.
• Derived several columns from existing columns using SAS SQL procedure.
• Created information maps using SAS Information Map Studio to predefine business formulas and calculations.
• Created reports in SAS Web Report Studio using Information maps.
• Scheduled and evoked several programs and tasks using Unix Shell Script.
• Demonstrated the reporting tools and presented them to senior vice presidents and several program managers.
• Lead a team of 3 analysts in designing, analyzing and reporting key performance indices.

Environment: SAS 9.2, SAS BI, SAS Management Console, SAS Enterprise Guide 4.0, Unix, SAS DI Studio, AS/Access, SAS/SQL, SAS/Base, SAS/Macros, SAS/Graph, PL/SQL, Oracle and Endevor

Confidential, NJ

SAS Developer

Responsibilities:

• Enhancing SAS applications in different environments for Models and business Methods.
• Wrote SAS Macro’s when ever re-usability was needed.
• Created Ad-hoc reports in Excel and HTML for Business users using SAS/ODS.
• Used SAS/Access to read data from SQL Server database for Audit purpose.
• Extensively used SAS Formats and Informats to read and write data.
• Working closely with Internal and External Auditors to provide information about different production applications.
• Worked closely with other support teams like Unix Administrators and SAS Infrastructure team to solve infrastructure related issues.
• Worked extensively in troubleshooting and fixing bugs for various applications in a timely manner.
• Good knowledge of change managements and defect tracking tools like ClearCase, ClearQuest, Remedy and Change Tracker Turbo.
• Interfacing with the business area to support production systems, assisting in ad-hoc requests and providing technical expertise and knowledge.
• Quick trouble-shooting skills and highly responsible in supporting critical financial application during month end process.
• Worked as Incident Manager and escalated incident tickets based on impact and urgency.

Environment: SAS 9.1.3, SAS/Access, SAS/Connect, SAS/SQL, SAS/ODS, SAS/Macros, JAVAJ2EE,Weblogic,Webmethods, MS Excel, UNIX, Remedy, ClearCase and ClearQuest, SQL Server.

Confidential, Cincinnati, Ohio

SAS Programmer

Responsibilities:

• Worked in SAS PC for design, development and operations.
• Perform data extraction from various sources
• Performed quality control, as required per SOPs, for statistical programming deliverables (including input in Validation Plan & QC documentation)
• Provided items required for e-submission (i.e. SAS transport files, define.pdf, annotated CRF)
• Created derived-analysis datasets for the biostatistician based on SDTM/Adam standards.
• Assisted in providing and maintaining project plan for all projects/study including milestones, tasks, and coordination of programming activities
• Executed analyses specified in the Statistical Analysis Plan (SAP) under the guidance of the project statistician
• Secondary programmer to validate SAS programs that produce derived-analysis datasets and data analyses.
• Designed, developed and tested SAS code to track and forecast the sample and lab test results.
• Developed code to track patients’ end of study visits and early termination.
• Tested the macros to track error handling and email notification due to system failure.
• Produce frequency and distribution tables for various studies for analysis.

Environment: SAS 9.1.3, SAS DIS, SAS EG 4.0, SAS/Base, SAS/Macros, SAS/Access,, SAS/CONNECT, SQL, Oracle, SQL Server, Windows OS

Confidential

SAS Administrative Developer

Responsibilities:

• Developed a program to monitor the Transaction Types-Wires In/Out, Withdrawals/Transfers-on a daily basis.
• The report displayed a column of each trading day of the amount and number, by transaction types with sub-Totals and totals.
• This was done using SAS (Base, SQL, Macros, and Proc Transpose) and DB2 Tables of Brokerage and Financial Data on a z/OS System.
• Developed a Reporting System to be distributed to the Branch Managers of the FA who has any split relation with the Director.
• These reports displayed data of Corp Name, Acct #, Household ID, Reinvestment Partner, Commissions, Assets, FA Name, Partnership Type and also summary data.
• These are programmed using SAS SQL joins and SAS Passthru Facility and Libname Engine to extract data from large DB2 Tables of Brokerage and Financial information which was then processed with SAS (Base, SQL, Macro, ODS, Proc Report, Data Steps) on IBM OS using JCL. These processes are migrated to the production System with CHGMAN Package.

Environment: SAS 9.0, JMP, SAS Business Intelligence, SAS/Base, SAS/Macros, SAS/Access, SQL, MS-Office, SAS/CONNECT, CHGMAN, DB2, z/OS, JCL