Ernesto Arias Email & Phone Number

Responsible for designing and developing the database for the software products, support existing client's implementations and enhancing the database infrastructure. Database Development . Design and implement logical and physical database modeling, and provide database-related solutions to software development team.Design and implement the complex T-SQL scripts, stored procedures, data aggregation to satisfy the product requirements . Design and implement data migration SSIS… Show more Responsible for designing and developing the database for the software products, support existing client's implementations and enhancing the database infrastructure. Database Development . Design and implement logical and physical database modeling, and provide database-related solutions to software development team.Design and implement the complex T-SQL scripts, stored procedures, data aggregation to satisfy the product requirements . Design and implement data migration SSIS packages and support ETL process . Mentor the engineering team on best SQL practices . Explore SQL Server new features in the product suite. BI - SSAS . Show less

Data warehousing and business intelligence. Data Architecture, Data Processing and Integration Design

• Data Architect. Designs and builds relational databases. • Design and Implementation of the Data Warehouse/BI. • Database Analyst Reviews, evaluates, designs, implements and maintains company databases; develop data models and entity relationships diagrams. Establish and maintain backup and recovery policies and procedures; tuning and performance monitoring. • Deploy and support production db systems; high availability log shipping.• Identifies data sources, constructs data… Show more • Data Architect. Designs and builds relational databases. • Design and Implementation of the Data Warehouse/BI. • Database Analyst Reviews, evaluates, designs, implements and maintains company databases; develop data models and entity relationships diagrams. Establish and maintain backup and recovery policies and procedures; tuning and performance monitoring. • Deploy and support production db systems; high availability log shipping.• Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. • Writes codes for database access, modifications, and constructions including stored procedures, triggers, custom functions, T-SQL coding best practices, CTE's. Maintain all company tables, referential integrity, indexes, stored procedures, functions, and views.• SQL Server Reporting Services and SQL Server Integration Services, BI using SSAS (2000/2005/2008). Establish and maintain backup and recovery policies and procedures, tuning and performance monitoring of SQL Databases.• Designs and Implementation data security, integrity and high availability, Develops strategies for data acquisitions, archive recovery, and implementation company databases. • Cleans and maintains databases; administration of production and development environments. • XML architectures. • Client/Server Programmer: Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.• Intranet/Internet developer. Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs in ASP, ASP.NET C# / VB.NET. Show less

Developed and optimized code for lightweight OLAP (On-line Analytical Processing) client tools. Analyst and programmer / Product Manager for the "IQ Business" OLAP Analysis suite. In charge of the consulting and Olap/DW division. Organized and led development teams Designed and developed custom software solutions for various corporations Trained junior programmers

Masters Of Science, Master Of Computer Degree In Information Systems

Activities and Societies: • Models of Organization and Information systems. • Networking. • Databases. • ASP.NET • Windows DNA.

Masters, Science Mechanical Engineering, Specialty Mechanical Design; Industrial Mechanical Engineering