PROFILE:

• I am a senior information systems professional with over twenty years of Database, Software Development, and Systems Integration experience. As a systems integrator, I specialize in full life cycle design and development, n-tier database design, software and GroupWare development, and network planning and design. I have an informed understanding of corporate issues and concerns. With a broad-based technical background from microcomputers to mainframes, my expertise is in creating, designing and implementing solutions for large and small environments.
• My project responsibilities have included business process redesign, database design, database development, network design, implementation and migration, GroupWare server design, client application development, and program, project and technical management. I have developed client applications using Microsoft Visual Basic, Microsoft Office, and other development platforms. I have worked with Microsoft SQL Server, Oracle and other database management software under Windows NT/2000, UNIX, MS-DOS, and NetWare on microcomputers and under CMS and MVS on mainframe computers. I am experienced with database management systems DBMS spanning both platforms.

EXPERIENCE:

Confidential

Business Intelligence Architect

As a Business Intelligence BI Architect, supported Momentum Consulting Corp's MCC BI practice. Participated in client Statement of Work development. Identified vendors to support projects. Administered MCC's windows Infomatica installation. Installed and administered the Embarcadero ER/Studio model repostitory on SQL Server. Worked at client sites to perform analysis, design, development and lead roles.

Confidential

• Participated in the design and scope of the SM2K conversion project.
• Documented meetings with clients and identified tasks and milestones for MCC participation.
• Worked with senior management in costing out the project.

Confidential

• Worked with team from MCC to identify the tasks to support the VA/SAM replacement system.
• Interviewed and identified data migration/modernization vendors/partners. Identified In-Com Data Systems as the best of breed for the VA/SAM project.

Confidential

• Acted as the ETL Architect, Senior ETL Developer, and PL/SQL Developer for the Southeast Toyota Pathway Project.
• Created High Level Design documents to document the ETL strategy for the project.
• Created PL/SQL packages, stored procedures, functions and scripts to facilitate data extraction where use of the ETL tools were not warranted.
• Worked with Power Exchange Change Data Capture, laying out infrastructure requirements, configuring dbMover.cfg files for DB2, VSAM, Oracle, and SQL Server tables and files. Worked with Navigator to create Data Mapping entries for batch processing and Data Capture entries for near real-time logging. Worked within a group to create a fail-over strategy for Power Exchange Listeners and Oracle and SQL Server databases.
• Designed and developed complex Informatica Mappings, Mapplets, Worklets and Workflows to support the Pathway ETL effort. Performed peer reviews to validate that workflows followed company naming standards, efficient use of transformations, configurations were proper for the type of workflow.

Confidential

Principal Technology Architect

As a Principle Technology Consultant, used OOA techniques to identify client needs and provide solutions. Using the Rational Unified Process RUP , Entity-Relationship ER diagrams, and the Unified Modeling Language UML with Joint Application Development JAD sessions, documented System Architectures. Applications were developed using Visual Basic, VBScript and Visual Basic for Applications. Designed and developed database applications supporting Microsoft Access, Microsoft SQL Server and Oracle. Created Data Marts to support business intelligence efforts, created SQL stored procedures and used Extract, Transform and Load ETL tools, like DTS, SSIS and Informatica for loading data into Data Marts. Using SQL Server Analysis Services SSAS and Framework Manager of the Cognos 8 BI suite, created cubes and packages, and using SQL editors created stored procedures to extract data used to create reports using Crystal Reports and Cognos 8 BI Suite. Identified and recommended hardware, software and operating system platforms in support of the new reference architecture. Developed statements of work, negotiated fees, and created contracts as part of the full procurement lifecycle. Established and maintained relationships with vendors to identify, purchase, and license hardware and software and insure that purchases include issue resolution, warranty, and maintenance.

Confidential

As a Senior Informatica Developer for the Total Return Team, developing ETL solutions using Informatica 9.x. Using Agile development, work with Analysts and QA to decompose specifications into workable stories that could be completed during a 9 day iteration. Provide support and assistance to other developers, code reviews and deployment group reviews. Using Harvest SCM to package SQL, text, and parameter files into a package to facilitate promotion of project files from development environment to testing through production environments. Analyze and update C .net and Perl scripts as needed.

Confidential

For the Data Warehouse Team analyzed Cigna Dental's data model. Reviewed ETL procedures and determined the best path to migrate the ETL process from PL/SQL to Informatica. Maintained and developed data models using Erwin. Worked with Sparx Systems Enterprise Architect to model the full data warehouse development life cycle. Developed ETL in SSIS using the Assurant Oracle Connectors, Informatica v9.2, and PL/SQL. Migrated ERwin models and ERwin Model Mart from r7v3x to r8v2x.

Confidential

For this startup provided database development expertise to develop solutions using PL/PGSQL. Analyzed existing SQL and PL/PGSQL scripts supporting their PostgreSQL v9.x databases and created new scripts, functions and tables. Reviewed and identified development and administration tools for PostgreSQL, like EMS SQL Manager, to be used on Windows client systems. Developed solutions required to meet their current short release cycle.

Confidential

For the Cognos Reporting Team provided database and Cognos expertise to model data in support of their reporting requirements. Working on a project to migrate Cognos reports from Cognos Report Net to Cognos Business Intelligence Suite 8, version 8.4. Running reports through Cognos Connection, identified issues and problems with reports migrated from Cognos Report Net. Using Cognos Framework manager redesigned the models and packages to correct any problems or issues with the reports where errors existed or the upgrade resulted in any Full Outer Joins. Developed SQL based solutions for SQL Server and Oracle by creating T-SQL and PL/SQL solutions dealing with hierarchical extracts.

Confidential

For the Data Warehouse group, provided expertise database and business intelligence BI design and development. Identified source data, business rules, and transformations required to build T-SQL and PL/SQL batches, extract transform and load ETL jobs and BI reports to support the business. Activities performed consisted of developing T-SQL and PL/SQL scripts, create ETL jobs and packages, and develop Microsoft Business Intelligence solutions. BI solutions were developed to support the following platforms: SQL Server 2005, SQL Server 2008, and Oracles 11g. Development of T-SQL was performed using SQL Server Management Studio and Toad for SQL Server, and PL/SQL was developed using Toad for Oracle. Used the Business Intelligence Developer Suite BIDS to design, develop and reverse engineer SQL Server Reporting Services SSRS report projects, SSAS OLAP projects, and SQL Server Integration Services SSIS ETL projects. Informatica was used to identify current business rules, data sourcing, and data mapping by reverse engineering current ETL workflows, and to create new ETL workflows. To support the implementation of a new loan processing system identified how data was sourced throughout the system using Informatica workflows, SSIS packages, and Business Objects Enterprise reports to identify business rules, data mapping, and data sources required by the business. Worked with business users to gather requirements, identify and confirm business rules, data transformations and reporting requirements.

Confidential

• For the Enterprise Data Warehouse EDW group, identified business rules, researched data, and provided superior PL/SQL programming to refine the monthly reporting process. Improved and tuned SQL, T-SQL and PL/SQL queries used throughout the monthly reporting process restoring confidence in the numbers on the monthly finance reports. Activities performed in a typical week included performing quality assurance, researching data inconsistencies, creating and running ETL scripts, creating and delivering custom reports, performing software installations, configurations and patching of software and environments, and providing production support. Key participant in the creation of a new reference architecture High Availability Business Intelligence Data Warehouse by performing requirements gathering, data modeling and data analysis, SQL queries for data research and identification of business rules.
• Created, maintained, and deployed reports created in Report Studio. Created, maintained, and deployed cubes and packages for use through Cognos Connection using Power Play and Framework Manager. Analyzed existing packages to insure that the models and SQL generated by Cognos was efficient and extracted the correct data.
• As the project manager and key member of the Credit Card Payment Gateway project, was responsible for creating the project plan. Using Microsoft Project identified key processes and milestones, allocated resources, and estimated timelines. Gathered and recorded business requirements from both Finance and IT to create an RFI used to sub select vendors from a field of 100 products. As a selection panel member, identified the best solution during the written and verbal vendor presentations. Participated in meetings to secure funding and prepared the RFP.
• As the Project Lead and Technical Manager of the Enterprise Project Management EPM project, designed and implemented a SharePoint Server farm. Following Microsoft best practices and product recommendations, implemented a 4 Server SharePoint Server Farm. Windows Server 2008 Enterprise x64 was installed as the operating system for all servers. The server farm consisted of a SharePoint Server, a SQL Server 2008 Server, Office 2007 Project Server, and Office 2007 Project Portfolio Server. SQL Server Analysis Service SSAS and SQL Server Integration Services SSIS were installed to support OLAP and ETL SQL Server requirements.
• Created relationships with major IT vendors, developed systems requirements, evaluated COTS Commercial off the Shelf products, and negotiated with vendors to achieve significant cost savings for the Enterprise Data Warehouse group. Participated in full lifecycle procurement processes and served as the point of contact on all issues and maintenance renewals, for several products. Managed the distribution of software licenses, scheduled vendor presentations and trained, and mentored team members on several software tools Embarcadero, Toad, and MSDN .
• In support of the EDW used ETL, BI, Data Modeling and Database Administration Development tools. Developed ETL processes using Informatica PowerCenter 8.6 to extract data from source systems and populate the data warehouse. Used Cognos 8 BI Suite to develop reports for the dashboard and PDF reports, published to the internal website. Oracle administration was performed with Embarcadero's DBArtisan, and SQL development was performed with Embarcadero's DBArtisan Rapid SQL Pro and Quest's Toad for Oracle. Implemented Embarcadero ER/Studio Server, created a Data Model repository to allow all users access to the data models and to establish version control. Integrated Toad for Oracle with CA Harvest to use it for Source Control Management SCM for all Oracle scripts and database objects created by administrators and developers.
• PCI Compliance: Called upon past experience to develop a project plan MS Project that was used to accelerate the PCI compliance process. Used expertise of everything Microsoft, helped to make the difference between successful Ingrian encryption software rollouts of the client application to users and to correct the deployment failure on two separate occasions. When developers deployed and testers were unable to test the installation of the new Oracle 9i listener and Advanced Security Option on call center workstations, provided support and remediated the failure. Developed a script designed to correct the permissions on the Oracle9i directory structure on user workstations. In an effort to make the call center PCI compliant, developed a plan that used Ingrian to encrypt WAV files, and created a script that erased WAV files from client machines at the end of call center conversations. Was recognized for excellence as a major contributor to the successful implementation of PCI standards across the enterprise, completed in only four months when estimates indicated it would take six months to complete.

Confidential

For a leading provider of hospice care, provided expertise in database and web development. Supported the IT department's Web Development group in maintaining and enhancing their web based application system. The hospices application was developed using the Oracle 9i and 10g databases with the following tools: Oracle Internet Application Server, Oracle Gateway Services, PL/SQL, the PL/SQL Web Toolkit, and Oracle Reports. Designed and developed tables, stored procedures, views, packages and SQL scripts using SQL and PL/SQL. Created custom web applications using PL/SQL and JavaScript. Became the main developer supporting the fiscal accounting departments remittance processing, patient accounts, adjustments and write-offs and provided technical support to the other developers. The applications were developed using Toad, SQL Developer formally raptor and the Oracle Reports Developer.

Confidential

For an international Fortune 500 printer manufacturer, provided expertise in data modeling, database development and administration, reporting, data extraction and transformation, and scripting. Supported the continuing development and maintenance of the Data Warehouse. DB2, Oracle and SAP were the original data sources where data was extracted to populate the Data Warehouse. Developed SQL scripts using PL/SQL, P/SQL and T-SQL to extract data from the original data sources into the Data Warehouse. Assisted in the installation and administration of Crystal Reports Enterprise v10.0. Created reports using Crystal Reports v10.0, designed stored procedures, views, functions, and scripts to populate the reports. Designed and developed jobs consisting of DTS packages, stored procedures, functions, and scripts to support and populate the SQL Server database. Worked with end-users to facilitate the design of modifications and additions to enhance the Data Warehouse, create new data marts, and provide timely business critical reports that saved management time and money.

Confidential

For an internet telephony and IVR firm, provided expertise in database development and reporting. Created and designed extracts from Oracle, MaxDB and MySQL databases. Presented the data in reports created with Crystal Reports v10.0. Reports developed in Crystal Reports used views, procedures and packages to extract data to populate reports used by the firm's clients. Developed the queries, views, stored procedures and packages using Quest's Toad for Oracle and Toad for MySQL for Oracle and MySQL and SQL Navigator for MaxDB. Created an automated reporting system in PHP for the Windows Server environment. The data for this system was extracted from a MaxDB backend, the output was sent to an Excel spreadsheet which was then mailed to the report recipients.

Confidential

For a large Remote Systems software firm, provided expertise in database design, development and reporting. Created and designed tables to be used in a Data Mart for current and historical information. Created ETL scripts for loading SAP data into a SQL Server backend by creating SQL Server 2000 DTS packages. Created reports with Crystal Reports using SQL stored procedures to extract data from the Data Mart and other tables in the Original Data Source. Reports created in Crystal Reports versions 8.5 10 using SQL Server stored procedures saved the company's analysts from several days to a couple of weeks of time performing data collection and scrubbing in producing their final reports.

Confidential

For a small consulting firm, provided analysis of existing systems. Using database and application expertise, designed a new application development framework that incorporated development best practices, naming conventions, and coding conventions. Recommended a multi-tiered migration path to migrate Access 2000 tables to SQL Server and update the client interface to Visual Basic. All applications are developed in VB/VBA using ADO to access the backend. Worked on Sales/Relationship Management System using workflow management to help the sales staff maintain contacts with potential and future clients using Outlook and Access forms to access Exchange data. Developed a Visual Basic code library containing all common code routines. Modified existing applications to use code library in place of redundant code. Developed new applications and modified existing applications as needed.

Confidential

For a non-profit organization, provided expertise with Microsoft Access, ADO, and Microsoft SQL Server development. As a member of a development team, modified and created forms, modules, reports using Microsoft's Access 2002 front-end developed in Visual Basic for Applications, and installed, maintained, populated and extracted data from a Microsoft SQL Server and MSDE 2000 backend. To support the application, developed Transact-SQL stored procedures, triggers, and user-defined functions.

Confidential

• For a small non-profit organization, provided expertise in systems design, development and implementation to migrate a MS-DOS based application to a relational database and a Graphic User Interface GUI . The application was redeveloped using Visual Basic and MS Access as the back-end. Identified and recommended hardware, operating system, and broadband connectivity update requirements. Negotiated with potential vendors to perform the system upgrades.
• Using Visual Basic and ADO developed an application to map data from other applications and databases to tables and attributes in an Oracle 9i database. Created procedures and applications that were used to import and export data from the Oracle central repository to external files and databases.
• Assisted client developers with the development of an application written in Microsoft Visual Basic VB that used ADO to access the database and required the creation of: ActiveX controls OCX objects , ActiveX DLLs in processes COM objects , and ActiveX EXEs out of process COM objects . Trained and supported the client developers in their conversion of the application to Microsoft Access 2000, without the use of any ActiveX components or controls.
• Using UML and Entity Relationship diagrams created a data model of an Oracle 9i central repository. Analysis of user data collection techniques and four different applications used to collect and process data and to identify the entities and attributes of the central repository.
• Using VBA created customized rules, forms, and functions and workflow applications for use with Exchange and Outlook. Created a custom VbaProject.otm to access the Outlook MAPI namespace and perform operations on the Outlook folders. Through Outlook accessed Exchange folders to add event agents. Wrote code to access and process agents using CDO, ADO and MAPI component object models COM .

Confidential

Principle Systems Engineer

• Utilized expertise in full life cycle system and network integration, to develop and maintain client and internal LAN, e-mail, and application infrastructure. Responsibilities included:
• Using object oriented analysis techniques to architect system models and application specifications, and entity relationship diagrams to describe database designs. Using UML methodology created multiple views of the system model for each stakeholder. Use Cases, JAD sessions, and diagram reviews were used to create application specifications, database designs, and middle tier architecture.
• Designed and developed an upgrade path to migrate existing Microsoft and Oracle SQL applications to Oracle 8i. Supported Oracle 8i databases using Oracle PL/SQL to create stored procedures, packages, triggers, views and functions. Designed and developed an upgrade path to migrate an existing application to Microsoft SQL Server 7.
• Providing the technical expertise required to support various client systems. Developed applications and systems to support the collection and tracking of information from states, government agencies, employers and financial institutions. Disseminate information to the client with reports developed using Crystal Reports and Oracle PL/SQL Packages. Created an application wrapper end-users used to execute the reports.
• Creating applications to support the enterprise and maintain CMM Level 3 compliance. Designed and developed a client server system application to track software defects and enhancements. The system documents the software engineering process in accordance with CMM Level 3 procedures. The application was supported and enhanced with ActiveX Controls OCXs and COM objects. The system uses the information collected to create reports that provide performance metrics release schedules and creates the work order. The system also automatically generates e-mail to users affected by modifications to work orders.
• Providing the technical expertise required to support Microsoft SQL Server. Supported, administered, and maintained a SQL Server version 6.5 backend with a Microsoft Access front end. Maintained and updated any existing stored-procedure or trigger as required.
• Working with the internal LAN group to maintain and administer the local LAN and Intranet. Major role planning and migrating all users from cc:Mail to Exchange e-mail and lead the development of Outlook/Exchange workflow solutions. Assisted with the expansion of the network infrastructure, researched and recommend new server and workstation hardware configurations and recommended development software.

Principle Operating System Consultant

• Utilized expertise of system development life cycle to consult, manage, design and implement projects that support the client. Acted as Work Order Manager and Senior Consultant, providing technical and administrative support to client's ongoing client server initiatives, which included:
• Assisting in client's effort to standardize development tools for all platforms mainframe to Internet, evaluated Intranet/Internet tools.
• Developing white papers and working papers to keep the client informed. The white papers described solutions to complex problems or detailed systematic instructions in the use or installation of a Back Office product or add-on. The working papers were research papers that were periodically updated as available information changed.
• Creating applications, designing databases and providing development support to create n-tier client server applications, the development tools included PowerBuilder and Visual Basic. Designed and developed Microsoft SQL Server Databases used T-SQL to create triggers, procedures and scripts to support and optimize the database. Developing and supporting GroupWare/Workflow applications designed for use with Microsoft's Exchange Server and Outlook e-mail client. Developed ActiveX controls OCX and ActiveX COM components using Visual Basic to support middle tier processes.
• Supporting the LAN infrastructure, research solutions recommend actions and hardware/software purchases, and providing NetWare and Windows NT technical support. Planning and supporting the server consolidation effort required for the client's transition from NetWare to Windows NT. Used Crystal Reports to query the event log to report on the frequency of certain system errors and audit log entries over a set period of time. Providing answers to all technical questions involving Windows NT, Exchange Server, NetWare, Outlook, development languages, etc.
• In recognition of exceptional work, broad expertise and commitment to values performed across multiple activities received several Lightning Awards .

Confidential

Automated Information Systems Specialist

• Utilized expertise in all areas of the system development life cycle, managed and consulting for projects supporting SEMA Inc., in pursuit of overall corporate objectives. This included acting as a troubleshooter for projects in jeopardy, providing input for proposals and marketing efforts, providing technical assistance, and managing projects as a Task Leader, Technical Manager and Program Manager. Project work included:
• Development of a prototype system that measures project performance using cost, schedule and performance for the Office of the Assistant Secretary Defense. Task involved designing a normalized relational database, standardizing user interface, identifying reusable objects, developing application code. Project developed using standard ER and RAD techniques using Watcom SQL and PowerBuilder.
• Managed, maintained and developed the Store Tracking and Redemption System STARS for United States Department of Agriculture. Task involved staffing, maintaining existing system, developing new modules to support the expanding business model and development of a fraud subsystem. The task required constant interface with a variety of users from head quarters staff to field agents. All new database designs were implemented to ease migration to a relational database. STARS was developed and maintained using the IDMS/R network database using COBOL and ADS/0 programming languages.
• Reviewed and modified database designs for a GSA sponsored project. Using Entity-Relationship ER diagrams produced the conceptual and physical database designs in Boyce-Codd normal form BCNF . Explained to experienced data modelers and end-users the complex relationships ER diagrams.
• In recognition of exceptional performance in the work place received annual achievement awards and was named Employee of the Month.

Confidential

Network Consultant

• Utilized experience with NetWare and Windows NT to analyze and provide solutions to network problems for Local and Wide Area Networks LANs and WANS . Projects included:
• Corrected NetWare for SAA and printer services problems on communication servers and workstations emulation packages . To solve problems accessing communication servers, implemented load balancing. Designed and implemented communication server fault tolerance. Loss of user access was prevented by substituting the cold spare for any production communication server that went down.
• Performed network audits of the physical network, server and workstation hardware, server and workstation software, the server's volume and directory structure. Delivered reports containing a detailed analysis of the network with detailed solutions for problems identified by the audit.
• Administered and supported a NetWare v3.12 LAN and Beyond Mail e-mail service allowing users access to the LAN internally and remotely. Remote users accessed the system through MHS. The Server supported System Fault Tolerance SFT III and Oracle Server NLM.
• Installed and maintained a Microsoft SQL Server v4.2 database. Identified a computer with adequate disk space and memory. Installed Microsoft OS/2 v1.3 on the computer and tuned the operating system for running Microsoft SQL Server. Installed, designed and developed a SQL Server database. Setup client access using named pipes to allow other users on the network access to SQL Server.
• Administered and supported an Oracle Server NLM that resided on a NetWare v3.x database server. Used PL/SQL to create, manage and support the database as well as embed in applications used to access the Oracle v6.x database.
• Corrected database design errors, developed new database designs, developed and implemented complex solutions using IDMS/R, ADS/0 and COBOL. Managed a large team that identified all database and application changes required to conform to Federal Telephone System 2000 requirements for a major long distance phone company. The project involved cross platform applications and databases using IBM and Tandem Mainframe systems and LAN based systems.
• Developed a database using Gupta SQLBase, developed applications supporting client server using Gupta SQLWindows, C and Visual Basic.