Qualifications Summary

• Resourceful and dynamic technical professional, with over 8 years experience in SAS 9.4 9.3 in Windows and UNIX with SAS eBI, SAS DI 4.2, SAS Advanced, Base SAS Programmer.
• Strong fundamentals in Business Statistics, Mathematical Statistical Analysis and financial mathematics concepts.
• Working on SAS Business Intelligence BI platform to drive the automation of standardized analytics
• Strong command of Software Development Life Cycle SDLC and Data Warehousing concepts Conducted requirements gathering, building specifications, coding, testing and
• implementation
• Generating SAS EG stored processes with static and dynamic prompts for product-specific analyses. Modifying existing codes for improvement in the performance Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets
• Refreshing the SAS data marts on weekly basis for different brands. Scheduling different process using SAS DI studio scheduler and crontab scheduler
• Import all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Well versed with platform for SAS Business Analytics typically client tier consisting of SAS Enterprise guide, SAS Add-in for Microsoft Office, SAS Information Map Studio, SAS OLAP Cube Studio and middle tier consisting of SAS Information Delivery Portal, SAS Web Report Studio, SAS Stored Process Web Application, SAS Content server and SAS BI dashboards
• SAS Management Console used to create the metadata libraries and also for password administration
• Proficient in SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, managing software quality/functionality testing.
• Skilled at ETL operations using SAS/Base, SAS/SQL, SAS/Macros and SAS/SQL.
• Experience in programming for generating graphs, data listings and tables using data steps, procedures, SQL and macros.
• Strong abilities in problem solving, data analysis and complex reports generation.
• Investigated existing SAS code, created query, maintained and defined strategies to improve the efficacy of SAS programs.
• Skilled at concatenating, interleaving and merging datasets.
• Worked with PC SAS, SAS EG, UNIX, SQL Server, Oracle to create reports and analyze data.
• Extensive experience in PROC TRANSPOSE, PROC SUMMARY PROC REPORT, PROC FREQ, PROC TABULATE, PROC FORMAT, PROC PRINT as well as in exporting SAS results to different formats, such as RTF, XML,HTML, Excel, and PDF by using SAS/ODS for report and presentation.
• Experience in developing SAS Macros and application for data updates, data cleansing and reporting.
• Skilled at data modeling, database design, views, normalization, stored procedure, triggers and functions.
• Analyzed business logic and system to prepare dataflow diagrams and documentations.
• Strong command over Structured Query Language SQL .
• Strong programming, analytical and problem solving skills.
• Proficient in Microsoft Office Suite Word, Excel, Outlook and PowerPoint .
• Exceptionally well organized, strong work ethics, and mindset to work hard to achieve client objectives on time.

Technical Skills

• Statistical Software: SAS Business Intelligence, Web Report Studio, Dashboard, MC, Web portal, Data Flux Studio 8.1,SAS Stored processes, Platform process manager, Information Delivery Portal, Information Map Studio. SAS Data Integration Studio, ETL processes SAS Enterprise Guide, SAS Access, OLAP Cube development/design, SAS MO, Minitab, SAS Jmp
• SAS Macro and SAS SQL, proc summary, proc freq, proc report, proc mean, proc tabulate, SAS/ODS, SAS/GRAPH, proc reg, proc corr, proc varclus, proc factor, proc univariate, proc glm. LSF server.
• Operating Systems: Windows 2000/XP/7, Vista, SQL, Linux, UNIX. Database: MS SQL Server, Oracle, My SQL, MS ACCESS.
• Languages: SQL 2012, XML, HTML, Java Script, Shell Scripting, Ms SQL
• Office Tools: MS Office 2013 Suite, MS Project 2012, Toad

Professional Experience

Confidential

Sr.SAS Developer

Responsibilities:

• Held user meetings with the financial analysts for the presentation of reports Interfaced with the testing team to improve the code performance and reduce the errors
• Assisted in data validation of production moves of credit models Performed quantitative analysis and data analysis
• Built data sampling codes for assessing credit risk
• Retrieved the data from flat files received from the vendors and converted to SAS data sets for Analysis using SAS/STAT Procedures such as Proc Freq, Proc Tabulate, Proc Univariate, and Proc anova
• Created views on Oracle tables and indexes on SAS datasets to enhance the speed and performance of the SAS programs
• Created reports using analysis output and export them to the web to enable the customers to have access through Internet
• Created shell scripts which would take arguments from the command line and create subdirectories to store the listing files, output files and graph files
• Developed web-based reports, scorecards, and dashboards using SAS Information Delivery Portal, Web Report Studio, BI Dashboard, Stored Processes, and SAS Server pages
• Create OLAP cubes using SAS OLAP tools for the creation of dashboards and drill-through web based reporting.
• Developed methods to streamline analysis and present business critical information through a combination of SAS BI dashboards and web-based reporting
• Developed a stored process to selectively import users from MS Active Directory to SAS Metadata
• Developed custom themes for the SAS Information Delivery portal for corporate branding
• Developed ad-hoc reports using SAS Macro and Enterprise Guide and SAS VA.
• Assist with the creation, support and scheduling of SAS programs within the reporting infrastructure
• Create and maintain documentation including data dictionaries, report summaries and process run-books.
• Assist with managing and driving different projects needed to change with a dynamic business
• Synthesize data into actionable recommendations
• Converting programs from one version of SAS to another version Process of moving from SAS Version 8 to SAS Version 9 .

Environment: TOAD for Oracle 11, Oracle8i, Secure CRT 5.0, Enterprise guide 6.1, SAS Visual

Analytics 6.2, UNIX-AIX 5.3/AIX 6.1, SAS 9.4/SAS 9.3 EBI tools OLAP cube, Information Map Studio, Information Delivery Portal, AMO, Enterprise guide 6.1, Management Console, Personal Login manager, Work flow Manager, Dashboard, Web report Studio , Stored process and SPDS , BASE SAS macros, data steps, Exceed , Flow manager

Confidential

Sr.SAS Developer

Successful Projects:

• ACG10, Medicaid-Realignment, HICPAC, ICD-10, APR-DRG,EDI WATCH, Claims line,
• OUTBOND Dialer, FACETS 5.1 ,EDW

Responsibilities:

• Data Architecture/ETL Processing
• Designed data warehouses, detailed data stores DDS , and reporting data marts using relational and dimensional modeling techniques for utility, healthcare,
• Utilized slowly changing dimensions to track changes over time
• Developed star schemas for effective reporting on high volumes of data
• Developed a method to centrally manage Change, Data, Capture CDC processing
• Designed and developed Extract, Transform, Load ETL processes using Base SAS, Data Integration Studio, and DataFlux Data Management Studio to populate Data Warehouses and Reporting Data Marts
• Utilized OLAP cubes to report large volumes of data, provide hierarchical drill downs, and slice and dice capabilities

Environment: UNIX-AIX 5.3/AIX 6.1, SAS 9.4/SAS 9.3 EBI tools OLAP cube, Information Map Studio, Information Delivery Portal, AMO, LSF scheduler, Enterprise guide 5.1, Management Console, Data Integration Studio, Personal Login manager, Enterprise miner, Work flow Manager, Dashboard, Web report Studio , Stored process and SPDS , BASE SAS macros, data steps, Exceed , Flow manager. Websphere 6.1 and 7, SVN, FACETS 5.1.

Confidential

Sr.SAS Developer

Responsibilities:

• Worked as a SAS Business Intelligence BI platform to drive the automation of standardized analytics. In loan department, assisted in development of statistical models which helped to determine the loan worthiness of individuals seeking the loans.
• Coordinated with marketing department to finalize the list of individuals to whom the loan can be forwarded so that targeted campaign can be launched.
• Extensive exposure on every step of entire software development life cycle SDLC including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results. Command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using PROC IMPORT and PROC EXPORT.
• Generating SAS EG stored processes with static and dynamic prompts for product-specific analyses. Modifying existing codes for improvement in the performance.
• Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Pulling the data in SAS using Proc SQL and refreshing the data mart on weekly basis. Importing SAS datasets, OLAP Cubes in SAS Information Map Studio .Using instructions on how to access and combine relational Data tables, calculating new data items, created multiple pre-defined filters.
• Building Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports.
• Refreshing the SAS data marts on weekly basis for different brands. Scheduling different process using SAS DI studio scheduler and crontab scheduler.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Worked on a project for Loan Metrics, which involves importing from the Oracle database, cleansing, analyzing and validating data once it is loaded in SAS data set and building various reports according to the business requirements.
• Managing the datasets and making them available on the server using the SAS Management Console, so that the datasets can be used as inputs for creating the Information maps..
• Create Information maps using the Information Map Studio, and further creating the Web Reports using the Information maps as the input through the Web report Studio, and later make these web reports available on the Information Delivery Portal
• Creating the OLAP cubes using the OLAP cube studio and refreshing the cubes on a weekly basis and later make these cubes available on the Information Delivery Portals for use by the business end-users
• Prepared datasets by mining data from various data sources SQL Server, DB2 using SAS Base, SAS EG, SAS/Access, SAS/SQL procedure.
• Developed Macro programs to clean, validate and update data to perform data analysis and generate reports.
• Modified existing datasets using Set, Merge, and Sort, formats, functions and conditional statements.
• Created customized reports using proc tabulate, proc report and proc print.
• Debugged, Created maintained and documented adhocs reports on demands.
• Used options like DROP, KEEP and RENAME to work with some variables.
• Sorted, filtered and joined tables by using SAS EG.
• Debugged, Created maintained and documented adhocs reports on demands.
• Provided database support to modeling and production team.
• Extensively created summary reports using SAS PROCEDURES like PROC FREQ, PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE.

Environment:- SAS 9.3, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 11g , MS Office 2013, SAS Enterprise Guide 4.2 , SAS Marketing Optimization 5.1, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio , SAS Information Delivery Portal, SAS OLAP Cube Studio, SAS BI Dashboard, SAS Enterprise BI Server, SAS Management Console 9.2.

Confidential

Sr. SAS Developer

Responsibilities:

• Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
• Developed new or modified SAS programs and used SQL Pass Through and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Experienced in handling Terabytes of records and manipulating them through SAS.
• Analyzed Interactive Marketing / eCRM System data and produced ad-hoc report details
• Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB.
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence BI to produce required Reports.
• Created various summary reports of POS, Total Sales, Regional Sales and Account Sales of various titles, regions and also presented the various sales reports using the Information Delivery Portal and the Dash Board Portlets.
• Documentation, presentation, data reports and model results to the team/manager
• Used various Statistical Procedures like PROC FREQ, PROC REG, PROC ANOVA and PROC GLM to analyze data and generate reports.
• Used SAS EBI suite for creating, managing reports
• Implemented OLAP cubes, OLAP tools and other report tools like Web Report Studio
• Initially created tables and views in Teradata and used a BI/Query model for local users to access the data tables and reports.

Environment: SAS/Base, SAS/STAT, Teradata, SAS/SQL, SAS 9.2, Windows XP Professional, SAS/Macro, SAS/Access, SAS ODS, SAS/GRAPH, SAS/IML, SAS/ ETL, SAS BI, Oracle 10g, SAS Views, SAS Enterprise Guide, SAS/information mapping, Excel, Windows XP, UNIX, SAS Grid.

Confidential

SAS Developer

Responsibilities:

• Used programming tools such as SAS base V9 Windows and UNIX , SAS MACRO, PROC SQL, Microsoft Excel etc.
• Developed validated and maintained SAS programs for validation, manipulation, analysis and reporting of large volume of data as per the business requirements
• Modified data in several ways using various procedures like Proc transpose to obtain the desired format.
• Created information maps using Information map studio
• Created stored processes and stored them on BI metadata server
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results
• Read both worksheets into SAS data sets and compared the data for any discrepancies. Worked on manipulating data to be used as input to Microsoft Excel.
• Created scripts in UNIX to help improve the efficiency of the application.
• Experienced in SAS Business Intelligence area and in-depth knowledge of SAS BI including OLAP Cube Studio, Web Report Studio, SAS Add In for MS Office, stored processes.
• Created SAS data sets by extracting data from Oracle tables via an ODBC connection using SQL PASSTHRU facility in SAS/ACCESS and writing SQL queries .
• Verified and validated data accuracy to improve the overall accuracy of customer records, product data and other information.
• Worked on resolving production issues, debugging procedures for existing SAS code.
• Generated highly customized reports using PROC FORMAT, PROC REPORT, PROC TABULATE and ODS HTML.

Environment: SAS 9.2, Base SAS, SAS/MACROS, SAS/ETL, SAS/ ACCESS, SAS/SQL, Information Map Studio, Web Report Studio, OLAP Cube Studio, Oracle 9i, SQL Server, MS Excel, Windows XP/2000, Unix