We provide IT Staff Augmentation Services!

Sql Developer Resume

3.00/5 (Submit Your Rating)

North, CarolinA

OBJECTIVE:

  • To work in a challenging environment that provides opportunities in implementing Information and Knowledge Management (ECM, EDM, BPM, RM and ERP) methodologies and solution

SUMMARY

  • Subject Matter Expertise and Domain Knowledge with 15 years of experience in Design and Implementation of Electronic Document (DM), Content (CM) and Business Process (BPM) solutions for Health and Life Science, Retail, Supply Chain and Senior - care industries
  • Conversant with Systems Development Life Cycle (SDLC), Waterfall and Agile/Scrum methodologies for Project Management
  • Strong understanding of web technologies and ERP systems Integration
  • Good communication, leadership skills, analytical and presentation skills, problem solving skills and motivated to learn

TECHNICAL SKILLS

Operating System: Windows (2008 Server, 2003 Server, Win 7, XP), Linux

Database: Oracle (9i, 10g), SQL Server (2000, 2005, 2008)

ECM Tools: Open Text Content Server 9.x, 10, 10.5, LAPI, SharePoint 2013, IBM FileNetEnterprise Connect, Enterprise Scan, Brava, LiquidOffice eForm, Capture CenterKofax OCR, Autostore

ERP Tools: SAP ECC 6.0

Development IDE: Eclipse, SQL Server Studio, Oracle SQL Developer, Apache Directory Studio, BadboyContent Server Builder, CSIDE

Web Server: IIS 7.5, Apache

Application Server: Tomcat, JBoss

Language: Java, C++, C

Scripting: PowerShell, Perl, OScript

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

SQL Developer

Responsibilities:

  • Design Categories and Attributes in Content Server for storing the metadata extracted from FileNet
  • Design Taxonomy structure and security access for storing the documents extracted from FileNet to Content Server
  • Develop Java program using JAXB component to extract data from FileNet and store them as XML tags in OpenText Control file
  • Develop Powershell scripts to automate the process of file extraction from FileNet, migrate metadata to Content Server Control file and upload data/control files via FTP to Content Server site
  • Evaluate OpenText’s Extended ECM and InfoFusion application for archiving and migrating data from SAP to Content Server
  • Develop Java program to read comma delimited text file extracted from SAP system and convert them to separate excel files based on the business rules
  • Develop complex SQL queries to merge data from different database table and combine as single table
  • Develop Enterprise Scan workflow process to scan documents received via fax and store it in Content Server along with document attributes
  • Prepare Project Design, QA and User Training documentation for data migration project

Confidential

SQL Developer

Responsibilities:

  • Provide direction, prioritization, and guidance on project activities to meet business targets.
  • Responsible for status reporting, risk management and resource management
  • Support multiple teams through various phases of project life cycle which includes requirements analysis, planning, development, testing, implementation and maintenance
  • Manage projects related to Enterprise-wide Implementation, Migration, Integration, Maintenance and Support of WCM, EDM and BPM solution
  • Create rollout schedule and scheduling of resources to perform the configuration, installation and training
  • Create and maintain documentation including business requirement documents, functional design documents, test plans, project plans, and change control documents
  • Prepare RFI and RFP responses for new and existing bids
  • Follow GRC (Governance, Risk, Compliance) model for assessing existing and new projects
  • Apply architecture best practices and standards at the program and project level
  • Identify and address key project constraints and requirements such as interfaces to COTS software, software distribution capabilities and special end-user requirements
  • Participate in webinars, training session, technology meet-up to evaluate and analyze new products and services from different vendors to integrate and enhance existing business solutions

Confidential

SQL Developer

Responsibilities:

  • Define project scope, goals and deliverables in the implementation of Invoice Scanning solution in collaboration with senior management and stakeholders.
  • Perform requirements analysis, and design of technical solutions to support Invoice Scanning initiatives
  • Identify options to reduce costs, enhance service and process quality of scanning invoices
  • Work with customers and QA team to develop test scripts and scenarios for user acceptance testing
  • Develop test plans, manual and automated test cases and scripts
  • Write instructions and manuals to guide end users with scanning process and storing files in electronic document repository
  • Manage the Corporate rollout of Livelink, Kofax Scanning and Oracle BPEL to production environment

Confidential

SQL Developer

Responsibilities:

  • Upgrade Livelink version 9.1 and associated modules to 9.5 and 9.5 to 9.7.1
  • Implement conversion of Livelink Database BLOB Storage mechanism to External File Storage
  • Implementation of DMZ architecture for Livelink by separating Web components (IIS Server) and Livelink Application Sever through Secure Extranet Architecture (SEA) module
  • Provide technical expertise in solving high-level and low-level issues with Livelink applications infrastructure
  • Administration of Livelink including system maintenance, creation and management of application user and group security permissions, project workspace, workflows, folders, documents and reports
  • Create ongoing administration plan, standard operating procedures (SOPs), deployment procedure, checklists, test scripts and traceability matrix for ECM projects
  • Create backup, recovery and restore strategy and procedures for Livelink
  • Conduct performance monitoring and tuning of applications over TCP/IP network
  • Manage the periodic capacity planning and analysis which includes generating statistics reports on a weekly, monthly and quarterly basis
  • Design and implement web sites based on Microsoft Office SharePoint Server 2007 in a test environment
  • Prepare feasibility analysis for implementing Microsoft Office SharePoint Server as ECM solution
  • Perform regular maintenance of Livelink, installation of monthly patches, service packs, module upgrade and configuration
  • Design and implement Digital signature, Adlib express for PDF conversion and workflow procedures for Livelink 9.7.0 confirming to CFR 21 Part 11 validation
  • Design, Installation, Performance and Operation qualification and validation of Livelink for 21CFR Part11 compliance

Confidential

SQL Developer

Responsibilities:

  • Technical design, development, testing, implementation, training and maintenance of business process workflows and reports for Confidential agency using Livelink 9.2
  • Design migration of Livelink application and database from Windows/SQL Server to Solaris/Oracle
  • Collection and analysis of performance statistics for Livelink application and IIS webserver
  • Installation of Livelink webform module and development of E-forms to process reimbursable agreements
  • Installation of monthly service patches and planning of data backup and recovery process on a monthly basis
  • Create and maintain user and group accounts, reset passwords
  • Provide reports as requested on service delivery metrics
  • Support, perform and document Livelink technical configuration
  • Prepare documentation for Livelink risk analysis and contingency planning
  • Create documentation needed to help support the service

Confidential

SQL Developer

Responsibilities:

  • Livelink System Administration to include managing Users & Groups, Permissions, and Security within Livelink
  • Provide Livelink troubleshooting and diagnosis support to Database Administrator and Network Administration staff
  • Create and manage categories and attributes for projects, folders and documents
  • Integration of Livelink with other Enterprise Applications such as online Procurement and Asset Management systems using VB and ASP
  • Utilize Livelink tools to create Workflows, Forms, Discussions, and Tasks to automate business processes
  • Install and configure incident and defect tracking system, internal Help Desk management application for Livelink
  • Automation of Livelink performance and regression testing using tools such as Compuware TestPartner and QADirector
  • Participate in high level meetings to determine Livelink release criteria and maintenance schedule
  • Collaborate with the trainers in the development of training materials

We'd love your feedback!