Recruited to support business goals and objectives by leveraging advanced skills in database architecture, data modeling, Power BI, SSAS, Tabular, Microsoft .Net, SSIS, SSRS, Oracle, ER/Studio, big-data, warehousing, data marts, analytics, ETL, Azure, data lakes, star schema, visualization, outcomes-based design, reporting pivots, data architecture, and query tuning. Key projects in role include: • Consolidated Trade Reporting – Managed revision of data warehouse with financial, transactional and physical data marts. Overhauled decision support systems to assist business centers with daily profit, financial planning, finance, accounting, risk management, marks and pricing, and wholesale operations. • Iso-Physical – Provided decision support through the implementation of a new system displaying energy delivery data, and on-energy fees with intricate and complex methodologies critical to the corporation. New system delivered day over day snapshots and facilitated trend analysis, GL entry, daily profit statements, overrides, and estimates. • PJM Bill – Analyzed billed vs. actual reports from vendors and created disparate datasets. Integrated data into financial reporting for bill reconciliation, bill consolidation, and invoice generation. • ETL, MDM, DQ – Developed processes to integrate data from Oracle, SQL Server, Excel, CSV, XML to create numerous decision support systems, support analytics, and predictive systems.

Recruited to lead solutions architecture, data architecture, warehouses, ETL, and advanced reporting. Leveraged skills in data modeling, ETL, SQL Svr, data profiling, SSIS, SSAS, SQL AMO, .Net, Netezza, and identity-based access management. Key projects in role include:• Decision Support System - Designed a hosted DSS containing data warehouse with several data marts, cubes, and reports. • SSAS On-Demand – Developed an on-demand SSAS cube generation for client sites that included 20,000 cubes generated monthly to replace legacy excel reports

Conducted data architecture, transactional and reporting database design, warehousing, ETL, and report design. Leveraged scrum, Toad Data Modeler, database design, data modeling, SSIS, SSAS, XML, and TFS. Key projects in role include:• Data Warehouse – Designed a data warehouse, decision support system, SSAS cubes for transactional data and site governance. Utilized SSIS and SQL server to implement an enterprise ETL framework. Architected replication-based solution for hot standby and immediate reporting needs.

Brought on board to leverage skills in architecture, embarcadero ER/Studio, ETL, EAI, SharePoint, Rapid SQL, Zainet, Data Profiling, DB design, data modeling, Oracle, SharePoint, SQL Server, SSIS, SSAS, SSRS, and XML to design data architecture, application architecture and conduct data modeling. Key projects in role include:• Forward Prices – Supported the design of a multi-stream price-gathering tool to retrieve and consolidate latest prices for forward marks from internal and external sources. Presented for data steward approval and disseminated to multiple trading, DSS, and reporting systems. • Prices – Led provisioning of spot prices, forward prices, correlations and related data for mark-to-market valuations, risk analysis and various models and valuations

Leveraged data profiling, database design, data modeling, data architecture, SQL, .Net, SOA, win Svc, MS Access, and ASP.Net to lead applications architecture scaling, and deployment of infrastructure. Key projects in role include:• Auto Fax – Utilized automation tools to enable the development and transmission of a detailed eFacimile. Implemented upgrades including redundancies, post-crash self-healing, scalability, and automated deployments to manage to 10,000 communications daily. • Appointment Log for Customer Service – Led upgrade of the customer service web application and implemented content management for managers and document managers for end-users. Delivered faster turnaround time by automating data flow.

Established the SDLC structure and recruited the software development team. Overhauled DR site to create a new data center with consolidated file servers and upgraded database to 64-bit SQL server 2005.

Recruited to write reports to track student performance from the Data Warehouse. Designed a sub-section of reports to show outliers, and downward trends.

Brought on board to leverage leadership, and strategic skills for Enterprise Architecture and Data Architecture. Established the SDLC, consulted on internal and external projects, built strategic initiatives, optimized performance, optimized processes, reorganized business processes. Implemented Software Development Life Cycle. Key projects in role include:• Accounts Receivable systems: Replaced billing and AR system to manage order entry, insurance and customer billing, generate invoices, reminders, and update the AR data warehouse.• Order Automation - Strategic solution implemented for customer service, order entry, automate workflows, including content, document and workflow management portals. Automated order entry, reduced errors, and eliminated manual workflows.• Technology Integration - Led effort to integrate telephony technologies for Click-to-Dial, Predictive Dialing, Incoming IVR to increase talk time by 40%, number of dials by 300%.

Recruited to interface the CRM data into the General Ledger by interfacing with multiple databases and software solutions. Delivered a monthly GL export through an on-demand service for reconciliation between SQL Server, FoxPro and Oracle Financials using Microsoft.Net and Windows Services.

Brought on board to leverage leadership and team building skills for long term strategy, enterprise architecture, lead the software development effort and leverage skills in .Net, ASP.Net, Enterprise Architecture, SQL Server, ERWin, Master Data Management, Reference Data, Windows Svc, SharePoint, TFS, Infragistics, SQL reports, MS Access, Office, VBA, SSRS, XML and XMLFO. Key projects in role include:• Expert Realty - This paperless real estate transaction process is an on-line solution, integrating portals over laptops, and smart phones. Sub-systems include Workflow Management, Real Estate Explorer, Buyer Pipeline, Transaction Coordinator & Property Artist Portal, Notification system, PDF Generation, Reporting.

Promoted to General Manager to lead the Software Development Team utilizing and building on experience in Data Architecture, Client Management, Leadership, S/W Development; this was a multi-project operation servicing clients in six countries. Key projects in role include:• Inbound and Outbound CRM and POS Solutions• Data warehousing & IntelliCube - Query-by-example with pivots & graphs. Data Qualification & Cleansing via ETL into Enterprise Data Warehouse for Data mining and OLAP Cubes.• E-Strategy is a CRM strategy for Product Offers utilizing a decision tree based content management system. The lead base is segmented according to Market performance & client specifications from machine learning.• Internal Solutions - Mainframe Host Data Exchange over SNA server with SDLC cards, Mitem Screen Scraping, Internet Data Scrapers, enterprise CRM health monitor, continuous deployment, and Time Tracking, streaming audio.

Recruited to develop and enhance software solutions leveraging and learning skills in C#, VB.net, ADO.Net, ASP.Net, ASP, HTML, JavaScript, Batch Files, Active Directory, ADO, C, *nix shell scripting, IP telephony, Mitem, MS Access, VBA, ETL, ERWin, Master and Reference Data Mgt, MSMQ, Opalis, DTS, SQL Server, Replication, OLAP Cubes, SQR, SOAP, Voice Compression, Windows Services, Web Services, XML, Data Modeling, Data Profiling. Key projects include:• CRM - Inhouse CRM utility to faciliate product sales, customer retention, customer service for inbound and outbound sales with offices in six countries.• Enterprise Data Warehouse - Multiple data marts (one-each for individual verticals) went into this warehouse.• I.T. Toolkit - A set of utilities to simplify, consolidate, and manage I.T. tasks with failure notification, escalation mechanism, an Automated Job Tracker which was a Token based job tracking system including detailed log files with a front end allowing search, reporting. Other utilities include Text Feed Runner, Auto Corrector, Regression Tester, Transmission Automator.

Managed the scheduling system for the $15 Billion renovation of Miami International Airport. The system tracked tasks for each business, operational and engineering unit in the endeavour.

Developed a school management software system to track students though various courses and grades, to keep track of tests, homework, assignments, projects, etc.

Implemented Ship-to-ship chat system

Quickly promoted to Lead Architect to lead two groundbreaking projects levering C, C++ and Paradox and DBii development skills. Projects are:• Electronic Fund Transfer - This was a groundbreaking project for the Govt of India. It is the first electronic money transfer system replacing the legacy fax + phone confirmation system. Modules included data entry front end, secure DES 5 transmission, financial reporting, and end-of-day confirmations.• FOREX - Another groundbreaking project for the Govt of India. It is the first electronic Forex confirmation system allowing local State owned banks obtain permission for high volume transactions, and exchange foreign currency at the correct rates.

Designed a student management system tracking admissions, fees, grades, progress through education levels with financial and grade reporting for each class.

Designed several innovative products - Pert-CPM crashing routine, Lexical analyzer, Mouse driver, MS Paint.Taught programming in C, C++, Pascal, Fortran, GW Basic, and taught WordStar, WordPerfect, Lotus 1-2-3