SUMMARY

• 9 plus years of work experience in 6 different industries using a combination of SAS, SQL (Oracle, MS SQL Server, and DB2), Hive on Hadoop, and BASH to build data processes, transform data, and create reports.
• Data visualization experience with Tableau, Spotfire, Microstrategy, and Excel.
• Experience taking a proof of concept reporting system to an enterprise level reporting system.
• Academic experience with machine learning.
• Excellent communication skills and business acumen combined with a technical mindset.

TECHNICAL SKILLS

• SAS
• SQL
• Tableau
• Hive on Hadoop
• Python 3.0
• Machine Learning
• Excel
• R
• MATLAB
• Octave
• Linux
• BASH
• MicroStrategy and Microsoft Office.

PROFESSIONAL EXPERIENCE

Confidential

Senior Analyst

Responsibilities:

• Performed proof of concept with Tableau for reporting using SQLite and Tableau desktop to replicate existing reports created in MS Access.
• Scaled up the proof of concept to a proven enterprise level reporting system used by over 10,000 users by performing the following:
• Software and hardware procurement
• Worked with IT to provide information on the number of users, the size of the data, and the type of visualizations so IT can procure the correct Tableau server, Tableau server license, and MS SQL server database.
• Data Architecture
• Designed the conceptual data model by understanding the existing data used in specialty care and value based program analytics and reporting.
• Proposed a logical data model for storing all data related to analytics and reporting and worked with the data architect to implement the physical model.
• Performed QA on the data definition language of all tables to ensure all constraints, foreign keys, and composite primary keys were put in place.
• ETL Design and Development
• Exported data out of Access and wrote SAS programs to create local plan criteria logic, derived fields for reporting, and transformed the data into flat files for SQL Server to store.
• Used SQL Server Data Tools to develop the ETL workflow in the SSIS packages to load flat files created from SAS to stage tables in SQL server.
• Developed insert/update stored procedures used in the SSIS packages to move data from source stage tables to their target tables.
• Wrapped SSIS package execution into a .BAT file for batch mode execution.
• View Table Development
• Developed user view tables to group concatenate provider users to their facilities and plan users for their plan to enable row level permissions in reporting.
• Developed a facility profile view table to allow reports to the ability to filter on profile dimensions.
• Developed a view table to handle designation of multiple specialty care types.
• Developed facility fact view tables that can be joined with the profile tables to allow reporting on current and historical metrics related to a facility.
• Developed a report metadata view table to allow data driven reporting.
• Tableau Server Users, Groups, and Permissions
• Developed comma separated files with SAS to load over 10,000 users into Tableau server to create usernames and user display names.
• Created 5 project folders for each specialty care program and a total of 148 plan, provider, and internal BCBSA user groups.
• Created comma separated files with SAS to associate users to their specific Tableau user group.
• Delivered the users to Tableau user group files to IT for them to execute TABCMD on Tableau server to add the Tableau user to their respective user groups.
• Interviewed and hired a temporary consultant to assign custom permissions for each Tableau group assigned to each project folder.
• Assigned user QA tasks to the temporary consultant to ensure all users in MS SQL server are added and assigned the correct groups in Tableau server.
• Tableau Workbook Development
• Designed and developed the eligibility results report for BCBSA and plan users to display an interactive executive summary and a detailed data page of the facilities’ eligibility status for the Blue Distinction Program for Bariatric Surgery, Maternity Care, and Transplants.
• Developed the text based facility feedback report that details why they are eligible or not eligible for the Blue Distinction Program.
• Developed the Value Based Program snapshot reports for the marketing communications team to show financial incentive for each program.
• Developed dashboards to QA flat files to ensure data quality before loading into the MS SQL Server database
• Used SAS to apply Levenshtein distances to create similarity measures between strings to check if incorrect spellings of facility addresses received a different unique identifier than one that already exists for the same address with a different spelling.
• Added new users to the Tableau server by creating the user and assigning the correct user groups.
• Created maps in Tableau on an adhoc basis for management to use in PowerPoint.
• Created a GUI python 3.0 desktop application for users to delete specific records in the database using TKinter, pyodbc, and cx Freeze.

Confidential

Senior Analyst

Responsibilities:

• Used Salespage to manage CRM data and to update territory information of the Sales team.
• Responded to adhoc data requests from the sales team by writing SQL queries on MS SQL server.
• Created Tableau dashboards related to:
• Nuveen fund performance against competitor fund performance
• Segmented Sales territory maps
• Activity tracking of the internal sales staff for the Nuveen High Yield 2020 term closed end fund IPO
• Capital gains of Nuveen funds versus competitor funds.
• Created stored procedures in MS SQL server for Tableau reporting.
• Worked with the IT team to move stored procedures in the analytics environment to production.
• Created custom SQL in Tableau for reporting.
• Tested existing Tableau production workbooks for the version 9 upgrade.
• Modified existing excel VBA code for added functionality

Confidential

Senior Data Analyst

Responsibilities:

• Improved speed and efficiency of SAS processes related to RFV segmentations, panel creation, and raw data loads to ensure SLAs are met every time by:
• Analyzing existing SAS processes and workflow of 12 different SAS scripts
• Consolidating and restructuring existing SAS processes and rewriting certain SAS scripts
• Developing 33 new SAS scripts and 10 new BASH scripts to fulfill process dependencies
• Initiating the process automatically by having crontab execute a shell script which executes a SAS wrapper script
• Having the automated process send results as attachments through e - mail to the analytics team after successful completion
• Performing QA on the automated process outputs before going live on production
• Created a new automated direct marketing campaign reporting process by:
• Gathering data and business requirements from analysts and manager
• Analyzing the requirements to ensure all the required data is available
• Developing BASH and SAS scripts to join data from multiple sources such as delimited files, Oracle database tables, and SAS datasets
• Developing 28 reporting metrics on 24 different variables in SAS
• Automating the process to start once the direct marketing campaign is complete
• Migrated existing processes into the new UNIX folder structure to help save backup costs.
• Developed and automated SAS file size reports sent weekly to list out all SAS files greater than 1GB to help analysts monitor their disk space usage.
• Assisted the onboarding of new feed files by explaining our data requirements to clients and filing JIRAs to have IT operations team automate the feed file transfer between servers.
• Documented all of the automated SAS processes

Confidential

SAS Programmer/Data Analyst

Responsibilities:

• Gathered and documented historical data requirements related to the lifecycle of individual loans of the acquired bank.
• Automated the Credit Portfolio Risk Management Dashboard in SAS by:
• Understanding the current excel process, formulas used for calculations, and the excel VBA functions.
• Translating the excel process to SAS code.
• Architecting the SAS code to have an input data loading program, a derived input data ETL program, a report data ETL program on the derived input data, and a data export program on the reporting data.
• Architecting the automation process in Linux to run on crontab by having the program look for the required input files before starting and having the process send out success and failure e-mail notifications.
• Documented and presented the automated SAS process to the Senior Vice Presidents and the team to understand and use.
• Explored data visualization tools such as Tableau, Spotfire, and SAS Visual Analytics for dashboard enhancement.

Confidential

Business Analyst

Responsibilities:

• Redeveloped, tested, and automated an existing SAS ETL process using HQL and Bash
• Gathered and documented business requirements for various marketing reports to be automated.
• Developed HQL, SAS, and Bash code according to requirements that I gathered.
• Written test cases in HQL to QA data according to business requirements.
• Collaborated with the predictive analytics team to create aggregated tables in Hadoop for modeling.
• Analyzed Coremetrics SDE data to help fulfill data requirements for the site merchandising team.
• Created a SAS macro to de-normalize product hierarchies up to N different levels.
• Fulfilled adhoc data request from the marketing team.

Confidential

Marketing and Product Analyst

Responsibilities:

• Documented and presented the relationships between tables in the Pogo data warehouse specifically for e-mail campaigns.
• Enhanced the data request template so business users can understand and make data requests more efficiently.
• Gathered requirements for 30 existing automated email campaign SQL scripts in order to investigate the accuracy of the scripts.
• Developed 30 different production quality SQL scripts which was handed off to the ETL team for automation.
• Worked with the QA team to help implement a QA process for present and future email campaign data files.
• Developed adhoc SQL code to fulfill the business users’ requests.
• Re-written existing SQL scripts to create free form SQL reports in Microstrategy.

Confidential

Associate Level

Responsibilities:

• Written adhoc SQL queries and SAS code to analyze and extract data.
• Updated, re-estimated, and verified the risk model outputs in a SAS Linux production environment before delivery to clients.
• Assisted client service members by answering model methodology and data related questions.
• Trained intern and new hires about the basics of multi-factor risk modeling, model data processes, Linux, SAS and SQL.
• Improved the quality of the US risk model by correcting and inspecting each asset’s industry assignment based on the business description in the10-K filing.
• Identified and streamlined risk data elements for all equity risk models for storage in the risk model database.
• Collaborated with various teams to gather data and data process requirements for new model operational specifications.
• UAT of new data processes to ensure proper functionality and risk data output.