SQL Developer
Resume:
Frederick Dowd
Woodinville, WA 98072
Cell: 818-***-****
*****@*********.***
Summary of Qualifications
• Microsoft Certified Technical Specialist in MS SQL Server 2005.
• Knowledge of and working toward certification in .NET 2.0 using MS Visual Studio 2005.
• ETL and Data Warehouse experience.
• Experience in planning, designing, programming, testing, providing maintenance of, and training users on large integrated financial applications in COBOL.
• Experience with GL, AP, and AR financial software systems.
• Experience in software development lifecycle from planning, developing, testing, and documenting to delivery and maintenance.
Software Skills
• Programmed with SSIS, SSRS, C#, T-SQL, and Stored Procedures using MS SQL Server 2005 and MS Visual Studio 2005.
• Programmed in HTML, XML, JavaScript, ActionScript, COBOL, Assembly, and Pascal.
• Skilled in Flash and Dreamweaver 8 & CS3; InDesign, Photoshop, Illustrator, Acrobat CS2 & CS3; CorelDraw & Photo-Paint; QuarkXpress.
• Experienced in Visual Basic, MS Access, Word, Excel, PowerPoint, Visio, and Project.
• Familiar with Windows Vista, XP, 2000, Me, 98, 95, 3.1; MAC OS 9, OS X; DX10, DNOS, and IMS.
• Trained by Oracle in SQL and in relational database design and management.
Professional Experience
SQL Developer/Consultant – Disney Stores for SMCI; 2008 – 2009
• Gathered and documented user requirements for MS SQL Server projects.
• Used T-SQL and C# within SSIS, Management Studio, and Stored Procedures to develop and implement automated process to gather sales information from database and send daily email to all Directors / VPs.
• Migrated Data Warehouse from The Children’s Place stores acquired by Disney and converted the data to conform to Disney dimensions.
• Structured Disney Store operational data mart to optimize reporting for Marketing using SSRS and MicroStrategy.
IT Support, Graphic Artist, Preflight/Prepress Operator – Ventura County Star; 2005–2008
• Assisted in installation of MS SQL Server 2005 as part of an automated advertising tracking system on Windows Server 2003 platform.
• Used Flash 8 with ActionScript to create and modify ads for newspaper web site.
• Debugged HTML, XML, and JavaScript on newspaper web site in order for ads to appear and function correctly.
• Under daily tight deadlines, performed preflight/prepress proofing and correcting of approximately 150 ads daily for county newspaper using MAC.
• Worked with Adobe Acrobat Professional to process and correct PDFs from external customers for ads, interacting with external customers and internal staff.
• Used Photoshop CS2 to color correct photographs for editorial pages of newspaper.
• Worked with MEI PageDirector ALS to book and place retail advertisements.
• Performed liaison function among Directors of Sales and Marketing, managers, graphic artists, advertisers, and external customers to meet daily deadlines for newspaper and other publications.
Developer, Business/System Analyst, Tester, Technical Writer and Trainer - Texas Instruments; 7 years
• Throughout software development lifecycle of international project for General Ledger, Accounts Payable, and Accounts Receivable, gathered business requirements, planned and developed software through testing, deployment, and maintenance.
• Developed and wrote technical documentation, test cases, and training materials for international installation, testing, and training of financial software.
• Managed software release updates for over 170,000 lines of COBOL code in the General Ledger system and performed regression and unit testing.
• Developed integrated testing procedures, wrote unit and system test cases, established entrance and exit criteria for code, executed procedures, and fixed defects, which resulted in zero defects for GL, and implemented comprehensive QA process for GL for each major release internationally.
• Gathered and documented business and functional requirements for financial business, developed design for financial software, and programmed, tested, debugged, and maintained financial application software; deployed software and provided training to 7 sites and supported 20 sites, including sites in North and South America, Europe, Australia, Asia, which resulted in having a successful, consistent, stable financial reporting system, better communication among business units, and high efficiency with one site performing maintenance.
• Provided technical help desk support for 200+ international users online and by phone, for sites in Europe, Asia, Australia, North and South America.
• Served as internal technical consultant to Hong Kong developers, who adapted financial systems for the PC.
• Programmed in Assembly code for TI990 mini computers and developed interfaces and reports in various internal proprietary languages.
Previous Experience
Consultant – System Analyst
• Performed data migration of financial systems after Halliburton acquired TI division.
• Performed needs assessments and documented business requirements for small businesses. Included researching and ordering of computer equipment, such as peripherals, hardware and software, and PC and network set up, installation, configuration, and testing.
• Installed hardware, provided troubleshooting for operating system, hardware integration, and software problems for customers, who used MS Office and related software, which resulted in integrated systems with reduction of software problems.
• Created and maintained customer tracking MS Access databases for small businesses which resulted in improved sales management and customer service.
Owner / Director - Dallas Yoga Center, Inc.
• Managed yoga studio business, which included planning, designing, managing, and operating daily business of yoga studio, as well as performing operations of budgeting, bookkeeping, payroll, advertising, and scheduling for over 500 customers.
• Developed MS Access databases and reports in order to track customers, classes, fees, and payments, and used Quicken to manage finances of the business.
• Studied yoga and taught advanced, intermediate, and beginning yoga classes to yoga customers, and also developed training materials and trained yoga teachers.
• Set up software, installed hardware, and documented systems and trained end users for yoga institute in Pune, India.
Education
BA; Computer Science; University of Texas; Austin, TX.
Certification: Microsoft Certified Technical Specialist in SQL Server 2005 (test 70-431).
Contact this candidate