Senior Integration Developer Resume
SUMMARY:
- Currently working in Confidential responsible for integration applications between AS400, Oracle, and SQL servers and sync with cloud based applications (TeraData, Salesforce, and CallMiner) using IBM CastIron websphere appliance.
- In Cantor, managed the creation/installation/maintenance for the infrastructure including Windows, Linux, MSSQL, MySQL, software components, web components and security rules on cloud, as well as the data integration/replication processes and trade data processing procedures.
- In Penson, led the admin and development work for Salesforce.com used as main CRM / ticketing system / customer data warehousing tool for more than 6 years, supporting 350+ users from multi instances globally. Designed and implemented all the java based customization and data integration between Salesforce.com and internal SQL/application server using SQL SSIS, DataLoader and CastIron. Also familiar with SQL admin work and VBScript and ASP.net programming.
- Recognized as a hard and smart worker, with nice personality that always easy to work with, and holding positive attitude toward working and learning.
KEY SKILLS:
Cloud management: Infrastructure, OS, databases and applications
SQL DBA and SQL development: Salesforce.com administration and development
ETL tools: IBM CastIron, Informatica, Pentaho, Dell Boomi
Familiar with: Windows Server 2008/R2/2012, Linux Ubuntu 12.04
Applications: MS SQL Server 2000/2005/2008/2012 , MySQL, MS Exchange Server, MS Sharepoint portal, K2.Net, IBM MQ, Tidal, Visual Studio .NET/2010/2012, Office Suite
Programming Languages: T - SQL, VB, VBScript, .Net in VB and C#, Java, JavaScript, Python, HTML
PROFESSIONAL EXPERIENCE:
Confidential
Senior Integration Developer
Responsibilities:
- Integrate data between AS400/Oracle/SQL/API/SF using IBM CastIron
- Maintain/manage data quality from different systems
- Develop new integration projects
Confidential
Assistant Vice President - Cloud Architect / DBA / Infrastructure Admin
Responsibilities:
- Managed Amazon AWS cloud environment with server(Microsoft/Linux) creation/backup/termination, security design, process maintenance, and usage monitor
- Implemented cloud resource like key authentication, volume template, snapshot creation/restore, security group creation and IP allocation
- Architected data warehousing from SQL, MySQL, and other systems
- Designed Salesforce CRM functions for customers
- Installed and implemented IIS, Apache, MSSQL, MySQL, SFTP Chroot jail, NFS and other needed components and processes on cloud servers on both Microsoft and Linux
- Designed and programmed cloud server maintenance processes with coding in Python and API tools for automation of shutdown/start/backup/restore/alert
- Designed and implemented MSSQL/MySQL replication/backup/dump/restore schedule
- Integration/replication process using Pentaho between Sybase, MSSQL and MySQL
- Coordinated with customers for data transformation and process organization
Confidential
DBA / System Administrator
Responsibilities:
- Supervised and led salesforce.com admin work of custom objects, workflows, approval processes, and customer support models; as well as the development work with java-based triggers, validation rules, visual source pages, and integration processes
- Designed and developed Email-to-case, Web-to-case, SF2SF, Customer Portal, customer objects, workflows, approval processes, validation rules, and VisualForce pages on SalesForce.com,
- Programmed and coded IBM CastIron for real time salesforce.com integration, SQL/MQ replication, and routine salesforce.com data mapping
- Designed and implemented SQL Server databases, tables, and stored procedures used in applications, plus SQL maintenance with backup/restore/replication/log/performance
- Coded .net applications including Windows and Web, and SQL procedures to process text files, spread sheets and emails to generate daily routine data, reports and analysis
- Performed routine system maintenance for patch/drive/services, as well as installation and configuration for Virtual Machines
Confidential
Network/System Administrator
Responsibilities:
- MIS work of hardware, software and networking maintenance
- Designed, created, maintained and backed up SQL database to optimize the query performance and data storage
- Coded ASP and HTML programs to maintain, update, or create websites for customers and internal users, as well as VBScript and SQL programs for internal processes
- Performed daily batch process (both before market and after market), monthly billing data preparation by execution, ticket, and upload for all correspondents