SUMMARY:

• Knowledgeable professional with 8+ years of Information Technology experience, including proficiency in IT software and hardware such as SSIS, SSRS, SQL, VB, ASP, PHP, LAN / WAN management and SQL servers. Well qualified to design and implement database architecture designs coupled with proficiencies in monitoring, tuning, backup, migration, and support. Continual learner recently completing a graduate degree in Network and Communications Management. Strong understanding of database concepts and systems. Effectively ensures data integrity through scans, limiting users to “read only” or “read/write” access as needed. Capably captures key data using queries generated through SSRS. Fluent in French and English.
• Strong skills in creating SQL objects like Tables, Views, Stored Procedures, Indexes, Cursors, Functions, DDL/DML Triggers, Temporary tables and User Defined Data types (UDF).
• Excellent experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS.
• Experience in creating packages, Jobs, Sending Alerts.
• Strong skills in Creating, Configuring and Fine - tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experience in creating complex SQL queries using joins, sub queries and correlated sub queries
• Experience in Instance Configuration and database Creation
• Experience in Managing Databases and Automating Tasks
• Experience in Database Monitoring and Performance Tuning
• Experience in Backing up, Restoring Databases and Managing Indexes

TECHNICAL SKILLS:

Programming Languages: Visual Basic, Asp, Php, C / C++, Html/Xhtml, JavaScript, Vbscript, T-Sql, Cold Fusion

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2014, Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Windows 2007 Server, Windows 2003 Server, Oracle

Databases: MS SQL server 7.0/2000/2005/2008, 2012,2014 Oracle, MS Access.

SQL Server Tools: SQL Server Management Studio, BIDS (SSIS, SSRS), SQL Server Query Analyzer, DBCC, SQL Server profiler.

Development Skills: SQL, PL/SQL, SSIS/SSRS

Languages: VB Script, T-SQL, HTML, XML, ASP

EXPERIENCE:

SQL, BI DEVELOPER

Confidential, Columbus, Georgia

Responsibilities:

• Creates ETL packages with different data sources (SQL Server, Flat Files, and Oracle) to load the data into staging tables by performing transformations using SQL Server Integration Services (SSIS).
• Uses SQL Server Agent to create jobs and schedule them to execute SSIS Packages on a predefined time.
• Uses SSRS Reports to generate different types of reports for Business Intelligence.
• Creates numerous processes through MS Visual Studio (SSIS, SSAS, SSRS) and MS SQL Server to develop data warehouse projects.
• Creates PowerShell scripts for reporting and automating tasks
• Write complex SQL queries using complex joins, grouping, aggregation, nested subqueries, cursors…etc
• Creates reports from the IVR systems
• Develop SQL scripts to be used by web developers
• Hands on experience asDB2 DBA for mainframes
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS)
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in creating complex DTS Packages in SSIS for Data Migration
• Developed complex custom reports and deployed them on server using SSRS.
• Loop through Flat Files in SQL Server Integration Services
• Building Dashboards in SQL Server Reporting Services
• Designed, tested and debugged DB2 native stored procedures. Worked with remote stored procedure calls

Database Administrator

Confidential, Columbus, Ohio

Responsibilities:

• Pulled data from Oracle to SQL Server as part of a SSIS project.
• Drafted scripts to handle column store indexes.
• Coordinated performance tuning and optimization of stored queries and procedures.
• Used DBCC Utilities for Database consistency checks, Performance Tuning, Query Optimization.
• Creates ETL packages with different data sources (SQL Server, Flat Files, and Oracle) to load the data into staging tables by performing transformations using SQL Server Integration Services (SSIS).
• Uses SQL Server Agent to create jobs and schedule them to execute SSIS Packages on a predefined time.
• Uses SSRS Reports to generate different types of reports for Business Intelligence.

Help Desk

Confidential, Columbus, Ohio

Responsibilities:

• Performed troubleshooting as needed.
• Diagnosed, troubleshoot and resolved a range of software, hardware and connectivity issues.
• Experienced IT help desk support representative with strong background in the installation and maintenance of software and hardware.
• Worked with end users resolving their software and hardware issues in efficient manners
• Installed, configured and modified hardware and software to ensure optimal performance
• Documented all technical issues. Highlighted steps taken to remediate problems.
• Created, responded to, escalated, and closed tickets. Tracked all outstanding tickets, worked closely with Tier II Technician to ensure any problems are resolved in timely manner.

Information Technology Specialist

Confidential

Responsibilities:

• Managed SQL server databases from conceptualization to planning, testing, and post-implementation support.
• Arranged for system backups and restores, data export, and script monitoring.
• Managed database security and permissions as well as debugging and maintenance
• Originated applications to pull and manipulate data.
• Diagnosed and helped resolve issues through IT troubleshooting.
• Developed and updated the company’s website, using ASP and SQL Server. My team also developed websites for foreign countries’ news agencies.
• Developed the company’s software product, using PHP and MySQL.
• Implemented TCP/IP core networking services using WINS, DNS, DHCP and Windows NT
• Designed and developed applications used to access and manipulate data within various databases