Data Microsoft Office

Supraja Reddy

Ph.:484-***-****

Email: **********@*****.***

Professional Summary

Over 6+ years of experience working in various domains as SAS programmer and Business Intelligence applications.

Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.

Proficient in using SAS both in Windows, UNIX and Linux Environments.

Extensive knowledge in data management by using SAS DATA step statements including SET, MERGE, Formats, Informants and functions.

Proficient in working with multiple databases like Oracle Server, MS SQL Server and MS Access.

Capable in using SAS to import/export data to external file formats like CSV, Excel and XML files.

Superior skills in analyzing and coordinating data, generating tables, listings, graphs and reports.

Conceptual understanding of various business requirements in financial and met needs by having firm grip over various procedures like proc SQL, proc report, proc tabulate, proc plot, proc chart, proc format, proc import, proc export, proc print, proc sort, proc compare, proc append, proc connect.

Extensive experience in processing large datasets with millions of records for data transformation including data cleaning, data scrubbing, data profiling and applying business logic rules to incoming data.

Experience in producing HTML, RTF and PDF formatted files using SAS/ODS.

Extensive knowledge is SQL server Analysis services (SSAS).

Extensively used SAS/MACRO for creating macro variables and macro programs to modify existing SAS program for ease of modification while maintaining consistency of results.

SAS products installation and support of Base SAS, SAS Enterprise Guide, SAS Enterprise Miner, add in Microsoft office, Text Miner, SAS Data Integration Studio, SAS Information map studio, SAS Management Console, SAS Visual Analytics, SAS Web Report Studio, Office Analytics, SAS Forecast Studio, SAS OLAP Cube studio as well as other SAS tools may be evaluated.

Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Enterprise Guide, SAS/Enterprise Miner, SAS/Share, SAS Enterprise BI Server and SAS Management Console.

Identifying potential issues, working with vendors and provide research and solution recommendations proactively.

Using SAS Enterprise Guide build advanced querying, calculating computed columns, using filter, sorting, manipulate and prepare data for Reporting, Graphing, Summarization, statistical analysis and finally generates summarization SAS datasets.

Experienced in creating Data Mart using different transformation in Data Integration Studio.

DI jobs used to extract, transform and load the physical data structures, scheduled jobs and job flows.

Imported summarization SAS datasets from SAS Management Console to SAS Information Map Studio.

Have strong working knowledge on SAS Data integration studio in extracting data.

Generated various graphs using SAS/GRAPH procedures like PROC GPLOT and PROC GCHART.

Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint and MS Excel.

Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.

Excellent programming skills in SQL and understanding of data definition principles, joining data sets, data manipulation and subsetting using PROC SQL.

Skills

SAS Tools: Base SAS 9.4/9.3/9.2/9, SAS/Stat, SAS Macros, SAS/SQL, SAS/ETL, SAS Graph, SAS Enterprise Guide, SAS/DI, SAS/EM, SAS/TM, SAS/SMC, SAS/FS, SAS/WRS, SAS/OLAP, SAS/AMO

Reporting Tools: Base SAS versions 9.3/9.2/9, SAS Enterprise Guide, SAS Enterprise Miner, SAS Graph, MS-Excel, SAS BI Platform, SAS OLAP Cube Studio, SAS Web Report Studio, MS-VISIO, and MS PowerPoint

RDBMS: SAS SQL, DB2, Oracle 7x/8i/9i/10g/11g, Teradata, MS-Access, Microsoft SQL Server, Netezza, Green Plum, SAP Hana and MySQL.

Languages: SAS, SQL, C, C++, C#, Java, Visual Basic, Visual C++, PHP

Operating System: Windows 95/98/XP/Vista/Win 7/Win 8/Win 10, UNIX, MAC OS, Linux and DOS

Batch Server: UNIX, Putty, SSH, and SAS scripting

Web Server: HTML, JSP, Linux, Apache Server

Office Tools: Word, Excel, PowerPoint, MS ACCESS, MS Visio

Education

Bachelor of Technology from Jawaharlal Nehru Technology University, Hyderabad, India

Professional Experience

New York Times, NY Aug 2016 to till date

SAS Programmer

Responsibilities:

Analyzed present data warehouse tables data volume, memory space, relationship, columns functionality, and metadata of DW.

Extracted of data from fact and dimension tables and created SAS repository.

Worked with marketing and business analyst group to support marketing and financial decision.

Installation and implementation of SAS components to fulfill project report requirements.

Excellent data exporting job in excel and flat files in multiple operating platform by using interacting SAS and Enterprise Guide SAS.

Created and maintained of automatic scheduled jobs using automatic macro variables.

Completed SAS coding using various date and time to perform daily, weekly, monthly and quarterly jobs.

Used data cleaning techniques such as proc freq, proc print, _null_, proc means, proc tabulate, procunivariate, nodupkey, procsql, proc compare and created macro to check data.

Extensive used of SQL PLUS to DML and data extraction job.

Developed ETL process and SAS independent repository as source of data transaction.

Environment: Base SAS 9.1, Unix SAS, Enterprise Guide SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/SQL, SAS/ODS, SAS/Macros, SAS/AF, SAS WRS, EG, SAS/ETL, SAS/MDDB, UNIX SAS, PC SAS, Oracle 9i, RDBMS, OLAP, MS Excel, and MS Access.

S & P Global, NY May 2015 to July 2016

SAS Programmer

Responsibilities:

Analyzed present data warehouse tables data volume, memory space, relationship, columns functionality, and metadata of DW.

Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools- SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.

Responsible for locating appropriate databases for projects and performing relevant analysis.

Processed data collection to ensure proper quality of data.

Maintained the daily error log for cleaning the data.

Developed SAS macros for data cleaning, reporting and to support routing processing.

Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.

Presented numerical information in various formats. Created SAS Customized reports using the Data _null_technique.

Generated graphs using SAS/GRAPH and the SAS Graphics Editor. Used Proc Report to generate reports.

Prolifically generated SQL queries for the reports.

Successfully identified problems with the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.

Environment: SAS 9.3, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, UNIX, Windows.

Credit Suisse, New York, NY Mar 2014 to Apr 2015

SASProgrammer/ Developer

Responsibilities:

Extracted raw data and created SAS data sets that are required for the project analysis.

Involved in development and enhancements of SAS Programs.

Analyzed data using SAS/Stat procedures.

Used Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access).

Created reports using SAS/ODS.

Used LIBNAME and SQL PASSTHRU facility to read data from other sources.

Provided all data analysis, ad-hoc and custom reporting of customer data, involving extracting data from an Oracle database, xml files, csv files data used as input for SAS programs to create Excel, spreadsheets, Access databases, and hard copy reports.

Involved in creation of complex reports using stored procedures.

Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.

Creating various transformation procedures by using SAS 9.1, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide.

Create SAS metadata objects in a SAS metadata repository and Implement into data integration studio job for all MDA related requirements.

Integrated all SAS components, SAS graphs and programs onto one web application software for end users by using SAS IntraNet, SAS information map studio and SAS Information Delivery Portal.

Created OLAP Views, Maps and OLAP cubes for different modules.

Developing Reports and Customizing Portal using SAS OLAP Cube Studio, SAS Information Map Studio, SAS Enterprise Guide, SAS Web Report Studio and SAS Information Portal.

Environment: SAS/BASE, SAS EBI/DI Studio, SAS Web Report Studio, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, Windows, MS Office.

CAREERNET TECHNOLOGIES PVT LTD, INDIA Dec 2009 to Nov 2012

SAS Programmer

Responsibilities:

Responsible for identifying, collecting, analyzing and maintaining data to evaluate issues that support business decisions using SQL and SAS.

Analyzed data sets and generated SAS output using PROC FREQ, PROC COMPARE, PROC CONTENTS, PROC SORT, PROC SQL and PROC REPORT etc.

Creating and saving the Macro programming into Macro library and maintaining Macro library to be used by all user in the team.

Cleaning data files to accommodate missing data, creating variables, use of aggregating commands and various techniques of file merges to create results.

Performing analysis on survey responses and producing multi-dimensional reports using SAS.

Documented policies and procedures required for supporting system enhancements.

Work with Enterprise Miner for marketing campaigns doing statistical analysis.

Using SAS/SQL for extract, transfer and load (ETL) methodology for the data used to deliver the programs direct mail and email contacts.

Data processing and validations were done extensively on the SAS datasets using edit check programs.

Quality control and assurance including running datasets/files through programs.

Environment: BASE SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS/ENTERPRISE MINER, UNIX and WINDOWS.

Contact this candidate