Mboli Karlmac

Fort Worth, TX *****

682-***-****

ac3znk@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 2 years of experience in IT as a SQL Server Developer and strong work experience on Business Intelligence tools.

Demonstrate professionalism, attention to details, collaborative nature and a quick learner. Strong communicator exhibited by working closely with users to identify and resolve problems. In addition to working well individually, an effective team player.

Develop detail and summary reports to include; drill through, drill down, parameterized, matrix, and chart reports using SQL Server Reporting Services (SSRS).

Experience in Database Design and development of applications with Business Intelligence using SQL Server 2012/2017 (T-SQL), Integration Services (SSIS), Reporting Services (SSRS).

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop SQL Objects and maintain Stored Procedures and User defined functions.

Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS 2012/2015).

Experience in migration of Data from various Data Sources such as Excel, Flat file, and SQL to MS SQL Server by using SQL Server Integration Services (SSIS).

Versatile team player with an aptitude to learn new technologies.

Experience in updating and creating Tables, Views, Stored Procedures, User Defined Functions, and other T- SQL statements as needed.

Deploy and upload SSRS reports to Report Manager for the end users and involved in enhancements and modifications.

Strong analytical and problem solving skills, Ability to work to deadlines, Results oriented Flexible, and Adaptable.

Excellent technical and professional client interaction skills with technical, functional and business audiences across different phases of the project life cycle.

EDUCATION

American Public University System - Associate’s Degree in Database Application Management.

School of Data Analytics - MS SQL Server BI/EDW.

Mountaina Computer Training Institute - Computer Networking, Web Development and Introduction to Computer Programming.

CERTIFICATIONS

Certified SQL Server BI/EDW Developer

PROFESSIONAL EXPERIENCE

SQL Developer/Reports Developer May 2015 to Present

Communications Test Design Inc Flower Mound, TX

Creating and maintaining SQL tables according to business requirements.

Utilizing the import and export wizard in SQL to transfer files in various formats (csv, excel, text, etc.) into SQL tables.

Merging files from different SQL database tables using Joins and exporting in various formats for functional and end users.

Manipulating data in SQL using data manipulation and data definition languages to achieve business needs.

Creating and managing databases, including SQL Server objects such as tables, views, stored procedures, user defined functions, etc., according to business requirements.

Updating and maintaining previously created SQL database tables.

Extracting data from SQL tables into the required format for business and end users.

Modifying and maintaining SQL queries written by current and previous developers.

Writing and maintaining T-SQL queries, views, functions, joins, and stored procedures used by reports according to the Business Requirements Document (BRD).

Verifying user access and ensuring that users follow the given naming convention to access the database.

Utilizing email and phone to respond to, and fix technical issues encountered when manipulating databases.

Assisting team members with documentation and interpretation of business requirements.

Utilized SSRS to create, develop and maintain reports in accordance with style, functional, and technical guidelines established.

Designed and deployed parameterized, matrix, drilldown, drill through, and sub reports.

Modified and managed various report models with multiple model objects, source fields and expressions.

Gathered and analyzed data, developed and built SSRS reports in support of the business.

Deployed reports successfully to production environment for access by end users.

Created chart reports in excel for ad-hoc reporting using pivot tables.

Worked with sources including Flat Files, Excel, and SQL, to perform the ETL (Extract Transform Load) process in SSIS.

Migrated data from various sources into SQL Server and Archives using the ETL tool in SSIS.

Used various data transformations in SSIS like, conditional split, derived column transformations, to move data to/from various sources to different destinations.

Environment: SQL Server Management Studio 2012/2017 (SSMS), SQL Server Development Tools 2015 (SSDT), T-SQL, SSRS, SSIS, MS Excel 2016, MS Access 2016.

TECHNICAL SKILLS

Operating Systems Windows 98/XP/NT/Vista/7/10

Database Tools SQL Server Management Studio (SSMS), MS Access, MS Excel

GUI Tools SQL Server Data Tools (SSDT), Visual Studio 2015

Languages T-SQL, HTML, CSS.

OLAP Tools SSIS, SSRS.

REFERENCES

Available upon request.

Contact this candidate