Professional Profile

• Database Administrator, developer, and integration / reporting specialist with 14 years' experience in the IT industry.
• Experienced with Microsoft SQL Server and Oracle data platforms and a variety of reporting, ETL, and SaaS application environments.

Experience

Confidential

ETL Reporting Database Developer

Responsibilities:

• Development, testing and implementation of multidimensional OLAP database cubes for KPI reporting. This was performed using Microsoft SQL Server Analysis Services.
• Development of KPI reports for various departments which were used to visualize and evaluate the key performance data that had been assembled in the SSAS cubes.
• Using Microsoft SQL Server Integration Services, I was responsible for the development and testing of several ETL processes for synchronization normalization of data between major systems.

Confidential

Database Administrator / Cognos Report writer

Responsibilities:

• Administration of multiple instances of Microsoft SQL Server relating to accounting operations. This includes backup management, hardware monitoring and creation of custom SQL views and procedures.
• Administration of an IBM Cognos 8 reporting environment. Design, maintenance and support of a library of 150 custom data reports. The reports were of varying types, and often included data visualization via the tool set included in Cognos.
• Management of the backend Cognos framework and infrastructure. I also presided over the upgrade from Cognos 8.2 to 8.4.1.
• Administration and support of a Deltek Costpoint accounting suite, including end user training support, management of upgrades and rolling out of new features, hotfixes, and annual year-end updates. In addition, I managed the upgrade of this system from version 6.1 to 6.1 Service Pack 2, and began preparations for the upgrade of this system from version 6.1SP2 to version 7.0.1, including project and testing plans, and construction of a fully functional 7.0.1 testing and training environment.
• Backend and frontend administration of a Deltek Time Expense suite, including building and maintaining the links between Time Expense and Costpoint, and configuration and management of the Oracle Weblogic backend. I also planned and executed the upgrade from Deltek Time Expense 8.2 to 8.3 and initial preparations for upgrading to Version 9.
• Development, automation and management of multiple SQL Server Integration Services SSIS solutions for data integration with 3rd-party applications, including Bank of America Positive Pay and Concur travel Expense.
• End-to-end design, development, implementation and continuing support of a process for gathering employee utilization forecast data from project managers, importing that data into a custom-built database of my design, and generating useful weekly executive reports based on the forecast data.

Confidential

Systems Analyst

• Responsible for support reporting for the Logos.NET ERP for the Town of Apex, NC. These responsibilities included:
• End-user support and troubleshooting, including data querying and updating in the Microsoft SQL Server 2008 environment.
• Development of data reports in Crystal Reports 2008.
• Monitoring the status and performance of the SQL Server 2008 environment using Idera SQL Diagnostic Manager.
• Management of user sessions, backups, database jobs, and services.
• I was also involved in the development of several custom user interface tools based on Microsoft Access databases, for the support of certain tasks of the town administrators, such as condemned property and right-of-way acquisition.
• Tools used in this position include: Microsoft SQL Server 2008, Crystal Reports 2008, Idera SQL Diagnostic Manager, Microsoft Access 2007, New World Systems LOGOS.Net, Transact-SQL

Database Analyst / Programmer

• Responsible for analysis, cleanup, rewriting, and restructuring multiple aspects of the data warehousing, data processing, and reporting systems at North Carolina Mutual Life Insurance Company. Responsibilities included:
• Re-writing and converting dynamic data reports from a Cognos environment to a SQL Server 2008 environment, and customizing the new report versions according to user input.
• Creating an original and highly complex series of packages in Microsoft SQL Server Integration Services to integrate data from proprietary systems into a SQL Server 2008 environment, and to transfer that data to a Synergy environment.
• Assisting with the creation of a new data warehousing architecture, including analyzing and optimizing the schema structure, job load and index configuration of SQL Server and iSeries data environments.
• Tools used in this position include: MS SQL Server 2005, 2008, SQL Server Integration Services SSIS , SQL Server Reporting Services, Cognos Reporting Services, Transact-SQL, AS/400, and Synergy

Database Administrator / Business Analyst

• Responsible for managing the development and updating of processes in the GSK Service Catalog application. The Service Catalog, a product of Integrify, is a Software-as-a-Service SaaS platform which provides browser-based forms which clients use to submit many different types of IT-related requests. In this position, common activities included:
• Gathering requirements for new Catalog forms and for the updating of existing forms, including what data should be gathered, what help text should be provided, and the visual appearance of the form
• Gathering requirements for development of the workflows which operate behind the Catalog forms. These processes automate such tasks as manager approvals, email notifications, Remedy ticket generation, web service interaction, and reading and writing to database tables.
• Development, testing, and implementation of the aforementioned forms and processes, including managing an offshore development team. Responsible for 80 of database and web service-related development. This development was accomplished using the following:
• Integrify 4.5
• Transact-SQL queries, views, and stored procedures
• Oracle queries, view, and stored procedures
• PHP, JavaScript, and ASP development environments
• cXML and SOAP document transfer protocols.

Database Administrator, Confidential

• Primary responsibility in this position was planning, development, implementation, support and maintenance of Alphanumeric's electronic procurement infrastructure. This system was based on a product from Cybiz, Inc. The main client for this system is the IT division of one of the world's largest pharmaceutical manufacturers. Development of the system involved the following tasks:
• Gathering of hardware and software requirements
• Pricing, comparison, approval, and purchase of hardware, software and a secure co-location facility
• Hardware configuration, software installation and configuration, and construction of the required network infrastructure
• Integrating the Cybiz eProcurement system with multiple vendor catalog feeds, as well as the Ariba Supplier Network, including extensive XML field mapping using Microsoft BizTalk.
• Training of end users in accessing the system and using it to procure IT hardware and accessories.
• Once the system was in place and operational, responsible for the support and maintenance of the system. These include:
• Working with multiple vendors to obtain periodic product and pricing updates, and updating the customer-facing product information
• Gathering and implementing customer-specified changes to the product presentation
• Overcoming any hardware or network failures to minimize downtime
• Maintaining an effective rotation schedule for backup tapes
• Also performed administration duties with Epicor eBackOffice and eFrontOffice ERP systems. These duties included maintaining the databases that these systems were based on, as well as designing various reports to present data from these systems in ways that were useful to several different departments including purchasing, accounts payable, accounts receivable, and inventory.
• Additional responsibilities include updating and enhancing a Microsoft Access-based inventory management and reporting system which was in place at Alphanumeric's warehouse facility. Later tasked with replacing this system with a new tool, based on Microsoft SQL Server. This system was developed from scratch, including the design and implementation of a graphical interface, created using Microsoft Visual Basic 6.0. Additionally developed several SQL Data Transformation processes for various purposes, including importation of vendor catalogs into a purchasing database, and also for creating a CIF 3.0 catalog file from a group of data tables containing information from various vendor catalogs.

Tools: Windows Server 2000 and 2003, Microsoft SQL Server 2000, 2002, 2005 2008 including Transact-SQL , Oracle all versions , Microsoft Visual Basic 6.0 and .NET, Microsoft Biztalk 2002, Microsoft Visio all versions , Microsoft Access 2000, Cybiz PTX Marketplace 4.1, Cybiz TPE, Crystal Reports 8.0 and 9.0, Epicor eBackOffice and eFrontOffice, Ariba eProcurement Solutions, XML electronic document transport protocols, including cXML, SOAP 1.1 SOAP 1.2 protocols, HTTP electronic document transport protocols, JavaScript all versions , Microsoft Active Server Pages ASP , Integrify 3.5, 4.5, 5.0, BMC Remedy all versions

Confidential

Database and Reporting Consultant

• Administator, trainer, and troubleshooter for the database and the database front end solutions which track the progress and status of new cellular sites in construction. Two front end enterprise suites were used. The systems were products of Eftia, Inc., and Cingular Wireless. During the launch of these suites assisted in the setup of several SQL Server and Oracle databases, participated in the design process of the front end interface solutions, coordinated User Acceptance Testing, trained and supported the end users, and addressed any technical or user issues which arose. After launch, designed multiple reports using Crystal Reports 8.0 and 8.5 which presented data from the databases in various configurations, as well as sharing administrative responsibilities for the databases. Included in my responsibilities were the maintenance of the reports, diagnosis and resolution of user errors and difficulties with the system, and maintenance of the data integrity of the SQL Server and Oracle databases. Also responsible for the creation of custom SQL queries and tables in those databases.
• Extensive use of Crystal Reports in order to create self-updating data presentations which were used by Cingular personnel throughout the Southeast region both in printed form and on the corporate intranet. Also created several applications using Microsoft Visual Basic 6. The function of these programs was to automate the process of backing up the reports in the form of exported PDF documents, which were considered vital to the site construction process.
• In addition, responsibilities included development and maintenance of workflow plans utilizing Microsoft Project. These plans spelled out and tracked the tasks, timeframes, and responsibilities of all departments involved in the construction of new cellular towers and sites.
• Performed research into the new Microsoft .NET framework for possible future implementation. At this position, also acquired a thorough knowledge and understanding of the functioning, construction, and maintenance of digital cellular networks, and exercised skill in interpersonal communication and relation, through the process of training often-frustrated users on new systems, assisting their learning process and making them comfortable with the systems. Trained personnel ranging from Office Assistants to Radio Frequency Engineers and Project Managers, and after their training was completed, I remained the person to be contacted in case of questions or difficulties.

Tools: Crystal Reports 8, Oracle 8i and Microsoft SQL Server administration, Transact-SQL, Microsoft Visual Basic, ASP, HTML, Microsoft Project, Excel, FrontPage, Access Database reporting, Windows NT administration

Confidential

Software Engineer

• Served as administrator to Midway's enterprise software suite, an enterprise suite for an Oracle database which was a product of Industrial and Financial Systems IFS . Tasked with creating customized reporting tools to present data, which pertained to various aspects of the airline's operation. Responsibilities included testing, debugging, and initial implementation of the IFS suite of enterprise tools. This system was in a phase of gradual implementation. Administrator and trouble-shooter for the sections of the system, which were in production, which included systems for Human Resource management.
• Heavily involved in testing and debugging of the portions of the IFS suite, which were not yet in full production. This included systems for aircraft parts inventory and maintenance scheduling.
• In addition, acted as database administrator for several Oracle databases, creating custom SQL queries and Oracle stored procedures, as well as managing users, passwords, permissions and backups. Also assisted in the administration and management of several smaller Oracle databases which performed functions such as the tracking of liquor sales aboard Midway aircraft.
• These duties required me to become intimately familiar with the IFS system in a short time. Specific tasks performed included managing system users, roles and privileges, creating system events and programming the reactions to these events, configuring Oracle servers in a Solaris environment and Oracle clients in a Windows NT environment, configuring and administrating a Windows NT Domain, and general Oracle administration tasks.
• Other main area of responsibility was the creation of customized reports and reporting tools for the liquor-tracking, finance and purchasing departments at Midway. Created a large number of distinct, customized reports for these departments, which allowed them to better utilize the data, which was available. These reports even played a vital role when the liquor-tracking department was required to justify its existence to the airline's upper management. The tools used for these projects were Microsoft Visual Basic and Crystal Reports 8.5. Created multiple reports from scratch, which referenced procedures, views and tables in Oracle databases, manipulated the data, and presented it in useful forms, including various visualizations. Also developed reporting tools using Visual Basic, which would allow a nontechnical user to create their own reports. This project involved extensive work with Visual Basic in order to create a user interface, which would allow a user to customize certain reports that I had created using Crystal Reports.

Confidential

Professional Services Software/Implementation Engineer

• Specialized in computer telephony integration CTI . Altitude's chief product was a suite of software which coordinated the operations of smallto medium-sized call centers. Responsibilities included but were not limited to the following:
• Application development via a proprietary scripting language, Microsoft Visual Basic and Visual C . These applications included programs to control Interactive Voice Response systems, as well as desktop applications for call center agents which interact directly with the PBX, IVR, and Access, SQL or Oracle Database. Also involved was on-the-fly script programming to solve on-site problems such as logging multiple ports of a voice board into a PBX.
• Research and testing into the feasibility of developing Web-based call center agent desktops using XML. This concept was nearing production when the company pulled out of the North American market in April 2001.
• Development and testing of a Visual Basic OCX control which allowed Altitude engineers to create call center agent desktop interfaces in Visual Basic, as opposed to Altitude's proprietary language. I developed several different interfaces in VB for the purposes of testing the OCX control. Versions of these interfaces were later implemented for clients.
• Installation and integration of Altitude products into existing call center systems. These tasks were most often accomplished at customer sites throughout the United States, and required me to work in a team environment and often take a position of leadership. These rollouts included such responsibilities as:
• PBX configuration and administration Lucent Definity and Nortel Meridian
• Windows NT network configuration
• Installation and configuration of 3rd party software and hardware products from Lucent, Nortel, Symitar, Microsoft, Dialogic and others, as well as integrating these products into the overall environment and setting up communication between all components of the system.
• Troubleshooting and support of all aspects of Altitude's area of responsibility to a customer
• Documentation of all projects and customer rollouts composition of user manuals and training curriculums, documentation of testing results

Confidential

• PC technician
• Tasks performed include:
• Hardware and software troubleshooting and installation
• Operating System diagnosis, installation, and setup Win95/98, NT, Mac OS, Linux, SunOS
• Network construction including cat5 cabling, as well as hub and router configuration.
• O-site installation and repair of a variety of business-oriented systems including Novell Netware and the White Plains POS suite.
• Technical support
• Customer and Vendor interaction.