SUMMARY:

• Full - stack enterprise application developer with experience on benefits administration, mortgage banking, e-commerce and capital markets solutions.
• Adept process, systems and data analyst with the ability to define, design and improve business processes, build or implement technology tools, and produce actionable business insights from data
• Excellent facilitator of communications between technical, non-technical and executive audiences
• Practiced team builder and motivator with strong written communication and presentation skills
• Experienced entrepreneur: business structures and formation, financial and operations management, marketing and sales

TECHNICAL SKILLS:

Database: SQL Server, MS Access, MongoDB, SSMS, SSIS, SSRS, ETL, query optimization, views, functions, sprocs

Programming: C#, JavaScript, TypeScript, SQL, VBA, PowerShell, CSS, XML, HTML, SOAP, JSON, AJAX, SOA

Systems Development: requirements, architecture, documentation, TDD development, deployment, monitoring, security

Software: Visual Studio, Excel, Access, Visio, Project, Word, PowerPoint, Outlook, SP Designer, Illustrator, Photoshop

Platforms/Frameworks: .NET, Entity Framework, SharePoint, Azure, NodeJS, AngularJS, Bootstrap, Azure

Data Analysis: Google Analytics, Access and SSRS reports, Excel - Power BI, PivotTables, vlookup, macro automation

WORK EXPERIENCE:

Confidential, Dallas, TX

Software Engineer

Tools: Used: .NET MVC, Web services, SOA, C#, LINQ, JQuery, Bootstrap, HTML, XML, CSS, WCAG, JSON, SAML, SSO, GPG, TFS, SQL Server, SSMS, Visual Studio, PowerShell, VBA, Access, Excel, PowerPoint, NewRelic, Azure

Responsibilities:

• Lead client delivery team developer for multiple BenefitConnect web portals. BenefitConnect (BC) is a SaaS platform relied upon by enterprise clients to deliver employee benefits, pension and HR program administration. The BC feature set includes: benefits enrollment, automated email and printed communications, billing, invoicing and payments, reporting, multi-factor authentication (MFA), vendor SSO and API integrations, and secure EDI between employers, insurance carriers and vendors.
• CDT developers are the systems and technology principals for WTW’s Benefits Delivery and Administration (BDA) business. CDT developers own the following roles:
• Application Development - Test driven development of user interactive and process automation applications using Agile SDLC iterations. Ensure applications are SOC-2 compliant for security, confidentiality, availability and privacy. Manage deployments to private cloud hosting environments. Actively monitor Production systems with DevOps tools to ensure high performance and SLA compliance. Address faults and security threats by implementing and deploying patches and updates. Execute periodic maintenance, backup and recovery tasks. Coach and mentor junior developers.
• Data ETL & Business Intelligence - Manage multiple application SQL Server databases. Develop and maintain secure EDI transfer and loading processes for client and vendor datasets. Maximize data access performance via query optimizations, indexing, partitioning and nearlining. Develop and maintain cached data services and data warehousing tools. Create custom reports that deliver easily consumable and actionable insights to internal and client consumers.
• Business & Product Support - Work with client-facing staff to win new business by serving as a BenefitConnect subject matter expert (SME) on system features and behaviors. Create or validate technical presentation documents. Respond to system architecture and performance inquiries from IT diligence teams. Maintain sandbox environments for client system demonstrations. Deliver feasibility and cost analyses for feature change orders to client-facing staff.

Confidential, Plano, TX

Business Analyst, Software Engineer

Tools: Used: C#, MVC, LINQ, JQuery, Bootstrap, HTML, CSS, TFS, Entity Framework, MEF, XML, SQL Server, SSMS, SSIS, Visual Studio, VBScript, VBA, Access, Excel, PowerPivot, PowerPoint, SharePoint, SharePoint Designer

Responsibilities:

• Lead developer of ESLDataMaster, a project management and invoicing application used to manage $MM merchandising projects and deployments. The feature set included invoice entry and tracking, reporting, automated emails and documents ETL. Created OFramework, an OOP framework for MVC pattern VBA application development.
• Summarily, served as an information technology principal for MCOE, Confidential ’s merchandising execution unit by fulfilling three business roles:
• Application Development - Communicate with stakeholders across LOBs to elicit requirements for the creation or design of business processes and applications. Design, build and deploy desktop and web applications using multiple technologies (.NET - C#, JQuery, MVC, LINQ, EF, TFS; SharePoint - sites, pages, lists, libraries; Office - Access, Excel, VBA). Post deployment, facilitate user training sessions and own user support.
• Database Administration & Reporting - Create and manage multi-user Access and SQL databases. Maximize data access performance via indexing, partitioning, and query plan optimization. Develop and maintain complex queries, views and stored procedures. Build and deploy complex Excel and SSRS reports. Manage report subscriptions and permissions. Create and administer data backup and recovery plans.
• Data Analysis - Contribute requirements and acceptance criteria for primary research projects. Build and run efficient ETL processes for large datasets. Discover principal insights using business intelligence tools (PowerPivot, Excel, Access) that are meaningful and actionable in the company’s facts and measures context. Write findings narratives for presentation and distribution to research sponsors.

Confidential, Richardson, TX

Business Analyst

Tools: Used: VBA, Java, XML, SQL, SSMS, HAScript, VBScript, MS Access, LPS Desktop, IBM AS400 PCOMM & HOD

Responsibilities:

• Developed AutoPOC, a mortgage servicing application that integrated and automated Proof of Claim preparation tasks formerly accomplished using Internet Explorer, MS Excel, MS Word and IBM AS400 Host On-Demand. Rotated through multiple default/bankruptcy process roles to develop professional acumen in default mortgage management and deep expertise with case deliverables including Proofs of Claim, Motions for Relief and Reaffirmations.
• Summarily, duties were to deliver SLA-compliant management of bankruptcy accounts via ‘best practices’ use of company information systems and tools. A chronology of the roles is as follows:
• Loss Mitigation - Performed bankruptcy file audits to assess plan compliance (Chapter 13), delinquency status and cure horizon. Audit results triggered loss mitigation actions including Loan Modification, Deeds-in-Lieu and Motions for Abandonment or for Relief.
• Case Servicing - Owned and assembled bankruptcy deliverables such as Proofs of Claim, Payment Change Notifications, Post-Petition Fee Notices and Notices of Final Cure Response. Completed assemblies included: Mortgages/Deeds of Trust, Notes, Assignments, loan interest tabulations, fees and costs ledgers, escrow analyses.
• Process & Systems Support - Elicited requirements and developed business unit reports. Served as an expert resource to peers and managers for MS Office applications, SQL reporting and AS400/XML macro programming.

Confidential, Dallas, TX

Founder, Managing Partner

Tools: Used: C#, JavaScript, IIS, VBScript, HTML, CSS, MS Office, VBA, FrontPage, SQL Server, SSMS, HTML, VBA, Access, Excel, PowerPoint, Microsoft Project, Google AdWords, Google Analytics

Responsibilities:

• Managed the build and implementation of Confidential, a B2C e-commerce platform for booking airport ground transportation and purchasing travel merchandise. Successfully transitioned the clients and operations of DFWLoveTaxi, the legacy business, to iLOVETravel. Created SEO programs that delivered Page 1 organic Google & Bing listings (2005 to 2012). Grew client accounts from zero to 200+. Grew annual revenues from $0 to $285,000.
• Served the business variously as the information technology, marketing and financial principal:
• Information Technology – Designed Microsoft Access forms, views and reports to simplify data entry and querying. Developed ETL processes for transferring remote Oracle sales data into local SQL Server. Created Excel templates and VBA scripts used to analyze productivity and business performance data. Created PivotTable reports and dashboards for operations KPI reporting.
• Marketing – Used Google AdWords & Analytics to execute web marketing campaigns. ROI was measured with multiple metrics including: click-through (CTR), bounce rate and conversion percentage. Created and edited AirportBOUND, a monthly client newsletter. Also created TED., a customer satisfaction KPI
• Finance – Established budgets, prepared financial statements and tax forms. Also built Excel ROI models that governed expenditures. Procured secured and unsecured business lines of credit, and merchant accounts to enable card transactions processing

Confidential, TX

Software Engineer

Tools: Used: C#, VBA, VBScript, HTML, CSS, XML, SQL Server, SSMS, Crystal Reports, Access, Excel, PowerPoint

Responsibilities:

• Co-developed PriceThrustDetector (PTD), a price momentum algorithm used to trade equities and futures instruments.
• PTD delivered positive backtest returns across market conditions and time frames.
• Summarily, duties were to serve as an information technology associate for the firm by fulfilling two business roles:
• Develop and support real-time trading signal-generation algorithms. Signals were generated by automated discovery of technical patterns in OHLC price charts of equities and futures instruments. Patterns sought and traded were directional Edwards-Magee and Dinapoli price formations. Production algorithms were validated via backtesting on intraday and daily time frames. Entry, profit target and stop-loss prices were also generated by automated technical analysis to discover Fibonacci support and resistance price levels.
• Data Administration & Reporting – Develop and maintain SQL queries and reports. Create and administer data backup and recovery plans. Support stakeholder communications by computing firm performance ratios including periodic VaR, CAGR, Sharpe ratio and alpha versus benchmarks.

Confidential, Dallas, TX

Research Analyst

Responsibilities:

• Assisted in the design to implementation of market research projects including: product concept tests, attitude and awareness, positioning and segmentation.
• Also helped develop advertising and pricing strategies for corporate clients.
• Developed Excel VBA used to migrate csv datasets from SPSS into Excel for analysis using PivotTables and PivotCharts.
• Created final client deliverables using Excel, Word and PowerPoint which included tables and charts of findings, textual interpretations of quantitative data, and decision-enabling conclusions and recommendations.