Data Analyst Scientist
Resume:
Randall D. White
Lansing, IL *****
**********@*****.***
Summary
Expert Data Intelligence Analyst and SAS Data Engineer in the UNIX, Linux, Mainframe and PC environments. Excellent data analyst and data profiler. Strong background in data governance. Proficient in areas of developing both complex and simple reports in a production environment as well as the ability to extract data from many different databases including SQL Server, Oracle and DB2 platforms. Twenty years of experience as a Qualitative Analyst, Reporting Specialist, SAS Base Developer and DevOps Engineer. Experienced in performing the duties of complex data analysis in a big data environment. Proficient in delivering ad-hoc reports and all other duties necessary for data modeling and management. Demonstrated ability in Data engineering that develop efficient processes which reduce the amount of manual work necessary. I bring, with a genuine enjoyment for solving the data problems, the expert skill that is required to work with large amounts of data in a relational database environment.
Technical Skills
Proc Report, Windows 7, Cobol, SAS Enterprise Guide, Business Objects, SQL, Proc Freq, SAS Macros, Unica\IBM Campaign, SAS Base, HTML, C++, Proc Tabulate, Python, SQL Server, TSO\JCL\MVS, MS Office, Cognos, File AID, MS Access, MS Excel, Proc Summary, SAS ODS, Visual Basics
Professional Experience
US Cellular, Chicago, IL.
2021- Present
DevOps Engineer PRE Platforms
Automated deployment processes, reducing average deployment time by 80% and increasing deployment frequency from weekly to daily.
Utilized Jira and Agile methodology in development of workflows to increase the distribution network.
Coordinated and deployed CI/CD process that delivered steady flow seamless continuity to existing processes.
Automated routine operational task through writing custom scripts and creating custom software code.
Acquired specific Workfront Core and Workfront fusion skills that allowed for the reduction in consultant staff that was needed.
Implemented campaign management processes that monitored the delivery mechanisms of a particular campaign using SAS and Oracle systems.
Created specific MongoDB scripts that allowed for the troubleshooting of delivery parameters to direct customer communication.
Participated in migration from UNICA Campaign development technology to SAS CI360 development tools.
Collaborated with development team on instituting new databases and development on monitoring processes.
Spearheaded projects that affected the network infrastructure and continual process execution of the PRE team.
Coordinated development of tools that streamlined and automated processes for SAS Plan.
BMO Harris, Chicago, IL.
2017- 2021
Marketing Info Product Analyst II
Created SAS-SQL code to synthesize large amounts of relational data to optimize complex member communications products to key audiences.
Developed data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs.
Performed extensive testing, created queries to extract and validate segment data and sizing.
Supported the campaign Analytics team on tracking the marketing campaign performance.
Supported quality and user acceptance testing such as, creating and executing.
Analyzed systems, met with end users and business users to define the requirements.
Developed project time lines and managed delivery commitments to stake holders.
Worked within cross-functional teams, using data and analytics technologies to drive decisioning.
Designed and executed multi-channel Campaigns leveraging UNICA Campaign application.
Developed Life-cycle Campaigns such as welcome streams, Points life-cycle and expiring points.
Designed Campaigns focused on delivering personalized product recommendations in effort to improve relevancy and increase incremental revenue.
Created complex join queries, transformations of all data types, as needed, to smoothly pass data through ETL maps.
Perform quality analysis (SQL) and peer reviews before launching a campaign to ensure data quality.
The Warranty Group, Chicago, IL.
2008- 2017
Actuarial Technician II/Business Intelligence Analyst
Develop SAS programs and/or Access databases to process, cleanse, summarize and analyze non-standard warranty data.
Process monthly, quarterly and annual reports for existing clients.
Develop programs and spreadsheets to perform simple actuarial analyses such as frequencies, severities, loss cost, loss ratios.
Develops ad-hoc reports and extracts for auditors and Underwriting.
Develop and implement approved information solution designs of manageable scope and complexity.
Work with internal and external clients on data analysis, documentation of data issues or business requirements and solutions design in order to facilitate the business modeling development processes.
GE Commercial Distribution Finance
2006- 2008
SAS Base Programmer/Consistency Analyst
Participated in SDLC initiatives for increasing the consistency of financial data across multiple data platforms in order to assure that reporting is both accurate and consistent for all data sources company wide.
Develop simple SAS macros for cleaning and reporting on financial data.
Create adhoc reports for spur-of-the-moment analysis and policy meetings using SAS9, SQL and Business Objects6.5.
Assist statisticians and business end-users in the creation of reports and business analysis by providing analytical support, data dumps, training and the maintaining of dashboards.
Develop and implement approved information solution designs of manageable scope and complexity.
Work with internal and external clients on data analysis, documentation of data issues or business requirements and solutions design in order to facilitate the business modeling development processes.
Grainger Industrial Supply
2002- 2006
Commercial Credit Specialist
Analyzed commercial loan applications, company cash flow and conduct in-depth reviews of borrowers’ financial statements to facilitate loan portfolio growth.
Monitored financial state and financial needs of existing customers to assess current and future credit risk.
Maintained quality of current loan portfolio through monitoring delinquencies and ensuring acceptable credit standards are maintained.
Collected outstanding accounts receivable and resolve customer billing problems in a timely manner in order to expedite cash flow.
Worked with company commercial account managers to resolve collection issues.
Transamerica Retail Finance, Hoffman Estates, IL.
2000 – 2002
SAS Base Programmer/Report Specialist
Developed production reports to measure performance of current programs or products, using proc summary, proc freq and proc tabulate in mainframe environment.
Designed and Developed a Timeseries Database that tracked a chosen grouping of variables on a month-to-month basis for each subsequent year.
Created adhoc reports used to measure a number trends and other business related issues.
Created file layouts used for determining commissions, incentives payments and mailing list.
Maintained and updated existing monthly and weekly reports using Sas base and relational databases (such as volume, insurance penetration and promotional reports).
Analyzed and manipulated data from outside sources in order to perform various duties.
Household International, Elmhurst, IL.
1996-2000
Information Analyst/MIS
Adhoc reporting to track trends and measure performance (of new dealers and portfolio performance such as booking versus losses).
Developed new reports with input from relational databases using mainframe SAS and Pastor.
Developed queries and profiles according to end users clients specifications.
Maintained and updated existing data archives.
Analyzed monthly business data from various outside vendors using proc report and proc means.
Edited and maintained programs, queries, reports and databases as necessary.
Education
Illinois Institute of Technology - Java Application and Applet Certificate
Absolute Solutions - Web Development and Design Certificate
Lindenwood - B.S. Business Administration/Finance (30 hrs to completion)
Contact this candidate