Carlos C. freelancer experto en SQL Server, Database, Inteligencia empresarial

Carlos C.

dataqbs

0 / 5

Mexico
Valor hora:

MX$ 500,00

IT & Programación

Habilidades (Máximo: 3)
¿Qué es posición de perfil iron?

Iron es el nivel inicial de los freelancers de Workana. A medida que consigan más logros y ganen más proyectos, irán progresando hacia los niveles superiores. Leer más

Sobre mí
Expert level Developer, Administrator and Analyst with 10+ years of experience in databases and business intelligence. Extensive T-SQL development skills including writing complex queries, data migration and complex ETL developments .Great ability to develop and maintain stored procedures, views, triggers, jobs, ETLs, dashboards, user defined functions and detail reports always guiding results to business, facilitating the decision making process through the provision of reliable, clear and timely data.


Summary of Experience
10+ years of experience in Analysis, Design, Development, Implementation and Support of Relational and Multidimensional Database Projects
10+ years in T-SQL Development
10+ years in ETL Development
7+ years working with Business Intelligence tools and strategies
5+ years as DBA
4+ years working in multiple cultures, countries and time zones with Agile Methodologies


Technical Experience:

Proficient: SQL Server Administration, T-SQL, MS-SSRS ( Reporting ), MS-SSIS,DTS ( ETL ), MS-SSAS ( OLAP ), SQL Server 2000,2008,2008R2,2012

Medium: Crystal Reports, Actuate Reports, Teradata, MySQL,PHP , ASP.
Historia laboral
Tiempo Developvent    
Guadalajara, Mexico        
Software Engineer Lead – Consultant for Preferred Homecare (USA)                            Period: June. 2016– Now
•    SQL Server BI SR. Developer



Freelance - BI/DBA Consultant at dataQBS                            Period: Jan. 2011 – now

Working as BI/DBA Consultant on SQL Server solutions, SSAS, SSRS, SSIS, T-SQL, Database Development, Teradata, MySQL...
•    C&A Mexico:  DBA support, T-SQL Development, SSAS Cubes OLAP development and maintenance, SSRS development. http://www.cyamoda.com/
•    KnowIT: T-SQL Development, DBA support. http://www.knowit.mx/Pages/default.aspx
•    Integra Consultoría y Sistemas: SSRS Development, SSIS Development Intallation and Maintance. DBA support. http://www.integraconsultoria.com.mx/jupgrade/index.php/es/
•    BSDevelopment SA de CV: SSRS Development http://bsdev.com.mx/


HCL Technologies    
Guadalajara, Mexico        
SQL Report/SSRS Consultant  for Ceva Logistics (USA)                                                            Period: Aug. 2014 – June 2016
•    Development of Complex queries based in the Matrix Ceva client database which includes research, analysis, coding, testing, pass to production workflow and maintenance.
•    Development of reports ad hoc using Microsoft Reporting Services 2012 , SQL Server 2012, Visual studio 2010 and Report Builder 3.0
•    Development of reports ad hoc with Actuate Reports, Actuate e.Report Designer Professional and SQL Server 2012.
•    Code Control and Maintenance through Microsoft Team foundation Service, Visual Studio 2013 and Visual Studio 2010.
•    Formulating SQL queries and stored procedures on assigned modules
•    Wrote Stored Procedures, Functions and Triggers as per the requirements.
•    Advanced T-SQL programming, to improve codes that already exists
•    Analysis of requirements
•    Migration of Actuate reports to SSRS
•    Resolution of tickets assigned for development and incidents related with all kind of reports used by the client, this work has to be done in the SLA previously estimated.
•    Work in a global team using Agile Methodology, TFS, Share Point and Compuware change Point to share work and code.

Tools: T-SQL, SSRS; Actuate, TFS, VS2010, VS2013,SQL Server 2012, SQL Server Management Studio, Report Builder 3.0, Share Point and  Compuware Change Point.


Jabil Circuit  de México                                                                                              Period: Aug. 2011 –  Aug.2014
Guadalajara, Mexico
Database Analyst II (Data Management Global group)

•    Responsible of the Database Architecture for new Global corporate applications as the eKaizen software which cover all the plants around the world in the company.
•    Database Administrators of dozens of servers and databases belonging to the Data Management Global Team.
•    Design and Development of complex ETLs using Microsoft Integration Services loading and the legacy DTS, converting and mapping data from multiple sources and destinations such as Oracle, MySQL, Success Factors, SAP, plain texts, Excel, SQL Server 2000,2008,2012 and windows services as Perfmon.
•    Responsible of the Database Architecture for multidimensional databases in order to provide a complex base to create Reporting Services , .NET reports and OLAP Cubes.
•    Analysis, Development, Maintenance of OLAP Cubes with Microsoft Analysis Services
•    Development of reports ad hoc using Microsoft Reporting Services 2012 , SQL Server 2012, Visual studio 2010 and Report Builder 3.0
•    Formatting SQL queries and stored procedures on assigned tasks.
•    Writing of Stored Procedures, Functions and Triggers as per the requirements from de development team.
•    Responsible of the Data Management guard in a weekly base to give support 24/7 to the corporates ETL process between SAP extracts and SQL Server (SSIS).
•    Resolution of tickets assigned for development and incidents related with all kind of reports used by the client, this work has to be done in the SLA previously estimated.
•    Work in a global team using Agile Methodology, Share Point and TFS to share work and code.
•    Tools: T-SQL, SSRS, SSAS, SSIS, DTS, TFS, VS2010, VS2013, SQL Server 2012, SQL Server 2014, SAP, SQL Server Management Studio and Share Point.




C&A Mexico                                                                                                        Period: Sep. 2005 – Aug. 2011
Guadalajara, Mexico
BI programmer 
•    BI Project Management
•    Administration, Implementation, development and maintenance of OLAP cubes for HR, commercial area, payroll, credit area with SQL Server Analysis Services (SSAS 2008 R2)
•    Administration, Implementation, development and maintenance of reports in SQL Server Reporting Services (SSRS 2008)
•    Administration, Implementation, development and maintenance of ETL’s with Integration Services (SSIS SQL Server 2008) to the data warehouse. (POS, commercial area)
•    Advanced Programming in T-SQL for connectivity applications such as POS and Merchandise (Channel Integration T-SQL).



Gamsa                                                                                                                                          Period: May 2005 – Ago 2005
Guadalajara, Mexico
•    Support, Analysis, Development and Implementation of Software and Databases using ASP, Crystal Reports and SQL Server 2000.

Grupo Firme plus                                                                                      Period: Apr 2004 – May 2005   
•    Support, Analysis, Development and Implementation of Software and Databases

Jabil Circuit de México                                                                    Period: Ago 2003 – May 2004   
•    Support, Analysis, Development and Implementation of Software and Databases  using ASP, Visual Basic 6.0 and SQL Server 2000.  ( Trainee )
Contratar

Rankeado: No está rankeado

Posición del perfil: Iron

Último login: Hace 5 meses

Registrado: Hace 6 meses