CONSULTANT Summary College graduate interest insurance claims work. Proven record success endeavors. Strong work ethic focus details. Excited begin career investigative work. Searching entry level position insurance claims adjuster. Skills Unix, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, VM-Ware, ODBC, SQL, PL/SQL, Access, MS Office Suite, MS Visio, Oracle 10g, Oracle 11g, SAP Business Objects BI Suite, PeopleSoft, ADP, cView SAP Business Objects Suite, MS Reporting Suite, MicroStrategy, MS Office Suite, Tableau Industry Software: SQL Server Studio, EmpCenter, CQCS, DNA, DNA-sme, IMC, eSoms, cView Web Design: Internet Explorer, Netscape Navigator, Chrome, Firefox, JAVA, ASP.NET, HTML Operating Systems: MS Windows Professional/Enterprise/XP/7/8, NT, Novell NetWare Server Environments: SQL 2008, SQL 2008R2, SQL 2012, Oracle 11g, Oracle 11g2, RPG Metadata, SAS, PeopleSoft, ADP, Ceridian Encore, SSRS, SSAS, SSIS, ETL, Access, Excel, Teradata, Crystal Reports, ServiceNow, SharePoint, Cyberquery Experience Consultant 07/2016 Current Company Name City State Top 4 Financial Institution) Create SQL queries, stored procedures, tables extract data Analyze data create executive team dashboards daily visualizations Utilize Excel pivot tables monitor observations within Core Finance metadata template Analyze Core Finance GBAM Americas feeds manual spreadsheet remediation Support data stewards review various domain issues vlookups extractions Document process improvements enhance data integrity Conduct data reviews ensure data quality reasonability data feeds supplied EDM Generated trend reporting assist reducing number feed gaps Environment Access, Excel, SharePoint, SQL Server, Metadata, Teradata, Adaptive. Database Analyst 04/2016 07/2016 Company Name City State Provided technical support basic development computer applications programs Documented technical specifications design redesign complex projects applications Analyzed complex computer application problems maintain restore functionality Led resolution complex issues escalated needed meet established SLAs Prepared programming specifications completed programming tasks develop basic, and/or assist development moderately complex, computer solutions Prepared program test data, tests debugs programs using Waterfall methodologies Updated completed documentation, procedures user guides ensure data quality Participated testing updating business continuation plan Planned analyzed highly complex business requirements Environment SQL Server, Teradata, Oracle 11g, Oracle Discoverer, MicroStrategy 9.3.1, Metadata, BMC Remedy. Senior Business Intelligence Analyst 02/2015 04/2016 Company Name City State Developed enhanced WebI reports universes Business Objects Provided technical support triage database performance reporting related issues Reviewed interpret report SQL determine data source business logic Conducted report requirement gathering sessions project business SMEs Compiled report mapping legacy reports aid Change Management communication Quality Assurance tested additional objects universe structure ensure data quality Created functional technical specifications according business requirements Conducted unit system tests various technical tools including SSAS Collaborate Business SMEs develop report testing strategy using Agile methodologies Conducted UAT Business units Quality leaders Performed various tasks throughout Software Development Life Cycle (SDLC) Environment SQL Server, Oracle 11g, Business Objects WebI, Tableau 9.0.1, ServiceNow. Reporting Analyst 10/2013 02/2015 Company Name City State Reviewed translated current state Business Object/Crystal Reports/Report Builder/MSRS Reviewed interpreted report SQL determine data source business logic Conducted report requirement gathering sessions business SMEs focus groups Developed new modify reports MSRS, BIDS, SQL Server 2008 R2 2012 Compiled report mapping legacy reports aid Change Management communication Designed, developed, implemented new existing interfaces ETL processes using SSIS Created Logical Physical Data Models utilizing ERWIN Developed implemented data warehouse tables views Metadata Created functional technical specifications according BRDs Created test plans validate adherence business requirements using HP ALM QC Conducted Unit System tests various technical tools including SSAS Collaborated Business SMEs develop report testing strategy using Agile methodologies Conducted UAT eSOMS Business SMEs ensure data integrity quality Environment ERWIN, eSOMS, SQL Server 2008R2, SQL Server 2012, SQL, SSAS, SSIS, SSRS, SAP BO Crystal Reports, MS Office Suite, MS Visual SourceSafe, MS Visio, TOAD. Business Analyst 04/2012 09/2013 Company Name City State Collaborated team members clients gather HR/payroll report requirements Created functional technical specifications according BRDs Configured screen layouts, dashboards, workflows, interfaces according HR specifications Developed enhanced reports using SAP Business Objects SQL, PL/SQL, Oracle Integrated developed HR reports SQL Oracle based ERP environments Analyzed query performance optimization using SSAS analytical tools Documented functional specifications procedural documentation HR BRDs Developed enhanced WebI reports universes Business Objects Provided technical support triage database performance reporting issues Created test plans validate adherence HR business requirements using SQL Conducted Unit System tests ensure data integrity various tools including SSAS Provided technical guidance direction peers Designed, developed, implemented new existing programs ETL processes using SSIS Environment SAP Business Objects BI, Visual Basic, SQL Server 2005, SQL Server 2008R2, SQL Server 2012, VM-Ware, ODBC, SQL, PL/SQL, SSAS, SSIS, SSRS, MS Office Suite, Oracle 10g, Oracle 11g, Oracle 11g2, JavaScript, PeopleSoft, ADP, Kronos, ETL. Business Analyst 09/1999 12/2011 Company Name City State Interrogated data domestic international banks credit unions including Fifth Third Manipulated large financial datasets utilized complex queries data transformations Cross departmental collaboration software development subject matter expert (SME) Collaborated team members clients gather document project requirements Acted liaison clients technical teams aid go-live transition Created functional technical specifications according BRDs Created Logical Physical Data Models utilizing ERWIN Developed enhanced reports using SAP Business Objects PL/SQL, SQL, Oracle Generated business reports including matrix, parameter reports, charts, drill functions Integrated developed reports SQL Oracle based ERP environments Designed conducted technical knowledge transfer sessions various client sites. Education Training B.S. Degree Information Management Systems Wayne State University City State Information Management Systems A.S. Degree Accounting Wayne County Community College MCL Distinction City State Accounting Skills ASP.NET, Business Objects, Crystal Reports, data warehouse, DNA, JAVA, JavaScript, SharePoint, MicroStrategy 9.3.1, MicroStrategy, Oracle Discoverer, Oracle, PL/SQL, PeopleSoft, pivot tables, SAP, SAS, Software Development, spreadsheet, SQL, SQL Server, Tableau 9.0.1, Tableau, technical support, Teradata, triage, Unix, Visual Basic, Web Design