TRAIAN CRISTIAN VOICULESCU
Attleboro,MA
Summary
Data Modeler/ Data Architect with over a decade of experience, proficient in designing complex data models that serve as the foundation for efficient databases. Extensive experience with major database systems including Oracle, SnowFlake, Teradata.
Overview
19
19
years of professional experience
Work History
Senior Data Modeler / Data Architect
CVS Health
09.2011 - Current
- As lead architect for Pharmacy Integrated data warehouse I was driving database design and data modeling effort for multiple large projects
- Worked closely with business analysts and project managers to design and architect solutions which meet requirements
- Interacted with business partners in order to fully understand their needs and expectations
- Identified data needs for various projects
- Created and maintained mapping documents used by ETL team to move data from source systems into data warehouse
- Created Erwin models for stage, core and semantic layers in Oracle, Teradata and Snowflake databases
- Defined and maintained data modeling standards
- Assisted QA team in testing activities helping them understand projects scope and architecture
- Created views and stored procedures involving complex queries in Oracle, Teradata and Snowflake databases
- Lead effort to migrate existing Oracle and Teradata warehouses to new Snowflake platform
- Part of a team assigned to determine feasibility of using GCP Big Query as future platform for pharmacy data warehouse
- Provided estimates for future projects
Software Engineer
PointRight
02.2006 - 09.2011
- As member of development team, I was deeply involved in company’s efforts to develop new web-based data driven solution for long-term care and health insurance industries
- Major functionality of the solution includes clinical data validation, risk assessment, compliance measuring and performance benchmarking. Application is using Windows web platform (IIS, Net2.0) and Oracle 10g as database engine
- Designed and implemented a flexible multithreaded Windows service used to load data from various sources into Oracle database
- Created Oracle SQL Loader control files and PLSQL stored procedures used to load data from external files.
- Implementation of Oracle stored procedures and views responsible with data preprocessing, performing complex business rules
- Design and development of ASP.Net risk assessment application responsible for receiving, tracking and fulfilling risk assessments requests from insurance companies. Web interface was created using complex user web controls that extend ASP.Net existing controls (grid view, table, etc.) and also using Telerik controls for APS.Net AJAX. Database interaction uses Oracle .Net Provider. Reporting was done using Winnovative PDF Creator component, XML and Excel
- Supported research department in their data mining efforts by modifying and creating complex database queries and stored procedures using SQL Plus and PL/SQL
- Responsible for fine-tuning long running queries to improve performance
- Create design documents that are further used by engineers during development process.
Software Engineer
The Next Round, Inc
10.2005 - 02.2006
- Part of a team in charge with development and maintenance of enterprise class software solution for Private Equity and Alternative Investment communities
- Solution was built around Microsoft's .NET platform, which provides seamless integration with all Microsoft products such as SQL Server 2000 and MS Office (Outlook, Word, and Excel)
- Designed and implemented new set of classes for interaction with SQL Server database engine using managed C++ and ADO.Net
- Implemented application interface with MS Outlook.This is an important part of CRM component of the application. The project used C# and COM interoperability to automate MS Outlook from .NET application and synchronize Outlook folders content (Inbox, Drafts, Contacts, Appointments, etc.) with database tables.
- Created and improved application user interface using .Net Windows Forms controls and specialized third party controls (Infragistics library) in order to provide a very effective way to display and analyze complex data.
Software Engineer
Taxware
07.2004 - 10.2005
- Responsible for development and maintenance of large-scale C/C++ tax calculation application running on many platforms such as Solaris, HP-UX, AIX, Linux and MS Windows; added new features and improvements for both back-end tax-engine and front-end user interface
- In charge with implementation of new deployment and installation strategy using InstallShield Multiplatform
- Responsible for integration of Taxware software with PeopleSoft Financial and Supply Chain package using Business Interlinks technology
- Migration of Taxware software to ASP.NET Web Services technology in order to integrate with SAP
- Maintained Oracle version of Taxware tax-engine adding new features and improving existing PL/SQL code in complex queries, stored procedures and triggers
- Integration with Pitney Bowes Group1 (major GIS/mapping provider) GeoTax and Universal Coder applications allowing Taxware system to perform more accurate jurisdiction determination.
Education
Master of Science - Computer Science
University of Craiova
Romania06.1995
Skills
Environment:
- MS Windows
- Linux/Unix
Development tools:
- MS Visual Studio
- Toad
- Teradata Express Studio
- PyCharm
Database:
- Oracle
- Teradata
- Snowflake
- Big Query
- SQL Server
- MS Access
Data modelling:
- Erwin
Languages:
- C#
- C/C
- SQL, PL/SQL, SnowSQL
- Java
- Python
- VB
Web development:
- HTML/DHTML/CSS
- JavaScript/VbScript
- XML/XSLT
- JSON
Timeline
Senior Data Modeler / Data Architect
CVS Health
09.2011 - Current
Software Engineer
PointRight
02.2006 - 09.2011
Software Engineer
The Next Round, Inc
10.2005 - 02.2006
Software Engineer
Taxware
07.2004 - 10.2005
Master of Science - Computer Science
University of Craiova
Similar Profiles
Dany GarciaDany Garcia
Pharmacy Lead Technician at CVS HealthPharmacy Lead Technician at CVS Health
Amber BentleyAmber Bentley
Customer Service Representative at Cvs healthCustomer Service Representative at Cvs health
Khanh HuckleberryKhanh Huckleberry
Pharmacy Manager at CVS HealthPharmacy Manager at CVS Health