-Works directly with the client user community, business analysts, and directors to define and document data requirements for data integration and business intelligence applications.-Determines and documents data mapping rules for movement of medium to high complexity data between applications.-Creates, adheres to, and promotes the use of data administration standards.-Manages data selection, extraction, and cleansing for corporate applications, including data warehouse and data marts.-Creates and sustains processes, tools, and on-going support structures and processes.-Extracts and analyzes data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the data.-Investigates and resolves data issues across platforms and applications, including discrepancies of definition, format and function. -May create data models, including robust data definitions, which may be entity- relationship-attribute models, star, or dimensional models us Azure Data Factory, Knime, and Databricks.-May also create data flow diagrams and process models and integrates models across functional areas and platforms like Oracle and Snowflake.-Works as a DBA to transition logical models to physical implementation.-Responsible for employing data mining techniques to achieve data synchronization, redundancy elimination, source identification, data reconciliation, and problem root cause analysis.-Responsible for managing quality control and auditing of databases, resolving data problems, and analyzing system changes for quality assurance.-Building and resolving front end and back end issues in Oracle Apex.

▪ Oversee all business reporting team, database team, and data engineering team with 12 direct reports, focusing on SQL and BI development teams communicating on any data points with team.▪ Implemented processes from inception to documentation to implementation while practicing Agile Kanban development procedures.▪ Develop and maintain dashboard and report documentation, within set business SLA’s.▪ Develop deep understanding of business objectives to translate into an information management and business intelligence strategy.▪ Partner closely with technology team to support data and reporting capabilities through project management tools within Azure. ▪ Manage internal management information and analytics platform to provide data, information, and action to business. ▪ Provide leadership of BI analyst and Data specialist teams to develop recommendations based on data interpretation and analysis to transform behaviors and techniques. ▪ Promote and enable the import and export of best practices to and from other business groups and link to emerging practices in the industry and the Business Intelligence data fields. ▪ Manages both internal and external partnerships on BI & Analytics programs from concept-to-delivery to ensure that roadmap priorities meet customer expectations and needs.▪ Engage with the client stakeholders to understand business problems, ideate & converge on solutions/approaches, and develop analytical solutions.▪ Strong understanding of cloud architecture patterns, scalability, and performance optimization techniques in the Azure environment.▪ Collaborate with data engineering team to leverage Azure services to design scalable and reliable data pipelines, ETL and Pipeline processes, and data warehousing solutions.

▪ Led the design and implementation of a new Customer Data Warehouse using Microsoft SQL Server, incorporating complex data models, ETL processes using Data Factory, Python, and Apache Airflow to ensure data accuracy and integrity in Azure.▪ Led the development of a comprehensive documentation strategy and data governance, working closely with stakeholders to identify key requirements and ensure alignment with business goals.▪ Collaborate with various Business function team stakeholders to build high-quality, performance solutions that ensure stakeholder groups have access to the data and reporting they need.▪ Define a set of standard technologies & tools in the Azure and AWS cloud platform, and drive the adoption, implementation, data mapping and ongoing sustaining of the data platform.▪ Evaluate and make the call on technical solutions, architecture, software, data models, hardware, and platforms▪ Manage Data Management practices including Data Modeling, SQL, ETL data collection practices, Data Storage and usage, Aggregation patterns, RDBS, Cloud Development and Data warehousing principles.▪ Execute the vision, goals, roadmaps, strategies and priorities and work alongside my team to accomplish them to ensure high-quality technical solutions and skill development.▪ Develop an organizational structure, operating model, and culture in which my engineers thrive in cross-functional teams that are embedded and dedicated to all business and product areas.▪ Lead strategic planning, roadmap development, and operational planning for my teams and the IT organization.▪ Drive continuous improvement to deliver solutions that are at the forefront of industry-leading techniques while also adhering to analytical and reporting best practices.▪ Maintain a position as a subject matter data expert, defining business requirements, providing data, and assisting in high-level data analysis and reporting to C level executives and below.

▪ Led the team and effort to combine redundant data sources into one to assist in reporting and analytic needs for network automation.▪ Translate business requirements into technical specifications by working with senior stakeholders, developers, and network engineers.▪ Manage and lead complex IT projects in financial services through the software development lifecycle to work with multiple teams and functions across multiple time zones US, Poland, UK, India, and Australia.▪ Practice SAFe Agile, and Kanban software development and testing practices.▪ Manage and create ETL jobs across multiple platforms using Python and Informatica.▪ Manage direct report priorities and performance evaluations.▪ Collaborate and create, maintain, and update Python code using Git Pandas, Web2Py, and PyPac.▪ Migrate databases from on-prem to the Azure cloud while maintain SOX compliance.▪ Write and maintain custom SQL and PLSQL code for multiple data sources and databases.▪ Create APIs using MuleSoft and FastAPI.

▪ Led teams within the IFG (Integrated Fighter Group for F16’s and F22’s) to consolidate data, insure ETL processes and practices and data governance.▪ Led finance developer teams to convert older tables to SAP Hana tables and calculated views.▪ Led finance team effort to convert all data from older mainframes to Hadoop tables as well managing the ETL and documentation efforts.▪ Developed SAP Web Intelligence reports and Universe creation in SAP Business Objects 4.▪ Created Universes in Designer and the Information Design Tool (IDT).▪ Created Calculation Views and Analytic Privileges in SAP HANA.▪ Created ETL scripts and jobs with Business Objects Data Services BODS.▪ Assisted users with Webi and SQL (Oracle and SAP HANA) issues practicing excellent problem-solving.▪ Created dashboards in Tableau with DAX.▪ Was responsible for BI direction of Data Warehouses and Data Marts.▪ Created and maintained documentation, training modules, test cases, and best practices.▪ Managed projects AGILE / Scrum methodologies to insure timelines and delivery dates using JIRA and VersionOne tracking Epics, Stories, Features, and sprints.▪ Wrote and maintained SQL, TSQL, PL/SQL, and stored procedure scripts for ETL, data analysis, quality control and data loading, and testing in SAP Hana.▪ Coded SCM full-stack solutions using SAP Hana, C#, HTML5, Angular, Bootstrap, GitHub, Cloud Foundry, Slack, Squirrel, and Java.▪ Created API's in MuleSoft.

▪ Managed the on shore and off shore team priorities, removed road blocks, and help development roadmaps and data strategies.▪ Led the effort to combine datasets across the company and ensure data integrity, data governance, and documentation was all up to date.▪ Developed SAP Web Intelligence reports and Universe creation in SAP Business Objects 3.1 and 4. x using Universe Designer and the Information Design Tool (IDT).▪ Assisted users with Webi and SQL (Oracle and SQL Server) issues practicing excellent problem-solving.▪ Created and updated Informatica 10.2 Mappings and Workflows in PowerCenter.▪ Created dashboards in Tableau and Power BI with DAX.▪ Was responsible for BI direction of Data Warehouses and Data Marts.▪ Created and maintained documentation, training modules, test cases, and best practices.▪ Managed projects with both SDLC and AGILE/ Scrum methodologies to insure timelines and delivery dates using JIRA.▪ Wrote and maintained SQL, TSQL, PL/SQL, and stored procedure scripts for ETL, data analysis, quality control, and data loading.▪ Created dashboards for Dev Ops showing overall company KPIs as well as branch level.▪ Created basic Oracle Apex 18 applications.

▪ Was responsible for the overall BI direction of the client and team as well mentoring more junior level developers.▪ Created and maintained documentation, training modules, test cases, and best practices.▪ Managed projects to insure timelines and delivery dates.▪ Developed SAP Web Intelligence reports and Universe creation in SAP Business Objects 3.1 and 4.1.▪ Designed, developed, and maintained dashboards in SAP Dashboards Richard Carter - page 3.▪ Developed reports and documents in MicroStrategy 9.2.▪ Wrote custom SQL for Quality Control and testing purposes.▪ Had some Unica experience.

Develop custom reports in Web Intelligence using BO XIR2 - 3.1 Titan.Create custom executive dashboards using Crystal Xcelsius 2008/ SAP DashboardsDesign and maintain reporting marts including tables and objects in Netezza and Oracle.Design and maintain multiple universes for multiple clients.Write custom SQL and other code as needed per project.Some light Unica development

Develop custom Business Intelligence assessments, solutions, and implementations utilizing Business Objects 3.1 XI R2, Excel, Access, MS SQL Server 2005, Cognos 8, and MS Business Intelligence Studio.Develop and document ETL utilizing SAP Data Integrator (now Data Services) into a star schema for reporting and client adhoc reporting purposes.Develop custom charts, diagrams, and dashboards using Crystal Xcelsius (Now SAP Dashboards).Wrote and maintained custom SQL, Business Views, and Materialized views in Oracle9i and 10g.Create custom charts, graphs, and other metrics with programs listed for trend tracking and monitoring.

-Build web-based applications, websites and Surveys using technologies that conform to company standards utilizing ASP, .NET, ASP.NET and C#. -Perform maintenance and updates to existing software products and websites -Assist in the development and maintenance of user manuals and guidelines -Development, formatting and layout of Web user interfaces for new & existing web application projects -Work closely through testing and quality assurance processes for new projects and web change requests - -Troubleshoot reported problems and bugs in web-based applications, identify problem source, debug and directly resolve the issue or coordinate with other programmers -Research, development and testing of new technologies for future web and IT related projects -Coordinate and communicate with project manager and other IT and non-IT department resources

-Develop, evaluate, refine, and automate analytic models using data to address business needs in MS Excel pulling data from Brio Data Warehouse.-Create MS Access Databases to track claims trends and client contact information.-Create Visual Basic (VBA) Macros to evaluate data pull from Access Databases and Brio.-Prepare visualizations of data in order to explain and persuade.-Provide recommendations to key stakeholders and support the business need.-Create and produce forecasts, reports, ad hoc requests, dashboards utilizing Brio data warehouse data and other data source systems.-Interact with multiple teams in different departments and defined requirements for reporting