Manager Sql Server

KHAJA MOHAMMED

Email: *****.********@*****.***

Phone: 901-***-****

SUMMARY

• Software Professional with 9 years of design and

development experience using Microsoft technologies.

• Extensive development experience in diverse areas of

services, logistics and manufacturing industries

• Excellent experience building N-tier applications using

C#.NET, VB.NET, ASP.NET

• Hands on experience configuring Product, Production,

Data Collection, Non-Conformance setup in SAP ME.

• Extensive experience with various software environments

of Software Development Life Cycle (SDLC).

• Experience in designing and building applications using

Microsoft.NET Framework and Visual Studio.NET.

• Enormous experience in writing stored procedures,

functions using SQL Server 2008/2005/2000.

• Well versed in reporting tools and experience with SQL

server reporting, and Component One Reports.

• Team player with excellent communications and inter-

personal skills.

EDUCATION

Master of Science in Management Information Systems (MIS), University of Memphis

Master of Science in Computer Engineering Technology (CETH), University of Memphis

Bachelor of Engineering, Osmania University, India

TECHNICAL SKILLS

Languages: C#.Net, VB.Net, ASP, Visual Basic 6, JavaScript, VBScript

.Net Technologies: ASP.Net, LINQ, ADO.Net, COM+, Web services

Web Technologies XML, HTML, CSS, AJAX Toolkit 3.5

Databases: SQL Server 2008/2005/2000, Sybase11, MS Access 2003/2000

Operating Systems: Windows 2000/XP/7, Windows Server 2008/2003

Reporting Tools: SSRS2005, Component One Reports, MS Access Reports

ERP: SAP ME

Other: Visual Studio.Net 2010/2008, Business Intelligence Development Studio 2005/2008, Team Foundation System

2008, Visual Source Safe 2005, Microsoft Visio 2003, Infragistics NetAdvantage 7.2, Loftware

Label Manager, Mercury Quality Center

PROFESSIONAL EXPERIENCE

Jabil Circuit Inc April 2012- To Date

Business Systems Analyst II

MES Upgrade and JVW Server Consolidation

MES SME, working on critical corporate initiatives to upgrade site shop floor control systems and JVW consolidation of

system servers to datacenter.

Responsibilities:

• Analyze to-be MES shop floor control systems and

perform gap-analysis.

• Modify reports, third party applications, SSIS

packages to integrate with the upgraded database systems.

• Perform user acceptance testing and validate the

upgraded EPS code functionality

• Coordinate and schedule workshops for end user

training on the new version of MES.

• Analyze and group servers into migration packages

causing minimum effect on end user experience.

• Identify applications and end user testers for post

migration testing on JVW consolidated servers

• Document the post migration configuration process

for QIS servers moved to corporate data center.

Environment: C#.NET, VB6, SQL Server 2008/2005/2000, SSRS 2005, Visual Studio 2010/2008, BIDS 2008

Jabil Circuit Inc June 2010- To April 2012

Application Administrator II

OPMS, MES & EPS

Primarily responsible for developing new functionalities in Order Processing Management Systems, Electronic Packout

System and Manufacturing Execution Systems across the workcells at Jabil Memphis plant.

Responsibilities:

• Provide functionality and support to Production

Planners to load and schedule BTO and CTO build plans.

• Analyze BOM structure and develop functionality

to load CTO orders to OPMS.

• Provide production edashboard for planners and

manufacturing to track the WIP and FGI material..

• Develop new functionalities to improve workcell

business processes and enhance user experience.

• Work with cross functional team and shop floor

personnel to ensure uninterrupted production schedule.

• Monitor and resolve application related issues to

minimize downtime for manufacturing activities.

Environment: C#.NET3.5, VB6, SQL Server 2008/2005/2000, SSRS 2005, Visual Studio 2010/2008, Loftware Label

Manager, Ajax Toolkit 3.5, Agile, Terminal Service Manager, Peregrine Service Center

e-Dashboard

Designed and developed an e-dashboard website tool for Workcell management to monitor the test status of units in real-

time. The website provides daily capacity and first pass yield summary of the available testers in use. The second phase

of this project is to design a tool that reflects the current production route and displays the batch status and the quantities

of units on each route step.

Responsibilities:

• Gather customer requirements and team up with

Test Engineers to understand the layout of testers.

• Create SQL jobs to pull the current steps, test status

and details based on batch Id’s.

• Work with Industrial Engineers to understand the

production routes, route steps and derive calculations for Capacity, FPY and through put pass yields.

• Environment: ASP.NET3.5, SQL Server 2008/2005, BIDS 2008, VS 2010/2008

CVP Tester Program

Designed and developed CVP-OPMS interface program to read and process the test data from the serial ports of the

tested machine type models. The program uses regular expressions to parse the stream of data into groups for further

processing. The CVP test data is a critical pre-requisite for the units to be processed into OPMS.

Responsibilities:

• Collaborate with Test Engineers to analyze the data

from various machine type models.

• Plan and deploy program changes to multiple CVP

Testers across the production lines

• Work with manufacturing and test team to ensure

100% test results for the daily production schedule.

• Troubleshoot and customize the program for test

data and machine type model related changes.

2 Page

• Environment: C#.NET3.5, SQL Server 2005, VS 2008

SAP ME Conference Room Pilot

Involved in a high visibility CRP project for implementing SAP ME across the leading workcell at Memphis EMS plant. This

project is aimed to help manufacturers gain visibility into manufacturing operations, achieve shop-floor control, and

manage process and product traceability.

Responsibilities:

• MES SME representing Memphis plant in the

corporate initiative.

• Work with cross functional teams to analyze the

integration points of SAP ME with other functional modules.

• Analyze the as-is production process flow and

design and develop the to-be SAP ME system

• Identify the current production issues and solution

them in the new system.

Environment: SAP ME, SAP MII, SAP ECC6.0, Loftware Label Manager

FedEx Services January 2010 – May 2010

Software Engineer

FedEx Ship Manager Ship Engine (FSMSE) – Café / GSM Development

FSMSE provides a range of services to FedEx Ship Manager (Café) and Global Ship Manager (GSM) to seamlessly ship

products from anywhere to anywhere around the world with express and ground services. The main services provided by

Ship Engine include shipping, tracking, rating, and other administrative services.

Responsibilities:

• Worked on Café 2480 June Release to mainstream

Smart Post Services.

• Customization of GSMW to accommodate NDE

changes as per SRS for APAC and EMEA countries.

• Provide application support and defect resolution

for Café 2460 and earlier versions.

Environment: C#.NET2.0, XML, Web Services, Sybase11, TFS2008, Visual Studio 2008, Mercury Quality Center

ServiceMaster February 2004 –June 2009

Software Developer II

Application Backlog Management

Version One is a backlog management tool for all applications at ServiceMaster Clean. All application issues that are

received by the level I support team are entered as requirements into Version One. These requirements are diligently

planned and prioritized to minimize the backlog.

Responsibilities:

• Primarily responsible for monitoring and managing the application support backlog queue using project planning

and management tool like Version One.

• Responsible for prioritizing the backlog items based on business value and development effort.

• Daily tasks involve working closely with the system support group, development team, gathering requirements

from the stakeholders, and providing status updates to the customer.

Environment: Version One, MS Visio, MS Project

Groups

The Groups application facilitates the business users to organize their contacts into logical collections based on business

criteria. The application allows users to categorize their contracts into Public, shared and Personal groups.

Responsibilities:

• Solely responsible for design, development,

coding and implementation of Groups module.

• Responsible for Database design and

implementation of Role Based Security for the entire Groups module.

• Integrated with LIVE application and customized

the Statistical reports to utilize the Groups functionality.

Environment: VB.Net2.0, Infragistics NetAdvantage 7.2, ADO.NET, SQL Server 2005, AJAX, Visual Studio.net, XML

3 Page

Business Services Profiles

Description: The Business Services Profiles is a web based application tool that provides License CLR for Janitorial and

Commercial service lines based on the business services category. The application retrieves data from multiple sources

including MS Analysis Services data cube application using MDX queries.

Responsibilities:

• Providing user friendliness and flexibility by using

Infragistics NetAdvantage and other validation controls

• Designed and developed an application to provide the user

real time license, enterprise and profiles data by querying the MS Analysis Services data cube application using

MDX queries.

• Computed the CLR data piece of each license by querying

the Analysis services application.

• Environment: ASP.Net 2.0, ADO.Net, MDX, SQL Analysis Services, Infragistics NetAdvantage, SQL Server

2000

L.I.V.E

LIVE is a web based franchise support application developed for ServiceMaster Clean to enable the business users and

franchise owners to maintain their franchise information. LIVE is a core application that acts as an interface for all other

applications at ServiceMaster Clean.

Responsibilities:

• Primary developer for LIVE and it’s supporting

applications.

• Provided adhoc custom reports to facilitate the

senior management.

• Extensively used Infragistics controls to provide

rich user experience.

Environment: VB.NET, ASP.NET1.1/2.0, ADO.NET, VB6, ASP, VBScript, XML, SQL Server 2005/2000, VSS

MM Connect

MM Connect is a seamless integration of CIS Customer base and RightNow CRM software. It provides users with better

customer and leads management for improved market analysis and research.

Responsibility:

• Created a seamless CIS integration with the RightNow CRM for better customer and leads management.

• Involved in creating and analyzing use cases and getting additional clarifications from the users.

• Developed a module to communicate with the RightNow API and Synchronize data in real time.

• Environment: VB6, XML, MS-Access, MS Visual Studio 2000 and MS Visual Source Safe

Employee Payroll Module

Customer Information System (CIS) is a core franchise support application for Merry Maids. Employee Payroll module in

CIS maintains personal and payroll data and facilitates the franchisee with federal, state and local tax etc for their

employees.

Responsibility:

• Involved in Analysis, coding, integration and

documentation of the new payroll system

• Performed a crucial role of analyzing the existing system,

identifying data and system requirements, data flow and process steps involved in integrating and synchronizing

the application with the backend database.

• Involved in integrating third party 'Payroll calculation'

software with CIS for the employee payroll module.

Environment: VB6, MS-Access, VSS, MS Visual Studio 2000, Component One Reports and MS Visual Source Safe

University of Memphis August 2000 – December 2003

Web Developer (Graduate Assistant)

Engineering Department Websites

The Engineering department websites display information related to the latest news, ongoing research, faculty, courses

offered and other department related news and events. The online tutorials provide the students with a better

understanding of engineering concepts with the help of interactive and user friendly flash animations.

4 Page

Responsibility:

• Designed and developed the departmental and faculty

websites for the Civil Engineering Department.

• Solely responsible for design and development of online

tutorials for the Civil Engineering department.

• Developed various Flash animations for academic

purposes.

Environment: FrontPage, Flash 5, HTML

5 Page

Contact this candidate