William Cepeda

Detailed-oriented software programmer with 10+ years’ success devising innovative and tailored solutions to meet ever-changing business requirements within diverse industries. Ability to assimilate and rapidly utilize emerging technology. My technical proficiencies includes:

Programming: Oracle, Sybase, MySQL, Sqlbase, PostgreSql, Microsoft Access, SqlServer, Java, C, C#,C++, SqlWindows, VB, Cobol, ASP.Net.

Development: Object – Oriented Design, Agile Development, Project Management, Quality Assurance, Database Design.

Platforms: Windows, Mac OS, Linux, HP Open View, .Net, Eclipse, Netbeans, Adobe. Networking: Cisco, Motorola, Tellabs.

Excellent knowledge in designing and creating SQL Databases.
Excellent knowledge in SSIS in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012.
Designed developed implemented and maintained several ETL processes using SSIS
Created Parameterized reports, linked reports, click through reports, drill down reports and sub reports using SSRS in SQL Server 2005, 2008 and 20012.
Created OLAP Cubes in SQL Server 2005, 2008 R2 and 2012 for supporting clients reporting as well as performance needs.
Used TFS along with Database projects, SSIS, SSAS and SSRS for managing multi developer development environment.
Advanced experience in SSIS project deployment in SQL Server 2012.
Experienced in working with Scrum and Agile software development cycles throughout 8 years.
Expert in performance tuning slow running stored procedures, SSIS packages, reports and OLAP SSAS cubes.
Excellent skills in understanding legacy business logic and developing new ETL processes.
Monitored and narrowed down performance bottle necks using DMVs, SQL Server Profiler and SSIS custom audit tables and fixed it.
Design, support, and maintain multiple Database applications, determining solutions and taking actions to resolve the issues onsite.