Devin Chen Email & Phone Number

Pasadena, California, United States

Pasadena, California, United States

Chatsworth, Ca

Knowledge of relational database design, T-SQL, writing Stored Procedures, functions, views, triggersAnalyze SQL queries and makes recommendations for better performanceETL ProcessSSIS package modification/creationSSRSDatabase Backup, Recovery, RestoreWrite Windows Batch file scriptServer Migration (ex. migrate from Windows Server 2008 to Windows Server 2016)SQL server instance installation and configurationWindows server IIS configuration, Component Service setupProject management. Work with Bank/Credit Union's IT and BSA regulatory compliance todefine system requirements and project scope in order to ensure the product meets the client’sneeds and timeline.Understanding complex business needs, analyzing, designing and developing solutionsPerform problem solving, troubleshooting, resolution and root cause analysis for database andapplication specific incidentsCreate and maintain documentation on any issues effecting functionality.Delegate tasks according to department’s needs, set short-term and long-term goals to ensurecompany’s longevity. Oversee all projects, make sure software can deliver on time withmeeting financial institution's requirementsTroubleshooting technical issues in PATRIOT OFFICER reported by financial institutions.Customer service skills.

Chatsworth, Ca

Interacted with clients to define system requirements and project scope in order to ensure theproduct meets the client’s needs and timeline.Design/write complex procedures to meet business requirement/logic and troubleshoot dataissue that exists in source level.Reverse-engineered database without documentation to extract necessary data.ETL using BCP, DTS and SSIS package.Database maintenance such as create/backup/restore database and server migrationTroubleshooting technical issues in PATRIOT OFFICER reported by financial institutionsAssist financial institutions with BSA audits by providing logic, data extracts, etcWorked as a vendor from GlobalVision Systems onsite forBanamexUSA (Citi Group), primarily focused on writing/modifying stored procedures using T-SQL, providing data analysis for Citi/BanamexFDIC compliance project.Worked closely with different consultants from E&Y, Deloitte, Accenture to report logic and provide data extracts.Daily use of SQL working with large data sets in banking operations such as wire transfers, credit cards, etc.Working with the compliance department for data validation with focus on Anti Money Laundering, Anti-Fraud and different government compliance requirements.

Chatsworth, Ca

Troubleshoot technical issues in PATRIOT OFFICER reported by financial institutions in time-manner.Answer PATRIOT OFFICER related questions asked by financial institutions.