SUMMARY

• Hands - on backend ETL development experience. Design, develop, and enhance mission critical data systems.
• Strong ability to provide daily production support for multiple backend processes responsible for data movement, (alpha and delta loads).
• Successfully execute small and large data integration projects.
• Strong ability to build and maintain relationships with fellow tech team members and stakeholders across all lines of business.
• Naturally curious and always eager to help colleagues.
• Experience in all stages of SDLC for enterprise systems.

TECHNICAL SKILLS

Programming Languages: SQL, Python, R, C#, PHP, PowerShell

Markup Languages: HTML, CSS, XML, JSON

Database Engines: MSSQL, Postgres, Snowflake, Redis, MySQL, AWS Redshift

Tools: SQL Server Management Studio, SSIS, SSRS, Visual Studio/Code, Excel, Pentaho, PowerShell, Swagger, WinSCP, Notepad++, RedHat Decision Manager, SVN, TFS, GIT

PROFESSIONAL EXPERIENCE

Sr. Systems Analyst

Confidential

Responsibilities:

• Inherited and enhanced legacy processes to Extract, Transform and Load (ETL) data from systems of record to target systems
• Created ETL’s for data movement in-network across databases and API’s and with external vendor systems
• Daily ETL production support and backend development across multiple database servers for reporting and application databases
• Bi-weekly Sprints to enhance backend processes and address defects
• Involved in all phases of SDLC from documenting requirements, design, development, deployment and post-release production validation
• Lead daily stand-up meetings with onsite and offshore developers
• Partnered with LOB to define system requirements on capitalized projects
• Supported data governance committee comprised of cross-functional group of executives and senior managers

Systems Analyst, IT ERP & Control Systems / Business Systems Development

Confidential

Responsibilities:

• Maintained and enhanced ERP application supporting +2,500 concurrent users across the enterprise from corporate offices in Westlake Village California, contact center in Salt Lake City Utah, distribution centers in Indianapolis Indiana and Kansas City Missouri
• Key point of contact for resolving issues and completed projects for internal customers across the enterprise including: Accounting, Treasury, Operations, EDW, POS, Contact and Distribution Centers
• Partnered with the business to understand business requests and requirements to enhancement critical financial systems, (sub-ledgers and general ledger for balance sheet)
• Directed the efforts of onshore and offshore developers
• Served as the primary functional/technical interface between inter-department business users and development teams onsite and offshore
• Elicited requirements from internal and external customers for systems enhancements and bug fixes
• Successfully meet monthly build deadlines for project releases and hot patches
• Lead daily stand-up meetings with onsite and offshore developers

Business Analyst

Confidential

Responsibilities:

• Innovator award for the year 2012 (awarded April 2013) for automating repetitive, manual and error prone processes
• Reconciled $70+ million transactions per month in balance sheet accounts
• Prepared and entered journal entries and completed month-end close cycle
• Documented procedures for accurate reconciliations and efficient management of customer payment issues
• Assisted business with creating test cases and validation of ERP bug fixes and enhancements in sub-ledger and general ledger
• Scripted batch jobs for data conversions, data mapping, error handling and issue logs for financial systems
• Provided support to development teams on/offshore, (located in India and China) in their coding and unit testing
• Initiated development of semi-automated reconciliation software
• Developed automated processes for data extraction from remote servers
• Mapped and conformed data from internal and external sources
• Successfully implemented balance sheet reconciliation application which increased financial controls and automated manual high touch point processes for $5+ million per month in transactions

Systems Analyst

Confidential

Responsibilities:

• Managed team of offshore developers located in Philippines and India
• Prepared functional and technical requirement documents
• Managed team of offshore developers located in Philippines and India
• Deployed databases and developed front end GUIs for institutional clients to update and retrieve client data
• Integrated high frequency trading applications into firm’s proprietary trading software using internal programs and third party APIs
• Converted EL scripts to C# for non-retail customers
• Implemented low latency block-allocation add-on script for non-retail customers

Programmer Analyst

Confidential

Responsibilities:

• Coordinated the release of new .NET based trading platform
• Built website to support software for the analysis and execution of futures, options and equities
• Developed and maintained file schemas, (XML) and packaged executables to provide customized software layout for various retail and institutional clients
• Lead software training sessions for employees and clients in-person and online
• Identified, documented and QA’d bug fixes and enhancements
• Migrated firm from Microsoft Mail Exchange Server to Google Apps Enterprise
• Implemented and maintained cloud based customer relationship management (CRM) software
• Developed and deployed customer specific software installation, (.exe) files
• Rebuilt existing website to function dynamically with a content management system (CMS)
• Developed web based data communication system which coordinated multiple internal and external systems