SUMMARY:

• Certified Six Sigma Yellow Belt (Six Sigma Process Management)
• Microsoft Certified Professional (Exams 070 - 228, 070-229, 070-215)
• In-depth understanding of SQL Server that includes database normalization, creation of stored procedures and performance tuning
• Strong knowledge of business applications and excellent understanding of relational database structures and processes
• Proven excellence with analyzing existing processes and developing time-saving solutions using systems integration and development skills
• Ability to work directly with end-users to troubleshoot and resolve problems
• Strong communication, interpersonal, analytical and problem solving skills
• High attention to detail and ability to work within stringent deadlines
• Strong passion for superior “customer service”
• Ability to multi-task with a variety of concurrent projects
• Ability to interact with the business community to understand and assess their information needs and then deliver solutions to meet those needs
• Demonstrated ability to work within the structure of a software development cycle methodology including effective completion of all development phases (Analyze, Design, Build, Test, and Implement)
• Ability to code in .NET languages, SQL, and scripting languages as well as the ability to quickly learn new languages and tools as needed to get the job done
• Excellent ability to investigate and analyze system/server issues and performance bottlenecks
• Experience with Agile Development
• Proven ability to quickly analyze new databases and understand table relationships, indexes, existing stored procedures, and performance statistics using available SQL Server tools (such as dynamic management views and functions, information schema views, Profiler, traces,sysjobs, etc.)

TECHNICAL SKILLS:

Systems: Windows; UNIX; IIS; Actuate iServer

Languages: SQL; VB.Net; ASP.Net; C#.NET; JavaScript; Visual Basic; HTML; DHTML; VBScript; XML; XSL; Visual Basic for Applications; ASP; Unix Shell Scripting; Actuate Basic; WMI; Powershell

Applications: SQL Server; SQL Server Reporting Services; SQL Server Integration Services; Sunrise Clinical Manager; Actuate 5, 6, 7, 8.1; Actuate iServer; Actuate Active Portal; Actuate Management Console; Actuate e.Report Designer Professional; Actuate Information Objects/Query Tool; Actuate Report Encyclopedia; Actuate iServer Integration Technology; DocFinity WorkFlow; Microsoft Office; Visual Studio; Visio; Oracle; InfoLease; SalesLogix; Crystal Reports

PROFESSIONAL EXPERIENCE:

Senior Database Administrator

Confidential

Responsibilities:

• Developed a payment processing intranet solution using C#.Net, ASP.Net, and a SQL Server database for Volunteer Services Med Alert Program tailored specifically to needs of program administrators; includes various levels of invoicing and reporting
• Monitor all clinical systems for operational or performance problems
• Perform database administration duties
• Create reports using SSRS, Crystal Reports, or other reporting tools; Data is assembled from various clinical systems across the hospital as well as Sharepoint lists
• Create ETL processes using SSIS to provide data and reporting solutions for users
• Collaborate with Clincial Informatics team and other staff members in process improvement efforts across the organization
• Provide technical expertise in the analysis and implementation of new or existing clinical systems with regard to hardware and software needs
• Develop documentation and procedures regarding the configuration, maintenance, and troubleshooting of servers, databases, or related processes
• Obtain, install and document clinical application software releases

Programmer/Analyst - SQL Developer

Confidential

Responsibilities:

• Create/Maintain complex SQL Server stored procedures
• Create/Maintain SSIS and Legacy DTS packages
• Troubleshoot SQL Server performance issues
• Provide Windows server support for DocFinity application
• Provide database support for WorkFlow Applications (multiple databases)
• Upgrade Visual Basic 6 applications to Visual Basic.Net
• Assist with troubleshooting and maintenance of existing Java web pages in custom web application utilizing Spring framework
• Provide VBA support to junior developers
• Develop VB.Net and C#.Net programs to address specific needs within Confidential ’s Billing departments

Senior Actuate Systems Administrator/SQL Server Reporting Services Administrator

Tech Analyst

Confidential

Responsibilities:

• Administer and maintain optimal performance of the Actuate and SSRS reporting platforms for multiple clients on multiple projects
• Provide senior level analytical and problem solving skills when addressing and resolving Actuate and SQL Server Reporting Services (SSRS) issues, assessing possible systems impacts and recommending technical solutions
• Perform all Actuate 8.1 system administration duties including the creation and management of users, roles and notification groups, encyclopedia management, data source management and job scheduling
• Created Unix scripts to accomplish various Actuate administrative tasks such as archiving log files and creating nightly encyclopedia backups
• Assisted Actuate and SSRS developers in resolving complex report development issues
• Created assemblies using VB.Net code to extend the functionality of SSRS reporting and meet business requirements; Setup server configuration files and deployed assemblies to web server
• Conducted “brown bag” sessions and provided written tutorials for Actuate developers on more complex development tasks (i.e., hyperlinked reports, e.Spreadsheet page bursting, using VBA/macros in e.Spreadsheet reports, debugging reports, etc.)
• Created and maintained server configuration files for database connections in Actuate e.Spreadsheet
• Conducted regular meetings with developers to discuss common issues/obstacles in the development of Actuate and SSRS reports
• Planned and executed all Actuate product maintenance and upgrades
• Customized the Actuate log consolidator to save data to a DB2 database by modifying java code
• Participated as the technical lead on the project team for the upgrade from Actuate 8.1 to Actuate 9
• Installed Actuate 9 iServer and iPortal on Unix development servers in preparation for upgrade project
• Participate in capacity planning activities and disaster recovery exercises
• Drive implementation of new features and functionality
• Ensure compliance to the change management and defect tracking standards in a production environment
• Responsible for problem assessment and/or resolution as well as documentation of those resolutions
• Provided support for implementation of “The Manager” application (a business process and compliance management web application running on Oracle WebLogic); application was used by all Freddie Mac Technology departments to store SOP documents, Business Continuity Plans, operating procedures, and other critical documentation
• Attended “Oracle University Hyperion Planning 9.3.1: Create and Manage Applications” and Oracle’s BI Suite workshop
• Assisted with the deployment and installation of Oracle Hyperion Planning platform (including Hyperion Planning, Hyperion Essbase and Hyperion Financial Reporting)

Senior Web Developer/SQL Server Database Administrator/Actuate Report Developer

Confidential

Responsibilities:

• Provided enhancements and developed new functionality for existing Six Sigma/Reengineering global project tracking and reporting intranet system; technologies used include VB.Net, ASP.Net, HTML, DHTML, JavaScript, VBScript, Active Server Pages, Visual Studio, IIS, SQL Server, SQL Server Data Transformation Services, Microsoft Office Applications and VBA, C#.NET, Actuate, and SQL Server Reporting Services
• Led reporting effort for new custom built Metrics system; reporting consisted of dashboard reports built with SQL Server Reporting Services
• Partnered with data owners, project managers, internal customers and developers to analyze and define complex business requirements to meet customer ad-hoc and application development needs
• Analyzed, gathered requirements, created, developed and maintained interactive reports using SQL Server Reporting Services
• Developed “Health of Six Sigma” interactive analytical dashboard (VB.Net, ASP.Net, ChartFX, SQL Stored Procedures) for Executive level reporting
• Designed and developed Data Warehouse for Six Sigma training and performance data
• Served as project lead for the addition of a new module to our existing system where the “customer” was a group in the United Kingdom
• Provided analysis and development for the integration of two SQL Server databases used by top-level company executives for six sigma and reengineering project tracking and reporting
• Designed, developed and documented data transformation processes
• Developed Executive level Actuate reports using complex SQL Server stored procedures, customized page layouts, parallel and sequential report sections, Actuate Basic programming, Actuate Query Tool, and hyperlinked reports
• Created Actuate Information Objects to assist with ad-hoc reporting needs
• Customized “look and feel” of ActivePortal.Net through modifications of Actuate’s C# code
• Assisted with initial installation of Actuate 5 and all subsequent upgrades (up to Version 8.1)
• Setup new Actuate reporting site for spin-off of Confidential Financial Consulting business (Ameriprise)
• Provided Actuate Administrator duties as required
• Provided guidance on all Actuate reporting deployment solution options
• Served as lead reporting contact/developer for executive level reporting after reporting manager left group (Nov. 2005)

Developer/Analyst

Confidential

Responsibilities:

• Provided analysis, development, maintenance, and support for company-wide Accounts Payable system ("Pyramid"); technologies used include Visual Basic, Microsoft Transaction Server, IIS, Visual InterDev, Active Server Pages, JavaScript, VBScript, HTML, DHTML, XML, XSL, SQL, Oracle, PL/SQL
• Served as System Administrator and only application support resource for the most widely used company leasing system (InfoLease).
• Reduced InfoLease month-end reporting time for accounting group from 16 hours to 4 hours by analyzing existing process and developing new procedures to more efficiently accomplish same goals.
• Analyzed existing processes for several departments and developed automated procedures using Visual Basic for Applications to interface with data from a unidata database. User effort was reduced by approximately 90%.
• Developed Access Reports for sales and marketing database using Visual Basic for Applications; development included using SQL to retrieve data from both Microsoft Access and Oracle tables.
• Provided System Administrator duties for InfoLease, DataScan, and SalesLogix systems.
• Provided Unix level assistance for InfoLease system.
• Developed reports using Crystal Reports for SalesLogix users.
• Assisted with implementation of Hyperion System.
• Received Accelerated Thinker Award (first quarter 2000) for consistently "thinking outside the box" to solve problems and for maintaining a high level of support for over 200 users.

Part-Time Instructor

Confidential

Responsibilities:

• Courses Taught included: Introduction to Computers; Introduction to Office Systems Technology; Introduction to Programming and Logic; Windows 98 Operating System; Medical Coding, Billing, and Insurance; Office Software Applications; Transcription; Professional Development; Spreadsheet I; Spreadsheet II

Information Associate

Confidential

Responsibilities:

• Developed a Visual Basic application to index documents for a Lava Document management system using SQL to extract and manipulate data from an Oracle database.
• Served as only onsite developer, SQL Server database administrator, and application support resource for Visual Basic application used by financial team; created user manual for system.
• Served as only application support resource for a USPS security Intranet application used throughout the United States; tasks included maintaining Oracle WebServer, fixing bugs in PL/SQL and JavaScript code, writing SQL statements to make changes to Oracle database, maintaining both production and test servers, receiving and responding to Tier 2 support calls, tracking support issues with Remedy Help Desk software.
• Elected and served as Project Manager for Technical Training Development project in Adelaide, South Australia; completed Microsoft Windows Architecture, Visual Basic, Data Modeling, Systems Life Cycle training program; chosen as alternate for assistant instructor position for next training class
• Participated in testing and implementation of Oracle Financials - Project Costing Module; created user manual for system
• Assisted with support of Security Management System implemented on US Postal Service intranet (using Oracle WebServer, JavaScript, PL/SQL)

Web Consultant Intern

Confidential

Responsibilities:

• Served as web consultant for professional organization and Textiles Department
• Assisted with domain name registration of organization
• Developed approximately 18-20 web pages

Guidance Counselor

Confidential

Responsibilities:

• Developed and implemented Guidance Curriculum for three elementary schools
• Created/developed/implemented extensive programming to address and meet the needs of "at-risk" students
• Organized and conducted training workshops for faculty, staff, administrators, parents, and students
• Assisted administrator in analyzing staff/student morale and subsequently developed and implemented a comprehensive school-wide self-esteem building program
• Coordinated services with community agencies (Social Services, Mental Health, etc.) for students in crisis
• Received "Dropout Prevention Coordinator of the Year" Award for school year 1986-87