Sr. Data Analyst

Ed Betamour, MBA/ME

*** **** **** ****, ******* – NJ 07436

Tel: 973-***-**** (cell)

Email: **********@*****.***

******.********@*****.***

Professional Experience

Anthem – NY, NY

Oct 2015 – Present

Business Information Consultant/Health Care Analytics

Work with the different business areas to capture, analyze and create reports. Responsibilities include:

Perform data analysis

Provide technical analysis and support.

Create Reports.

Automate processes.

Key accomplishments:

Built automated data pull and report generation processes by using excel VBA to connect to SAS and Teradata servers.

Created process for monthly Medicaid Rx reports.

Created process for quarterly Medical and Rx reports.

KPMG – Woodcliff Lake, NJ

Dec 2014 – Sep 2015

Data Analytics/Audit Data Analyst

Work with the Global Service Centre’s KAAP support team. Responsibilities include:

Perform data analysis (profiling, gap checks, check for quality and consistency of data and formats)

Perform data lineage analysis using XML parsing of SQL stored procedures.

Provide technical analysis and support.

Database management, writing/modifying SQL stored procedures.

Automate data test processes.

Manage client relationships in support of KAAP processes.

Key accomplishments:

Built user raw data retrieval process connecting excel and SQL server for routine testing and validation purposes.

Healthfirst Management Services LLC – NY, NY

Oct 2013 – Dec 2014

Enterprise Data Steward/Data Analyst Senior

Started as a Sr. Analyst and moved into the Enterprise Data Steward role within 8 months working on projects under the Enterprise Information Management and Data Governance initiatives. Responsibilities include:

Act as liaison between business units and IS.

Manage and guide data stewards.

Conduct data analysis (source to target mapping, data profiling, identify critical data elements, performing data gap checks, perform necessary data transformation)

Manage and maintain enterprise business glossary terms (business definitions and rules, data lineage).

Work with ETL and Data Model teams.

Built Data Quality edits for data elements and business quality rules.

Helped in creating UAT test cases.

Key accomplishments:

Helped in the design of Metadata repository system used for capturing business data definitions, rules, and data linage.

First American Financial Corporation/Data Trace – North Haledon, NJ

Jan 2010 – Oct 2013

Business/Data Analyst Senior

As a data analyst managing internal data audit/ remediation projects. Additionally working on data conversion projects of external data files from different counties/ sources. Responsibilities include:

Conduct data analysis of raw data and create standardization and conversion rules. Also, identify new data sources that can complement or validate our data.

Identify and Implement solutions, procedures and processes to address data quality issues under audit/remediation projects.

Write complex SQL queries, stored procedures and functions to summarize, test and profile the data.

Investigate and research data for future product development.

Work with DBA programmers to streamline data management and data handling processes.

Develop and maintain conversion SQL databases.

As a business analyst taking on the responsibilities of translating business unit requirements into technical specifications and creating process/product documentation. Responsibilities include:

Perform information gathering and research on target areas for business expansion and negotiate with vendors or government agencies for information as required.

Provide programmers and developers with product specification/documentation to build applications.

Streamline and enhance processes by identifying and eliminating bottlenecks and non-value adding steps from processes.

Act as liaison between business unit and IT groups.

Identify and initiate contact with source vendors and suppliers.

Key accomplishments are:

Reduced the conversion process time from average 6 to 8 months to an average of 1 month.

Managed to collect raw data for 4 counties covering 10 years of data per county and then standardized the raw data into a structured data file with defined data fields ready for conversion.

Created SQL scripts that parsed complex raw data strings into structured data elements.

Helped in creating name string parsing process and developed the SQL scripts necessary for the process.

ASCO Valve – Florham Park, NJ

Sep 2008 – Jan 2010

Senior Product Engineer (Agency Approvals)

Review agency approvals standards (UL 429, CSA 139, CSA 6.5, FM 7400) to ensure products are in compliance.

Work with project engineers and marketing teams on product design requirements.

Review product test records to ensure compliance with approval agency standards and requirements.

First American Financial Corporation/Data Trace – West Orange, NJ

Oct 2004 – Sep 2008

Operations Manager/Technical/Data Analyst

Managed a group of 10 researchers from 2004 to 2007 under the operations manager role of the NJ research center. Also worked with other research centers providing documentation, training and support to on shore and off shore teams. From 2007 to 2008 I transitioned into a technical/data analyst role working on audit/remediation projects to clean databases and ensure the data complies with company standards.

Key accomplishments are:

Proposed switching the process of handling and working Exception Reports from paper print outs to an Electronic Data file. This proposal was implemented and the exception reports were eventually brought into an Access database environment where on shore and off shore teams managed the reports in much more efficient manner which resulted in big time and money savings for the company.

Changed/adjusted the process in 2 NJ counties by introducing the concept of keying temporary data to ensure our databases in these 2 counties remained close to the actual County Clerk database. Also provided the instructions on the how the new process works and established a necessary data matrix structure for the process.

Helped in the creation of a new quality assurance research center to handle the NJ title plants.

Managed the monthly data updates of the Recognizance Bond database.

Oversaw the on-going development and distribution of the NJ map browser, a research tool used in the built of NJ title plants.

Provided the analysis and technical support for the NJ/NY Starters project. Also worked with data entry programmers to create edits that ensured the quality of the data records.

Managed the keying of historical tax records projects in NJ and created audits to ensure data completeness and accuracy.

Helped in the creation and training of an “expert” team in India to help our on shore operation teams in managing daily data processing and quality issues.

Participated in weekly meetings with off shore vendors to review progress/issues and provided training and support when necessary.

Provided extensive data analysis on Atlantic and Burlington counties index conversion projects and established rules for data formats and data mapping.

Proposed changes to processes in OCR counties in NJ and worked with data entry programmers to implement the changes which resulted in 40% to 50% improvement in data processing time.

Worked on the NJ historical tax records audit project and created a process that enabled management to track and audit vendor work to ensure the completeness and accuracy of the work.

Gas Purification Engineering Corp – Irvine, CA

Jan 2002 – Jan 2003

Mechanical Project Engineer

Performed engineering calculations for gas system (flow and pressure calculations), design piping systems, and size pressure vessels.

Reviewed quotation requests and process specifications, prepared equipment estimates, created bills of material lists, and prepared proposals.

Prepared equipment general layout drawings, process and instrument drawings (P&ID), process flow diagrams (PFD), and preliminary engineering drawings.

Provided support to start-up and service engineers, and helped in equipment installations.

Coordinate with suppliers and vendors and provide technical support to customers.

DURR Environmental Inc (REECO) – Bridgewater, NJ

Jan 1998 – Nov 2001

Jr. Mechanical/Applications Engineer

Helped in the creation of a sophisticated thermal oxidizer sizing program (I worked on the math and general PDF and P&ID drawings) which reduced the annual man-hour spent in sizing calculations and generation of process flow diagrams by 50%. Responsibilities included:

Performing energy and mass calculations, design fume incinerator and industrial ventilation duct systems including thermodynamic and flow calculations, sizing fans, combustion, and pneumatic system components.

Managed the supply of proprietary rotary valves for the Asian market. Duties included communicating with our Japanese customers, customer training and support, and coordination of international shipping arrangements.

Prepared industrial air pollution control system estimates, detailed bills of materials, spare parts lists and proposals.

Provided support to start-up and service engineers, helped in equipment installations and collected field data for analysis.

Assembled, prepared and issued operating and maintenance manuals.

Education

New Jersey Institute of Technology, MBA, 2009

New Jersey Institute of Technology, B.S. Mechanical Engineering, 2001

Skills

MS Office (excel pivot tables, macros (VBA), look ups, functions and formulas, conditional formatting, visualization/charts), power point, Tableau, MSSQL Server 2008, T-SQL, writing SQL queries, creating SQL stored procedures and functions, Netezza (Aginity), Teradata, SAS EG and Base SAS, Informatica’s Metadata Manager/IDQ Developer and Analyst tools, Data Analysis, Business Requirements Research, Process Documentation, analytics and reporting (designing reports and dashboards).

Contact this candidate