Design Sql Server

Asif Sajjad

*** ***** ****, ********** ** *****

314-***-**** ***.******@*****.***

Sr. SOFTWARE ARCHITECT

IT leader with 15+ years of experience providing strategically aligned Enterprise solutions on an international level and across multiple industries. Extremely proficient in Enterprise and solution architecture and multiple key IT delivery approaches, including: Agile, SOA, EAI/ESB, TOGAF, RUP. Collaborates closely with executives, management and personnel to drive innovative and forward thinking software that aligns with market trends and business goals. Background includes all phases of software development lifecycle, from initialization to final closure.

AREAS OF EXPERTISE

Business Information and Technology Architecture SDLC Optimization

System Integration Release Management High Availability

Continuous Improvement Software as a Service E-Commerce

Web Services Client / Server Architecture Agile / Scrum

B2B Solutions Enterprise Integration

PROFESSIONAL EXPERIENCE

DaVita, Dallas, TX December 2012-Present

Lead Integration IT Architect

Primary Leader in planning, development of company’s IT Architecture strategy encompassing architecture, governance and consulting services of all aspects of architecture such as information and technology initiatives

Collaborate with senior leaders across all business units to design, develop and deliver IT solutions that balance strategic objectives of the company with acceptable quality, risk and cost

Responsible for JBoss middleware architecture such as JBoss EAP, Fuse ESB, ActiveMQ, Fabric, Spring and Spring Integration

Responsible for selecting and implementing, Splunk, Git, Artifactory, Stash, JIRA, Clover, Sonar and Confluence

Key Accomplishments

Solution delivery optimization: applied Lead and Agile methodology best practices to significantly improve SDLS efficiency by 10%, approximately $500K

Technology roadmap: introduced the concept of technology radar for the enterprise to map out current and future technology needs and help reduce technology fragmentation resulting in annual savings of $700K

IT integration roadmap: leverage standard JBoss (FUSE, AMQ and EAP) technology and industry standard technologies (Hibernate, Spring, ESB, JMS, Camel, JUnit) to reduced system and data integration complexity costs by 20%

Major initiative to overhaul current IT infrastructure and technology portfolio resulted in skill consolidation by replacing old systems with CRM, CDR (Clinical Data Repository), PMP (Pharmacy Management Program), EMPI (Enterprise Master Patient Index) and HIE (Health Information Exchange) and created use cases, success criteria, RFI and evaluated RFP for vendor selection

New capabilities:

oLead the design effort of integrating Oracle Financials with internal systems reducing billing turnaround time by 30% and increasing collections by $2.5MM

oLead the design and development effort of middleware to integrate back end VMS, reporting and shipping systems with McKesson dispensing system which reduced cost by $700K

FedEx Corporation, Dallas, TX November 2011-December 2012

Expertise used: JAVA 1.6, Spring, Hibernate, JMS, EJB 3.0, Weblogic 10.3, JBoss 7.0, Oracle 11G, Flex 3.0/4.5, JUnit, Clover, Sonar, Hudson, Scrumworks, Agile Development

Solutions Architect

Incorporating Open Group Architecture Framework (TOGAF) in architectural design decisions and software development.

Using UML extensively to document current and future system state, the documentation provided included Software requirements specification, Technical specification document, Activity, State, Network and sequence diagrams.

Assisted in design and development of integration tools and applications for ERP and back-end office collaboration between e-Procurement application and existing ERP system

Designed and developed a unit testing framework using JUnit and H2 to facilitate integration and unit testing with back end system, resulting in a reduction of Oracle licensing cost by $250,000 per year

Upgrading older systems to newer technologies using Spring

Providing in-house customization of e-Procurement application for global clientele

Active member of FedEx Innovation Team to build future technology radar and drive the effort to move from Flex to HTML 5

Working with third party vendors to develop mobile solutions for platforms such as Android and IOS

Working across team to incorporate Agile methodologies such as Scrum meetings, continuous integration and Test Driven Development

Monsanto Company, Saint Louis, MO 2001-2011

Technical Architect, 2008 – 2011

GQA (Genetic Quality Lab)

Responsible for architecture design of global project to connect quality testing labs with SAP and data warehouse

Leading a team of 6 developers in all aspects of SDLC

Application front end is developed using Flex 4.5 while the backend processing is performed using Java

Application is developed using TDD methodology allowing us to achieve 90% test coverage and 3% cyclomatic complexity.

Mentoring developers on design patterns, OOA and OOD

Using SQL Server CDC to capture data changes for downstream processing

Technologies used: Java 1.6, Hibernate, Spring, Weblogic, Flex, SVN, Oracle 11g, SQL Server 2008, Test Driven Development, Agile, JMS

Technical Architect

FIDO (Field Information Data Organizer)

Responsible for the architectural design and oversight of US$2.5 million Project: Field Information Data Organizer (FIDO), handheld tool for Windows Mobile 5 and 6.1 Operating System. The application is used for quality data collection during crop production using handheld devices such as HP IPAQ, Symbol MC9090 and MC75. The application enabled Monsanto’s crop planners to have latest information about crop yield from Argentina to Indonesia, saving an average of $1 million each year in manual labor.

Developed front end using .Net CF 3.5 for handheld and Silverlight 3.0 for the website, developed backend SOA piece, written in Java using Hibernate, EJB 3.0 and Web logic

Wrote a custom synchronization process to transfer data between the handheld and central database using MSMQ

Lead the global implementation of FIDO in Asia Pacific, Brazil, Argentina, Chile, Canada, Mexico and United States

Manage eighteen developers and testers

Co-Lead Test First Development Mentoring Virtual Team: the team is responsible for implementing best practices for Test First Development across Monsanto Commercial Organization (200 developers), standard practices include TeamCity build server, Clover coverage, Cyclomatic Coverage and average

Technologies used: .Net CF 3.5, .net 4.0, LINQ, Ninject(Dependency Injection), Silverlight 3.0/4.0, EJB 3.0, Weblogic, ASP.net, Resco Grid, Maven, SVN, MSMQ, Hibernate and SOA.

Integration Architect, 2005-2007

(Plug-in based architecture providing customized solution to Monsanto’s Research Community)

Green House and Lab Book Plug-in

Actively involved in all aspects of design, development, and analysis

Served as an expert for application and database performance tuning

Actively involved in the functionality of import, cross plug-in communication and filtering

Developed SOA communications between client and server

Inventory Manager Plug-in

Architected and developed this plug-in for tracking of inventories in a storage unit in a warehouse

Served as an expert for application and database performance tuning

Technologies used: AquaLogic BPM, Struts, JSP,Maven, Java, Hibernate, Kerberos, SOA, Test First Development, J Unit, Tomcat, Apache, Swing, Design Pattern, Clover, Ant, Spring Workflow, Oracle, Jakarta-POI and Java1.4

MIDAS (C# Solution)

Designed and developed MIDAS desktop application using Microsoft .Net technology

Created Archiving, Protocol Management and Read Only modules

Providing capability to communicate with JAVA Swing using SOA

Responsible for application and database tuning

Technologies used: Agile Software Development, Test First Design, XML, Refactoring, C#

Technical Lead, 2001-2004

(Various B2B Applications)

Converted old Pro*C code to Java RMI-IIOP application

Led a team to remove dependency on SAS in turn saving Monsanto $2.0MM annually

Technologies used: Test First Development, OO, XML, PL/SQL, Java, .NET2.0, Tomcat, and Apache

Other Positions Include:

Lead Software Engineer-The Advantage Group of Saint Louis, MO 2000-2001

Lead Developer-Navisys of Saint Louis, MO 1999-2000

Application Developer-MCI WORLDCOM of Wichita, KS 1996-1999

COMPUTER SKILLS

Methodologies: UML, Visio, Agile, Scrum, TOGAF

Languages: Java, JSP, Struts, Spring, Silverlight, EJB, Hibernate, Weblogic, J2EE, .Net, C#, VB.Net, C/C++, JDBC, SQLJ, CGI, Perl, Pro*C, HTML, SQR, C and Korn Shell.

Development Tools: Visual Studio (6.0, .NET), MS InterDev, JBuilder, Eclipse, XMLSpy, SAP GUI, Perforce, CVS, Jakarta Tomcat, IntelliJ, Weblogic 10.3

Platforms: MS Message Queue, JMS, BizTalk 2000, Site Server 3.0, Commerce Server 2000

Databases and Tools: Oracle 8.0.6/Oracle 8i EE/9i/10g, MySql, MSDE, Sybase, SQL Server 2005/2008, ODBC 3.5, mSQL2.0, O2, SQLJ, Transact-SQL, PL/SQL, SQL Server 2005 CE

Operating Systems: Windows Mobile 5.0/6.1/6.5, UNIX (SunOS, Linux, HP-UX), Windows NT, DOS, Windows 95/98/2000/ME, and x-windows,

Software: MS Office (Word, Excel, PowerPoint, Access, Outlook), MS Project, Service Desk, Enterprise Architect, JProfiler, TOAD

EDUCATION

Master’s Degree Coursework in Computer Engineering

Wichita State University, Wichita, Kansas

B.A in Accounting and Finance

Coe College, Cedar Rapids, Iowa

OTHER

US Citizen

Certification

Professional Scrum Master

Contact this candidate