Edw Architect Resume
Austin, TX
SUMMARY:
- I have been designing, building, and managing the development efforts of large scale commercial systems since the 1990s, having successfully completed banking, health care, energy, governmental, insurance, and manufacturing/engineering systems. business management, as well as technical disciplines such as Data Warehousing, SOA, and multi - tier architectures.
- Over the past 10 years I was the lead architect on two enterprise level projects that lasted about 5 years each. Due to limited budgets we could not hire several architectural specialists, and I had to serve as data architect, soa architect, database administrator, Scrum/Agile project manager, lead business analyst, release coordinator, quality control manager as well as lead developer and information security architect. better able to see-the-big-picture, therefore be more effective in whatever is the specific job assignment:
- Data Architect, Data Modeler, SOA Architect, Security Architect, Web-UX Architect, Project Manager, … r of course I can function as the lead architect overseeing an entire project.
TECHNICAL SKILLS:
GUI: .Net Custom Web Application Server, MVC4-6, ASP.Net, Java Swing, HTML, Javascript, jQuery, ajax, Ms Reporting Services, Delphi, Powerbuilder, et al.
Security: Privacy: TLS / Public Key Infrastructure / JWT, Authentication / Single Sign-on, Authorization, Consistency/Reliability: Tamper attack mitigation, Replay attack mitigation, Denial of service attack mitigation, Non-repudiation, Least privileged accounts, OWASP, PCI, FIPS 140.2, HIPAA, Expose data on need-to-know role basis
RDBMS: MS SqlServer, Oracle, Sybase, PostGresSQL, MySql, et al. MongoDB (noSql)
Operating Systems: Windows/WindowsServer, Azure Cloud, UNIX, LINUX, HP/UX, SunOS, Solaris, Netware, OS/MVS, et al.
MiddleWare: OWIN, WebApi2, WCF, Java EE, Bea WebLogic, Tomcat, TCP/IP, JDBC, IIS, Apache, javax.servlet.*, EJB, LDAP, XML, CORBA, ODBC, ONC RPC, Sybase Client Library, et al.
Data Warehousing / Business Intelligence: Sql Server: Integration Services, Analysis Services, Reporting Services
Data Modeling: ERWin, Er/Studio, S-Designer, Provision, LBMS, DbWrench
Programming Languages: C, C++, C#, Java, SQL, Ms Dts, Visual Basic, et al.
PROFESSIONAL EXPERIENCE:
Confidential, Austin, TX
EDW Architect
Responsibilities:
- Servicing as the Data Warehouse Architect for the Enterprise Data Warehouse (EDW) initiative; EDW is one of the 5 top projects for the TWC state agency.
- Designed and implemented multi-tier data architecture
- Developed highly advanced and fully flexible software architecture to forward-engineer the entire data model for the four tiers: Staging, Raw Vault, Data Vault, Biz Vault.
- Designed and developed ETL software architecture suitable for daily runs of 5+ TB/day.
- Technologies:
- Oracle 12c
- C#/.NET / System.SqlBulkCopy
- Data Vault 2.0 - Dan Lindstedt and Michael Olschimke
Confidential, Sparks, NV
Chief Technology Officer
Responsibilities:
- On sabbatical to integrate, re-write, refine, and copyright several architectures I’ve developed over the past several years which will of course benefit whatever will be my next project engagement:
- REST-MicroService: OWIN / WebApi / JWT Architecture
- PKI / JWT Security Architecture
- JQuery / Ajax / SqlServer WebSite Architecture
- Data Warehouse Architecture
- Azure Cloud Architecture
- Implemented in for Lifeline Outreach International Ministry, a 501c3 public charity.
- Therefore, in the next project we can use my architecture, or adapt these highly successful technical concepts and methodologies into an existing architecture.
Technologies: SqlServer, SSMS, T-SQL, C#, OWIN, WebApi2, REST, JWT, Public Key Infrastructure, JQuery, AJAX, XML, TFS, Microsoft Azure and others.
Confidential, Portland, OR
Senior Data Warehouse SOA Architect
Responsibilities:
- Serving as the lead data architect responsible for massive software development project, engaging 70+ technologists.
- Serving as the lead technologist to retro fit the entire system to Micro Service Architecture; including fully automated API TESTING.
Technologies:SqlServer, SSMS, SSIS, T-SQL, C#, OWIN, WebApi2, REST, JWT, Public Key Infrastructure, JQuery, AJAX, XML, TFS, Subversion, and others.
Confidential, Carson City, NV
Senior Data Warehouse SOA Architect
Responsibilities:
- Served as the lead technologist and project manager responsible for all aspects of the development of the state-wide data warehouse for the Mental Health and Developmental Services Agency.
- Established entire development infrastructure.
- Established scrum/agile project management methodology.
- Established extensible and fully scale-able enterprise data warehouse.
- Established web site security in compliance with HIPAA Health Insurance Portability and Accountability Act of 1996.
Technologies: SSIS, Dimensional Modeling, MVC4, SSAS, SSRS, SOA, SqlServer, SSMS, GOF Design Patterns, XML, SQL, TFS, C#, Asp.Net.
Confidential, Detroit, Michigan
Senior Application Architect
Responsibilities:
- Served as the lead data architect in resolving a formidable and highly complex set of road blocks within the enterprise data model relating to the integration of security with the government geographic hierarchy and user defined customer hierarchies.
- Worked with the Confidential WCF architect in establishing both the TFS development infrastructure and a fully functioning MVC3/WCF/SqlServer prototype application which includes security, globalization, exception handling, trace logging, et al.
- Established the scrum team.
Technologies: SOA, MVC3, WCF, SqlServer, GOF Design Patterns, XML, SQL, TFS, C#.
Confidential, Wixom, Michigan,
Chief Architect & Director
Responsibilities:
- Using Agile Software Development to achieve maximum efficiency and Gang-of-Four design patterns to attain optimal design, served as principal manager and architect of the effort to build and establish an enterprise-level system for a Financial Services firm, being directly responsible for the data model, middle tier architecture, user interface, UML designs, construction, testing, and project management.
Technologies: SOA, .NET, ASP.Net, Silverlight, GOF Design Patterns, Ms SqlServer, XML, SQL, C#, Ms Reporting Services, Windows Server 2003.
Confidential, Detroit, Michigan
Systems Analyst
Responsibilities:
- Using Hadden/Kelly methodology and under the direction of Earl Hadden himself, designed and implemented an enterprise wide data warehouse for a full service insurance firm, which transformed and consolidated unstructured and essentially inaccessible information from several mainframe systems into a structured and easily comprehendible database. This data warehouse provides statistical and adhoc reporting in virtually any format, which is relied upon by senior management and actuaries to direct future business and marketing strategies.
- Served as senior business analyst and technical architect for a global marketing firm; established use cases, and designed use case realizations, logical and physical data models.
- Serving as technical architect, designing the project planning system and enterprise data warehouse for a health insurance provider.
Technologies: ASP.NET, Ms SqlServer, Provision, XML, SQL, Visual Basic, C#, HTML, Windows2000 Server.
Confidential, Troy, Michigan
Chief Data Architect and
Responsibilities:
- Designed and developed a J2EE development architecture, a highly generic software module which encapsulates functionality of both the middle tier and database tier, thereby relieving application developers from all middle tier and database programming.Designed the database for an automotive warranty tracking system. The design is now under consideration to be used by all operational divisions with the corporation.
- Designed the database for the system that controls the project management for an automotive engineering operation and developed a prototype Java architecture for interfacing middle tier objects to the database tier using JDBC.
Technologies:ERWin, Provision, Oracle, Ms SqlServer, PostGresSQL Bea WebLogic, Tomcat, TCP/IP, JDBC, javax.servlet.*, J2EE, EJB, CORBA, LDAP, ODBC
Confidential, Troy, Michigan
Project Manager
Responsibilities:
- Responsible for developing the primary corporate strategy to integrate client/server, WWW, e-commerce, and mainframe technologies for the Detroit region of Norrell, focusing upon the entire system development life cycle of large scale, mission critical web applications that are secure, scalable, fault tolerant, and extendible.Completed multiple system development projects with the State of Michigan Treasury Department. The architectural platform integrates Delphi 4.0, WindowsNT, and Sybase, using a fully UML Object design methodology.
- Previously completed a three tier system development effort with a major natural gas energy firm involving 100+ system professionals. The project budget is $17 million for phase one. The system integrates PowerBuilder/PowerTool, ONC RPC, and Sybase.
- Previously assigned to 3PM/McKesson where I managed the system development effort to integrate PowerBuilder, Microsoft SQL-Server, and WindowsNT for a client-server based retail pharmacy system. The project engaged 30 analysts and technicians. Estimated software value is $2.5 million. The system is being implemented at 2500 sites.
Technologies: ERWin, Provision, S-Designer, LBMS, Oracle, Ms SqlServer, Sybase
Confidential, Southfield, Michigan
Vice President
Responsibilities:
- Developed a comprehensive corporate plan defining virtually every aspect of a system development organization, including administrative, regulatory, and technical concerns.Created a 4GL system development environment integrating a screen manager with a relational join engine. The environment allows the creation of character-based screen applications without writing program code.
- Instituted systems and procedures to dramatically improve overall client support.
Technologies: PICK Basic, PICK, C, SQL, MsDos.
Confidential, Auburn Hills, Michigan
System Analysis Manager
Responsibilities:
- The WorldWorks banking system was developed during my tenure at WCC. During the first half of the project, I served as System Analysis Manager and was directly responsible for business requirements and design specifications. I was promoted to System Programming and Database Manager when the focus shifted to program development during the second half of the project. The research and development effort consisted of 45-60 individuals over a two year period. Estimated software value is $4.5 million.
Technologies: Sybase, TCP/IP, Sybase Client Library, C, SQL, SunOS UNIX, Netware, MsDos
Confidential, Auburn Hills, Michigan
Mortgage System Administrator, Conversion Manager
Responsibilities:
- Coordinated the conversion of $1.3 billion mortgage assets and the three major systems utilized by the Real Estate Loan Department. After conversion, I was responsible for supporting and developing these as well as several auxiliary systems. My department was responsible for business requirements, technical design, data administration/modeling, programming, testing, and system evaluation as well as user workflows and procedures.
Technologies: Btrieve, Nixdorf LMIS, Information, Revelation, C, SQL, Visual Basic, Netware OS/MVS, MsDos
