SUMMARY:

• More than 12 years’ experience with software programs both of client and server side. Including Data Architecture, Data Migration, Database Administration and Reporting Services
• Experienced in IT departments within diverse business environments, including Banks, Financial Investments, Call Center, Law Firm, Insurance Company and Solution Technology
• Experienced as an I.T Consultant, Team Leader, Systems Analyst, Software Developer and a Database Administrator
• Doing capacity planning, setting future plans and doing production development for best approach that will give more benefits to every applications.
• Performs technical specifications, provide the analysis and give recommendations on every aspect of SLA
• Guided teams in the development of relational database management systems (RDBMS) for clients and improved the consistency, recoverability and accessibility of data.

TECHNICAL SKILLS:

• C#.Net
• VB.Net
• Framework 4.0
• Framework 3.5
• Framework 2.0
• ASP.Net
• ADO.Net
• Web Services
• Window Services
• XML
• Visual Basic 6
• ASP
• PHP
• CAML
• JavaScript
• Vbscript
• HTML
• JQuery
• MVC
• CSS
• MS SQL 2014
• MS SQL 2012
• MS SQL 2008
• MS SQL 2005
• Oracle 11G
• Visual FoxPro
• Crystal Report
• SQL
• SSIS
• SSRS
• Visual Studio 2012
• Visual Studio 2010
• Visual Studio 2008
• Visual Studio 2005
• Sharepoint 2010
• Sharepoint 2013
• CRM 2011
• TFS
• Telerik
• Powershell 3.0
• IIS
• FTP
• SFTP
• HTTPS
• SSL
• HTML5
• Windows Server 2012
• Windows Server 2008
• Window Server 2003

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Administrator

Responsibilities:

• Defining objectives the determine information system requirements and making recommendations
• Managing and organizing multiple IT projects to lead in to high standards and global implementation
• Create clusters and monitor SQL Servers; alter and optimize SQL Databases and instances
• Support the definition, implementation and reporting of KPI´s and SLA´s
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Perform a Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
• Expert experience in implementing operational automation.
• Give recommendation on indexes, index management, integrity checks, configuration, patching.
• Write and troubleshoot SQL Code and design ( stored procedures, functions, tables, views, triggers, indexes, constraints )
• Solid acquaintance with windows server, security delegation, storage components.
• Provide SQL Database Operational support to tech users
• Creating custom functional reports using SSRS for the end user
• Plan and implement the overall analytics and business intelligence strategy
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement
• Develop and maintain reporting and analytical tools, including Business Objects
• Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs.

Confidential

Application & Integration, Solution Developer

Responsibilities:

• Supporting multiple production applications within the public and private sector organizations.
• Dealing with Application Support queries and issues that have been handed over by Second Level Support.
• Take ownership and responsibility of an issue from start through to a successful resolution.
• Provide specialist support and back - up to professionals within client companies
• Dealing with these queries by following customers’ procedures for fault resolution.
• Provide on-going technical maintenance and usage support of business applications in order to maintain their reliability and business benefits.
• Provide database design, development, and enhancement, as well as management and coordination of changes to existing applications.
• Provide a database architecture design through implementation, administration, monitoring, performance tuning, backup, migration, technical architecture analysis, design, development, and enhancement.
• Doing DB design, analysis, development, implementation and administration of 2008R2 and 2012 databases.
• Implementing high availability and disaster recovery solutions such as Always-on, Log shipping, data replication, and mirroring.
• Expert in DB performance monitoring, DB recovery, DB change management, and DB task automation.
• Experienced in working with different components of SQL Server including SSRS, and SSAS.
• Provides consultation to application developers in SQL coding and tuning, and coding and deployment of stored procedure
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• External Managers Integrated System (SQL 2008, VS2008, .Net Framework 3.5)
• Handling Data Architecture and Systems Integration
• Creating system backup plans and system jobs.
• In-charge of gathering systems requirement from the client-user
• Doing functional specification documents, technical design, and test cases scenario
• Creating system prototype for users on their own perspective
• Doing an analysis and design in technical aspects
• Creating case to case system diagram
• In-charge in integrating third party Livelink API in the system technical sides
• Performing system testing (Unit, Assembly, and Integration) to validate the efficiency of the system.

Confidential

Senior Software Engineer

Responsibilities:

• Handling 24/5 support on database from productions up to test environments servers.
• Responsible for doing automation in terms of database perspective to minimize time consuming.
• Developed custom database utilities created in ASP.Net with SQL backend using stored procedure to monitor the error logs, jobs, health checks, backup information, disk space utilization and etc.
• Implemented a backup strategy with the concepts of Weekly Full Backup, Daily Differential, and Hourly Transactional for the concept of point in time recovery.
• Evaluating and implementing third party software such as SqlLiteSpeed. To decrease the backup in a very minimal disk size.
• Creating and executing SSAS package for data migration and for business needs. Automated transformation of data, data filtering and concatenation coming from legacy system to a new system.
• Handling database change request (Alter Database, Restore Database Backups, Backup Request)
• Perform database fine tuning and queries optimization. Implementing clustered and non-clustered indexes, doing analysis review, creating filegroup.
• Reviewing and handling SQL Profiler Trace. Also, give recommendation to optimize stored procedure and select statement that running too much time.
• Administer, setup, and doing configuration on SSRS for business needs.
• Full time coordination with the team plus the counterpart on-shore.
• Handling database maintenance like a regular re-index job, integrity check, statistics update, shrinking logs.
• Administer installation, maintain and provide technical support for ensuring the security and integrity of the company database.
• Responsible for problem resolution, database configuration, capacity planning, and performance tuning.
• Responsible for day to day database operations, including system and product administration functions.
• Implement data models and database designs, data access and table maintenance codes.
• Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Perform feasibility studies, systems development and modifications in response to user requests.
• Create and maintain a Database Master Plan and Meta Dictionary.

Confidential

Systems Analyst

Responsibilities:

• Analyzes process to ensure maximum availability through change and problem management reviews changes effecting complete implementation and test/back out plans, and coordinates wide enterprise wide changes to ensure consistency and repeatable results.
• Handling a DBA role that administer all the databases from test to production. Implementing backup strategy, maintenance and monitor uptime.
• Creating custom sales report using views
• Hold a meetings; discuss task delegation and review issues; client visits - build relationships and review technical requirements
• Assisted management in defining computer system requirements and in system acquisitions
• Provide technical consultation and direction in the development and application of advanced theories, concepts, principles, and processes for utilization of computer
• Advised management on policies, procedures, and standards as they related to complex computer systems in order to improve operations and advance capabilities
• Performed coding, testing, installation, and maintenance of computer programs and systems
• Prepared project resources estimates, schedules, and cost analyses
• Provided diagnostics support to correct processing anomalies in complex computer programs
• Interpreted requirements and performed analyses to ensure that objectives were met

Confidential

Senior Programmer

Responsibilities:

• Developed complex applications and updates throughout SDLC, including analyzing business requirements, developing technical specifications, planning, coding, testing implementation, and QA.
• Created SQL scripts to query SQL database; developed C#.NET/ASP.NET forms via SQL that significantly decreased data entry and transactional processing times.
• Spearheaded project planning sessions with managers, business analysts, and team members to analyze business requirements and outline proposed IT solutions.
• Led design reviews and provided recommendations. Incorporated security requirements into design and ensured effective workflow.
• Supervised code reviews and ensured all solutions met architectural specifications.
• Collaborated with database administrators to design appropriate data structures.

Confidential

Computer Programmer

Responsibilities:

• Employee 201 File
• Performance Management
• Time and Attendance
• Payroll, Compensation and Benefits
• Employee Intranet