Responsible for strategic planning, tactical planning, regulatory compliance, policy development, systems alignment, and operations oversight.

Technical environment: Snowflake, dbt, Workday, SnapLogic, Control-M, DataStage, Python, Netezza, SQL, Jira/Confluence, Tech Lead for an HR data warehouse data engineering team. Responsibilities include engaging with stakeholders, drafting features, technical solution design, data modeling, work breakdown to stories, defining project schedules, work delegation, code and data quality controls, project documentation, production deployments, and developing in Workday, dbt, Snowflake, DataStage, and Netezza.

Contractor with the Business Intelligence Reports and Statistics unit to support databases, data collection systems, analytics solutions, and other related tools that optimize efficiency and quality of analysis work. Analyze business objectives and develop data solutions to meet stakeholder needs. Utilize agile development methodology to design meaningful Tableau dashboards, Analyze data issues with SQL and advanced Excel. Document report components and processes in runbooks. Develop, test, and deploy SQL Server-based reports in Tableau and SSRS. Develop, test, and deploy data import and export (ETL) processes in SSIS.

Manage and mentor team responsible for requirements gathering, documentation, solution design, development, testing, deployment, and ongoing support of data management, data warehouse, and business analytics functions. Prioritize and assign service requests, perform technical reviews. Lead daily SCRUM meeting. Represent Data Services in regular client meetings. Perform data analysis, design and implement data architecture solutions, create and modify ETL and data scrubbing solutions, and automate processes. Create and modify stored procedures, functions, and triggers. Create, optimize, and modify reports in SQL, SSRS, and Excel. Partner with business unit leaders to prioritize initiatives, optimize operational data flow, improve information delivery, and support regulatory compliance.

Supported the University’s branding and marketing efforts by generating and providing marketing lead and student enrollment data in flat reports and pivot tables with complex calculations and slicers. Created complex SQL queries to provide required datasets for analysis. Identified and resolved data issues. Developed analytics dashboard prototypes in Excel and Numetric. Obtained access to Indeed job posting data to provide a current source for relevant higher-education market data. Worked with Neustar and the marketing team to develop a model for extracting demographic and consumer behavior data from ElementOne for comparison to the University’s student demographic data to refine marketing personas for individual degree programs.

Contract Lead Business Systems Analyst with the Water Services Department to improve processes and facilitate implementation of business intelligence. Gather and document business requirements, diagram processes, perform gap analyses, evaluate technical solutions for procurement, customer service, customer service, and human relations. Define KPI and other reporting requirements, identify data sources, and define technical ETL requirements. Manually extract, transform, and load from disparate sources to perform data analysis using Oracle SQL, Microsoft Access SQL, and Excel Pivot Tables. Identify and facilitate resolution of data consistency issues. Design and create prototypes, including SQL statements, and technical specifications, for business intelligence dashboards and operational reports for development in an Agile environment. Perform system testing, facilitate user acceptance testing, and provide user training.

Contract Business Analyst on the MVD modernization project. Working in a hybrid Waterfall and Agile/SCRUM environment, conduct interviews for discovery and requirements gathering, process mapping, and design. Clarify system, workflow, process, and data needs. Create as-is-/to-be statements for interfaces to MVD systems, including AAMVA, court, insurance, and third party systems. Perform data analysis using SQL in a Microsoft SQL Server environment to identify the root cause of court data issues. Create UML models, use cases, functional requirements, process flow diagrams, and user acceptance criteria to produce a backlog of sprint-ready scalable solutions.

Configured and implemented an automated business management system built in SQL Server to meet requirements gathered through analysis and JAD sessions. Engineered and re-engineered processes and procedures to ensure efficient end-to-end functionality. Performed revenue gap analysis to identify the root cause of shortfalls and high-margin opportunities. Facilitated vendor relationships, established key performance indicators (KPIs), and created a definitive brand communicated through traditional advertising, public relations, internet marketing, social media marketing, and customer relationship managementEngaged with cross-functional teams to develop and spin new service offerings. Created new service technical protocols, consents, and marketing collateral. Created print and digital collateral for monthly promotional offerings, including brochures, flyers, rack cards, website content, email content, and press releases. Leveraged social media marketing, blog posts, edited videos, press releases, and social bookmarking to improve keyword search engine performance.Identified the root cause of the Infusionsoft platform service deliver capacity constraints and provided a recommended solution. Completed an internal sales pipeline process JAD session, created and received approval on the process chart, and implemented appropriate system changes. Created an automated reporting system in Access to replace and improve inefficient spreadsheet efforts.

Evaluated business plans for flaws and funding source compatibility. Guest speaker for alternative asset investment due diligence and cost segregation strategies. Passed the Series 65 (Investment Advisor Representative). Real estate investments, including wholesale and fix and flip.

Completed an Oracle database audit remediation project ahead of schedule and under budget.

Manager and technical lead for a global database administration team supporting high transaction replicated Oracle and data warehouse systems with 18 members located in six data centers in five countries. Responsible for leading collaborative efforts across multiple teams to identify opportunities, remediate production issue root cause, mange defects, develop SOW (statement of work) documents, vendor management, gap analysis, and project planning. Assist developers with writing and optimizing SQL and complex shell scripts. Standardize operations policies and procedures across data centers. Ensured service delivery met or exceeded SLA (service level agreement) specifications.

Senior Oracle Database Administrator and team lead supporting multiple customer accounts in local and remote data centers. Determined business and system requirements by facilitating client discovery and JAD sessions, including communicating technical issues to non-technical internal and external customers. Review and approve SQL deliverables for QA, coordinate QA and user acceptance, perform defect management, and deploy releases into production.

Oracle DBA supporting OLTP and data warehouse Development, QA, and Production environments. Created and maintained relational data models, entity relationship diagrams(ERDs), and data dictionaries for multiple applications. Created test cases and executed test plans. Wrote data load, including ETL, and reports using SQL and PL/SQL.