Software Engineer Senior
Resume:
Name: Lei Song
Contact Information: ********@*****.***
Professional Experience
GEICO Full-Time Employee
April 2000 – September 2024
Senior Software Engineer, ETL Architect, Enterprise Data Warehouse Architect
Achievements and Skills
●Extensive experience in database modeling, design, and development.
●Proficient in ETL, BI application software, database development, and automation.
●Strong ability to design and develop complex systems and tools.
●Excellent data analysis and reporting skills.
●Experience with ERWin, Snowflake, DB2, SQL Server, AB INITIO, DBT, C#, SSIS, SSRS, Power BI, ASP.NET
●Awarded the Year of Heroic Customer Service Award.
RAD Research and Innovation Department
●Designed and developed a simulator for the Apollo sales system.
Created a comprehensive Rating Factors Management System that consolidates multiple factors with various versions and lines of business into a single database. This system generates diverse factor sets tailored to new product development based on specific business requirements.
Implemented a robust process to compare policy premiums and intermediate factor values between the simulator and the sales system, ensuring accuracy and consistency.
Developed a re-scoring system that evaluates policy premiums and intermediate values processed by different factor sets, significantly improving new product development efficiency and reducing both time and costs.
Designed and Developed a state-filing tool to automate the generation of state filing documents. This tool allows business users to configure the system for different states and lines of business with various versions through a web interface, enabling automatic document generation. This application is applicable to multiple states, multiple years, and multiple lines of business state filings.
Produced numerous reports based on results from the Apollo IT system.
●Developed the Commercial Auto team in generating commercial underwriting rating scores system.
IT, Decision Science and Transformation, Data Warehouse Department
●Designed and developed an Enterprise Data Warehouse system, including Metadata System, ETL data process flow, Integrated policy data and BI projects.
●Participated in the design and development of the Warren Buffett report database and ETL data processes, providing senior management with sales, service, and claims operational information for the company.
●Led the design and development of the homeowners, renters, condo and boat lines of business (MOAT) BI database, converting and cleaning data from MOAT partner companies to GEICO standards and generating various reports for business users. Analyzing post-release changes and providing actionable recommendations for application enhancements. Significantly accelerated data delivery to senior business leaders by standardizing and automating partner data feeds, reducing manual work and improving data quality and insights.
●Created and implemented a Scorecard system for monitoring sales, service, and claims personnel performance to improve the quality of service and coaching
●Designed and developed the Survey System, Internal Fraud System, Call Center Report System and Job Post System. Created and implemented the Staff Development BI Database and staff ratio report system, integrating employee information with evaluation data to generate performance reports.
Trade Compass, Washington, DC
March 1998 - April 2000
Senior Software Engineer
●Responsible for the design, development, and maintenance of the company’s network, database, and websites.
●Designed and developed user registration, management, payment, search engine, and usage analysis systems.
●Developed the Trade Smart and US Trade Analyzer (USTA) systems, Import/Export system (STATUSA, National Export Offer Service (NEOS)), Sailing Schedules, Air Cargo Schedule, Ocean Transit Analyzer, and Tracking System.
●The Trade Compass website was ranked among the top five international trade websites and ran for several years without any maintenance.
●The development team’s (only 4 IT developers) methodology was used as a teaching case by professors at Cornell University's School of Business.
Education
●MS in Computer Science, The Johns Hopkins University
Majored in System and System Software.
●BS in Civil Engineering, Tsinghua University
Majored in Structural Engineering.
Contact this candidate