Project Technical Support

Phone: ***- ***- **** E-Mail: *************@*****.***

**** * ***** ******, *******, IL, 60616

SUMMARY

•Dynamic, savvy, SAS Base/Advance programming & PMP certificated, computer science & MBA educated professional, expertise in data programming, project managment, business analyze in Finance,Telecom,Digital Security and Internet Industry.

•Over 1 year experience and proficiencies in data programming,data analyst using SAS, SQL and Excel for data analysis,design,development,testing,draw conclusions and create reports.

•Tech savvy with 5+ years IT industries experience in data managment and project management to achieving high amount (multimillion) high-quality mobile deliverables within time.

•Strong SAS programming skills: Data step, proc sql, macros in Windows Environment.

•Experience in import raw data with PROC IMPORT,INPUT Statement and INFILE Statement.

•Heavy experience in SAS data extraction procedures,import and export techniques using SAS/SQL,SAS/ACCESS.

•Knowledge of logical and physical database design with ERwin.

•Experience of Oracle Database and SAS Developer.

•Proficiencies in Water Flow/Agile Method, SDLC process,Project Managment methods and tools.

•Strong analytical skills to business analyze, technical interrelation,requirement collection and functional specification.

•Solid technical background with knowledge of IT technologies,Internet technologies, and software development method.

•Proficiencies in PMP tools,Primavera,MS office set including:Project/Visio/Excel/PowerPoint,Pivot tables.

•Bilingual(English&Chinese),quick learner,passion for work,good team work,solid work ethic, detail oriented and extremely organized,deadline-sensitive . Be able to multi-task in order to complete multiple projects with competing deadline.

SKILLS

•SAS Skills: SAS/BASE,SAS/STAT,SAS/MACRO,SAS/SQL,SAS/ACCESS,SAS/ODS,SAS/GRAPH

•Database Skills: Oracle,ACCESS

•Language: SQL,JAVA,C++,Html,PHP;

•Design Tools: Erwin,MS Excel,Power Point,Word

•OS: Windowa XP/7/8

EXPERIENCE

SAS Programmer, Northwindsor,Chicago,IL, Jun 2016 - Now

Northwindsor Inc. is a consulting company focus on SAS data analyze and business analyze.

•The project involved working with the marketing and business analyst group to support marketing and financial decisions. Main purpose was to make the data warehouse more efficient and time saving in functional aspect and generate detailed reports as well as developing helpful data model to perform quick analyses.

•Developed and designed SAS Programs/ Macros to analyze financial data and to generate reports.

•Used SAS/ACCESS to extract data from ORACLE and SQL SERVER.

•Created different datasets by combining individual datasets using various inner, outer, right and left joins using SAS/SQL.

•Created and modified existing SAS datasets using PROC SQL, PROC DATASETS, PROC IMPORT, etc.

•Performed ETL - Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and documentation using SAS.

•Extracted and concatenated data from internal and external resources, including demographic and credit variables, payment history and frequently using SAS Macro, data steps and procedures including Proc SQL, Proc Sort, Proc Format, Proc Summary, Proc Export, Proc Transpose, Proc Freq, Proc Contents, Proc Print etc.

•Built summary reports to communicate key findings/performance indicators and articulated strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC UNIVARIATE, PROC MEAN, PROC GPLOT and DATA_NULL_.

•Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, and SAS/MACROS for descriptive and inferential statistical analysis and data displays.

•Extensively worked on creating Macro variable and Macro for automated weekly, Monthly report generation and to submit in a batch mode

•Used SYMBOLGEN, MERROR, SERROR, MLOGIC and MPRINT options for MACRO debugging.

•Extensively using SAS data steps and Macros in generating monthly delinquency reports for obligor and obligation account management.

•Generated complex reports in text, HTML, Excel and PDF formats using SAS Output Delivery System (SAS/ODS).

•Used PROC TEMPLATE to customize the reports in spreadsheet with footnotes, titles, and pages numbers along with image logos.

•sEnvironment: SAS v9.1.3, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/ACCESS, Oracle 10g, SQL Server 2005.

SAS Programmer (Trainee), Northwindsor,Chicago,IL,Nov.2015-June2016

•Trained as SAS Programmer and learned Data Visualization,Data Analysis,SQL language and Finance knowledge.

•Data analysis:data manipulation using querying tools such as SAS, SQL Navigator and Reporting.

•Read SQL Scripts to ensure that it fulfills the SAS program needs as developers convert some of the SAS Scripts to SQL.

Security Consultant, LT Security Inc.,Chicago,IL, Jan 2016-June 2016

•LT Security Inc. is a leader in video surveillance solutions in the category surveillance cameras and network video recorders.

•Data analyze: manipulate and analyze large data sets using Microsoft Excel, including pivot tables, lookups, and macros.

•Project managment& Business analyze: responsible for clients surveillance project,analyze customer’s requirement and provide solutions based on customers’ requirement and solve customers’ basic technical problems/questions.

•Business development: prospect clients with calls,emails,direct mails and networking,develop strategic goals and objectives to prospect and grow book of accounts.

•Customer care:service customers and prospects with company/product information,quotations,sample products and marketing materials. Maintain productive working relationship with customers and across teams,update and manage CRM.

Project Specialist, Sina US, Chicago, IL, May. 2015- Jan,2016

•Sina is a Chinese online media company, operates four major business lines: Sina Weibo, Sina Mobile, Sina Online, and Sina.net. It has over 100 million registered users worldwide.

•Responsible for the media campaign projects in New York, Chicago, Boston and San Francisco. Successfully managed the advertising project for Warren Buffett Investment Value forum which cooperated with Sina over 5 years and selected Sina as the only one Chinese media for event reporting.

• management and QA: planed and managed online/mobile project, monitor scope /timeline/budget with reports.

•Business analyze: identified business needs, analyzed statistic data of web/mobile to monitor page views and operational practices to determine alignment with quality standards, and delivered feedback to the product management team based on prospect.

•Project coordinate across function: worked with teams in different functional and project leaders to gather and interpret information.

Technical Consultant, Telecom business unit, Gemalto, Beijing, China, 2009 to 2013

•Gemalto is an international digital security company providing software applications, secure personal devices such as smart cards and tokens, and managed services. It is the world’s largest manufacturer of SIM cards.

•Acted as liaison between business and engineering, clients cover three china mobile operators(Fortune 500) and managed concurrent global cross-functional mobile/SIM application projects.

•Successfully led 2FF/3FF Certification for IPHONE product and the first mobile payment project in highly regulated markets resulted in a sales increase by 20%.

•Project management& Product management: independently managed matrix-multiple mobile digital projects simultaneously for development. Scoped projects,created project plans, made schedules and managed product on PDM system and accurate delivery with limited time/budget.

•Business analyze: analyzed,documented and reviewed project proposals,generated input template file and detailed statement of work (SOW) based upon customer requirements and accurately translated business requirements.

•Technical support& QA: executed test plans and test cases based on priority of feature. Identified, recreated and reported bugs into R&D to fix immediately, participated in field and UAT test, developed and executed case test plans.

•Marketing& Customer care: developed promotional literature, provided technical support and presentation to clients for promotion & training, responded to emails and RFP’s and provided follow-up technical support to clients for all concerns.

Mobile/WebEngineer, Open source team, France Telecom R&D Centre, Beijing, China, 2007 to 2008

•France telecom is a French telecommunication company and is the third biggest wireless operator in Europe.

•Designed, build-up of the website project of “Terracotta2” which is one of the reference projects of LiPS (Linux Phone Standards) program, and managed the daily update of the website.

•Conducted research on Linux Smart phone industry with reports.

•Managed website database using SQL.

Mobile/Web Engineer, Mobile team, ARES Communications Inc. Beijing, China, 2006 to 2007

•Designed plan for data collecting of E-commerce sites of mobile E-commerce project to achieve Smartphones ‘Online E-commerce of Amazon, EBay, Joyo etc.

•Selected the E-commerce sites’ products main data and register data source to establish MySQL database server connectivity.

EDUCATION and PROFESSIONAL DEVELOPMENT

•SAS Certified Base Programming for SAS 9, Score 85/100, Feb.2016

•SAS Certified Advance Programming for SAS 9, Score 90/100, Feb.2017

•Master of Business Administration (MBA),International Business, University of Illinois at Chicago, Chicago, IL, 2015

•Master of Computer Science, Database and DataMining, China University of Mining and Technology, Beijing, China, 2009

•Bachelor of Computer Science, Software Engineering, Shandong University, Jinan, China, 2006. Certified Project Management Professional (PMP), License 1682950, 2013

•Certified Project Management Fundamentals, License 902600,2010

TRAINING and VOLUNTEER EXPERIENCE

•Communication Skills Training, Beijing,China,2009

•Project Managment Fundamentals Training, Beijing,China, 2009

•The Field Museum, Volunteer, Chicago,IL,2015

•Lions Clubs International,Volunteer, Guangzhou,China,2009

Contact this candidate