Resume

Sign in

Data Developer

Location:
Saratoga Springs, New York, United States
Posted:
April 12, 2018

Contact this candidate

Resume:

Steven M. Baer

** ******** ** #***

Lowell, Mass. 01854

603-***-****

email:ac44f5@r.postjobfree.com

JOB OBJECTIVE:

To apply and enhance my data visualization skills utilizing Tableau desktop.

QUALIFICATIONS:

Over 19 years experience in software development including the last 14 years during which I have been exclusively dedicated to data warehousing. Particular strengths and competencies include:

Database application design and development

Data Warehouse and Data Mart design and development

Create interactive dashboards using Tableau

Sophisticated Online Analytic Process Query design and development

Software development for mission critical on line transaction processing systems

Requirements gathering and system analysis

Excellent written and verbal communication skills

CERTIFICATIONS

Tableau Qualified Associate version 10 obtained from Tableau December 2016

COMPUTER PROFICIENCY:

Data Visualization: Tableau version 10.0.2, versions 6 – 9

Operating Systems: Unix AIX 4.2, Solaris 5.6, Windows NT, Windows XP, 2000

RDBMS: Teradata, Netezza, Oracle 11g, Microsoft SQL Server 2008, Sybase Adaptive Server Enterprise 12.0

Development Tools: SQL, PowerBuilder 5.0, 4.0, Clipper 5.x, ‘87, SAS 7.0, IBM ScreenReader 1.2

OLAP Tools: Cognos 8 (version 8.4), PowerPlay and Impromptu, Business Objects XI (release 3), BrioQuery Designer and Explorer 6.1, 5.5.6, Information Advantage 1.2, R&R Report Writer

Modeling Tools: Powersoft Warehouse Architect, Erwin

Other Applications: MS Office

PROFESSIONAL EXPERIENCE:

Optum Latham, N.Y.

9/2016 –

Tableau Developer

-Create dashboards using Tableau version 10

-Offer guidance and mentoring to less experienced Tableau developers

-Provide technical assistance that leveraged my experience as a data warehouse developer

-Perform QA on colleague workbooks to verify data accuracy

-Review colleague workbooks to ensure look and feel conformity

Cisco Systems Boxborough, Mass.

6/2012 – 9/2016

Tableau Developer

-Create dashboards using Tableau

-Offer guidance and mentoring to less experienced Tableau developers

-Develop Tableau standards to establish a consist look and feel to the suite of dashboards developed

-Provide technical assistance that leveraged my experience as a data warehouse developer

Content Admin

-Create groups

-Add users to groups

-Set permissions

-Repoint and publish workbooks to production environment

-Schedule workbooks to be refreshed on the server

UHealth Solutions Worcester, Mass.

4/2011 – 4/2012

Tableau Developer

-create dashboards using Tableau with drill through functionality to the underlying data

oprototype and demonstrate various data visualizations options to the users

ounit test developed reports

-develop strategies for delivering highly responsive interactive dashboards

-create stored procedures on SQL Server 2008 to populate database objects that are used as the source of data for Tableau

oanalyze on-line transaction processing system to determine which data elements were required to support the report specification

obuild indexes as appropriate on database objects to increase performance

-meet with users to define their requirements and undergo an iterative process to review proposed report layouts

-prepare documentation specifying the content of the report for the Quality Assurance team

-perform bug fixes as reported by the quality assurance team regardless of report author

Blue Cross Blue Shield Boston, Mass.

9/2010 – 3/2011

Data Warehouse Production Support

-revise Oracle Data Integrator ETL routines according to specifications

-Administer and execute ‘groupers’ made by Ingenix and Milliman

oResolve questions presented from the user community

oInteract with the ETL developers to ensure the applications were supplied data in the appropriate fashion

-execute and monitor Unix based routines on an off hours basis

Mass. General Hospital Charlestown, Mass.

9/2009 – 8/2010

Database / Report Developer

-convert existing Cognos 8.2 reports to Cognos 8.4 with drill through functionality to the underlying data

-develop reports using both relational database tables and cubes as the source of the data

ounit test developed reports

operform quality assurance on colleagues reports

-respond to potential issues with production reports.

oAnalyze the issue and take corrective action if appropriate or explain to the initiator why no action is necessary

Epsilon Wakefield, Mass.

7/2007 – 8/2009

Database/Report Developer

-write functional specifications describing specifically the content the report will deliver

-test the Business Objects Universe or the Cognos FrameWork Manager Model for accuracy

-develop custom reports using Cognos 8 (version 8.3) or Business Objects (XI release 3) to satisfy reporting requirements based on client specifications running against Netezza or Oracle databases, generally.

-develop and test SQL scripts to load data into summary tables to provide more rapid response for reports

-review client data requirements to determine whether or not existing Epsilon reporting suites can satisfy the client needs or new reports will need to be developed

Boston Medical Center HealthNet Plan Boston, Mass.

8/2005 – 8/2007

Data Warehouse Developer

-develop data marts based on interviews with the companies business community

-create stored procedures on Microsoft SQL Server 2000

ocreate data extracts to support fraud prevention initiatives

ointegrate data feeds to support disease management initiatives

-create ETL routines utilizing Microsoft SQL Server 2000 Data Transformation Services (DTS)

-create reports using Cognos ReportNet

-create a data dictionary illustrating the flow and changes the data underwent from the source systems to the data warehouse

Private HealthCare Systems Waltham, Mass.

8/2004 – 8/2005

Data Warehouse Developer

-analyze the source data available and develop ETL routines utilizing Data Stage that would bring client data into the data warehouse environment.

-resolve questions with regard to content of the data in the Oracle database

otroubleshoot Oracle packages

-respond to requests for information and generate the appropriate data content in order to prove to clients the effectiveness of the companies managed medical care programs

Orange The Hague, The Netherlands

3/2001 – 7/2002

Data Warehouse Designer

- responsible for the development of reports using Business Objects and the supporting tables or views that allowed Orange to respond to inquiries from the Police and Justice Departments

- responsible for the monitoring of critical PowerMart processes.

-reconcile differences between the source system and the data warehouse.

United Behavioral Health San Francisco, Ca.

5/1991 – 12/2000

Senior Software Engineer 1997 - 2000

- responsible for the design, coding, testing, documenting and implementation of programs that extracted, cleansed, transformed and produced loadable data files from a major source of data from a legacy system for the operational data store of the data warehouse. These extraction programs ran weekly and the files were automatically ftp’d to the appropriate Unix box ranged in size from 30 mb to 1.5 gb

- responsible for the development of data marts. This included tasks ranging from requirements gathering, specification documentation, data modeling, coding and testing of programs, development of queries to provide answers to the business questions supported by the assembled data mart.

- pioneered efficient methods and processes to ensure the success of the mission critical weekly data extraction programs.

Software Developer 1993 - 1997

- responsibilies included designing, coding and testing of programs that were incorporated into the mission critical on-line transaction processing claims payment system in a dBase environment.

- supported a client-server application which entailed software development and releases of enhanced versions of software using PowerBuilder as the development tool.

Business Analyst 1992 - 1993

- acted as a liaison between the claims department and the software development team. Provided the programmers with requirements and specifications for system enhancements.

- authored reports for the claims department, tracking examiner productivity, claims status reports, reports documenting compliance with performance standards.

Claims Examiner 1991 - 1992

- processed health care claims, developed documentation to assist examiners in processing of new benefit plans.

Claims Service Resource Group Concord, Ca.

1987 - 1991

Claims Examiner

- responsibilities included acquiring working knowledge of a clients claim processing system and familiarization with the benefit plans for the purpose of providing fast and accurate claims processing. This position oftentimes entailed significant travel.

University of Houston Houston,Tx

Bachelors of Business Administration

Concentration in Finance – graduated May 1981



Contact this candidate