Summary

• Have 7 years of experience in Finance and Marketting Industry.
• SAS Programmer/Analyst with extensive experience in SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ACCESS and SAS/SQL in UNIX / Windows environment.
• Experience in extracting data from flat files, spreadsheets, external RDBMS ORACLE, DB2 SQL Server, Teradata using SQL Pass-through facility.
• Experience in Data Exporting and Data Importing of different file structures.
• Extensive programming experience with Proc Report, Proc Tabulate, Proc Format, Proc Transpose, Proc Print, Proc Append, Proc compare, Proc Sort, Proc Freq, Proc Import, Proc Export.
• Experience in using arrays, table look ups and data merging.
• Extensive use of statistical analysis techniques such as correlation, regression, ANOVA and MANOVA using BASE SAS and SAS Enterprise Guide.
• Experience in writing new programming codes and macros for data analysis and data validation.
• Possess good knowledge in SAS functions, Data step programming, SAS Procedures.
• Debugging, enhancements and testing of all delivered production code quality control, execution and maintenance . Strong SAS programming background for maintaining existing code, ad hoc reporting and supporting the reporting functions.
• Experience in converting SAS data sets to other files HTML, PDF using SAS ODS.
• Extensive knowledge in data management like Merging, concatenating, interleaving and moving of SAS datasets.
• Experience in extracting data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Experience in RDBMS development specifically MySQL, Oracle and Teradata using Oracle SQL developer, Toad and Teradata SQL assistant.
• Thorough hands-on experience in using ODS to generate different files including RTF, MS Excels, PDFs and HTMLs
• Experience in testing and validation of application on windows.
• Extensive knowledge in generating graphs and reports, their Documentations as per client's specifications.
• Comprehensive skills in working with Base SAS, SAS/MACRO in UNIX and Windows environments.
• Experience in time series and forecasting techniques using SAS enterprise guide.
• Strong Knowledge in advanced analytics and Text and Data mining Techniques.
• Good knowledge of data validation using PROC FREQ, PROC MEANS and PROC UNIVARIATE.
• Experience in developing complex SAS Programs, Macros for data updates, data cleansing, and reporting.
• Highly motivated individual with excellent organizational and interpersonal skills. Possess strong ability to quickly adapt to new applications and platforms.
• Good experience in working cordially with the team members and with other related groups working in the company.
• Ability to work on multiple projects simultaneously and meet the project deadlines.

Confidential

SAS Designer/Developer

Responsibilities:

• Extracted data from the database using SAS/Access and Teradata SQL Assistant.
• Populated and maintained existing Weekly excel dash board and populated monthly KPI reports for prepaid product
• Reviewed existing reporting outputs to validate current deliverables prior to publication.
• Used SAS to develop a forecast model for campaign forecasts
• Using historical data on transactions, identified key explanatory variables, profiled merchants into various groups, developed weights of evidence and used SAS enterprise miner for recognizing patterns.
• Involved in developing and validation of churn modeling using SAS Enterprise Miner using explanatory variables to forecast merchant retention for PayPal's Latin American operations.
• The model was subsequently used by the operations team to score merchants for retention.
• Extensively used Tara data SQL Assistant to assess the halo effect of various PayPal products and services. The analysis was used to measure the overall effect of the PayPal brand on adoption of its products.
• Responsible for streamlining ETL process for prepaid product to meet future analytical requirements with in data limitations.
• Interacted with business teams for requirement gathering and conducted several meeting to give project progress and explain the bottlenecks.
• Take instructions and perform tasks as necessary as directed by reporting manager.
• Develop and ensure specifications and documentation are correct and complete per client SOP and methodology such as Detailed Level Design specs,
• Work with other team members to ensure outputs are correct and complete.
• Organize, plan, and prioritize work to accomplish project objectives.
• Analyze information and evaluate results to choose the best solution and solve problems.
• Unit test objects.

Environment: Base SAS v9.3, SAS Stat, SAS/Access, SAS/GRAPH, SAS Enterprise Guide, Enterprise Miner, Excel, Teradata, Windows, UNIX.

Confidential

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: Enterprise guide 6.1, SAS Visual Analytics 6.2, UNIX-AIX 5.3/AIX 6.1, 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

SAS Programmer

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 ad-hoc 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 ad-hoc 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, SAS Enterprise Guide 4.2, 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

Programmer

Responsibilities:

• Analyzed large data sets consisting of million records
• Automated Risk division reporting process using SAS and MS Excel.
• Creating a customer statistical mailing list for Direct Mailing and Telemarketing. Worked with large customer response and sales data sets
• Developing code for star-schema and MDDBs.
• Deploying data mart and decision support systems.
• Implementing physical models using Oracle database.
• Maintain and enhance existing SAS reporting programs for marketing campaigns.
• Maintain SAS analysis for the products purchased every month.
• Conduct significance tests and study response rates for different level of Marketing based on the reports.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Extracted data from warehouse using SQL procedure and created SAS data sets.
• Created reports using analysis output and export them to the web to enable the Customers to have access through SAS Integration.
• Extensively used SAS procedures Print, Sort, SQL, Mean, Freq.

Environment: BASE SAS, SAS MACROS, SAS/ACCESS, and SAS/ODS, SAS/Stat, SAS/MDDB, SAS/SQL, SAS/GRAPH, SQL Server, DB2, MS EXCEL, MS ACCESS and WINDOWS.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Report Development using a variety of SAS Procedures and Tools: including ODS, Enterprise Guide
• Assisted in developing regression models for better decision making on consumer purchasing pattern
• Sorted data for tables and then merge tables by using MERGE and BY statements. Also used options like DROP, KEEP and RENAME to work with some variables.
• Used Data null to create date logic by using macros.
• Created SAS MACROS for applications to extend and customize SAS software programs and used existing SAS MACROS for standard reporting
• Debugged, Created maintained and documented adhocs reports on demands.
• Worked with marketing team for setting up new assignment, pulling data, making new processes, maintain and documents them.
• Provided database support to modeling and production team.
• Develop and maintain new or currently used applications/programs and take Well-defined technical steps to find out the problems /issues and resolve them.
• Direct coordinate with customer regarding missing, incomplete and data outlier.
• Analyzed large data sets consisting of million records
• Creating a customer statistical mailing list for Direct Mailing and Telemarketing. Worked with large customer response and sales data sets.
• Extensively created summary reports using SAS PROCEDURES like PROC FREQ, PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE
• Generated Ad hoc reports using SAS ODS engine and Proc SQL.
• Used SAS/ACCESS SQL Pass-Through Facility to access the data.
• Used SAS ODS facility with PROC Report procedure to generate reports in PDF and HTML formats.
• Used PROC ANOVA, PROC MEANS and other analysis procedures in generating real time reports.
• Involved in complete validation of all the SAS programs used.
• Was involved in the documentation.

Environment: SAS Enterprise Guide, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/STAT, SAS/SQL, ORACLE, MS-OFFICE, Windows XP professional, Access, Excel, UNIX.