CAREER SUMMARY:

An IT business systems and data analyst with a strong technical background and thirty nine years of IT experience including positions as business systems analyst, data analyst, developer and in quality assurance testing. Specializing as liaison between business partners and technical staff. Extensive experience working with end - users and business clients gathering and formalizing business requirements, designing system specifications, writing formal technical design statements, documenting system processes, analyzing data, designing data structures, developing SQL queries, creating test plans and performing user acceptance testing. Excellent written, verbal and interpersonal skills.

SOFTWARE EXPERTISE:

Extensive use of: SQL in a variety of software environments, such as SQL Server, Teradata, Netezza, DB2, Oracle and AWS Athena.

Fluent in the: Microsoft Office Suite including Microsoft Word, Microsoft Excel, Microsoft Power Point, Microsoft Project, Microsoft Visio, Outlook and Skype.

EXPERIENCE:

Confidential

Senior Data Analyst

Responsibilities:

• Performed numerous data analysis tasks such as debugging, correcting and testing scripts, data profiling and source to target mapping.
• Utilized SQL in a Netezza, JIRA and Agile environment.
• Performed various data discovery tasks on a project to migrate Confidential data into Salesforce/Vlocity.
• Tasks included attending discovery meetings to gather requirements, creating current state data process flow diagrams, future state data process flow diagrams and a Practitioner logical data model utilizing MS Visio.

Confidential, Newark, NJ

Senior Data Analyst

Responsibilities:

• Performed extensive data profiling and source to target data mapping on a long term project to create a state of the art Hadoop/Hive data lake for adjudicating and processing medical and pharmacy insurance claims.
• Input files were received from various sources in both mainframe and json formats.
• Data profiling was performed on traditional mainframe files loaded into Teradata tables and json files loaded into tables on Amazon Web Services (AWS) and accessed through Athena. IDQ output was also utilized as an aide in data profiling.
• Responsibilities also included creating DDL for various intermediary views, creating SQL scripts for intermediary view to target table data loading, performing data validation in target tables and creating detailed, step by step documentation for various in-house processes.
• Utilized Teradata, AWS, Athena, Jupyter Notebook, LucidChart, Google Docs, Google Sheets, JIRA, Zoom and Slack in an Agile environment.

Confidential, San Francisco, CA

Senior Data Analyst

Responsibilities:

• performed extensive data profiling and source to target data mapping on a short term project to assist Confidential in assimilating Care1st data.
• Confidential had recently purchased Care1st and scores of health care data files, including EDI 837 transactions, needed to be mapped and loaded into Confidential 's book of record data warehouse.
• Performed in depth data analysis utilizing SQL and "Aginity Workbench for PureData System for Analytics" in a Netezza, JIRA and Agile environment.

Confidential, Philadelphia, PA

Senior business systems analyst

Responsibilities:

• worked directly with systems architects in developing technical requirements for various new systems interfaces and developing new process flows for a new on-line billing system.
• Responsibilities included communicating with an assortment of disparate groups both inside and outside the company to determine and document technical requirements, creating use cases and user stories in an Agile environment, creating multi-layered process flows, performing extensive data anaysis using Excel and SQL in Oracle and SQL Server environments, data modeling for new data marts and data mapping from various data sources to target tables.
• Utilized Toad in an Oracle 12c environment, SQL Server Management Studio 2012, ERwin, Visio, Rally and the Microsoft Office Suite.

Confidential, Trevose, PA

Senior Data Analyst

Responsibilities:

• Performed extensive data analysis and quality assurance testing on a special short term project to reduce a backlog of problematic data integrity issues throughout their corporate data warehouse.
• After successfully eliminating the backlog issues, went on to perform quality assurance testing on a wide range of code modifications and marketing campaign enhancements.
• Responsibilities included validating technical requirements, performing extensive data profiling, identifying data anomalies, investigating causes of erroneous data, creating test data, testing various programs, logging trouble tickets and assigning corrective requirements to various developers.
• Utilized PL/SQL Developer in an Oracle 12c environment & JIRA.

Confidential, Somerset, NJ.

Senior Business systems and Data Analyst

Responsibilities:

• designed and developed technical specifications for a number of new data mart initiatives for various business intelligence and marketing projects.
• Responsibilities included gathering business requirements, writing functional requirements documents, negotiating and writing interface agreements with various business partners, data profiling and analysis, creating entity relationship diagrams, data modeling (designing data structures and their inter-relationships) for new data mart, creating high level design diagrams, data migration data mapping, developing DDL scripts, creating SQL code to load various tables and materialized views, creating test plans, creating test data and queries and performing user acceptance testing.
• Developed DDL for an extensive materialized view which included complex calculations for over 170 key performance indicators to be used in a new business intelligence reporting system to be built on various reporting platforms.
• Utilized Advanced Query Tool and SQL in an IBM DB2, Netezza and SQL Server environments.

Confidential, Plymouth Meeting, PA

Senior Business Systems Analyst

Responsibilities:

• documented existing processes and gathered and formalized business requirements for this health care assistance company.
• Created a very detailed 105 page, step by step user manual for this firm's complicated, custom in-house ETL process.
• This user manual enabled new employees to easily get up to speed and perform the ETL process without assistance from others, saving senior personnel significant mentoring time.
• Other responsibilities included conducting business requirements gathering meetings and formalizing detailed business requirements for an internal cost study, supervising a developer during system development, creating system test plans and performing extensive data analysis and user acceptance system testing.
• Utilized SQL and Microsoft SQL Server Management Studio in a SQL Server version 10 environment.

Confidential, Philadelphia, PA

Senior Business Systems/Data Analyst

Responsibilities:

• created test data for a large user acceptance testing effort in support of a newly developed on-line transaction system.
• This system allows doctors to manage their accounts, pay fees and register for exams for various medical certifications.
• Responsibilities included interpreting dozens of business use cases and numerous business rules and incorporating them into various test case scenarios.
• Utilized SQL and Microsoft SQL Server Management Studio in creating test data meeting specific test case criteria in a SQL Server environment.

Confidential, Philadelphia, PA

Senior Data Analyst

Responsibilities:

• performed extensive data profiling using SQL while performing data mapping and data migration of Confidential 's Oracle data warehouse to Catalyst's Oracle data warehouse with snowflake schema and type 2 dimension tables containing both surrogate and natural keys.
• Developed extensive data mapping spreadsheets with transformation rules.
• After Catalyst was purchased by Confidential, performed additional data profiling while data mapping and migrating Catalyst's Oracle data warehouse to Confidential 's (now Confidential 's) Netezza data warehouse.
• As senior business analyst, met with business partners gathering and formalizing business requirements for various management and client facing reports sourced from the new data warehouse.
• Additional responsibilities included participating in data warehouse design sessions, organizing and leading requirements gathering meetings with business partners, tracking open issues, writing formalized business requirements documents (BRDs), leading requirements review sessions, presenting BRDs to stakeholders for approval, writing functional requirements documents (FRDs), presenting FRDs to technical staff, managing developers, creating test plans, performing UAT testing and creating defect tracking spreadsheets.
• Utilized PL/SQL Developer for Oracle queries, Aginity Workbench for Netezza for Netezza queries, Ab Initio for ETL mapping and Microsoft Office Suite 2007.

Confidential, Philadelphia, PA

Senior Business Systems Analyst

Responsibilities:

• performed extensive data analysis on a very large Teradata data warehouse.
• Responsibilities included mapping numerous data elements between various databases within the warehouse, creating transformation rules (T-rules) as required, creating and publishing monthly release bulletins and performing various change management tasks.
• Extensive use of SQL in a Teradata environment.
• Utilized Teradata SQL Assistant, MS Word & Excel.