Responsible for creating and guiding the overall enterprise data and reporting strategies for Airlite. Mentor a team of business intelligence, reporting, and ETL developers who are responsible for growing enterprise BI platform investments. Collaborate with business leaders on data requirements to translate business needs into analytical and reporting applications and structures. Supporting the organization and leadership of a business intelligence competency center for continued data governance.DUTIES & RESPONSIBILITIES:• Manage a team of BI developers for reporting, data, and ETL development. • End-to-end solutions architecture designs, and most recently architecture and implemented a Power BI reporting platform, including SAP migration to Power BI. My roles included building gateways (clustered), certified dataflows, data-marts, datasets, and publishing objects to respective workspaces, with security factored! • Create and manage a governance team to protect the meaning and value of company data.• Work closely with internal business customers to gather and document requirements for scope of project, including reporting, business intelligence, data feeds, and analytics.• Introduce, educate, and implement BI technologies and architectures of delivery mechanisms, ETL/Integration, dashboards, and self-service reporting tools.• Develop and maintain reports, dashboards, stored procedures, ETL packages, and dimensional models.• Contribute to the enhancement of outdated reports, optimize existing ETL packages, OLAP cubes, and dimensional warehouses, and decommission outdated applications where applicable.• Assist in creating ETL mapping specifications, job scheduling, error handling, data governance rules, process flows, and data implementation procedures.• Validate the output from ETL procedures, store procedure data sets, against end report information.

Duties & Responsibilities: • Azure Suite/Technologies: ADLS Gen 2, Integration (ADF), Data Ingestion from On-prem Sources, landing in ADLS Storage Containers as parquet files. Azure resource management, cost analysis on usage include configurations of Integration Runtime servers, allowing traditional SSIS to communicate with cloud resources, and allowing On Prem resources to use the self-hosted server during computations, saving substantial dollars for the company.• Azure Databricks - Configuration of unity-catalogs, and working with Databricks Live Tables (DLT), and delta tables. Utilizing notebooks for DMLs (Data Manipulation). Measuring cost analysis over Serverless vs Self-Hosted Clusters to gage computation cost! Spark languages: Python, Scala and SQL• End-to-end solutions architecture designs, and most recently architecture and implemented a Power BI reporting platform, including SAP migration to Power BI. • Gateways (clustered) Configurations. • Modeling dataflows, data-marts, datasets, and publishing objects to respective workspaces, with security factored! • Work closely with internal business customers to gather and document requirements for scope of project, including reporting, business intelligence, and analytics.• Introduce, educate, and implement BI technologies and architectures of delivery mechanisms, ETL/Integration, dashboards, and self-service reporting tools.• Develop and maintain reports, dashboards, stored procedures, ETL packages, and dimensional models.• Contribute to the enhancement of outdated reports, optimize existing ETL packages, OLAP cubes, and dimensional warehouses, and decommission outdated applications as needed.• Assist in creating ETL mapping specifications, job scheduling, error handling, data governance rules, process flows, and data implementation procedures.• Validate the output from ETL procedures, store procedure data sets, against end report information.• SQL and ORACLE database development and Support.

• Collaborate and help scope projects by sharing customer and/or technical knowledge in their specialty domain by leveraging their expertise as a subject matter expert.• Adhere to process(es) outlined by the Global Management team. Maintain tools with up-to-date skills and availability. • Collaborate in and/or may lead meetings with clients/partners to understand their business needs they are trying to solve. Deploy business, technology, and industry strategies to decipher client/partner needs and challenges. Work with team-members appropriately to define customer needs.• Articulate the business benefits of planned solutions to clients/ partners with scaling guidance. Implement mitigations on technical and business challenges.• Implement technical solutions by completing assigned project tasks with defined quality standards.• Identify problems and risks and engage with customers and/or partners or internal stakeholders as appropriate to address and resolve issues.• Identify opportunities to expand or accelerate the adoption and consumption of the cloud technologies.• Learn new technologies or services based on business demands and industry trends. Acquire relevant accreditations and certification(s) as advised by domain leadership team. Share experiences and best practices within the team. • Complete operational tasks and readiness and ensures timeliness and accuracy. Follow policies, compliance, and procedures (e.g., Enterprise Services Policy, Standards of Business Conduct, expenses, travel guidelines).• Technology Facets: AI and Microsoft Data Solutions (Integration, Engineering, Science). Enterprise Database Warehousing, Database Modeling (Conceptual, Logical, and Physical). Work closely with other technology department areas to facilitate cross-function capabilities.• Business Facets: Collaborate as the bridge between business and technology during business requirements gathering and enabling a true end-to-end solutions architecture.

• Adhere to standard naming practices, design patterns, and testing KTG Department of Information Technology processes • Data profiling and analysis on source systems to orchestrate a proper model design.• Analyze and collaborate with KTG subject areas about business requirements during conceptual and logical model phases.• Help define and contribute to conceptual, Logical, and physical Data Model approaches for the Kiewit EDW• Define and detail integration points for SAP data and collaborate with ETL team to facilitate effective EDW.• Define and write technical Metadata definitions for EDW objects across all models• Leverage SAP and Non-SAP data to project physical data models, and integrate into a single integrated physical data model using an industry standard data model as a reference to ensure business extendibility• Work in conjunction and supporting the other Data Modelers• Define and develop technical Metadata definition• Azure Data Factory ETL/data pipeline & data modeling scripts and associated documentation.• Design & implement data integration jobs (External Sources and/or ODS to Data Warehouse and/or Azure Data Lake (ADL) using Informatica Intelligent Cloud Services (IICS) or SSIS• Document ETL job designs and configuration information• Design and perform user acceptance testing• Database development leveraging SQL Server, Oracle and Teradata• Modeling SAP data for BI and delivering large and complex solutions for subject areas per requirements• Architect business and technology solutions, including documentation with strong analytical and problem-solving approaches• Technologies utilized include ER Studio, SQL Server, Teradata, ORACLE, Informatica Intelligent Cloud Services (IICS), Microsoft Azure Data Lake (ADL), Microsoft Azure DW, ADF, SSIS, SSAS, SSRS, Power Designer, and other 3rd party utilities particularly within IICS connectors and ADF.• Service-Now and HCM Success-Factors data and Integration API / ETL

• All your enterprise BI development needs: (SSAS, SSIS, SSRS). • All your enterprise databases architecture and development needs: (SQL Server database development, implementation and maintenance, Security). • Data modelling tools (Enterprise Visio for Architect and ERWIN).• Writing MDX queries for measures and dimensions and incorporating business intelligence rules on business applications/functions (SSAS).• SSIS (SQL Server Integration Services), development and support. Writing ETL applications from country ERPs to corporate central EDW; and between EDW and ODS layers.• Help DBAs with database maintenance plans and recommending best practices during data governance sessions / meetings• Technical specifications, Systems Operational guides, and Functional docs.

• Work directly with clients to map business needs to data warehousing and business intelligence solutions centered on Microsoft technologies• Assess existing data warehousing and business intelligence solutions and recommend approaches for modernization.• Define system/data architectures for Analytical systems and large scale enterprise DW solutions• Analyze performance bottlenecks and recommend performance optimizations• Work collaboratively with a team of senior software architects/developers to implement the solutions• DW schema design, implementation and optimization• ETL framework design, implementation and management• TSQL, MDX, DAX• Design, develop and deploy SSIS packages• Design, develop and deploy SSRS and Tableau solutions

• Responsible for leading and development of software components related to all aspects of Data Sourcing, Transformation, Data Quality and Reporting using standard ETL, DW and BI technologies.• Design and implement processes for sourcing data from various ERP sources leveraging Operational Data Store and Data Mart concepts to facilitate timely, reliable and secure delivery of Data driven reports and analytics.• Design and development of integration/ETL components using IBM Cognos Data Manager, SQL Server Integrated Services (SSIS), SQL Server, and Oracle PL/SQL procedures and functions.• Providing technical guidance and leadership to other developers on ETL/Data Integration projects.• Troubleshoot execution challenges in complex projects (application, infrastructure, code quality, data and performance) and enable focused corrective actions to make projects successful.• Attend meetings in preparation of project planning directly with client business users and sponsors, including requirements and architecture review, and project milestone sessions.• Reporting and data analysis systems that include Cognos/SSRS dashboards, standard reports, and ad-hoc reporting capabilities.

• Design, execute, assess, and troubleshoot software programs and applications. Includes configuring, coding, developing, and documenting software specifications throughout the project life cycle(s). • Oversee system startups in a timely and accurate fashion, and provide support to other departments where required. • Strategy & Planning - Collaborate with analysts and designers in the development and initiation of new software programs and applications. • Oversee the quality assurance of program logic, data processing, and error resolution. • Develop an awareness of programming and design alternatives. • Take an active role in cross-departmental projects when needed.• Run and monitor performance tests on new and existing software for the purposes of correcting mistakes, isolating areas for improvement, and general debugging.• Gather statistics and prepare and write reports on the status of the programming process for discussion with management and/or team members and miscellaneous library and test scripts.• Built Team-Site and configurable SharePoint site for document sharing and other work related shared features.• TCS Healthcare technology system applications – Acuity and CareWebQI for Milliman Care Guidelines.• Business and technical requirements gathering• Writing and maintaining ETL packages• Research, document, and implement program requirements and specifications. • Consistently write, translate, and code software programs and applications according to specifications. • Administer diagnostic analysis of test results and deliver solutions to critical areas. • Determine, develop, and maintain user manuals and guidelines. • Liaise with network administrators, systems analysts, programmers, and other software engineers to resolve any defects in products or company systems. • Recommend, schedule, and perform software improvements and upgrades for optimal performance of company workstations.

• Lead a comprehensive strategy and delivery of data solutions as per development of a comprehensive UniNet and EI/BI Roadmap to ensure that UniNet and Alegent Creighton Health have the data and information solutions to support their initiatives and overall strategy.• Contribute as a solution developer on identified initiatives and also provide oversight/liasion/coordinator to other EI initiatives that are in support of UniNet and Alegent Creighton Health. Additionally, ensure that UniNet is taking advantage of solutions and data that can help company-wide strategy• Contribute on initiatives and ensure UniNet and Alegent Creighton Health initiatives are coordinated and integrated into overall EI/BI data architecture.• Business and technical requirements gathering• Database and application analysis, design and development, Writing requirements documents• SQL server database and SSIS development• Writing ETL packages and loading data into data marts• Helping some team members with some technical guidance / code debug and code refactoring to improve performance, maintainability, complexity and scalability

• Business and technical requirements gathering• Writing requirements documents for business and developers• Database and application analysis, design and development• SQL server 2008 database development• SQL Server Reporting Services development and deployment• Writing ETL packages and loading data into data marts• User testing and user training through extensive collaborations and meetings• Liaising with clients designing work flows• Production and development support • Helping some team members with some technical guidance / code debug and code refactoring to improve performance, maintainability, complexity and scalability• Working with mainframe (COBOL) team and decoding business rules and integrating with SQL during migration

• Database and application analysis, design and development• Systems architecture – small business technology integrated• IIS, SQL Server, SMTP, FTP servers building and configuration• Active Directory and local DNS configuration• VB.NET, VB/SCRIPT, ASP .NET Framework, SQL Server Development.• SQL Server 2005, SQL Server Reporting Services,• Projects plan and management – liaising with clients designing work flows• Production and development support

• ERP (Enterprise Resource Management - IFS) System development.• Manufacturing logistics application development.• VB.NET, PLS SQL Development, and C#, .NET Framework.• SQL Server 2005, SQL Server Reporting Services,• User Requirements gathering and compiling feasibility reports.• Modifying and maintaining production systems (ERP) – C#, PL SQL and VB.NET.• Reporting team progress to users and senior staff.

• Instrumented BizTalk solutions for Healthcare Claims Processing using BizTalk Server 2006 R2. Parsing EDI Claims documents spanning from HIPAA 837, 835, 270, and 271 schemas. Utilized SQL Server as the backend and some C#, XML and BizTalk Orchestrations as the front end.• SQL Analysis Services for aggregating reporting data.• Writing and managing ETLs from the data mart to ODS utilizing SQL Server Integrated Services (SSIS).• Developed SQL Server Reporting Services solution for Healthcare claims solution• Installed and configured Exchange Server 2003, Active Directory on Windows Server 2003, DNS and DHCP Servers.• Installed and configured Microsoft Customer Relations Manager (CRM).• Managing and configuring windows accounts

• Design, develop, and implement computer software application using Oracle Database, PL/SQL, MS Visual Studio.Net, SQL Server Database, Visual Basic, Visual Basic Script, and web development technologies, including Active Server Pages, HTML, Java, and Java Script, SSRS. • Designing logical and physical models for ODS layer for internal/external systems• Writing and managing ETLs from the data mart to ODS and from ODS to application layers• OLAP development and dimensions and cubes for reporting systems• Oracle-specific IDE for developing oracle packages, procedures, functions and ad hoc query scripting• Writing procedures and functions, packaging and collections for both windows and web applications usage• Review needs and requirements of clients• Analyze pertinent data and information;• Design system parameters to address the application needs to clients• Design logical and physical databases• Develop customized software based on physical design• Develop supporting data structures• Code, test and implement software

• Extensive software development of new and existing various business applications to manage healthcare insurance claims.• Troubleshoot and debug program bugs. Modify existing programs with enhancements. Implement fixes and enhancements. Design, create, and implement SQL database and applications programs utilizing SQL Server, VB/Script, and MS Visual Studio.NET, JavaScript, SQL DTS, BizTalk Server, SQL Reporting Services, Infragistics Controls.• Deploy Visible Analyst for DB Modeling and Visio for Object-Oriented programming. Write program utilities to bridge the AS/400 and SQL barrier to write/read/change data between the database packages. • Resolve problems and questions from Technical Support. Provide documentation. Assist Select-a-Seat Team Leader with creation and testing of new software. • Responsible for BizTalk Server Installations & Configurations that drive HIPAA compliance for healthcare information. Develop channels, claims receiving functions, and document definitions of 4010 837 EDI claim XML through BizTalk 2002/2004.• Built the web-based helpdesk application which is currently and widely used internally. Support and manage reports deployment to our providers, payers and internal audience through SQL Reporting Services.• Responsible for all web applications backend – from programming, testing and implementation of applications and servers.

• Lead programmer for ASP and .NET databases and applications of different types of clients from different industries which included: realty, investment, general administration, retail and education. Configure and support websites throughout the company farm servers. Configure IIS, ODBC, DSN and security, both database-driven and Windows NT across web and desktop applications. • Manage the Technical Help Desk function as well as prioritizing, resolving, recognizing, and routing end-user computer problems. Establish and document policy and procedure.

• Year 2000 application compliance auditing and testing. Troubleshoot and maintain Visual Basic applications. Writing SQL stored procedures and DTS for SQL data manipulation. FoxPro report designer reports generation.

• Responsible for migration of extensive FoxBASE and Dbase databases and applications programs to Visual FoxPro. Tuned and modified applications for year 2000 remediation and compliance. Troubleshoot and maintain existing Visual Basic programs and MS Access database for UMASS (University of Massachusetts) internal facets. Troubleshoot and diagnose PC, and MS Windows 98 related problems for in-house staff.

• Perform configuration, set-up and implementation of incremental improvements. • Promptly initiate Service Desk tickets and resolve tickets assigned. • Participate on technical support team responsible Data Center functions as well as hardware and software support. • Develop procedures and documentation for handling frequently encountered issues and improving reliability and availability of key Data Center infrastructure components. • Consult with and support end user departments in use of hardware and software; Assist in the implementation of the Systems plan.

• Entry-level programmer. Utilized C and Structured Systems Analysis and Design Methodology (SSADM). Developed program documentation and testing for senior developers.