Summary of Qualifications

Data Architect / BI Engineer

• with the skill set and experience to integrate technology, teamwork, and business savvy with excellent planning, organization and problem solving.
• More than 25 years of experience in IT with a broad range of technologies encompassing data warehousing and business intelligence, ETL, client/server development, software selection and COTS implementations.
• Accomplished background with progressive responsibilities in all phases of the software development life cycle SDLC utilizing structured methodologies such as DeMarco/Yourdon, Andersen Method/1, Oracle AIM, and the Kimball Toolkit.
• Technical breadth of knowledge coupled with an MBA and PMI best practices.
• Skilled in applying techniques to plan, execute and control the fundamental project parameters of time, cost, and quality including managing schedules and deliverables as well as mitigating risks.
• Exceptional systems analyst excelling in the design and implementation of adaptable, extensible, and sustainable technical solutions.
• In-depth understanding of data warehousing / BI concepts and architectures to support analytics.
• Proven experience in constructing star schemas utilizing data modeling discipline.
• Expertise in advanced high-performance reusable SQL query development and best practices.

KeyTechnical

Skills

• Data flow diagramming DFD and analysis to include profiling, cleansing, and transformation
• Database design and modeling for OLTP and OLAP applications using ER/Studio and Erwin
• Database development with SQL Server, Transact-SQL DDL / DML, DTS / SSIS
• Database development with Oracle, PL/SQL DDL / DML, SQL Developer, SQL Loader
• SQL performance tuning and query execution / explain plan analysis
• Report writing and data visualizations for dashboards
• Proficiency with Microsoft Windows, Word, Excel, Outlook, Project, Visio and PowerPoint

Experience

Confidential

Environment: SQL Server 2005/2008 RDBMS, SSIS, SSRS, ER/Studio, Redgate SQL Compare and SQL Data Compare, Oracle 10g/11g RDBMS, PL/SQL Developer, QlikView

Senior Information Architect

• As a member of the Business Intelligence and Outcome Analytics department, duties included metric definitions and dashboard visualization data flow decomposition design, modeling and development of data marts source to target data mapping and transformation rules performance tuning quality assurance and data integrity as well as coordination and oversight of the overall implementation effort.
• Advocated the use of sound data warehousing methodologies incorporating atomic level data, data profiling, dimensional modeling best practices, and aggregate tables for performance.
• Promoted and praised for the level of knowledge achieved in the business domain, the ability to convey technical information to a non-technical audience, the skill to quickly translate business needs into workable technical solutions, and the self-directed achievement of results.
• Directly responsible for the design and maintenance of solutions to monitor performance for metrics affecting CMS reimbursement incentives for hospital quality reporting programs such as HCAHPS surveys and Value Based Purchasing.

Confidential

Environment: SQL Server 2000 RDBMS, DTS/ActiveX Scripting, Oracle 10g RDBMS, SQL Developer, Crystal Reports 10, Visio, Ingenix EASYGroup Medicare PPS, AMISYS Offline Operational Database

Lead IT Analyst

• As the senior associate, charged with projects broader in scope and with greater complexity. Additionally, responsible for mentoring team members on sound design techniques, physical data structures and RDBMS concepts, SQL performance tuning and DTS / ActiveX scripting functionality.
• Analyzed undocumented systems and provided detailed knowledge on data flows, file structures, and core functionality. Using Visio, prepared DFD and ERD system documentation.
• Reworked resource intensive T-SQL processes and reduced run times as much as 90 .
• Created data marts from the offline operational database for decision support purposes. This included mapping business requirements to relevant data entities, profiling data and identifying data anomalies, as well as designing and loading de-normalized data structures.
• Devised practical ETL solutions utilizing dynamic DTS properties and Excel tables.

Confidential

Environment: SCT Matrix Student Suite 2.5, SQL Server 2000 RDBMS, Crystal Reports 8.5/9

Student System Applications Team Lead

• Responsible for the implementation of Tulane's Enterprise Student System TESS to replace legacy mainframe systems. Assessed project scope, prepared resource estimates, and developed project plans. Hired and supervised a team of 5-7 developers. Coordinated and monitored all application development activities for configuration, data conversion, interfaces, reporting, and customization of the system.
• Promoted due to demonstrated technical skill set, superior planning and organizational skills, and the ability to grasp new and challenging software applications quickly.
• Integrated a team, of legacy mainframe developers with 25 years of tenure and VB developers that were freshly hired, into a cohesive and enthusiastic functioning group. Reinforced team-building concepts by valuing differences, knowledge sharing, assembling varying perspectives, and seeking the best possible alternatives as a group.
• Organized the development of instance management procedures, which encompassed program object naming conventions, versioning and promotion utilizing Visual SourceSafe. Over 1000 custom objects were involved in the production installation of the first system module, which was accomplished competently and on schedule.

Environment: Oracle Applications 11i OSS, CRM, GL and AR, Oracle RDBMS 8.1.7, TOAD

Oracle Applications Architect

• In support of Tulane's role as an Oracle Partner in the development of a new student system module OSS , key responsibilities included functional analysis, the design and implementation of application extensions and external interfaces, and the conversion of legacy data.
• Provided technical insight to the functional team in the high-level design process, function and data-level security options, the assessment of functional gaps, and the setup and configuration of a conference room pilot CRP .
• Educated legacy system developers on the Oracle Applications infrastructure in terms of application security, the application file system, database schemas, concurrent processing, extension strategies, and supported methods and best practices for migrating legacy data.
• Streamlined the implementation methodology based on AIM deliverables for setup and configuration, data conversion, business requirements mapping and gap identification.
• Assessed extraction, transformation, and loading ETL options and developed a data conversion strategy that allowed for the mapping of data elements between the legacy system and OSS as well as the tracking of transformation rules using metadata from both systems.

Confidential

Environment: Oracle Applications 11.0.3 GL, AP, PO, AR, OE, INV, BOM, CS and OTA, Oracle RDBMS 8.0.5.1, Oracle Developer 1.6, TOAD

Manager of Strategic Applications

• Responsible for the support, upgrade, and extension of the Oracle Applications to ensure the functionality and reliability to meet ongoing business needs.
• To meet a Y2K objective, implemented the Oracle Applications in 2 months with minimal resources and no prior experience with the applications. Hired and supervised 5 contractors. Identified, planned, analyzed, and executed critical path tasks to meet the go-live date.
• To meet corporate merger and consolidation objectives, accomplished data conversions for four companies in less than 2 years. Interpreted Oracle Open Interfaces for Customers, Items, BOMS, and Material Transactions. Performed data mapping from legacy systems, developed specs for PL/SQL validation and transformation programs, confirmed results.
• Executed applications administration functions such as the definition of custom responsibilities, flexfields, and value sets and the registration of new program objects.
• Scheduled, monitored, and resolved problems with concurrent processing including Inventory Interfaces, Material Transactions, and Auto Invoicing.
• Attained detailed understanding of data flows and relational data structures across the application modules. Trained staff on data structures for the implementation of a data warehouse.

Confidential

Environment: Oracle RDBMS, PeopleSoft

Principal Information Engineer

• Contracted to Lockheed Martin for the implementation of the Navy Standard Integrated Personnel System NSIPS .
• Quickly demonstrated aptitude to apply technical knowledge to identify and solve unusual problems after completing only introductory training in PeopleTools and PeopleCode.
• Solicited to perform the role of a technical lead to assist in the mentoring of other developers. Conducted design peer reviews and code reviews.

Confidential

an affiliate of international shipholding corporation

Environment: Oracle RDBMS, ERwin, SQLWindows, Microsoft Access, Lawson Case Tools / MicroFocus COBOL, IBM VM-VSE/ESA, ADABAS, NATURAL, CICS CMD /COBOL, VSAM

Senior Systems Analyst

• Acted as Project Leader in a series of projects to migrate legacy systems from a mainframe platform to a client/server infrastructure for the implementation of a strategic plan prepared by Andersen Consulting. Administered performance appraisals, hiring decisions, training plans, and budget projections.
• Distributed Computing Tools Software Selection / Technology Analyst
• Responsible for the research, evaluation and selection of a relational database management system, data modeling tools, middleware, and GUI front-end processors for rapid application development with a total project budget exceeding 200,000.
• Established guidelines for change management procedures using TeamWindows GUI design considerations naming conventions and modular structuring of reusable components for SQLWindows development, and naming conventions for database objects.
• Expedited database design and development efforts with the use of a data modeling tool, namely ERWin. Trained staff on concepts such as data modeling notations, normalization, cardinality, referential integrity, surrogate keys, indexing, constraints, and views.
• Lawson Financial System Implementation
• Technical advisor for cross-departmental team to evaluate and select a COTS solution for AR, AP, and GL applications. Conducted market surveys, screened potential contenders, scheduled vendor demonstrations, and assessed finalists based on RFPs and strategic technology directions.
• Led the IS implementation team. Developed programming standards for newly introduced Lawson Case Tools. Prepared project schedules. Supervised 5-6 programmers. Directed resources for DBA and UNIX administration activities.
• Insurance and Claims I C Contingency Migration / Application Specialist
• When faced with a lack of resources to meet a fixed deadline, devised a contingency plan for migrating the I C system off the mainframe. This consequently allowed dated hardware / software to be removed in a timely manner thereby significantly reducing operating costs.
• Adapted a mainframe CICS/COBOL application using VSAM data structures to a Microsoft Access application within a 2-month period. Developed tables, forms, reports, and event driven Access Basic modules to support detailed business rules.

Confidential

Environment: IBM OS/MVS, JCL, NetMaster, TSO/ISPF, ADABAS, NATURAL, COBOL

Senior Analyst / Programmer

• Served as primary contact with user community for the definition of information requirements performed systems analysis and design developed systems specifications, test plans, manpower resource estimates, and project schedules managed resources, schedules, and communications for projects within the Medicare Claims/Remittance Processing MCP application.
• Solicited expressly by the user community to provide consulting services for vital projects due to demonstrated application expertise and technical competence, proven ability to interpret vague user needs and wants, and established reputation for organizing workable and efficient solutions.
• Strengthened the analytical skills of the project application team by initiating the use of DeMarco/Yourdon structured analysis and systems design techniques.
• Guided all project aspects from beginning to end for the implementation of a new MCP sub-system to facilitate the re-filing of Medicare insurance claims. The new functionality streamlined AR open items and reduced the level of manual intervention required.

Confidential

Environment: IBM OS/MVS, JCL, NetMaster, TSO/ISPF, CICS CMD /COBOL, SUPRA, VSAM

Programmer / Analyst

• Designed, coded, tested, installed, and maintained programs in the Equipment/Inventory Control ECOS application. Supported the development effort using Warnier/Orr structured analysis techniques.
• Audited existing equipment dispatching procedures, overhauled information requirements, and pinpointed automated solutions. The revisions improved the utilization of inventory levels and thereby reduced costs associated with equipment leasing.
• Revised database files using normalization techniques, which reduced extraction time by 85 .

Professional

Development

• Self-study on data warehousing best practices including the Kimball Toolkit series and Mastering Data Warehouse Aggregates by Adamson.
• Completed Microsoft Certified Training for SQL Server 2005 to include SSIS, SSRS, SSAS.
• 16 days of courses for PMP certification with a PMI Registered Education Provider.
• Compulsory courses to earn an Oracle Masters in Application Development including PL/SQL, Developer/2000 Forms 4.5 and Reports 2.5, Extending Oracle Applications, Defining Flexfields
• Seminars including Dr. Covey's 7 Habits of Highly Effective People and First Things First .