SQL Developer and Business Analyst Resume

TECHNICAL SKILLS:

Programming Language : Swift, Java, Objective - C, C, C++, html, css, Javascript, Java, XML, R

Operating System: Unix, Linux, Window, Macintosh

Software: Xcode, Android Studio, Matlab, Unity, VisualStudio, Bugzilla, Rstudio, SQL server.

Speaking Language: Mandarin, English

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer and Business Analyst

Responsibilities:

Analysis and Import 35,409 Russia accounts from Spark, 83,298 Slovakia accounts from Finstat, 32,983 European accounts from EMIS, 42,938 India accounts, Applying SAM match tool to match SAP CRM inner database, Import matched result with account’s revenue and employee information to CIC intelligent system.
Combining Heatmap report with CRM sql database query to fix total 3843 invalid address accounts, both in CRM and DNB database.
Improved current database quality and accuracy from 85% to 92%.
Processing SSF request tickets in Global Ticket System, SQL query for Singapore and Europe, APJ, G-China, LAC, MEE, EMEA different regions, Market Attribute Checking in CRM and ERP.
HeatMap, SQL server, Information Steward, D&B, Spark, EMIS, FinStat, SAM Match Tool. Statistic and Math.

Confidential

iOS Mobile Developer

Responsibilities:

Constructed the foundation of the company’s mobile app UI.
Set up authentication communication between mobile app and the server. Implemented google Firebase Cloud Messaging and Apple Push Notification to receive survey.
Implemented Bluetooth detection feather, iPhone device contacts, call and wifi connection data collection.
Implemented twitter, google plus, linkedin social network data acquisition module. SwCrypt.swift, OAuthenSwift, SQLite.Swift, FirebaseMessaging, Alamofire, SwiftyJSON,

Confidential

iOS Mobile Developer

Responsibilities:

Maintaining & Upgrading iOS company’s mobile apps
Creating relative Watch app
Responsible for controlling Core Data flow between iPhone/iPad app and Watch app
Deploy third party libraries, such as HoneyWell(Captuvo SDK), uniMag-SDK, ScanAPI, BrotherFiles.

Confidential

iOS Mobile Developer

Responsibilities:

Implementing new Palace Pets: image assets management, treat animation, process image animation sequences, accessories.
Implementing Styling.xml, including positioning pets, treats animation, gallery, princess big reveal; Convert, Renaming, Implementing Audio for different pets.; Key-Value-Observe design pattern; FrameClearner, Xcode

Confidential

Software Tester

Responsibilities:

Independently developed full life-cycle object oriented RASCAL testing solutions, including analyzing and designing of application specifications, concurrently coordinating with other software developer in the process of detecting faults of the implemented system components, dynamically set the alive/staging system to meet with the updated RASCAL design and implementation requirements from shareholders.
Involves the execution of the full circle implementation of RASCAL project in the regards of professional researchers and execute Rascal system with the intent of finding system bugs (errors or other defects), the complex new protocols approval procedure in RASCAL system, both for Human Subject Protocols and Animal Care Protocols.
Make sure all the web pages on Human Subjects Protocols, Animal Care Protocols, Safety Officers, HIPAA Compliance Office, Environmental Health and Safety, Annual Conflicts of Interest and Clinical Trials, met the requirements that guided its design and development.

Confidential, New York City, NY

iOS Mobile Developer

Responsibilities:

1.5+ years experience in developing iOS mobile apps by using Objective-C & Xcode.
Extensive knowledge of MVC design pattern, apple build-in frameworks, such as MapView, TableView, CollectionView, etc, and ability to deploy third party libraries from Cocoapod such as ReactiveCocoa, Mantle, TSMessage, Google Analytics, Appirate, GoogleAdMob.
Have knowledge of Block, Grand Central Dispatch in order to write complex multithreaded application that keep UI responsive and fluid.
Experience working with RESTful APIs.
Thorough understanding of Objective C, XML, Web Services, JSON technologies and data structure fundamentals.