We provide IT Staff Augmentation Services!

Database Architecture Resume Profile

PennsylvaniA

BUSINESS IT DEVELOPMENT EXECUTIVE

  • Lifecycle Management Team Building Strategic Planning
  • Visionary Business Intelligence Leader, with expertise in multimillion-dollar, real-time software/systems development solutions to align with strategic organizational objectives. Critical thinker, adept at establishing and tracking key performance indicators. Strong leadership and solid issues-resolution experience, with record for bringing together diverse groups to achieve common goals. Successfully manage all stages of project lifecycles: initiation/planning requirements gathering and analysis architectural design implementation and maintenance oversight. Demonstrated data modeling and mining expert, with ability to use predictive methodologies. Excellent oral, presentation and written communication skills known as keen motivator. Talent for articulating complex concepts to technical and non-technical audiences. Additional core competencies:
  • Resource Policy Planning SDLC Methodologies Staff Performance Management
  • Programming Databases SOX Compliance Training Development
  • Architectural Design Technical Documentation Enterprise Applications Integration

CAREER ACCOMPLISHMENTS

REMEDI SENIORCARE

  • Provided new innovations around several key business areas needing remediation:
  • Product Inventory Management
  • Product Pricing and Billing
  • New Business KPIs around Resident Days a paradigm shift in financial performance metrics
  • Automated Therapeutic Interchange for substitute drug ordering
  • Confidential Developed database yielding nearly 600,000 in revenue from data sales. Additional initiatives described below for tracking company dealings with drug product manufacturers add to netting more than 1.2 million in the past two years:
  • All of above executed with a lean team of developers and analysts providing needed budget relief from salary overhead
  • Established an full-solutions Enterprise Data Store EDS : Researched and deployed database and information dissemination technologies, introduced innovative Role Based Security model, developed replication and ETL processes from source systems, created unique class-based data deployment model facilitating rapid and consistent report development with all transformation functions. Implemented schematic architecture to integrate ODS to corporate software/systems development lifecycle SDLC , including quality assurance QA .
  • Established operational data store ODS : researched database technologies developed replication and ETL processes from source systems created unique class-based data deployment model facilitating rapid and consistent report development and developed all transformation functions. Implemented schematic architecture to integrate ODS to corporate software/systems development lifecycle SDLC , including quality assurance QA .
  • Pioneered enterprise database for master data management MDM by: selecting technical architectural components designing data flow between major enterprise systems identifying data stewards within the organization modeling all tables in database, working with GUI designers on maintenance screens and testing all results.
  • Confidential Managed team of up to 11 developers, business analysts and programmers. Co-led Technical Design Group. Headed staff meetings. Coached developers/business analysts about architecture, functionality, QA testing, and proofs: test plan development, data test bed derivation, and testing maintenance/environments. QA methodology saved the company money, time and auditing concerns due to mitigated risk.
  • Liased with upper management, development staff and potential/existing clients, regarding development and maintenance projects for millions of dollars in new business initiatives. Advised corporate leadership and customers on proper technology directions.
  • Secured 3 million annual RFP for the company, which lead to additional contracts. Awarded Excellence in Performance honor and monetary compensation. Leveraged research performed to win RFP to innovate and present Standard System, saving the firm 2.5 million minimally in overhead. Initiated re-engineering that restructured software system for 11-states' Medicare claims processing.

PROFESSIONAL EXPERIENCE

Confidential

Director: Enterprise Systems

  • Full responsibility for enterprise vision-related processes, technologies and business priorities.
  • Hand-on responsible for ground-up development of Enterprise Data Store including multi-source replication, Operational Data Store, MDM Services, Operational/Analytical and Customer Facing reporting services.
  • Managed and mentored a lean team of developers and data analysts to provide cost-saving analysis and innovation to Remedi.
  • Designed, developed and deployed various utilitarian solutions to remediate process workflow and functional gaps in the Remedi business model including:
  • Pricing utilities to allow for re-pricing, analytical services around product pricing
  • Inventory management for identifying, counting and asset valuing inventory
  • Costing mechanisms to produce accurate COGS
  • Revamp metadata derivation for Automated Therapeutic Interchange, allowing best price medication substitutions to occur during order entry
  • Deployed Jaspersoft, an open source reporting tool providing advanced reporting and visualizations at a low cost
  • Developed and deployed metadata-based ETL process. Designed, created and implemented replication reconciliation process.

Confidential

Director: Application/Database Architecture

  • Spearhead re-engineering enterprise-wide data flows and processes, including all architecture for enterprise systems and database development for operational and data warehouse needs.
  • Supervise five developers and six QA team members. Provide evaluations and career path development. Mentor junior architects and developers.
  • Advise officers regarding enterprise vision-related processes and technologies.
  • Teach SQL and architectural design classes for technical staff. Conduct functional design sessions with business subject matter experts.
  • Author documentation for enterprise data architecture.
  • Collaborate with external customers regarding reporting needs. Prototyped MS Reports architecture.
  • Evaluate tools and commercial off-the-shelf COTS applications for enterprise reengineering. Code ODS functions and utilities. Install, configure and tune Oracle and SQL Server databases.
  • Developed and deployed metadata-based ETL process. Designed, created and implemented replication reconciliation process.

Confidential

Director: Database Architecture

  • Derived departmental SDLC and internal regulations for compliance with SOX initiatives.
  • Oversaw architecture, development technology and standards creation for all operational and data warehouse enterprise systems. Designed code to generate java beans J2EE for applications.
  • Evaluated COTS and smaller third party solutions. Estimated costs for all aspects of deployment.
  • Analyzed, revised and contributed to derivation of functional specifications for various projects.
  • Led database API development: Smalltalk, ASP, Flash, ColdFusion and Crystal Report applications.

Confidential

Manager: Application/Database Architecture Designed client server and mainframe applications. Decision support systems DSS encompassed derived complex statistical data elements, high-speed query performance, and task schedule management to maximize database availability. Recognized and awarded for database and system design achievements.

Confidential

  • Lead Systems Architect / Project Manager / Developer Supervised developers and database administrators. Conducted performance/salary reviews.
  • Managed projects and daily systems, including mainframe, client server, data warehousing design, development, deployment and maintenance.
  • Developed high proficiency in Assembler and SQL. Received awards for outstanding achievement.

Hire Now