PROFESSIONAL SUMMARY:

• Statistical Business Analyst/Programmer with over 6 years of experience in analysis, design, development, testing and implementation of Applications in Financial, Retail and Healthcare Industry using SAS.
• Extensive knowledge of Banking, Health Care, Retail and Campaign marketing data.
• Adept in Base SAS, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/IntrNet, SAS/CONNECT and SAS/ODS etc. in Windows UNIX environment.
• Experience in PROC SQL joins and PROC SQL set operators to combine tables
• Efficient in utilizing SAS Functions, SAS Procedures, Macros, and other SAS application for data updates, data cleansing and reporting
• Competent in developing programs to generate derived datasets from raw data imported from various sources.
• Strong in Data management, data extraction, manipulation, validation, and analyzing huge volume of data.
• Expert in transforming data imported from different data sources into analysis data structures, using SAS functions, options, ODS, macro facility and other SAS procedures.
• Experience in extracting data from relational databases like Oracle, DB2, Teradata, SQL Server and MS Access etc.
• Sound in Developing and designing SAS Programs / Macros to access and analyze financial data used in CCAR submissions.
• Experience in working with Business Users and Technical Teams to understand requirements and to develop code based on SDLC procedures.
• Proficient in transferring data across different environments using FTP, SFTP, Humming Bird and Synchrony.
• Well versed in writing UNIX shell scripts.
• Fluent in statistical and machine learning algorithms such as decision trees, neural networks, collaborative filtering, clustering, survival analysis, graph theory, etc.
• Proficiency in Time Series Forecasting techniques ARIMA, ARCH/GARCH using SAS Enterprise Miner.
• Analytical, organized, enthusiastic to work in a fast paced and team oriented environment
• Strong communication skills, problem solving skills and challenge oriented.

Statistical Knowledge:

Inferential Statistics Parametric : T-tests independent sample and repeated measures , Analysis of Variance - One way and factorial, linear Regression, Multiple - linear regression models, algorithms- stepwise and forced , post hoc test, Chi Square test of independence and goodness to fit , ANCOVA and Decision Tree . Multivariate calculus, Linear algebra, Hypothesis testing and Bayesian methods.

Descriptive Statistics: Histograms, Box - plots, Charts, Means etc.

Data Mining Knowledge:

Data Extraction, Data Cleansing and Preparation, Model Fitting, Performance Measurement and Evaluating models using SEMMA approach.

SPSS Modeler SAS Enterprise Miner: Predictive Modelling, Pattern Discovery Market Basket Analysis, Segmentation Analysis , Regression Models, Cluster Analysis, Decision Tree, Trend and Pattern Analysis, Classification models, Neural Networks and Forecasting models.

Technical Skills:

• Statistical: SAS Enterprise Guide, SAS Enterprise Miner, SAS JMP, SPSS Modeler, R, Weka,, Python, STAT Graphics, Matlab ,Mathematica Wolfram , Tableau, Spot fire, Data Flux
• Programming Languages: C, Java, Python, SQL and SAS.
• Database: Teradata, Microsoft SQL Server, My SQL, Oracle, MS Access and Excel.
• Productivity: MS Office Power Point, Outlook, Project, Excel, Access .
• Operating Systems: Windows, UNIX.

EXPERIENCE:

SAS Programmer

Confidential

Responsibilities:

• Used SAS v9.2 UNIX environment and Programming in SAS base, Macros and Performed cluster analysis to identify critical factors for Software designing.
• Interacted with assigned business analysts to perform work outlined.
• Created database objects like tables, views, stored procedures, functions, joins, indexes and triggers in T-SQL based upon the functional specifications.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code and optimized.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
• Accessed multiple databases using SAS and provided ongoing reporting that supported information-based decision making.
• Documented and delivered Functional Specification Document to the project team.
• Used SAS procedures such as Report, Tabulate, Freq, Means, Summary and Transpose for producing customized reports.
• Developed SAS programs to extract, transform, clean and manage large data files.
• Validated existing Data Model and identify opportunities for removing redundancies.
• Worked with SAS/ODS, HTML to produce dynamic web interfaces from SAS programs.

Environment: Base SAS, SAS/Graph, SAS/Macros, SAS/SQL, SAS/STAT , SAS/Access, SAS/Connect, SAS enterprise Guide, MS SQL Server, MS Visio, MS Project, MS Office

SAS Programmer Analyst

Confidential

Responsibilities:

• Financial data from the database is extracted using SAS/Access, SAS SQL, SAS/Connect, and Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, PROC Univariate, and PROC ANOVA.
• Design of ETL process to meet the requirement of data demand.
• Retrieved the financial data from flat files received from the vendors, convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Writing Meta data for important data set before archive into SAS metadata server.
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc. Used data
• Cleaning tools such as Proc Freq, Proc Print, Data null , Proc means, Proc tabulate, Proc Univariate, Proc SQL.
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, CPORT, ODS having formats such as HTML, RTF, or XML.
• Regular interaction with the financial analysts for the presentation.
• Performed in-depth quantitative data analysis.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Experience in Advance SQL to extract data from various databases like Oracle.
• Experience in Transferring and converting data from one platform to another to be used for further analysis. From Oracle and Excel to SAS and vice versa
• Interfaced programs with Oracle databases to provide accurate reporting, archiving, and error handling.
• Created required financial reports using analysis output and export them to other environments or the web using various SASODS methods for creating delimited text files, HTML, RTF, or XML files.
• Regular interaction with the financial analysts for the presentation.
• Performed in-depth quantitative data analysis.
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Experience in Advance SQL to extract data from various databases like Oracle.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel, MS Access, Korn Shell

SAS Programmer Analyst

Confidential

Responsibilities:

• Collaborate with physicians, medical writers and data managers to finalize mock tables
• Design select appropriate SAS procedures for each statistical analysis test-run SAS program on mock data to ensure smooth analysis implementation.
• Use PROC SQL/IMPORT to import data from mainframe oracle clinical databases and MS excel sheets. Perform Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Access.
• Produce quality customized reports by using PROC TABULATE, PROC RPORT Styles, and ODS RTF and also provide descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE.
• Work with statistician to analyze the results obtained from various statistical procedures like Chi-Square, PROC ANOVA, GLM, and T-test.
• Develop and debug routine SAS macros to create tables, graphs and listings.
• Provide proper validation, including testing and documentation e.g., requirements document, program validation , in accordance with GCP and company standards.
• Contribute to the development of manuscripts, labels, scientific and commercial presentations, and regulatory response documents by generating statistical tables and graphs through SAS programming.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, PL/SQL, ODS RTF, SAS/STAT, SAS ETL,

SAS/Enterprise Guide, SAS/Grid, SAS Data Integration, Excel, Windows, SPSS, Oracle, Teradata.

Market Research Analyst

Confidential

Responsibilities:

• Worked as a SAS programmer and analyst in revenue assurance and reporting department using internal system tools like PC SAS, SAS EG, UNIX on TARO server, TOAD for oracle, TERADATA SQL Assistance, WIN SCP and SAS Mainframe.
• Specially involved in Marketing team - Production area with NDW National Data Warehouse and TERADATA.
• Was closely working with Business Intelligence team for setting up new assignment, pulling data, making new processes, maintain and documents them by using SAS BI tools.
• Worked with and reported to executive directors to provide business requirements/reports by pulling data from TARADATA database, ORACLE database TOAD , very large dataset by using PC SAS and SAS EG.
• Created complex SQL query by using specifies TERADATA specific SQL with PROC SQL EXPLICIT - SQL pass through and using LIBNAME statement SAS SQL - IMPLICIT on TERADATA as well as on UNIX SAS server.
• Debug, Create, maintain and documented AD HOCS reports on demands.
• Created SAS data sets by extracting data from Oracle database and flat files using Proc SQL, Proc Import, SAS Data Step, cleaned, validated and manipulated data by SAS and SQL.
• Created report using report wizard with an OLAP Cube, using templates with an information map, also created OLAP Cube with SAS OLAP Cube studio, also did work on SAS Add-In for MS with SAS BI team.
• Supported, troubleshoots, and maintained production systems as required, resolving problems, and providing timely follow-up on identified issues.
• Created reports including tables, listings, and Graphs by using PROC TABULATE, PROC SUMMARY, PROC FREQ, PROC REPORT, and PROC GPLOT.
• Use Data null to create date logic by using macros.
• Use PROC CONTENTS to change the variable name by creating MACROS.
• Created DDE and templates based on SAS code by using MACROS, select and put options for final output.
• Exported and imported data from or in to SAS environment by using wizard and PROC EXPORT/IMPORT statements.
• Scheduled job on CRON for daily, weekly and monthly SAS processes for automation, also rescheduled, dropped and delete SAS processes by using UNIX commands.
• Work on data space management by maintaining datasets created by SAS automation processes by using UNIX CONSOL command.
• Attended annually, monthly and daily meetings in order to set up new goals like customer loyalty program, Customer segmentation, and new product launch.
• Use RSA and CISCO system to connect remote computer and submit SAS code and DDEs remotely on PC SAS.
• Handled datasets has more than 800 variables and millions of observations.

Environment -SAS 9.2, 9.3, SAS Enterprise Guide 4.2/4.3, UNIX TARO server, TOAD for Oracle, SAS WRS, CRON-facility for SAS automation and WIN SCP- for Data sharing.