SUMMARY:

• 6 years of extensive SAS programming experience in data analysis, data migration, and reporting on statistical applications in Banking/Financial/Health care sectors.
• Good experience working in SAS on various platforms like Windows, UNIX and Mainframes.
• Strong SAS macro programming experience in SAS 9.x- BASE SAS, SAS/STAT, SAS/GRAPH, SAS SQL, SAS ODS, SAS/ETL, SAS/ACCESS, SAS/ASSIST, SAS/CONNECT, SAS/ETS, SAS PC and SAS Enterprise Guide, UNIX environment .
• Extensive experience with accessing data from database including its functionality and structure: ORACLE, Teradata, MS SQL and MS Access.
• Integration of both traditional and emerging data sources with SAS Customer Intelligence CI
• Involved in integrating the Analytical capabilities such as statistics, predictive analytics, data and forecasting, and optimization.
• Experience in data validation techniques, testing and documenting the development of SAS programs that generate output in conformance with defined specifications of tables/listings/graphs and other programs.
• Thorough knowledge of SAS procedures like Proc Format, Proc Report, Proc Means, Proc Summary, Proc Freq, Proc Univariate, Proc Transpose, Proc SQL, Proc Import, Proc Tabulate, Proc Plot, Proc Chart, Proc Plot, Proc Compare and the DATA NULL data step.
• Strong in UNIX and used all UNIX commands to manage SAS by Coupon Companion Plugin >programs.
• Familiar and utilized specialized Statistical and Graphical SAS procedures including Regression Analysis, Multivariate Analysis, Cluster / Factor analyses, Logistics Regression and Time Series Analysis.
• Established standard operating procedures for coding, documentation and validation of applications programs/macros/procedures which support monitoring and reporting of data.
• Experience in coding using SAS SQL, Procedures and Functions.
• Using SAS/SQL for extract, transfer and load ETL methodology and processes.
• Experience in various ETL tools like Informatica, SAS, and Business Objects.
• Working knowledge of RDBMS concepts and implementation using SQL server as a back-end database server and excellent in writing SQL queries.
• Created graphs using PROC GPLOT and GCHART permanent formatted SAS data sets for present and future analysis, infield several data sets and sorted and merged by common variables.
• Excellent verbal and written communication skills which can clearly articulate complex concepts and ideas to all levels of the organization.
• Good analytical, conceptual and strategic thinking and planning
• Extensive experience in creating complex Excel pivot tables, Ad-hoc reporting in EXCEL.
• Possesses excellent communication and presentation skills combined with strong analytical, organizational and problem solving skills.
• Team oriented with ability to work effectively with many different people across many diverse organizations.

SKILL SET:

PROFESSIONAL EXPERIENCE:

Confidential

SAS Programmer Analyst

Responsibilities:

• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Used SAS/ACCESS to extract data from different relational database management ORACLE and SQL SERVER systems using SAS.
• Performed extraction, transformation and loading from large Oracle tables.
• Manipulated existing Oracle database by accessing the data using SQL pass through facility.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets.
• Developed UNIX Korn shell scripts for automating and executing SAS batch files on UNIX.
• Utilized BASE SAS, Macros, SAS/ACCESS, and SAS SQL for programming.
• Performed Consumer profiling, Sales forecasting and testing.
• Wrote SAS JCL programs to extract data from DB2 tables and send it to different mainframes and UNIX servers using FTP.
• Developed Shell scripting to automate SAS queries.
• Extracted, transformed and loaded data using SAS/ETL
• Performed statistical analysis of financial and operational data.
• Extensively used Data Null and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Supported and developed a management reporting system which used a web front end to generate user queries.

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, and SAS/CONNECT, Oracle 9i, Korn shell, DB2, Windows, HTML.

Confidential

SAS Financial Analyst

Responsibilities:

• Maintained performance reports, creation of reports for online and batch application of various server and Involved in preparing executive Dashboards for senior level management.
• Responsible for the monthly preparation of financial statements according to US GAAP/IFRS, which includes analysis of monthly and year to date variances, detail analysis of balance sheet, P L accounts, revenue - expense accounts and statement of cash flows.
• Used SAS, SAS Macros, Procedures like SQL, FREQ, UNIVARIATE, SUMMARY, MEANS, TRANSPOSE, ARRAYS, Tabulate, and SORT to extract data, prepare integrated data base and its analysis.
• Extracted data sets from server using PROC CIMPORT and created datasets in SAS libraries, Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
• Developed application for measuring financial performance of newly acquired accounts: Forecast Vs Actual and developed SAS programs for generating reports on Key financials, Income Statements, and Balance Sheet.
• Prepared yearly financial statements - package for assigned entities. Such reports will include accurate accruals of expenses revenues, balance sheet data and disclosures- footnote explanations of variance from historical levels and /or budgeted amounts.
• Worked with external auditors E Y to prepare annual audited financial statement in conformity with GAAP/IFRS, GAAP disclosure checklists, preparation of schedules and work papers, providing detail answers as question arises.
• Design, implement and administer the formal support processes for service request recording, documenting, routing, resolution and escalation for Finance Controlling.
• Formulate, support or design financial forecasting model using SQL, V-H lookups, if/then statements, pivot table.
• Identifying and reconciling intercompany financial planning and transactions between different entities.
• Maintains and monitors the status of certain balance sheet accounts for the overseas entities using company's GCRS system and analyzed MIS report.

Environment: SAS/Base, SAS/Access, SAS/Enterprise Miner, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS-Excel, Windows NT, XP.

Confidential

SAS Consultant

Responsibilities:

• Worked extensively with business users on requirements gathering, analysis and documentation.
• Interacted with clients, modelers and analysts to define targeted populations and control groups.
• Extract, transform and load datasets with basic modeling variables for each segment type.
• Extraction of claims data from Data Ware housing tables based on the needs of each internal project.
• Modifying data using SAS/BASE and Macros.
• Worked on analyzing medical claims data and interfacing SAS with MS Office applications such as Access/Excel.
• Responsible for analyzing data sources for integrity, precision, and accuracy.
• Experienced in producing external files and reports employing various SAS procedures, like null , ODS, Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Mean, Proc Transpose, Proc SQL, etc.
• Responsible for data cleaning, merging data from multiple files e.g. medical, pharmacy , applying project-specific inclusion/exclusion criteria, coding project-specific variables and producing participant/member-level datasets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Claims data from oracle database and converted to SAS data sets for Analysis using various SAS procedures.
• Built, maintained, and scheduled SAS production jobs and data bases.
• Worked with large volume data warehouses and data access tools Windows, Unix, etc.
• Provide insight to the sales/retail organization as to appropriate sales strategies and tactics using information and research findings.
• Design and test prescription, over the counter and retail evaluation programs/mailings.
• Provided demographic analysis of telemarketing campaigns using Unix SAS for call list target market and call center effectiveness determinations.
• Prepared, documented and tested required programs and presenting the results in a table format for conducting data analysis and supporting other team members in designing and developing programs.

Environment: SAS BASEv8.x/9.x, SAS/MACROS, SAS/SQL, Oracle, DB2, Windows XP, UNIX and Mainframes.

Confidential

Jr. SAS Developer

Responsibilities:

• Complex and unstructured data is verified and using PROC and MACROS it is made into a structured format.
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel.
• Created ETL workflows in SAS/Data Integration Studio to populate the analytical data marts for business reporting.
• Designed, implemented, and maintained the Data Warehouse extract, transformation and load ETL processes including timeliness, accuracy, completeness. and metadata .
• Involved in developing and maintaining documentation of operational processes and data mappings.
• Developed data load programs using SAS Enterprise Guide to insert data periodically into the SAS server in UNIX.
• Designed and coded ETL processes with varied source systems like Oracle, SQL Server and flat files.
• BASE SAS procedures like FREQ, MEANS, SQL, SORT are used to validate current results with expected results.
• Performed quality control QC checks against database to ensure correct data was entered.
• Developing standard reconciliation programs using MACROS.
• Created ETL workflows in SAS DI Studio to populate the analytical data marts for business reporting.
• Enhanced the existing SAS Macros to automate the job.
• Exported large SAS data sets to external files to be sent to external vendors using SAS and SAS/Macro.
• Hands on experience in merging SAS data sets using SAS EG.
• Created process flow diagrams, and data mapping documents.
• Developed an application using Base SAS, Proc SQL and Proc Contents to generate concise data profiling reports.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ETL, SAS/ODS, SAS/GRAPH, Oracle, SAS/CONNECT, SAS/STAT, SAS/ENTERPRISE GUIDE, Windows, MS Excel.