Mounica Kavuri

· 2.5 years of experience as SAS Programmer.

· Coordinate with technical team to determine client needs, project feasibility and respond to inquiries.

· Reviewing the document work and functional requirements and creating business process workflow.

· I have involved in Manipulate the data using SAS statements, functions and Procedures.

· Worked on SAS technical points like IF-THEN statements, SQL Case and WHEN statements, filtered the data using WHERE statements and options using both SAS data step and SAS SQL, data step options KEEP, DROP statements and Functions, Retain statement, FIRST. And LAST. Variables efficiently.

· Worked on manipulate the data using Character, Numerical, Mathematical and Date functions.

· Analyzed the data using Statistical Procedures like PROC SUMMARY, PROC MEANS and PROC FREQUENCY, PROC Datasets, PROC COPY

· Generated the Reports using PROC FORMATS, PROC REPORT, PROC TABULATE , PROC TRANSPOSE and PROC GCHART

· Worked on combining the Tables using MERGE, SET, JOIN and UNION.

· Able to write the programs efficiently using SAS SQL queries.

· Can write SQL queries for the Table creation, adding, deleting and updating rows and filtering, manipulating the data using CASE statements.

· Can write programs using SAS SQL statements, functions, combining the tables using JOINS and UNIONS.

· Can create Macro Variables using various methods like Call SYMPUT, %LET, INTO clause, Positional and Key parameters.

· Can convert data step variables to Macro variables and vice versa.

· I can write the programs on how to store the Macros & Autocall Macros.

· Can Handle the Macro code using debugging techniques like Macro options MPRINT, MLOGIC and SYMBOLGEN.

· Can write Macros, using Macro statements and Macro Functions.

· I know how to use Libname Filename, Infile, File, Input, Put statements.

· I can write programs to count the number of Observations of dataset using various methods.

· I can write the programs to append the datasets using different methods.

· I can debug the SAS code using SAS Debugging techniques.

· Fetch the data from Oracle and other data bases using Pass through facility and Libname statements.

· Ability to work both as an individual and as part of a team.