SUMMARY:

• 8+ years of experience working with data utilizing SQL, Excel Pivot Tables, V - Lookup, VBA, Access, and SAS generating reports in Crystal Reports and staff on data integrity
• Experience with Database management and development, data integrity, report generation, and extracting reporting requirements
• Excellent analytical (qualitative and quantitative) and communication (written and verbal) skills
• Entrepreneurial mindset, including ability to work independently, self-motivate, and propose and implement new initiatives
• Ability to think strategically, handle ambiguity, and problem solve in a fast-paced, limited-structure, multicultural environment
• Ability to be effective in high-pressure situations, handling multiple tasks simultaneously, and set priorities

TECHNICAL SKILLS:

• IBM Initiate
• SQL, Excel (Pivot Tables)
• Word, PowerPoint
• Salesforce Administrator
• Financials and GAAP
• SAP Business Objects
• SAS (EG&PC), SAS DI, SAS Visual Analytics
• JAVA Script (Mobile App Development)
• SPSS
• Visual Basic
• IBM AS400
• Epic ( Confidential Health)
• R-Statistical Software
• Data Management Methods
• Mathematical/Statistical Modeling
• Data Taxonomy
• Quality Measurement Methods
• Business/Finance Principles
• Program Evaluation Methods
• Health Insurance Business Principles
• Medical Data
• Strategic Insights Development
• Media Analytics

PROFESSIONAL EXPERIENCE:

Confidential -Glendale,CA

Data Analyst

• Using Excel to summarize research data
• Creating an Access Database to warehouse results
• Using R to conduct indepth analysis of results and presenting to stakeholders.

Environment: Excel,SQL,Data Analysis,Project Coordination,Access

Confidential -Burbank,CA

Senior Trade Revenue Management Analyst

• Re-writing SQL Modifications to better reflect and attain Financial Metrics such as Net Revenue on Sales Planning team
• Creating an automated flow-through of live data from Proprietary database (Teradata) to Tableau for the purpose of developing robust Dashboards for Directors and Vice Presidents.
• Re-writing SAS code to better reflect accurate Sales and Forecasting numbers during Data Validation of Quarterly Reports.

Environment: SAS, SQL, Tableau, TeraData, Financials and Sales Analytics.

Confidential- Santa Monica, CA

Financial Operations Analyst

• Tracking monetization efforts using Data from Nielsen, Salesforce, and Internal systems to create Match criteria in SQL script that would accurately combine Data from different sources.
• Developing automation practices in Ad-Operations team with Sales Finance, Salesforce Development group, and Advertising Managers to ensure Self-Service and Sales Business lines can accurately share data.
• Creating new Advertising Metrics for different Product lines and conducting analysis (Using SQL) on effectiveness of various advertising campaigns.
• Environment: Nielsen, SQL, Google Docs and Analytics, Salesforce

Confidential - Santa Monica, CA

HRIS-Data Analyst

• Automating HR Reports in Oracle Fusion/ Taleo, transforming Data into Excel and Access, Presenting Analysis in PowerPoint. Developing.
• Creating Insights into HR Data for C -Level Executives using Excel and Vizier Workforce Analytics.
• Developing Automated Data Validation Processes for Government Compliance Reports in Excel.
• Environment: Oracle Fusion/Taleo, Vizier Workforce Analytics, Excel, Talent and Compensation

Confidential, Irwindale,CA

Business Analyst-3

• SAS Conversion, Using SAS and R to conduct extensive analysis on Call Center Performance
• Creating Quantitative and Qualitative reports. Pulling Data in SAS and summarizing in Excel or Access. R for Analysis. Building Data warehouses in Access Project Managing Data Repository tasks
• Streamlining reports and creating more Scorecard-style reports to prevent on-demand requests and data dumps.
• Environment: SAS EG, PC SAS, SAS DI, SAS Visual Analytics, Excel, R, Crystal Reports

Confidential- Burbank, CA

IT Development Manager

• Forensically Investigating IT Infrastructure, Processes (Hardware and Software) after sudden departure of VP of IT and layoffs. Developing comprehensive documentation of all IT Processes.
• Creating Company-Wide Credentialing system for a multitude of Applications/Programs
• Creating and managing Innovative IT Ticketing program providing root cause analysis
• Creating documentation and set-up seminars to train on IT and Data Issues with solutions. Advertised as resume boosters or as new ways to become valuable to organization. Federalized IT and Data Programs
• Created over 150 new metrics (Sales/Marketing) company-wide working with various stakeholders
• Developed product visibility and customer acquisition metrics
• Managing back-end Web-Site sales and Mainframe
• Developing different Testing environments to test products
• Leveraging integration server with 15 applications that acted as a "Virtual Product Manager"
• Salesforce, Intacct, Avalara, Akamai, and Office Suite Administrator
• Developing back-end SQL Data warehouse monitoring integration and sales
• Managing vendors and IT budget priorities, budgeting analytics
• Creating IT infrastructure to test products
• Managing Google Analytics Data and creating a framework for strategic insights
• Environment: SQL, Crystal Reports, C#, .NET, Akamai,Cloud-Based Applications, Google Analytics, Salesforce, Intacct, Avalara,Marketo

Confidential, Thousand Oaks, CA

Project Manager-Human Resources

• Developing and revising reports in SAS to better integrate with Workday Network
• Developing analytical tools in SAS with a focus on talent and compensation
• Creating metrics by reviewing internally promoted employees through performance reviews to establish a smoother transition into role
• Developing predictive analytics framework for Human Resources needs
• Environment: SAS,Taleo, Workday, Talent and Compensation, Global HR Benefits, SAP HCM

Confidential - Canoga Park, CA

Database Analyst

• Repairing and Developing Access database for investment services company
• Mapping data between Excel and Access. Data Scrubbing
• Wrote Macros and Formulas for both Excel and Access to deal with complex financial calculations
• Creating dashboards and developing Marketing Analytics Reports for President
• Created and improved infrastructure for process improvement. Established workflow via Visio
• Writing SQL queries from scratch to extract legacy data and establishing data lineage for data warehousing
• Translating sales and marketing requests to technical development

Environment: SQL Server 2008, Access,Excel, Macros for Financial Analysis, Marketing Segmentation

Confidential, Burbank, CA

Business Analyst

• Customizing insurance benefits for Account and Sales Managers
• Using Access and SQL to pull benefits information. Ensured process integrity of benefits selections
• Creating benefits tools to assist in analysis, and presented benefits analysis to Account and Sales Managers
• Analyzing and assembling insurance packages while assuring the following of company guidelines and state compliance
• Environment: SQL, Access, Executive Account Management

Confidential, Westwood, CA

Data Quality Analyst

• Identifying and developing framework for picking Data Stewards and explaining data lineage process
• Developing standardization techniques and data definitions by working with various stakeholders throughout Confidential Health
• Developing data warehouses for various departments in SAP and created Data Lineage materials
• Creating a framework from how to collect data from various front-end resources, established front-end controls, and used various vendor tools such as IBM Initiate to accurately combine and match data
• Establishing a Master Confidential t Index and creating materials for staff
• Environment: SQL, Excel, IBM Initiate, Multiple EPIC Modules, Gathering Business Requirements

Confidential, Los Angeles, CA, US

Product Management Analyst

• Creating scorecards, running weekly, and monthly report and created Macros to run reports from SAS EG to Access Database to Excel while utilizing extensive SQL
• Earned Kudos from Farmer's for report catching agent manipulation and saved the company over $100,000 alone in California and still in the process of calculating nationwide
• Maintaining and archived reports on SharePoint and internally developed database
• Imported/exported data from data warehouse in SAP to Access tables creating multiple data sets based on ad-hoc requests
• Creating and maintained tables, reports, and forms that are the basis of weekly, daily, monthly, and quarterly reports from Access
• Conducting extensive statistical and data analysis using SAS EG and R
• Conducting Forensic Data Analysis and transactional data analysis
• Building recurring reports and scorecards for directors and managers reflecting underwriting analysis trends
• Exporting queried results from SAS EG to Access, transforming the data
• Writing a high volume of SQL code and extensive use of SAS EG and SAP Business Objects to query data from company database
• Utilizing MS Office to present data
• Conducting qualitative and quantitative analysis and creating reports of data via ad-hoc requests and provided business insights in an accelerated environment
• Forecasting trends within reports
• Collaborating with different departments to gain insight into business needs to develop strategy as well as operational improvements
• Presenting to Business Users
• staff to query using SAP Business objects, Developed Universes in SAP
• High volume use of pivot tables, R to conduct and present analysis
• Environment: SQL, R, SAS EG, SAP, Macros, Excel, Access Database, SharePoint, Lotus Notes

Confidential, Hollywood, CA

Data Analyst | Specialist

• Strategic and operational implementation of Data Governance goals
• Maintained data integrity organization-wide by front-line staff on definitions provided by county and developing materials. Project Manager on Clinical Data Compliance
• Developed databases in Access, Excel, and ETO for First Place for Youth at Confidential House
• Created SQL Queries, using mathematical/statistical modeling, and translated analysis for program evaluation
• Accounting and Extracting IT Data from IBM AS400 as well as Census numbers
• Working with AS400 Consultant to establish better methods of extraction of Accounting Data.
• Transferred data from Excel data, Crystal Reports to Access Database. Created Access database to establish weighted index to balance out client needs and organizational resources
• Made presentations in PowerPoint for use by Development Department
• Used data mapping to properly identify unassigned data. Data Reconciliation
• Extracted, analyzed, and managed data including statistical analysis from the last five fiscal years to present to potential donors reflecting organization's outcomes as it related to our resources, modeling the trend in outcomes as it relates to resources
• Designed aesthetical and functional forms
• Managed daily data input
• Coordinated and streamlined data into wider organizational database
• Collaborated with and trained various department directors on quality assurance and government compliance issues
• Created spreadsheets and setting queries to ensure data integrity and Monitored staff and client performance to ensure compliance. Trained staff on software. Ensured documentation compliance
• Environment: Excel Data, Crystal Reports, Access Database, SQL Queries, PowerPoint, Project Management
• Gained insight to building singular database for the goal of establishing weighted index
• Created trust and advocated for homeless youth with risky behaviors to ensure following of organizational rules and standards
• Established self- economics workshops and events to create solidarity between staff and youth
• Provided paraprofessional counseling and gaining an understanding of human nature in the context of organizational dynamics
• Quality assuring Outreach department data
• Created data infrastructure, set queries to begin analysis to retrieve lost data, ensured integrity of current data, and facility
• Established quality measurement methods to help retain highest quality data
• Established Access Databases for Director for their recurring reports to the Board of Governors
• Trained them on some basic analysis
• Lead the Forensic Auditing of data in preparation for reports to Grantors
• Created new data collection system involving coordinating and managing different department data needs into one database using Access and Excel
• Managed the re-organization of Clinical Department Data ensuring transparency and integrity of Data submitted to grantors via Access
• Trained staff on how to create Access queries and monitoring their performance
• Environment: IBM AS400,Access, Excel, Forensic Data Analysis, Project Management

Confidential, Anaheim, CA

Data Conversion Specialist

• Operational and strategic planning to comply with OSHA regulations
• Moving data from proprietary database to Access Database into new Vendor Database and established data lineage
• Performing data scrubbing and developed a standard nomenclature for 12,400 items by researching manufacturer specifications for each unique product in Access Database while maintaining inventory of items
• Tracking database that had been using items and where it was located upon pick-up and return
• Conducting statistical analysis to monitor staff performance and compliance
• Creating cogent queries to clean out database of errant items. Data Reconciliation
• Developing queries for inspection procedures provided by Cal-OSHA. Using SQL to extract data from 72 vendor databases including data mining and SQL reporting services into Access Database Environment: SQL, Access, Data- mining, Forensic Data Analysis, Data Conversion

Confidential, Van Nuys, CA

Intern | Clinical Care Extender

• Project with Cardiac Catheter Lab: Assembling data for procedures conducted in catheter lab to determine insight into the relationship between staff performance and procedure punctuality
• Project with Corporate Office: Developing database with Alumni data from the last 10 years
• Setting queries for predictive analysis of potential Alumni who may act as mentors
• Personally cold-calling 600 Alumni to collect data then conducting analysis which was then reported to Director of Health Talent Innovations
• Using knowledge of Health insurance business principles in order help establish new SQL database using unassigned finance data to evaluate health insurance payments to client hospitals and using healthcare quality measurements(HEDIS) to track staff performance and Confidential t health outcomes
• Assisting Nurses, Doctors, and allied health care providers in various departments with responding to Confidential t and staff needs ensuring timely and accurate assistance while advocating Confidential t needs and concerns
• Providing administrative help to hospital staff and executives
• Environment: SQL database, data, analysis

Confidential

Benefits Analyst

• Analyzing benefits packages using SAS to determine third-party retention
• Creating multiple data sets for Director of Human Resources and Executives
• Using broad knowledge of business/finance principles to properly interpret data and conducted presentations to CEO and Controller presenting analysis
• Environment: Benefits Administration, Talent and Compensation, Business/Finance principles, SAS

Confidential, Burbank, CA

Administrative Clerk

• Interviewing up to 35 candidates daily in Spanish and English for positions for the large-scale temporary project
• Providing orientation for new hires
• Conducting payroll entry for 800 staff daily and worked in an accelerated environment that required versatility and flexibility
• Environment: Payroll, new hire orientation