Ms Sql Server

C: 214-***-****/ *************@*****.***

TECHNICAL EXPERIENCE

●Extensive experience in designing, developing and integrating with MS SQL Server and BI tools (SSIS, SSRS).

●Expert in creating Drill Down and Drill Through, Ad Hoc, Parameterized reports, Sub-reports, Snapshots, designing report layout using SQL SSRS.

●Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions and others.

●Experience in importing /exporting data from various data source like Excel, XML and flat file using SSIS utility. Involved in transformation of OLTP data to the data warehouse using SSIS and SQL commands.

●Expert in implementing ETL packages and proficient in implementing all transformations available with SSIS/DTS toolbox.

●Outstanding experience in specifying issues in database, Performance Tuning, Debugging, Troubleshooting and improving database performance. Setting up data governance on incoming data feeds to validating the qualify for feeds.

●Extensive experience in data extraction, transforming and loading (ETL) using SQL Server Integration Services (SSIS), creating various packages depending on user requirements.

●Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.

●Experience on agile methodologies Scrum.

●Good knowledge on Object Oriented Programming, JavaScript, Core Java, HTML, CSS, XML, JSON, Oracle.

Environments: MS SQL Server 2000-2016, Windows 2003/2016, Ubuntu, MS SQL Server 2005 -2016, Microsoft Access. MS Visio MS Excel, Visual Studio 2008 - 2017, SQL Server Management Studio 2005- 2016, MS SQL Server BIDS, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS). SQL Server Management Studio, Enterprise Manager, SQL Server Business Intelligence

US Bank July 2018 to Current

SQL Server Developer

●Created the ETL (SSIS) packages and ETL procedures scheduled them for Jobs.

●Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).

●Experienced working with agile methodology and provided daily communications, Scrum notes, Sprint Reviews Reports, Project Retrospectives.

●Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

●Rewritten the stored procedures for the ETL processes where monthly billing data is sent to the client.

●Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both environments: Development and Production.

●Created and configured the database with file groups and created the tables having required constraints.

●Installing, configuring, administering and securing Clients' production servers.

●Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.

●Worked on Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.

The Loan Store

SQL Support Developer June 2016 to April 2018

•Developed SSIS packages that includes LOOKUP, Conditional Split, and package also included incremental loading technique.

•Created jobs and monitored job history for maximum availability of data and to ensure consistency of the databases.

•Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so as to create reports that draw content from a variety of data sources.

•Designed and implemented stored procedures and triggers. And to keep track of changes to the fields of tables when changes are made.

•Extensively used Joins and sub-queries for complex queries involving multiple tables from different Database

•Tests the code to ensure it functions as designed as per the business requirement and the implementation of the code in production environment.

•Upgraded SQL Server 2008 to SQL 2012 server for high volume processing databases on a clustered environment.

•Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

•Rectified various performance issues & necessity of indexes and schema changes.

•Developed the template for the database objects like Store Procedure, Views, Triggers, Metadata, CTE's, Functions and Work Table.

•Investigated nature and probable cause of bugs. Clearly described all bugs followed through to resolution. Tracked bugs, reported trends and made recommendations.

•Setup backup and restoration jobs for development and QA environments.

•Creation of new databases, planning the location of data, index, and Transaction log files on disks.

•Modified the existing report and security management of the report and deployed as per requirement.

Capital One Auto Finance August 2013– May 2016

Junior SSRS Report Developer

●Design and deploy SSRS reports for visual presentation of the data.

●Created and deployed SSIS packages – 8months experience

●Creating AD HOC Reports at Client requests

●Develop ETL processes to collect/consolidate data from a variety of sources.

●Document functional report requirements as well as technical design when needed.

●Develop T-SQL code, stored procedures, views, functions, and other database objects to supply data needed for the reports.

●Communicate reporting changes, enhancements, and modifications – verbally or through written documentation – to management and other employees so that issues and solutions are understood.

●Gathering business/reporting requirements from the clients and converted them into technical specifications.

●Publishing and deploy reports in the report server

●Transfer Excel Files and AS400 tables to SQL server database.

EDUCATION

University of Zimbabwe, BS in Computer Science 2000

Contact this candidate