SUMMARY:

• 14+ years of Information Technology experience with 10+ years of Business and Systems Analysis, Testing, Development, Reporting and Support experience for web based applications and database systems for education services, governments, and telecomm/engineering clients in global business environments
• 7+ years of SQL Server 2005/2008/2012 experience performing report queries, solving index issues and table constraints
• 5+ years of SQL Server Reporting Services (SSRS) experience creating reports and performing data manipulation
• BS and MS degrees with pending PhD possessing solid skills in web/application development and integration working in Agile/Scrum environments. Familiar with SDLC processes surrounding analysis, design, documentation, testing, and stakeholder communication with frontend and backend support.
• Team player committed to collaborative learning with emphasis on training teams and users.

TECHNICAL SKILLS:

Project Tools: MS Project, Publisher, Visio, SharePoint, MS Office Suites, SQL Developer, TOAD, SQL Plus, MS Team Foundation Scripting SQL, T - SQL, VBScript

Business Intelligence: SSIS, SSRS, SSAS, Oracle BI, Business Objects, SASIxp (Used in School Districts), SalesForce, Oracle Reports, Crystal, DTS Packaging, Informatica

RDBMS: SQL Server, Oracle, FoxPro, MySQL, MS Access, dBase, SQL Anywhere

Operating System : Microsoft Server 200-2012 Platforms, Microsoft XP, Vista, Windows 7/8/10, UNIX Solaris, UNIXWare, Linux, Ubuntu

Web Services / Languages: .NET Framworks, Apache, C#, C++, VB.NET, HTML, XHTML, XML, JavaScript, CSS, AJAX, Flash

Content Management: Drupal, OpenCMS, Sitecore, WordPress, Adobe CMS, MS Content Manager, VSS

PROFESSIONAL EXPERIENCE:

Confidential, AZ

Sr. IT Consultant(Contractor)

Responsibilities:

• SAP/ERP run support working with business entities to ensure SAP and Informatica jobs run as scheduled.
• Troubleshoot and execute jobs using Business Objects for certain repositories as failures are encountered
• Act as a liaison between Project Managers and ETL developers for Business Objects reporting support, execution, development and enhancements
• Query tables, fix constraint issues, or resolve index issues
• Prepare Unix Servers, adapters, file storage and sync repositories daily for next run.
• Rotate on-call with 3 other team members and take off-shore calls after hours to fix production issues.
• SharePoint Administration creating dashboards and assisting users with site creations/web parts/workflows/InfoPath forms/lists/libraries, and maintain server support for IIS and SQL Server 2008.
• Use Oracle and SQL Server for query optimization, stored procedures, triggers, constraints, views, capacity planning, batch processing, and adhoc query via TOAD, SQL Plus, SQL Developer, and MS SMS
• Used SSRS for report creation and data manipulation in reports
• Gather user requirements and meet with stakeholders and business units for BI enhancements, work closely with developers to ensure enhancement requests are developed according to specs

Confidential, AZ

Sr. IT Consultant(Contractor)

Responsibilities:

• Owned and supported 9 production applications across national Honeywell locations.
• Gathered user requirements; communicate with IT users/developers on implementing application enhancements, break/fixes, severity resolutions, and monthly patching.
• Skills used SQL, SSRS for report creation, Oracle, HTML, XML, JavaScript, CSS, VB6, and a VMS.
• Tools used daily were Adobe Web CS5, VSS, SQL Developer, Brio, Attachmate Extra, SQLPlus, RAdmin/RDP, Dameware, IIS, SQL databases, Visual Basic, and UNIX.

Confidential, AZ

Systems Analyst/Integrator II(Contractor)

Responsibilities:

• Provided analysis, design and code modifications or enhancements in C#, VB, JavaScript, HTML, XML, SQL using Visual Studio 2008 & 2010, TFS and MVC for internal APS business units surrounding integrated web applications.
• Convert DTS to SSIS Packages in SQL BI Studio
• Collaborated with internal teams to provide break/fix solutions. Gather requirements, update technical documents, define scope of work documentation.
• Provided support to business entities with 3rd party applications and troubleshot/debugged web application issues.
• Manage projects working with vendors, stakeholders, developers, and business units.
• Managed, documented, and coordinated project initiatives within timeline constraints. Review code enhancements against BRD and specifications to determine fix type.
• Led change control management, update specs and follow changes through testing to production.
• Maintained Intranet pages on SharePoint 2010 surrounding knowledge base, wikis, and specs for projects.
• Provided Quality Assurance support and testing.

Confidential, AZ

Sr. Business Systems Analyst

Responsibilities:

• Business systems analyst for business units who participated in legacy migration. Communicate with stakeholders and establish requirements to design system specifications.
• Determined business processes for project migration, code to specifications.
• Analyzed, documented, and designed projects for user/department requests or through internal initiatives.
• Coordinated and interacted with associated project stakeholders to understand user requirements.
• Provided support and leadership guidance to student workers with project goals.
• Provided development migration and integration support for large project moving 3 disparate systems into 1 enterprise system. Develop user specifications to meet business requirements.
• Developed, maintained, and supported internal web applications built to interface a 3rd party ERP system using C++, SQL 2008, IIS 7, JavaScript, VB Script, SSIS Packages using VS 2008 & 2010 with SQL SMS, and used SSRS for report creation
• Originated technical documentation and manuals for web applications and 3rd party software to preserve business processes and for training purposes.
• Managed project to convert Classic ASP applications to .Net platform using C#, SQL 2008, AJAX, JavaScript, HTML
• Exposure to BI creating SSIS packages to meet project needs including BO report writing and customization

Confidential, AZ

Web Content Specialist(Contractor)

Responsibilities:

• Primary web developer to the Confidential Aviation Department for Sky Harbor, Deer Valley and Goodyear airports. SharePoint 2010 Administrator development and maintenance of InfoPath forms, User account administration, site creations, lists, and workflows
• C#, SQL, HTML, XHTML, XML, JavaScript, Flash, CSS, Adobe Web Creative Suite CS4, Visual Studios 2008, InfoPath 2007, Tortoise SVN, IIS, SQL/Oracle databases, and Microsoft .NET Frameworks
• Work closely with marketing and PR groups gathering requirements for website updates and content creation

Confidential,Tempe, AZ

Associate Software Engineer

Responsibilities:

• Worked with a team of developers on projects designed and catered towards software and application solutions for food service programs in K-12 school districts nationwide
• Migrated applications and systems from client/server to web for real-time data accessibility
• Created reports using Crystal Reports 2008, as well as optimized and troubleshot issues with reports
• Technologies used were MS IIS 6 & 7, Visual Studios 2008/2010, SourceSafe, Visual SVN, SQL Server 2008, Crystal Reports 2008, ASP, ASP.Net, C#, Visual Basic 6.0, HTML, and XML

Confidential, AZ

Web Developer/Business Analyst

Responsibilities:

• Developed district website using Classic ASP, ASP.Net, CSS, ADO.Net, VB.Net, AJAX, & JavaScript.
• Gathered user requirements; communicate with stakeholders to implement effective project plans.
• Established business and stakeholder needs for websites.
• Integrate and support 3rd party web applications and software with district and school websites.
• Worked with district administrators to develop a strategic plan for the integration of a district Intranet site with MS SharePoint services, planning, designing and implementation of a content management model for district and school website contributors, enticed other entities interested in creating a web presence, and for future development requests of custom in-house applications, content, and integration.
• Tools used were Adobe CS3 Suite (Dreamweaver, Flash, Fireworks, Photoshop, Illustrator, Acrobat, Contribute), Visual Studios 2005 & 2008, IIS Manager, and SQL Server 2005 Enterprise Manager.
• Also helped as E-rate coordinator for the district.
• Server migrations (2005 to 2008), Barracuda firewall administration and support.
• MS IIS Administration, SQL Server Database owner/administrator.

Confidential, AZ

Software Support & Technology Programs Specialist

Responsibilities:

• Created technical manuals to school and district staff for training and support purposes.
• Maintained license inventory database, Update and Support of district software related to curriculum in classrooms. Coordinate the overall E-rate process
• Managed accounts/security groups in Active Directory, Cisco Call Manager and Unity voicemail. Configure or make adjustments to user settings in Call Manager and Unity.
• Assigned trouble tickets to appropriate tech staff members.
• Prioritized trouble tickets and found solutions before closing tickets.
• Solved escalated tickets or reassigned to higher support techs as necessary.
• Participated in district software committee where the main purpose of the committee was to properly evaluate and approve software products requested by school or district staff.
• Barracuda firewall administration and support to campus technicians.