SUMMARY:

• Solid understanding of OLTP/OLAP database structures. Including 1 5+ years’ experience in analysis, design and implementation of the physical model, security model, as well as relational and dimensional design of databases for enterprise level applications. Extensive use of BIDs suite including SSIS, SSAS, and SSRS for data analysis, reporting, and integration.
• Hands on experience creating, designing, and modeling data infrastructure components to support integration of disparate data systems as well as modeling the OLTP/OLAP structures to support a high level of data integrity and meet all required capacity, performance, retention, and reporting needs.
• Strong experience in collaborating with all members of project teams and clients to fulfill business requirements, establish best practices, design principles, and data governance within the data domain as well as the entire application scope.
• Very strong experience with T - Sql including complex aggregation and analysis across very large datasets. Skilled at troubleshooting and tuning complicated sql issues. Solid understanding of Sql Server management, security, and best practices.
• Extensive experience building robust scalable ETL processes for clients across many diverse industries. Hands on experience engaging clients, stakeholders, and vendors to collaborate on all aspects of data collection, transformation and end reporting needs. Designed and built systems utilizing SSIS and BizTalk as well as custom implementations based on client needs.
• Over a decade of experience utilizing the principles of Agile development in many diverse team environments. Experience with managing both Scrum and Kanban boards with Atlassian, JIRA and TargetProcess. Familiar with several different approaches to scoring, velocity measurement, and sprint planning to maximize team participation and productivity. Experienced building out stories and tasks from requirements and adhering to defined workflow processes.
• Strong experience interfacing and collaborating with all members of a project from stakeholders, users, analysts, and developers. Accustomed to leading an effort to establish principles and practices to ensure project success for all involved. Very experienced at not only mentoring and training but also evangelizing new efforts to improve processes and practices.
• Utilized Angular JS/Angular 2 extensively to build custom directives and components to handle very large data set presentation in a responsive manner.
• Strong experience utilizing multiple versions of EF from beta to EF Core. Including implementations using database-first, model-first as well as code-first migrations.
• Strong background in utilization of XML/XSLT for data integration as well as presentation.Experienced with the standards and use of XML as a B2B integration mechanism utilizing tools such as Biztalk as well as custom implemented integration and mapping tools. Experience with industry standards such as PIP established by RosettaNet consortium.
• Many years of experience building applications in ASP from classic ASP to .NET Core with MVC pattern variations. Experience with multiple asynchronous architectures and RESTful implementations including WCF and WebAPI.
• Experience building and maintaining applications using C# and angular utilizing the MVC pattern.
• Have utilized GIT, Tortoise, TFS and SVN extensively over the years.
• Utilized C# as the language of choice in the last 12 years. Attended Confidential training for C#.
• Over 7 years of extensive knowledge of COM and .NET architecture and practices. Understanding of COM from a C++ perspective as well as in depth knowledge of MTS and implementations of n-tier applications developed in the COM genre. Several years experience developing VB.NET applications utilizing web services as middle tiers to web based applications.
• Several years experience setting up and configuring IIS for ASP as well as ASP.NET applications. Experience includes SSL and DNS configuration.
• 15 years of experience utilizing HTML and script for the presentation and manipulation of content.
• Experience designing and developing enterprise level CF applications for content management. Excellent knowledge on the use and scalability of CF as well as optimization of the templates for reuse and maintenance purposes
• Native language used throughout college. Experience building applications using Visual C++ as well as a basic understanding of the low level aspects of the Component Object Model.
• Excellent understanding of numerous development life cycle models, as well as real world experience utilizing classic development life cycles. Significant experience working directly with clients throughout the entire development process.
• Experience with SQL Server (2005,2008r2,20012-2016) Windows Server 2008-2012, AWS, VMWare, AS400/DB2, and UNI X

EXPERIENCE:

Senior Application Consultant

Confidential

Responsibilities:

• As a member of the KCE team I was involved with several critical components.
• I architected and implemented a custom drop down control utilizing AngularJs directives.
• The directive supports multiple selection, virtual scrolling, and user searching of very large data sets.
• The directive was designed for flexibility allowing developers multiple configurations for optimization of loading and displaying selection options.
• I performed end to end development for multiple features. This included design and layout of the UI templates, implementation of Angular and Rest layer controllers, as well as scripting of the stored procedures. The architecture is implemented utilizing C#, MVC, Web API, AngularJS, and SQL Server stored procedures.
• Performed analysis and tuning of the SQL database. Utilizing several different techniques and tools I analyzed performance and targeted possible solutions. Implementing indexes or script modification as necessary to improve performance of the application.
• Key member of team responsible for analysing financial processing logic to ensure invoicing executed accurately and efficiently. This entailed obtaining a full understanding of the business requirements and then subsequently dissecting the logic built in C# and T-SQL to ensure the accounting system is scalable, speedy, and precise.

Senior Sql Developer

Confidential

Responsibilities:

• As a senior member of the development team I was responsible for quality, security, performance and accessibility of enterprise data.
• Projects include implementation of a new ERP solution including ETL development to support integration of business critical data points from several disparate systems.
• Spearheaded initiative to re-architect internal applications to improve performance, scalability, and data stability.
• Technologies include Sql Server, RavenDB, RabbitMQ, Oracle, .NET, MVC, C#, WCF, and AngularJS.

Senior Consultant Blackfin

Confidential

Responsibilities:

• Worked as lead Data Architect at the Idaho State Department of Education on the nationally recognized State Longitudinal Data System. I along with the lead Application Architect spearheaded the development of the entire system from the ground up. Including design and implementation of the new Data and System Architecture of the SLDS system, while supporting the rewriting and integration of the legacy systems that existed at SDE into the new SLDS system.
• I was responsible for the design and implementation which consisted of a multi stage environment with a 3-node sql server 2008 r2 cluster for production installed on virtual instances of server 2008. With 2 terabytes of storage for the OLTP database and another 2 terabytes and a separate instance to host the OLAP database.
• Data Integration consisted of a 3rd party data collection tool utilized by the 160+ disparate school district system to load data to staging. I designed and built a custom implemented integration tool to perform ETL operations from stage to OLTP and then downstream into the Financial, Reporting, and Assessment analysis engines and ultimately into the OLAP structures for consumption by the end user audiences. The custom tool consisted of a complex set of stored procedures and functions scheduled and managed through a front end .net Application. The tool was self logging and self recovering allowing reloading of data into all structures if failure during processing should occur.

Integration Consultant

Confidential

Responsibilities:

• Analyzed and implemented a ETL solution for Confidential to satisfy there need to integrate Starbucks XML standard into the clients unsupported version of JD Edwards EDI software.
• I assessed the requirements, analyzed and identified the collection, content, as well as the frequency of the data elements.
• I then scoped out a 3rd party integration solution based on the very small budget and very tight timeline.
• I prototyped a solution utilizing an EDI-XML mapping tool called Altova.
• I provided upper management and the IT team necessary documentation and demonstration to gain approval.
• Then subsequently designed and implemented the mapping schemas, developer documentation, team training, as well as support and process and procedure documentation.

Integration Consultant

Confidential

Responsibilities:

• Worked on the Confidential to Sharepoint integration tool.
• Responsible for Building the transformation tool to serialize KPI’s and other BI objects from existing Confidential customers BI suite into SharePoint serialized objects.
• I analyzed, designed and implemented mappings required to deserialize, transform, and serialize into the sharepoint database instance.
• Built a windows service to perform the actual transformation exercise and tested resultant output for each type of object transformed.

Integration Consultant

Confidential

Responsibilities:

• I designed and implemented a suite of complex SSIS packages to perform importing of online order and billing activity related to the sales of licenses by the Confidential and Rec.
• This entailed interfacing a disparate online vendor billing system with a legacy database that already existed at the client.
• Utilizing SSIS I designed, built, tested, and documented a set of SSIS packages that performed file loading, processing of data, importing results into client billing system, and performed end to end validation of resultant transactions.

Senior Consultant

Confidential

Responsibilities:

• Designed and built a custom framework utilizing XML/XSLT for custom configuration and display of resident OLAP marketing data.
• The application architecture consisted of a customized ASP.NET rendering engine, sql server 2005 database, and extensive use of XML/XSD/XSLT for data rendering.
• Built custom database integration and manipulation tool that allowed client to load new data sets at will with schema changes being handled on the fly.

E-commerce consultant

Confidential

Responsibilities:

• Worked in staff augmentation role at Confidential for 6 months on the e-commerce team.
• Responsibilities included design and development of internal system to Import, analyze and track data results for Confidential system scanner.
• As a senior developer on the team I served as a mentor for application architecture, data design, and coding questions. I spearheaded a committee to establish best practices including Data Design, Data Governance, application architecture, coding standards, coding reviews, etc…
• I designed and built a custom data integration suite using VB.NET/XML/XSLT that allowed developers to easily integrate the disparate application's OLTP databases that existed within the organization. This tool provided a mapping, scheduling, and notification mechanism to expedite, improve and standardize data integration.
• I worked closely with the in house developers as well as the vendor of the CRM system to establish database standards and practices.
• With a extremely high volume of data, upwards of 3-5 million call records a day and the subsequent analysis, reporting and retention of this data per federal standards drove a need for a highly available, scalable, and robust system.
• Utilizing a mix of archiving, partitioning, and separate analysis engines I lead the effort to establish proper data retention as well as data processing standards and practices.
• Which enabled the company to comply with federal data regulations and produce timely and accurate billing information for our CSRs as well as to our customers via a web based billing information system.
• I worked with marketing, management, developers, as well as auditors to improve the complicated rating algorithms required to generate billing records from raw mobile call records.
• This consisted of a stack of T-Sql stored procedures and functions to analyze and rate call records based on a limitless number of permutations..
• Lead the implementation of the Logica WAP/MMS/SMS gateway.
• This included installation, testing, and training around the Highly available Unix based system.
• This included implementation of data integration of the call record data associated with the new SMS/MMS call records as well as modification of the integration and analysis engines to accommodate this new data. I also managed the integration of sales data from our external mobile vendors to support marketing promotions, payments, and inventory fulfillment to these 3rd party sales entities.

BizTalk Data Integration Consultant

Confidential

Responsibilities:

• I was responsible for migrating BizTalk orchestrations to BizTalk 2004 to support Confidential 's daily B2B data integration operations.
• This entailed extensive use of XSD/XSLT/XML to build the required mappings based on RosettaNet.org PIP standards. analyzed and implemented new orchestrations utilizing custom pipelines to standardize the transformation, sanitation, and quality checks of the data as it was received into the Confidential data systems .
• Was responsible for mentoring and training offshore development team tasked with taking over the BizTalk 2004 effort at the end of the development cycle.

Senior DBA/Developer

Confidential

Responsibilities:

• Key player in the design and maintenance of the OLTP and OLAP DataBases utilized to support the extensive reporting needs of our clients. Spearheaded efforts to automate setup of new client configuration and installation. In addition I managed the client support department including gathering requirements and implementing new functionality as well as initiating additional sales to existing clients. As a manager and senior staff I also mentor and train new staff members. I performed multiple on site installations of the product and provided training to both the end users as well as IT support staff.
• I completed the COM to .NET migration of my company’s product. The new version of the product is a completely web enabled .NET application.
• Responsible for designing and implementing core objects in the .NET platform. Including building VB.NET web services for business logic and data access layer, and ASP.NET objects for user presentation. Also responsible for setting up and maintaining dozens of client web sites with SSL access.
• Other responsibilities include administration of IIS and SQL server. Including setting up new client sites, management of SSL certificates and DNS administration. Developed software using Visual Studio .Net, VB, XML, XSLT, Crystal Reports and SQL Server.
• Participated in several major projects and was involved in every aspect of application development from gathering requirements to the design and implementation of database structures, application architecture, as well as training of the resident development staff. With a focus on data integration and manipulation I utilized SQL Server 2000, VB6, .NET, COM+, XML, XSLT, UML.
• Project roles included Senior developer for the Drinking Water management system for the State Department of Health. While on the DOH project I was responsible for design and implementation of T-SQL stored procedures utilized to import, transform, track and analyze the vast amounts of water sample data collected by labs at thousands of corresponding water testing sites.
• Lead Analyst/Developer for the design and implementation of a Treasury Management System for the Office of State Treasurer. My duties on this project required extensive and complicated T-Sql stored procedures to manipulate and analyze data for the distributions of moneys to state and local agencies. I was responsible for the development of dozens of middle/data tier components and stored procedures that perform complex calculations for cash management and reporting. This application not only gave employees in depth access to all accounting information, it also automated cash distributions and provided investment forecast calculations. I also worked closely with the executive director of the agency at the end of the project to ensure all deliverables were met in a timely and cost effective manner. The architecture consisted of Visual basic components, DTS packages and SQL Server Jobs. I was also responsible for training/mentoring the resident IT staff in Object Oriented development in a Visual Basic environment, as well as deployment and management of the VB6 Objects in an MTS environment.
• Lead Developer for Forest Products Management tracking system. This project included extensive updating of the companies OLAP Database. Requirements for this project was to produce a fast, reliable, fully customizable, web based data analysis tool that the regional sales directors could utilize from anywhere in the world. This required extensive development of T-SQL stored procedures able to cube up, slice, dice, and further analyze the vast amount of information required for regional sales reporting.
• I also worked on several other projects including wrapping up a critical Visual Basic application for Radiant point of sale system back end and completing the implementation of the RosettaNet.org consortium web site.