PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Technical Skills Used: SQL Server 2008 R2, SQL Server 2012, SSIS 2008 R2, SSIS 2012, SSAS 2008 R2, SSAS 2012 Multi - Dimensional and Tabular

ETL Consultant

Responsibilities:

• Developed and deployed the consolidated user management information from PeopleSoft ERP system to the Nuclear Learning Management system using SSIS 2012 and T-SQL. Integrated with the vendor’s learning management system to facilitate the activating and de-activating of employees for certification and qualifications of various craft and professional services personnel during critical plant outages and operations for compliance.
• Developed and deployed merger related supply chain assets and entities to the consolidated nuclear operational data store for QC inspection and inventory reporting using SSIS 2012, T-SQL 2012, and SSAS 2012 tabular database for data analysis.
• Developed and deployed ETL application to transfer nuclear work order and work order accounting information to the corporate ERP system general ledger using Informatica Power Center 9.x

Confidential, Charlotte, NC

Technical Skills Used: SQL Server 2008 R2, SQL Server 2012, SSIS 2008 R2, SSIS 2012, SSAS 2008 R2, SSRS 2008. Tableau 8, SAP BW

Sr DW/BI Analyst

Responsibilities:

• Designed and implemented data warehouse business processes for the Company budget and forecasting.
• Designed and implemented the business process model for doing customer surveys and Retailer inventory surveys to provide analysis on shelving and stocking arrangement of the Coke products in each store.
• Implemented the ETL process for Coke truck delivery route execution to monitor the efficiency of the delivery routes within the Coke system. This analysis was compared to the Delivery route planning to facilitate route planning for new customers within the same branch.
• Developed a dashboard in Tableau 8 to provide the front end analysis of the Delivery Route execution and planning comparison metrics
• Developed the ETL process for orders and invoicing for sales for line item invoicing and orders
• Developed the ETL process for daily actuals sales from the mainframe based on product, branch, retailer, and delivery point
• Developed the EDW extracts for Budgeting and Forecasting to be delivered to our SAP ERP system.

Confidential, Charlotte, NC

Technical Skills Used: SQL Server 2000, 2005, and 2008, SQL 2000 DTS, SQL 2005, 2008, and 2012 SSIS, Analysis Services 2005 and 2008 with MDX, SQL Reporting Services 2005 and 2008, .NET Framework 2.0 and 3.5, C# 2.0 and 3.0. Sharepoint 2007/2010. Performance Point Server, ASP.NET 2.0 and 3.0. AJAX, JQuery, JSON. WCF, WPF, Windows Workflow Foundation, ADO Entity Framework, LINQ to SQL, LINQ to XML, Infragisitcs controls. Javascript., Microsoft Virtual Server, Windows 2003 and Windows 2008 servers.

Data Architect

Responsibilities:

• Created an Operational Data Store (ODS) based on the high level entities of Confidential USA business functions that consolidated these entities from 2 ERP systems and one CRM system and ActiveDirectory as a central point of enterprise application data and enterprise reporting. Developed and deployed all ETL packages and ETL monitoring/validation to support loading the ODS.
• Implemented SQL Server 2012 database availability groups for clustering/failover and disaster recovery of critical enterprise applications.
• Worked with EA council to come up with the content types for the EA process
• Helped to develop a Meta model for business architecture as it relates to information modeling and architecture for current architecture.
• Work with IT development staff to develop a meta model for the IT landscape as it relates to data architecture for current state.
• Help to develop a change process for information architecture and data architecture to a specified agreed upon target architecture.
• Worked to document all data and system catalogs, matrices, and interfaces to show relationships between the information/data to the entire application portfolio.
• Documented all system integrations between application portfolio and information models.
• Developed an MDM strategy for consolidating JD Edwards business entities such as vendors, employees, jobs, and GL chart of accounts to a single master data repository.

Sr. Database Developer/Administrator

Confidential

Responsibilities:

• Performed the dimension modeling (Kimball Methodology), data dictionary and metadata store, and ETL pipeline process automation and monitoring in support of an Executive dashboard project which provide financials, quality assurance monitoring and key performance indicators, safety monitoring and key performance indicators, and human resource measures.
• Helped to develop SharePoint web parts for Executive dashboard projects using C# 3.0, SharePoint 2007, and ASP.NET 3.0.
• Developed and deployed a Subcontractor Sharepoint workflow for Confidential and subcontractor agreements using Sharepoint 2007, ASP.NET, and C# 3.0.
• Developed nightly automated scripts for all SQL Server backups, Log file maintenance, and index defragmentation and maintenance.

Confidential, Charlotte, NC

Technical Skills Used: SQL Server 2005 and SQL Server 2008, SQL Server Integration Services (SSIS) 2005 and 2008, SQL Server Analysis Services (SSAS) 2005 and 2008 (Kimball Methodlogy), Microstrategy, Hyperion Essbase, ProClarity Analytics Server, C# 2.0 with .NET Framework 2.0 and 3.0, C# 3.0 with .NET Framework 3.5, PVCS Source code Repository, Visio for developing logical ERDs, Metadata capture and management, Infragistics controls, Window Communication Foundation, Windows Workflow Foundation, LINQ, ADO Entity Framework.

Sr. BI / DW Developer

Responsibilities:

• Designed and developed the ETL process for pulling Call Center information from a PBX loaded data source into the enterprise data warehouse (EDW) to relate to call center associates to leads that were generated from the Confidential web site.
• Designed and developed and integrated custom built rules engine using SQL Server 2008 C# scripting engine as transformation into the ETL system that dynamically applies rules to the calculation of account manager bonus and commission. Also did a proof of concept with ILog rules engine and BizTalk rules engine development with C# with end users supplying rules up from a sharepoint portal site
• Designed and developed a data model, ETL subsystem, and on-line analytical processing cube for all of the MLS listings on the RealEstate.com web site based on a snapshot of the data by day. Produced the technical design artifacts, metadata, and ETL monitoring system to support the cube.

Confidential, Charlotte, NC

Technical Skills Used: C# 2.0 with .NET Framework 2.0 and 3.0, SQL Server 2005 using Service Broker, Reporting Services, and Analysis Services. Windows Workflow Foundation (WF) and Windows Communication Foundation (WCF) for server processes. Smart Client Software factory and Guidance packages. Team Foundation Server for source code repository, defect management, and requirements gathering.. Visio for developing logical ERD diagrams and UML diagrams for a share application development library. Infragistics controls for presentation and Windows Presentation Framework (WPF).

Sr. Software Engineer

Responsibilities:

• Developed a messaging framework using WF and WCF for sending messages throughout a client enterprise. Messages were signed, encrypted, and compressed to ensure security and low transport payload.
• Used WF to develop rules defined at the corporate level that determined based on a series of events, which data points would trigger a data synchronization between corporate and entity stores.
• Created the self-hosting services for all of the messaging that would be used by the back office application.
• Helped to create business modules using the Microsoft Composite Application Block (CAB) and Smart Client Software factory (SCSF) for the main shell application for the back office application.
• Worked with SQL Server Integration Services (SSIS) to create ETLs to load new dimension and fact tables to an existing Operational Data Store for new modules added to support Time and Attendance features and Enterprise HR activity

Confidential, Charlotte, NC

Technical Skills Used: C# 2.0 with .NET framework 2.0 and 3.0 using ASP.NET 2.0 with AJAX and JSON, SQL Service 2005 OLAP server with Analysis Services, SQL Server 2005 Integration Services for Extraction, Transform, and Load (ETL) nightly processes, Oracle 9i and Oracle 10g, .NET Framework 3.0 Windows Communication Foundation (WCF) for service oriented architecture, .NET Framework 3.0 Windows Workflow Foundation (WF) for human workflow and system workflow applications, Business Objects Universe XI, nANT-MSBUILD for automated build and deployment.

International Business Intelligence Architect

Responsibilities:

• Performed all logical and physical dimensional modeling for the ODS/Data warehouse. Participated in the gathering of requirements with business and operational staff to determine metrics and facts to be captured.
• Used SQL Server SSIS as the ETL tool to pull data from 10 different heterogeneous data sources which included PeopleSoft, Active Directory, and other OLTP systems.
• Designed and administered ETL process for failures/warnings, and performance counters into a dashboard visible through an ASP.NET 2.0 web application. The application had the ability to kick off specific tasks within the entire ETL process.
• Worked with Data Analyst to document and create a data dictionary for Business Object report writers and business users.
• Used SQL Server Analysis services to define the key performance indicators in the reporting instance. Also worked with business users to use Office and Infopath to create ad-hoc reports on any given instance.
• Designed and implemented security and authorization ODS.
• Wrote custom ETL processes to be used as Enterprise Application Integration (EAI) that would transform the data based on rules defined in rules engine repositories using YASU Technologies and Windows Workflow Foundation Rules engine technologies.

International Technical Architect

Confidential

Responsibilities:

• Designed and implemented a smart client application using C# 3.0 that re-engineered a classis ASP application that was used for processing treaty statements for premiums, claims, commissions and retrocession for Confidential international division.
• Used the Microsoft Smart Client Software factory to develop a rich front end user application that connected with WCF services exposed on a enterprise service bus. Used WF for human and system workflows of statement processing of claims and premiums to update the ledger to reflect financials of International treaty processes.
• Developed a PL/SQL package to process month end accruals and deferred acquisition costs for all international treaties to measure division financial metrics. Using Sql Server Integration services (SSIS), these metrics and calculations were posted to the division’s operational data store for business intelligence reporting.
• Developed international business rules using YASU technologies QuickRules.Net for evaluating each statement based on risk factors, actuarial calculations, and retrocession exposure that was incorporated as a WCF service and exposed on the enterprise service bus.
• Developed an enterprise application authentication and authorization system that provides access to international applications. Application owners had the ability to add active directory users to their applications and map roles and privileges to a particular user. This application was creating in response to a Sorbanes-Oxley (SOX) audit. Auditing and logging of all activity is captured and loaded into the operational data store for reporting and trending.

Confidential, Charlotte, NC

Technical Skills Used: Visual Studio 2005 .NET Framework 2.0 and 3.0, SQL Server 2005, TeraData on OS390, Oracle 10g, .NET web services, Windows Communication Framework (WCF), ASP.NET 2.0 ASP.NET AJAX, SQL Server 2005 SSIS, Informatica Power Center, Microsoft Enterprise Library 2.0 using Data Layer, Caching Block, Security Block, and Logging Block. Microsoft Smart Client Factory using Composite Application Block, Microsoft Web Service Factory, Microsoft SQL Server Reporting Services, nANT-MSBUILD for automated build and deploy, Java Spring framework, Java Tiles, J2EE with Hibernate and NHibernate for domain objects

Technical Architect

Responsibilities:

• Saved about 25% of total cost of ownership (TCO) by using an existing TeraData environment for the main operational data store and SQL Server 2005 as divisional data marts using SQL Server 2005 SSIS ETL tools in lieu of Oracle on a UNIX platform using Informatica ETL tools for the entire solution.
• Designed the entire Business Intelligence topology from logical to physical which included the procurement of new servers with back-up methodology, co-location, SAN storage requirements, environments (dev, SIT, UAT, Prod, Contingency). Also consulted in the setup/configuration of web farm load balancers co-located between TX and VA using F5 Big-IP Global Traffic controllers 3DNS technology for multiple name resolution for SOA services in multiple environments (DEV, TEST, SIT, UAT, and Production)
• Developed an OLTP workflow application using Microsoft .NET 2.0 CAB framework and Smart Client Software Factory with C# 3.0 for associate tracking metrics for banking centers, vault imaging, doc and loan administration activities, and servicing. Application uses “Click-Once” technology and is deployed from a web server and installed on the local machine. It makes calls to other systems and the database through the CST SOA using web services for authorization and application entitlements and agents from other source systems. Allows workflow modules to be developed, tested, and deployed separately based on authorization without re-deployment or testing of the main Shell application. Used Infragistics Controls on the presentation layer to support stylesheets and application themes. SOA was implemented using .NET 3.0 WebServices Software Factory with Windows Communication Framework for database updates and inserts and ASMX implementation to other systems such as authorization/entitlements and file and imaging repository (FileNET).
• Developed an ASP.NET 2.0 web application using C# 3.0 for security point of contacts within the GCIB Credit systems division that would approve new users being added to any CST applications and the requested entitlements. This system exposes web services and uses SQL Server Service Broker for asynchronous notification of SPOC approvals.
• Implemented WSRP objects for J2EE portal web applications to create requests for application user access and customer account research request over .NET Webservices to the OLTP systems for queuing of external customer requests about account or loan information.

Confidential, Charlotte, NC

Technical Skills Used: Visual C# 1.0/2.0, Visual Studio .NET versions 1.0/1.1, ASP.NET 1.0/1.1, .NET Framework 1.0/1.1, SQL Server 2000 stored procedures/triggers/user-defined functions in T-SQL, Oracle 8i/9i stored procedures/packages/user-defined functions in PL-SQL. .NET Remoting, .NET Enterprise Services, MSMQ, ADO.NET 1.0/1.1, .NET XML and Web Services, .NET Windows Services and Service Oriented Architecture (SOA). C# and VB.NET design patterns including Singletons / Factory/ Façade/ Adapter, Borland Delphi scripting, .NET Code Generation using Reflection and CodeDOM in Visual Studio.NET, and BizTalk 2004 using .NET 1.1.

Development Technical Lead

Responsibilities:

• Developed a common data access layer component to access both SQL Server and Oracle data stores from any .NET application that uses a configuration file setting to specify the target database engine and catalogs. Used reflection to dynamically instantiate classes based on the settings in the configuration file which allows a consumer of the class to code generic commands against either data source or data source type.
• Created a class library that used inheritance to intercept the Authenticate Request and Application Error delegates of an ASP.NET application to provide generic principles from ActiveDirectory for authentication and authorization from roles maintained in a database. Application Error delegate intercepts any error that occurs in the application and displays and error page and logs an error to the database and creates an incident inside of our UniCenter Service Desk application. This class library was hosted by a processing server where client applications interfaced through remoting over HTTP.
• Architected and developed a CRM application using ASP.NET, SQL Server, Enterprise Services, MSMQ, and Enterprise Services that was used by our Vendor Approval department to maintain contact, status, and licensing information of all Brokers/Originators, Appraisers, Closing Attorneys, and Title Insurance companies to improve our loan origination process. Each vendor had its own application using ASP and MS Access. Consolidated all vendor data and logic and created a new interface with the Loan Origination system to flag the status of a vendor before the loan closes/funds with transactions through Enterprise Services and MSMQ for Underwriter notification when vendor’s status or license information changed.
• Architected and developed a CRM application using ASP.NET, SQL Server, SQL Server Analysis services for our Secondary department for pooling loans for investors based on the Credit, Equity, and Income characteristics of the loan. Used Analysis Services to scrub data for Investor pools based on these characteristics and provided views to Sales, Operations, Accounting, Servicing, and Quality Assurance. Used MSMQ to provide import files for the Servicing, Accounting, and Quality Assurance third-party applications.
• Developed the export process from Confidential ’s on-line Pre-Qualification system to the main Loan Origination system using .NET Remoting, XML, XML schemas, .NET Web Services, .NET Enterprise Services for transaction support and messaging through MSMQ, and BizTalk Server 2004. Also developed the pipeline reports to support this flow and on-demand access to the loans in the loan cycle against both SQL Server 2000 and Oracle 9i.
• Designed and developed a MISMO Credit parser using .NET remoting and enterprise services that parsed a MISMO XML Credit file and evaluated credit scores, mortgage pay history, bankruptcies/foreclosures, and current tradelines to be used with underwriting guidelines of Confidential ’s on-line Pre-Qualification application.
• Designed and developed a MISMO Desktop Underwriter (DU) parser that we parse a Mortgage Loan Application (1003 document) from any originator’s point of sale system and load it into the on-line Pre-Qualification system for export and reporting into our main Loan Origination system against both SQL Server 2000 and Oracle 9i..

Confidential, Columbia, SC

Technical Skills Used: Visual Basic 6.0 COM/DCOM, ActiveX Controls Automation, XML, Win32API, Crystal Reports Version 8.0

Senior Application Developer

Responsibilities:

• Gained experience developing a client-server application using Visual Basic 6.0 deployed to an OS/2 server using SoftwareAG’s EntireX Broker API to commit data to an OS/390 mainframe using SoftwareAG’s ADABASE database server.
• Responsibility included developing and deploying ActiveX controls (.OCXs) and ActiveX DLLs that the Win32 client application uses for graphical interface and business logic. Developed all of the components for data messaging and exception handling that directly connected to the Natural programs and objects through EntireX broker API.
• Worked as the Visual SourceSafe administrator for version control of all of the Visual Basic projects and components. Developed Visual Basic scripts that would pull all of the latest projects and components together for deployment to all of the servers throughout the state when new version roll-outs were needed.
• Developed application security through messaging with the EntireX broker components and Natural programming modules and objects using CONSTRUCT and PREDICT.
• Used InstallShield to develop the images for installing the application on new computers throughout the state.
• Developed the COM component stubs that will handle all of the data messaging to the mainframe for the next version that uses XML via the EntireX XML wrapper and Microsoft XML DOM interface.

Confidential, Charlotte, NC

Technical Skills used: ASP with JavaScript client-side/VB Script server-side, SQL Server 7.0/2000 stored procedures, triggers, and user-defined functions with T-SQL. SQL Server 2000 DTS Packages for Job Scheduling, Business Intelligence Reports using Crystal Reports, and Mercator 5.0 as an ETL tool.

Developer

Responsibilities:

• Gained experience with Mercator 5.0 ETL application, XML (XML DOM, XML schemas, XSLT), COM+/MTS applications, SQL Server 2000 stored procedures/triggers/DTS
• Developed FTP scripts to download text stream files from a securities data license FTP site with Bloomberg to a local department distributed database
• Performed transformation of data and applied business logic to populate an index table for distribution of data to client applications that were used for trading securities and the accounting systems for the securities using Mercator 5.0 adapters
• Developed an ASP application to track the progress of scheduled data transformation from the Bloomberg FTP site to the distributed database, and out to the client applications
• Developed an ASP application using COM DLLs and SQL stored procedures with another developer for an application and would reconcile differences in Holdings accounts with the trust system (outages) and provide override functions for end-of-day financial transactions and Holdings