Michael Wright

BI Developer/Consultant and Insurance Assistant

I am a BI Developer/Consultant and Insurance Assistant. Created SSIS packages with which data from different resources were loaded daily in order to create and maintain a centralized data warehouse. Made the package dynamic so it fit the environment. Designed and implemented a snowflake -schema Data Warehouse in SQL Server based on the existing data warehouse & SCS auto operational database. Developed schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables. Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations. Managed and developed existing and new ETL processes for SQL Server reports. Refreshed staging tables with ETL. Scaled SSIS to make it work more reliable. Wrote enterprise reports and stored procedures upon requests. Designed report models to meet business requirements and allowed users to perform fast queries. And I'm a Insurance Assistant and managed new and renewal policies received from offices nationwide. Managed assignments to a team of 20 internal and 4 external policy analysts within a 24 hour turnaround. Analyzed new or renewal policies against the binder and the expired policy for accuracy. Created underwriter reports weekly and communicated missing information to team leaders. Created letters documenting contract and endorsement changes to client. Handled phone and email inquiries from regional offices, identified and resolved problems.