James Lewis

<p>Responsible for SSIS DB Catalog ETL Production Support for CT DMHAS EDW and Web Development and Maintenance, Setup and Security Support, Medical Clients and Vendor Managed Data (VMD) Applications.</p><p> Developed and supported enterprise ETL workflows using SSIS, T-SQL, stored procedures, SQL Server Agent Jobs, Azure SDLC, SSN, including data validation, troubleshooting, query optimization and production support.</p><p> Designed and created interactive Tableau Dashboards and Power BI financial dashboards for Loan transactions, Real Estate analytics, personal banking, and auto loan reporting.</p><p> Translated financial reporting needs into interactive Tableau and Power BI dashboards for loan transactions, real estate analytics, personal banking, and auto loan reporting, supporting business users with data analysis and KPI visibility.</p><p> Support .NET Framework interface, Crystal Reports, MS Access Applications, MS360, Java scripts and Project Management.</p><p> Developed Tableau KPI scorecards and visual analytics reports for business users and executive management.</p><p> Built and maintained SSRS reports, parameterized reports, scheduled reports, and financial operational reporting.</p><p> Supported Database, SharePoint Websites, One-Notes Doc, TPEP with SSIS ETL Packages and Excel Extracts.</p><p> Worked on Property and Casualty (P&C) LLM data integration for Auto and Home Loans prospect direct mailings, Insurance policy mapping, Teradata upload, security, access, and financial analysis reporting.</p><p> SQL Server upgrades, report server maintenance, ETL monitoring, query optimization and advanced T-SQL.</p><p> Used Visual Studio, SSRS, SSIS, SSAS, SSMS, AGILE methodologies, and Power BI for enterprise report and analytics.</p>

<p>Responsible for SSISDB Catalog ETL Production Support for CT DMHAS EDW and Web Development and Maintenance, Setup and Security Support, Medical Clients and Vendor Managed Data (VMD) Applications.</p><p> Developed and maintained enterprise ETL solutions using SSIS, T-SQL, SQL Server stored procedures, views, and database automation scripts, REST & SOAP Web Services, and REST API clients.</p><p> Designed and implemented Tableau Dashboards and Power BI analytics reports for healthcare reporting, HL7/HIPAA transaction monitoring, client analytics, and operational dashboards.</p><p> Created Tableau visualizations and executive dashboards for healthcare metrics, production monitoring, and vendor managed reporting.</p><p> Developed and maintained SSRS reports, healthcare operational reports, and SQL-based reporting solutions.</p><p> Supported DMHAS EDW, DRS, TPEP with SSIS ETL Packages, Excel Extracts, and SharePoint Websites.</p><p> Used Visual Studio, SSRS, SSIS, SSAS, SSMS, AGILE, and Power BI for healthcare data integration enterprise reporting.</p><p> Developed SQL and Python scripts using PowerShell connectors to Add/Update MS Databases and Report Servers.</p><p> Worked extensively with Cloud storage, Tableau & Power BI Dashboard report, data extracts, interface integrations.</p><p> Documented SSISDB Catalog conversions, SharePoint Forms/Lists, Azure DevOps work items, data flows, production support steps, and system changes for technical and business users.</p><p> Experience MS Azure Cloud/O365, Power Apps, Mi-Apps Cloud, Smart Forms, Excel, PowerPoint Training Systems.</p>

<p>Responsible for SharePoint Production Support, SharePoint Site Development and Maintenance, Setup and Security to support Suppliers and Buyers with Vendor Managed Inventory (VMI) Applications.</p><p> Developed and supported enterprise ETL workflows using SSIS, T-SQL, SQL Server, and Excel ETL processes for shipment and receipt integrations into SharePoint VMI sites.</p><p> Designed and developed Tableau Dashboards and Power BI dashboards for shipment tracking, inventory analytics, supplier performance, and operational reporting.</p><p> Created Tableau visual analytics reports and KPI dashboards for logistics and warehouse reporting.</p><p> Developed and maintained SSRS reports, operational dashboards, and warehouse reporting solutions.</p><p> Used Visual Studio, SSRS, SSIS, SSAS, SQL Server, AGILE, BIPICS, and Power BI for shipment interfaces and production data warehouse reporting.</p><p> Converted SharePoint 2013 to Cloud 2019 using AvePoint FLY migration tools.</p><p> Developed Python scripts and PYODBC PowerShell connectors to Add/Update MS Databases.</p><p> Developed SharePoint 2010–2016 Forms InfoPath and Java Scripts converted into Power Apps Canvas applications.</p><p> Used MS Cloud/O365, Power Automate, Access, Excel, and PowerPoint for VMI tracking and training systems.</p>

<p>Worked with The Hartford Insurance using Visual Studio, Cloud SharePoint, SSAS Financial Reporting.</p><p> Developed Dashboards using SSAS, SSRS, Excel Warehouse Data for Extracts refreshing SSRS, Reports, Cubes, Tabular and Pivot Table Data for Deployment to Web Site.</p><p> Supported SQL Server 2003-2016 Databases.</p><p> Supported with Data link Viewer, MS Access App, Windows workstation OS upgrade.</p><p> Support Developed International Enterprise Accounting Management Software Apps for local Unions.</p>

<p>Used VS 2000-2016, SSIS, SSAS, SSRSs, SharePoint Web Site, Crystal Reports for online Reporting.</p><p> Developed Tableau Dashboards deployment.</p><p> Excel Charts for Pivot Tables for Dues Financial Report.</p><p> Performed ETL and Excel file conversions.</p><p> Utilized Remote software as Log Mein, Team Viewer, Go to Meeting for installation and Support.</p><p> Performed Web Apps development.</p><p> Resolved production issues Web support and Work Request tickets.</p>

<p>Managed Servers, E-mail Server, Testing, Internet High School online classes, .NET Apps, VS 2005-2014.</p><p> Worked with SSIS, SSAS, SSRS, .NET Framework interface, Crystal Reports, MS Access Applications.</p><p> FileMaker Pro installations, ASP .Net, MF COBOL interface, Windows upgrades, deployment.</p><p> Created Tableau Workbooks for Dashboard and deployed Tableau Servers.</p><p> Manage SQL Data Warehouse, Support Power BI, Excel Pivot tables Macros.</p><p> Created SSIS Packages.</p>

<p>Responsible for SQL Server Installation, Development and Projects Maintenance.</p><p> Converted Company Mainframe and MS Access data sources to Web Base ASP VB screens and Excel spreadsheets.</p><p> Converted COBOL DB2 and Oracle DB to SQL-Server.</p><p> Design and developed procedures, forms, VBA Modules, Excel Workbooks to GUI screens, reports, Web scripts.</p><p> Used Excel, Crystal Reports for on-line corporate financial reports.</p><p> SQL Server, DTS extracts from SAP transaction database tables for accounting and reports.</p>

<p>Worked with Project Team to manage offshore consultants.</p><p> Responsible for conversion, legacy Databases to support of mainframe system for Y2K compliance.</p><p> Worked with Project Team on Company database conversion.</p><p> Converted COBOL IMS screens, Excel VBA spreadsheets, JCL, VSAM data into internet/intranet applications.</p><p> Converted mainframe into Y2K compliant applications.</p><p> Developed Backup and Restore utilities.</p><p> Developed and coded screens, form, stored procedures, views, reports for Quality assurance testing and performance tuning.</p><p> Converted IBM MVS/VS Mainframe COBOL code into Web applications.</p><p> Tools used were TSO, SPFPC, SP-Win, Erwin, other CA utilities.</p>

<p>Computer Associates ((CA)/Platinum Technologies) Y2K Conversion / Data Warehousing / Data Marts.</p><p> Responsible for security support COBOL DB2, CICS, IMS, JCL, RPG, CL, VSAM, ISPF, TSO, ORACLE, MS-Access, and Supervised 18 Offshore Consultants.</p><p> Excel VBA Modules.</p><p> Coded applications for Y2K compliance.</p><p> Performed quality assurance, e-Testing, and performance tuning on all applications.</p><p> Converted to PowerBuilder, designed and coded Internet/Intranet applications using HTML, ASP, VB Scripts.</p><p> Documentation Enterprise Management Application (GRITS) Coding of menus, screens, forms, reports, and procedures for gathering Medical Documents, claims for Patient and Doctors Database for tracking, HL7 and HIPPA transactions.</p><p> Managed daily and monthly reporting for State and Federal Immunization Requirements.</p><p> Developed Medicare and Medicaid claims process.</p><p> Coded online forms, patients record from Oracle Data Warehouse.</p><p> Designed screens, browser, views, reports, and online help documentations.</p>

<p>Member of Project Team for Development of a National Insurance internet application with VB coding.</p><p> Converted Access and Excel Financial Reports into SQL Server Database and Seagate Crystal Reports.</p><p> Developed Property and Casualty (P&C) insurance Quote Database Application for Auto and Home insurance Coverage with Home and Drivers information, Coverage Limits, History, Optional Coverage, and Policy Discounts.</p><p> Converted MS-Access forms, imbedded procedures and Excel spreadsheets to embedded VBA Macros.</p><p> Developed internet/intranet menus, forms, screens, reports, and views.</p><p> Converted Financial Accounting reports into Internet/Intranet web access reports, and forms.</p>

<p>Phase one of the assignments – System Administrator on the Development Team.</p><p> Customizing of a FoxPro client-server application.</p><p> Converted Child Care Application from MS Access and Excel VBA Workbooks Modules to a SQL Server and Oracles Application to interface HL7/HIPAA/Immunization Transactions.</p><p> Developed menus, screens, forms, reports and procedures for DFCS and Used TSO/ISPF, COBOL, DB2, CICS, and VSAM modules to client server FoxPro menu, screen, forms, and Crystal Report generators.</p><p> Phase two - Responsible for Development and Installation of an Immunization Registration Client HL7/HIPPA/Immunization Transactions (GRITS).</p>

<p>System Administrator on the Development Team coding COBOL Application into PC Client/Server Application in FoxPro Developer.</p><p> Assisted in the development and coding of menus, screens, forms, reports and procedures for Statewide DFCS Application.</p><p> Managed State wide Energy Assistance Application migrated to MS Access, Excel Modules, FoxPro and Clipper Application.</p><p> Utilized FrontPage, PowerBuilder, and JAVA J2EE.</p>