Stephen Woolwine Email & Phone Number

Bristol, Ct

Maintained various PL/SQL programs for large media company. Developed new pipelines to support real time reporting.

Norwalk, Ct

Batch Load Development Developed 100+ table Oracle data mart to move Rental Car product team off of Excel based reporting. Effort included designing tables, views and procedures in Oracle to support the team’s analytical requirements. Tuned and refactored long running queries. Developed process to trigger loads based on the completion of financial and operational base data. Included automated reporting when errors occurred. Stored code versions in BitBucket git repository. Documented structures and lineage per data governance requirements. Tableau Developed Oracle reporting tableau dashboards for customer operations team. Effort included uncovering requirements in 100+ excel workbooks by conducting JAD sessions with power users. Designed report tables to rollup 100 million row tables using source-to-target specifications. Developed and tested 10+ dashboards based on table design. Managed 150+ views in Tableau for various teams across the organization. Developed Python script to auto-generate and publish extracts using the software API. Big Data Insights Led effort to expand Rental Car business team’s analytical capabilities beyond Oracle warehouse. Effort required designing structures to support the load of billion-row rate and web logs data into Hadoop (Cloudera) and Google BigQuery. Developed scripts to stage data in Hive and Google BigQuery to facilitate analysis through Tableau Dashboards. Managed deployment process with data engineering team. Project resulted in many new insights to improve conversion on site.

Englewood Cliffs, Nj

Lead business analyst for application service provider to corporate tax departments. 50% role of technical project management for internal and external development tracks. 50% role of writing functional requirements and technical designs. Delivered major upgrade to tax web document manager system using Asp.net / Vb.Net / C# pointing to a Sql 2005 database. Delivered requirements and prototype for new web application integrating Flash, Asp.net and Sql Server 2005.

Woodcliff Lakes, Nj

Technical lead for decision support web site project. Created Statement of Work for external development vendor. Developed estimates for development track. Led efforts to gather technical requirements from external data sources. Led design efforts to build data models for 100-table plus database, class diagrams for middle tier, and, site maps and page specifications for 2 Asp.net web sites. Led development effort utilizing Ajax scripting on the client, Microsoft Enterprise library components with Asp.Net 2.0 / C# / VB.net on the web server, and, Sql Server 2005 for the database. Project also utilized Sql 2005 Integration & Reporting Services. Received special “Encore!” award for contributions to project success. Led efforts to streamline release process. Team to evaluate CMMI level II application. Built web dashboard to track releases. Configured MS Project portal server for technical team.

Woodcliff Lakes, Nj

Managed release process for 15+ products developed by global services division of Big 4 accounting firm.

Greater New York City Area

Initially hired as a developer to enhance and maintain on-line learning platform. After a year, was promoted to Senior Software Engineer. Took on a lead role for two development initiatives: * Message Board Integration. Project involved integrating Kaplan's on-line classroom with a message board application hosted by Prospero Technologies (an application service provider). Initially, managed a series of JAD sessions with a user group to define the UI for the integration. Designed a set of components to capture classroom updates and push them to the message board via web services. Components used Soap messages to communicate between systems. Managed project rollout by participating in test design and solving configuration issues. Project significantly increased capacity for learning platform by moving heavy message board traffic to vendor. Integration has been proven extensible across many enhancements to the learning platform. Technologies used were Asp.Net, .Net Web Services, VB.Net and Sql Server 2000. * Learning Classroom Redesign. Project involved upgrade of classroom UI and port of 250+ pages from Asp to Asp.net. Managed initial estimates for development and qa resources. Also, participated in framework design sessions. As the project developed, managed issues and solved design challenges for team of 4 developers. Provided weekly status updates on development progress. Participated in design of test plan, including 3 test cycles to optimize performance of site. Project was delivered on time and within budget. During first week of rollout, users of the 250 pages reported less than 5 problems. Technologies used were Asp.Net, VB.Net and Sql Server 2000.

Herndon, Va

Designed, developed and tested web pages and components for telecommunication trading web site. Site required high quality code to ensure accurate and timely processing of bids. Backend processes involved summarizing activity for millions of call records. Helped design and implement homegrown XML/XSLT framework for displaying and updating data.

3/99-2/00 * Programming consultant to development team for commercial LIMS (Laboratory Information Management System) application. Project heavily utilized UML class diagrams to describe 40+ business objects. Business objects hosted on application server used to control and gather information from laboratory instruments. * Developed desktop application to automate the testing of business objects. Program used the type library's metadata to generate test modules. Modules were executed in batch during nightly the build test. Results were logged to a data store and viewable through a web interface. 10/98-2/99 * Programming consultant to development team for accounting software vendor. Designed and developed components of global billing system. System utilized database replication to synchronize billing information between stateside and European sales offices. 7/98-10/98 * Programming consultant to government contractor. Converted client-server document tracking system to comply with Y2K standards for Agency at Pentagon. Developed requirement and design documents according to DOD standards. 11/97-7/98 * Participated in design and coding of a contact management program for large pharmaceutical firm. Project utilized 3-tier framework with components accessed on a remote server.

Greater Chicago Area

Developed and maintained various office utilities for 500 users of trading organization. Developed and implemented client-server budget application for 50+ users.

Greater Chicago Area

Developed data input screens and reports for benefits consulting processing team. Processing required intricate mathematically algorithms to calculate 401K and pension earnings.

Master Of Science - Ms, Computer And Information Sciences, General

Bachelor Of Arts - Ba, Journalism