John Beirne Email & Phone Number

Lombard, Il, Us

* Responsible for gathering and assessing business large complex information needs and preparing system requirements. * Perform analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation. * Use data mining and data analysis tools. Review and validate data loaded into the data warehouse for accuracy. * Generate ad hoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts. * Integrate data from multiple sources to produce requested or required data elements. * Program and maintain report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resources. * Create specifications for reports based on business requests. * Interact with user community to produce reporting requirements. * Provide technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage.* Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses. * Maintain knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments.

Downers Grove, Il, Us

Performed data extraction on SQL Server Reporting Services (SSRS), Excel, and VBA reportingParticipated in the overall maintenance of existing software and hardware solutions, including training and deployment of all changes and upgrades. Participated in training of new employees.

Riverwoods, Il, Us

Continued primary support for New Accounts and Portfolio Verification Database and Exam Management Database. Transitioned to SAS programming to support, maintain and improve the Archer Scrub process and KRI reporting process. Added functionality to Archer scrub so it wouldn’t have to be repeatedly run for each Control Business Unit, just run program once for all. KRI, wrote code to eliminate manual Excel work to produce monthly reports. Produced daily SAR reporting using Tableau and Excel. Automated Complaints reporting using a cron job in Unix to run SAS program monthly.

Royal Oak, Michigan, Us

Contracted to Discover Financial Services to support databases for Business Risk Analytics & Reporting team. Primary support for New Accounts and Portfolio Verification Database and Exam Management Database, deploying many key updates including a major structural overhaul of the Exam Management Database.

Naperville, Illinois, Us

Supported several MS Access databases including the main database the company used. This database was created in the late 1990's, has a SQL Server back end and uses VBA extensively. Created new database that housed and tracked data that came from the firewall software used by PMAThis database imported from MS Outlook, cleaned up the data and exported it to SQL ServerCreated graphic reports to illustrate the data.

New York, Ny, Us

Created a database that enabled users to upload and manage large data files relative to compromised accounts. Worked with multiple tools and data resources (SQL Server, text, Excel) in order to aid the business with timely fraud reporting that went to external clients.Built models in Excel and/or Access that assisted in the automation of the various Fraud Operational functions. Supported several databases for the Commercial Card organization.

Riverwoods, Il, Us

Started as a contractor in May of 2006, got hired as an employee in April 2007. Worked on an MS Access database for the Problem Management department. Worked on reporting that goes to directors, VP's and the CEO.

Hanover, Md, Us

Contracted from TEK Systems to assume responsibility for existing Problem Management database (MS Access). Maintained database and later upgraded it to database industry standards. Created several new reports for Problem/Incident Management team and upper management. Hired by DFS in April of 2007. Transferred to Production Support Performance Measurement with the Problem Management database, where it was converted to a ColdFusion/SQL Server based web application. Responsible for monthly reports for directors, VP’s and Officers.

Pasadena, Ca, Us

Contracted from Titan Technologies to create and train staff in the use of a new MS Access database which tracked investment deals and portfolios, matching clients up with deals. Database tracked the lifecycle of the deal from initial conversation to sending closing documentation.

Diemen, Noord-Holland, Nl

Temp on assignment from Randstad Staffing. Responsible for development and maintenance of several MS Access databases, including automated email integration with Outlook. Updated weekly credit card sales process. Worked with external data sources for sales leads.

Access databases for small companies.

Chicago, Illinois, Us

Primary support for the Associate Incentive Database (MS Access), used each quarter to pay 2,000 associates incentive bonuses based on Individual, Team and Call Center Performance. Responsible for Ratings Distribution databases, publishing performance rating distribution charts on Team, Department and Call Center to U.S. Cellular’s intranet. Maintained Excel charts of database back end compacts and repairs.

Access databases and websites for various small companies.

Worked on Access and Lotus Notes databases.

Providence, Rhode Island, Us

Worked on several Paradox and MS Access databases and the banks Intranet.

Chicago, Il, Us

COBOL/CICS support and created a database using Paradox for the Medical Review Unit.

Bachelor Of Science - Bs, Business Information Systems

Bachelor Of Arts - Ba, Speech And Performing Arts