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