John Clasing Email & Phone Number

Västerås, Se

Stockholm, Stockholm County, Sweden

Sweden

Roles:• System Analyst• Database Specialist• DBA• Project Management• Development• System ManagementCustomers:• Worldline/Bambora• Scania• Klarna• ZoovillageTechnical Summary:• Extensive experience in SQL data modeling and relational database design/creation • Extensive experience in SQL SERVER (T-SQL) • Extensive experince in SQL Server Management Studio (SSMS), SQL Server Profiler, Database Engine Tuning Advisor & Red Gate Toolbelt• Extensive experience in SQL Server performance tuning and writing advanced SQL queries• Proficient in SQL Server DBA tasks• Proficient in MYSQL & ORACLE databases (PL/SQL) • Proficient in MySQL Workbench, SQL Developer for Oracle and Toad• Extensive experience integrating and migrating business systems, mapping data, importing/exporting/converting data and normalizing unstructured data• Proficient in developing web and windows applications• Proficient in Visual Studio .NET, C# and ASP.NET, JAVA, JQUERY, CSS, JAVASCRIPT, C, PHP and Unix scipting• Extensive experience with implementations, customizations and rollouts.• Proficient in test case design and development• Proficient in MS Office, including Access, MS Excel (VBA), Visio and PowerPoint • Proficient in VBScript, VBA/Excel and other proprietary scripting languages• Experience with full Software Development Life Cycle, system architecture and design• Experience with change management and version control using Team Foundation Server (TFS) and Git• Excellent communication, analytical, and interpersonal skills.• Able to work efficiently with both technical and nontechnical teams to develop complex projects• Expertise in ecommerce and experience in various other sectors as insurance, consulting, support, transportation industry and government.• Extensive experince in Agile development

Västerås, Vastmanland County, Sweden

Sodertalje, Sweden

• Collected and inserted data (ETL) from various sources to implement a contract management tool in all new markets • Model and design backend data stores and enhance existing databases. Design and create new databases and database objects. • Performance monitoring and tuning of local and global SQL Server databases.• Implementation, customization and rollouts of new contract service products in all global markets.• Create scripts and automation processes for data collection, integration and reporting. • Provide technical leadership for development team for all changes in SQL Server databases• Provide technical leadership for development team for all changes in MySQL databases• Provide technical leadership for support team on issues in SQL Server databases • Work with business units to analyze business processes, develop requirements and solutions.• Migrating data from various resources to SQL Server databases.• Migrating data from various resources to MySQL databases.

Stockholm, Sweden

• Managed, developed and maintained all IT systems and application at Zoovillage.com, Sweden’s oldest and leading online store for clothes, shoes and accessories.• Designed, developed and deployed a new web shop in ASP.NET. The shop is designed to handle multiple currencies and languages and now ships to 40 countries. Agile methodology used throughout the project.• Converted a web shop from VB6 to .NET• Managing all SQL servers with regards to design, DB changes, development of stored procedures and performance tuning.• Developed a new Order Management Tool for the customer service department in C#. The tool handles all returns and exchanges with API’s to 3rd party payment providers and Zoovillage’s financial system (Epicor).• Developed an API in C# that automates the process of sending new orders and customers to Epicor. It also exports and controls data for a 3rd party payment provider, i.e. Klarna that handles all orders paid by invoice.• Maintenance and added functionality of the pick and pack application written in .NET 1.1• Maintenance and added functionality of the Product Management Tool written in VB6.• Work with business units to analyze business processes, develop requirements and test plans, and provide documentation, training and on-going system support and maintenance.Manage developers, contractors and all outsourced projects as well as 3rd party provider of hardware and networks.

Greater Los Angeles Area

• Managed an eyewear startup company designing, producing and selling eyewear

Corvallis, Oregon Area

• Development, test, deployment and assist the support team working with various business systems for the IT Hardware Support Group.• Development and maintenance of interfaces to external business partners (e.g. FedEx) in UNIX and C.• Maintenance and support of batch processes in an HP3000 environment.• Duties included being on-call 24/7 one week every month.

Portland, Oregon Area

• Part-time tester while completing my B.S. at Portland State University.• Test of localized software products developed by Intel for their network cards.• Installation of various Microsoft operating systems.

Uppsala, Sweden

Intrustworld build IT solutions for the insurance indus• Designed and implemented the data model for a life insurance system in SQL Server.• Developed scripts in Transact SQL (T-SQL) to ensure proper data in all databases.• Managed all traditional DBA tasks as performance tuning, backups and security.• As a second role in the development cycle I took on a role as a test leader.• Developed some parts of the business layer in VB.

Portland, Oregon Area

• Worked on multiple project for Hewlett Pack.• Developed back-end applications in PL/SQL for hpshopping.com.• Developed back-end applications Unix and C for the financial team of HP Latin America.• Developed a reporting tool PL/SQL and Microsoft Access to find discrepancies for the financial team of hpshopping.com.

Vasteras, Sweden

• Developed a web shop for Bolagsverket in Oracle Designer/2000 and PL/SQL.• Lead development and test teams using iterative development methodologies.

Bs, Computer Science

Activities and Societies: Intramural Sports. Worked as the Head of Intarmural Sports.Major: Computer Science Minor: Biology.

Applied Mathematics, Computer Science & Information Systems