MIRELA VOICULESCU
Attleboro,MA
Summary
Over 9 Years of experience as SQL developer, data analyst. Dedicated and motivated person, with strong abilities to solve problems quickly and effectively.
Overview
18
18
years of professional experience
Work History
Database Developer, Data Analyst
Bristol Community College
05.2014 - Current
- Assist business users with their requests to perform various ad hoc analysis and decisions
- Implemented business oriented star schema mart that help them tracking and analyzing financial detail around student activities
- Build and schedule jobs responsible to pull data from various areas of OLTP system and external sources and update data mart making use of Oracle external tables and SQL Loader
- Designed metadata driven framework for loading data files from various sources using SQL Loader
- This greatly simplifies and reduces work involved to load new files
- Maintain existing applications by applying business logic related updates to reflect changes in state or federal legislation in area like financial aid, taxation, etc.
- This activity involves good understanding of existing data model and application modules
- Responsible for implementing new BI reporting infrastructure using ARGOS reporting system. This activity involves following:
- Migrating existing reports created using Oracle ProC to new platform using SQL/PLSQL blocks, stored procedures, triggers and packages.
- Re-architect existing reports to take advantage of Oracle features like parallel processing, analytical functions, pattern matching, virtual columns, etc.
- Performance tuning of existing reports making sure complex SQL queries are using right indexes, table partitions and statistics of various tables are up to date
- Designed views and materialized views encapsulating complex logic with direct impact on queries performance
- Implemented new processes responsible for data pre-calculation and pre-aggregation by daily or weekly jobs using shell scripts and Crontab
- Use Oracle techniques to improve performance and minimize impact on existing functionality like partition exchange
- Documented existing and newly created reports
- Responsible for maintenance of data model and data dictionary for existing and newly created database objects
- Helped business analyze results of various student surveys with direct impact on educational process quality
- Analyze survey results and associated student comments in order to identify weak areas and opportunities for improvement.
Senior Design Engineer
Double E Company
04.2005 - 05.2014
- Create and document new designs based on customer and sales/marketing needs
- Support manufacturing for machining and design related issues
- Part design, model assembly and detailed customer and production drawings using Pro Engineer
- Manage methods of manufacturing for all components, assemblies and sub-assemblies, using Epicor Vantage ERP
- Perform structure analysis and optimization for various parts using Pro Mechanica
- Create various SQL based reports from ERP system using Microsoft Access and ODBC connectivity
- Reports covered area like inventory, bill of materials, customer orders
- Created visual LISP programs to automate Pro Engineer design appliance tasks.
Education
Graduate Certificate Database Management/BI -
Boston University
Boston, MA2016
Associate of Science - Computer Information Systems, Computer Programming
Bristol Community College
Fall River, MA2015
Master of Science - Mechanical Engineering, Mechanical Engineering Technology
University of Craiova
Romania06.1996
Skills
- Environments:
- MS Windows, LINUX/UNIX
- Development tools: SQL Plus, Toad, MS Visual Studio, NetBeans IDE
- Database: Oracle 11g, Oracle 12c, SQL Server 2008
- Languages: SQL, PL/SQL, Unix shell, Python, Java, Weka (Machine Learning), VB Net
- Web Development:
- HTML5/DHTML/CSS, JavaScript
Timeline
Database Developer, Data Analyst
Bristol Community College
05.2014 - Current
Senior Design Engineer
Double E Company
04.2005 - 05.2014
Graduate Certificate Database Management/BI -
Boston University
Associate of Science - Computer Information Systems, Computer Programming
Bristol Community College
Master of Science - Mechanical Engineering, Mechanical Engineering Technology
University of Craiova
Similar Profiles
Suffrens HylaireSuffrens Hylaire
Student Librarian Assistant at Bristol Community CollegeStudent Librarian Assistant at Bristol Community College
Enoch ChanEnoch Chan
Adjunct ESL Instructor at Bristol Community CollegeAdjunct ESL Instructor at Bristol Community College
ANGELA FOUGEREANGELA FOUGERE
Spanish Teacher, Upward Bound Summer Program at Bristol Community CollegeSpanish Teacher, Upward Bound Summer Program at Bristol Community College
Hannah MeierHannah Meier
Registered Nurse / Super Trainer at PM Pediatrics Urgent CareRegistered Nurse / Super Trainer at PM Pediatrics Urgent Care
Ashley PostellAshley Postell
Personal Banker at US BankPersonal Banker at US Bank