Andy Hahn Email & Phone Number

Atlanta, Georgia, United States

Administrate and develop in Informatica Cloud, SQL Server, Snowflake Cloud, AWS (IAM, EC2, RDS, S3, Lambda, EventBridge, Cloudtrail), PostgreSQL, Pyramid Analytics, Bitbucket, Github, SFTP, Proprietary Software, Microsoft 365 and support on and offshore software engineering teams as lead for providing SAAS data and analytics solution for Properties and Casualties insurance companies.

Alpharetta, Georgia, United States

Contracted to create secure financial data loads using encryption and masking technics.

Alpharetta, Ga

• Managed onsite, virtual, and global BI data warehouse development teams working in an Agile environment operating in 2-week sprints with daily standup meetings utilizing LEAN methodologies for over 40 live production customer projects• Increased efficiency, effectiveness, and morale of developers by promoting team cohesiveness and training; reduced outstanding production tickets by 95% with 30% less staff• Designed, implemented, and enforced standards for data warehousing best… Show more • Managed onsite, virtual, and global BI data warehouse development teams working in an Agile environment operating in 2-week sprints with daily standup meetings utilizing LEAN methodologies for over 40 live production customer projects• Increased efficiency, effectiveness, and morale of developers by promoting team cohesiveness and training; reduced outstanding production tickets by 95% with 30% less staff• Designed, implemented, and enforced standards for data warehousing best practices, BI architecture, documentation, data load automation, and operational processes• Participated in all phases of SDLC for designing and implementing data warehouse and MDM solutions for several medium to large insurance companies with diverse lines of business and multiple source systems • Successfully completed data warehouse projects from scratch by creating custom end-to-end ETL processes and data marts using Informatica PowerCenter and T-SQL• Analyzed, designed, implemented, optimized, and maintained custom SQL Server Analysis Services Multi-Dimensional Cubes (SSAS)• Effectively collaborated with clients to gather requirements and resolve issues or develop solutions for their SaaS reporting environments• Mentored developers of all levels on developing complex code and adhering to best practices and standards to promote professional growth and efficiency via biweekly lunch and learn sessions• Created operational processes for SQL Server 2008 R2 to 2014 and Informatica 8.6.1 to 9.6.1 migrations• Collaborated closely with system administration and network engineering teams to create new ODBC connections, establish new or adjust existing VPN tunnels, optimize server and software configurations, implement encryption, and manage security users and roles• Guided and collaborated with project manager weekly on production support and new development tasks and priorities• Interviewed developers and project managers and worked closely with internal recruiter in hiring process Show less

Atlanta, Ga

• Purchased rights to develop 5-store territory• Developed and streamlined operational processes, some of which became standard for corporate and all franchisees• Developed various enterprise reporting tools to increase efficiency and a greater focus on operations for Five Guys store managers, corporate district and regional managers, and franchisees• Evaluated and helped implement a restaurant device focused on improving food safety and store operations. Served as beta tester and… Show more • Purchased rights to develop 5-store territory• Developed and streamlined operational processes, some of which became standard for corporate and all franchisees• Developed various enterprise reporting tools to increase efficiency and a greater focus on operations for Five Guys store managers, corporate district and regional managers, and franchisees• Evaluated and helped implement a restaurant device focused on improving food safety and store operations. Served as beta tester and liaison for franchisor • Managed staff of over 70 employees. Held regular meetings with management teams. Implemented team building strategies. • Worked closely with corporate district managers in continually improving operations• Processed biweekly payrolls, handled daily bookkeeping, reconciled monthly bank statements to ledger, managed accounts payable, and filed monthly sales tax. Established and maintained vendor relations and negotiated contracts. • Handled marketing campaigns and developed community relations Show less

Mclean, Va

• Managed team of database developers and data analyst• Supported processes that loaded production data warehouse• Designed and developed databases and ETL mappings and workflows from scratch per business requirements• Created views and stored procedures to automate quality control and fulfill client deliverables• Mentored other developers on ETL processes and troubleshooting techniques• Handled source control for code and document versioning using MS Visual… Show more • Managed team of database developers and data analyst• Supported processes that loaded production data warehouse• Designed and developed databases and ETL mappings and workflows from scratch per business requirements• Created views and stored procedures to automate quality control and fulfill client deliverables• Mentored other developers on ETL processes and troubleshooting techniques• Handled source control for code and document versioning using MS Visual SourceSafe• Led Visual Fox Pro 2.0 to SQL Server 2000 migration using DTS packages• Identified bottlenecks and optimized data processes to achieve greater efficiency• Coordinated projects with CTO, database administrator, data analysts, and account managers as necessary• Scoped, planned, managed multiple projects simultaneously• Managed database backups and schedules• Designed and implemented team intranet site Show less