Talles Roberto Silva

Email:accezq@r.postjobfree.com

Mobile: 647-***-****

Education

****-**** ***** *******

Bachelor in Computer Information System

USA: VA State

Microsoft Certificates

MCT- Microsoft Certified Trainer 70-445-BI Development and Maintenance SQL 2005

70-431-Implementing and Maintaining SQL 2005 70-448-BI Development and Maintenance SQL 2008

70-432-Implementing and maintaining SQL 2008 70-452-Designing BI Infrastructure with SQL 2008

70-667 Microsoft SharePoint 2010, Configuring

Technical Skills

• Microsoft SQL Server 2005/2008/2012 • Windows 8,7, Windows 2003/2008R2,MDX

• SSRS,SSIS,SSAS 2008/2005/2012 • Excel, Visio,VMware,Win Hyper-2008R2

• TSQL, SSAS Tabular,ETL • SharePoint,Support Tier III / Data Mining

Professional Experience

Solgenia Canada

January/2012 Present

DBA/BI Developer

I have been working as a Solution Engineer at Solgenia Canada for 2 years and I impletement Solgenia’s

document management and Business Intelligence solution to customers in NA. I spend good time talking with

customers in order to understand their technical needs to implement and integrate Freedoc Collaboration as well

Solgenia Anlysis with SQL Server reporting services, analysis services. During these 2 years working for

Solgenia I have been receiving from the company awards for being inovation builder and always for being close

to customer’s needs.

• Implement, configure and maintain SQL Server 2008R2/2012, SSRS, SSAS and SSIS.

• Install, configure SharePoint, Solgenia Analysis,Freedoc Document Management, Blix CRM.

• Maintain instances and databases, manage data, implement security and high availability.

• Extract, transform and load data with SSIS, design, configure and deploy with solutions SSIS.

• Build SSAS databases and tabula data model; create cubes, design dimensions and measures .

• Create backup strategies, Manage different backup models, including point-in-time recovery.

• Design a report; implement a report layout, interactivity in a report, troubleshoot SSRS issues.

World Service Cargo

November 2011 –2012/Jan

DBA/BI Developer

• Implemented SQL Server 2008 R2, configured instances and databases and appllied security.

• Implemented SSRS solution,created all the company’s SSRS reports, subreports, matrix reports.

• Created linked reports, drill down reports, guage reports, applied security to reporting services.

TimerTech

November 2010-2011/Oct

DBA/BI Developer

• Installed SQL Server 2005/2008, configured instances and databases, implemented security.

• Implemented database mirroring, log shipping, linked servers and created database

snapshots.

• Implemented and maintained SQL Server Agent jobs, created backups, restored databases.

• Moved a database between servers, gathered performance by using the SQL Server Profiler.

• Monitored and resolve blocks and deadlocks diagnose and resolved database server errors.

• Created tables, views, triggers, stored procedures, functions, constraints, portioned large DB.

• Created indexes, reorganized, rebuilt indexes, managed index fragmentation and statistics.

• Implemented, configured, deployed, and maintained SSRS solutions with SRRS 2005/2008.

• Created cubes, translations, perspectives, defined default storage settings for measure

groups.

• Created dimensions, user-defined and parent-child hierarchies within dimension and storage

modes.

• Created and maintain measure groups, aggregations and partitions, translations,

perspectives.

• Created measure groups, Added measures to measure groups, modified measure properties.

• Defined storage mode settings on partitions, ROLAP, MOLAP, HOLAP, Proactive caching.

• Created, actions, action target, and action content, DSV, relationships, named queries.

• Created named calculations, KPIs, value and goal, trend indicators and expressions.

• Configured dimension usage: Regular, Reference, Fact and Many-to-many relationships.

IBM (Stefanini)- Brazil

Nov /2009-2010/Aug

Production DBA/BI Developer

Support Specialist

• Created replication, database mirror, linked server, log shipping, migrated Access data into SQL.

• Upgrade SQL Server 2000 databases to SQL Server 2005 and 2008, defragmented indexes.

• Backed up databases, and created partition function, partition indexes, full text search, profiler.

• Maintained and automated SQL Server, created stored procedures, tuned stored procedures.

• T-SQL, triggers, replication, worked strongly with relational databases and OLAP databases.

• Tracked data changes, worked with UAT, Development and Production environments.

• Created several reports, deployment, parent /child reports, and improved SSRS performance.

• Extracted, loaded and transformed tons of data from different sources into SQL Server 2005/2008.

• SSAS cubes, dimensions, measures, named calculations, snow flake schema, star schemas.

• SSAS data mining, algorithms, calculated attributes, named set, named queries, dill through actions.

Akta Trading-Russia

Jan/2007-2008/Dec

DBA/BI Developer

• Implemented and mainted SQL 2005 and migrated all SQL 2000 databases into SQL Server

2005.

• Extracted,loaded,transformed SQL data into Excel to business users in the financial department.

• Created all the company’s SSRS reports, subreports, matrix reports, linked reports, drill down

reports.

• Designed Star schemes and snowflake schemas, created cubes, named calculations, named

queries.

• Created and improved stored procedure performance, created indexs, tables and trained users.

• Deployed SSIS packages by using DTUTIL; deployed SSIS packages by using the deployment

utility.

• Implemented and maintained SQL Server 2005, migrated all Access databases into SQL Server

2005.

• Create and schedule jobs; notification of job execution; disable/enable jobs; change job step

order.

Contact this candidate