Sql Server Management
Resume:
Jawaid Memon
Programmer / System Analyst
******.***@*****.***
Profile
A Microsoft Certified technical Specialist, with 8+ years of experience in development, project coordination, performing complex activities in designing, development, testing, debugging, delivering and supporting business system solutions within different team environments including banking applications Financial/Non-Financial. Experience with web, desktop and database software development life cycles (SDLC). Expertise with n-tier development architecture and OO-based development, Experience with SharePoint 2013 support and administration i.e. creating business surveys, web-parts, document/list libraries, managing pages, user permissions and also can do coding if required for SharePoint. A team player, quick learner and easily adopt/fit in new environment with great system/support troubleshooting skills.
Educational / Certifications
Bachelor of Science (Software Engineering) University of Sindh Jamshoro, Pakistan 2002-2006
MSCTS: Microsoft Certified Technology Specialist: .NET Framework 2.0 - Web-based Client Development.
Skills
Experienced with programming languages and tool i.e. C#.NET2.0/3.5/4.5, ASP.NET 2.0/3.5/4.5, Razor, MVC
Experience and skills in desktop and web application development.
Good Troubleshooting and problem solving skills
Experience with Service Management for SLA (Service Level Agreement), Problem / Change management in the organization.
Complete knowledge of SDLC process (Software development Life Cycle) Agile/scrum.
Software Code/Release management using different tools i.e. (VSS, Team Foundation)\, Clear Case, Synergy)
Experience and skills in Designing Crystal Reports using Crystal Reports tool and with VS.NET
Experience and skills in software analysis and design using object oriented analysis and design methodology and tools
Experience and skills in software testing and quality assurance
SQL/PLSQL procedures/triggers/functions.
SQL Server 2005/2008/2012, Oracle 9i/10g/11g, Sybase (11, 12, 15.7) ASE.
Design & development of SAP business objects universe, desktop/web intelligence
ETL: SSIS/DTS/SSRS
Optimization of SQL scripts i.e. Query Plan (table scans, I/O), temp tables. Plus ability to write complex and fast result query results.
TDD (Test-Driven Development), to write a code to do automatic unit testing for developed code.
Ability to lead a small team of developers/support and walk them through whole process of releasing and production deployment, i.e. UAT processes, Security Clearance project, Security penetration testing, deployment, arranging the production servers, DMZ production servers, server VA (Vulnerability Assessments) testing, Developed Application A testing.
Technologies
Experience
TDD
2+years
Service Management for SLA/Problem/Change Management
~5 Years
SharePoint 2013 (Administration/Content Management/Surveys/List)
1+Years
MVC
3 + Years
C#
7+ years
Asp.net
6+ years
Entity Framework
2+ years
WCF (Windows Communication Foundation)
1+ year
SQL Server 2000/2005/2008/2012/2014
7+years
Crystal Reports
7+years
MS Access SQL reports by combining all different DB servers i.e. (oracle, SQL Server, Sybase, DB2, excel)
5 years
MS VSS/MS TFS
3+ years / 2+ years
SAP BI (Desktop / web Intelligence) [Business Intelligence]
3+years
Sybase, Oracle, SSIS, SSRS, JQUERY, LINQ, XML, XSLT, IIS6, IIS7, IIS7.5, HTML5, CSS, JavaScript, SDLC, Razor, WebMatrix, web services, windows services, Bootstrap
Work Experience
Systems Analyst at Abu Dhabi Islamic Bank (ADIB) (Location: Abu Dhabi, United Arab Emirates)
May 2011 to Jan 2016
Job Role: Project Co-ordination, Software Development, to follow the Agile SDLC process with TDD (Test Driven Development) (Including documentation), ad-hoc reports, Support for Financial / Non-Financial applications, Implementation, Communication with business for requirements, developing TDD based application for better performance.
Software Development (windows/console/web) (.NET Technologies with VS 2008/2013/2015)
oAutomate Attendance system for Senior Staff
oIntegrating Emirates ID with ADIB core application.
oWelcome Emailer (To Send emails to Barclays migrated Customers into ADIB)
Managing Projects
oIntranet Portal upgrade – based on SharePoint 2013 (Techsource)
-An intranet based SharePoint portal for ADIB users, to allow them share/create/maintain document/policies and meetings.
oSignature Capturing System – Deployed for UAE/ All International branches (Vendor 01Systems)
-Signature capturing software for staff to capture customer signatures into ADIB environment.
oQueue Management System (Vendor SEDCO)
-Customer Visit Management System, which allow customers to print ticket wait for turn, based on priority customers level.
oBoard Pad (ICSA Board Pad) (https://connect.adib.ae)
-Board Pad allow board member to attend meetings anywhere in the world with registered iPads and allow them to upload documents.
oBlue Print (ICSA One World) (https://OneWorld.adib.ae)
-Blue Print allow board members to arrange meetings/invitation/reminders and it also allow them to create a form based authentication with restrict members to view and authorization.
oAccounts / Covered Card E-Statements (Avanza)
-An electronic account or Covered Card (Credit Card) statement mailing system for registered users. It send email to the users on bases of Daily/Weekly/Bi-Weekly/Monthly/Quarterly/Bi-Annually/Annually statements of the account or cards.
oClickPSS – (SeeinfoBiz)
-An Emailer to send emails on marketing campaign(offers) to registered users/customers
oSmart Card Initiatives (Online / Offline)
-An online System for Credit Cards (Covered Cards) to allow user buy/sell commodities deals online, without visiting branches. It also allow them to transfer funds from one STI (Short Term Investment) to another STI Account.
oIncoming Payment solutions
-A WPS/FTS systems to receive payments for Barclays migrated customers from Central Bank to ADIB Accounts.
oEmployees Information System for HR
-A SharePoint 2013 based web application to get Employees Personal information for HR Department.
oADIB MOI Mortgage Solutions for ADP [Abu Dhabi Police]
-An auto (cars) mortgage system to be communicate directly with local police in order to issue the mortgage to the customer.
oADIB Smart Connect
-A SharePoint 2013 Nintex based workflow application to get customer information through middleware (ESB) and process it through series of approval using workflow.
Support
oAd-hoc core System reports.
oSharePoint 2013 Support (Administration/ managing site content i.e.(Team Sites/Pages/Surveys/Lists/Documents libraries, group/user level permissions)
oProvide Support for All Developed/Managed projects
oSQL script Optimization
oReports design development using crystal reports/Business Objects/MS Excel & MS Access
oSupporting core applications in the bank (Mosaic, Phoenix, ICCS (Cheque Clearing System))
oAnalyze and problem solving.
oDatabase troubleshooting / SQL script troubleshooting
oManaging Business Object Management Console / Info-view
oCollecting system requirements from business and sharing with vendor for implementation
Automatic Attendance System for Senior Staffs
Description: Automatic Attendance System is based on two modules one using web service and other using console application calling a web-service to sign for senior staffs automatically when they will open/unlock the station first time in a day. It is written in .NET technology integrated with SQL server 2012 DB.
Tools and Technologies: C# .NET4.5, SQL Server 2012 (VS 2013)
Integration of Core Banking Software with EIDA [Emirates Identity Authority] services
Description: application is based on windows/Console /web technologies, which allow reading data from Emirates card and passport, which provides validity services and genuine authentication of the cards/Passport with Government EIDA authorized services, through applet and SDKs.
Tools and Technologies: C#, ASP.NET, SQL Server 2008 (VS 2013)
Bulk Emailer
Description: Bulk Emailer is a windows based application, which reads an email template and a pdf attachment template and based on provided Information it sends out email to all customers in bulk.
Tools and Technologies: C# (VS 2013)
ERP (Enterprise Resource Planning) (Web Application)
Description: ERP web site is fully package for Finance companies. This allows users to retrieve customer(s) information through single portal and perform various tasks or updates if necessary. ERP is directly dealing with active directory for each user to retrieve security and information and group restrictions. ERP is rich with financial and not financial reports to help management for decision making. ERP major modules are Finance, Automation Banking System, and Internet Banking and Reporting sections.
Tools and Technologies: C# 4.5, ASP.NET 4.5, SQL Server 2008
Software Engineer at ITS Retail System (Pvt.) Ltd. UK. https://www.itretail.co.uk
Jan 2008 to Jan 2011
Job Role: Software Development (Including documentation), ad-hoc reports, Supporting
Design, developing and maintenance desktop applications using C#.NET (2.0)
Worked on N-Tier application architect (MVC)
Develop, debug, test, document, support and maintain software
Analyze and write software requirement and software design documents
Perform peer code reviews
Assist in software configuration management and processes
Design simple and complex DB Scripts (Store-Procedures, views, functions and Commands) for SQL server 2005/2008
Maintain active database bugs
Water Marked Images (Web / Windows Application)
Description: Water Marked is built in both technologies web and as well as in desktop. It is application for marking the images with another image on the middle of the marked image to make image private. It is freelance requested software. Software is also capable of converting the image type into any image format and also resizes the Image.
Tools and Technologies: C# 4.0, ASP.NET 4.0, VS2010.
Retail Manager (Windows Application)
Description: Retail Manager is a windows application which manages the goods in branches. It is the application for one branch and multi branch with different interfaces. It works at tills backend software. It is developed on layer technology. Capable of automatic downloading from suppliers and updating stock in branch and automatically send order to supplier.
Tools and Technologies: C#, VS2005, Crystal Reports, SQL server 2005.
POS (Point of Selling) (Windows Application)
Description: POS is windows application, which runs over tills. It is frontend software which is design to work with Retail manager. It also sends order and generates reports.
Tools and Technologies: C#, VS2005, Crystal Reports, SQL server 2005.
Junior Software Engineer at Buraq Integrated Solutions (Pvt.) Ltd. (Location: Pakistan)
May 2007 to December 2007
Job Role: Software Development (Including documentation), ad-hoc reports, Supporting, Deployment.
Design, develop and maintain web applications using (C# and ASP.NET) 2.0
Design, develop and maintain windows applications using C# 2.0
Design DB and wrote scripts, views and stored procedures scripts for various applications using SQL Server 2000
Code, debug, test, support and maintain software
Reporting to software team lead
Create use cases and other design documents
Document Creator Modeler integrated with Visio application (Desktop Application)
Description: This desktop application is the part of the product named workflow. This generates the result and reports for the end user, from the mapped database to user readable form, which helps the end user to work with the workflow. It uses web services for changing the mapped database to user readable format.
Tools and Technologies: C# 2005, VS2005, Crystal Reports, SQL server / Oracle database.
Stock Management System (Desktop Application)
Description: Stock Management System is developed for a pharmacist company for maintenance of their record in and out from the company, and generating day wise, monthly, yearly reports for the company.
Tools and Technologies: C# 2005, VS2005, Crystal Reports, SQL Server.
Distribution Application (Desktop Application)
Description: Distribution Application is developed as product. This application worked as remote application/text based chatting application and sharing data / sending data from one terminal to another.
Tools and Technologies: C# 2005, VS2005, Crystal Reports, SQL Server.
Employee Management System (Web Application)
Description: Employee Management System is developed for collecting information from employees of any organization. It is an oracle based software which collect information from end-users like family, friend, contact, emergency contact details, spouse details etc. In admin module it also allows to print card for employees.
Tools and Technologies: ASP.NET with C#, VS2005, Crystal Reports, Oracle database.
CV Management System (Web Application)
Description: This web application is the project of Government of Azad Jammu & Kashmir. This web application gets the information from the employee(s) and makes a CV for them.
Tools and Technologies: ASP.NET with C#, VS2005, Crystal Reports, SQL Server / Oracle database.
Human Resource Management System (Web Application)
Description: Human Resource Management System (HRMS) is developed for Government of Azad Jammu & Kashmir. HRMS web site collects the information of employees working at Azad Jammu & Kashmir and on that information it build the final reports, bases of Department, Designation, and Reporting officer.
HRMS is released in three versions, one with SQL server 2000, 2nd same as 1st but with Oracle database, 3rd with number of changing's and some additions with Oracle.
Tools and Technologies: ASP.NET with C#, VS2005, Crystal Reports, SQL server / Oracle database.
Contact this candidate