SUMMARY:

• Over 10 years of IT experience in Database Management, Design and Architecture
• Expert in data analysis and data modeling design and architecture.
• Expert in developing analysis reports on MS SQL Reporting Services 2005/2008 and Crystal Reports.
• Extensive hands on experience in writing, optimizing & debugging stored procedures, functions, views and triggers, troubleshooting database issues.
• Experience in installation, configuration & maintenance of MS SQL Server 2008, 2005 and 2000
• Experience in database backup, recovery and disaster recovery procedures.
• Experience in setup and configuration of high availability solutions such as Replication, Database Mirroring, Log Shipping.
• Experience in automating the migration/transferring of data/information from one form to another using MS SQL Integration Services.
• Experienced in creating databases based on functional requirements and system design.
• Experience in assisting application developers in creating conceptual database designs that meet the business and technical objectives of various projects.
• Working experience in an Agile and SDLC development environment.
• Working experience in financial/card processing, high volume transactional mission critical data system
• Working experience in HR and Payroll systems (HRIS) such as Microsoft Great Plains Business Solution.

PROFESSIONAL EXPERIENCE:

Lead Database Management and Architect

Confidential

Duties and Responsibilities:

• Manage, maintain and administer the company's enterprise transactional database servers.
• Architect, design and develop database driven solutions that meet technical requirements such as ETL, reporting, data analysis and data modeling using tools such as Erwin, Crystal Reports and MS SQL Reporting Services.
• Provide consultation to engineering teams regarding SQL programming, performance tuning, design and proof of concept using best practices.
• Manage two offshore and onshore resources on database implementation and changes to design. Act as a mentor and coach for SQL developers on data design and plan architecture
• Work with business analyst, project management and finance teams for data trens reporting needs and analysis.
• Create and strictly implement on promoting the company’s T - SQL best practices, data security, policy, PCI guidelines and design standard practices.
• Work with developers, Testers and QA to review, test and execute database changes from one environment to another making sure that each object is efficient, functional and optimal to all environments including production.
• Lead database technology upgrade, data archiving, performance tuning and data security implementation
• Production DBA role:
• Monitoring, administering and configuring SQL Server 2005 database server
• Setup and configure transactional replication and log shipping
• Monitor the company’s high availability solution and disaster recovery solution
• Configuring security, maintaining user access controls and object permission
• Overseeing backup schedules and jobs are functioning on a day-to-day basis
• Support and troubleshooting mission critical OLTP production database servers
• Applying database updates from time to time and as needed.
• Provide 24x7 on call support for any database related issues such as database consistency checks, routine maintenance, backups, recoverability, security, replication, log shipping, mirroring and availability of all production and non production MS SQL Server Databases

Sr. Database Administrator

Confidential

Duties and Responsibilities:

• Administer company’s MS SQL database 2000 and 2005
• Developed backup & disaster recovery strategies and implementing on all production servers.
• Creation of DTS/SSIS packages to automate data load from variety of data sources.
• Write and review stored procedures and functions created by the application team.
• Monitor SQL performance by using profiler and performance monitor to check on running queries, deadlocks, blocking and auditing.
• Creating and managing schema objects such as tables, views, clustered indexes, procedures, triggers.
• Configuring Database Mail, SQL Mail and Log Shipping and Linked and Remote Servers
• Implemented new search algorithm for fast and effective search of card holder information. Revised all affected stored procedure to comply with this new search algorithm.
• Create user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Setup log shipping and troubleshooting log shipping errors when arises.
• Oversee Integrated Voice Recording (IVR) system database backend
• Manages ACH and card transactions from RBS and made part of the production database. Provide centralize reporting services to the company.
• Assess hardware and algorithm performance used to encrypt and decrypt confidential information using 3 types of encryption algorithm.
• Redesigning and remodeling of new database and application architecture
• Support application development team in deploying and testing the application, releasing application bugs and features from testing stage to production environment in an n-tier architecture.
• 24x7 call and technical support

Data Analyst/Database Administrator

Confidential

Duties and Responsibilities:

• Administer institute’s MS SQL Server: create database, views, tables, stored procedures and functions; install patches releases; managing backup and disaster mitigation; installation, optimization and maintenance; managing security, roles and permissions; managing and working with linked servers and distributed transactions; implement data warehousing concepts, architectures, and processes.
• Write functional requirements for computer systems using models and diagrams to represent the processes and functions involved. This includes working with UML diagrams, flowcharts, entity relationships and systematic diagrams for technical representations.
• Investigate and applies new and emerging technologies, particularly Internet-related technologies thereby formulating new applications or simplifying existing ones.
• Design and develop information systems for the institute’s data processing and networking needs. Web and window based applications developed using ASP/VB.net, ASP Classic, VB6, DotNetNuke framework, with Dreamweaver 8, Visual Studio and Visual Studio .Net/2000 as development tools.
• Data Analysis and Report automation. Eliminating data redundancy and inconsistency by consolidating data sources; execute data audit and analysis; create automatic report generation using Crystal Reports and/or MS SQL Reporting Services or automatic PDF generator using Active PDF toolkit thru ASP Classic coding; automating email notification thru MS SQL Mail Agent; importing and exporting data using MS SQL Data Transformation Services (DTS).
• Coordinate with the organization's key data persons to plan and design connection schemes to a wide range of databases. Coordination with Finance, HR and Research support group on information system and MS SQL database server linkages.
• Install, upgrade and/or migrate legacy systems to newer platforms and more modern computing environments. This includes upgrades from MS SQL 7.0 to MS SQL 2000, upgrades from MS SQL 2000 to MS SQL 2005; HR application upgrades from manual system to HR Information System using MS Great Plains.
• Coordinating and leading project meetings to facilitate timely project execution, tracking project issues and facilitating resolution using MS Project 2003, IT developed online dashboard project details and thru regular meeting schedules.
• Provide documentation for developed applications and procedures. Establish document standard (user’s manual, versioning, technical documentation, Including design standards); developed software development standards for shared adoption (specifically including conventions on naming of projects, objects, variables, functions etc);selecting and standardizing on visual modeling tools; developed data dictionary for all databases; development of quality assurance processes;
• Maintain, troubleshoot, and debug existing systems and applications and databases, including installation and configuration of IT supported commercial software or applications shared by or with other institutes.
• Provide consultation to other IT personnel in the institute directly involved in information processing to propagate technical know-how onto end-users.
• Coordinate with outsourced application designers, developers, or consultants, if any, in the design and development of software applications. This may include assisting, collaborating with, or providing technical support in developing applications such as MS Great Plains (HR Information System), Micros Fidelio (Hotel Management System), Imanami (Active Directory Synchronization)
• Lead the development and adoption of best practices by the software development community in so far as the use of administrative systems and data are concerned, ensuring that wheels are not reinvented and that relevant knowledge is effectively shared and institutionalized (captured for reuse wherever possible).

Database Developer

Confidential

Duties and Responsibilities:

• Convert user specification using flowcharts, data flow diagrams and system flowcharts into series of algorithms for coding proper. Specific tasks include:
• Designing database access through various SQL scripting using Visual Basic/Foxpro as front end
• Creating Transact SQL (T-SQL) scripts and functions for development and code
• Maintain existing database systems and evaluate backup and recovery procedures and research for white papers and articles with regards to database protection and administration. Specific task include:
• Creating SQL database recovery plan methods and procedures
• Testing recovery procedures and disaster mitigation specifically on SQL database servers
• Designing SQL database backup and recovery test and procedures
• Perform system administration to company’s HR/Payroll, SQL Server, Lotus Domino and Drawing file Servers. This includes but not limited to:
• Managing MS SQL 7.0 and 2000 database servers.
• Migrating from MS SQL 7.0 to MS SQL 2000 database server
• Extracting, transformation and loading of data using MS Data Transformation Services (DTS) with complex T-SQL scripts to manipulate data
• Administering security, permissions, access connections through series of SQL commands and scripting
• Monitoring SQL data integrity and functionality
• Provide support to company’s domain and exchange server
• Acquire and install new systems to include obtaining needs, researching product costs, planning installation, testing the system, implementing the system and providing training to computer operation personnel in different platform such as Windows 95/98, ME, XP, NT 4.0, NT Server, Windows 2000.
• Handle licensing agreement on the following: Microsoft OS Server and Client products, Adobe products, Symantec Anti Virus, Engineering drawing software, and all other software licenses with Service Level Agreements.
• Trains users regarding IT supported commercial software or IT developed applications or applications shared by or with other company.
• Assist in the installation, testing, administration and management of standard organizational programs and other software such as email, office, lotus notes client, databases, internet, intranet and other tools. Provide support to network infrastructure, telecommunications and other communication equipment