Data Developer
Resume:
Steven M. Baer
Lowell, Mass. 01854
email:*********@*****.***
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