PROFESSIONAL SUMMARY:

• 6+ years of IT Industry Experience in Software Development in different environments.
• Extensive experience in programming, analyzing and reporting in various Banking, Healthcare and Retail sector applications using SAS on Windows and Unix environments.
• Proficient in SAS/Base, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/Stat and SAS/Graph.
• Strong Skills in Data Analysis, Predictive or Statistical Modeling: query and mine large data, time series analysis, generalized linear model, linear and logistic regression, multivariateregression analysis, neural networks, hypothesis testing, ANOVA, MANOVA
• Involved in extracting data from XML files, flat files, CSV, Data files, and relational databases, transforming the data and loading it into the DW.
• Accountable for writing complex SQL Queries (PROC SQL and PL/SQL) for the analysis of large health care tables like Claims, Membership, medical, provider, sales and support data.
• Experience in extracting, manipulating and creating datasets from various source like Excel, flat files, Oracle database, Teradatausing PROC IMPORT and other techniques.
• Proficient in DATA STEP programming and SAS functions like SUBSTR, INDEX, SCAN, COMPRESS, COMPBL, STRIP, INTNX, INTCK, CAT etc
• Experience with database manipulation (ETL) and SQL programming and reporting
• Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Proven skills in SAS Base (data step and Proc) and SAS Macro fulfilling on demand business needs.
• Extensive Experience inSASReport Generating ProcedureslikePROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE, PROC PRINT and DATA NULL TECNINQUES
• Strong Skills in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Strong SAS programming background for creating, maintaining existing code, ad - hoc reporting and supporting the reporting functions.
• Expertise in statistical, quantitative and analytical data in financial sector.
• Knowledge of probability and statistics
• Expertise in SAS WPS, SAS Enterprise Guide 4.1/5.1, SAS studio 9.4
• Statistical software/ Programming languages: SAS, SAS/WPS, SPSS, SQL, ACCESS
• Developed SAS programs for statistical analysis & modeling using Regression & ARIMA model for forecasting.
• Firm grasp over understanding of business needs and strategies to develop reliable and effective solutions.
• Created RTF, PDF, and HTML listings, tables and reports using SAS/ODS
• Understanding of the client's vision, goals, limitations, data sources and time lines.
• The ability to multi-task and function efficiently in a high-volume, fast-paced environment
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Effective team player with strong communication and interpersonal skills.
• Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience.

TECHNICAL SKILLS:

Operating System: Windows 7, Windows XP, UNIX.

Servers: Windows servers, Unix servers

SAS Tools/Programming Languages: SAS/Base, SAS/SQL, SAS/Access, Advanced SAS, SAS Macros, SAS Procedures, SAS Analytic, SAS/ETL, SAS Modeling, Financial Analysis, Predictive Modeling, SAS BI Clients, SAS/Connect, SAS/ODS, SAS Clinical, SAS/GRAPH.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

SAS Programmer/Analyst/IT Consultant

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Developed SAS code to manipulate raw data and validate data integrity.
• Implemented statistical sampling techniques in various settings including Univariate, bivariate, multivariate methods with extensive use of logistic regression.
• Analyzed research data and estimated economic models using different statistical techniques
• Constructed, cleaned, and documented large datasets for various socio-economic projects using SAS, SPSS and Excel
• Wrote SAS and SPSS for data manipulation for use in statistical packages for statistical analyses
• Prepared various charts and graphs for all economic data and drafted appropriate articles
• Analyzed business related data, generate custom reports, tables and listings.
• Extensively used various Base SAS procedures like Proc SQL, Proc Datasets, Proc Format, Proc Print and Proc sort.
• Created data sets from variable length multi format files having more than one layout in a single file.
• Documented business requirements for necessary customizations to the new application and reviewed the customized components with the business and developer team.
• Created and delivered reports and presentations with key findings and recommendations.
• Performed data quality analysis using advanced SQL skills.
• Coded extremely complex SAS Data step and proc including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
• Provide technical support on SAS programming related to data manipulation and analysis.
• Produced reports in excel using SAS add-in and Proc Report
• Created different user defined functions for applying appropriate business rules

Environment: SAS/Base9.2/9.3, SAS/Macros, SAS/Stat, SAS/Graph, SAS/SQL, SAS Clinical, SPSS.

Confidential, Whitehouse Station, NJ

SAS Programmer and Data Analysis

Responsibilities:

• Validated Economic, Financial and Market Risk Models. The models include time series models, multivariate models, logistic regression, linear models, non-linear models, simulation models, value-at-risk models (VaR), generalized linear models and other statistical models
• The validation work entails the following activities
• Evaluate conceptual soundness of the modeling methodology
• Examine appropriateness of both quantitative and qualitative assumptions underlying the model.
• Assess quality of the data for model development as well as inputs to the model
• Test implementation accuracy of the model
• Perform tests to assess performance of the model
• Perform ongoing research and develop benchmark models based on alternative modeling methodologies and ensure the models are in line with industry best practices and meet regulatory requirements.
• Make recommendations to the stakeholders or models owners (government, business, insurance, hospitals) on the approval of the models or other corrective actions based on the independent validation results. Document validation results and findings/recommendations in a validation report.
• Assist the Model owners to ensure that all the models are validated according to the existing validated procedures/standards
• Based on the results of model validation, recommend improvements to the model or the model development process and identify material improvement opportunities in the models being validated.
• Responsible for completing draft reports and submission of all necessary documentation related to validation assignments to model owners; ensure accuracy and completeness of archived information and related documentation to allow independent third party review of the validation work performed
• Establish communication with model owner/developers to understand model rationale and issues; maintain relationship with key contacts as identified for each validation.
• Recommend and enforce improvements to tests/methods in order to fulfill internal validation needs and to align (if applicable) with industry practices
• Keep abreast of industry and regulatory developments and evolving expectations
• Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Extracted, performed validation and generated SAS data sets from Teradata applied SQL Pass through Facility.
• Developed new Macros for report generation using SAS/Macros as per the customer's requirements.
• Retrieved millions of records using various Procedures.
• Involved in code migration across multiple environments, maintenance of all the Table scripts needed during migration.

Environment: SAS, SPSS, Excel, ACCESS, SAS/MACRO, SAS/FUNCTIONS, SAS/ODS, SAS/SQL

Confidential, Hartford, CT

Sr. SAS Programmer / Analyst

Responsibilities:

• Worked with business users to design and develop several ad-hoc reports and information maps using Proc Report and Proc Tabulate.
• The reports created include Monthly summary reports as well as detailed weekly reports.
• Connected to the DB2 database and extracted the relevant data (using LIBNAME or Pass-through facility) and then processed the data using business logic to produce reports. Made heavy use of Proc SQL, Proc Report andODS for producing these complex reports.
• Developed online claims reporting system to retrieve client records and create SAS Proc tabulate tables, Proc Freq, Proc Means, and Proc Report.
• Creating excel pivot table reports using Cycle Time data. These reports consist of Benefit level data, claims level data. These reports are very useful to get a greater insight into the further plan design.
• Extensively used SAS Data Steps, Statistical models, and Flowchart Design, Listing, Graphing, Summarizing and Reporting procedures.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining.
• Created various transformation procedures by using SAS ETL and SAS Enterprise guide.
• SAS Procedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets.
• Developed and deployed SAS OLAP cubes for browsing of financial data via the SAS Information Delivery Portal.
• Proficient in sorting, merging and using different table lookup techniques to get the required information to generate the report.
• Produced reports and complex data analyses using SAS, including SAS/stats, extracted data from MVS and Oracle files using SAS/Views, SAS Proc SQL and SQL.
• Debugging SAS programs using data null, Put statements and using data step debug.
• Generated automated graphs for monthly run using Proc Gplot. Exported these graphs to Pdf File using SAS/ODS.
• Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
• Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data
• Exported SAS Reports to the Excel sheet by using ODS/Tag sets/ Excel XP to get output in multisheets. Used several Style Options.
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
• Prepared Analysis Datasets, Tables, Listings, and Graphs according to the Business Requirement.

Environment: SAS/Enterprise Guide, SAS/Base, SAS/Macros, SAS/SQL, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, Excel, MS Access, Windows, MS office.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Prepared, analyzed and distributed various monthly and quarterly Loan Portfolio Reports.
• Performed and conducted written analysis outlining key performance indicators and key risk indicators.
• Developed and implemented necessary exception reporting in support of Credit and the line in order to manage to better manage credit administration risk posed to the Bank.
• Provided support in the design and implementation of ad hoc requests for Credit-Related Portfolio Data.
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time.
• Carried out data extraction and data manipulation using Proc SQL, Proc Sort, Proc Report to create preferred customer list as per business requirements.
• Extensively used SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary, Transpose and Data Null for producing ad-hoc and customized reports and external files.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.
• Extensively used SAS ODS facility to create customized reports in HTML, PDF, RTF formats.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis
• Performed Consumer profiling, Sales forecasting and testing of financial and business models.
• Effectively prepared and published various performance reports and presentations.
• Developed and used scripts to schedule SAS Jobs.

Environment: SAS 9.1.3/9.2, SAS/Connect, SAS Macros, SAS/Access, Oracle 10g, Windows 7, MS Office, HTML, SAS Enterprise Guide 4.3, Unix.