We provide IT Staff Augmentation Services!

Data Analytics Resume Profile

Summary of Qualifications

One of the most thoroughly experienced .Net developers in the Atlanta area has worked in every major version of the .Net Framework as well as at the highest levels of PL/SQL and TSQL database development. Extensive expertise in Business Intelligence applications, Windows applications, Client/Server applications, SOAP Web Services, Web applications and Enterprise Data Warehouse applications. Always makes valuable contributions to every project, providing expert, seasoned, technical leadership. Highly recommended by peers.

Experience

Confidential

Data Analytics, ETL and Custom SSIS Components

  • Maintained and enhanced ODS and data marts, extracting core data from Teradata EDW and ECDW data warehouses to load proprietary SQL Server databases. Performed ad-hoc and periodic data analytics for measuring and improving effectiveness of company's retention marketing campaigns. Led extensive highly complex ad-hoc and scheduled querying of ODS to attach demographic metrics to correlated core datasets. Heavy daily on-demand usage of TSQL stored procedures, SSIS packages and SSIS custom components.
  • Developed several SSIS custom control flow components that scale to multi-core servers processor core count and improve SSIS package ETL loading speed by up to an order of magnitude. Multi-threaded parallel bulk copy custom components configurable parameters include number of concurrent threads, numerous data sources not available to standard bulk load components and column mapping.
  • Migrated and maintained several highly parameterized SSRS reports to SharePoint.
  • Teradata 13, MS SQL Server 2008 R2, TSQL, CTEs, SSMS SSIS, ADO.Net, OLEDB Visual Studio 2012/2010 C NET 4.0 Teradata SQL Assistant, Excel 2012, Access 2012, SSRS MOSS 2013

Confidential

.NET Contract Developer

WPF Fraud Detection Systems

  • Developed application architecture for company's consolidation of four separate fraud detection systems into one WPF application.
  • Implemented modified MVVM pattern with strongly-typed dataset model using ODAC to access Oracle package functions.
  • Authored several attached behaviors to extend WPF datagrids with added functionality including datagrid filtering, persisting users' datagrid configurations via a context menu, and transposing datagrid rows and columns.
  • Created WPF forms that databind to XML and standard view-models and invented method for binding Silverlight controls to XML, overcoming this limitation of Silverlight.
  • .NET 4.0, WPF 4.0 Silverlight4.0 Visual Studio 2010 C XAML XML Oracle 11g ADO.Net MS Entity Framework 4.1 PL/SQL ODAC Visifire 4.0 Linq to SQL Linq to XML Expression Blend Behaviors

Confidential

.NET Contract Developer

Silverlight OLAP Order Analysis and Reporting Website

  • Architected and authored conversion of company's Access application to a Silverlight/SQL Server application.
  • Converted Access database to SQL Server, Access forms to Silverlight web forms and Access VBA macros to SQL Server stored procedures using Jet2SQL, SSMA and Entity Framework 4.0.
  • .NET 4.0, Silverlight 4.0 Visual Studio 2010 C , XAML SQL Server 2008 R2 ADO.Net TSQL IIS 7 Access VBA RIA Data Services MS Entity Framework 4.0,Linq to SQL MS SQL Server Migration Assistant

Confidential

.NET Contract Developer

Silverlight OLAP Order Analysis and Reporting Website

  • Re-architected company's UVERSE sales order analysis and reporting web app, deepening analytical capabilities, vastly improving application stability and increasing application performance by an order of magnitude.
  • Introduced multi-dimensional analysis with integrated data visualization and chart drill down.
  • Introduced data caching and SQL Server relational data mart cubes for scalability, supported by scheduled automated data loading.
  • Expanded scope from Southeast's 9 states to entire territory of 22 states, changing sourcing from a SE Teradata data warehouse to a national one.

Database Conversion Applications

  • Wrote Jet2SQL, an application for converting Access queries to SQL pass-through queries, crucial for maintaining performance in upgrading from Access to SQL Server.
  • Wrote SMUF, an application for loading and updating SQL Server tables from Excel spreadsheets, with data validation
  • ASP.NET 4.0, Silverlight 4.0 Visual Studio 2010 C , VB.Net, XAML , SQL Server 2008 R2, Teradata 12.0 Visifire 4.0, jQuery, jQuery UI, AJAX 1.0, AJAX controls, Javascript SSRS SSIS ADO.Net, TSQL, IIS 7, SOAP Bing Maps API, Google Maps API, Amazon EC2, Excel VBA, Access VBA

Confidential

.NET Contract Developer

Web Portal and Back Office Applications

  • Rewrote school system's web-based administration system for its After School Programs, updating it from classic VB6/ASP to three-tiered VB.Net/ASP.Net with extensive user-control encapsulations. Introduced new features like Student/Teacher Profile pages, Student Account Statements with running balance calculations and spreadsheet-like data entry grids.
  • Replaced cumbersome cash-receipts batch entry process with custom web-based spreadsheet grid allowing free-form data input with real-time database updates via XmlHttp requests tied to server-based threaded database calls.
  • Created class library DAL of multiple strongly-typed table adapters backed exclusively with over 120 stored procedures. Created class library BLL of multiple application entity classes. Created MSTest-based system testing class library with multiple classes for system regression testing along with web-based front end for on-demand testing across all environments with color-coded lamps indicating test status.
  • Wrote cloud-based logging system for creating consolidated exception logging across all web-farm servers.
  • ASP.NET 3.5 AJAX 1.0 AJAX controls, Telerik controls , JavaScript, jQuery, XML Http SSRS Visual Studio 2008, VB.Net, C , ADO.Net, SQL Server 2005, TSQL, IIS, MSTest, Amazon AWS

Confidential

Lead .NET Developer

Web Portal and Back Office Applications

  • Created extensive dual-language Web Portal in ASP.Net using Telerik and AJAX controls, adding many features including a custom ASP.Net membership provider, geo-coded address validation and numerous SSRS reports with multiple drill-downs, increasing functionality by more than 100 . Built page translation system allowing employees to quickly translate pages into Spanish. Wrote built-in defect tracking system accessible by all users for centralized bug reporting and management.
  • Wrote Windows Forms Client/Server applications supporting data-driven IVR out-calling programs generating a 20 increase in payments.
  • Developed Windows Services and WCF Web Services for XML-based PCI-compliant credit card processing system saving thousands of dollars per month.
  • Developed SSIS packages for moving databases from SQL Server 2000 to 2008 servers resulting in increased performance.
  • ASP.NET 3.5 AJAX 1.0 AJAX controls, Telerik controls, JavaScript Crystal Reports 10, SSRS, SSIS, Visual Studio 2008, VB.Net, C , ADO.Net, WCF, SOAP, XML, BI Development Studio SQL Server 2000, 2005, 2008, TSQL, IIS7

Confidential

.NET Contract Developer

Financial Systems Integration and Reporting

  • Provided technical leadership and development of complex web-based financial SSRS reporting applications for integrating Oracle and SQL Server data using ASP.Net, AJAX, JavaScript, TSQL, PLSQL and SSIS.
  • Developed web-based ETL applications for integrating Oracle and SQL Server-based reinsurance systems using TSQL stored procedures and functions, PL/SQL packages and SQL Loader scripts.
  • Created SSIS packages and ADO-based bulk load applications for fast ETL data loads.
  • Authored web-based interfaces for phased conversion of Oracle databases for correcting long-standing retrocession transformation errors.
  • Provided PLSQL maintenance and Cobol customer data load troubleshooting support for operations department.
  • Developed web-based system to automatically create Visio flowcharts documenting ETL processes from deeply nested DOS batch files, with drill-up and drill-down capabilities.
  • Wrote web-based actuarial survivorship Frasier rate calculator with substandard rate capabilities.
  • Wrote innovative ad-hoc Facultative Underwriting Limits and Coverage Report in SSRS that underwriter described as the best tool he had ever been given to do his job.
  • ASP.NET 2.0, SSRS, SSIS AJAX 1.0 AJAX controls, JavaScript Visual Studio 2005 VB.Net, ADO.Net, BI Development Studio Oracle 10g, PL/SQL, SQL Server 2005, TSQL, Visio.

Confidential

.NET Contract Developer

Compliance Reporting

  • Integrated web-based SSRS reporting into compliance scheduling application.
  • Developed tabular and matrix reports, sub reports in SSRS with custom functions
  • Wrote extensive TSQL stored procedures and functions in support of evolving federal regulation compliance.
  • SSRS, ASP.NET 1.1 2.0 Visual Studio 2003 2005 BI Development Studio, VB.Net, C , ADO.Net SQL Server 7, 2005, TSQL.

Confidential

.NET Expert Developer

Financial Systems Integration

  • Authored web-based ETL apps for budget and forecast data integration and inter-department budget allocation.
  • Created customizable extraction, transformation, and loading applications, configurable via external configuration files, for transforming and moving data between divisional, cross-platform, OLAP and OLTP systems.
  • Used AJAX controls and JavaScript to build richly interactive UI's, and AJAX update panels for real-time status displays across multiple threads.
  • ASP.NET 1.1 2.0 Visual Studio 2003 2005 VB.Net, C , ADO.Net AJAX 1.0 AJAX Controls DHTML DOM JavaScript, VBScript Oracle 9i PL/SQL DDL and DML, XML, Unix Shell Scripting, IIS 5.0/6.0 , Hyperion Essbase OLAP

Employee Systems Integration

  • Wrote major components of company's web-based integration application for synchronizing employee data systems, using loosely-coupled, Java Messaging JMS web-service clients.
  • Wrote a custom IDE COM add-in program generator in VB6 to create inherited base classes for ADO.Net-based data layer including transactions, strongly-typed business object layer and data-type aware presentation layer objects, including N-Unit fixtures and tests.
  • ASP.NET 1.0 1.1 MS Visual Studio 2000 2003 VB.Net, C , ADO.Net Oracle 8 PL-SQL DDL and DML, Stored Procedures, Functions, Packages, Triggers MS SQL Server 2000 T-SQL DDL and DML and DTS JMS 1.1, IIS 5.0, VSS

Hire Now