Please complete the CAPTCHA to continue
@aristeiacapital.com
✓
LinkedIn matched
A concise factual answer block for searchers comparing this professional profile.
Ming Pan is listed as Database Administrator at Aristeia Capital, based in New York, United States. AeroLeads shows a work email signal at aristeiacapital.com and a matched LinkedIn profile for Ming Pan.
Ming Pan previously worked as Consultant at Stellar Services and Consultant at Shanghai Key Real Estate Investment Consulting Co.. Ming Pan holds Master Of Science - Ms, Computer Science from New York University.
This section adds company-level context without repeating Ming Pan's masked contact details.
AeroLeads found 1 current-domain work email signal for Ming Pan. Compare company email patterns before reaching out.
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.
Listed skills include Enterprise Architecture, Business Analysis, Project Management, Sdlc, and 16 others.
Company context helps verify the profile and gives searchers a useful next step.
A career timeline built from the work history available for this profile.
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.
• 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.
• 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.
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.
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.
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.
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.
• 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.
• 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.
• 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.
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.
Quick answers generated from the profile data available on this page.
Ming Pan works for Aristeia Capital.
Ming Pan is listed as Database Administrator at Aristeia Capital.
AeroLeads has found 1 work email signal at @aristeiacapital.com for Ming Pan at Aristeia Capital.
Ming Pan is based in New York, United States while working with Aristeia Capital.
Ming Pan has worked for Aristeia Capital, Stellar Services, Shanghai Key Real Estate Investment Consulting Co., Cibc, and Cibc World Markets.
You can use AeroLeads to view verified contact signals for Ming Pan at Aristeia Capital, including work email, phone, and LinkedIn data when available.
Ming Pan holds Master Of Science - Ms, Computer Science from New York University.
Ming Pan is listed with skills including Enterprise Architecture, Business Analysis, Project Management, Sdlc, Risk Management, Management, Program Management, and Microsoft Sql Server.
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial Search contacts