Description
PROFILE * Certified SAS Programmer with Base SAS certification & experience on Advance SAS (SQL) * Creation of new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update and conditional statements. * Extracting external data in the form of CSV files and developing reports as per client mock ups. * Performing Merging, Appending of datasets and creating new variable by using Macros. * Extensive programming with proc SQL, PROC report, PROC tabulate, PROC means, PROC freq, PROC formats. * Created listings, tables and Reports in RTF, PDF, HTML formats by using SAS ODS. * Use SAS functions to manipulate data types * Process data using DO LOOPS and using one-dimensional SAS arrays & Error Handling * Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting. * Controlling i/o processing and memory * Managing indexes, array, multidimensional array and hash objects in data step * Competent and result oriented professional offering 3.8 years of experience in Software/Product Development Product Customization & Enhancement, Requirement Gathering, Bug Fixing &Reporting/Tracking, with expertise in devising measures for POC & Technical Implementation currently spearheading as Software Engineer with Wipro Technologies. * Possess keen business/technical acumen in analyzing & understanding business requirements, Technical Proof of Concept and implementation of POCs in various product development life cycles. * Good knowledge of Mongo in core Java Development and can effectively use of Hibernate, Spring, java script & xml. * Rich product development experience with various enhancement & customization to the base product sufficing multi flavored customer need & scaling up to their business process. * Recognized as a hands-on, proactive individual who can rapidly identify technical and product related problems, formulate tactical plans, initiate change and implement effective strategies in challenging environments * A fast pace technical associate adopting to rich range of technology usage & implementation SAS CERTIFICATION from: SAS International SAS TRAINING From: Ultramax Infonet Technologies Pvt Ltd, SAS Accredited Training Partner Address: ITI Road, Parihar chowk, Above OBC Bank, Pune, Maharashtra 411007, India, Phone: +91 20 4107 1111, http://www.ultramaxit.com/ BASE SAS: * Creation of new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update and conditional statements. * Extracting external data in the form of CSV files and developing reports as per client mock ups using data _null_. * Performing Merging, Appending, Concatenations to combine datasets and creating new variable by using Macros. * Extensive programming with proc SQL, PROC report, PROC tabulate, PROC means, PROC freq, PROC formats. * Created listings, tables and Reports in RTF, PDF, HTML formats by using SAS ODS. * Use SAS functions to manipulate character data, numeric data, and SAS date values and conversions of character to numeric and vice versa. * Process data using DO LOOPS and using one-dimensional SAS arrays. * Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting. * Handling Errors i.e. Identify and resolve programming logic errors, recognize and correct syntax errors and examine and resolve data errors. BASE SAS: PROC SQL * Extensive programming with PROC SQL basic queries * Generating results using SQL joins, sub queries, set operators * Generating tables and views. * Used Dictionary Table and view to obtain information about SAS files. BASE SAS: MACROS * Creating and processing macro variables and Creating and using macro programs * Performing Merging, Appending, Concatenations to combine datasets and creating new variable by using Macros. * Creating Macros as per the Business Requirement and Storing macro programs. ADVANCE SAS * Controlling i/o processing and memory * Managing indexes, array, multidimensional array and hash objects in data step.