CAREER OBJECTIVE:

To obtain a position in an environment, which will use my skills and expertise in its process of growth and development while giving me opportunities to learn and enrich my competencies

TECHNICAL SKILLS:

• SAS Tools: SAS/BASE, 9.1, 9.2, SAS/GRAPH, SAS/MACROS, SAS/ODS, SAS/REPORTS, SAS/ACCESS, SAS/STAT, SAS/ETL.
• SAS Procs: Print, Means, Univariate, Correlation, Regression, Time series, Tabulate, Freq, Sort, Summary, Format, Import, Export, Transpose, Compare, and Gplot.
• Database: SQL Server 2000, MS Access.
• Operating Systems: Windows XP/NT/2000/98
• Others: R Programming, Eview's, SPSS and MSOffice.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Research Analyst SAS

Responsibilities:

• Create complex SAS algorithms to identify opportunity for various research projects.
• Provide analytical and technical support for professors and projects in their research.
• Develop end-to-end reporting based on business requirements using SAS views from database tables using SAS/ACCESS and writing SAS programs using BASE SAS and SAS MACROS to create SAS reports.
• Utilized SAS PROC SQL Pass through facility for data extraction, location and retrieval from the database.
• 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.
• Used SAS procedures FREQ, SUMMARY , SAS functions and user defined macros to test the accuracy and validity of data.
• Solve complex issues and implement solutions to enhance productivity, improve quality and customer satisfaction.
• Generated output files in text format, CSV, HTML PDF format using SAS ODS.
• Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan.
• Work with research scholars to help in their projects and other research projects.
• Conduct code review and testing of final results to ensure the work delivered by the team is of high quality standards.
• Performed Data validation, data integrity and data profiling on the data
• Work with the Business Analyst in process improvement initiatives as directed by the business.

Environment: SAS/BASE 9.3, SAS/EBI, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/IML, SAS/EG, SAS/ODS, SAS/ACCESS and MS Access Database.

Confidential

Strategic Analytics Reporting:

Responsibilities:

• Performed statistical analysis and data evaluation of loss trends, loss development patterns, and product and claims analysis by utilizing appropriate statistical and actuarial methods using SAS.
• Involved in the fundamentals of rate making and actuarial methods for bringing historical prices to current rate level, and for developing and trending historical losses to project future costs.
• Involved in collect and analyze data to use for financial and utilization reporting and monitoring including IBNR for solvency reporting.
• Used various SAS techniques to integrate results of the Marketing Mix Analysis, Price Elasticity, performance and other advanced analyses into business planning process.
• Work closely with different Marketing Groups in designing and analyzing the data.
• Involved in planning, coordination, execution and reporting efforts associated with execution of data analytics in support of fraud detection.
• Applied data analysis tools and techniques to help management evaluate data quality in support of system implementations.
• Performed statistical analysis of financial and operational data using SAS/STAT and other statistical procedures like Proc Means, Proc Freq, Proc for short- term and long-term programs designed to achieve corporate marketing objectives like sales forecasting, targeting etc.
• Write optimized queries and reports to accurately access data using SAS and SQL.
• Involved in segmentation analytics to assess policy life expectancy and policy tenure influences on cost and average premium to select targets in support of lifetime pricing
• Analyzed statistical information to estimate various actuarial methods like IBNR, Claim ratios, projections, sickness, disability, and retirement rates and solvency models.
• Collaborated with managers, underwriters, accounts, claims experts, and senior management in develop plans for new lines of business or improving existing business.

Environment: Base SAS 9.1.3, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, MS-Excel Windows OS.

Confidential

Data Analysis/Reporting:

Responsibilities:

• Assisted to departments in developing new products by researching and statistical modeling, obtaining and evaluating information and building predictive models that supports revenue growth and profitability performs primary field research, including customer, distribution, competitor, and insurance department and market surveys.
• Performed moderate to highly complex actuarial functions used in determination of the indicated rate level and product performance need for a line of business.
• Worked with large databases containing data from multiple sources, at various levels of granularity, using SAS and SQL to write queries to extract data and create a dataset ready for analysis.
• Validated data and created reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
• Extensively used statistical procedures and predictive modeling techniques such as ANOVA, Regression Analysis, Trend Analysis, and Cluster Analysis.
• Assisted in the product performance, maintaining rate, rule and coverage comparisons and assist in the implementation of change process by performing predictive analysis.
• Analyzed information using various SAS Procedures for data manipulation and correlation created various reports to assist the product manager.
• Using SAS retrieved and performed claims and insurance data and prepared reports, charts and graphs in showing cost of risk / cost of insurance / loss ratios exposure growth and its relationship to claims and funding trends.
• Involved in product management, actuarial analysis in an analytical role. Cleanse the raw data and preparing variables for model building using SAS/BASE, SAS/STAT
• Performed predictive analytics for claim ratios and provided advanced analytical solutions to complex problems for motor, health and commercial insurance segments.

Environment: SAS 9.1.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/STAT, ODS, DDE, SQL Server, Window NT/ XP, UNIX.

Confidential

Credit Risk Reporting:

Responsibilities:

• Extracting data from various MI Systems for the creation of meaningful and insightful management information.
• Designed, coded, tested and debugged SAS programs to generate listings, Tables.
• Generated SAS macros as part of the standard programs and validation
• Created SAS dataset's from tables in Database using SAS/Access. Retrieved the loan data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Used Dynamic Data Exchange DDE feature of SAS for importing and exporting data between SAS.
• Generated modeling variable based on univariate and bivariate analysis, supported various business requests which requires statistical analysis.
• Performed logistic regressions, CHAID and decision trees on loan portfolio data.
• Performed portfolio performance and credit risk management strategies to results in identifying deviations from forecast/expectations and explain variances.
• Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/Base and Macro facility
• Developed sophisticated risk strategies for credit rate migration, and analyzed and mitigate fraud risks by identifying the risks associated with different customer loan portfolios.
• Involved in developing pricing strategy in concert with deposit and loan Pricing Mangers and Product Management for retail deposit and loan portfolios.

Environment: SAS 9.1 Base, SQL Macros , SAS Enterprise Guide, SQL, MS-Excel, Windows OS.