Systems Engineer/Senior Data Architect Resume McKinney, TX - Hire IT People

PROFESSIONAL SUMMARY:

Talented Senior Data Architect with a strong background in SQL development and data analysis with exceptional skills in requirements gathering and project management.

Data Warehousing and Analytics
MS SQL Server 2016/2014/2012/2008
Proficient in SSRS, SSIS, SSAS
Excellent analytical, problem - solving and documentation skills
Exceptional written and oral communication skills
Strong leadership skills
Well versed in multiple development/design languages; C#, SQL, HTML, CSS, JavaScript
In-depth understanding of software development life cycle (SDLC)
Agile/Scrum/Kanban methodologies
Experience with JIRA, Microsoft Project, TFS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, McKinney, TX

Systems Engineer/Senior Data Architect

Responsibilities:

Developed and optimized complex SQL queries from multiple diverse data sets.
Planned, designed, and implemented application database code objects such as stored procedures, triggers, and views.
Collected and analyzed project requirements to determine needed data structure and prepared technical design documentation ensuring mutual understanding of the scope and desired outcomes of the project.
Performed code reviews, analyzed execution plans, and refactored inefficiencies.
Created, managed and maintained scheduled SQL Agent jobs.
Responsible for management of data replication from the ERP system to local data warehouse.
Identified, created, and implemented processes and procedures to ensure data integrity across the data warehouse.
Created and managed ETL packages using SQL SSIS.
Monitored database performance metrics and corrected issues as they arose.
Responsible for planning and coordination of outside vendors to ensure the successful migration of data infrastructure to a new hosted environment.
Led teams in developing custom solutions to meet business objectives using Agile methodologies.

Confidential, Dallas, TX

SharePoint Developer

Responsibilities:

Designed and developed external facing custom C# portal solution streamlining collaboration and communication between customers and staff.
Planned and designed enhanced permission strategy of existing 2010 SharePoint portal solution. Improving system performance and minimizing risks associated with the use of fine-grained permissions.
Designed and developed custom C# SharePoint 2010 Workflows, Event Receivers, Timer Jobs to assist staff in managing client accounts.
Planned and developed Cross-Site publishing architecture for a corporate intranet site.
Researched architecture and participated in the planning of SharePoint 2013 migration.
Managed all phases of Software Development Life Cycle (SDLC), business analysis and project management for multiple internal and external facing SharePoint 2010/2013 solutions.

Confidential, Menomonee Falls, WI

Senior Web Developer/Analyst

Responsibilities:

Managed all phases of the software development lifecycle (SDLC) for multiple custom solutions.
Participated in Process Advisory Council (PAC) working toward improving the processes and procedures used throughout the Information Technology department.
Acted as a Corporate Diversity and Inclusion Advocate. Leading staff and teams in reaching the organization’s goal to provide an inclusive and diverse culture for patients and employees.
Developed multiple SharePoint and web solutions to improve efficiency, collect metrics and improve internal communication for various departments and stakeholders.
Provided excellent customer service by meeting or exceeding customer expectations and project timelines.
Collaborated with executives and team members on writing and implementing a 5-year Team Strategic Plan.
Actively participated in the development of successful process and project management team strategies.
Collaborated with intranet and internet content management vendor to migrate and streamline information architecture.
Organized and created team documentation ensuring a streamlined requirement gathering process.

Confidential, WI

Systems Analyst /Database Architect

Responsibilities:

Senior Lead SQL Programmer in development and implementation of custom in-house Client Management application.
Successfully led team in the development of Business Intelligence Solutions.
Monitored and audited database performance and corrected inefficiencies.
Planned, designed, and implemented application database code objects such as stored procedures, triggers, and views.
Developed executive dashboard metrics using SSRS.
Created training documents and conducted in-house training sessions for internal users on custom in-house applications and SharePoint.
Collaborated with IT Management on internal review and auditing of IT policies.
Developed custom applications using SQL, ASP.net, C#, VB.net