Machine Learning Sql Server
Resume:
Roderick Ewing
***********@*****.***
Atlanta, Ga
SUMMARY
With over 17+ years of experience in analytics, design, development, testing and implementation in Healthcare, Banking and various other industries using SAS/SQL. I have extensive experience with SAS programming, SQL, Reporting Tools, Object Oriented Programming, Oracle and MS SQL Server. I also have extensive knowledge of ‘state of the art’ machine learning tools and data mining techniques with a track record of applying them to real problems for real data. I possess a collaborative approach and adaptability to changing project needs. I am focused on delivering reliable results through efficient team coordination and technical expertise.
SKILLS
●SAS BI, SAS Viya,, SAS Enterprise Guide, SAS/BASE, SAS/SQL, SAS/Macro, SAS/Reports, SAS/Macro, SAS/Connect, SAS ODS(RTF,PDF,XL) Excel, Access, Hyperion, TOAD, Notepad++, Ultra Edit
●SQL Server, Teradata, DB2, Oracle, Databricks.
●COBOL, JCL, TSO/ISPF, DOS, MVS/TSO, OS-390 Mainframe, UNIX, MW300, CICS.
●ETL Workflows.
●Ultra Edit, Azure Boards, TortoiseGIT. TortoiseSVN, HTML/XML, Notepad++,
,,
EXPERIENCE
SAS/SQL Developer(contractor)
CDC/DNI 11/12 – Present, Atlanta, GA
•Provide analysis and identify complex data issues, identifying root causes, and work to propose solutions to improve business operations.
• Implement and adhere to data quality standards and best practices to maintain data integrity.
•Ensure project schedules and performance requirements are met.
•Develop and deliver comprehensive reports with clear interpretations and actionable recommendations based on data analysis findings.
•Gather data from multiple internal and external sources, ensuring data quality and consistency by cleaning and transforming data sets using appropriate tools like Databricks, SQL, SAS, or R.
SAS/SQL Developer(contractor)
CDC/Leidos 10/16 – 9/24, Atlanta, GA
•Design, develop, and unit test analysis and reporting requests using SAS in an Agile Scrum development environment as development with SAS Viya in an Azure cloud environment.
•Exercise independent judgment within broadly defined practices and policies in selecting methods, techniques and criteria for obtaining assigned objectives.
•Ensure project schedules and performance requirements are met.
•Collaborate with the customer’s subject matter experts, application developers, business analysts, and project management to understand customer and project needs for analysis and reporting.
•Provide technical feedback and guidance on data output options, recommend technical changes, and share suggestions for improvements in analysis and reporting to project management.
•Investigate and correct system issues within the analysis and reporting functionality and collaborate with other developers to resolve application software issues.
•Provide technical support for the quality assurance and deployment of new software releases of the overall system..
SAS/SQL Developer(contractor)
Cigna Health Care 11/15 – 7/16, Chattanooga TN / Atlanta, GA / Bloomfield CT
•SAS Programmer/Consultant developing SAS programs to support Medical or Pharmacy claims data management and reporting in an enterprise setting.
•Automate reports through the full development life cycle.
•Pull medical or Pharmacy claims data from various data sources: SQL server, Neteeza, Teradata, Oracle, Unix and Mainframe to create reports and streamline data reporting..
SAS- Developer
Construction Management Data 12/14 – 9/15, Norcross, GA
•Design and develop project-specific SAS programs, and produce analysis datasets, reports and graphics.
•Develop detailed, logical and documented plans for data analysis, execute those plans, resulting to output that is accurate, has a high degree of data integrity and is responsive to the business need.
•This includes outlining analytic data set specifications as well as managing multiple large SAS data sets, including: defining populations and variables, performing analysis and summarizations to address client business questions.
•Cultivate a level of industry knowledge necessary to not only recognize meaningful findings and distinguish potential anomalies, but also enabling identification of opportunities to innovate and leverage custom analytics findings as the basis for developing a standardized product offering, for broader market consumption.
•Deliver clear and effective communication of analysis findings, including most salient points and analysis methodology utilized.
•Contribute to the definition and development of key findings and marketing-oriented conclusions.
•Proactively work with colleague to develop and strengthen their skill sets in SAS coding, information maps, stored processes..
SAS-ETL Developer(contractor)
Peak Health Solutions 4/14 - 9/14, Roswell, GA
•Design and develop project-specific SAS programs, and produce analysis datasets, reports and graphics.
•Extract, transform and load (ETL) very large tables of health care data from text-formatted datasets.
•Develop utilities for QC/QA and analyses.
•Deliver ad-hoc reporting as requested.
•Coordinate and communicate customer and system issues with internal resources.
•Follow policies and procedures to insure organization is compliant with HIPAA and other privacy and security requirements.
SAS-SQL Developer
Regions Bank 11/13 - 4/14, Birmingham, AL
•Analyze, create and modify reports based on business objectives and requirements.
•Structure, analyze and present loan data in tabular, graphical, time series, variance and relational presentations.
•Query and deliver loan detail data from the Credit Risk Analytics Data Mart (CRMS).
•Design, develop and support data and reporting requests for Risk Analytics.
•Ability to analyze results for accuracy and explain variances.
•Coordinate, assist, develop SAS programs to extract and present data in presentation reports.
•Participate in business requirements gathering including working with end users to interpret functional requirements into report specifications.
•Provide support, training and consulting to end users on the use of data sources..
SAS-SQL Developer(contractor)
Blue Cross Blue Shield-Cahaba GBA 1/13 - 11/13, Birmingham, AL
•Work with complex health care data to develop and produce standard ad hoc reports and analysis based on requests from various groups and managers.
•Develop adhoc reports and scheduled production reports using SAS/SQL from Centers for Medicare & Medicaid Services (CMS) databases.
•Build and execute SAS/SQL queries and retrieval based on health insurance claims transaction, enrolment and provider data, Medical Reviews, Edit Effectiveness and Workload Analytic reports.
SAS-SQL Developer(contractor)
BBVA Compass Bank 5/12 - 1/13, Birmingham, AL
•Extract data from multiple platforms, data warehouses and database tables for use in analytics and validation.
•Develop and execute queries in a SAS environment to validate data attributes for a comprehensive review of data integrity for capital planning purposes.
•Provide both quantitative and qualitative means of validation to establish the highest level of confidence in the bank’s integrity of data.
•Work with multiple sources of data (often outside of the in SAS database).
•Create documentation sufficient to explain the results achieved when performing validation (frequency distributions, etc.)..
SAS –SQL Developer –Analyst/ ACS Specialist/ Analytics and Performance Measures Group
Delta Airline 5/09 - 5/12, Atlanta, GA
•Responsible for the design, development and review of Airport Customer Service reporting.
•Assist in implementation of divisional decision support processes to report and analyze performance of ‘ACS’ airport operations and administrative functions.
•Develop ad-hoc reporting and trend analysis for management.
•Manage and/or assist in special projects as required to support corporate and divisional initiatives.
•Troubleshoot and assist in developing next-generation decision support, analytics and process improvements.
•Use TERADATA/SAS/DB2/Excel to automate standard reporting process.
EDUCATION
Bachelor of Science, Computer Information Systems DeVry Institute of Technology • Atlanta, GA • December 1999
Contact this candidate