• Responsible for advanced data analysis and acted as a SME on all data requests and data requirements.
• Performed EPSI protocol design and statistical programming.
• Followed Standard Operating Procedures (SOP) for setting up protocol design.
• Created and maintained SOPs.
• Performed full ETL and data migration processes.
• Extracted data, manipulated, merged, and analyzed data into reports, graphs, and digital dashboards.
• Provided data analysis and data reports for Senior Executives and implemented strategic solutions when needed.
• SAS development and programming with macros for efficiency.
• Troubleshot connection issues from internal and external SAS users.
• Monitored production and development servers for workload balancing.
• Developed tools (databases and spreadsheets) to track (VPN and\or server) connection and access issues.
• Completed UNIX system access request forms for user’s permissions.
• Assigned permissions to directories and Access Control Lists (ACL) to groups.
• Utilized COGNOS and other BI tools to develop complex reports from multiple data sources.

• Develop statistical programming routines in SAS for QC’ing reports.
• Modifying, maintaining and executing existing SAS programs.
• Assisting with automation of non-automated processes using SAS

• Used the EPIC system to access electronic medical records for health care provider.
• Use of Power BI tools to develop executive-level reports and presentation materials to communicate analysis results.
• Analyze data profiling reports and evaluates quality, identifying issues and gaps in data with regard to supporting business processes utilizing tableau and Power BI.
• Lead, design and perform analyses to report meaningful ROI metrics at the executive-level.
• Create and maintain SQL database to capture and integrate data from multiple sources, including Evariant PRM, CRM, Contact Center, EPIC, eSimon and HCI financial system.
• Work regularly with the Marketing & Communications team (including Executive Directors, Directors and Managers), Network Development and Director of Business Analytics.

• Developed SAS and SQL code for the purpose of analysis and reporting to validate and measure business objectives.
• Database consultant for the Information Management data tables.
• Analyzed data to support physician compensation and network optimization.
• Interacted with business customers and Information Technology Group contacts.
• Performed analysis and database queries to gather information for a better understanding of the business.
• Requirements gathering from business units to resolve business issues

• Created reports, charts and digital dashboards using Excel and Power BI tools.
• Performed data analytics to assist in determining the significance and impact of various activities/organizations.
• Maintained data dictionary for data tables created by enrollment activities and in the data warehouse repository.
• Analyzed the responses to Call Center through the Interactive Voice Response (IVR) system.
• Reported findings to help recognize program effectiveness and influence future planning.
• Produced reports and information using data visualization practices.
• Identified trends suggested by empirical data and evidence.

• Wrote and Modified SAS code via SAS Enterprise Guide 4.2 and 9.1 to create SAS data warehouse tables.
• Subject matter expert for any technical issues involving data accuracy.
• Interpreted client needs and data requirements for the building of ad hoc reports.
• Executed and monitored the daily and monthly process of refreshing of SAS Data Mart tables.
• Automate and recode SAS code for increase efficiencies and reduce data input errors.
• Audited SAS Data Mart tables for accuracy and recency.
• Managed and resolved data issues as a liaison between the analysts and technical support.
• Created new Excel and HTML reporting via SAS Output Delivery System (ODS) to reduce input error and expedite report generation and the decision making process for the account managers

• Worked with Global Products Group to help with process improvement proprietary application MarketMap, by setting up and running of the Accessories and Footwear categories within MarketMap.
• Modified SAS code via SAS Enterprise Guide 4.2 to create Access database tables.
• Automated the lookup page in the Excel module to populate dynamically from SAS.

Worked with the GPG team to complete any necessary adjustments to the existing SAS code to MarketMap for transfer to the IT/Ops department.

• Traditional analysis and reporting for direct marketing campaigns for deposits and small-business accounts.
• Performed statistical significance testing on both Test and Control groups within the campaigns.
• Provided monthly dashboards reporting on analysis to better understand the population of customers that are “right-fitted” in terms of changing their accounts post-sale.
• Provided analytical insight of how to engage and deepen the bank’s relationship with its customers by measuring Cross Sell/Upsell opportunities, card activation, and online banking suite of products.
• Worked with internal Business Partners to develop methodology and scope of direct marketing campaigns.
• Reported on retention, attrition and acquisition metrics for direct marketing campaigns by Email (EM), Direct Mail (DM) and other channels.
• Used SAS to solve complex calculations and queries across different data sources to build cross channel marketing campaigns.
• Performed complex data merges and joins using SQL and SAS on large multi-million record datasets.
• Utilized SAS macros to perform repetitive sections of code.
• Designed and programmed Excel applications with VBA to automate spreadsheet execution and analysis.

• Monthly and adhoc reporting and analysis of the consumer and small business portfolios.
• Provided analytical insight from data analysis for Senior Management to make quality decisions.
• Developed and modified SAS code working with TSYS and FDR financial data from Teradata databases.
• Monthly analysis and reporting for Home Loan portfolios for strategic initiatives and portfolio performance updates.
• Performed ad-hoc analysis on consumer and commercial portfolios for Credit Risk Managers to mitigate credit risk.
• Designed and programmed in VBA an Excel reporting and data mapping application for credit risk analyst.

• SAS development and analysis for the District, school and student level reporting.
• Compiled data and managed relationships with internal and external research partners in order to perform independent studies and reporting of test scores.
• Extracted, transformed and load data for the District’s report portal.
• Expedited the delivery and viewing of HTML and XML reports using Proc Report for the state tests and performance level scores of students, schools and areas by posting them onto website.
• Served as liaison between data management and private/public research groups gathering, compiling and manipulating data for conducting research studies.
• Created digital dashboard reports allowing senior-level management to step back from the details and see the key trends and relationships that driving student performance.
• Performed all functions related to data gathering, analysis, and reporting.

• Performed data mapping and continually resourced the metadata and data dictionary in order to map data variables from new data source in order to replicate reports.
• Performed business analysis testing, debugging and documenting SAS code.
• Executed data analysis utilizing Citibank’s multi-million records consumer and commercial oil First Data Resources (FDR) data files.

SAS programming and report replication for First Data Resources data convergence from old legacy system

• Managed accounts and credit line strategies for existing card members (ECM) on a variety of Private Label and Co-brand/Bankcard portfolios. Performed complex data analyses for the functionality of assisting senior management in the decision making of high risk accounts.
• Conducted studies of customer groups and product types, and develops computer-based models for projections, e.g. delinquency and charge-off, cost and profitability, new account acquisition, credit limit setting, and account management.
• Established credit limits for corporate oil customers private label accounts based on the volatility of the oil market and customers’ transaction history. Performed risk analysis for co-brand portfolios to reduce the company’s exposure to risk, defaults and delinquencies.
• Utilized credit bureau, First Data Resources (FDR) and other secondary data sources in the analysis of customer portfolios.
• Utilized Perl and UNIX Shell scripting to run batch processes.

• Performed the analysis and performance reporting of the monthly direct mail and telemarketing campaigns. Utilized Mintel Comperemedia data to perform competitor offers analysis.
• Provide analytics to support strategies for accelerated direct mail campaigns.
• Delivered post-booking results for accelerated campaigns compared to pre-approve.
• Performed geographical analysis to increase merchant penetration, card activation and utilization while reducing charge-offs and bolstering cardholder retention.
• Programmed and developed Excel applications using Visual Basic and SQL coding for the Marketing Department to perform competitive analysis

• Measured the effectiveness of advertisements on the pre-print sales circulars by analyzing the size of the ad and the placement (page location) of the ad to determine the profitability and effectiveness of the ad for the Advertising Effectiveness department.
• Performed back-end analysis for national lines direct marketing programs using SAS and Sears methodology. Analyzing the response rates of the household files for mailed vs. non-mailed groups by customer segments for each marketing program. Then reporting return on investment (ROI) and profits for each program period.
• Created an Excel reporting system to produce the monthly reports generated from the different direct marketing programs and back-end analyses determining the lift of response/non-response and mailed/non-mailed classifications.