We provide IT Staff Augmentation Services!

Sas Data Analyst/developer Resume

5.00 Rating

Zebulon, NC

SUMMARY:

  • Over 10 years of experience as a SAS programmer in statistical analysis and clinical research with strong emphasis on design, implementation and development of various projects in Financial,Pharmaceutical companies and Clinical Research Organizations
  • Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ETL, SAS/ACCESS, SAS/CONNECT, SAS/ENTERPRISE GUIDE, SAS/DIS, SAS/MC, SAS BI, SPSS, DATASTAGE/SAS.
  • Solid understanding of statistical concepts and proficient use of various statistical and stored procedures like proc sql, proc report, proc freq, proc means, proc tabulate, proc transpose, proc plot, proc chart, proc contents, proc dataset, proc format, proc import, proc export, proc print, proc summary,macros, proc sort, drop, keep, retain, date manipulations, formats, in formats and SAS/STAT procedures like proc anova,t - test.
  • Strong knowledge of clinical trial data and good experience in designing, developing and analyzing the data, debugging the errors, reviewing the SAS code
  • Extensive experience in generating reports and creating summaries according to the specifications of Statistical Analysis Plan (SAP) and Standard Operating Procedures (SOP)
  • Worked on data quality rules and ensures the proper implementation of data quality during the creation and modification of data, according to Enterprise Data and Analytics data quality standards, guidelines, metrics and quality-expectations.
  • Followed rules to evaluate data quality and creates effective test plans, according to Enterprise Data and Analytics data quality standards.
  • Ensured accuracy, completeness, integrity, consistency, uniqueness, and timeliness of data.
  • Executed Enterprise Data and Analytics data quality tests/assessments and data cleansing activities.
  • Monitoring compliance of data flows against Enterprise Data and Analytics data quality standards.
  • Proficient in creating tables using Proc Report, Proc means, Proc freq,Proc surveyselect, producing and customizing Graphs using Proc Gplot
  • Part of a team for FDA e-submissions. Created Deliverables like annotated CRF and .XPT files
  • Generated various SAS reports according to the ICD 9 and 21 CFR-Part11.
  • Knowledge of frequency and duplicate analysis, cross dataset dependencies, orphan child data' rows, redundancy analysis;data extraction techniques and applications.
  • Knowledge of and some experience applying statistical/mathematical decisioning and/or testing methodologies.
  • Proven ability to support multiple projects under deadlines often with competing priorities and complexities.
  • Experience working with large ‘Big Data’ datasets. Worked with metadata,master data.
  • Quantitative analysis experience. Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
  • Experience in producing safety and efficacy reports-Integrated Summaries of Safety and efficacy
  • Experience in creating and validating SDTM and ADaM datasets and in producing TLG’s and summaries based on company’s and the client’s requirements
  • Experience working with different coding dictionaries like ICD 9, MedDRA and WHODrug
  • Created PDF, RTF, HTML files using SAS/ODS.Designed and developed datasets as per the CDISC standards
  • Good in handling multiple projects at a time and large databases to perform complex data modifications
  • Excellent Collaboration and Communication skills (written and verbal)
  • Good technical and Analytical Skills and ability to work in a team as well as independently

TECHNICAL COMPETENCIES:

SAS Tools: SAS v.9.1, v9.2, v.9.1.3 SAS/EG 7.1(Base, Macro, ODS, ACCESS, CONNECT, GRAPH, STAT),SAS-DI(Data Integration Studio) 4.9,SAS MC (Management Console)9.4,DATASTAGE/SAS,TIBCO-Spotfire,MDCT.

Operating Systems: Windows XP/NT/2008, UNIX

Languages: SQL, PL/SQL, C, C++, SAS

Databases: Oracle 9i/10g, mySQL,DB2,MS ACESS

Microsoft: Access, Word, Excel, Outlook, Power Point, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Zebulon, NC

SAS Data Analyst/Developer

Responsibilities:

  • Data analysis to analyze large data sets using statistical techniques to identify trends or patterns
  • Build automated reports/dashboards to share results with the team on periodic basis (daily weekly, monthly, quarterly and annually)
  • Help build and maintain key performance indicators (for operational and financial dashboards)
  • Develop and implement data collection systems/processes that optimize statistical efficiency and data quality
  • Combine, filter and reconcile data from multiple sources
  • Assist in building and maintaining models, analyses and reports for our investors
  • Assist in database administration and design wherever applicable. Provide maintenance support for system as needed.
  • Work closely with business stakeholders to prioritize, plan and implement their information and analytics needs
  • Developing tools by programming that aid in accurate and efficient data.
  • Creating SAS programs and performed data validation on raw data sets and created data set for analysis.
  • Codes, tests, and debugs programs; maintains and documents programs.
  • Work assignments include the complex phases of applications systems analysis and programming activities, and require some instruction in other phases as per the SOP.
  • Diagnose and resolve program and system technical problems.
  • Served as a Developer/Analyst on special projects Accelerated Stability Modelling Dashboard with SAS as analytical engine for Spotfire Statistical Server v7.0
  • Confer with users to define and understand business needs and identify technical solutions.
  • Begins or continues to develop comprehensive knowledge of the application and business system processes in order to participate in system evolution/replacement planning and implementation.
  • Provides impact analysis on application change requests or modifications.
  • Assisting in change management according to the project change management plan in a GxP environment..
  • Participate in opportunities to further develop technical and communication skills.
  • For critical applications, provided on call or after hour support .
  • Provide and mentoring for less experience team members.

Environment: Windows 2013, SAS 8.2, SAS9.3, SAS 9.4, SAS/ODS, SAS/EG, BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ACCESS,SAS DI,SAS MC, MS Excel,MS Access,MS Visio,Beyond Compare,TIBCO-SpotFire,MiniTab,Ultra Edit,Toad 12.7,Snagit12,XMLEditor, Datapost,PPA2,“WinSCP” (Windows Secure CoPy), Putty,database Oracle, PL/SQL 8.0.4.

Confidential, San Antonio, TX

SAS Analyst/Developer

Responsibilities:

  • Creating SAS programs and performed data validation on raw data sets and created data set for analysis.
  • Creating test scenarios to find errors and confirm programs meet specifications as per Bank Governance Guidelines.
  • Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
  • Capable of utilizing data management techniques like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step.
  • Performed PROC SQL joins and worked with PROC SQL set operators to combine tables .
  • Worked with SAS on Unix and SAS EG (Enterprise Guide) with Oracle / DB2 and Host files using Proc SQL Pass-Through.
  • Experience in using various MS office tools for analyzing, arranging and presenting data.
  • Responsible for accessing and managing data and for performing complex queries and analysis,data mining,.
  • Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (output Delivery System).
  • Worked using SAS Macros and SAS procedures in Banking for credit card report generation and upgradation.
  • Working experience in coding using SQL, Procedures/Functions.
  • Rewrite SAS codes to fine-tune and automate various SAS processes
  • Strong communication skills and ability to work in groups as well as independently
  • Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
  • Worked on data quality rules and ensured the proper implementation of data quality during the creation and modification of data, according to Enterprise Data and Analytics data quality standards, guidelines, metrics and quality-expectations.
  • Ensured accuracy, completeness, integrity, consistency, uniqueness, and timeliness of data.
  • Executed Enterprise Data and Analytics data quality tests/assessments and data cleansing activities.
  • Participated in the discussions and worked on tasks assigned from cross-functional teams.-FSB(Federal Savings Bank).,Bank Data Warehouse.

Environment: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS, Windows XP.

Confidential, Princeton, NJ

SAS Developer

Responsibilities:

  • Formulate and define system scope and objectives for assigned projects.
  • Gathering requirements and documentation, unit test case development, and defining and documenting the integration testing of new applications.
  • Implement complex data file manipulation involving matching, merging, cleaning and modifying operational testing program data (primarily using SAS)
  • Assist in setting and maintaining Incoming and Outgoing Data Quality Standards.
  • Ensure that statistical analysis requirements are met for assigned projects.
  • Preparation of clear detailed specifications from which programs will be written by team developers.
  • Consultation with Confidential Systems and Technology staff in the modification, design and implementation of systems or projects using multiple processing techniques and system technologies, database and structured design techniques.
  • Analyze data; Work with Confidential business, and technology areas, as well as implement data and manipulation technologies and transition the support of the systems to a production environment.
  • Develop and evaluate unit testing plans to ensure design requirements are met.
  • Provide technical knowledge of all phases of applications systems analysis and programming and have a good understanding of the business or function for which the applications are designed.
  • Responsible for contributing to the design and development of technologies for executing large and complex data analysis projects.
  • Design and check complex data file manipulation rules involving matching, merging, cleaning and modifying operational testing program data.

Environment: Windows 2000, SAS 9.1, SAS9.3, SAS/ODS, SAS/SQL, MS Excel, database Oracle, SAS/ACCESS, JavaScript, SAS/EG, BASE SAS, SAS/ MACRO, SAS/ SQL.

Confidential, NYC, NY

SAS Programmer

Responsibilities:

  • Responsible for handling two projects namely Update the Survey Module and Creation of new module.
  • Generate a new dataset by modifying previous SAS code versions
  • Updated current data to include additional variables based on the user requirements
  • Incorporated the new data into the EQ module by modifying the metadata base (Access),Teradata and updating HTML/JavaScript code
  • Assisted in data checks of the new data and responsible for making the final revised module live
  • Analyses of requirements and datasets that produce data tables and graphs by demographics and bivariate.
  • Written SAS code for each level of the module, including embedded HTML and JavaScript to build webpages and working within the SAS eBI system.
  • Created a new Access database containing the metadata for the module
  • Worked closely with the BES team to design a working internal site, providing a testing environment and demonstrating the site as developed.
  • Completed the documentation and created the development process for the above project modules

Environment: Windows 2000, SAS 9.1, SAS9.3, SAS/ODS, SAS/SQL, MS Excel, database Oracle, SAS/ACCESS, JavaScript, SAS/EG, BASE SAS, SAS/ MACRO, SAS/ SQL.

Confidential, NYC, NY

SAS Programmer

Responsibilities:

  • Understanding the Business and its Requirements
  • Gathering the requirements from user
  • Modified data using SAS/BASE and Macros
  • Modified data for business analysis
  • Creation of Data Sets on the Remote server
  • Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
  • Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
  • Creating SAS dataset from tables in Database using SAS/Access. Retrieved the MEMBERS data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures
  • Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs
  • Created reports for online and batch applications for various servers
  • Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs
  • Retrieved, monitored and analyzed MEMBERS DATA using MHS
  • Run reporting programs and download the results into EXCEL and build pivot tables
  • Moved data set across platforms (from PC and Mainframe MHS)
  • Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements
  • Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros
  • Attended project team meetings, worked with, Data Managers, Business Users and offshore team as appropriate
  • Involved in extracting, analyzing data from the data-warehouse using SAS.
  • Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT.
  • Used ULTRA EDIT and VSS features to connect to multiple databases for comparing views and checking syntax errors for performance tuning and quality control
  • Worked with Financial departments to develop required applications for performing complicated analysis
  • Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for business user, preplanning and doing ad hoc joining of multiple Oracle views.
  • Created and maintained the project documentation like functional and technical specifications
  • Documented the SAS project report notice, which included the indications of purpose of the requirement, from where it is been read and written to, what kind of process it is, how the process runs and finally the installation instruction for the upgraded data dictionaries and the new or modified program
  • Worked by abiding to the HIPAA Privacy regulations required by the health care providers and organizations, as well as their business associates.
  • Created test plans for QA validation purposes.
  • Coordinated with the offshore team.

Environment: Windows 2000, SAS 9.1,SAS9.3, SAS/ODS, SAS/SQL, MS Excel, database Oracle, IBM ASO/400 and IBM compatibles, BASE SAS, SAS/ MACRO, SAS/ SQL.

Confidential, Princeton, New Jersey

SAS Programmer Analyst

Responsibilities:

  • Worked on in-house Survey project handling the responsibilities of SAS programming and QA analysis/testing
  • Performed data and QA analysis, tested/completed the deliverables and presented the analyzed/output data based on the requirements understanding of business process, the data and the user.
  • Transformed the statistical data in various formats (excel, access) into SAS data sheets. Provided statistical programming expertise in the production of QA analyses, tabulations, reports and listings.
  • Derived from specifications of survey regarding editing, coding, reports, debugging etc
  • Accompanied in Phase I various consulting sessions and provided support in statistical analysis including choice of experiment design, management of data, statistical procedures for analyzing experiments, interpretation of the results, statistical modeling and statistical computing.
  • Developed programmes for cleaning, transforming and modifying the data daily.
  • Updated documentation during the life cycle of QA testing like design processes, business specs, comments in the code, record the issues/problems and record the inputs/outputs
  • Actively participated in internal QA peer reviews and managing the project folders on project shared drive and SharePoint site
  • Used PROC compare to compare the data before and after editing
  • Developed various SAS reports for Survey project and involved in code reviews for all the developed reports

Environment: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS/ACCESS, SAS/STAT, Windows XP, KEDIT.

Confidential, COLOMBUS, OHIO

SAS Programmer

Responsibilities:

  • Worked on Agile methodology
  • Performed data analysis, completed the projects and presented the analyzed data. Transformed clinical data in various formats (excel, CSV) into SAS data sheets. Provided statistical programming expertise in the production of analyses, tabulations, graphs and listings
  • Accompanied statisticians in various consulting sessions and provided support in statistical analysis including choice of experiment design, management of data, statistical procedures for analyzing experiments, interpretation of the results, statistical modeling and statistical computing
  • Developed macros for cleaning, transforming and modifying the data daily
  • Accomplished data manipulation on SAS data sets using techniques such as merging, appending, concatenating and sorting
  • Extensively used statistical procedures like PROC FORMAT, PROC MEANS, PROC FREQ, PROC IMPORT, PROC UNIVARIATE, PROC TABULATE
  • Extensively used statistical procedures like PROC FREQ and PROC MEANS to compute elementary statistical measures which include descriptive statistics based on moments, quintiles, confidence intervals, frequency counts, correlations and distribution tests
  • Applied statistical techniques to analyze and validate the model implementations
  • Created queries to generate HTML reports and tables using PROC SQL, PROC TABULATE and PROC REPORT to update the data daily

Environment: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS, Windows XP.

Confidential, Philadelphia, PA

SAS Programmer

Responsibilities:

  • This project involved experiment design to evaluate different strategies for customer retention. Integrated customer data, addressed data issues to create a clean and consistent database. Reading raw data files and manipulating the data sets
  • Convert excel data files into SAS data sets.
  • Creating SAS datasets by using Base SAS
  • Involved in development and enhancement of SAS programs.
  • Documentation, Analysis through using SPSS and SAS
  • Created plots using PROC GPLOT in SAS.
  • Generating graphs using SAS/GRAPH
  • Developed SAS Dataset and generated results into the excel sheets.
  • Responsible for retrieving and manipulating datasets using SAS, developing and executing SAS programs in support of statistical modeling projects, coding and running SAS programs for internal process validation, and maintaining and managing teradata.
  • As a SAS programmer supported Marketing Team and worked with Statisticians in analyzing the data. Tested whole process (Unit, UAT).
  • Validation the data using latest SAS functions.
  • Used SAS/SQL to pull data out of a relational database and aggregate to provide detailed reporting based on the user requirements.
  • Responsible for providing statistical research analyses and data modeling support for mortgage product.
  • Analyzing credit report to determine credit worthiness and performing risk evaluations.
  • Ensuring loans are structured and priced consistently with bank policy and commensurate with risk.
  • Analyzing and calculating debt to income ratio for evaluating mortgagor’s financial risk and provide recommendation to mortgagor to lower debt to income.
  • Evaluating and recommending affordable options to mortgagor to help reduce financial loss.
  • Run daily report to help determined how many loans are in foreclosure or will be in foreclosure within the next ten days.
  • Researched and analyzed all required documents for accuracy such as signature, bank statement.

Environment: SAS 9.3/Base, Windows, SAS/ BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/Access, SAS/VIEW, SAS/Enterprise Guide, DB2.

We'd love your feedback!