CAREER OBJECTIVE:

Microsoft certified technically proficient IT professional, seeking next opportunity in any of these areas: SQL/OpenEdge/Oracle Database Administrator, Business/Data/IT Security Analyst, or OpenEdge Developer. Though I am flexible, remote/telecommuting is preferred. I have over 14 years of track records as a self - motivated, responsible, and dependable remote/telecommuting staff member.

CAREER SUMMARY:

Over twenty years of experience in SQL Server (2000 to 2012) and Progress OpenEdge (OE 9 to 11), to include database design, installation, administration, and maintenance. Extensive experience in backend 4GL programming in OpenEdge, having strong analytical and design skills. Installed many database systems at client sites, including maintenance, performance optimization, and disaster recovery. Over a decade of experience in writing backend codes for a proprietary .Net and OpenEdge based CRM product, from design and development to implementation and customer support. Successfully completed many projects from project initiation to go-live implementation, and provided professional services involving product installation, enhancement, and data migration. Customer support experience to both internal staff and external clients, from troubleshooting to effective resolutions.

TECHNICAL SKILLS:

Database: SQL Server 2000/2005/2008/2012 (expert); Progress OpenEdge (expert); Oracle (basic), Microsoft Access (expert), DOL IV (prior experience), Powerhouse (prior experience).

Programming Language: Progress OpenEdge 4GL (expert), T-SQL (basic), HTML/XML (basic), eFormz (printing solution - expert). BASIC (academic); COBOL (academic), C++ (academic), Powerhouse (prior work experience), IDOL IV (prior work experience); ColdFusion (basic);

Operating System/Server: Various Windows and Windows Servers (basic), Unix (prior work experience), DEC/ VAX (prior work experience).

Productivity Software: Good working knowledge of various office products, such as Microsoft Word, Excel, Outlook, PowerPoint, etc.; Adobe Illustrator (intermediate); Adobe Photoshop (basic), Minisoft eFormz (expert); Nagios server monitoring software (basic).

Other Skills :, Software as a service (SaaS); Agile development (SCRUM); Microsoft Report Builder; SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS); Amazon AWS; RoundTable (version control software); Visual Source Safe; Team Foundation Server (TFS); JIRA; metadata work.

EMPLOYMENT CHRONOLOGY:

Confidential

Sr. CS Engineer

Responsibilities:

• Installation of enterprise wide database systems in Progress Open Edge and SQL Server Perform database installation and configuration (SQL and OpenEdge)
• Maintain data dictionary, including schema changes and management
• Perform database upgrades, including new releases and patches
• Database administration, maintenance
• Database optimization and performance tuning
• Troubleshoot performance issues
• Setup maintenance plans (backups, index rebuild, optimizations, etc)
• Disaster recovery plan
• Setup and maintain app servers and app services.
• Product development and maintenance work on an enterprise wide CRM software solution.
• The production is written in Progress OpenEdge for back end business logic with SQL and OpenEdge databases; the front-end is based on both OpenEdge GUI and browser-based .Net interface.
• The CRM product is modular and provides a wide range of solutions to association based clients that include customer maintenance, membership management, meeting registrations, publications and subscriptions management, continuing education, accounting, order fulfillment, customer service center, speaker engagement management, exhibit/booth management for shows and events. It also provided add-on option with QlikView BI solution
• Maintain master product versions
• Lead projects in enhancing master product
• Issue and manage product releases
• Perform product upgrades
• Sourcecode and version control management (RTB and Visual Source Safe)
• Provided services to many clients throughout the United States and Canada, to include: Installation of enterprise-wide .Net based CRM software solutions
• Client interview and requirements gathering for customizations and enhancements
• Systems analysis
• Preparation of high- level proposals, often including multiple alternative options
• Estimate analysis
• Frequent conference calls with project managers and customers in tracking and managing progress
• Write technical specifications for programmers, as well as general specifications for customers
• Engage in back-end code development work for customer solutions and enhancements
• Work with QA team and perform/lead final delivery and go-live implementations
• Perform product upgrades at client sites
• Data conversion work form legacy systems
• Data migration using SSIS
• Deployment of data models.
• Served both internal and external customers:
• Troubleshoot and investigate issues
• Provide bug fixes and resolutions
• Train and support internal customers (staff).

Confidential, Lumber Bridge, NC

Programmer/Analyst

Responsibilities:

• Analyze, design, test, implement, and maintain new information systems
• Modify existing programs to satisfy user approved requests
• Write new programs according to agreed upon specifications
• Design & implement user interfaces with additional features/external subsystems
• Interview users in order to complete the requirement analysis phase
• Perform data recovery on as needed basis
• Design, test, and write special, one-time requests on non-scheduled basis
• Write and modify user and applicable programming documentation
• Analyze user's requests and apply the most efficient method in solving them
• Run daily verification runs and take any necessary corrective actions
• Interface existing subsystems with others as requested
• Perform single, multiple, or global data dictionary changes as needed
• Unload, restructure, reload, and recompile needed data files / programs
• Perform data / file management functions such as reloading and re-indexing
• Maintain the Powerhouse data dictionary
• Provide IT support to internal staff, such as add, modify, or delete user accounts and provide appropriate menus / security requirements
• Maintain terminals and print queues
• Maintain all terminal, printer, data and voice line configuration in the MICOM unit
• Configure, connect, install new minor equipments, such as terminal and printers.
• Read manuals on straight forward problems in hardware devices and perform necessary repairs
• Notify hardware service contractors of any major problems and follow up till repairs are completed.