Senior Database Developer Resume
SUMMARY:
- Accomplished data developer with over 8 years of experience serving in database development and big data report and analytics for finance and e - commerce. Hands-on expertise leveraging and tuning performance and processing big datasets using Oracle and diverse Big data technologies. Personable team player with history of success collaborating with diverse technical and cross-functional teams.
- Database Development Financial Systems Reporting
- Tuning Performance Business & Statistical Analysis Machine Learning
- Coding & Troubleshooting Team Collaboration
TECHNICAL SKILLS:
Languages: Python, PL/SQL, Hive, Java, Linux Command, Shell Script
Databases: Oracle, PostgreSQL, Mongo DB, Tuning Performance, NoSQL, SQL Server, Oracle Data Warehouse
Tools: Toad, PLSQL Developer, Eclipse, Jupyter Notebook, Jira, MS Visual Studio, Control-M, Subversion
Reporting: Oracle Forms and Reports, Oracle OBIEE, Microsoft Excel
Platforms: Unix, Windows
Big Data: Hadoop, Map Reduce, Hive, Spark, Spark Machine Learning
PROFESSIONAL EXPERIENCE:
Confidential
Senior Database Developer
Responsibilities:
- Handled banks’ business and technical tickets related to BO SmartVista system.
- Diagnosed configurations, processes and messages from outside payment systems to localize of the problems’ sources. Tuned query performance.
- Developed new features, requirements and customized enhancements on cards products, payments.
- Closed and fulfilled long list of every support tickets from urgent to normal priorities with ASAP, efficient and satisfiable responds. Customized and created jobs for reporting using Unix Shell, based on customer requests.
- Deployed Deferred Payment Plan and SMS scenario feature for banks, BO VISA changes.
Technologies Used: PL/SQL, Oracle, Toad, Shell Script, SmartVista Systems, Unix, Jira, Subversion, Putty, Centos, VPN, BPC Internal tools.
Confidential
Responsibilities:
- Designed and implement database model. Implemented business logic, tuned data performance. Installed and deployed backup and recovery database systems.
- Setup & build new data systems for online game system.
Technologies Used: Python, PostgreSQL, PL / SQL, Shell Script, PgBarman, PgTag, Ubuntu, Docker, Gitlab, Toad
Confidential
Senior Oracle Developer
Responsibilities:
- Member of offsite CBOE, Chicago Board Options Exchange, the world's largest options exchange with nearly 5 billion quotes, 20 million orders, 3 million trades per day. Developed and enhanced the Regulatory Surveillance System belongs Exchange Market Regulatory Department.
- Implemented surveillance applications for monitoring CBOE and C2 Trading Permit Holder compliance with trading rules and procedures designed to provide a fair and equitable marketplace
- Contractor of FINRA, FINRA monitor 6 billion shares traded in the U.S listed equity market and process approximately 6 terabytes of data, up to 75 billion trading events of all 12 financial trading exchanges with 3900 security firms, nearly 600 thousand brokers every day using Big Data and Cloud Technology.
- Member of Cosatech’s R&D products team. Applied machine learning models to predict stock trends; conducted stock analysis and assessment of technical indicators.
- Interpreted business requirements and functional specifications into stock surveillance applications.
- Conducted coding and programming. Tuned data performance and processed large volumes of data.
- Migrated surveillance applications from Oracle Warehouse to Cloud AWS environment with Apache Hive
- Researched and developed stock analysis and stock indicators to predict stock trends software.
Technologies Used: Oracle PL / SQL, Python, Java, Kafka, Spark Streaming & Machine lib, MongoDB, Anaconda, Google Collab, Unix, Apache Hive, Hadoop, MapReduce, Amazon AWS, S3, EMR, EC2, HBase, Control M, ClearCase, Putty, Jerkins, Jupyter, Finra HERD
Confidential
Responsibilities:
- Migrated underwriting SQL server objects to Oracle scripts for new data warehousing system.
- Delivered risk reports; calculated expected monthly losses and segmentation for products.
- Created new Oracle reports for Nation Information Center CIC, compliant with SBV regulations.
- Underwriting Rules Management System: Developed business logic and conducted simulation on operational Fico Blaze Decision Support System supporting loan underwriting process.
- Oracle DWH Project: Performed Business Risk Management Report Migration into Oracle DWH.
- State Bank of Vietnam Reports Project: Completed automatic periodic operational reports reporting to government information center.
Technologies Used: Java, PL / SQL, Oracle DWH, SQL Server, Oracle OBIEE, Excel, Windows Server, Fico Blaze
Confidential
Software Developer
Responsibilities:
- Developed scripts, forms, and reports for finance, accounting, deposits and loans, and banking reporting.
- Conducted coding, testing, and troubleshooting. Mined data and performed business analysis.
- Bank Reporting System: Developed bank reporting system with modules for finance management, business and administrative management.
- Visual Intelligent Reports Project: Developed new applied business intelligence and dimensional modeling system based on Oracle OBIEE. Led development of enhanced reporting modules.
Technologies Used: PL / SQL, Oracle DBMS, Oracle DWH, Oracle Forms and Reports, ETL Informatica, Oracle Apex, Oracle OBIEE, X-Code, Java, Ellipse, Unix, Java, Putty, Toad, Ellipse
Confidential
Teaching Assistant
Responsibilities:
- Taught courses in computer fundamentals, website design, C / C#, HTML, DHTML, JavaScript, RDBMS and data management, ASP and SQL Server, XML, and SQL Server Database Objects.
- Developed CRM software.
Technologies Used: Java, C#, CSS, HTML, JavaScript, ASP, SQL Server, XML, SQL Server Database Objects, Visual Studio.Net, Ellipse, jQuery, Java Servlet and JSP