Sql Server
Resume:
Dear Hiring Manager:
I was interested to see your job description for a position posted on the Internet. I believe you are searching for either a Programmer Analyst, .Net Programmer, Application Developer or for a SQL Server Database Developer.
I am searching for a position and would like to learn more about this opportunity.
I am a programmer and most of my experiences are from working with the Microsoft development tools.
While I have been ask to work on many types on programming projects I am most skillful in C#, Visual Basic and SQL Server programming. I develop not only the data structure, I also compile testing data, design how the client application communicates. I have a method of code tracking, process tracking and application control. I also have a method for tracking changes to code. In addition to this I manage code descriptions, process descriptions, bug descriptions and writing user help files and setup documents.
In both Visual Studio 2003 and Visual Studio 2005, I am capable programmer with C#, VB.Net, ADO.Net while working on ASP.Net and Web Services projects. On a number of projects the tasks included upgrades and code fixes to existing code, new webpages or a complete website devised and implemented in ASP. Net. Some projects were migration projects from Standard ASP or a VB6 application to ASP.net. A few applications were client access portals into a private database. There were a series of replication projects where a website or a portion of a website was replicated and modified for a particular client or purpose. And a few projects were meant to replace the management of spreadsheets and client data. For instance in one project airline flight information on shipping were compiled and stored into a designed database. A Web Service was designed to import and merge flight confirmations with shipment tracking numbers and format the results for populating ASP.net controls on a webpage. One project was a normal database project where the database was designed and implemented with SQL Server. Encrypted user passwords, image files stored in a database and a number of different data imports were used in the foundation. Another project was an exchange of an older project in VB6 and SQL server. The original project was an employee database that included project codes and office phone numbers. The new project was a tracking database for which tracking computer assignments and user passwords. The users in the company have anywhere from 5 to 30 passwords for websites and operational applications. The application allowed us to track original user passwords and user movement from one computer to another.
The programming projects with Visual Basic were not just limited to Visual Basic 6. Projects were developed with Microsoft Office VBA and Visual Basic Scripting with both scripting files and webpage programming. A significant number of projects were developed with Visual Interdev 6, earlier versions of both SQL Server and Crystal Reports.
As a result I have worked on maintenance and enhancement projects, migration projects and environment specific projects. For example today I move code from Excel 2003 VBA to Visual Basic 6, add a number of changes and upgrades and compile an EXE that generates Excel files populated with data from a SQL Server. The users don’t have to manage the code and the interface is compatible without making changes to the Windows platform and interfering with the production applications on the system. Another VB6 project was designed to access the SQL Server database and provide administrative changes to the database. The interface was written in the same VB6 language. It mimicked the same user interface with the same controls as the production application. Other applications were written using existing software and resources that were found in the company’s environment.
In the area of database development, I have several years of experience with SQL Server from the earlier versions up to SQL Server 2008. While the main development has been with designing table, triggers, stored procedures, complex queries, and importing and exporting data. I have the ability to write and optimize complex SQL queries, procedures and functions based on previous completed code samples and code samples from other programmers as templates and research and development of new code samples. I have some familiarity with Business Integration projects and have worked with SQL Server Reporting Services and SQL Server Integration Services. I have experience with different database replication. this includes restoring databases from backups, copying database resources directly from another database using the importing and exporting tools, and on several occasions I was forced to wright code to process data validation and data maintenance and produce a new resource that could be easily entered into a newly created database and I have on occasion reexamined the original data sources for a new data extract, normalized the data and redesigned the table structure of the specific tables. I have the ability to perform both database-level and operating system performance tuning and monitoring. I have knowledge of SQL Server backup and recovery scenarios. I am proficient in SQL Server security management. And, I have experience in code migration, database change management and data management through the various stages of the systems development life cycle. I have experience with maintaining SQL Server Agent jobs, Maintenance Plans, window’s Scheduled Tasks and some Reporting Services. On one project I use SQL Profiler to run a database trace and isolate user tables. A query was designed to extract information on table locks and a plan to redesign application tables to avoid conflicts between processes. Another database project was a migration from Microsoft Access. The process included migrating VBA windows, designing a new database and a method for automating the generation of monthly Excel spreadsheets. Email notices from the system with files attachments are sent to users using Collaboration Data Objects.
In the area of Microsoft Windows platforms, I have experiences both Server Environments and Desktop environments. I have strong abilities with installing, configuring and administrating and troubleshooting both Windows XP and Windows Server. I have experience with basic Windows Networking, TCP/IP. In all, I have experience with deploying Windows Desktops and Servers, SQL Server, Exchange Server, Internet Information Server and Security and Acceleration Server and Small Business Server.
I would welcome the opportunity to discuss how my qualifications would enable me to make a valuable contribution to your firm. Enclosed is my resume, which summarizes my experiences and education.
Thank you for your time and considerations.
Sincerely,
Timothy Maturah
Applications Programmer Analyst
ac1m32@r.postjobfree.com
Encl: resume.
Timothy Maturah
Kew Gardens, New York 10118
ac1m32@r.postjobfree.com
Objective: Seeking a challenge and responsible position utilizing past experiences with current abilities and knowledge in the Systems Development Life Cycle, Structured Systems Analysis and Design, Database Development, Web Development, Project Management, Customer Relations Management and Object Oriented Programming with Unified Modeling Language •
Education:
Pace University, New York, NY
Department: School of Computer Sciences and Information Systems
Degree: Masters of Science QPA: 3.65
Major: Information Systems Sept, 2006
Pace University, New York, NY
Department: School of Computer Sciences and Information Systems
Degree: Bachelor of Science QPA: 3
Major: Information Systems Minor: General Business
Concentration: Database Management & Programming
Awards: Second Honors Sept, 2004
Graduate Courses: Object Oriented Design using Unified Modeling Language • Database Design for Websites • Cyber Ethics • Customer Relations Management • Java Programming • Web Services • Technology Innovation Management • Strategy of Information Technology and Control • Project Management • Management Information Systems • Managing Information Technology • Information Security •
Undergraduate Courses: Small Business Management • Organizational Behavior • Management Information System • Human Resources Management • Qualitative Management • Managerial and Organizational Concepts • Managerial Accounting • Financial Accounting • Marketing • Visual Programming • Programming Languages • Advanced Database Programming • Java Programming • Business Telecommunications & Networks • Distributed Networking • Psychology I & II • Ancient Philosophy and Ethics •
Software: Languages: Databases:
InterDev, FrontPage Visual Basic, VBA, VBScript Access 95, 97, Y2K, 2003
IIS, Personal Web DHTML, ASP, XML SQL 6.5, 7, 2005, Y2K
Crystal Reports 5, 6, 7, 8 JScript, JavaScript, ASP.net, VB.net, C#
Software and Operating Systems Summary: Microsoft Small Business Server 2003 • Microsoft Exchange Server • Microsoft SQL Server • SQL Server Express • Microsoft Internet & Acceleration Server • Microsoft Visual Studio • installing and configuring windows networks • TCP/IP • installing and configuring SQL Server databases • developing and designing SQL database applications • installing and configuring proxy servers and clients using ISA Server • installing and configuring Exchange Server and user mailboxes • developing ASP.Net applications using C# and stored procedures using SQL Server • developing web service applications and client interfaces • ASP.Net 2.0 and ADO.Net with Stored Procedures implemented in C# using Visual Studio •
Experience Summary: Support of existing applications, users and servers • to troubleshoot, analyze, design, upgrade, migrate, implementations and installations of software applications for both Windows and company Intranet • to developed Active Server Page applications using Cascading Style Sheets, Dynamic HTML, Stored Procedures, with VBScript through Internet Information Server, InterDev 6 and SQL Server • to develop and redesign Windows applications using Stored Procedures with Visual Basic 6, Crystal Reports, Software Developer’s Kit and SQL Server • setting up Virtual Private Networks, LANs, Intranets, Email Servers, Application Servers, Database Servers • to provide 2nd level support for Help Desk, Desktop Support and Networking • to provide 1st level support including user training sessions, phone support, printers, accounts and profiles • to conduct software testing including regression testing, unit testing, user requirements, user guides, systems documentation, product completion and packaging • other: to manage roaming profiles, desktop images, installation packages, database connections, Exchange/Outlook connection, etc •
Experience:
5/2008 to Current • Programmer Analyst/ Database Administrator
SDV USA, Inc., Co., 150-15 230th ST, Jamaica, N.Y, 11434
• Company Description: a worldwide leader specializing in international freight forwarding, transportation and logistics. We have moved users away from an AS-400/Lotus Email environment to a new Citrix environment providing both user and printer support. Direct Administration duties including editing queries, designing stored procedures, table views, DTS packages using Integrated Services, management tasks, running database traces, linked servers, importing and exporting objects from SQL Server, reviewing work loads, examining locks and deadlocks, etc. performed on a number of SQL Servers 2005and 2000 databases. Remote Desktop was used on hosted servers and user PCs in performing maintenance tasks including backups and restores from files, assigning passwords, application support and troubleshooting, and submitting application bugs to the consulting firms. There is some network support including the resolving of user profiles, Active Directory issues, software installs, installing operating system, conflicts, printer issues, desktop configurations, windows updates, configure internet applications using Siebel, a large amount of virus removals, printer conflicts, driver installs, IP address conflicts, setting up profiles in Outlook/Exchange, fixing email archives, schedule tasks, etc.
• Development Projects: database to track and record user errors and application bugs, tracking database for airline departures and arrivals on customer shipments, database for tracking human resource data, database for data exchange, database to store shipment data from hand held scanners, a number of data extracts and uploads from various data sources •
• Programming Projects: applications to extract operational data and compile into a formatted Excel report, user tracking applications for computers and password deployment, profile reports for operational user audits. Automated email notices, programs to monitor data exchanges between databases, and code maintenance and modifications on SQL Agent tasks and Windows Scheduled Tasks •
12/2007 to 01/2008 • Programmer Analyst/ .Net Developer
Sullivan & Cogliano, 230 second Avenue, Waltham, MA, 02451
• Company Description: The Contract position was with Entergy Corporation, an integrated energy company engaged primarily in electric power production and retail distribution operations. Entergy owns and operates power plants with approximately 30,000 megawatts of electric generating capacity.
• Programming Projects: The focus of the position was primarily for the simple revision and migration of an existing intranet application in Access from Standard ASP to ASP.Net 2005. The new application was implemented with a new SQL Server 2005 database and production templates were created for both layout and graphics •
02/2007 to 10/2007 • Lead Programmer Analyst
J.M. Rodgers. Co., In., 1975 Linden Blvd, Elmont N.Y.
• Company Description: A privately owned and operated shipping freight company tackling Information Technology in order to provide website development for their clients. Incorporating new designs while managing original source code linked to a growing environment of databases, networks and web servers.
• Programming Projects: The gathering of application requirements, managing client customizations and the development and implementation of client databases and websites using standard ASP, ASP.Net ADO.Net 2.0 using languages like Visual Basic Scripting Language, C#. •
• Development Projects: database to store and record customer shipment data, database of various lookup codes, security database of user passwords and applications, client databases. SQL Server Express, SQL Server 2005 and Access 2000 •
07/2006 to 09/2006 • Programmer Analyst II
Whole Foods Market, 905 River Road Edgewater N.J. 07020
• Company Description: Retail environment of a grocery chain in a dynamically changing environment. Install, maintain, modify and upgrade existing item hosting systems and ASP/SQL Server based reporting systems. Evaluate, recommend and implement new software solutions to meet a variety of business requirements in our stores. design, implement and maintain small to medium sized databases for reporting. Requirements gathering, the development and implementation of custom reports for stores and regional product teams. Maintain integrity of enterprise applications by adhering to configuration management and change control procedures. Document and provide training for applications.
• Development Projects: revisions of existing sales transaction database, revisions and generation of SQL Reports, queries and stored procedures used in company websites. SQL Server 2005 and Access 2000 •
• Programming Projects: code maintenance on an older website used in the store to house data on Walk-in Customers pertaining to delivery information and user preferences, maintenance on the scripts extracting operational data from each of the stores and then consolidating the data into a common database used in regional reporting, SQL Server 2005, Visual Studio 2005, C#, SQL Reporting Services, Standard ASP with VBScript, UNIX, FTP •
09/2005 to 03/2006 • Programmer Analyst/ .Net Developer
Update Legal, 1140 Avenue of America New York, N.Y. 10036
• Programming Project: Litigation support environment in a law firm. Contract position primarily for the migration of a web application written in PHP, My SQL and Apache Server to a new application written on the Microsoft platform in SQL Server 2000, C#, ASP.Net and Internet Information Server. Requirements and Business Rules gathering, code revisions, and redevelopment using .Net technologies, the creation of newly designed Stored Procedures and class designs using C#, Further enhancements included error pages and error trapping, Code, Scope and Application documentation, Data migrations from Excel to Access and to SQL Server 2000, and Use Case scenarios were used for the development of class designs and user interfaces •
02/2001 to 09/2003 • Computer Support Specialist, Radiology
Catholic Medical Hospitals, Union Turnpike, Jamaica, NY
• Company Description: A contract position to provide application support in a hospital environment. Windows based front end and back end server support on existing systems for radiology, ambulatory care and medical records. Install, upgrade and migrations and server administration of Windows 2000 servers. Various client installs of diagnostic groupware. There were some basic office administration duties when needed. Medical record duties including medical file maintenance, record searches, file completion, status checking, record searches, etc. St Joseph’s Hospital filed bankruptcy in 2003 and then finally closed in 2005 along with ST. Vincent’s Catholic Hospital •
• Programming Project: Report generation using Crystal Reports and Microsoft Access. Basic Intranet and windows programming with Visual Basic when necessary •
01/1998 to 10/2000 • Application Support Analyst, Information Systems
Willkie Farr & Gallagher,787 7th Ave New York, N.Y. 10019
• Company Description: Systems support environment in a law firm • Construction, development and maintenance of front end/ backend database applications for Human Resources department with Crystal Reports, Visual Basic and Visual Interdev • Software application installation, maintenance, support and troubleshooting of vendor purchased and customized packages • Testing and Analysis, implementation and user training of newly purchased applications • Software: Visual Studio 6, Crystal Reports and SQL Server. Personally designed applications: Internal Employee Phone and Room Directory, Client – Matter – Attorney Lookup, Staff Lists • Software upgrades and migrations to existing applications in Access and earlier versions of VB,VBA and VBScript, data file and table maintenance in SQL Server, ActiveX and Active Server Page conversions from standalone applications to web interfaces with the company Intranet on Internet Information Server using DHTML, VBScript and some class objects in Active server Pages • Other applications for team use included a personal disk utility for copying files, various automated forms, a crystal report window, information yielding dialogs accessing data from SQL Server, batch timers, File I/O for data Imports/exports from a Wang COBOL system to SQL, etc. •various database types including Betrieve, Access 97 & 2000, SQL Server 6.5 & 7, 2000, and Oracle 8 • Report Writing with Crystal Reports 4, 6, & 8 • Departments included Managing Attorney’s Office, Legal Recruiting, Intellectual Property, Human Resources, Secretarial • Other responsibilities include user training sessions, operating systems and software installations, desktop image revisions, user profile maintenance, nightly server batches, network troubleshooting and database deployment issues • Departmental accomplishments include successfully migrating to Windows 98 and to Windows NT4 Workstation/Office2000 • Rightfax, PCDocs, CarpeDiem, Office 97, 98, 2000 Win95, 98, NT4, Win 2000 •
09/1997 to 01/1998 • Quality Assurance Analyst, Quality Assurance
Comp Info, Inc., 304 Park Avenue South, 9th Floor New York, N.Y. 10010
• A software development company with a project environment using PowerBuilder, SQL Server and Oracle. The platform covered multiple versions of windows and OS2 • Application testing including regression testing, unit testing, object testing, documentation maintenance & demo testing, application platform testing, database version testing, installation script revisions, application usability/functionality, training sessions with User Support Services to present window revisions to clients • Compiled a simple client service database in Visual Basic and SQL Server 6.5 from word/excel macros with the use Remote Data Access Objects • Developed new window prototypes • Demonstrated functionality using company software with Office 97, Visual Studio 97 and SQL 6.5 • Client Platforms were Oracle 7, SQL 6.5, and Sybase, against Win3.X, Windows 95, NT4, and OS2 Warp.
10/1996 to 08/1997 • Help Desk Analyst, Academic Computing Lab
Pace University, One Pace Plaza New York, N.Y. 10038
• An academic environment with open computer services, Windows 95, Wang Systems and IBM mainframe hardware • Troubleshooting of academic software and printers • Student and faculty training sessions, user workshops, software demonstrations and revision of workshop documentation • Tutoring sessions to aid students with study techniques, report construction and organization • Managed student lab projects with structured programming and COBOL, C and Visual Basic • Office, WordPerfect, Lotus, CMS/VMS and email •
Academic References:
School of Computer Science and Information Systems, The
Pace University
161 Williams Street, 2nd Floor
New York, New York 10038
• Dr. John Molluzzo • Dr. Anthony Pupello
Department Chair Adjunct Professor from Graduate School
ac1m32@r.postjobfree.com ac1m32@r.postjobfree.com
Technical References:
• Odette Danvers • Dr. John Molluzzo
Update Legal Department Chair
1140 Avenue of America 212-***-****
New York, N.Y.10036 ac1m32@r.postjobfree.com
Contact this candidate