Mirela Voiculescu
PROFILE
6 Years of experience as SQL developer, data analyst. Dedicated and motivated person, with strong abilities to solve problems quickly and effectively.
EXPERIENCE
May 2014 - Present Bristol Community College, FALL RIVER MA - Database Developer, Data Analyst.
-
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 the OLTP system and external sources and update the data mart making use of Oracle external tables and SQL Loader.
-
Designed a metadata driven framework for loading data files from various sources using SQL Loader. This greatly simplifies and reduces the 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 a good understanding of existing data model and application modules.
-
Responsible for implementing a new BI reporting infrastructure using ARGOS reporting system. This activity involves the following:
-
​migrating existing reports created using Oracle Pro*C to the 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 the 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 Cron. 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.
​
April 2005 - May 2014 Double E Company, WEST BRIDGEWATER MA - Senior Design Engineer.
-
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 the 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 in Database Management and Business Intelligence (GCERT DBM/BI), Boston University, 2016, GPA 3.60
Associate of Science in Computer Information Systems, Bristol Community College, 2015, GPA 3.91
-
Major: Computer Information Systems
-
Concentration: Computer Programming
Bachelor of Science in Mechanical Engineering, University of Craiova, Romania, GPA 3.31
-
Major: Mechanical Engineering
-
Concentration: Mechanical Engineering Technology.