PROFESSIONAL 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.
• SCRUM and Agile background with applied emphasis in requirements gathering, business systems analytics, project planning/coordination with strong focus surrounding analysis, design, documentation, testing, and stakeholder communication. Additionally, a solid 5+ years of SQL Server Reporting Services (SSRS) experience creating reports and performing data extraction, transformation and manipulation. Possesses BS and MS degrees concentrating in Information Technology and is currently pursuing PhD in Business Administration.
• Team player committed to collaborative learning and building to meet IT business needs for organizations.

COMPETENCIES:

Experience Areas: Data Mapping, Data Modeling, Workflow, Gap Analysis, JAD, SQL, SSIS/SSRS/SSAS, Oracle BI, BO, SalesForce, Informatica, SASIxp, Oracle, MS SQL Server, .Net Frameworks, C#, XML, CSS, Adobe CS3 - CS5, Drupal, MS Content Manager

Methodologies: Scrum, Agile, SDLC, RAD

Project Tools: MS Project, Confluence, Konbon, Publisher, Visio, SharePoint, MS Office Suites, MS Team Foundation, MS Great Plains

EXPERIENCE:

Business Process Analyst

Confidential

Responsibilities:

• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Created use case scenarios and documented work flow and business process using MS Visio. Conducted user interviews and documented business and functional requirements.
• Gathered and documented business requirements for existing and future business systems. Great Plains, Vison Real Estate system and Kronos data mining and analysis in order to manage and operate business processes while adhering to changes.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Process modeling and development of SQL reports/procedures to meet business needs.
• Performed in depth Gap analysis with different business groups to ensure that the system initiatives are met.
• Stakeholder meeting facilitation and interaction to understand business needs by using requirements gathering techniques and create process flows.
• Work directly with real estate, payroll, human resources and parks and recreation departments performing systems and data analysis to meet integration and development needs.
• Kronos implementation assistant project leader to meet HR/Payroll requirements.
• Project lead for implementing and configuring Vision software and facilitate functional testing using Zephyr tool.

Sr. IT Consultant

Confidential

Responsibilities:

• SAP/ERP run support working with business entities to ensure SAP and Informatica jobs run as scheduled.
• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Web application and SharePoint code development using Dreamweaver, Drupal, Visual Studio, SharePoint, Coldfusion in various languages, such as; C++, .Net, ASP, VB, VBScript, JavaScript.
• Interacted with the client and the technical teams for gathering requirements and translating Business Requirements into technical specifications.
• Troubleshoot and execute jobs using Business Objects for 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.
• Served as conduit for managing system requirements between the business and the software development team.
• 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
• Involved as a Test Engineer in testing team for manual and automated testing with open source tools.
• Created/Updated business process flow and data flow diagrams using MS-Visio
• Prepared business user stories while following Agile methodology and translated them into technical requirements
• Gathered user requirements; communicate with IT users/developers on implementing application enhancements or break/fixes.
• Performed Requirements Analysis by gathering both functional and nonfunctional requirements based on interactions with the product owners and stakeholders.

Systems Analyst/Integrator II

Confidential

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.
• 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 using testing methodologies concluding with acceptance testing, defect tracking and release management.

Sr. Business Systems Analyst

Confidential

Responsibilities:

• Business systems analyst for business units who participated in legacy migration and integration. Communicate with stakeholders and establish requirements to design system specifications.
• Determined business processes for project migration.
• Analyzed, documented, and designed user stories per 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.
• Developed, maintained, and supported internal web applications built to interface 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 using TFS 2010.
• Exposure to BI creating SSIS packages to meet project needs including BO report writing and customization.
• Functional and non-functional testing.

Web Content Specialist

Confidential

Responsibilities:

• Primary web developer to the City of Phoenix 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.

Associate Software Engineer

Confidential

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.
• Tools used were MS IIS 6 & 7, Visual Studios 2008/2010, TFS 2010, SourceSafe, Visual SVN, SQL Server 2008, Crystal Reports 2008, ASP, ASP.Net, C#, Visual Basic 6.0, HTML, and XML.

Web Developer/Business Analyst

Confidential

Responsibilities:

• Gathered user requirements; communicate with stakeholders to implement effective project plans. Developed district website using Classic ASP, ASP.Net, CSS, ADO.Net, VB.Net, AJAX, & JavaScript.
• Established business and stakeholder needs for websites.
• Integrate and support 3rd party web applications and systems
• 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.
• E-rate coordinator for the district.

Software Support & Technology Programs Specialist

Confidential

Responsibilities:

• Created and distributed technical manuals to school and district staff for training and support purposes. Barracuda firewall administration and support to campus technicians.
• 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.
• 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.

Tier2 Broadband Support

Confidential

Responsibilities:

• Level II Business and Residential support.

PC Technician (Contractor)

Confidential

Responsibilities:

• Convert legacy (1000+ seats) Windows 95, 98 and NT 4.0 to a Windows 2000 Professional platform for several Confidential bases in the Confidential area.

Web Technical Support Specialist II

Confidential

Responsibilities:

• Install/configure/troubleshoot client account issues