Nancy Arner Email & Phone Number

Monroe, NC, US

Durham, NC, US

• Responsibilities & Duties
• Analyze business and technical requirements for the design of data integration solutions
• Define the overall data integration and dataflow architectures to support data integration projects
• Design and develop SQL and SSIS processes to support data integration projects
• Design and develop APIs to consume and distribute healthcare data
• Design, develop and execute unit testing plans

San Francisco, California, US

Performed complex SQL Server SSRS/SSIS automation reporting and analytics for the Home Lending Mortgage Default servicing team. The reports pertain to home mortgage and home equity bankruptcy executive and regulatory reporting. Compiled research, built test cases and performed in-depth analysis on critical operational data.

San Francisco, California, US

• Performed complex SQL Server SSRS/SSIS automation reporting and analytics for the Home Lending Mortgage Default servicing team. The reports pertain to home mortgage and home equity bankruptcy executive and regulatory.
• Gathered business requirements, designed, developed, tested complex stored procedures, SSIS packages, SSRS reports for bankruptcy Setups, Proof of Claim, Motion for Relief, Payment Change Notifications, Supplemental.
• Created parameterized, summary and drill-through to detail SSRS reports.
• Created and scheduled SQL Server jobs to automate bankruptcy SSRS report data updates.
• Responsible for user acceptance testing with the Bankruptcy and Quality Assurance teams.
• Created technical documentation of system related activities including business requirements, solution design, testing and run procedures.

Performed audit assessment interviews with Information System Application Managers to identify and track systems eligible for Optim archival processing.

• Responsible for following business requirements to design and establish email marketing campaigns executed via APRIMO campaign management software.
• Designing, developing and executing SQL Server database queries for the purpose of data quality validation.
• Designing and developing SQL Server based Excel pivot table reports and charts for business analysis purposes. SQL code is embedded in the Excel files and updates with a refresh.
• Producing key project documentation on the new Marketing database views using Microsoft PowerPoint presentations.

• Principal responsibility is to deliver production reporting and analytics for Deposit Analytics Marketing business partners to execute and support deposit related marketing initiatives.
• Banking customer promotional bonus payment qualifications are assessed and monetary bonus payment files are generated for eligible customers.
• Generating marketing performance measurement reports including promotional tracking and analysis of direct and interactive marketing campaigns.
• Extracting and manipulating data from Teradata relational databases using SQL, via Teradata SQL Assistant, and PC SAS to drive reporting and insights to the business.
• Interacting with business partners daily in management and coordination of marketing initiatives.
• Maintaining and updating established production reporting to meet the changing requirements of the business.

Responsible for legal compliance archival of a multitude of legacy Mainframe application systems IMS, VSAM and sequential file data. Analysis of COBOL copybooks is required utilizing software that maps Mainframe application system data structures to relational type data structures. End product is use of Optim archival software that requires input of.

Charlotte, NC, US

Delivered project management for multiple projects in support of programmed statistical models ensuring that target dates were met. Projects included Pricing and Cash Management, Model Variable Metadata Library, FICO08 and a Teradata View conversion project. Participated in the testing phase for the rollout of a new credit card system. Responsible for.

Charlotte, NC, US

Participated in the examination of an existing SAS forecasting program to analyze ways to refine the code and improve the processing efficiency, labeling and outputs for internal audit compliance. Assembled information to compose the project work plan. Researching potential issues with the program modifications. Participating in testing the program.

Risk Operations Department. Analyzed a potential new loan portfolio to determine potential for profitability and risk of loan default. Created SAS/SQL ODS PDF program code to produce time plots, graphs and charts depicting the state of the loans credit strength. Further analyzed the results to present a risk analysis of the loans for presentation to upper.

Charlotte, NC, US

BANK OF AMERICA: Corporate Investments Technology/CR Analytics – 11/2009 to Present Sr. Unix SAS/SQL Application Developer - ContractorResponsible for technical production support of a Credit Card Consumer Spending database. Execute Mainframe jobs to provide data feeds for UNIX Netezza DB data reconciliation processes. Enhance and execute UNIX SQL and Korn.

Responsible for interpreting business requirements to design, develop and test UNIX resident SQL/SAS programs that extract and process data from Corporate relational databases in support of Mortgage Marketing campaigns. Accountable for timely and accurate targeted Marketing campaign execution, analysis, and performance measurement for mortgage loan.

Delivered Direct Marketing customer campaign lists in support of a Marketing Offers Management campaign for Consumer and Small Business products including Mortgage, Home Equity, Deposits and Student Lending. Processed and generated large data files by creating and executing SAS/SQL UNIX programs accessing a Teradata DB. Additional responsibilities included.

San Francisco, California, US

Responsible for the design, development and testing of UNIX SAS/SQL programs accessing Teradata DB tables to automate testing processes for a Basel II Mortgage initiative. The automated testing programs replaced work previously performed by employees. Automated mortgage data field range value comparisons between source and target systems. Account level.

Charlotte, NC, US

Analyzed Home Equity consumer credit risk portfolio and vintage trends concerning loan losses, portfolio dynamics, credit bureau scoring criteria, credit policy and collections. Responsible for obtaining business requirements and development of complex analytical programs. Extracted data from UNIX resident Teradata and DB2 databases using SAS, SAS/SQL and.

Charlotte, NC, US

Accountable for the modification, and execution of SAS production programs to provide Card Services department reporting. Accessed DB2 tables utilizing base SAS, SAS/SQL, SAS macros, and SAS procedures on the UNIX and PC/SAS platforms. Analyzed requirements, designed, developed, tested and implemented a Credit Card reporting system with ACCESS DB forms.

Charlotte, NC, US

Analyzed the Finance Decision Systems department Mainframe/UNIX, TERADATA/ORACLE SQL and COBOL programs to perform data mapping for the BASEL II initiative. Executed SQL queries with Queryman software to analyze data in the Financial Data Warehouse Oracle tables. Researched Financial Systems process flows using the Financial Data Warehouse production.

Generated web based marketing reports using SAS ODS HTML code, SAS OLAP, SAS base, SAS Macro and SAS SQL on a UNIX Solaris platform. Developed UNIX scripts to automate system processes. Collaborated with Account Executives to obtain business requirements for Marketing and Insurance Information System reporting. Performed Project Management to manage.

Wrote business requirements analysis documents using the Method/I systems development methodology. Utilized base SAS, SAS MACRO, SAS SQL and EXCEL to generate Managed Care data reports for internal sales force personnel. Generated statistical analyses on SAS library data. Modified and executed SAS programs to perform data loads to a web application..

New York, NY, US

Provided UNIX RS6000, mainframe and Client Server PC/LAN based programming support for the Authorizations, Credit Operations, Card Replacement, Finance, Marketing, Membership Rewards, Performance Engineering, Regulatory Compliance and Risk Management business functions.Implemented LAN based applications written in VISUAL BASIC and ACCESS. Designed.

Bachelor Of Arts (Ba), Experimental Psychology

B. A. Conferred With Honors, Psychology, Computer Science