James Watson Email & Phone Number

Freeport, Fl, Us

Destin, Florida, United States

Joined the Legalserver team in 2014. Instrumental in reducing the time needed for clients migrating data to LegalServer - what used to take days is now achieved in a few hours. Data conversion & migration from various sources include MSSQL Server, Excel, MS Access, FoxPro, and others using a custom import framework I developed. Daily duties include extracting, cleansing, matching, and loading data from multiple disparate systems. Daily technical environment includes object-oriented development in PHP and Postgres SQL in a Linux environment. ETL knowledge gained using Pentaho Data Integration

Developed database architectural strategies at the modeling, design and implementation stages to address business requirements, and provide efficient transactional and reporting features.Designed and implemented complex data models for financial data warehouse. Designed and implemented warehouse database structures.Developed data warehouse process models, including sourcing, loading, transformation, and extraction.Designed, implemented, and operated comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.Designed databases to support business applications, ensuring system scalability, security, performance and reliability.Developed and implemented data extraction procedures from other systems.Developed databases to support web applications and web sites.Designed and developed custom internal support applications.Developed supporting code for web applications or web sites.SQL prototyping; tables, procedures, and functions.UI wireframing, mock-ups, and prototypes.Coordinated and reviewed work of offshore ETL developers.Developed highly complex SQL statements to simplify the processes that consume data.Analyzed SQL execution plans; tuned SQL and adjusted indexing to provide optimal performance.Provided technical support to junior staff and clients.Analyzed user needs to determine technical requirements and feasibility of design within time and cost constraints.Recommended and implemented performance improvements.Application ArchitecturesOracle, DB2, MySQL, C, Java, MVC, Rest, PHP, JavaScript, HTML, jQuery, AJAX, JSON, jQueryConceptsUser interface design (UI)User experience, including information architecture and interaction design (UX)Front end development (FED)Data extract, transformation, and load (ETL)

Recruited to automate order entry, inventory tracking, and overall office processes. Installed companies first computer network and developed a highly customized sales & inventory tracking system that dramatically improved efficiency, decreased expenses, and optimized data integrity.* Computer programming utilizing Visual Basic, Microsoft Access, Clipper, and Visual FoxPro* Novell network OS installation, maintenance, and administration* Windows NT client workstation configuration and support

27Th Fighter Wing

Responsible for maintaining optimal performance of aircraft electronic equipment – focusing on radar, communications, navigation, flight control and flight data recorder systems. Test, maintain, repair, align and inspect both the aircraft equipment and the associated test equipment. Honor Graduate - Completed technical school with 98% GPA. Discharge Status: Honorable