| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLESenior Data Architect and Performance ExpertStrong problem-solving skills. Quickly moves from business needs to data structures, with a grasp of how data applications should work between the two. Learns new systems quickly and sees how to enhance performance.Extensive experience designing and writing complex applications, introducing distributed data structures, and integrating stove-piped systems into the enterprise. Countless extensive reporting systems, insurance applications, and web hosting for over a hundred sites. Have worked with live feeds from newspapers, airports, weather services, and kiosks.Education: Yale (BA), Harvard (MA), University of California San Diego (PhD)Databases:Microsoft SQL-Server 2000, 2005, , 2016, 2017Oracle, MySQL, Postgres,SAP HANA, Access 2000, 2003, 2007, 2010Languages: T-SQL, PL/SQL, VBScript, HTML, JavaScript, PowerShell,
Data Tools: SSMS, SSRS, Excel, Oracle SQL Developer, ColdFusion, PythonCitizen: USExperience: Database Developer, Data Modeling, Data Integration, Data Warehouse,Dimensional Modeling (star, snowflake)Performance tuning: SQL, Oracle, HANA, MySQL, etc.; Procedures, Triggers, Applications.Expert with Central Server Management features in SQL Server (SQL 2008 and later)Looking to make a difference:project rescue; mentoring others;consolidating architectures for warehouse or reporting;resolving performance problems . Candidate's Name Work History2015-2018 Chief Data Architect, KSM ConsultingArchitect/Developer on several major data projects for the State of Indiana.Worked closely with ETL team to prepare and structure data for Data Science team.Built analytic reporting systems foroDept of Corrections (recidivism)oDept of Revenue (tax fraud)Built Data Warehouse with Analytic Reporting for Dept of Child Services.Data Architect for the Governors Mgmt Performance Hubs multi-dept effort using data from education, early childhood programs, and wage reporting; enabling long-term analysis of program efficacy.2011-2014 - Enterprise Data Architect, HP Enterprise ServicesNMCI -- Navy Marine Corps IntranetData Governance / Master Data Management / Data Performance / Configuration BaselineEstablished an automated central catalog of all SQL Servers; catalogued all network databases (approx. 900) according to owner and function, software versions, and hardware beneath, as well as general hygiene. This enabled re-architecting several infrastructure applications to conserve network resources and dramatically reduce annual license costs.(one million dollar annual savings).Designed the data structures to produce the Product, Functional, and Allocated Baselines for NGEN, the next major phase of the Navy networks. Identified authoritative sources, designed tools to capture missing elements, coordinated efforts between teams, integrated multiple departmental models. (PL/SQL)Data Architect, Enterprise Management Systems, with responsibility for data integrity throughout the primary ITIL applications and through all discovery and network management tools used in support of the Universal Configuration Management. Worked with technical lead on each team to analyze and refine data products, reconciling each to others. (PL/SQL)Worked with ETL team for the NMCI Project, tuned troublesome procedures and structures; introduced new SQL techniques reducing nightly run time by 50%, meeting OLAs, and alleviating concerns about system resources. Mentored the ETL team on writing more efficient PL/SQL code and on Oracle database configuration for performance.Instituted Master Data Management practices throughout the NMCI network. Added special application to assess and compare progress across systems.Provided SQL support (T-SQL and PL/SQL) to Production groups. Analyzed slow-running applications and queries to tune database operations across the network. Mentored production staff on using indexes to tune performance of Oracle database systems.2003-2011 Data Architect, US Navy SPAWAR Logistics
Developed an Data Warehouse for the Navys Program Management Office to integrate and report multiple contractor and government data systems, assisting the Navys Systems Command in receiving/tracking/driving the ten-billion dollar NMCI project.(ColdFusion over T-SQL)Provided secure data access to Navy users across the country and throughoutEurope and the Far East.Used Agile development approach, standing up dozens of applications in responseto emergent requirements.Developed Base Logistics Information system to track network spare parts inventories for the Navys ONENET network. (For bases outside the US.)2004-2007 Data Consultant, US Marine Corps (PM MCNIS )Developed new USMC Command Budget System.Identified millions of dollars in mid-year de-obligations to fund PM MCNIS operations.2000-2011 Independent Developer, Carpenters UnionA tour-de-force application for the Southwest Regional Council of Carpenters, providing automatic, SQL-based job matching for 65,000 union workers in seven states. Three different technologies blended in one application.Asterisk-based IVR call-in system lets members join lists and request dispatch dates.ColdFusion web interface directs dispatch of members to matching jobs.SQL code managed all queuing, eligibility, selection logic, and business rules.1992-2002 Independent Developer, Arrowhead General InsuranceDesigned and produced systems to integrate 5000 independent agents as a virtual network, linking their remote offices to the Managing Agent in Mira Mesa.generating new auto insurance applications, with on-the-spot binding,ordering thousands of motor vehicle reports per week, into the underwriting department.Dynamically configuring each branch or location to allowed business lines and limitsPre-Internet, so I wrote all modem handling and file transfer routinesPre-Windows, so I developed custom drivers for dozens of printers.Manufacturing and Logistics: the EightiesDigital Equipment / Seminars Program 1980-1990 Instructor/AuthorHired by Digital as the leading expert on their Datatrieve product, to develop an advanced database curriculum, and to teach the Advanced Database Design and Programming seminar, using that text.The seminar was offered roughly every 6 weeks, traveling across the country, for ten years.The Architects Collaborative 1979-1989 Software ConsultantDesigned and produced a total project management system for this renowned Bauhaus Design firm that helped prepare quotes for large projects (for example, an entire university) and then drove the proposal from quote to project tracking to completeness reporting and budget analysis with labor and expenses.Reebok International 1983-1986 Ind. Systems Architect/DeveloperWorking closely with the CEO, transformed business requirements into software logic to help this sneaker startup grow to an industry leader by providing applications for each phase of wholesale distribution: order taking, overseas procurement, shipping, billing, commissions. Provided hardware systems and custom software systems.Digital Equipment Corp 1977-1988 Ind. Application ArchitectApplication architect for DECs conversion of customer-related systems from mainframes housed in Maynard, MA onto a network of PDP11s across the country. Also designed and produced numerous other systems for marketing, dealer matching, field service performance, and spares replenishment across all sites. Wrote and supported (for 9 years) a comprehensive Quality Assurance reporting system for all training courses and other training products.Ionics Incorporated 1978-1985 Ind. Systems Architect/DeveloperDeveloped a full factory management solution: Inventory Control, Purchasing and Receiving, and Requirements Planning for this manufacturer of desalination equipment. Dashboards allowed CEO and VPs to drill to any level of detail in any project.On-line Solutions Before the InternetU S WEST 1990-1991Designed a multi-protocol router to allow packet networks to host French and American data systems simultaneously. This enabled distribution and support of European terminals in the US context. ( X.25 networks, before Internet Protocol ((TCP/IP)) was available).Bell Atlantic 1987-1988Designed and operated a service bureau to allow the Bell Atlantic to host dozens of information services on its X.25 networks. Each Information Provider ran on the CitiNet software or on custom additions to that.NYNEX & SIEMENS 1986-1987Designed an architecture for X.25 networks to direct all dial-in users to a portal node, allowing users to connect to different information providers in a single network session, with transfers between hosts managed by the network itself. (Similar to automatic call forwarding from one site to the next.)Boston CitiNet 1984-1990Developed one of the very earliest on-line services linking tens of thousands of users with 90 information providers and vendors. CitiNet operated local portals throughout New England, New York City, Philadelphia, and Omaha.Three online pioneers in the newspaper industry (Newsday, Boston Globe, Philadelphia Inquirer) were actually hosted on the CitiNet system in Boston.This service offered online weather reports and pioneered online sales of music disks, Vermont cheese, VCRs, cookies, flowers; and introduced automated lead capture into American commerce.See in Wikipedia: http://en.wikipedia.org/wiki/Boston_CitiNetAsk me also aboutSan Diego Eye Bank (tissue bank), Anchor Insurance (MGA), Sammys Pizza (restaurant chain),Gillette (blades), Remington Arms (munitions), Brockton Enterprise (newspaper),Lotus Development Corp (Lotus 1-2-3 business reporting), UnterbergTowben (IPO software),Bartlett Farms (Geraniums), UCSD (A/V scheduling & management). |
