SUMMARY:

• Overall career has provided experience connecting business professionals and entrepreneurs with the IT solutions, technology and services they need to build their success. With over twenty years as an IT Professional primary assignments included extensive PowerBuilder experience. As such, I have focused on data modeling with both ERwin and PowerDesigner. I have led and collaborated with multiple project teams, team leaders, technicians, IT support analysts service partners and vendors for problem management of complex technical support issues.
• I have consulted and interviewed clients one - on-one, in groups and JAD sessions for the purpose of determining the model development and providing written ETL instructions for the developers. Additionally, I have managed schedules, provided status reports to management, developed databases, data warehouses and data marts to meet the end stakeholder requirements. These data models were comprehensive with data definitions. Data dictionaries were generated from the models, along with having elements of both logical and physical attributes.

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Consultant

Responsibilities:

• Identify, assess and solve complex IT problems for clients where analysis of situations or data requires an in-depth evaluation of variable factors.
• Develop target data models, and gap analysis to current business cases for improvement.
• Facilitate client evaluations of options and selections for target operating models.
• Maintained and enhanced a major system written in PowerBuilder 10.0. Upgraded to PowerBuilder 12.5.
• Source code control was performed with PVCS. The database server was Oracle.
• Wrote SQL queries and stored procedures to validate data and test embedded SQL for development purposes.
• Using PFC services, developed objects, both visual and non-visual, to implement new features. Worked with .COM objects to implement OLE automation.
• Resolved defects reported by the stakeholders. Researched the implementation of DOT.net support in the application.
• Implemented new functionality based on a brief description of the requirements.
• Conducted meetings with the stakeholders to review the changes prior to releasing the new version for unit and system testing.
• Used Erwin, on the database to reverse engineer the database to provide documentation. It consisted of over 100 tables.

Confidential

Senior Data Administrator

Responsibilities:

• Interviewed stakeholders to determine their requirements and create subsequent documents.
• Worked with business and technology teams to identify business data flow and requirements and at what points within that flow to capture the data needs.
• Developed and maintained all data models and dictionary utilizing the ERwin modeling tool to meet the stakeholder requirements for detailed documentation generation.
• Initiated and prepared ETL required Technical Design Documents with input and output mapping to describe the new populated environments.
• Conducted meetings with stakeholders and development teams for design reviews and sign offs.
• Used Informatica Data Explorer and SQL queries to analyze files and database tables with Oracle.
• Collected data from various systems and identified any data discrepancies. Assessed data quality, identifying patterns / trends and produced report with up-to-date, accurate data analysis for the organization, source t target data mapping.
• Wrote complex queries and stored procedures to support the effort.

Confidential

Senior Consultant

Responsibilities:

• Responded to stakeholder requests for new and ad hoc reports and queries.
• Enhanced the application to meet the evolving requirements of the stakeholders.
• Strengthened the application to respond to USDA requirements for modification to the WIC system.
• Rewrote a utility used by Operations to schedule, initiate, and track jobs eliminating the need for profile files for jobs being executed from this environment. The application built and implemented execution strings.
• The assignment was to maintain, support, and enhance the PowerBuilder application to meet stakeholder needs utilizing Oracle. I wrote complex procedures to add the required support functionality enhancement for the database utilizing ERwin with appropriate modified triggers. Implemented OLE functionality to support sharing of Postscript and Excel files.
• Responded to production issues and made necessary modifications to correct deficiencies that had resulted in production problems.
• Enhanced the application to meet the evolving requirements of the stakeholders.

Confidential

Support Enforcement

Responsibilities:

• Changed the Child Support Enforcement Levy process, which enhanced the Levy and Asset management processes and completely rewrote interface to an outside asset table.
• Developed a Levy review process to allow a supervisor to review, then approve or deny requests for special requirement levies.
• Fortified a payment processing system to replace a temporary process and integrate payment procedures into the CSE application.
• Upgraded a seizure process to allow request and tracking of physical asset seizures in the CSE application.
• Migrated the application to PowerBuilder version 10.5.
• Documented the database to create a model to be used by the DBA team.

Independent Consultant

Confidential

Responsibilities:

• Application converted a semi-automated process to a full workflow management PowerBuilder application. The database was migrated from Sybase SQL Server 10.5 on a SUN server to Sybase ASE 12.5 on an HP server.
• Re-engineered database after migrating to Sybase ASE 12.5.
• Employed ERwin to re-engineer the database and generate scripts to build the new database.
• Implemented workflow tracking, allowing customer service clerks to respond immediately to a customer request.
• Automated generation of correspondence utilizing OLE Automation. Word and Excel templates were created for the different correspondence needs.
• SQL queries were written to validate the data and test embedded SQL for inclusion in the application.
• Used PFC and PFE in the application, using PFE for extensions to the PFC objects.

Confidential

Senior Consultant

Responsibilities:

.

• Designed and developed database applications utilizing PowerBuilder (5-7) and Sybase ASE TSQL.
• As new versions of PowerBuilder were released, migrated benchmark applications and identified differences.
• Designed Conceptual, Logical and Physical data models for over 10 projects using PowerDesigner.
• Taught the complete set of classes in PowerBuilder, Logical and Physical Database Design, and ASE.
• During this time period, taught computer science classes at the local community college.
• Project: Self-Insured Insurance and Pension Application
• The system managed the full range of services, including policy management, pension management, and claims processing. The application was built on PowerBuilder 7 and Sybase ASE 12.5, consisting of over 500 tables and 900 stored procedures. Developed 40 stored procedures for this application.
• Reverse engineered the database using PowerDesigner. Enhanced and implemented the model with new requirements. Wrote more than 30 complex stored procedures for this application.
• Created data entry forms using bitmap images of the actual forms as background for the data entry windows.
• Aligned table columns with input fields to simplify data entry for the clerks.
• Developed backup and recovery procedures for the database and assisted in training the DBA in the use of these procedures.
• Provided on-site PowerBuilder and data modeling training.

Confidential

Senior Consultant

Responsibilities:

• Performed Data Modeling for various clients based on the Confidential methodology. This included Conceptual, Logical and Physical models. Utilized ERwin as the preferred modeling tool.
• Participated in and facilitated Joint Application Development sessions.
• Taught internal PowerBuilder classes and worked with clients designing and developing PowerBuilder applications. Made extensive use of SQL.
• Taught classes at the Anderson Technical training center. Some classes consisted of over 300 students.