resume patrick lee loy
DESCRIPTION
Resume containing over 10 years experience application development and databases.TRANSCRIPT
PATRICK LEE LOY Philadelphia, PA 19146-1207
(267) 254-9527 [email protected]
SUMMARY Highly motivated Business Intelligence Professional using SQL Server 2005, SQL Server 2008 and Microsoft Technologies. Experience manipulating various data sources to support Senior Management decisions. Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
http://www.linkedin.com/in/patrickleeloy
TECHNICAL SKILLS Microsoft Technologies:SQL Server 2005/2008 Integration Services, SQL Server 2005/2008 Analysis Services, SQL Server 2005/2008 Reporting Services, Microsoft Office SharePoint Server 2007, Microsoft Performance Point Server, Microsoft Visio, VB6.
Databases: MS SQL Server 2005MS SQL Server 2008MS Access 2000, 2003, 2007
Software: SQL Server Business Intelligence Development StudioMS Visual Studio 6.0, MS Visual Studio 2005, MS Visual Studio 2008
Query Languages:T-SQL, MDX
SetFocus, LLC. Philadelphia, PA Oct 2009 – Nov 2009Business Intelligence Master’s Program
Implemented a Labor Analysis Business Intelligence solution for a national construction company.
Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements.
Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
Created score cards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a construction company extracting data from SQL Server 2005 OLAP data source and deployed to SharePoint sites. The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.
Key product areas utilized also include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.
Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions.
PROFESSIONAL EXPERIENCE
Griswold Special Care Erdenheim, PA May 2001 – Aug 2009IT Manager
Worked on existing customized client server application in VB6.0 with Microsoft Access databases. The application was a CRM for the offices to keep track of its clients, caregivers, referral sources, 3rd party payers and staff. It allowed the user to match and create schedules between the client and caregiver. It also calculated financial data for the client and the office. It produced reports in Crystal Reports, Word, Excel and Access. I had direct client contact with the offices, users and corporate staff in which they were extremely satisfied with the service I was able to provide. I was in charge of the network and servers (file, print and MS Exchange), firewall and spam hardware and infrastructure at the corporate office. In the last year, I worked with consultants to move the client server application to a central web based application in .Net and SQL Server 2008 database.
Visalign, LLC West Chester, PA May 2000 – May 2001Application Developer
Part of the development team on the American Independent Insurance Company project. Worked with SQL Server, IIS, Com+, Visual Interdev, Visual Basic, XML, XSL, DHTML, HTML, ADO, JavaScript, And Visual SourceSafe.
Worked individually on fixing an existing client server application for Special Care. Worked with VB6.0, Access database. The application produced reports in Word, Excel and Access. I had direct client contact in which the client was extremely satisfied with the service I was able to provide as part of Visalign.
Worked on the QA Methodology site. Worked with Visual Interdev, JavaScript, and DHTML.
Set Focus, LLC Parsippany, NJ Feb 2000 – May 2000Consultant
Intense program consisting of 3 months (full time) programming training and 9 months consulting. Visual Basic Skills Set: ActiveX Controls, ActiveX Documents, ActiveX Components, Windows API, ADO, ODBC API, COM, DCOM, and MTS. SQL Server Skills Set: ANSI SQL, Transact-SQL Queries, Indexes and Views Transactions, Batches, Cursors, Stored Procedures, Triggers and Replication. Internet Development using Microsoft ActiveX Technology. Web Site Development Using Visual InterDev: HTML, DHTML, ASP, VB Script, and Java Script.
Thread Tech and Phoenix Drilling Services
Calgary, Alberta Apr 1998 – May 1999
IS Administrator
Setup network with Windows NT 4.0.Configured workstations with Windows 95 and Windows NT operating systems. Provided support for the all MS Office products (Word, Excel, PowerPoint, Access, Outlook, Internet Explorer), Accpac Plus for Accounting. Designed small database and application to maintain an inventory of the company’s products using Access and VB 5.0.
Thread Tech Calgary, Alberta Aug 1997 – Mar 1998Accountant/Bookkeeper
Company Treasurer. Analyzed all financial transactions including daily entries for Accounts Payable, Accounts Receivable and General Ledger.Invoiced and administered all Overdue Accounts Receivable.Produced biweekly check runs, Year End Financial Reports, Month End Financial Reports for the banks and Provincial, Federal and GST Tax reporting.Administered Payroll and Employee Benefits. Designed small database and application to maintain an inventory of the company’s products using Access and VB 5.0.
Canada Trust Bank andMortgage Company
Calgary, Alberta Jun 1991 – Aug 1997
Mortgage Administrator and Customer Service Officer
Received and successfully handled customer complaints and inquiries as a specialized Customer Service Officer.
Dealt with branch network to provide excellent service and turn around time for information and files to be processed and administered in the legal department specializing in increases, discharges and land title registrations relating to mortgages.
Promoted and referred RRSP, loans, lines of credits, etc. to the branches in order to expand the customer’s product base.
Processed and administered mortgage renewals customers including renewals, transfers and new mortgages.
Devry University Calgary, Alberta Apr 1998 – May 1999Faculty Assistant
Tutored students, graded examinations and quizzes, proctored examinations, coordinated, maintained and assisted a professor with his student’s grades.
Excelled in DeVry's Computer Information Systems Program covering business applications programming, computer-related sales and sales support, database applications, applications software support and maintenance, small business entrepreneurship and management, sales and marketing support, technical documentation and applications, software consulting, LAN and network support, and finally security issues related to programming.
EDUCATION
BS, Computer Information SystemsDeVry Institute of TechnologyCalgary, Alberta
BS, Computer ScienceBS, MathematicsWestern Kentucky UniversityBowling Green, Kentucky