Resume of Sql Server Developer

Title
Sql Server Developer

Primary Skills
Detailed oriented and experienced Programmer, Quality Analyst, and Business Analyst

Location
US-TX-Plano

Posted
Jun-19-07

SUMMARY

Detailed oriented and experienced Programmer, Quality Analyst, and Business Analyst with a wide variety of application programming. Technical skills involved in roll outs of hardware, software from start to finish and programming software tools from start to finish utilizing the Full SDLC cycle approach. Specialties include teaching and technical writing. Experience using Crystal Reports, and Business Objects Crystal Reports v 8.5 and v 9. Microsoft Visual Studio 2003 and 2005, SSRS (SQL Server Reporting Services) 2000, and 2005, DTS and ETL, Queries, Query Analyzer Microsoft Visual Source Safe, Sharepoint, Microsoft Project. Used Crystal Reports and SSRS Business Intelligence and Business Objects, Web Analytics, Currently learning SharePoint 2007 Development, C# and ASP.Net C#
Design Patterns: Scrum, Agile, Waterfall, Iterative, Extreme Programming

MAJOR PROJECTS
*NationStar Mortgage Answered help desk tickets on report problems for over 2,000 users. Created SQL Server Reporting Services reports in versions 2000 and 2005
* Northwest Educational Center Developed database in SQL 2000. Used BI Cubes and OLAP to extract data.
* Mortgage Loan Officer Entered client info in Calyx Point on a 1003 collected all necessary paperwork and found the best loan for each customer's need.
* Sector 7/Amer Technology - Developed database that tracked server consolidation for very large Fortune 100 companies saving the companies hundreds of thousands of dollars on server space and software purchases.
* Rational Software - Developed metric reports and ad hoc reports for Rational University reporting.
* SAIC/Entergy - A project startup database that traced customer's electric usage and billable electric hours.
* Lucent Technologies - A project involving designing a Bill of Materials (BOM) totally driven by Excel. Printed parts list and invoices.
* Unocal/RHIC - Y2K project involving migrating 8 years of Lotus 123 spreadsheets to Excel VBA for the Spirit Energy Accounting Revenue Department. Project completed on time and on cost. Spreadsheets ran perfectly until the day they were converted to an Oracle database.

Consultant Developer
Geniant
02/07- 05/07

* Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003
* Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2000
* Used Microsoft Visual Source Safe to check in and check out projects
* Used Microsoft SharePoint to keep documentation up to date regarding projects
* Updated Access database to utilized Excel as a front end retrieving SQL data using VBA code.
* Interacted with Business Analysts and Project Managers to give status updates and recommend changes
* Interacted in weekly meetings with IT Manager to give status updates on projects.
* Utilized documentation prepared by Business Analyst to complete projects.
* Used Microsoft .Net 2003 and Microsoft .NET 2005
* Used DTS and ETL and SSIS as needed.
* Used business Analytics to prioritize reports.

Nationstar Mortgage - Dallas, Texas Developer Web Originations
08/06 - 01/07
* Kept ASP reports running over companywide Intranet for over 2000 users
* Solved help desk tickets as needed regarding company reports
* Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003
* Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2000
* Used Microsoft Visual Source Safe to check in and check out projects
* Used Microsoft SharePoint to keep documentation up to date regarding projects
* Updated Access database to utilized Excel as a front end retrieving SQL data using VBA code.
* Interacted with Business Analysts and Project Managers to give status updates and recommend changes
* Interacted in weekly meetings with IT Manager to give status updates on projects.
* Utilized documentation prepared by Business Analyst to complete projects.
* Used Microsoft .Net 2003 and Microsoft .NET 2005
* Used DTS and ETL and SSIS as needed.
* Used business Analytics to prioritize reports.

Skills Used: Microsoft Visual Studio 2003 and 2005, SQL Server 2000, SQL Server 2000 Reporting Services, SQL Server Management Studio Express, Created Queries, Stored Procedures, ASP, Visual Basic Script, Excel and Access VBA

Northwest Educational Center Programmer/Business Analyst
01/06 - 07/06

* Used web scraper software to develop database. Developed schemes to extract the exact data needed..
* Developed proprietary database in Access 2002 using VBA, tables, queries and forms. Later switched this database to MS SQL.
* Kept ASP reports running over companywide Intranet for over 2000 users
* Solved help desk tickets as needed regarding company reports
* Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003
* Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2000
* Used Microsoft Visual Source Safe to check in and check out projects
* Prepared documentation detailing work completed.
* Traveled offsite for company meetings to gather requirements.
* Full Software Development Lifecycle implementation achieved.
* Created SQL 2000 stored procedures and triggers.
* Created SQL 2000 cubes.
* SQL Sever 2000 Analysis Services.
* Used SQL queries to pass data.
* Used DTS and ETL and SSIS as needed.
* Used SQL reporting services.
* Tested all software and made Quality Assurance and Control test through manual testing.
* Microsoft Project timeline utilization for tracking the entire project from start to finish.
* Created reports using Crystal Reports 9 using imported data sources.
* Used Crystal Reports v 9 to format drill down reports.
* Worked remotely from home.
* Used Microsoft .Net 2003 and Microsoft .NET 2005
* Used Web Analytics to determine how potential students responded to website.

Sigma Mortgage Group, NorStar Mortgage, Mortgage Strategies Group
Mortgage Loan Officer/Programmer Analyst
7/02 - 12/05
* Prepared Mortgage Loan Applications (1003's) using Calyx Point
* Gathered paperwork needed and processed my own loans.
* Explained mortgage programs to clients and found them the best loan possible for their situation.
* Programmed databases to keep track of clients as needed and to determine which lead companies were best to use
* Used Microsoft .Net 2003 and Microsoft .NET 2005

Skills used: Access VBA, Business Objects, Excel VBA Data Import, SQL, SDLC, ODBC, Microsoft Project, Web Scraper software.

Sector 7/Amer Technology - Austin, Texas Programmer/Business Analyst
03/02 - 06/02
* Involved in developing business plan, ideology and methodology for the company.
* Created Projected Income Statements and other Financial Reports.
* Project Manager. Set Team Meetings where needed to assure client timetable was met.
* Utilized Office XP for Word, Access, Excel and PowerPoint.
* Answered Technical Questions as needed.
* Created website utilizing ASP and Microsoft .Net technologies
* Developed ideology for multiple marketing and advertising ploys to target an exact audience to capitalize on optimal response.
* Involved in n-tier development in a Visual Basic 6.0 and SQL 7.0 web enabled database
* Tested all software and made Quality Assurance and Control test through manual testing.
* Microsoft Project timeline utilization for tracking the entire project from start to finish.
* Created reports using Crystal Reports 9 using imported data sources.
* Full Software Development Lifecycle implementation achieved.
* Created SQL 2000 stored procedures and triggers.
* Created SQL 2000 cubes.
* SQL Sever 2000 Analysis Services.
* Used SQL queries to pass data.
* Used SQL reporting
* Used DTS and ETL and SSIS as needed.
* Created reports using Crystal Reports using imported data sources.
Skills used: Access VBA Business Objects, Excel VBA, Excel Data Import, ODBC, SQL, SDLC, Visual Basic 6.0, Microsoft .NET SQL 2000, Crystal Reports

Entergy/Adecco & SAIC Programmer/Business System Analyst
06/01 - 12/01
* Created reports as needed to determine scope of project.
* Created databases in Access 97 and Access 200.
* Plotted graphs in Excel 97 and Excel 2000 using VBA and Excel Objects to connect to record sets using ADO and RDO.
* Automated spreadsheets for Energy Analysts showing customer meter usage and other detailed information.
* Created tables in Access 97 and Access 2000 containing all vital information needed to produce long term and short term forecast.
* Created a weather database in Access 2000.
* Tested all software and made Quality Assurance and Control test through manual testing.
* Created reports using Crystal Reports 8 using imported data sources.
* Full Software Development Lifecycle implementation achieved.
* Created SQL 2000 stored procedures and triggers.
* Created SQL 2000 cubes.
* SQL Sever 2000 Analysis Services.
* Used SQL queries to pass data.
* Used SQL reporting
Skills used: Access VBA, Business Objects, Excel VBA, Excel Data Import, ADO, RDO, DBMS, SQL, SDLC, Microsoft Project MS SQL 2000

Rational Software/Kelly Technical Services - Cupertino, CA Programmer/Analyst
01/01 - 05/01
* Responsible for creating reports on Web Site Metrics. Determine how much time users spent on specific pages and where they entered the website from and where they left to. Created reports in Professional Quest reporting system which is very similar to Crystal Reports.
* Created Financial Reports.
* Converted MS Access databases to MS Excel spreadsheets in Office XP. Programmed macros as needed.
* Created tables, forms, and reports in Access VBA and spreadsheets using Excel VBA Used Excel Objects. Used ADO and RDO to import/export between Access and Excel as needed.
* Managed web site metrics report creation and deliverables.
* Migrated data from Access 97 to Access 2002.
* Tested client website for errors and bugs.
* Tested all software and made Quality Assurance and Control test through manual testing.
* Full Software Development Lifecycle implementation achieved.
* Created SQL 2000 stored procedures and triggers.
* Created SQL 2000 cubes.
* SQL Sever 2000 Analysis Services.
* Used SQL queries to pass data.
* Used SQL reporting
* Used TSQL
* Utilized Web Analytics to develop scorecards on Rational University different schools throughout the US.
* Developed scorecards to report activity based on student response.
* Monitored user activities on website.
Skills used: Access VBA, Business Objects, Excel VBA, Data Import, ADO, DAO, SQL, SDLC, Microsoft Project MS SQL 2000

Lucent Technology/SOFTWARE SOLUTIONS- Warren, NJ Programmer/Business Analyst
06/00 - 12/00
* Programmed Excel VBA templates in Excel 97 VBA and Excel 2000 VBA and Excel Objects that were designed to produce a Bill of Materials for job costing.
* Converted MS Access databases to MS Excel spreadsheets. Programmed macros as needed
* Wrote detailed procedures for solutions for users as needed.
* Used MS Visual Basic 6.0.
* Maintained databases using Access 97 and Access 2000. Created forms, tables and queries using links for external data. Used RDO and ADO, DAO, ODBC, SQL, TSQL and RDBMS
* Tested all software and made Quality Assurance and Control test through manual testing.
Skills used: Access VBA, Business Objects , RDO, DAO, ADO, DOBC, TSQL, SQL, SDLC, Excel VBA, Excel Data Import

Unocal/RHIC - Houston, TX Programmer/Business Analyst/Financial Reporting
07/98 - 07/99
* Excel VBA Programmer Business Systems Analyst/Quality Assurance Analyst.
Converted 8 years of Lotus 123 Spreadsheets to Excel VBA in one year during Y2K compliance and testing. Used SQL 6.0 to extract information for some of the spreadsheets that the accountants needed. These spreadsheets were uploaded to an Oracle database using an FTP client to determine the allocation of oil lease expenditures for the Spirit Energy Revenue Accounting group.
* Helped with Project Management to assure critical tasks were met on time.
* Insured macros ran on spreadsheets containing financial data for oil leases including, general ledger, accounts payable, accounts receivable.
* Used SQL, TSQL to access data.
* Created Job Costing for the State of Texas Crude Oil Tax Forms templates in Excel that balanced Spirit Energy's Tax Payouts to the penny on a $51,000,000 monthly report.
* Used Active X Controls, COM and GUI interfaces to create buttons and user tool bars. Created print menus, drop down list boxes.
* Managed this project to ensure completion of the project would meet customer expectations. Developed these macros in a Windows 95 operating system and Windows N.T. 4.0 and Novell 3.12 network. Used Lotus Notes to update project database and for email.
* Tested all software and made Quality Assurance and Control test through manual testing. Placed software on Y2K compliant servers and tested to make sure the dates would stay in place.
* Created reports using Professional Quest ( a package very much like Crystal Reports) using imported data sources.
Skills used: Excel VBA, ODBC, TSQL, SQL, SDLC, Access VBA, Business Objects , Excel Data Import

Temple Inland, Vastar Resources, Dow Chemical- Houston, Texas Lead Help Desk Programmer
10/95 - 06/98
* Worked for various clients on a contract basis such as Temple Inland, Lufkin, Texas, Vastar Resources, The Dow Chemical Company
* Lead Help Desk Analyst, 2nd and 3rd Level Break Fix Technician and Programmer Analyst.
* Project manager for roll out issues.
* Created and utilized call center reporting metric tools to show tickets opened, tickets closed, and unresolved work.
* Tested all software and hardware and made Quality Assurance and Control test through manual testing.
Skills used: Access VBA, Business Objects , Excel VBA, Excel Data Import, Microsoft Office, Problem Solving

Northwest Educational Center - Houston, Texas Instructor/Technical Writer
09/87 - 09/95
* Taught Microsoft Office, WordPerfect and Lotus 123 courses.
* Provided technical support as a Network Analyst
* Prepared lessons and courseware material.
* Taught classes with students from 4 - 20 students per class.
* Prepared reports on student attendance and achievements.
* Managed student work, records and computer network.
Skills used: Teaching, Courseware Manual Writing, Lesson Preparation, Technical Support



TECHNICAL SKILLS
Languages: ASP, Microsoft .NET COBOL, Java, Java Script, Visual Basic 6.0, Access VBA, Excel VBA
Databases: Access, dBase, FoxPro, MS/SQL, MSSQL Server, MY SQL, Normalization, ODBC, Oracle, Paradox, PL/SQL, SQL
Application Packages: Microsoft Visual Studio 2003, Microsoft Visual Studio 2005, SQL Server Reporting Services 2000, SQL Server Reporting Services 2005, SQL Server Studio Management Express, SQL Query Analyzer, Crystal Reports, Front Page, FrameMaker, Lotus Smart Suite, Lotus Notes, Microsoft Access, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Office, Microsoft Project Novell NetWare, OLE, OO, OOD, PageMaker, RoboHelp, Visio, WordPerfect, WordStar
Mark Up Languages: DHTML, HTML, XML
Mail Systems: Lotus Notes, Microsoft Exchange, Microsoft Outlook
Internet Tools: ASP, Active X, DHTML, DNS, E-Commerce, FrontPage, HTML, Java, JavaScript, VBScript, Internet Information Server (IIS), Personal Web Server
Methodologies: OO Analyst and Design (OOAD), Object Modeling, UML, RUP
Operating Systems: MS-DOS/PC-DOS, OS/2, Windows 3.x/95/98/NT, Windows for Workgroups, Windows 2000 Professional, Windows XP
Publications: 1,001 Things For Kids On The Internet, 2006 Cool Things For Kids On The Internet


PROGRESSION
Consultant Developer 03/07 - 05/07
NationStar Mortgage Programmer Analyst/Consultant 08/06 - 1/07
Northwest Educational Center Programmer Analyst/Consultant 01/06 - 07/06
Self Emp Mortgage Loan Officer Mortgage Loan Officer Programmer Analyst 07/02-12/05
Sector 7/Amer Technology Programmer Analyst/Financial Analyst/Consultant 03/01 - 06/01
Entergy/Adecco & SAIC Programmer Analyst/Financial Analyst/Consultant 06/01 - 12/01
Rational Software/Kelly Metrics Analyst, Programmer/Consultant 01//1 - 06/01
Lucent/Software Solutions Programmer Analyst/Consultant 06/00 - 12/00
Unocal/RHIC Programmer Analyst/Financial Analyst/Consultant 07/98 - 07/99
Temple Inland Lead Help Desk/Break Fix Analyst 01/98 - 06/98
Vastar Resources Lead Help Desk Analyst 01/97 - 12/97
Dow Chemical Lead Help Desk Analyst 12/95 - 12/96
Northwest Educational Center Instructor Courseware Material 09/87 - 09/95

Consulting Assignments
NationStar Mortgage Contract Project Visual Studio 2003, 2005 Visual Source Safe, SSRS, ASP
Northwest Educational Center Programmer Analyst/Consultant Visual Studio 2003, 2005 SSRS BI Cubes
Self Emp. Mortgage Loan Officer Mortgage Loan Officer/Programmer Analyst Visual Studio 2003, SSRS
Sector 7/Amer Technology Contract Project/Integration Specialist Access & Excel VBA MS Project
Entergy/Adecco & SAIC Contract Project/Integration Specialist Access & Excel VBA Project
Rational Software/Kelly Contract Project/Metrics Analytics Access & Excel VBA Project
Lucent/Software Solutions Contract Project/Bill of Materials BOM Access & Excel VBA Project
Unocal/RHIC Contract Project/Y2K Conversion Access & Excel VBA Project
Temple Inland Contract Project/Windows 95 Rollout Lead Help Desk, Break Fix
Vastar Resources Contract Project/Lead Help Desk Analyst Lead Help Desk, Break Fix
Dow Chemical Contract Project/Lead Help Desk Analyst Lead Help Desk Analyst
Northwest Educational Center Full Time Instructor/Courseware Material Instructor & Courseware

Education
Texas State Technical College - Waco, Texas 05/87 - 09/89

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-TX-Plano »
View all resumes in US-TX »

View other Sql Server Developer resumes, Programmer / Developer resumes