Data Developer

Abderhakim Muzemil

adgt3l@r.postjobfree.com

240-***-****-Washington, DC

Highly motivated SQL developer with detail-oriented, ownership-feeling, and proficient in building and maintaining professional relationships. six years of experience in Database and application Development, Design, Business Intelligence Applications, System Analysis and design, Support of MS SQL Server, Java, web services. Proven experience managing all aspects of the software development life cycle, configuration management, change management, and support for a major enterprise system. Working with end users to understand functional and non-functional requirements. Team player with strong interest of teaching and sharing others best practices.

Technical Skills:

•Languages: T-SQL, MySQL, PolyBase, PL/SQL, XML, .net, Java, HTML, JavaScript, Json, VB- Script, Design Pattern, HTML, CSS, bootstrap and PowerShell Scripting

•SDLC: Agile, Waterfall, Iterative

•Operating Systems: UNIX, Ubuntu, Linux, Windows

•Web Service: REST and SOAP

•RDBMS: SQL Server 2019,2017,2016,2014,2012, Oracle 11 g and MS-Access

•Web / App Server: Web Sphere Application Server, JBoss, Apache Tomcat

•Tools: Spotlight, Actifio, Query Analyzer, Profiler, Query Execution Plan, and Visual studio, Hadoop, Database Engine Tuning Advisor

•NOSQL DB: MongoDB

•Packages: Microsoft Office, Lotus Notes, MS Visio, MS-Project

Professional Certification:

•Microsoft certified Solutions Associate in SQL Server 2016

•Certified Oracle Linux

Education:

•B.Sc. in Computer science, information System

Professional Experience:

Career Note: Available for full time, w2 employee

DBMS and Application projects:

Car License Issuing Registration DBMS project:

•Analyzed business requirement of Car license registration System

•Motor vehicle staff administers driving tests, driver’s lessons, interviews, inspecting their car for examination and issues driver licenses to Clients at different branches.

•identified the entities, attributes, tables, relationships

•normalize the tables and designed the ER diagrams

•wrote SQL queries, subqueries, stored procedures, functions, indexes and triggers to perform CRUD database operation

Migration account reconciliation System:

• Analysis attributes and tables for reconciliation between two of legacy databases and core banking databases in the test Environment.

•Designed SQL function for identifying missing migrated field’s values for all banking accounts, I had used SQL concat and join.

•wrote a SQL server script for comparing two databases, first I checked it for a single branch, and it was working properly, then I wrote a SQL function that is working for all 2000 branches.

Proactive Log Monitoring System:

•Developed a service for reading log file and identify severity level if Error or debug alert using on performance on the system

•Developed a service for removing locked users Sessions and send alert for monitoring team

•Implemented on the test environment and applied in the production environment

Big Data Analysis System:

• Conducted Big Data analysis of a bike company using SQL in an amazon web service

•Experienced in creating Ad -Hoc, parameterized and Linked reports using SSRS

•a network displaying the complete system with plots, graphs, and seasonal impact on bike riding conditions.

•Experienced in creating various Reports involving variety of features like Reports, Charts etc.

•Extensively worked on advanced subqueries queries to manipulate reports

Wells Fargo, Des Moines, IA

MS SQL Server Administrator/Developer Sept 2017-Aug 2020

Wells Fargo is a diversified banking, financial and Mortgage Company that provides a broad range of financial operations. I worked as a SQL DBA for their Backward & Forward Engineering using different data modeling tools like Erwin, Visio, and SQL Server Data Diagram. I was also involved in creating and modifying tables, Index, Constraints, Views, Stored Procedures and Triggers

Responsibilities:

•Installed MS SQL enterprise servers on production, test and development boxes.

•Managed Security by dropping and adding users, logins, aliases, and groups to the databases and granting/revoking permissions on Database objects.

•Performed stored procedures, Triggers, Views, Function

•Handled Performance tuning by dropping and rebuilding index.

•Handled Auditing stored procedures for optimization and improving performance.

•Extensively used SQL Server Management Studio, SQL profiler, SSIS, and SQL mail services.

•Involved in Writing T-SQL and Stored-Procedures

•Assisted SQL developers to optimize SQL queries and Stored Procedures

•Created Backup strategy for production and development environment

•Performed Database Backup & Restore, Scheduled jobs for the Database Maintenance

•Monitored Servers activity and then solving the issues

•Developed security policy and enforced it by adding users, logins, and groups to the databases and granting/revoking permissions on Database objects.

•Monitored SQL Server Error Log and space usage

Environment: MS SQL Server 2016/14, SSIS, SSRS, SSAS, OLAP, T-SQL, Query Analyzer, PowerShell scripting, Linux, Windows, ETL, MS Word, MS Excel.

PNC BANK, Pittsburg, PA Jul 2016-Aug 2017

MS SQL Server Developer

PNC offers personal retail banking and credit card services to customers in the United States. The project scope involved extracting data from different sources then loading the data into the data marts which support specific dashboards. It also generates reports to support the marketing department for business analysis.

Responsibilities:

•Design, Develop and Maintain complex queries, stored procedures, triggers, views and SSIS packages

•Created the package to import data from multiple sources to the staging environment and to export data from the staging environment to the Data Warehouse using SSIS.

•Created variables and configuration files to make the package more dynamic and schedule jobs to run automatically using SQL server agent Used multiple join statements to retrieve data from multiple tables

•Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance

•Performed daily tasks including backup and restore by using SQL Server Management Studio

•Setup profiler traces to support troubleshooting activities in QA environments

•Created reports using SQL server Reporting service, Extensively Used Variables and parameters

•Experienced in Developing and Extending SSAS Cubes, Dimensions and data source views in SSAS, deploying and processing SSAS objects.

•Proficient in scheduling and deployment of the reports and uploading files to a report server catalog from the report manager

Environment: MS SQL Server 2019,2017, 2012, Spotlight, Actifio, SSIS, SSRS, SSAS, OLAP, T-SQL, Query Analyzer, PowerShell scripting, Windows, ETL, MS Word, MS Excel

Application and Database Developer August 2014- June 2016

Bank of commercial Ethiopia, Addis Ababa, Ethiopia: Provided extensive technical expertise and solutions for development of different customizations with the core banking application depending on the requirements of clients. Developing business logic, data access, and presentation layers for new and existed applications. Creating different Supported services or applications for managing commercial operations. Handling application development in production, testing, and coordinated unit testing.

•Wrote SQL queries, stored procedures and triggers to perform back end database operation.

•Writing validation and exception handling application during CRUD operations

•Wrote SQL queries, stored procedures and triggers to perform back end database operation.

Environment: MS SQL Server 2012,2008, SQL, web services, Aix operating system, Java.

Contact this candidate