Data Sas
Resume:
Sai Reddy
***********@*****.***
SUMMARY:
Expertise in SAS with over 8 years of experience includes detailed knowledge of statistical analysis of financial, marketing and health care data and in the production of reports, tables, graphs and listing. Experience in Data analysis and Reporting in health care, finance and marketing sectors.
Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments
Developed new or modified existing SAS programs to load data from the source and create study specific datasets
Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design
Strong experience with databases like Oracle, MS SQL Server 2000, DB2 and MS Access
Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments
Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process
Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing
Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio
Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database
Extensive knowledge of advanced SAS/STAT procedures including UNIVARIATE ANALYSIS, REGRESSION, ANOVA, GRAPH AND PLOT
Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis
Possess a strong ability to adapt and learn new technologies and new business lines rapidly
Effective team player with strong communication & interpersonal skills
Skilled in using SAS Statistical procedures like PROC REPORT, PROC TABULATE, PROC CORR, PROC TRANSPOSE, PROC GLM, PROC ANOVA, PROC LOGISTIC, PROC TTEST, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC LIFETEST. Strong ability to write SQL queries using PROC SQL
Hands on Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks. Created complex web reports from SAS data and information maps using SAS WEB REPORT STUDIO.
TECHNICAL SKILLS
SAS Tools SAS 9.3, SAS/BASE, SAS/MACRO, SAS/SQL, AS/ACCESS, SAS/STAT, SAS/ODS SAS/CONNECT, SAS/GRAPH, SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO, SAS/ENTERPRISE MINER, SAS/INFORMATION, DELIVERY PORTAL
Databases Oracle 9X/8.x, MS SQL Server 2000/2005, Teradata 11/12, DB2, MS Access, Informix
GUI Tools MS Office, MS Project, MS Visio
Commercial Tools Informatica, Expediter, FileAid, Rapid SQL, Crystal Reports, Hyperion, ERWin, Roscoe, RCS
Operating System WINDOWS XP/NT/Vista, UNIX(AIX), MVS, z/OS
Programming C, C++, SQL, VBA, VB 6.0, Java, HTML, XML, Bourne Shell
Languages
Reporting tools Crystal Report, Hyperion, MS SQL Server Reporting Services
PROFESSIONAL WORK EXPERIENCE
Infocrossing Healthcare Services, Jefferson City, MO Feb 2016 – Present
Role: SAS Consultant
Infocrossing Healthcare Services, Inc. provides information technology outsourcing and transaction management solutions to the healthcare industry. It offers claims processing, business and clinical application hosting, health plan application, and information technology infrastructure services for the payer, provider, and government markets.
Responsibilities:
Integrated business needs and technology solutions to solve data and reporting challenges.
Used SAS Data Integration Studio to build Data Marts from enterprise data sources instructor based course from SAS Institute.
Developed and maintained daily, weekly, monthly processes.
Designed, developed, and programmed, daily dashboard reports.
Streamlined existing SAS code for table look-ups.
Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets.
Wrote different joins and merges to create reports based upon the requirements given.
Used PROC IMPORT to convert raw data files in different formats to SAS data sets.
Combined data vertically using SET statements, PROC APPEND and SET operators in PROC SQL.
Developed SAS Macro programs to create Ad-hoc reports. Automated SAS processes on UNIX to deliver data.
Utilized SAS/ODS to create reports in PDF, RTF and HTML format.
Presented SAS papers in SAS conferences.
Environment: SAS 9.2/9.3, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 4.3/5.1, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Data Integration Studio (ETL tool)4.3/ 4.4 SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Management Console 9.2, Windows
Fulton Bank, Mount Laurel, NJ Jan 2015 - Feb 2016
Role: SAS Programmer
Fulton Bank is a financial services holding company headquartered in Lancaster Pennsylvania. Fulton Financial Corporation operates affiliates in Pennsylvania, New Jersey, Delaware, Maryland and Virginia.
Responsibilities:
Used SAS and SQL to perform ETL from Oracle and Teradata databases and created SAS datasets, SAS Macros, Proc/data steps and SAS formats as required.
Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets.
UsedSASPROCSQLpassthroughfacilitytoconnecttotablesandcreatedSASdatasetsusingvariousSQL joins such as left join, right join, inner join and full join.
Data processing and validations were done extensively on the SAS datasets using edit check programs
Developed report asper business requirements and created various reports like summary reports,tabular reports, excel reports etc
Converted programs from Teradata SQL to SAS to automate the monthly production processes. Developed new/modified macros for report generation using SAS/Macros as per business requirements
Developing and analyzing key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA _NULL_
Designed and created SAS datasets from various sources like Excel datasheets, flat files, Oracle.
Worked on various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS Etc. to develop solutions.
Environment: SAS/ODS, SAS9.2, SAS Grid, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/Access, SAS/ Connect, SAS/Stat, Teradata, MS Excel, MS Access
Modelytics, Bangalore, India Mar 2013 - Dec 2014
Role: SAS Programmer
Modelytics is a strategy and analytical firm with client base comprising some of the leading financial services and banking firms Responsibilities. Modelytics helps it's clients win by developing and implementing Information Based Customer Value Management (IBCVM) strategies. Modelytics has proven capability in providing innovative strategies and analytical solutions across diverse verticals.
Responsibilities:
Provided ad-hoc data analysis and reporting support for Sales and Marketing using Base SAS
Developed SAS/MACRO to standardize the report and chart generation for re-use with
PROC TABULATE, PROC REPORT, PROC APPEND PROC GPLOT, and PROC
GCHART etc
Wrote Macros in SAS to develop a concise code for data cleaning and reporting
Developed SAS macros to create tables, graphs and listings
Created SAS customized files in HTML, PDF, RTF and Flat files using the DATA _NULL_ technique
Created reports with multiple graphs and chart displays into a single Excel spreadsheet
Created individual RTF files for summarizing the results and also to document the metadata
Performed data manipulations on data stored in Oracle using SQL Assistant and PROC
SQL
Used SAS/ODS for effectively deliver the outputs in HTML and PDF formats
Imported SAS data from Excel and Txt files to SAS Datasets
Environment: SAS V6.12 (Base, Macros, SQL), SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/STAT, Excel, Access, Oracle 8i, PL/SQL, UNIX, Windows NT
Novartis, Hyderabad Nov 2011 – Mar 2013
Role: SAS Programmer
Novartis International AG is a Swiss multinational pharmaceutical company based in Basel, Switzerland. It is one of the largest pharmaceutical companies by both market cap and sales.
Responsibilities:
Provided ad-hoc data analysis and reporting support for Sales and Marketing using Base SAS
Developed SAS/MACRO to standardize the report and chart generation for re-use with
PROC TABULATE, PROC REPORT, PROC APPEND PROC GPLOT, and PROC
GCHART etc.
Wrote Macros in SAS to develop a concise code for data cleaning and reporting
Developed SAS macros to create tables, graphs and listings
Created SAS customized files in HTML, PDF, RTF and Flat files using the DATA _NULL_ technique
Created reports with multiple graphs and chart displays into a single Excel spreadsheet
Created individual RTF files for summarizing the results and also to document the metadata
Performed data manipulations on data stored in Oracle using SQL Assistant and PROC
SQL
Used SAS/ODS for effectively deliver the outputs in HTML and PDF formats
Imported SAS data from Excel and Txt files to SAS Datasets
Environment: SAS V6.12 (Base, Macros, SQL), SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/STAT, Excel, Access, Oracle 8i, PL/SQL, UNIX, Windows NT
Global Analytics Inc, Chennai, India May 2008 – Nov 2011
Role: SAS Programmer
Global Analytics, is an analytic firm which uses the power of analytics to fundamentally change the way people do business with the under-banked. It leverage superior analytics, strategic thinking & top-tier talent and has a proven ability to create innovative, affordable credit products that serve customers respectfully & responsibly.
Worked on the application called Disclosure. The main purpose of this application was to disclose the documents to their lenders and notifying them automatically via emails whenever there are any changes to their documents or whenever they are posted on the web. Also worked on Data mining, reporting, and application development (Windows) utilizing Microsoft Access, VBA, SQL with emphasis in Fraud Prevention
Responsibilities:
Developed programs using the Libname statement & SAS Views to extract & report error statistics
Created Automated Turnaround documents for use as re-input to source
Used Microsoft Access and Excel to provide output analysis data
Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information
Implemented research forecasting models into production by using Base SAS, SAS Macros, PROC SQL and many other SAS tools
Assisted architecture team in moving layers of the EDW from Oracle to Teradata for using SAS In Database technology
Wrote Teradata code / SQL to enable the ETL processes to meet demanding business requirements, including BTEQs, Fast Loads, Multi Loads, and Fast Exports
Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL
Performed the automated data driven testing using WinRunner
Performed functional, GUI, and Security testing using different checkpoints with the WinRunner scripts.
Responded to ad hoc data requests from internal auditors and consumers
Analyzed requests generated data files using SAS and SQLPLUS etc.
Performed back-end testing to verify the flow of data from the database to the front end
Used SAS Macros to produce drill down capability for the reports
Performed detail analytics while producing financial reports so that the financial data is checked and are accurate.
Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets
Environment: SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, TOAD, Oracle, Windows NT Server, UNIX, MS SQL Server, SQLPLUS, Java.
EDUCATION:
Bachelors of Technology in JNTU, Hyderabad, INDIA.
Contact this candidate