Database Architecture Resume Profile
5.00/5 (Submit Your Rating)
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 t 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 t 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 t use predictive methodologies. Excellent oral, presentation and written communication skills known as keen motivator. Talent for articulating complex concepts t 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 t netting more than 1.2 million in the past tw 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 t integrate ODS t 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 t integrate ODS t 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 t 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 t 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 t additional contracts. Awarded Excellence in Performance honor and monetary compensation. Leveraged research performed t win RFP t 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 t provide cost-saving analysis and innovation t Remedi.
- Designed, developed and deployed various utilitarian solutions t remediate process workflow and functional gaps in the Remedi business model including:
- Pricing utilities t allow for re-pricing, analytical services around product pricing
- Inventory management for identifying, counting and asset valuing inventory
- Costing mechanisms t produce accurate COGS
- Revamp metadata derivation for Automated Therapeutic Interchange, allowing best price medication substitutions t 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 t generate java beans J2EE for applications.
- Evaluated COTS and smaller third party solutions. Estimated costs for all aspects of deployment.
- Analyzed, revised and contributed t 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 t 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.