| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Deepthi.P EMAIL AVAILABLE PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY Around 8+ years of experience in analysis, design, development, testing, validating the data. Extensive hands-on experience in programming using BASE SAS, SAS/MACROS, SAS/CONNECT, SAS/REPORT, SAS/ ODS in Windows and UNIX environments. Expertise in Data Import/Export via SAS Data Steps, using SAS Proc Import, SAS/ACCESS, SAS/SQL and SAS/ODS. Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and PROC SQL Pass through facility Proficient in Data Manipulations using SAS data step procedures such as SAS FORMATS/INFORMATS, MERGE, PROC APPEND, PROC SORT, AND PROC TRANSPOSE. Proficient in creating reports in HTML, PDF and RTF formats using SAS/ODS facility. Good understanding of healthcare claims processing (Eligibility, Claims & Provider). Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel. Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for process. Self-organized in all aspects of work such as keeping and recording regular activities by commenting codes and documenting while doing analysis. Self-Starter, Self-motivated, good team player, analytical and problem solving skills with ability to interact with individuals at all levels, and meeting deadlines. Conflict resolution, strong presentation skills, and ability to adapt in a new environment.Technical SkillsSAS ComponentsSAS v8.2/9/9.2,9.3, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/CONNECT, SAS/SQL, SAS/ODS, SAS EG, PythonSAS ProceduresProc Means, Proc Transpose, Proc Format, Proc Contents, Proc Summary, Proc Sort, ProcFreq, Proc Print, Proc Chart, Proc Copy, Proc SQLLanguagesSAS, SQL, PL/SQL, HTML, XMLRDBMSOracle, MS Access, DB2, SQL Server, Teradata, BigdataOffice ToolsMS office 97/2000/2003, Word, Excel and PowerPointClient:- Highmark
Senior Decision Support AnalystResponsibilities: Using SAS/Base, SAS/SQL procedures and provided programming expertise for employees and sponsors as needed.
Interact with system owners and SMEs (Subject Matter Experts) to understand the various data points used between systems to create reports by utilizing data residing in Teradata, DB2 and SAS datasets. Using PROC SQL procedures to replace complex merge statements. Using pre-existing Macros wherever needed to decrease the code length.
Debugged macros and regular programs to ensure cleanliness of log.
Supporting different modeling teams with their data needs according to their business requirement. Created reusable templates to reduce the manual efforts & automate the process to reduce the TAT. Developed the code to check the data quality.
Prepare formatted HTML, XLS and CSV reports by using SAS ODS technique.
Responsible for modifying the existing SAS programs to change the functionality according to new business requirements.
Improving the control and interactions for users on the Regression Engine a set of applications that shows the impacts of different variables on the results of marketing campaigns using Tableau, SAS EG, SAS macros, SAS prompts via EG and SAS procs such as LOGISTIC, REG and GLMSELECT and prompts from SAS EG. Developed and improved the efficiency of programs by using advanced SAS techniques and macros. Efficient in modifying the existing SAS programs and creating new programs using SAS macros to improve ease and automating & optimizing the process for effective results. Involved in scheduling of jobs using TWS. Maintained and enhanced existing SAS programs for deriving datasets, and for generating data listings, summary tabulation counts, categorical tables & figures.
Cross-validated SAS programs authored by other SAS programmers as a part of QA (quality assurance).
Act as a technical/domain mentor for junior team members
Build a healthy relationship with project stakeholders
Working on a project to automate SAS applications relating to calculation of earnings at risk. Provided design, development, implementation, documentation, validation and testing support for the business process, system requirements and functionalities needed. Experienced in enhancing and maintaining a complex Python framework which automates a complex SAS-based application workflow.Company:- XGIT
Client:- Wellsfargo , NCSAS DeveloperResponsibilities: Using SAS/Base, SAS/SQL procedures and provided programming expertise for employees and sponsors as needed.
Using PROC SQL procedures to replace complex merge statements. Using pre-existing Macros wherever needed to decrease the code length.
Debugged macros and regular programs to ensure cleanliness of log.
Using basic set, merge, update statements to create new datasets from existing datasets to meet requirements.
Responsible to generate various financial reports for various US banks. Supporting different modeling teams with their data needs according to their business requirement. Performed data analysis, statistical analysis, generated reports, listings using SAS Design SQL query to select, create, append, and update database tables and views.
Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.
Working with cross functional teams for developing applications for the business from End to End. Involved in migration process from PC SAS to SAS grid in my team. Efficient in modifying the existing SAS programs and creating new programs using SAS macros to improve ease and automating & optimizing the process for effective results. Involved in scheduling of jobs using TWS. Maintained and enhanced existing SAS programs for deriving datasets, and for generating data listings, summary tabulation counts, categorical tables & figures.
Cross-validated SAS programs authored by other SAS programmers as a part of QA (quality assurance).
Optum Global Solutions (UHG), Hyderabad, IndiaSAS Programmer/AnalystResponsibilities: Using SAS/Base, SAS/SQL procedures and provided programming expertise for employees and sponsors as needed.
Using SQL procedures to replace complex merge statements. Using pre-existing Macros wherever needed to decrease the code length.
Debugged macros and regular programs to ensure cleanliness of log.
Assisting data management team in preparing case report forms for clinical study.
Using basic set, merge, update statements to create new datasets from existing datasets to meet requirements.
Using several numeric and character functions in SAS programs.
Performed data analysis, statistical analysis, generated reports, listings using SAS
Design SQL query to select, create, append, and update database tables and views.
Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.
Perform migration process using export and import wizard to migrate libraries, tables, jobs, reports, users, users groups, roles and access control templates. Strong understanding of ETL process.
Involved in migration process from PC SAS to SAS grid in my team. Involved in scheduling of jobs using TWS. Maintained and enhanced existing SAS programs for deriving datasets, and for generating data listings, summary tabulation counts, categorical tables & figures.
Cross-validated SAS programs authored by other SAS programmers as a part of QA (quality assurance).
Working experience on methodology.Environment: SAS 9.x/BASE, SAS/MACROS, SAS/EG, SAS/SQL, SAS/ACCESS, SAS/Connect, MS Excel, MS Access, HTML, XMLQue labs, Hyderabad India
SAS DeveloperResponsibilities Modified data using SAS/BASE and Macros. Employed techniques like sorting and merging on the raw data sets and coded them using Proc SQL and SAS Macro facility to get the required output Prepared graphs using the modified data for business analysis. Creation of Data Sets on the Remote Server. Used shell programming to run weekly and monthly reports Used SAS/ACCESS to gather data from RDBMS like DB2 Coordinating the production of monthly, quarterly, and annual performance reports for senior management. Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used time to time and created tables, graphs and listing reportsKarthik Media, Hyderabad India
Jr. SAS DeveloperResponsibilities Importing/Extracting data from various sources like Flat files, Date warehouse, Excel and Access files. Performing UAT (User Acceptance test) on the data uploaded on DWH by creating various summary datasets through SQL queries. Cleaning, shaping and changing formats of the data according to the Client/Analyst requirement. Automated the process by using SAS Macro s, Batch file Processing and Job scheduling.
Pulling data from data warehouse using Pass-Through techniques and Libname statements and pushing the data into data warehouse. Generating Reports PDF, HTML and XLS reports using SAS-ODS according to the requirement. Pre/Post validating the data and generating the summary reports in Excel for the same if needed for further analysis. Creating Simple and composite indexes for ease of data extraction/filtering for client. Extensively working with Onshore and Offshore teams to generate the output files for further analysis according to their requirement. Used different SAS procedures like Proc SQL, Proc Sort, Proc Freq, Proc Append, and Proc Compare, Proc Import/Export, Proc Contents, Proc Datasets, Proc Format etc. Extensively utilized SAS/SQL and SAS/MACRO. Perform transformations like Merge, Sort and Update to get the data in required format. Develop reports and custom analysis using SAS, SQL, Excel and other tools based on specifications provided by the client or the client analytical lead. Used various procedures like SORT, SQL, MEANS, TRANSPOSE and CONTENTS to generate various data tables, patient data listings and reports according to Statistical analysis plan. Created SAS datasets from various sources like Excel datasheets, flat files.EDUCATIONBachelor of Information Technology, JNT University 2009 -2013.Key Accomplishments during Professional Tenure Fully automated Complex Restatement process by developing SAS programmes and interfacing it with Access based tool to run the process for any type of client to produce the access-based files for projecting the revenue. Automated daily data-loading process into SAS datasets from database (ETL process). Applied Six Sigma and Lean Concepts in the Development & Production. Lean ACE & GB (Green Belt) Trained. As a SAS developer, I delivered high quality work on time, efficiently worked on ad-hoc requests and received VOC rating of 8.9 out of 10.
Trained and mentored new candidates in the team.
|
