We provide IT Staff Augmentation Services!

Sr. System Developer Resume Profile

New York, NY

TECHNICAL SKILLS

  • Programming Languages: Java, C , PHP, JavaScript/jQuery, SQL, HTML/CSS
  • Database: SQL Server SSRS, SSAS, SSIS , Oracle
  • Development Tools: Visual Studio, Eclipse
  • Operation Systems: Windows, Linux

PROFESSIONAL EXPERIENCES

Sr. System Developer

Confidential

  • Conducted business analysis for P6 upgrade and developed a gap analysis report to identify potential issues and possible enhancements when upgrade existing P6 v7 to P6 EPPM 8.3
  • Successfully upgraded Primavera P6 from v7 to v8.3 including fix P6 database schema errors, archived 6000 projects, cleaned out 40 project codes/14 activity codes/400 UDFs, reduced user licenses from 1212 to 400, reduced security profiles numbers from 38 to 8, migrated 13 applications/29 stored procedures and views
  • Developed Business Rule Check Utility to ensure data quality and business rule compliance in P6 using SQL Server Reporting Services SSRS
  • Developed Project ID generator using SSRS to generate the next available project ID in P6 to enforce business rule and no duplication and display existing information in bar chart and pie chart format
  • Developed a ETL process to load project status information from Project Proposal System to Primavera P6
  • Developed a ETL process to extract project date from Primavera P6 to IBM Cognos TM1
  • Redeveloped Project Status Code ETL to update Project Status Code nightly based on specific business rule
  • Developed a P6 account passwords utility using Java and P6 API to identify blank password and notify users by emails
  • Developed a new projects monitor in SSRS to identify newly created projects on weekly basis and notify project control specialist and managers
  • Developed a project codes monitor in SSRS to identify new project codes assignments on weekly basis and notify Engineering Department
  • Involved in development of Project Management Office website using HTML and JavaScript
  • Developed a Windows service application to automatically start Weblogic Server using C
  • Maintained Primavera P6 system and provide technical support to 400 end users
  • Submitted two enhancement request of P6 and approved by Oracle

Confidential

  • Completed a system analysis and developed a system migration plan
  • Installed and configured Weblogic Application Server 11g on Windows Server 2008 R2
  • Deployed and configured Oracle Primavera P6 v7 Web Access on Weblogic Server
  • Performed a migration of Oracle Primavera P6 v7 database including over 200 projects
  • Deployed and configured Contract Management 14 on Weblogic Server
  • Performed a migration of Oracle Primavera Contract Management 14 database which contains over 300 contracts
  • Configured Contract Management 14 and imported 109 reports and forms
  • Deployed and configured Oracle BI Publisher on Weblogic Server
  • Performed a migration of Oracle BI Publisher database
  • Integrated CM14 dashboard to P6 Web Access which allows managers to view Contract Information in P6
  • Configured CM14 and P6 to make project schedule in P6 available in CM14
  • Completed functional and user acceptance testing

Confidential

  • Implemented a Project Management System for JetBlue T5i project
  • Implemented SharePoint 2010 Enterprise
  • Configured and customized SharePoint site collection
  • Developed customized InfoPath Forms and SharePoint document library workflows for document upload and email upload
  • Implemented Primavera Contract Management 14.0 BI Publisher Edition
  • Designed Data Model for Oracle BI Publisher
  • Developed 11 customized reports including filters, tables, graphs and sub report using Oracle BI Publisher
  • Migrated client's data from excel to Contract Management

Confidential

  • Implemented OpenText Capture Center 10.2 to manage document import process across client's multiple locations
  • Created and customized two OCC scan profiles and 6 different document types
  • Developed C scripts to extract extra information from scanned documents
  • Developed training document and user manual

Confidential

  • Developed a ZIP and Download custom action using C and Visual Studio for SharePoint 2010 which allows users to select single or multiple files or folders and download all of them as one single ZIP file
  • Integrated Primavera P6 dashboard with SharePoint 2010 which allows managers to review project status in real-time
  • Configured SharePoint as Contract Management's content repository to enhance versioning control of documents and attachments
  • Developed and customized project information Web Part to load information from Oracle Primavera P6 by using SOAP Web Services and generated a customized report in word format
  • Developed a publish report Web Part using C to publish finalized word reports into PDF and put specific folder
  • Developed a Resource Rate Interface which is a web-based integration application with Primavera P6 that allows users to view labor rates, role rates, and balances stored in P6. It also provides the user the ability to upload an Excel file to update labor rates, role rates, and compare balances through P6 Web Services
  • Developed a Leave Balance Check routine application to compare balance information in an excel file with P6 to MS SQL database and sends out email notifications periodically

Confidential

  • Completed a system requirement analysis and upgrade plan
  • Performed an upgrade of Oracle Primavera Contract Management from version 12 to 13.1
  • Migrated database from Sybase to Oracle 10g
  • Migrated total number of 285 Contract Management Info Maker Reports and Forms
  • Installed and configured Weblogic Application Server 11g on Windows Server 2008 R2
  • Deployed Contract Management 13.1 on Weblogic Server
  • Configured Contract Management 13.1 and imported reports and forms
  • Migrated all attachments to Contract Management 13.1
  • Completed functional and user acceptance testing

Confidential

  • Developed a Java program to extract record box information from excel spreadsheet and save to a XML file for LiveLink to import
  • Performed Kofax Capture software upgrade from version 8 to 9
  • Designed a Kofax Batch Class and implemented a scan batch class to allow users to scan or import files into LiveLink and trigger a workflow

Confidential

  • Involved in designing a hardware plan for implementing Fleet Management System
  • Conducted business analysis with Port Authority for standard workflow procedures

Confidential

  • Developed a cloud-based timesheet application using C and ASP.Net
  • Designed database schema in SQL Server for timesheet application
  • Developed a C application to integrate timesheet application with QuickBooks
  • Deployed the system in Amazon EC2 Cloud

Confidential

  • Developed a Java program to extract record information from excel spreadsheet and export to LiveLink enterprise record management system categories

PHP Application Developer

Confidential

  • Designed CRM System modules and databases for TRUST Brokerage platform
  • Developed a communication Log Module using PHP and jQuery to provide the sales department an easy to use tool to track history of communications with clients
  • Developed a Contact Management Module using PHP and jQuery to maintain client contact information
  • Developed a company information Module using PHP and jQuery to record client company information

Web Application Developer

Confidential

Designed and Developed commercial website for clients using HTML/CSS and JavaScript. Involved in website development projects for ShengTong Group China , China National Materials Group Corporation, Poly Energies Holding Co., LTD. Maintained and supported previously developed client websites

Hire Now