SUMMARY:

• Over 7+ Years of proven Experience in Retail, Manufacturing and Telecom with expertise in MSSQL SERVER 2017/2016/2014/2012/2008 R 2/2008/2005/2000 versions, and others Microsoft tools like SSIS and SSRS.
• Working experience in writing T - SQL code making complex queries, involving multiple tables (SQL Joins), creating tables, Triggers, Functions, Views.
• Expert in Performance Tuning, Handling Indexes, and Query Optimization.
• Identified and resolved problems encountered during development and release of the SSIS code.
• Developed ETL packages using SQL Server Integration Services to populate data from different sources like flat files/CSV Files, Excel to Staging Databases and between databases. The packages include wide variety of transformations like Look Up, Aggregate, Derived Column, Conditional Split, data conversion and Script tasks.
• Test the ETL Process for both before validation and after data validation process. Test the messages published by ETL tool and data loaded into various databases.
• Experience in creating user stories, scorecards and dashboards in KlipFolio or Crystal Reports in creating good data visualizations for the business.
• Manage Logins, Users, Roles and User Permissions.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in deploying the created SSIS packages in Development and Testing environments.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Proficient in designing Data Mart and Data Warehouse.
• Monitoring Performance making Traces with SQL Profiler.
• Supporting, troubleshooting and Maintenance of business applications using SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000 and SSRS.
• Installing, Upgrading and configuration of MSSQL Server 2000/2005/2008/2008 R2/2012, SSRS.
• Experience in working in Crystal Reports and KlipFolio.
• Can code and understand C# code, C/C++ and HTML.
• Generated the Reports with all the subcategory Information to Business users.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Good Attitude, work under pressure, flexibility and self-development.
• Great Team Worker and always availability to continuous improving.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000, MS Access, MySQL & Oracle.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS,SQL Profiler, Visual Studio,SQL Query Editor,SQLite, HeidiSQL, Crystal Reports, KilpFolio.

Languages: T-SQL, SQL, C#, C & C++Operating Systems Windows 10/8/7/Vista/XP/2003/2000/Me, Linux & Mac OS

Web Technologies: HTML

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), KlipFolio, Data Warehousing Design & Crystal Reports.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Programmer

Responsibilities:

• Understand the business requirements to provide new solutions to the end user.
• Design and Create New Reports to improve access data between Sales Info - End User.
• Analyzing and searching data to develop a clear vision of the business.
• Create database objects and scheduled them to automate processes.
• Work with RDBMS concepts making indexes, relationships between objects, Physical and Relational Diagrams.
• Developing in T-SQL, making modifications to store procedures in DBs based in MSSQL Server.
• Develop Code to upgrade data, in order to get Advanced Score Cards automatically.
• Developing in SSIS (ETL) processes to upgrade data between files and Databases.
• Developing Complex Code T-SQL involving Stores Procedures, Triggers, Functions, Views, and tables for several purposes like reports, jobs, ERP modifications, and maintenance or create third applications.
• Developing custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Create and Design Dashboards Klips, using KlipFolio Tool.
• Review code in MySQL to improve performance query in reporting issues.
• Propose new solutions developing new queries for business purposes.
• Developing in MySQL complex queries for collecting business data in flat files or Excel files and present to the end user.
• Using HeidiSQL to Administrate and Develop Databases for the infrastructure of the company.
• Troubleshooting and maintenance dashboards in KlipFolio.

Environment: MSSQL Server, Reporting Services (SSRS), Integration Services(SSIS) MySQL, KlipFolio, Excel and Windows, Microsoft Visio, Visual Studio Data Tools and HeidiSQL.

Confidential

Systems Analyst

Responsibilities:

• Analyzed the business requirements and make modifications according user are requesting.
• Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created queries to show correct information on invoices.
• Collected information with user in order to show correct data in formularies.
• Created reports for metrics in sales.
• Developed queries in Oracle to data analysis for the end user.
• Developed in T-SQL
• Monitored, Schedule Plans, Logs, Data Analyst and Traces.
• Automated process, developing Jobs and scheduled into SQL Agent.

Environment: Management Studio SQL Server, T-SQL, Excel, Windows and UNIX.

Confidential

Database Developer, Analyst & Administrator

Responsibilities:

• Created Business Requirements Documents, with data collected from the end users.
• Implemented improvements to ERP of the company, applying changes previously in a test environment before release in production.
• Created different ETL process, to show data calculated or transformed, to the End User automatically (DataMart).
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created and Designed Database working with Data Warehousing or DataMart.
• Worked with RDBMS concepts making indexes, relationships between objects, Physical and Relational Diagrams.
• Identified Improvements ideas to apply on business.
• Supported, troubleshooting and maintenance in Databases.
• Backups, restores, scheduled log shipping, security and high availability.
• Developed reports using tool Crystal Reports.

Environment: Management Studio SQL Server, Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),C#, HTML, Toad SQL Server, Excel, Microsoft Visio, ERP System (Grand-e), HR System (TREES), Crystal Reports and Windows.

Confidential

Data Base Analyst

Responsibilities:

• Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created and Modifying T-SQL Stored Procedures/Triggers for validating the integrity of the Data Bases.
• Developed solutions for consulting in Crystal Reports.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Designed complex queries to get information connect to Excel and present to the end user.
• Implemented and configured systems in new stores.
• Designed Data Bases for mini apps oriented to the end users.

Environment: Management Studio SQL Server, T-SQL, ERP (Commercial System), POS (Point of Sale System), DCT (Data Collector Terminal System), Excel, Crystal Report, Reporting Services (SSRS), Integration Services (SSIS), SQL Profiler and Windows

Confidential

IT Engineer (Data Base Developer & Administrator)

Responsibilities:

• Worked with Data Bases based in MSSQL Server, MySQL and Oracle.
• Created and designed Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement in MySQL and Oracle.
• Designed and implementation of Security Model, Policies and Procedures in SQL Server.
• Performed query plans and making sure each and every query is using appropriate Indexes
• Created and Modified T-SQL Stored Procedures/Triggers for validating the integrity of the Data
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Configured E-mail for alerts in case of error of Log Shipping.
• Created different kind of reports requested by user.

Environment: Management Studio SQL Server, Toad Oracle, MySQL, Arduino programming C\C++, PHP,HTML, Reporting Services (SSRS), Integration Services (SSIS),MS Excel, MS Acces, Visual Studio C#, Linux and Windows.

Confidential

Performance Tester

Responsibilities:

• Tested web services for companies like Confidential .
• Worked with a Tool “Load Runner”.
• Debugged code in C++, PHP and HTML.
• Elaborated reports with all the information of testing.
• Consulted and Validation on Data in MySQL Databases.
• Loaded benchmark for testing in real time, applied in a testing environment, before to make an analysis.

Environment: Load Runner, MySQL, Excel and Windows.