We provide IT Staff Augmentation Services!

Application Architect Resume

3.00/5 (Submit Your Rating)

Eden Prairie, MN

TECHNICAL SKILLS:

  • MS SQL Server, NoSQL, Azure SQL, Azure Table Space
  • Hadoop, SSRS, ETL - SSIS and Informatica PowerCenter
  • Salesforce, MySQL, C#.NET, VB.NET, C, C++, Oracle
  • Splunk, ER Studio, ERwin, Informix, Access, ASP.NET
  • JavaScript, Crystal Reports, Perl, LDAP, HTML, UNIX
  • Linux, Windows Server, shell scripting, batch scripting, MS Office, Pivotal Front Office

PROFESSIONAL EXPERIENCE:

Application Architect

Confidential, Eden Prairie, MN

Responsibilities:

  • Performed complete application architecture - Data and Software (SQL, .NET, MVC)
  • Led integration and conversion teams
  • Performed logical and physical Design and Data Modeling
  • Designed and rebuilt existing Views, Stored Procs and Tableau dashboards
  • Completed decommissioning and future state analysis
  • Designed and completed ETL processes in Informatica
  • Completed high level and context documentation
  • Led Salesforce Data design and loading
  • Mentored and led developers, business analysts and testers
  • Performed code reviews

Data Architect (Consultant)

Confidential, Mendota Heights, MN

Responsibilities:

  • Designed and Developed Universal Practice Schema for the dental industry (ER Studio)
  • Led data conversion team
  • Performed logical and physical Data Modeling
  • Designed and developed multiple-entry point Data Conversion system in SSIS and .NET
  • Mentored and led developers and testers
  • Developed import-export utilities.
  • Developed .NET libraries for asynchronous API response processing

Data Architect (Consultant)

Confidential, Minnetonka, MN

Responsibilities:

  • Led incentives team for Health Portal
  • Was in charge of ETL - SSIS development for Oracle databases
  • Designed, developed and maintained PL SQL
  • Mentored and led data analysts
  • Performed extensive data analysis and management
  • Provided defect management and fixes in a fast paced, global team

Senior Data Analyst (Consultant)

Confidential, Saint Paul, MN

Responsibilities:

  • Managed and led reporting team SSRS design and development
  • Led ETL design and development - Informatica and SSIS
  • Designed Oracle architectural changes in ERwin
  • Developed extensive PL SQL
  • Mentored analysts and junior developers
  • Maintained current software
  • Performed database indexing
  • Participated in enterprise software lifecycle
  • Managed TFS code storage
  • Developed custom reports
  • Performed Splunk research and created dashboards
  • Led deployment of new software releases

Senior Data Analyst (Consultant)

Confidential, Minneapolis, MN

Responsibilities:

  • Performed SQL architecture and development with ER Studio
  • Provided analyst support and mentoring
  • Tuned stored procedures for better performance
  • Made .Net design changes and recommendations
  • Developed reporting tools
  • Coordinated fix releases
  • Led Webex sessions for on-site debug and fixes - Tier 3 support

Business Automation Analyst - Data Architect

Confidential, Minneapolis, MN

Responsibilities:

  • Provided Marketing and Sales departments with technical expertise to improve operational effectiveness and efficiency
  • Performed Database design, schema analysis, procedure coding and debugging, automated process discovery
  • Led SSIS package design and development
  • Performed workflow analysis and recommended quality improvements
  • Participated in project management and leadership in the development of new SSIS and other SQL applications and the enhancement and maintenance of existing ones
  • Worked on requirements gathering and analysis, application design, coding and testing, application distribution and installation, database administration
  • Designed, developed, and maintained .Net web services
  • Administered processes within software development projects, including software change control, end-user application validation and problem management
  • Made recommendations to Manager of Marketing and Sales Systems regarding the acquisition and/or implementation of software to increase process efficiency
  • Was in charge of SQL Reporting Services, and its migration to the latest (2008) platform

Senior Software Developer

Confidential, San Diego, CA

Responsibilities:

  • Developed commercial web products using C#, ASP.NET, MS-SQL, and Oracle technologies
  • Performed SQL DBA duties, including maintenance, design, stored procedures, triggers, Informatica and DTS procedures
  • Completed database design alterations with ERwin
  • Provided direct support and communication to the clients
  • Worked as part of a development team, which was responsible for the design and coding
  • Provided test cases for automated and manual testing
  • Worked directly with the QA and BA teams to debug and analyze problems

Senior Software Engineer (Consultant)

Confidential, San Diego, CA

Responsibilities:

  • Developed large commercial web farm applications using Microsoft SQL, VB.NET, C#, ASP.NET technologies
  • Coordinated with development team and operations support to troubleshoot development environment, production environment, performance tune, optimize database and code
  • Internet reports
  • Actively wrote code and conducted unit testing
  • Communicated with the QA team to carry out tests and verify problem resolutions
  • Participated in database design
  • Developed stored procedures and triggers

Senior Data Analyst (Consultant)

Confidential, San Diego, CA

Responsibilities:

  • Developed reporting intranet sites using ASP.NET
  • Was responsible for database design
  • Performed major database translations, imports, and exports utilizing DTS, stored procedures, VB.NET and Perl
  • Analyzed data flow and made proposals to streamline the process
  • Database Optimization

Senior Programmer/Analyst (Consultant)

Confidential, San Diego, CA

Responsibilities:

  • Project planning and coordination
  • Maintained and developed Email Services/Directory Software utilizing Java/Perl/Ldap
  • Was responsible for architecture and design of email flow
  • Designed, programmed and maintained reports
  • In-house tools programming utilizing C/Perl as well as C#/VB.Net/SQL
  • Messaging programming and support

Senior Programmer/Analyst (Consultant)

Confidential, San Diego, CA

Responsibilities:

  • Team Lead for project coordination
  • Worked on Acuity Accounting System implementation
  • Completed an export interface with archive and report utilities using Microsoft SQL Server and Visual Basic.Net
  • Converted VB COM objects to VB.Net and ASP.Net (Beta .Net)

Senior Programmer/Analyst (Consultant)

Confidential, San Diego, CA

Responsibilities:

  • Worked on multi-tier client-server student loan management system
  • Led team to successful integration of third-party software
  • Implemented Microsoft SQL Server stored procedures and triggers for the Web-backend
  • Designed ASP pages for the Intranet front-end module using Visual InterDev
  • Developed various database applications with sophisticated GUI using Java/JavaScript
  • Performed Access programming and maintenance for legacy systems

Senior Programmer/Analyst

Confidential, San Diego, CA

Responsibilities:

  • Team Leader for a 4 member team designing and developing Payroll and Finance systems
  • Integrated core User Interface elements, developed Informix-based database and implements triggers and stored procedures utilizing Informix
  • Designed and implemented Human resources and payroll modules into Informix and SQL server database using Visual Basic 6.0/AWK/SQL scripting/and k shell scripting
  • Implemented, rolled out and administered system implementation, analysis, security as well as in-house and on-site software support

Programmer/Analyst

Confidential, San Diego, CA

Responsibilities:

  • Member of a ten-person development team working code for a financial software system
  • Provided maintenance, reports and optimization of an Informix, SQL server database using Visual Basic 6.0/VB script/shell scripting and SQL scripting
  • Customized financial application interfaces using Visual Basic 6.0/VB script/shell scripting and SQL scripting
  • Developed and implemented stored procedures, triggers, tables and screens in the creation of Informix database using Informix 4GL

Computer Programmer

Confidential, Minneapolis, MN

Responsibilities:

  • Webmaster for MusicLand.com, maintained and upgraded the website using Visual Basic, CGI, VI and HTML on an NT platform
  • Developed and implemented SQL/ESQL queries, embedded SQL and related conversions
  • Designed UNIX shell scripts and Web site development
  • Developed and implemented warehouse software development writing code to run machinery and updating the database using Informix 4GL and C in a UNIX environment

Programmer

Confidential, Minneapolis, MN

Responsibilities:

  • Performed debugging, enhancing, change operations, and maintenance jobs in Microsoft Windows 95 and UNIX environments
  • Created and maintained an employee database in VB/Access utilizing DAO functions

We'd love your feedback!