We provide IT Staff Augmentation Services!

Bi Development Senior Sas Application Specialist Resume

4.00/5 (Submit Your Rating)

Dayton, OH

SUMMARY:

  • Sixteen years of professional experience with Statistical Analysis Software(SAS) and advanced programming and data managing
  • Eleven years of public health experience at the state, federal and commercial level
  • Experience creating .bat, control, parm and macro files to migrate code from SAS EG to an automated Production SAS environment
  • Highly experienced in merging and transposing data, building macros, arrays, and formats
  • Highly skilled in generating ad - hoc reports with proc report, proc gplot, Output Delivery System (ODS) and more
  • Experience planning and executing all phases of the software development life cycle (SDLC) for a variety of projects
  • Experience providing On-Call SAS Production support, trouble shooting abend incidences and rerunning code to generate error free logs
  • Skilled in using SQL (SAS, Oracle, Teradata) to query data, SPSS to analyze data, Access to build databases, Excel to manipulate coding, VB Scripting to automate forms depending on user responses, etc
  • Acquired SAS Admin skills by supporting SAS & Web servers, writing JavaScript code for HTML UIs for SAS Intrnet, managing user permissions and more
  • Working knowledge of basic statistical procedures, survey design, proc logistic and more

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, OH

BI Development Senior SAS Application Specialist

Responsibilities:

  • Consistently design, code, test, analyze and translate SAS EG, SAS and Teradata SQL programs according to client specifications.
  • Create .bat, control, parm and macro files to migrate code from SAS EG to an automated Production SAS environment
  • Provide On-Call morning, night & weekend SAS Production Support by troubleshooting job abends incidences & rerunning for error free log
  • Manage, train and provide guidance to junior and mid-level software developers and research assistants
  • Perform technical code reviews of peers to ensure that proper coding methodology and Confidential ’s proprietary coding is being adhered to
  • Plan, execute and document all phases of the SDLC for a variety of projects

Confidential, Atlanta, GA

Marketing/Merchandising Marketing Manager

Responsibilities:

  • Managed Marketing/Merchandising team’s Analytics/Reporting projects using SAS EG
  • Analyzed customer trends and suggested product changes to generate revenue
  • Experience using Hyperion to Query data and generate summary statistics in pivot table form
  • Migrated SQL from Hyperion to SAS EG production schedule
  • Used in-depth knowledge of SAS Macro-processing and ODS to automate Microsoft Excel Report statistics package
  • Migrated Microsoft Excel reports into SAS EG using proc report
  • Developed and executed marketing analysis using SQL queries via SAS connection to TERADATA.

Confidential, Atlanta, GA

Fraud Analytics Retrospective Programming Senior SAS Engineer

Responsibilities:

  • Developed algorithms and troubleshoot logs that run on SAS grid in Unix SAS
  • Set up best practices for data storage and compression to improve performance in SAS grid
  • Developed and executed fraud algorithms for Medicare, Medicaid and commercial clients using SQL queries via SAS connection to ORACLE.
  • Used VBA scripting and other programming and/or scripting languages, as needed
  • Provided realistic cost and resource estimates for fraud algorithms programming
  • Conducted data extraction that includes analyzing, reviewing, trending and presenting information, based on provided specs, to support or refute hypotheses leading to the initial identification of heath care fraud & abuse
  • Interpreted and created requirements, functional specifications and technical design documents and communicate these effectively to the team
  • Performed unit, system and regression testing for SAS programs for quality
  • Contributed to knowledge sharing, ideas and information relating to SAS technologies and function as the key technical expert within the team

Confidential, Atlanta, GA

Quality Promotion Lead SAS Dev /DBA

Responsibilities:

  • Promoted from Database Administrator IV to Database Administrator V / Confidential IT Lead
  • Lead a team of Intermediate SAS DBA and SAS Statistical analyst; assisting them with SAS adhoc data request and Confidential IT SAS support
  • Provided SAS support, including supporting Production and backup SAS application and web servers, writing JavaScript code for HTML user interfaces for SAS IntrNet, managing user permissions, automating SAS programs using windows dos batch programs running on windows scheduler
  • Knowledge of SAS/IntrNet and Web-based applications, including HTML, ASP, JavaScript
  • Familiar with managing SAS application and IntrNet servers, brokers, sockets, stopping and restarting services, etc
  • Familiar with Windows batch applications/processing and job scheduling for tasks such as updating information at the end of the day/week/month/year and generating reports

Confidential

Quality Promotion SAS Developer/ DBA

Responsibilities:

  • Provided expert assistance in logistic regression analysis, categorical data analysis techniques, data mining techniques
  • Applied new and innovative analytical approaches to vaccine safety research projects and epidemiological investigations using SAS, and other appropriate statistical packages and programming languages to perform standard analysis of research studies
  • Demonstrated knowledge of probability and statistics; using statistical methods to describe data, estimate parameters, and test hypothesis
  • Demonstrated ability to present statistical findings in an understandable fashion and synthesize results into meaningful recommendations
  • Managed data quality in SAS (e.g., step manipulation including merging datasets, creating arrays, do loops, if/then/else statements, proc sql)
  • Wrote complex SAS macros to automate processes along with the ability to rapidly debug existing applications
  • Worked independently to perform analyses of large and complex datasets with SAS ODS to output results to specific file formats
  • Provided support in SAS programming, data management, best practices and analyses to other members of the team

Confidential

Data Manager

Responsibilities:

  • Developed protocol for best practices in data management, quality and integrity and advanced IT principles
  • Created procedures performed to fully document data management and SAS routines visual flowcharts using MS Visio to document analysis
  • Created Fill and Submit PDF Forms using Adobe Acrobat and online survey for the GA Epi-Aid H1N1 in Schools Study using the GA DCH State Notifiable Disease Surveillance System (SENDS)
  • Created Algorithms that searched chief complaint field for Influenza Like Illness and Acute Respiratory Illness in Dallas Fort Worth study
  • Generated matrices in SAS that distinguish between “No” and “missing” responses for the ACA/ACN/ Confidential National Survey of summer camps study and Super Intendent/Principle Michigan Epi Aid
  • Generated complex data cleaning and analysis code for various online survey formats
  • Conducted data cleaning and analysis for several publications studying effects of non-pharmaceutical interventions in schools, camps, daycares..

Confidential

SAS Prgr/Data Mgr

Responsibilities:

  • Collaborated with Epidemic Intelligence Service (EIS) Officers, statisticians, epidemiologists and the director of the Biostatistics Office to analyze and prepare data for publications, conferences and Lectures
  • Co-presented division-wide seminars on questionnaire design, Standards for creating SAS compatible Databases and Descriptive Analyses Made Easier
  • Conducted data analysis and co-authored Multistate Outbreak of Salmonella Saint Paul Infections and Pulmonary Nocardiosis Resistance Testing publications
  • Served as a IT Projects liaison between the programmatic/business/science( Confidential ) side and the IT systems side ( Confidential )
  • Participated in requirements meetings to gain an overall working knowledge of all projects to assist government oversight for IT systems
  • Conducted quality control checks and the descriptive Case Control Analysis during the Salmonella St. Paul and Typhimurium Outbreaks in the Emergency Operations Center (EOC)
  • Provided ad hoc analytical SAS programming assistance to all levels of Foodborne division staff
  • Planned, built and maintained Access databases for data storage and retrieval and SAS Component Language (SCL) interfaces in support of outbreak and surveillance data
  • Produced instructional protocol for descriptive analysis tools and applications
  • Built automated summary reports in SAS for the Foodborne and Mycotic Disease Branch
  • Developed interface applications with SAS AF to be used as analytic resource tool for EIS Officers and other staff
  • Programmed for univariate and bivariate descriptive and conditional logistic studies during Foodborne outbreaks
  • Used SAS Structured Query Language (SQL) to create macro variables and generate data queries.

Confidential, Atlanta, GA

Data Quality and Integrity Consultant

Responsibilities:

  • Performed Senior level review of work papers and developing project plans that suggests solutions to client’s data analysis issues
  • Used SAS to create algorithms that re-rolled up mortgages back securities to help reinstate financials during the subprime mortgage crisis
  • Used ACL for identifying data patterns, data extraction, analysis, queries, data manipulation & cleaning, computed fields & data views
  • Validated data in SAS and performing data source analysis to ensure data provided for Audit testing is relevant to master data.
  • Profiled journal entries & benchmarking Confidential & Touché IT Control Activities & objectives to assist in mitigating risk of potential fraud
  • Supported inventory audits, ad-hoc requests, data profiling, reconciliations and random sampling in SAS and Structured Query Language
  • IT Audit Specialist for IRS and Fannie Mae and other Corporate/Federal agencies
  • Used MS SQL Server to generate database queries.

We'd love your feedback!