Professional Summary:

• SAS certified professional with 7 years of experience in Business Requirements Analysis, Design, Development, Testing, Implementation and Maintenance of client/server applications in different environments like UNIX, windows and Mainframes
• Proficiency in SAS and R programming, in statistical analyses and predictive modeling
• Highly creative and intuitive in developing, designing and debugging of SAS programs and SAS/Macros to extract, merge and modifying the data for preparation of tables, listings, graphs and reports.
• Extensively worked on SAS macros, SAS Data Steps, SAS Procedures, SAS Views to improve ease and speed of modification as well as consistency of results for large volumes of data.
• Expert in optimization of existing SAS code for efficiency, maintainability, and to correct errors.
• Good in statistical analytics Procedures in SAS for producing various reports.
• Adept in data analysis and design and development of relational database applications.
• Experience in working with multiple file types SAS, Excel, text and convert from one to another.
• Comprehensive experience in analyzing end user requirements and problem solving skills with strong analytical background.
• Extensive programming experience with PROC SQL, PROC Report, PROC Access, PROC Gplot, PROC Gchart, PROC Format, PROC Template, PROC Transpose, PROC Print, PROC Compare, PROC Append, PROC Import/Export, PROC Printto, informats and formats.
• Extensive experience in SAS/STAT Procedures such as PROC Reg, PROC GLM, PROC Freq, PROC Means and PROC Univariate..
• Skilled in optimizing SAS code using Macros.
• Experienced in producing external files and customized reports using various SAS Procedures like PROC Print, PROC Report, PROC Tabulate, PROC Means, PROC Summary, PROC SQL, PROCFreq, PROC univariate, PROC transpose, PROC Rank, PROC Access and data Null techniques.
• Skilled at using basic and advanced RDBMS concepts, SQL, PL /SQL and UNIX commands.
• Used PROC SQL for highly advanced matching and merging in large datasets
• Extensively worked on SAS macros, SAS Data Steps, SAS Procedures, SAS Views to improve ease and speed of modification as well as consistency of results for large volumes of data.
• Expert in optimization of existing SAS code for efficiency, maintainability, and to correct errors.
• Good in statistical analytics Procedures in SAS for producing various reports.
• Experienced in submitting batch jobs and monitoring SAS jobs.
• Good in SAS Administration.
• Good experience in Fraud Analytics using Base SAS.
• Having experience in reading data from flat files, excel files, databases, and data in the mainframes into SAS environment.
• Excellent understanding in OLTPModeling and OLAP Dimensional modeling Star and Snow Flake , database design and data analysis.
• Very Good Experience in databases such as Oracle 8i/9i/10g, SQL SERVER 2000/2005, DB2 and Teradata V2R6.0/V12 and Knowledge in web servers like JBOSS ,Oracle Weblogic.
• Interacted with the Business Users to gather requirements, design tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts.
• Experienced in IBM Mainframes: MVS/JCL, Javascript,

Technical Skills:

• Statistical Software SASV9.4/9.3/9.2/9,1,3/8.2,BaseSAS,SAS/SQL,SAS/MACROS, SAS/STAT,SAS/GRAPH,SAS/ODS,SAS/ETS,SPSS
• R/R Studio
• BI Suite SAS Enterprise Guide4.3,SAS Management Console9.2, SAS Information Deliver Portal 4.2,SAS Web Report Studio, SAS Stored Process Web Application, SAS OLAP Cube Studio4.2,SAS BI Dashboard,SAS DI Studio4.2,Tableau, WebFocus Developer Studio, Mainframe Focus.
• ETL Tools SAS DI Studio4.2, Informatica Power Center 8.x, DTS, AbInitio
• OLAP Tools Business Objects 6.5
• Decision Support Capstone
• Data Modeling Erwin Data Modeler r7.3/4.x ERD , Oracle Warehouse Builder
• Databases Oracle 8i/9i/10g, MS SQL Server 2000/2005, IBM DB2, Teradata V2R6/V12
• Web Technologies JBOSS-4.2.0, Apache 2.2
• CRM Siebel
• Programming Languages C, C , Java
• Mainframe Tools MVS/JCL
• Methodologies Star Schema, Snowflake Schema
• Operating Systems Windows 98/2000/NT/XP, UNIX, Linux, Sun Solaris, AIX, MVS
• Version Control MS Visual Source Safe VSS , clearcase,ClearQuest, Tortoise SVN
• Others MS Office, Microsoft Project 2010, MS Visio, TOAD, FileZilla, Quick Base,WinSCP, PVCS, FTP,SFTP,SCP,Telnet,HPSD,HPSM,TDG,Tes Web,AQTV7.1.3,WS FTP12,SQL Loader.

Professional Experience :

Confidential

SAS Developer

Responsibilities:

• Created specification documents as in the part of requirement gathering analysis.
• Captured Meta data information for data warehouse tables and also developed Use Cases for developing SASStored Processes.
• Developed function definition files for Births and Mortality for derived calculations like Crude Rate, Age Adjusted Rates etc.
• Extracted data from raw data files and created SAS data sets as per user requirement.
• Data cleansing and Data manipulation done using Data step, PROC Step and Macros.
• Executed queries in the query builder and generated query results.
• Used R functions anddid code migration from R to SAS whenever necessary.
• Developed checks for to validate query results.
• Extensively used SAS Procedures like PROC SQL, PROC PRINT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY and PROC DATASETS etc.
• Developed SAS stored Processes and generating adhoc reports, various Dynamic and Static Reports.
• Used Macros for validation and cleaning of data.
• Maintained user privileges, adding libraries and scheduling the reports through SAS Management Console9.2.
• Executed SAS Stored Processes through SAS Information Delivery Portal.
• Extensively used SAS SQL Procedure for filter, join the tables from DB2 Database.
• Build Quick Reports from Web Report Studio using Information maps.
• All Reports Imported from web report studio, Stored Processes and Information Maps to Information Delivery Portal.
• Designed and developed different report templates based on the user specifications.
• Created cubes, Information maps and design the reports as per user request.
• Developed Dashboards, KPI and Score Cards using SAS BI Dashboard.
• Promoted SAS Stored Processes from development to testing and testing to Production environments.
• Performed Unit and Integration testing.
• Run the SAS jobs by Daily, Monthly, Quarterly, Annually and on demand requests.
• Communicated with team for daily project activities and issues.
• Prepared technical design document, SMTD documents.
• Maintained SAS servers for start and restart PROCess.
• Experience in installing, configuring, and administering SAS BI platform

Environment: AIX 5.3, DB2, Base SAS9.2, SAS Enterprise Guide4.2, SAS Management Console9.2, SAS Information Delivery Portal4.3, SAS OLAP Cube Studio4.2, SAS Web Report Studio4.3, Web Focus Developer Studio,SAS Stored PROCess Web Application,SAS BI Dash Board, Mainframe Focus, SAS DI Studio4.2 ,Advanced Query Tool, IMS, Mainframe TPX ,JBOSS-4.2.0,Javascript, Microsoft Project 2010.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Involved in writing code using Base SAS SAS/Macros to extract, clean and validate data from oracle tables.
• Created SAS datasets in local SAS directory.
• Created tabular reports using Base SAS SAS/Reports Procedures.
• Created SAS views from Oracle database tables using SAS/Access
• Several reports are generated based on the requirements using PROC report, PROC Tabulate, PROC print and Data Null .
• SAS data sets are validated using SAS Procedures like PROC Means, PROC Freq and PROC Univariate.
• Combined and grouped datasets using concatenation and merging.
• Designed flowcharts indicating the input data sets and the techniques that would be used sorting, merging, etc. to get the desired output.
• Exclusive Data Step programming needed for calculating final variables.
• Write SAS code according to the design specifications. Preliminary data validation Health Care data quality check needed to be done on the data using PROC FORMAT and manual checking .
• Responsible for cleaning, reformatting and loading the data into the database Microsoft SQL Server .
• Write SQL Stored Procedures to extract the data from and to text files bcp in, bcp out which were later used to create SAS datasets.
• Assist in User Acceptance Testing and Unit Testing.
• Document the Test Results and Correct Requirements Documents.
• Write ODS SAS Procedures to publish reports as HTML pages to Web.
• Develop reports using PROC REPORT and DATA NULL . Create reports in the style format using ODS statements and PROC TEMPLATE. Query Data from the host using the PROC SQL pass through facility. The reports were sent to FDA.
• Validate the output based on input and compare the output results with the expected results using PROC COMPARE.
• Extensive usage of Base/SAS and SAS/Macros. Used Procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC COMPARE, PROC TABULATE and PROC REPORT.
• Required to integrate variables, unit test and integrate jobs into SAS/ETL.
• Conduct formal code walkthroughs and prepare formal documentation.

Environment: SAS/Base 9.1.3, SAS/SQL, SAS/Macros, SAS/ETL, SAS/Report, DATA NULL, MS-Excel, Windows 2003 Server, Microsoft SQL Server, T-SQL, Enterprise manager, Query Analyzer, BCP Bulk Copy , Visual Source Safe version Tracking .

Confidential

Sr SAS Programmer

Responsibilities:

• Involved in the developing of SAS code for multi models.
• Developed model specs which contains functional requirements requested by LOB.
• Developed SAS code components to implement a model on AMI.
• Developed the code for reusability, the same code that dynamically differences different sets of inputs for each model.
• Extracting data from large databases using SAS for model development or ad hoc analyses.
• Focuses on risk model output, adding quality and traceability of reports and output data from models used to generate the data for the risk models.
• Validated the test results for phoenix, scorecard models and Canada models.
• Write the wrappers that shall validate/transform the input and call the respective operations in the SAS model.
• Provided production problems resolutions on AMI applications.
• Performed and coordinate change requests, defect tracking.
• Responding to user requests, and monitored systems adequately.
• Executed ad hoc and scheduled reports.
• Involved Support call resolution or following up on Help Desk tickets.
• Involved Change Control PROCesses to ensure proper approval, coordination, and communication of systems changes.
• Followed resolution and escalation PROCedures based on problem severity and impact.
• Involved model test plan, model validation plan for test documents ,PROCedures and validation of the model
• Coding updates are deployed to test regions by release management.
• Testing performed after AMI and Capstone updates are complete and deployed to test region
• Developed UNIX Korn Shell scripts.

Environment:SAS9.2/Base,SAS/Macro,SAS/Access,SAS/STAT,SAS/ODS,SAS/GRAPH,SAS Enterprise Guide4.1, SAS Web Report Studio, SAS Information Delivery Portal ,SAS Management Console,SAS BI Dashboard,Capstone, TDG, TesWeb,SQL Developer,Oracle9i.HPSD,TDG,Tes Web,Oracle9i, UNIX,XML

Confidential

SAS Programmer/Analyst

responsibilities:

• Analyzed the data based on the requirement.
• Analyzed large data sets consisting of million records.
• Worked with large customer response and sales data sets.
• Used SAS/FSP to Browse and Edit SAS Data Sets.
• Converted existing PL/SQL scripts to conform to new standards
• Ad hoc listings and reports
• Extensively used SAS PROCeduresPrint, Sort, SQL, Mean, Freq etc.,
• Wrote Base SAS programs to generate reports.
• Done extensive shell scripting using Korn shell.
• Created graphs using SAS/GRAPH based upon the analyzed data.
• Gathering business requirement
• Prepared SMTD for Monthly, Quarterly jobs for US and Canada.
• Extracting the data from Oracle using SAS/Access
• Extensively used SAS macros for Process automation.
• Reports generated by using SAS ODS ,PROC Report
• Produced production level report monthly, quarterly for US and Canada
• Produce monthly supplier reports for US.
• Schedule and monitoring monthly and quarterly jobs for US Canada
• Changes on monthly and quarterly code according to customer requirements adding new menu items and its conversion efficiency to the reports.
• Automated SAS jobs through UNIX scripts.
• Interacting with customer on regular basis.

Environment: SAS/Base v8.2, SAS/Macros, SAS/Sql, SAS/Access, SAS/Stat, SAS/Graph, shell scripts, Unix, Windows NT, Oracle, PL-SQL, MS-Excel and PowerPoint.

Confidential

Lead Analyst

Responsibilities:

• Extracted data from Teradata using SAS/Access.
• Wrote Macros to develop a concise and reusable code.
• Converted large data from Teradata to SAS data sets using SQL pass through and libname facility.
• Data cleansing and Data manipulation done using Datastep and PROCedures.
• Extensively used PROC PRINT, PROC REPORT, PROC GCHART, PROC TABULATE, PROC MEANS, PROC FREQ, PROC SQL and PROC DATASETS.
• Maintained and enhanced existing SAS reporting programs.
• Prevalidation and post validation checks done on weekly PROCess.
• Analyzed and implemented code and table changes to improve performance and enhanced data quality of SAS programs.
• Conducted statistical modeling for both continuous and categorical data, including regression, ANOVA, GLM model etc.
• Users privileges defined through SAS Management Console.
• Servers bounce PROCess done on weekly basis.
• Prepared PROCess flow diagrams using MS VISIO.

Environment: SAS 9.1.3 ,HP Integrated Lights Out, Teradata7.2,Toad,Windows Server 2003,UNIX,Teradata7.2, Base SAS, Macros, SAS/Access, SAS Management Console,MS VISIO,SAS Enterprise Miner,SAS/Stat