Ming Pan

Ming Pan Email and Phone Number

Datebase Administrator/Developer and Production Support @ Aristeia Capital
Ming Pan's Location
New York, New York, United States, United States
Ming Pan's Contact Details

Ming Pan personal email

About Ming Pan

IT Professional with years of Sybase and Oracle DBA/development and system administration experiences for various applications such as SmartStream, Autosys, and Oracle Financials. Excellent communication and technical skills. Proven ability in project leadership, team working and problem solving. Willing to accept new challenges. Intelligent and quick at acquiring new skills and adapting to changing business needs.

Ming Pan's Current Company Details
Aristeia Capital

Aristeia Capital

View
Datebase Administrator/Developer and Production Support
Ming Pan Work Experience Details
  • Aristeia Capital
    Database Administrator
    Aristeia Capital Nov 2021 - Present
    Greenwich, Connecticut, Us
    The views expressed herein are my own. They have not been reviewed, approved, or endorsed by Aristeia Capital, L.L.C. Any endorsements or recommendations of my skills are not to be construed as testimonials of Aristeia Capital, L.L.C.
  • Stellar Services
    Consultant
    Stellar Services Nov 2017 - Oct 2021
    • From October 2018 to present Microsoft SQL Server database administrator and developer for NYCT’s Emergency Booth Communications System upgrade project at Boyce Technologies. Responsible for SQL Server database design, architecture, administration, and tuning. Installed SQL Server components. Created databases and database objects. Analyzed and aggregated data into tables. Set up Windows Server Failover Clustering and SQL Server AlwaysOn Availability Groups. Installed and configured SAP Crystal Server. Created Crystal reports for incident management and analysis.• From February 2021 to present Microsoft SQL Server and Power BI Developer for DC Water Cares Multifamily Assistance Program. Developed stored procedures and loaded data in the database. Created complex measures and computed columns using DAX. Designed Power BI dashboards to track weekly and monthly summaries of application statuses and assistances applied.• February 2021 to April 2021 developed Power BI dashboard prototypes for the NJ Transit Capital Plan project.• From January 2021 to present performed troubleshooting and performance tuning on Starboard Consulting’s IMB Maximo Asset Management Oracle database server. Adjusted server configuration. Cleaned up logs and the SYSTEM tablespace. Set up RMAN backups. Identified long running queries through the database diagnostic monitor.• From July 2021 to present Oracle DBA for Clark County Water Reclamation District. Created Oracle databases for IBM Maximo Asset Management system. Created tablespaces and other database objects. Created and restored database backups. Support and troubleshoot the production Maximo Oracle database.• Worked at the Port Authority of New York and New Jersey on a data warehouse project. Assessed the Engineering Department's current and near future capital project reporting requirements. Wrote T-SQL queries. Investigated multiple Microsoft SQL Server databases and identified data needed for a new reporting data warehouse.
  • Shanghai Key Real Estate Investment Consulting Co.
    Consultant
    Shanghai Key Real Estate Investment Consulting Co. Jun 2013 - May 2017
    • Participated in upgrading the company’s office automation system. Coordinated with vendor on business and data analysis, participated in database design and system deployment. Performed system and use acceptance tests. Developed Sybase Transact-SQL stored procedures for financial reporting.• Responsible for production support, troubleshooting and resolution of issues encountered by system users.
  • Cibc
    Consultant
    Cibc Feb 2011 - Jul 2012
    Toronto, Ontario, Ca
    • Participated in a systems migration project converting the SmartStream General Ledger system to the mainframe ledger system used by the headquarters. Performed extensive tests and troubleshooting.• Rewrote the Consolidation and Eliminations Engine in PL/SQL for the new Oracle data warehouse to satisfy legal and regulatory reporting requirements.• Helped other developers in converting financial and regulatory reports.• Designed the Autosys job scheduling for the new environment.• Provided production support for the SmartStream General Ledger system before the final migration. Rewrote Perl and UNIX shell scripts as batch jobs being decommissioned.
  • Cibc
    Consultant
    Cibc Feb 2009 - Jun 2009
    Toronto, Ontario, Ca
    • Worked as a technical expert on the SmartStream General Ledger system migration project. • Participated in setting up new system environment (UNIX, Sybase, Autosys, and report/web servers.) Performed extensive tests and troubleshooting.• Rewrote Perl and UNIX shell scripts for the new production environment. • Tested and monitored Autosys jobs.• Participated in the final migration of the production system.
  • Cibc World Markets
    Associate
    Cibc World Markets Nov 2001 - Jun 2004
    Toronto, On, Ca
    • Responsible for the development, implementation and maintenance of SmartStream General Ledger system. Provided 24x7 support for production G/L system.• Installed and configured Sybase and backup servers on Sun Solaris. Created database devices and databases.• Responsible for the backup and restore of database servers and databases.• Monitored and fine-tuned database servers to achieve optimal performance.• Created and monitored Autosys jobs to load data from various financial systems into the G/L system nightly.• Wrote Perl scripts and Sybase SQL stored procedures to aggregate data for various financial reports.• Wrote SQL stored procedures for Finance’s Head Office and Regulatory Reporting.• Wrote UNIX shell scripts to perform system administration tasks.
  • Enterprise Solution Providers
    Senior Consultant
    Enterprise Solution Providers Apr 1999 - Nov 2001
    New York, New York, Us
    • From April to October 1999, worked on the SmartStream system upgrade project at the National Football League. Set up new database servers and migrated their SmartStream 4.1 system to 6.0. Assisted NFL developers on efficient SQL coding. Streamlined their reporting process and fine-tuned their production environment.• From October 1999 to November 2001, worked at CIBC World Markets as a Sybase database administrator and developer.
  • Ing Barings
    Sybase Dba And Smartstream Administrator
    Ing Barings Jul 1998 - Mar 1999
    • Responsible for the implementation and maintenance of SmartStream Financials applications. • Acted as the technical leader of the project to upgrade SmartStream system to a Y2K compliant release. • Participated in the preliminary research and work of the migration of SmartStream to Oracle Financials.• Other duties included monitoring of nightly batch jobs, SQL server performance fine-tuning, troubleshooting and analysis of production problems. • Provided coding advice to developers on issues such as triggers, stored procedures, transaction processing, and error handling. • Assisted users with ad-hoc queries and daily financial reports.
  • Alliance Capital Management Lp
    Senior System Analyst
    Alliance Capital Management Lp Apr 1997 - Jul 1998
    • Sybase DBA and SmartStream Administrator. • Installed, upgraded, and configured Sybase servers on Sun Solaris. • Installed and administered SmartStream products. Maintained central file server repository of delivered SmartStream programs and files,• Maintained and applied SmartStream program updates and patches.• Planned and set up system security.• Sybase server activities monitoring and performance fine-tuning.
  • Bankers Trust Company
    Assistant Treasurer
    Bankers Trust Company Feb 1996 - Apr 1997
    • Sybase DBA responsible for the design, development, implementation and maintenance of Global Assets Data Warehouse. • Provided 24x7 production support.• Extracted data from multiple business areas and integrated them in the data warehouse to provide business users with optimal access to business data for effective decision-making. • Duties included database logical and physical design, database objects creation and maintenance, data load and integration, SQL server activities monitoring and performance fine-tuning, as well as UNIX/AIX system administration.
  • Credit Suisse
    Sybase Consultant/Application Developer
    Credit Suisse Jan 1995 - Feb 1996
    Zurich, Ch
    • Responsible for the development and implementation of Management Information Systems and data warehouse project. • Wrote C programs to load data from VAX/RMS into Sybase databases. • Developed database objects such as stored procedures, triggers and rules. • Extracted local data daily for the head office to fulfill international reporting requirements and all requirements for the Treasury batch reconciliation report, as well as Credit and Risk Management analysis applications.

Ming Pan Skills

Enterprise Architecture Business Analysis Project Management Sdlc Risk Management Management Program Management Microsoft Sql Server Strategy Strategic Planning Sql Financial Modeling Investment Banking Software Project Management Business Intelligence Java Capital Markets Vendor Management Equities Requirements Gathering

Ming Pan Education Details

  • New York University
    New York University
    Computer Science
  • Shanghai Jiao Tong University
    Shanghai Jiao Tong University
    Biomedical/Medical Engineering
  • Shanghai Jiao Tong University
    Shanghai Jiao Tong University
    Automation Engineering

Frequently Asked Questions about Ming Pan

What company does Ming Pan work for?

Ming Pan works for Aristeia Capital

What is Ming Pan's role at the current company?

Ming Pan's current role is Datebase Administrator/Developer and Production Support.

What is Ming Pan's email address?

Ming Pan's email address is mp****@****ces.com

What schools did Ming Pan attend?

Ming Pan attended New York University, Shanghai Jiao Tong University, Shanghai Jiao Tong University.

What skills is Ming Pan known for?

Ming Pan has skills like Enterprise Architecture, Business Analysis, Project Management, Sdlc, Risk Management, Management, Program Management, Microsoft Sql Server, Strategy, Strategic Planning, Sql, Financial Modeling.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.