SQL Server Developer/DBA (Sacramento and surrounding area)

Date: 2012-12-10, 7:56PM abp0ci@r.postjobfree.com

Thank you for taking time to review my qualifications for your open position.

My family is about ready to make the move back to Northern California (Sacramento area, not SF Bay). I am currently living in Arizona, and would like to obtain a Northern California position where I can work remotely for 3 to 4 months from Arizona prior to moving to California. Afterwards, I would be available on-site, if preferred. I have successfully telecommuted over the years and have great work ethics. I am not seeking a company to pay for relocation, but rather to allow me to save more funds prior to my move by temporarily working remote.

I am open to phone interviews (or Video Meeting).

RESUME

As an IT specialist for over 29 years, I have extensive experience and proven skills required to manage, analyze, design, develop and implement strategic solutions for complex business needs. My self-motivation, desire for quality and drive for excellence has allowed me to achieve remarkable results. I work well individually or within a diversified team environment, and have been a successful, mentor and collaborator. Managing and/or developing large projects through Full Lifecycle development, from concept to training of end users, is nothing new. My trouble-shooting skills are exceptional. I thrive on challenge. I am seeking a position where I can truly "make a difference."

TECHNOLOGIES/SKILLS

MS SQL Server 2012/2008 R2/2008/2005/2000/7.0/6.5/6.0 (SSMS), Transact SQL (T-SQL), Reporting Services (SSRS), Integration Service (SSIS), DTS, SharePoint, TFS, Change Management, VBScript, MS Visual Studio 2008/2005/2003, MS Visual Basic (VB) 2008/.Net/6.0/5.0/3.0, DB2, NextGen EPM/EMR (custom reporting and analysis), Crystal Reports, Cognos ReportNet: Framework Manager/ReportStudio, MS Access VBA, MS Excel VBA, Subversion, Perforce, Visual Source Safe, ASP (classic/.Net), MS Project, Visio, MS Office VBA, Sybase, Rapid SQL, ORACLE, UNIX Shell Scripting, FTP, Windows/Server, IIS, Citrix Server, Novell, O/S 2, EDI, DOS, dBASE, Great Plains, Siebel Systems VBA, TCL, Data Warehouse.

PROFESSIONAL EXPERIENCE

8/2012-11/2012 Consultant, Contract Tempe, AZ

SQL Server DBA -- Healthcare, Blood Bank (Part-time, Partial Telecommute)

Daily monitoring and maintenance for many MS SQL Servers. Troubleshoot, configure, optimize, resolve and prevent issues. Side projects: logical and physical proof-of-concept template design and implementation of extract process for a new national database (NPAR). MS Access conversion to SQL Server back end. MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, VS, SSIS, T-SQL, MS Access, CommVault, Idera SQLsafe and various tools, Data Warehouse, Oracle, HCLL, Sagent plans.

11/2011-5/2012 Consultant, Contract Tempe, AZ

Sr. SQL EDW Developer -- Sales, National Call Center (Partial Telecommute)

SQL Server Development and Migration of Enterprise Data Warehouse DataMarts for Business Systems Support: develop, modify, monitor and convert ETL SSIS packages and SSRS Report Server Reports. Optimize Databases and their objects (stored procedures, functions, views, etc.). Convert ad hoc queries within ETLs and Reports to stored objects. Create maintenance plans. Provide database support for a major company restructure -- MS SQL Server 2008 R2, VS, SSIS/ETL, SSRS, T-SQL, SalesForce, Apex Data Loader, Results

6/2011-8/2011 Independent Consultant, Short-term Contract Tempe, AZ

Sr. SQL DBA/Developer -- Language Interpretation

Establish High Availability Systems for Startup Company. Develop CRM database and assorted modules. Create interfaces between custom vendor platforms and in-house solutions. Develop SSIS packages (ETL) for device data feeds, Design Client self-service web portal, including billing module. Write technical and end-user documentation. -- MS SQL Server 2008 R2, SSIS, SSRS, T-SQL, .NET, Avaya

11/2010-6/2011 ClickSquared, Full-Time Scottsdale, AZ

Sr. SQL Database Developer -- Marketing (Telecommute)

Develop automated database solutions via .NET technologies and Microsoft SQL Server. Develop SSIS packages (ETL solutions) for DataMarts, Design database table structures and objects: stored procedures, views, UDFs, etc. Develop internal/external business processes and reports. Perform full application lifecycle, including documentation. -- MS SQL Server 2008/2005, SSIS/DTS, T-SQL, SSRS

2/2010-8/2010 Independent Consultant (Various Contract Positions) IL / NY

Sr. SQL Database Developer, Sr. Database Architect -- Direct Sales, Human Resources (Telecommute)

Design and develop data warehouse objects (complex ETL stored procedures, views, UDFs and create SSIS packages). Develop custom application enhancements (back-end) -- MS SQL Server 2008, SSIS, T-SQL

1/2009-1/2010 VirtualPBX, Full-Time San Jose, CA

Sr. SQL Developer/DBA -- Telecommunications (Telecommute)

Database schema optimization and architecture, including complex Stored procedures, views, triggers, UDFs, etc., implementation, source control and documentation. Create ETL SSIS packages. Mentor Software engineers. Database code reviews. Maintain and administer all SQL databases: backup/recovery, replication, clustering, performance tuning, security, etc. Implement and maintain data warehouse, production, test, development and reporting server environments. -- MS SQL Server 2005 (development and administration), DBF, SSIS, SSRS

11/2007-12/2008 Restoration Hardware, Full-Time Corte Madera, CA

Sr. Developer -- Retail

Design and develop key modules using SQL Server-based technologies (including custom order management system). Migration and administration of CommercialWare Collaborate (Vendor Portal) and CommercialWare Direct (OMS), including custom HDL process. Migrate and configure IssueTrak support software. Utilize strong troubleshooting and problem resolution skills. -- MS SQL Server 2005/2000 (development and administration), DB2, troubleshoot issues (XML, VB.Net, Classic ASP, ASP.Net)

11/2006-11/2008 Northcentral University, Part-Time Prescott, AZ

Sr. SQL Developer (DBA) -- Higher Education (Telecommute)

Complete management and administration of multiple high-availability database servers for Web based Higher Education University. Develop complex stored procedures, functions, triggers, user defined functions, views, tables etc., supporting a team of Web Developers. ETL. Performance tuning, optimizing and quality control. -- MS SQL Server 2005, SSRS, troubleshoot (VB.Net, Classic ASP, ASP.Net)

5/2006-9/2006 Barnett Dulaney Perkins Eye Center, Consultant Phoenix, AZ

Sr. Database Developer -- Medical Eye Surgical Facility

Develop complex proprietary business software (SQL backend) and reporting products. Administer NextGen security, product support and template development. Create commercial applications. Manage IT staff. Maintain, optimize and enhance applications, utilities and reports. Create ETL processes for third-party vendors and claims data (Medicare, BCBS, etc), as well as provide complex surgery enhancement, marketing and AR reporting utilities to maximize business growth potential. -- MS SQL Server 2000 (T-SQL/DTS), VB.Net, Crystal Reports, Citrix Server, NextGen Enterprise Practice Management (EPM) and Electronic Medical Records (EMR) Modules

8/2002-5/2006 Bank of America, Full-Time Phoenix, AZ

Sr. Programmer/Analyst and IM Manager -- Financial Operations

Design/modify Cognos and Crystal Reports. Develop complex stored procedures for financial reporting. Optimize DBs. Direct manager for eleven IM associates developing mission critical systems in support of many LOBs. Translate business strategy into solutions, identify, research, analyze and resolve complex problems. Perform Resource and Talent Planning, Budgeting, Associate and Business Reviews. Data Modeler: Framework Manager. -- MS SQL Server 2000 (T-SQL, DTS), Crystal Reports, Cognos ReportNet, Framework Manager, ASP

1/1999-7/2002 Independent Consultant (Various Contract Positions) AZ / CA

Sr. Database Engineer, Project Manager, Database Analyst, Principal Engineer, MS Access Developer

Information Services, Mortgage and Loan, Healthcare Network and Claims Processing, Internet Networking, Human Resources and Benefits Administration, Energy Engineering, Law Enforcement

MS SQL Server 2000/7.0/6.5 (T-SQL, DTS), Oracle Data Warehouse, Sybase 12, Rapid SQL 5.7, Unix Shell Scripting, FTP, Citrix, MS Access 97/VBA, MS Visual Basic, ActiveX/COM objects, QMACS, Kronos, InterDev, ASP, HTML, FrontPage, aQden, Q&A For DOS, dBaseIV, Corel Quattro Pro, Windows 95, Novell Network

ROI

1. Well seasoned technology professional (over 27 years of experience).

2. Self-motivation, desire for quality and drive for excellence in all that I do.

3. Ability to quickly grasp new structures and systems, in order to hit the ground running.

Testimonials:

1. I took on the challenge as a Sr SQL DBA/Developer, walked into an empty building and built from scratch a high volume database for a client with a critical timeline and did so in less time than they requested.

1. As a Sr SQL Developer, designed and implemented a fully-scalable database Security Application Model, which is now the foundation for all of the Communications Service Provider's proprietary subsystems.

2. While consulting, automated various manual processes for client's Workforce Planning ETLs that otherwise took many manual hours, saving the company thousands of dollars per month.

3. Sr Database Developer, completed a 3rd party product migration where 4 others before me had failed. The Surgery Center's CEO anticipated a 6 month turnaround. I accomplished the necessary tasks in 3 weeks.

4. As the Information Management Manager of a large financial organization, I brought back good moral and consistent superior results to the department that was previously poorly managed, which eliminated turnover and customer complaints.

Contact this candidate