Duncan Warwick Email & Phone Number

Raleigh, Nc, Us

United States

Using Azure DevOps, converted 30+ Actuate DB2 reports to SSRS and TSQL.

Cary, North Carolina

Leading core integration through API development. Data standardization across multiple core types to enable application wide compatibility. Development & Analysis of machine learning models via AWS Comprehend, Sagemaker & Snowflake SQL. AWS Quicksight dashboard development and production of PowerBI analytics product.

Raleigh, North Carolina

• Develop a cleansed, comprehensible, and convenient layer on existing Data Warehouse to enable non-technical users to generate self-serve analytics• Acquiring external data sets from government agencies and incorporated into SAS data lake• Evaluation of current value received from Equifax fields in the current contract for possible substitutions for more impactful data• Extensive development and implementation of stringent validations on source data to identify gaps and items in need of improvement• Acting as an “Analyst Catalyst” to the other data professionals in understanding our data, and best practices on satisfying requests/questions from executive management

 Develop, maintain, analyze and improve complex stored procedures for production and inventory reporting Generate daily, weekly and monthly reports and invoices Led development of historical tables to improve and ensure data integrity

 Develop, maintain, analyze and improve complex stored procedures and data warehouse historical tables for daily, weekly, monthly, and quarterly report data on biopharma medication and patient data to vendors and pharmaceutical manufacturers. Perform quality control on all data reported to clients and vendors, submitted via file transfer protocols. Utilize SQL Server 2012, SSRS 2012, Access, Excel, Outlook, and various FTP applications, (Smart FTP, FileZilla) to securely deliver reports to internal and external stakeholders. Lead discussions with vendors, clients, and internal customers on data gathering, methodology, metrics and requirements. Create and maintain Excel “smart sheets” in concert with T-SQL procedures to grant end users convenient ad-hoc, self-serve reporting.

 Develop, maintain, and analyze Crystal reports for financial, business, and real estate reporting. Create, maintain, and analyze T-SQL scripts, functions, and procedures for interface with Crystal Reports and SoftPro Select Application. Develop customized reporting solutions based on requirements from multiple users using SQL Server. Analyze and created new T-SQL queries to improve design performance and design complex reports. Design, code, test and document all new reports, applications, and programs.

Developed architecture roadmap for IBM Cognos environment.Develop, maintain, and analyze Crystal reports for financial and business reporting.Validated data element conversion rules leveraging Mainframe, SQL, MS Access, and MS Excel to extract and analyze data and by working closely with Business Analyst, Systems Analyst, Software Engineers, and business users.Provided business and financial reporting and analysis to determine trends, discrepancies, and conclusions to Senior Management and Executives.Translated end user reporting requirements into technical design documents

Develop, maintain, and analyze Cognos reports.Increased efficiency and quality of financial reporting systems by coordinating and implementing solutions using knowledge of database design and report design.Defined and implemented processes necessary for sourcing and reporting various metrics and financial data.Successful liaison with internal and external auditors; no unsatisfactory audit results during tenure.

Raleigh-Durham, North Carolina Area

Worked as admin for head of Business Underwriting

Inventory, employee supervision and scheduling, outstanding customer service.