Sql Server Developer

Jose M Lopez

Phone: 786-***-****

Address: **** ** *** **, *****, FL 33175

E-mail: ***********@*****.***

Summary:

Extensive years of experience as Computer Programmer and Database Developing.

Strong Experience using SQL tools for data interaction and support the Database environment.

Produced attractive visuals/dashboards to convey the story inside the data using Tableau.

Experience with business requirement identification and analysis, data modeling and/or mapping.

Experience in ETL using SSIS services for data Extraction and Load from Excel, Flat Files, Oracle, etc. into SQL Server.

Experience Reporting using SSRS.

Experience with VB.Net, ASP.Net, C#, Visual Basic through Visual Basic 6.0

Experience on SQL Server DBA.

Fast learner, analytical with strong troubleshooting and problem solving skills.

Comfortable working independently or as part of a team.

Agile Methodology.

Honest and always willing to take ownership of the work.

Education:

University of Havana. Major Mathematics, Minor Computer Science

Skills:

MS SQL, T-SQL, MSDE, SQL Express, SSRS, Oracle PL/SQL.

.NET Technologies (VB.Net, ASP, ASP.NET), Visual Basic 6, Visual Basic, MS Access, VBA, Business Objects, CSS, HTML, Visual FoxPro.

SSRS, Crystal Report, MS Access, MS Office (Excel, Word, PowerPoint), Tableau, Power Bi.

PROFESSIONAL EXPERIENCE:

UAIC (SQL Developer/DBA Administration) Apr 2018 – Present

Support SQL Server 2008 R2 / 2012 / 2014 / 2017

Develop ETLs utilizing SSIS tool to feed business intelligence platforms

Design and implement Microsoft SQL Server databases, performance tuning, indexing and developing stored procedures

Manage high volume Data Warehouse solutions as well as document storage, full text indexing and retrieval.

Support production users, debug production-related issues, fix and deploy dev, integration and test through to production.

Design database access security controls.

Work with stakeholders and different teams in an Agile Environment.

Create and Redesign Dashboard and Report using Tableau, Power BI and PowerPivot for Excel.

Tracfone Inc. (SQL Developer/DBA Administration) Aug 2017 – Apr 2018

Perform various types of complex analysis.

Build models for business and financial analysis; conduct Financial and Business Reporting, as well as Ad-Hoc reporting requests by executive management.

Manages various data and process audits.

Work on different projects with the project Managers following Agile Methodology.

Create procedures to make sure the data control policies are working as expected.

Create SSIS (ETL) packages to move data from Oracle, Text Files, and Excel to SQL Server to further process and Audit results.

Experienced in enhancing and deploying SSIS Packages from SQL Server 2008 to 2014 server.

Delivered reporting solutions and Data visualization with Power BI and PowerPivot.

Create Ad-Hoc reports using Oracle PL/SQL and Excel to Process Data for Compliance Requirements.

Manage and Coordinate root cause analysis of issues.

Support the continuous assurance program – tapping into various systems by developing and running Oracle SQL queries to identify outliers.

Predictive analytics – Using historical data, create predictive algorithms that would trigger an audit.

Perform systems analysis, operational systems maintenance, and managing testing of billing platform processes related to TracFone product brands.

Own and manage projects pertaining to Audit and Compliance.

Mount Sinai Medical Center (SQL Developer/DBA Administrator) Dec 2016 – Jun 2017

Create and Developed Reports, Store Procedures and SQL Job to Automated daily reports, alerts and email distribution.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Databases.

Involve in Source Data Analysis, analysis and designing mappings for data extraction.

Data Analysis and Reports using Excel, Visual Studio, Power BI and Tableau

Involve Query Optimization to increase the performances of the Report.

Developed an application in Visual Studio / SQL Server to evaluate and track and analysis Quality Food Nutrition Program.

Rebuilding / Monitoring the Indexes intervals for better performance.

Manage the emigration of the Databases from SQL Server 2012 to 2014.

Creation of Analytical reports using SSAS and PowerPivot.

Analysis and creation of Store Procedures to extract Data for Project Management.

Golden Trail Inc (SQL Developer/Reporting) July 2013 – Sep 2016

Authored stored procedures to centralize business logic. Refined the database model by eliminating data discrepancies in study set up and standardized the definition of study data.

Involved in scripting, migration, and testing of SQL server databases for the migration of data from standalone machines.

Work as a consultant to design and implemented several databases processes to integrate data from diverse sources (ASCII, EXCEL, ACCESS, DBF, SQL) into the SQL Database using SSIS services.

Performed Logging and Deployment of various packages in SSIS.

Develop various operational reports using SSRS.

Design and Develop Reports based on statistical analysis of the data using SSRS.

Involve Query Optimization to increase the performances of the Report.

Assist on resolution of Data conversion issues, work flows and the creation of test plans.

Performed analysis and presented results using SQL, SSRS, MS Access and Excel.

Imported, exported and manipulated large data sets.

Optimization of some Queries, Store Procedures and Views to Improve Database Performance.

Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.

UPS (Computer Programmer/Database Developer) April 2000 – May 2013

Developed scripts to automate the archiving of data every 6 months. Increased capacity and storage of the databases by archiving data, in accordance with periodic data auditing.

Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers.

Use SSRS to design and develop reports, automation solutions for receiving and reporting of client data across site support, materials, outreach, and call center operations.

Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Project Working with Marketing in Develop a Set of Store Procedures, Queries and Reports to Capture and Analyze Price, Revenue and Marketing Strategies.

Developed and maintained multiple Dynamic SQL and MDX queries for team’s reports, allowing for consistency, speed, and accuracy.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Deal with Fine-tuning Store Procedures to improve performance with a Query plan using SQL Tuning advisor.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Transferring the Data (ETL) from Oracle, Excel Files and Access to SQL Server using SSIS.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Monitored and Making Recommendations for Performance Improvements in Hosted Databases.

Performed Installation of SQL Server 2008. Manage the Migration of the Databases from SQL 2005 to 2008.

Perform moderate to complex server-class database activities across various environments.

Consult with and provide guidance to database users and client groups, recommending tactical and strategic solutions.

Work in the design, creation and implementation of several databases projects to integrate different department data into an Oracle Warehouse Database.

Develop a Web Site to speed the process of the Price Discount and Revenue (Marketing Department) for the Latin America Region, using ASP.Net and SQL Server.

Work in the Intranet Regional Site. Design, build and maintenance of regional’s Web Site using different technology and tools. Redesign components and applications using Visual Basic 6.0 and ASP.

Work as a part of a team developing several applications for diverse departments using Visual Basic 6.0 and SQL Server.

References:

Available upon request

Contact this candidate