Senior Application Architect Resume Profile Memphis, TN - Hire IT People

SUMMARY

A Senior Data Warehouse Architect/Data Modeler/Programmer Analyst/Business Intelligence Analyst with 16 years experience in application development, relationald database design/development, data modeling and business intelligence.
Experienced with all phases of the development life-cycle.
Experienced with the translation of business requirements into conceptual, logical and physical data models.
Solid practical knowledge of relational database techniques and data warehousing concepts, design and implementation.
Experienced with business intelligence concepts, design principles, data modeling, process flows and modeling, OLTP, OLAP, ROLAP and predictive analysis.
Proficient with multiple programming languages, databases, and reporting tools.

SKILL

Databases: Oracle, MS SQL Server, Microsoft Access, Lotus Notes, Postgresql, mySQL, Informix
Languages: PL/SQL, Transact-SQL, C .NET, VB.NET, Visual Basic, Assembler, C, C , Visual C , VBA, UNIX/LINUX Shell Scripts, ASP.NET, Java, JSP, JavaScript
Tools: SSIS, DTS, Excel, Toad, CVS, Business Objects, Visio, Subversion, Erwin, PowerPoint, SharePoint, Oracle SQL Developer, Crystal Reports, Brio
Platforms: UNIX, Linux, Windows, Windows CE, Visual Studio 2010, .NET Framework

PROFESSIONAL EXPERIENCE

Confidential

Senior Application Architect

Converted SQL Server applications to Oracle 10G, C .NET, VB.NET and Access.
Created and upgraded SQLLOADER scripts in Unix
Created Windows Services using C .NET and Oracle
Environment: Oracle 11g , MS SQL Server, SSIS, DTS, Transact-SQL, C .NET, VB.NET, WinForms, Access, VBA, XML, Unix

Confidential

Senior Programmer Analyst Contractor

Analyzed, designed, coded, tested and documented software for legacy reservation system.
Environment: C, Informix, Unix

Confidential

IT Specialist Government Contractor

Confidential

Senior Programmer Analyst

Confidential

Senior Programmer Analyst

Environment: C, C , C , Visual Studio, WinForms, MS SQL Server CE, Windows CE, XML, Linux

Confidential

Data Warehouse Architect/Data Modeler/Programmer/Business Intelligence Analyst

Designed and developed a web-based star-schema data warehouse with automatic daily feeds from in-house legacy system.
Designed and developed a custom ETL application for automatic pre-processing of legacy data prior to loading into web-based relational data warehouse.
Took charge of all server-side development issues surrounding metadata, triggers, stored procedures, optimizing SQL code and tuning of databases.
Queried and mined data sets to discover transaction patterns, uncover anomalies and build predictive analysis data models.
Wrote numerous PL/SQL procedures, functions and packages used in various data applications, migrations, import/export processes, and conversions.
Drove automation, improved accuracy and increased efficiency in all reporting and analysis initiatives, including the ongoing evolution of the data warehouse.
Environment: Oracle 9i , Oracle 10g , PL/SQL, Postgresql, C , Visual C , Java, Java Beans, mySQL, Access, Excel, JSP, VB.NET, WinForms, FTP, XML, Linux, VBA

Confidential

Senior Developer Government Contractor

Designed and developed document scanning and retrieval system for US Navy.
Environment: C, C , Java, MS SQL Server, Visual Basic, ASP, WinForms, XML and Linux

Confidential

Lead Developer

Confidential

Developer/Business Analyst

Designed and developed custom quality control application using corporate data warehouse, local database server, WMS system and Symbol PDA scanner.
Implemented automatic daily downloads of corporate data into central local Data Marts.
Designed and developed numerous custom applications for distribution facility.
Taught Excel, Access and SQL classes
Environment: C, Visual C , Visual Basic, Access, WinForms, MS SQL Server, DTS, Transact-SQL

Confidential

Senior Office Support Analyst

Provided senior level technical support for other support analysts.
Performed application development and database maintenance tasks for local corporate services and remote sites, wrote PC applications using BASIX, C, C .
Environment: C, C , Visual C , Unix, FTP, Lotus Notes, Access, Unix shell scripts