Lead Sql & Web Developer/sharepoint Admin Resume
Bonita Springs, FL
PROFESSIONAL SUMMARY:
- Over sixteen years’ experience in the Information Technology field
- Web tools: SharePoint Designer, FrontPage, Visual Interdev, Visual Studios 2005/2008/2010 , Flash 4/MX, Dream Weaver 8, ASP, ASP.Net, C#, VB/Java - script, HTML, CSS and DHTML, jQuery, Bootstrap, Angular JS
- Have overseen and implemented web applications through their full life cycle
- Ten years’ experience in administering/implementing and Developing with MS SQL Server (6.5,7.0, 2000, 2005, 2008, R2)
- Over 3 years’ experience with VB 5.0/6.0/ASP.Net
- Over five years of experience in design and administering NT networks
- Solid knowledge of Visual Studios Team Foundation Server (Source Control, SharePoint, Reporting Services, Analysis Services, Work Item Tracking, etc.)
- Familiar with Oracle implementation and maintenance and HPUX and Sun Solaris
SOFTWARE SKILLS:
Operating Systems: Win 3.1: 2007, NT 4 WS & Svr, 2000, 2003, 2005, 2008, Vista, XP, HPUX, Solaris
Back Office: Proxy 2.0, IIS 4.0, Exchange 5.5, SMS, SQL 6.5/7/2000/2005/2008/ R2
Programming: VB 6, VB Script, Jscript, C#, ASP, .Net, COBOL, RPG, BASIC, VS 2k3/2k5/2k8/2010
RDBMS: MS Access, MS SQL Server 6.5/7.0/2000/2005/2008/2008 R2, Oracle 7.3.4
Web/DTP: HTML, DHTML, ASP, .Net, SharePoint, Visual Studios 2005/2008/2010 , AJAX, Photoshop CS, Flash 4, CSS, FTP, IIS, jQuery, Bootstrap, Angular JS
Middleware: Confidential Transaction Server, COM/DCOM, COM+, Entity Framework, Web Services
Hardware/Network: Confidential, Compaq, Digital, Confidential, Dell, Generic makes, Network Topologies
CRM: Siebel Call Center, Siebel Tools
Other Applications: MS Office, Publisher, Lotus Notes, Lotus Suite, Application Expert, Crystal Reports
Team Foundation: VSTF Whidbey/Orcas, SharePoint, Reporting Services, SSIS, Analysis Services, SCC
PROFESSIONAL EXPERIENCE:
Confidential, Bonita Springs, FL
Lead SQL & Web Developer/SharePoint Admin
Responsibilities:
- Created various web sites for community based non-profit organizations and their members.
- Worked in-house and Confidential client sites and projects.
- Web Development and Web Marketing Website
- Built site using HTML5, CSS3 & jQuery, ASP.Net, C#, SQL Server
- Database driven Products & Services section
- Sales and marketing application utilizing Angular.js built on MVC framework using Visual Studios
- Photoshop, Corel Draw
- SQL Server
- Data modeling for marketing app
- Reports and ETL for use by executives, accounting and marketing
- Utilizing HTML5, CSS3, jQuery, Photoshop, Corel Draw, ASP.Net, C#, Exchange Server, SMTP Mail, Visual Studios 2010, Angular.js
- Dominos Pizza
- Web/UI developer
- Wrote the code to properly retrieve the data from Web Services
- Designed the UI for the Food Ordering system - HTML5, CSS3, Bootstrap
- Responsive Grid system
- Custom calendar controls
- Custom validations
- Analyses charts
- SPA on MVC using Angular.js, Bootstrap, Web Services, JSON and javascript
- Unit testing using Jasmine
Environment: SQL Server 2008, WebStorm, Perforce, Angular.js, Jasmine, JSON, Bootstrap, Javascript, SPA, MVC, Visual Studios, HTML5, CSS3, IIS
Confidential
SharePoint Admin & Dev
Responsibilities:
- Installed SharePoint 3.0 in company environment & upgraded to 2013
- Helped set up sites for each department
- Security administration with AD groups
- Automated and scheduled backup scripts
- Implemented KB repository
- Used Workflows for custom processes
- SQL DBA/Developer (In-house and client projects)
- Implemented SQL Server 2008
- Security administration
- Database design and modeling
- Confidential -SQL queries and functions
- Website for recruiting company
- Login module (Converted from standard ASP.Net site db to SQL Server)
- Job placement services
- Technical Service and Support
- Messaging module
- Website creation and customizations offering
- Utilizing SQL Server, ASP.Net, AJAX (jQuery), C#, CSS, Javascript, Exchange Server, SMTP
- Web site for a cleaning company
- Design front-end site
- Testimonials, contact form, content management engine
- Utilizing SQL Server, ASP.Net, C#, HTML, CSS, Exchange Server, SMTP Mail
- Web site for a facial aesthetics doctor
- Design front-end site
- Patient Intake App
- Testimonials, contact form, content management engine
- Utilizing SQL Server, ASP.Net, C#, HTML, CSS, Exchange Server, SMTP Mail
- Built site using HTML5, CSS3 & jQuery, ASP.Net, C#, SQL Server
- Database driven Deals section
- Photoshop, Corel Draw
- Utilizing HTML5, CSS3, jQuery, Photoshop, Corel Draw, ASP.Net, C#, Exchange Server, SMTP Mail, Visual Studios 2010
- Built site using HTML, CSS & jQuery, ASP.Net, SQL Server
- Database driven Menu system
- Photoshop, Corel Draw
- Utilizing HTML5, CSS3, jQuery, Photoshop, Corel Draw, ASP.Net, C#, Exchange Server, SMTP Mail
- Built site using HTML, CSS & jQuery
- Photoshop, Corel Draw
- Utilizing HTML, CSS, jQuery, Photoshop, Corel Draw, ASP.Net, Exchange Server, SMTP Mail
- Built site using HTML, CSS & jQuery
- Photoshop, Corel Draw
- Utilizing HTML, CSS, jQuery, Photoshop, Corel Draw, ASP.Net, Exchange Server, SMTP Mail
Environment: Visual Studios 2010, AJAX Toolkit (jQuery), SQL Server 2008 R2, (SSRS) Reporting Services, Javascript, VB/C#.Net, (SPS) SharePoint, WSS 3.0, MS Exchange Server, MS Visio, CorelDraw X4, MS Access, Entity Framework, SendGrid, Web Service, MS Project, Flash editor, Cloud based email services - Google
Confidential, Redmond, WA
Sr. Systems Engineer/Build Engineer
Responsibilities:
- Deployed software in PPE and Production environments
- Document Reviews
- Environment Prep
- Server decommissioning
- Platform and server maintenance
- Script Automation with oSQL, command line and PowerShell
- Maintain SOP documents
- Wrote the BRD for a deployment doc tool which would maximize the efficiency of work done by the various teams in the deployment process
- Designed and implemented the back-end data structure
- Created a prototype for Phase II of the DeployDoc Tool in Silverlight
- Sufficient budget was not allocated for the project
- Created an email template with the necessary fields which all teams were in agreement with. Phase II - Created a SharePoint “Resource” calendar with the appropriate fields and implemented workflows to perform data validations, automate field population and send out an email notification with the appropriate data to all parties concerned. The SharePoint calendar was adopted throughout the Finance space within Service Transition and applauded by other teams. Phase III - Since this created significantly more work for the SBEs, I created an Excel sheet, in compliance with the policy of not creating new applications, which, based on the unique ID, pulled data from SharePoint calendar and populated the entire template with the pertinent data which would otherwise be required to be filled out manually. The tool also allowed for quick selection of status and automatic scheduling and notification to all parties who needed to be notified. On average it cut down roughly 15 minutes per deployment and gave a consistent look and feel with all relevant data to the customers.
- Wrote a tool for gathering server configuration data from over a thousand servers we support and populate a database
- Included Machine, Network, Hardware, Software and SQL Server Agent job data
- Built an SSRS reports application to view data and drill down to pertinent data which included navigation to other reports and analyzing SQL Agent job failure rates and offending server/job
- Decom Project Plan
- Created a detailed MS Project plan which helped learn the server decom process in Service Transition
- Synced up the Project with SharePoint
- Sanctioned by Team Lead and Adopted by SRM
Environment: Visual Studios 2005/2008/2010 , SharePoint Designer, InfoPath, SQL Server 2005/2008/R2, (SSRS) Reporting Services, SSIS, VB-Script, VB/C#.Net, (SPS) SharePoint, WSS 2.0/3.0, Expressions Blend, Silverlight client
Confidential, Redmond, WA
Operations Engineer/DBA
Responsibilities:
- Supported several apps in the Finance space
- Created a KB system in SharePoint
- Trained new hires
- Built Server Monitoring CMDB and wrote reports to present data
- Deployed a solution to gather Server data through WMI calls
- Set up notifications on threshold
- Deployed drill-down reports in SSRS and deployed on the SharePoint site
- SQL Server
- DBA tasks (Agent jobs, backup/restore, locking and blocking issues, etc.)
- Security
- Automation and streamlining (Command line, SQL, PowerShell)
- Server Support (Problem Management)
- Deployed VSTF Server Instances over single, dual and 3 layer Implementations
- Application Tier
- Data Tier
- Analysis Services Tier
- Each deployment of TFS included deployment of SharePoint Server
- Troubleshoot and resolve issues with SQL Srv, IIS, Analysis Services, Reporting Services, etc.
- Triage product bugs with the Product team through the bug tracking system
- Customer Support (Incident Management)
- Liaison to the Product team
- Support VSTF across 30 instances, 10,000 users and 500 projects
- Source Control
- Work Item Tracking
- Documents and SharePoint
- SQL Server Reporting Services
- SQL Server Analysis Services
- Support Trainer
- Trained Tier 1, 2 and 3 levels
- Lead weekly team meeting with the support group
- Alert Tuning and Optimization
- DBA
- SQL Blocking issues
- Security
- Reporting Services
- Analysis Services
- Developer (New Project Creation): Created an application to collect requests from customers for creation of new projects
- C#.Net
- Telerik Controls
- SQL Server
Environment: VSTF Server, Visual Studios 2005/2008, SharePoint Designer, InfoPath, SQL Server 2005, (SSRS) Reporting Services, (SSAS) Analysis Services, (SSIS) Integration Services, VB/C#.Net, Visual Source Safe, Product Studio, Source Depot, (SPS) SharePoint, WSS 2.0/3.0
Confidential, Alpharetta, GA
Web Developer
Responsibilities:
- Create, Maintain and troubleshoot web sites for clients
- Create secure site for internal use accessible from the internet on a .Net platform
- Graphic design using MacroMedia FireWorks and Flash MX
Environment: Dream Weaver, ASP.Net, MacroMedia FireWorks, Flash MX, MS SQL Server, Textpad, Java Script, Visual Interdev, Crystal Reports, IIS
Confidential, Jacksonville, FL/Atlanta, GA
Applications/Web Developer/SQL DBA
Responsibilities:
- Move security validation and the bulk of the processing to COM components.
- Developed an application to tie in the local network to the web-based solution.
- Designed and implemented an Intranet for company use:
- Intranet applications were used by the company’s employees to navigate through the company network, access the web and share information. Used and tested Java-Script heavily.
- Created home page with Flash option for company Website.
- Planned and designed an Online Recruiting Web Application still being constructed:
- Created an online site to submit candidates’ resume via the web. Used Visual Interdev to create ASP pages to push and pull data from a MS SQL Server. Used FrontPage to upload files to the site and MS Access to test the application locally. Used Crystal Reports to pull data and display it in a Resume Format
Environment: FrontPage, Access, VBA, VB 6.0, MS SQL Server, Metapad, Flash 4, Java Script, Crystal Reports, IIS
Network Administrator
Confidential
Responsibilities:
- Administered and maintained network
- Planned out Network Architecture, Implemented WINS, DHCP, Remote Administration, Fault Tolerance and Rollout plan
- Installed and configured RAS Server, IIS Server, MS SQL 7.0, Confidential Proxy Server 2.0 and Exchange Server 5.5
- Set up Terminal Services for remote connection and Administration
- Development of Company Website using HTML, FrontPage 2000 and Java Script.
Environment: NT Server, Advanced Server w/ Terminal Services, IIS 4 & 5, MS Proxy 2.0, MS SQL 7.0, Exchange 5.5, RAS, McAfee Anti virus and Remote Desktop.
Confidential, Atlanta, GA
SQL DBA
Responsibilities:
- Maintained the QA and Production databases and Web Servers
- Created Views and wrote stored procedures to perform various functions and reports
- Modularized the code for efficient execution
- Troubleshoot and optimized existing Procedures and databases and application written in classic ASP
- Data Modeling on new projects
- Managed Database and Network security
- Created Data recovery and fault tolerance schemes
- Created DTS (ETL) packages and scheduled same to export vendor data and to import client data and status info
Environment: Win 2000 Advanced Server,2003 Server, XP, Visual Studios 6.0, MS SQL 2000, PGP, DTS Backup 2000, VNC, Terminal Server, IIS 5.0
Confidential, Atlanta, GA
MS Access/VB Developer
Responsibilities:
- Development of Order Purchase Management (OPM) and Order Fulfillment Management System (OFM)
- Re-designed the existing database structure
- Documented the re-design Developed an application to tie in the local network to the web-based solution.
- Modified code and front-end form in MS Access
- Provided flowchart designs and analysis to the migration team
- Migration to MS SQL Server
- Supported various applications from front end design to support
- KMS (Knowledge Management System) and K-Net (Knowledge Network)
- User support - Supported every aspect of the web application
- Track calls via BLT
- Provide monthly Reports
- Helped various teams fix errors in the ASP code in the application
- PROPHET (previously OPM/OFM)
- Provided detailed analysis and user support
- Smartcube (reporting application)
- Ran monthly reports in coordination with the worldwide team
- Monitored queue and followed procedures in troubleshooting and resolving problems using Essbase Manager tool
- Provided documentation and training
- Supported the Confidential UX Servers; ran scripts, cronjobs, wrote monitoring scripts, backup scripts, etc.
- Administered the SQL Server and Cold Fusion MX Servers in the NT and Win2k platforms and supported Oracle in HPUX platform
- Knowledge systems included a complete online collaboration environment for all Confidential personnel worldwide
Environment: HPUX, MS Access, VBA, VB 6.0, ASP, Oracle, MS SQL Server, NT Server, IIS 4, Hyperion Essbase, Remote Desktop.
Confidential, Atlanta, GA
MS Access & SQL DBA/Developer
Responsibilities:
- Created Tables, Queries, Forms, Reports and Modules - Data Modeling, Database creation and Front end development
- Created Order entry system for Hotels, Buildings, Facilities Information and Project Details
- Phases II, III and IV moved to a Confidential contract (See Confidential, Inc. Above)
Environment: Access 97/2000, VBA, VB 6.0, MS Windows 95, MS-SQL Server, ASP, MS Front Page, Visual Interdev
Confidential, Atlanta, GA
VB Coder
Responsibilities:
- Wrote code to control the API functions of Siebel Call Center product
- Used Siebel Tools and documentation to break down various components of Siebel
- Wrote code for the OLE Automation Server and COM Data Server
- Modularized the code for efficient execution
- Trained in Application Expert (a Network monitoring and Latency prediction tool)
- Used LoadRunner to “farm” code out to workstations
Environment: Windows2000 Pro, VB 6.0, MS SQL 7.0, DB2, Siebel Call Center, Siebel Tools, Application Expert, LoadRunner, OLE Automation Server, COM Data Server
Confidential, Jacksonville, FL
Systems Analyst
Responsibilities:
- Setup and trained the team in MS Project and Remedy Help Desk
- Setup up Naming Conventions and rollout strategies
- Security Project Lead
- Standardized Network shares and permissions
- Audited Domain accounts for potential security risks
- Implemented Policies and lockdowns
- Standardized Anti Virus scheduling and logging
- Implemented and administered MS SQL Server 7.0
- Implemented Oracle Hot Standby for mission critical production database
- Implemented Terminal Server to access 3rd party software (Canal +) with a single-user license key for multi user access.
- Provided Server level support and Network Services such as Systems Design, Analysis and Architecture
- Built VB and Access Applications for Network Administration ease of use
- Supervised Tier 2 Help Desk
Environment: IIS4, FTP Server, Oracle, Visual Basic, MS SQL 7.0, Canal +, McAfee, Terminal Server, MS Access.