John Mcshane Email & Phone Number

Bern, CH

Bern, CH

Lead a high-performance team in a challenging and dynamic environment where information technology is used as the foundation for business execution. Developed an enterprise application that drives competitive advantage, customer service, financial growth, and shareholder value. Enable returns on IT investments through thoughtful and careful architecture.

Philadelphia, PA, US

• Led the designed, development, and implementation of the firm's data driven projects and solutions.
• Designed and developed business intelligence solutions for specific cases and clients.
• Designed and implemented data integration solution to simplify the firm's enterprise applications integrations.
• Designed and implemented an enterprise data warehouse solution to simplify the firm's reporting.
• Initiated and lead the design of the Firm's custom Document Risk Management system. The system was designed to monitor attorney document activities that posed a risk to the firm and its clients. As the results, achieve.
• Led the database services team to migrate over 150 production databases and applications from SQL2000 to SQL2005/2008 leveraging all new features and functions available within SQL2005/2008. In addition, rewrote 100+.

Newtown, PA, US

• Instructor for database related technologies:
• Introduction to SQL
• Microsoft SQL Server Business Intelligence Certification
• Microsoft SQL Server Administration Certification
• Center for Workforce Development - Taught Advance Query and Performance Tuning class to corporate clients

Paris, FR

• Provided broad-based IT and database leadership and support for the consumer products division
• Progressed from a role as dedicated DBA to excel as Data Warehouse Manager providing hands-on leadership on a range of projects.
• Coordinate with other IT and business units, including developers and analysts, to propel project goal attainment. Train and mentor database and application developers on data integration methodologies and the use of.
• Enterprise Data Warehouse – Drove planning and development of ETL processes for two data warehouses with over 2TB of data running on Oracle and DB2. Provided 24x7 support for 200+ ETL processes consisting of internal.
• Clustered SQL Server 2000 – Installed and configured a development, QA and production environment, supporting over 40 production-related databases and applications.
• Spearheaded the design, installation, and configuration of a new production environment within ETL Informatica PowerCenter, streamlining the development process and increasing consistency among developers.

Austin, TX, US

• Promoted to facilitate database implementation and product development specifications activitieswhile supporting team of 40+ application developers and resolving customer database issues forbase of 200+ users. Created.
• Created online data dictionary for developers that enabled internet access to database information for both developers and customers and expedite report generation.
• Taught three-day SQL Server 2000 Administrator class for employees and customers anddelivered presentations at user conferences covering advanced techniques and peak performancestrategies.
• Promoted to serve as Technical Lead for DBA group; built strong relationships with developers.
• AIX System Administrator / Level II Technical Support Representative
• Managed UNIX-based network running on AIX system and provided technical support for200+ customers. Performed diagnosis, installation, configuration, troubleshooting, repair, andhelpdesk support functions to ensure.