Surain Badalian
Los Angeles,CA
Summary
Sr. Data Analyst with more than 11 years of experience analyzing, troubleshooting, leading projects, assisting with creating advanced methodology, logic and providing solutions, pulling complex data, creating data quality tools, dashboards and high-level reports. Analyzing massive data with creating charts and stored procedures, training users on different reports, tools. Work with management, federal data governance department, LA mayor office, LA city and county departments, lead and produce very complex reports i.e. Federal reporting and data quality tools, homeless count reports and many other high level reporting and data.
Overview
15
15
years of professional experience
Work History
Sr Data Analyst
Los Angeles Homeless Services Authority
09.2016 - Current
- Assisted in developing, and maintaining revenue management reports; developed and enhanced reports by using Microsoft SQL server and SSRS.
- Develop, maintain and oversees complex data quality reports and tools: leading US department of housing and urban development (HUD) federal agency data governance requirements and reporting data quality and submission deadlines.
- Manager, analyze a massive data by using advanced SQL queries and stored procedure.
- Write, run SQL queries, and provide an indexing to perform test and efficient searcher with the company database.
- Maintain, lead, oversee and develop dashboards by using different tools, i.e. looker, Power BI, Tableau.
- Lead a project of many projects with a budget of 5 million, as created data quality process, reports requirements and development, compliance standard, database enhancement and train more than 500 users on data validation, reports and data quality process.
- Created a standard and massive data, stored procedure, and charts, daily and weekly reporting process to the mayor office, city and county of LA.
- Manage and maintain sharing weekly, quarterly and monthly reports by using Ms share point tool.
- Documentation and reporting skills: review requirements, collaborate with team and developers, perform validation, assist in coordinating implementation of reporting, technical skills to review developed reports logic, modify, enhance, and fix reports logic.
- Experience with data warehouse, build and create queries in order to pull varies and massive data sets.
- An ability to manage and develop integrations with third party systems/database.
- Strong qualitative, analytical and problem solving.
- Develop an existing custom reports by creating new queries or coding new processes.
- Ability to troubleshoot issues and apply fixes with an existing custom and management reports by using the reports writing tool.
- Initiate ideas and seeks solutions for specific opportunities that enhance the performance of QA and our business partners.
- Applies appropriate test to analytical results to provide high quality and accurate results.
- Advanced experience presenting and communicating/recommendations to cross-functional teams/ and leadership.
- Develop and conduct clear, concise/reports training(s), and presentations.
- Operational lead responsibly: process data, build complex queries, review, test and provide reports feedback, communicate to internal and external users, report to city & county of LA, report to upper management and monitor progress of assigned projects.
- Created many power points and videos to walk through new developed reports and end user database.
- Review and analyze company and providers data to ensure consistency and accuracy through entire project.
- Streamlined data analysis workflows for increased efficiency and faster decision-making processes.
- Leveraged text, charts and graphs to communicate findings in understandable format.
Data Analyst
Los Angeles Homeless Services Authority
04.2011 - 08.2016
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Conducted and led quality assurance reports training to internal and external users.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Participated in requirements meetings to understand business needs.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Developed and created advance SQL queries, and ongoing custom in house reports.
Database Design and Project Development
Levelthree Solutions
06.2009 - 12.2009
- I worked as an internship at levelthree imaginative solutions company at product development and creative services department.
- Developed second version of invoicing application to support multiple divisions within one account.
- By using SQL Microsoft access, visual basic and access 2003.
- This helped the accounting department to broadcast the reports automatically generate to the client companies.
- Updated daily, monthly, and quarterly excel reports with the pending and invoiced orders for Managers with the final analyzing of sales amount and the % of the sales from the company goal.
- Tracked and solved problems in an existing database system and create reports with the solutions.
- Created new versions of an existing database to run them easier and tracked the project requests in centralized database.
- Established strong relationships with suppliers, ensuring timely delivery of quality components for projects.
- Broadcast new projects on the existing gateway.
- Conducted root cause analysis on recurring issues, developing targeted solutions for long-term resolution.
Education
Intro R Programming
University of California - San Diego
Online09.2023
Python Programming I: Information Technology -
UCLA Extension
Los Angeles, CA01.2018
Course of Intermediate and advanced SQL: Information Technology -
UCLA Extension
Los Angeles, CA01.2014
Course of Linux OS: Information Technology -
UCLA Extension
Los Angeles, CA01.2011
Master of Science: Computer and Electrical Engineering -
New York Institute of Technology
New York, NY01.2008
Bachelor of Science: Electrical & Electronic Engineering -
Al Technology of University Baghdad
01.2005
Skills
- Data Analyst
- Microsoft SQL Server
- Advanced SQL Query
- Share Point
- Microsoft Excel
- Operation and project management
- Data Quality
- Problems solving and troubleshooting
- Advance Analysis
- Power point
- MS SSRS Reports writing
- Statistic
Timeline
Sr Data Analyst
Los Angeles Homeless Services Authority
09.2016 - Current
Data Analyst
Los Angeles Homeless Services Authority
04.2011 - 08.2016
Database Design and Project Development
Levelthree Solutions
06.2009 - 12.2009
Intro R Programming
University of California - San Diego
Python Programming I: Information Technology -
UCLA Extension
Course of Intermediate and advanced SQL: Information Technology -
UCLA Extension
Course of Linux OS: Information Technology -
UCLA Extension
Master of Science: Computer and Electrical Engineering -
New York Institute of Technology
Bachelor of Science: Electrical & Electronic Engineering -
Al Technology of University Baghdad
Similar Profiles
Anais LaresAnais Lares
Site Coordinator at LAHSA-Los Angeles Homeless Services AuthoritySite Coordinator at LAHSA-Los Angeles Homeless Services Authority
Alejandra MendozaAlejandra Mendoza
HET Member Roadmaps at Los Angeles Homeless Services Authority (LAHSA)HET Member Roadmaps at Los Angeles Homeless Services Authority (LAHSA)
Derrick MosleyDerrick Mosley
Technical Advisor at Los Angeles Homeless Service AuthorityTechnical Advisor at Los Angeles Homeless Service Authority