Steve Fowler Email & Phone Number

Work with small and medium sized insurance companies to refine business process, define requirements, and drive deliverables in in the BI / reporting and application development areas.

Schaumburg, Illinois, Us

OMSNIC is the leading professional liability insurer for Oral and Maxillofacial Surgeons in the United States. As part of IT leadership team, was responsible for implementing and improving repeatable and standardized processes in IT and business areas to improve efficiencies and quality and driving improvements in the policy and claims management systems. Lead major upgrades of core business software (DuckCreek Technologies Full Suite – Policy / Billing / Claims) and website, the implementation of comprehensive BI solution (DCT Insights), and introduction of a comprehensive automated test strategy. Some highlights:- Identify areas of inefficiency throughout the organization and address with either process re-engineering and/or automation- Manage various projects (ranging from 8 to over 20 onshore and offshore team members) including DCT Insights data conversion project and new website implementation to on-budget and on-time delivery.- Lead functional side of new website implementation and subsequent enhancements. Major deliverables include quick quote, full quote, credit card and ACH payments, recurring payment, and electronic document availability- As IT leader, worked with technical team to identify and prioritize technical debt and processing efficiencies within our core systems, reducing development and testing time by as much as 50%. - Lead data validation effort for DCT Insights implementation. Also lead requirements gathering, documentation and prototyping for the new reporting / analytics solution.- Managed product road maps and prioritized backlogs through collaboration with business areas by creating and enhancing epics, features and stories and defining acceptance criteria for the dev team- Established processes and standardization within IT- Created comprehensive test automation strategy for core applications and website and assisted with technical implementation of natural language tests (Selenium / Gherkin / SpecFlow).

Trusted adviser to Data and Integration Services team responsible for requirements gathering, scoping, design, development, QA, delivery and documentation of numerous reporting and analytical applications for various business areas. Some highlights:• Team lead / lead developer that designed, developed and implemented analytical application (Crystal Dashboard, Webi, Crystal Report with DB2) for agents use to reduce attrition. Application was responsible for 3.25% change in attrition which resulted in retaining over $200 million annually in premium.• Dev lead on agile team that created Qlikview apps with DB2 data source for claims management to assist with reduction of total claim cycle time, staffing level management and customer experience improvement.• Architect of Qlikview data solution for claims area using 3-tier architecture with comprehensive incremental load strategy that processes over 1 billion rows nightly.• Develop SQL and QlikView scripts as well as configuring front-end UI.• Meet with business users regularly to understand their needs, show them capabilities and guide them in industry best practices as they honed their requirements. Presented prototypes and mockups to help drive discussions and expedite decision making.• Receive ad-hoc business question and priority requests from management and quickly create and execute queries, develop reports and provide actionable results. • Create robust development and testing methodology for BI applications which included a standardized approach to coding, development templates, test plan templates, test record identification utilities, test result comparison utilities and related documentation.• Represent systems area in requirements and design sessions, assist in KPI definition and application design, provide demos of applications to gain feedback iterate.• Build relationships between the various technical areas and the functional areas to achieve business goals.

Newtown Square, Pennsylvania , Us

Consultant primarily in the insurance / financial services sectorActed in role of trusted advisor to both the business and technical teams of clientsResponsible for creating and refining requirements, leading development teams for reporting and dashboard solutions (operational and analytical), doing development work and iterating quickly to satisfy business needs.Acted as trainer / mentor for junior team members and for inexperienced teams in other areas of the organization.Technologies / areas primarily worked with include Business Objects Suite (Designer / Webi / Crystal Reports / Xcelsius), DB2 SQL, Data Modeling and Integration, technical and business documentation. Highly proficient in all.

Us

Onsite Consultant Manager at City of Chicago handling reporting and analytics in Business Objects for HR and payroll systems.

Us

Successfully implemented ORACLE 11i (11.5.4) GL, Purchasing, Accounts Payable and Accounts Receivable modules. Served as data conversion team lead / lead conversion business analyst on a system conversion and data migration project (mainframe to ORACLE Financials 11i).• Lead the data conversion team. Gathered, analyzed, defined and refined data extract / data loading requirements.• Briefed stakeholders on best practices in Oracle Apps functionality. Mapped and gapped business processes and data between Oracle Apps and legacy system as well as mapped existing legacy data to Oracle table structure.• Utilized Application Implementation Methodology (AIM) documentation to set-up and configure charter of accounts as specified.• Prepared data conversion plans for each module and step-by-step procedure manual for go-live conversion and system cut-over.• Identified and resolved functional set-up issues for GL, PO, AP and AR.• Created SQLLoader control files and PL/SQL scripts. Configured and utilized ETL tool for conversion.• Developed a QA strategy for data migration verification process. Performed preliminary work in preparation for verification process. Created and maintained a user-friendly project database to store and track project issues and status using MS Access.• Converted Budgets, Journal entries, Vendor files, Requisitions, open PO’s and open invoices from legacy system to Oracle 11i (11.5.4).• Provided leadership to and acted as a technical resource for Conversion and QA teams.

Chicago, Il, Us

Successfully designed, developed and implemented automated regression test solution for ITS. Lead QA team during period prior to July 2000 release, developed test plans and worked with developers to resolve defects of both batch and online components.• Designed, created, tested, executed and maintained automated regression testing system comprised of over 20 separate data driven WinRunner test scripts, their test plans and input files, over 40 custom WinRunner functions specific to ITS online systems and the GUI map used by WinRunner components.• Developed test strategy and methodology for automated online regression testing project. • Developed scripting standards for online team to follow when creating or updating WinRunner scripts and prepared manual containing documents outlining scripting standards, custom functional specs and change management procedures for team.• Performed code reviews of scripts created by other team members; assisted team members with their scripts at design stage and provided feedback throughout development of their work.• Acted as primary technical resource for client QA team.

Chicago, Illinois, Us

Consultant at CNA

Northbrook, Il, Us

Subcontractor to Accenture (previously Andersen Consulting) working at Allstate Insurance on an online systems maintenance project.

Toronto, Ontario, Ca