Lead Data Analyst Resume
Chicago, IL
SUMMARY
- I am a creative and passionate Senior Data Analyst experienced in working with various technologies.
- An inquisitive mind, with a fierce thirst for knowledge and a demonstrated ability to think critically, allow me to identify and implement customized and elegant solutions.
- Experience working in flexible environments and dedicated to learning and improving make me a valuable asset to any team.
TECHNICAL SKILLS
Languages: HTML, CSS, Java, Junit, JavaScript (JQuery, AngularJS), Swift, XML, Ruby on Rails, C, Python, R, SQL
Database Tools: Google BigQuery, Google PLX, MySQL, Confidential, SQL Server, Confidential, Hadoop
Business Tools: MS Suite, MS Project, MS Visio, MS Excel, Google Sheets
Testing Tools: Selenium Webdriver, Selenium IDE
Development Tools: Eclipse IDE, IntelliJ IDE
Data Visualization/Prep Tools: Tableau, Tableau Prep, PowerBI, Alteryx
PROFESSIONAL EXPERIENCE
Lead Data Analyst
Confidential, Chicago, IL
Responsibilities:
- Manage a team of 3 data analysts and 1 senior data analyst for the Strategy & Insights team.
- Work strategically with the business to drive new insights that optimize company growth and expansion.
- Create dashboards for executives to make data driven decisions and monitor the impact of those decisions.
- Design experiments and projects to explore new geographic locations and improve performance in existing areas.
- Primarily using SQL, Python, and Tableau to ingest and report data.
- Frequently interface with internal stakeholders to manage expectations and outcomes.
Business Intelligence Consultant
Confidential, San Francisco, CA
Responsibilities:
- SME on data strategy and data visualization best practices.
- Used Tableau to provide multiple teams with easy to use analysis tools.
- Used SQL to write customized and flexible queries for ad - hoc requests or reporting.
- Provided best in class, high quality dashboards/tools to the client.
- Worked with multiple tech clients to consult on reporting best practices.
Business Intelligence/Data Analyst
Confidential, Sacramento, CA
Responsibilities:
- Created Data Models to source data from cost, schedule, and risk systems to feed into Tableau dashboard.
- Used MS Access to design SQL queries and forms (via VBA) to automate data for cost analysis.
- Integrated data across all functional groups (cost, schedule, risk, safety, quality, etc.) that highlighted key critical issues, risks, and areas where executive focus is required.
- Advised executives and senior management on desirable KPIs and best practices for visualizing data to extract actionable insights.
Business Systems Consultant
Confidential, San Francisco, CA
Responsibilities:
- Led the business effort to automate marketing data and consolidate it into a centralized big data environment on Hadoop.
- Used SQL Confidential to perform discovery and analysis on LOB source systems and databases.
- Utilized business knowledge to advise LOBs on most effective methods of data automation into target databases.
- Instructed and led other team members in creation of various business artifacts.
- Reviewed SAS scripts and translated scripts into working SQL queries utilized for analysis.
Business Systems Consultant
Confidential, Sacramento, CA
Responsibilities:
- Participated in Sprint Planning meetings and helped assign Story Points to user stories. Worked with the client to understand requirements and document what was important for the client.
- Spent time with various stakeholders and user groups gathering and documenting business requirements and translating them to functional requirements.
- Used MS Suite to conduct technical/ non-technical presentations for management.
- Used MS Project for managing resource allocations, progress of project, and budget costs.
Business Analyst
Confidential, La Jolla, CA
Responsibilities:
- Built an app for college students to be able to find parties in a student exclusive community that allowed for geographic location check-in, real time rating system, and ability to charge for cover.
- The App (PartySource) was selected as top 3 in the class and was promoted to be pitched at a San Diego Convention Center for potential business investors.
- Created a business model designed to double the amount of users every year after the first 2 years. The model assumed spreading the app into neighboring UC colleges within California and then spreading to states in the West Coast.
- Conducted market research and spoke with different communities to determine the business case for the application.
Web Developer
Confidential, La Jolla, CA
Responsibilities:
- Managed a medium sized staff of up to 20 people and coordinated between different staff members for posting and publishing of articles.
- Created reports using data from google analytics to understand how viewership can be improved.
- Used HTML5, CSS, JavaScript, Dreamweaver, Photoshop to revamp and maintain the website.
