Data Analyst

Liliya Franke

*** ***** ***** ****, ***** Hill, Texas 75104 ● 214-***-**** ● ******.******@*****.***

Summary of Qualifications:

* ***** ** ********** ******* as a Data Analyst;

* ***** ** ****rience working as a Manager in Food industries;

Build comprehensive dashboards and reports using Tableau Desktop;

Work with Oracle and MySQL for reports;

Highly analytical team player with aptitude for quickly learning scrutinizing environments, to identify and prioritize needs/risks and develop solutions. Achiever with exceptional knowledge of international markets, business practices and trade regulations;

Analyzes and visualization of data by using Tableau software;

Collect data information from Diversity and Finance Departments. Worked on projects “Credit Card Spending”, “Ethnicity” etc;

Extensive computer training, including knowledge of multiple networking environments and business software packages

Skilled at learning new concepts quickly, working well under pressure, and communicating ideas clearly and effectively

Familiarity with process and Python software development; Develop tools to perform arithmetic calculations; Tested and implemented applications built using Python. Used Pandas (Python library) for Analysis

Education:

Master of Science in Computational Sciences, 2015

Texas A&M University – Commerce, Commerce, Texas GPA: 3.62

Master of Science in Biotechnology, 2008

Mordovian State University Ogareva, Saransk, Russia GPA: 3.2

Technical Skills:

Visualization Tools Tableau Desktop 8.2/8.1/7, Tableau Server 8.2/7,Tableau Reader.

Programming Languages: C, C++, Python, iOS Programming, Java,

SAS, MySQL, Tableau Software;

Web Technologies: HTML, XTHML

Other Tools: MS Office 2003/2007/2010, Pages, Notes and other X Mavericks (Apple) softwares

Operating System: X Mavericks (Apple – Macintosh), UNIX, LINUX, and Windows OS Family.

Projects & Certifications:

Creating functions: linear and vectorized functions, arrays, 2 dimensional arrays; knowledge of using Canopy, library, GUI;.

I showed examples of using kNN on the MNIST data set from sklearn, in order to tried and classify hand written digits. We broke the data into 3 sets, a train set, a test set and a validation set. Recalled, when trying to tune a model, used the validation set to tune our performance (e.g. while tried different values for k, or tried to tune other model parameters). Found a good value for k, and tried and improved the kNN performance as much as possible on the MNIST digit classification. In addition to searching for good k neighbor parameters, also tried of using uniform vs. distance weighting, also tried changing the p parameter to see if different methods of measuring similarity or distance have any effect. Read and use Monte Carlo Simulation in calculating the probabilities.

Project: A back-propagated neural network is used in the classification of breast cancer diagnosis. The classification uses nine real data features from a fine needle aspiration (FNA) of a breast mass to distinguish between malignant or benign tumors. The goal of this project was to find the most accurate classification of the fine needle aspiration (FNA) dataset using the back-propagation neural network. Variations to the backpropagation neural network include changing the learning rate, momentum, and the number of hidden layer neurons. By running these variations on the neural network, a 94.5% accuracy in prediction of breast masses as malignant or benign is obtained. The dataset that was used in this analysis was obtained from University of California Irvine Machine Learning Repository. All calculation and probabilities were made by Python.

“Learn ABC”

Created, developed, and launched an application for iPhones and iPads. (2014)

“Logarithm and Power Function to Modify An Image”

Created in Image processing, where a dangerous weapons when concealed would be identified using heat capture and image processing applications by the help of MATLAB software and JAVA programming. (2014);

“CKY ALGORITHM”

Created for Automata Theory, which would identify word formations by the implementation of concepts of Automata Theory. (2014);

“ Fitness Club Model Relational Database”

Created a relational database for a fitness club with ER diagrams and run database and perform SQL operations.

“Real time store ordering and Management (Java Project)” The goal of the project is to demonstrate the multithreading to accept multiple orders. Utilization of swings to display the GUI.

Certificate of professional Development, 2009, Russian Economical Academy, Moscow, Russia

Certificate of Fundamentals of Personal Computer Users, 2006, Russian Union of Scientific and Engineering Organizations, Saransk, Russia

Work History:

Business Intelligence Analyst, 03/2015 - 09/2015

Dallas Area Rapid Transit, Dallas, USA

These projects had dealing with the Finance, Diversity and EEO Departments. I was modeling and developing programs(reports) for the Departments. Created ideas of the visualizations. Worked together as a team with developers and DB admins. The reports needed to be designed to allow them to pull diversity reports as well as card holder spending patterns. The projects saved them an estimated $150,000 per year. I presented my work every 2 weeks for receive feedback for desired additions or changes. I also had to teach the departments' managers how to use the reports in Tableau Software.

Collect data reporting and visualization requirements from the clients departments.

Document data retention schedule by consulting with the client department.

Determine data source and mechanism for data access to be used. Design, code and deploy data capture mechanism as necessary.

Determine whether objects need to be created in the data warehouse to store the transaction data sets, work with IMaDS staff to get supporting objects created.

Design and implement the reporting and analytic user interface using the agency’s Tableau software platform.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles,Histograms, Bullets, Heat maps and Highlight tables.

Deploy environment with the help of the IMaDS Tableau administrator to the client department.

Conduct and user acceptance testing and obtain client department sign-off that the project is

complete.

Publish dashboards and share them with colleagues, partners and clients.

Involved in creating dashboards by extracting data from different sources. Created dashboard using parameters, sets, groups and calculations.

Created report schedules, data connections, projects, groups in Tableau server.

Provide technical support for existing reports, dashboards, or other tools;

Collaborate with Developers/ Database Admins as needed to isolate root cause of defects

Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

Performed SQL reporting with the ability to create SQL views and wrote SQL queries.

EXPERIENCE/KNOWLEDGE & SKILLS

Excellent technical knowledge of laptop and desktop hardware.

Working technical knowledge of current protocols, operating systems and standards.

Ability to operate tools, components and peripheral accessories.

Microsoft Desktop Support Technician an advantage

A+ and N+ experience

Software and Hardware Troubleshooting

Windows XP, Windows 7, Windows 2000/2003/2008.1 experience

Routers, switches and firewall experience

Microsoft Office 2007, Office 2010 support

TCP/IP

SQL

Manager / Engineer-Technologist, 8/2008 – 8/2011

Lamzur JSC, Saransk, Russia

Over 3 years of experience working in food technology

Monitored and maintain food processing, food machinery, food packaging, ingredient manufacturing, instrumentation and control.

Maintain quality standards for various portfolio management systems

Managed a team of 16 people.

Researched and development of new ingredients for cookies and crackers

Monitored and maintain strict compliance with production processes.

Developed and approve new recipes. Design and execute new product line test runs with the production team.. Expand existing products and introduce new products to the Lamzur line.

Develops food standards, safety and sanitary regulations, and waste management and water supply specifications.

Head of Department for clinically approved sanitation technologies and disinfectant products.

Honors:

Recipient, TPEG Grant Resident Graduate Scholarship, Spring ‘14

Recipient, Pride Graduate, Scholarship, Spring ’14

Languages : Russian, English

Contact this candidate