David Nell Email & Phone Number

Glen Gardner, Nj, Us

Glen Gardner, Nj, Us

Ch

Ch

After the merger of Chubb and Ace Insurance Groups a project was launched to integrate the data into a single data warehouse. A separate project was launched to produce a single source Federal and State Reporting Data Mart. As part of the Statistical Reporting Group was responsible for creating business requirements documents for all Auto, Personal lines, Inland Marine and Home Owners as well as state specicific documentation for Texas and Massachussetts from ISO STAT Plans. Currently this applies to Premium only however the documentation has been prepared in anticipation of Claims reporting due to begin later in the project. In consultation with business end users gathered business rules as per various corporate ISO Agreements across various systems and platforms. Activity included end to end data mapping, creating data definition load tables, lookup tables to translate data into ISO code values, creating the extract SQL for the various Statistical Reports and methodologies to manipulate, transform and validate data. Utilized Excel, IBM Netezza, SQL, SharePoint.

Wilmington, Nc, Us

Data analysis, gap analysis, documentation, training materials etc. relating to GSDA system. Excel mini applications to format/interpret/post clinical trial applications and results. Data file mapping, creation. Oracle, SQL SMS, EXCEL, VBA.

Raritan, Nj, Us

Support / maintain processes around Consumer Sales Reporting, Data Integrity, Compensation Administration, Analytics, Data Maintenance, & other Sales Operations related information requests. Assisting in management & support of the company Consumer Sales information systems & related functions. Developing, implementing, and maintaining data edit check processes to ensure data quality and completeness. Support field sales in the investigation and resolution of sales inquiries through data intelligence gathering. Mining data and building data queries to understand complex database structures. Participating and leading in sales reporting meetings with internal and external business partners, management and technical consultants. Providing tactical project planning & interaction with customers in order to support business requirements. Excel (VBA, Macros and SQL), PowerPoint and Access (VBA, OBDC, SQL), Oracle 9i (Using TOAD), Snrgy Sales Force.

Charlotte, Nc, Us

Provided data sets for ORGVUE and ORGLAB product assessments. Located, mapped, extracted, cleaned, scrambled, created and loaded data as required. Assisted in product assessment, created and ran test scenarios and scripts within product. For the Shared Services Project provided detailed project, performance, funding and resource analysis across all services and projects for senior management.For Workday Phase2 Reporting created data-maps linking existing reports to business objects in Workday for Personnel, On-boarding and Recruiting Modules. Assisted in creating HLD’s (High Level Documentation) for reporting structures from gathered requirements documentation.

Philadelphia, Pennsylvania, Us

Data Analyst for the Prima-Web Application Project Team. Analyze, create, repair and transform legacy and new data. Create nutritional information tables, identify, quantify and delete erroneous and duplicated vendor and manufacturer data for vendors and franchises. Provide data analysis and insight for client divisions and management. MS SQL Server 20102, Showcase, T-SQ L, EXCEL 2013, Macros, VBA.

Conshohocken, Pa, Us

Data Quality Analyst for MDM Project. Import and Profile ERP Data. Provide data set and record level profiles and issues affecting merge to Informatica MDM. Achieved using MS Excel and ACCESS 2007. Import data is run through a series of queries to test each field to be merged. Results are output to Excel based Profile Report and Issues report for adjudication by Data Governance. Data set profile generated by ACCES Report to PDF and Excel.

Bloomfield, Ct, Us

Data Analyst (Agile Environment)Soft Skills Utilized: Data, Business, Systems, Reporting Analysis. Developer. Downstream Customer Centricity.Data Analyst for the AXCELRX Project (Data Profiling Team). Scrubbed ,mapped, transformed Pharmacy and Benefits data from internal and external data (Oracle, VSAM, Text and Excel Files and Tables) sources to create and complete commercial business lines data for further team and downstream analysis. Created data catalogs for various business lines. Performed QA on all datasets and output generated by the Team. Created an Analysis Application to revue Pharmacy and Benefit Plan Comment Data using VBA, VLookup and HLookups in Excel 2010. Created Excel Standard Reports Catalog using VBA and Pivot Tables. For data migration effort, created various Client and Account reports pertaining to Pharmacy and Benefit Plans including detailed Excel Score Card Reports using Pivot Table based Graphs. Analyzed score card data to determine complexity, incidence, spread etc. and represented findings using Graphs and Pivot Tables for downstream partners and senior management (Excel 2010 and PowerPoint). Used TOAD Editor, Oracle, SQL, Excel 2010, ACCESS and MS Powerpoint 2010.

Sayreville, Nj, Us

(Consultant) SABERT Inc. November 2013 – January 2014DeveloperSoft SkillsUtilized: Data and Business Analysis. Developer. Customer CentricityDesign and Create an Excel application to Import SAP data, check for duplicates, compare to an existing array of valid items, Test the validated data against formulas and values in the adjoining worksheets, return the values and test them for consistency, output the result to a new workbook showing results of that determination as well as the results of the de-dupe and valid/invalid items.

Center Valley, Pennsylvania, Us

(Consultant) Olympus Medical November 2012 – November 2013Financial Reporting AnalystSoft Skills Utilized: Data, Reporting, Business Analysis. Developer. Customer Centricity.Repair/creation and enhancement of proposed and existing ACCESS Databases and Excel based applications including Pricing Calculators for field reps (EXCEL VLookups, embedded Showcase SQL, embedded VBA code pivot tables and macros), Expired and current contract waterfall and forecast pivot tables and dashboards, Audit Databases, Contract and Customer Service Databases (ACCESS, VBA, macros, OBDC), OBDC linked databases creating and e-mailing customer contract compliance letters (ACCESS, VBA, OBDC, macros), call center agent statistical performance tool (ACCESS, EXCEL, VBA, macros, Vlookups, OBDC, Showcase) as well as ad hoc queries against JDE using Showcase regarding pricing, contracts, commissions etc. Data gathering, business analysis, project estimation and documentation of the above.

Brentford, Middlesex, Gb

(Consultant) Glaxo Smith Kline November 2011 – January 2012Data AnalystSoft Skills Utilized: Data Analysis.Scrub client data against field sales client data to confirm matches using fuzzy logic ,V and H Lookup in MS EXCEL 2010 to locate appropriate data to verify accuracy against web and client tables in Oracle 11i (PL/SQL) for Sunshine Transparency Program.

Dallas, Tx, Us

(Consultant) AT&T Global Project Management March 2012 – May 2012Data/Reporting AnalystSoft Skills Utilized: Data Analysis. Customer Centricity.Responsible for the Key Metrics report. This report measures projects globally with respect to every product, installation, completion, new sales, opportunities identified, on time performance, customer satisfaction, project status, project sites etc. Report consisted of 40 tabs and rolled up Pivot Table results from lead project managers to area managers to directors to VP level. Created crosstab and nested queries in ACCESS, imported and validated data from PICS System for use in ACCESS and EXCEL report. Used VLOOKUPS and macros. Debugged and created processes in ACCESS.

New York, Ny, Us

(Consultant) Morgan Stanley Smith Barney April 2011 – Oct 2011ACCESS 2010 Developer/Data/Reporting AnalystSoft Skills Utilized: Data, Reporting, Business, Systems Analysis. Developer.For the Global Wealth Unit designed and created an application in ACCESS 2010 to measure all system aspects of the Branch Workflow Project, across all servant regions, globally. Application imports mainframe and server data to measure system health, user counts, transactions, response times and abend/outage frequency etc. Application generates reports and pivot charts from production, development and test environments on a daily/weekly/ad hoc basis for CIO and MD. Application consists of approximately 500 objects including data validation on import streams, table creation for specific charts, user interfaces to parse parameter data, embedded macros, VB code, queries for pivot charts and tables, embedded metrics, data transformation/creation within tables as well as print routines to PDF and generated e-mail notifications. Created SOP’s, reference material, normalized tables, developed testing procedures, embedded macros to prepare data in pre-import spreadsheets, backup/archive procedures and databases, disaster recovery process, full system documentation and training material. Performed offshore training via Live Meeting.

Dallas, Tx, Us

(Consultant) AT&T – BVOIP Business Unit May 2007 – May 2009ACCESS/EXCEL 2003 Business/Data Reporting Analyst (DBA)Soft Skills Utilized: Data, Reporting, Business, Systems, Process Change Analysis. Developer. Managed 2 Reporting Analysts.Provide dashboards (Powerpoint and EXCEL for use in corporate web site), metrics, pivot tables and production reports for BVOIP Unit relating to order fulfillment, Order Managers, Regional Sales, product lines/performance and customer impact on fulfillment for unit VP and Senior Management. Used Access/Excel 2003. Responsible for data quality and accuracy, ad hoc reports for senior management (VP Level and above) and generating new report/metrics as required by senior management. • Provided data, metrics, systems overview, workflow analysis and input (as SME) for the Six Sigma Cycle Time Reduction Team.• Provided analysis and solutions for issues affecting production, process and cycle times.• For the BVOIP Integration Team provided data support, metrics, system input and liaison to the BVOIP Unit.• Interacting with Management and cross functional teams to gather metrics, algorithims, data and requirements regarding production and productivity.• Translate business objectives and organization needs into clearly written business requirements and design.• Establish and create standards, performance metrics and reporting mechanisms.• Created product dashboards/scorecards to track performance improvements, lifecycles, in process metrics and workload impact for VPs and corporate website.• Provided data normalization and requirements for ROAM Database.• Provided algorithms and metrics for production measurement and evaluation.

Newark, New Jersey, Us

Graduate Certificate In Business Analysis, Business Analysis

Mba, Business Administration And Management, General

Diploma In Applications Programming/Systems Design, Programming Languages And Application Design