Sr SAS Developer & Analyst

TECHNICAL SKILLS:

      Languages: UNIX Shell Script, PERL/PHP, C/C++, SQL, HTML,JavaScript,XML

      Databases: ORACLE, SYBASE,INFORMIX, MYSQL,ACCESS

      Operating Systems: SUN OS, SUN SOLARIS, AIX, HP-UX, LINUX, SCO UNIX, and WINDOWS.

      Networks: TCP/IP, SNMP, TL1, GDMO/ASN.1, OSI, CMISE/CMIP

Automated Testing Tool: Mercury Interactive test tools(Testdirector/Quality Center)

ETL/DW: Informatica PowerCenter, SAP BW

Job Scheduler: Autosys

Web Server: Apache

EMPLOYMENT HISTORY:

BlackRock Systems Software Engineer June 2006-December 2008

Understood concept of encryption, decryption and digital signing with public key and private key.

Implemented a secure FTP using GPG/PGP (encryption and decryption) multithreaded daemon through PERL/XML/MYSQL under UNIX.

Wrote secure FTP management scripts through SHELL/MYSQL.

Developed SHELL scripts to monitor Apache Web server/Jboss application server and purge database through Perl/DBI module.

Understood Informatica PowerCenter architecture and maintained Repository server and PowerCenter server from backend. Configured data connection to different type of data source through workflow manager.

Developer wrapper through PERL and used Autosys to schedule Informatica workflow by Informatica command ‘pmcmd’ from backend.

Worked with configuring Apache Web server/CGI/mod_perl/mod_php and SiteMinder policy server/LDAP for web based application.

JP Morgan Chase Production Support Engineer Nov. 2004-May 2006

Worked with web based application CASH-ONLINE including products: ACH, Fund Transfer, Cash

Reporting and Concentration Reporting from both frontend and backend.

Wrote test plan according to the business requirement/use cases, designed test cases, conducted the system test and regression test, logged and tracked the defect.

Managed application user entitlements for different products and sub products/sub function.

Parsed data from different data source (EDI/IDOC, XML and Flat File), converted data, analyzed data and loaded data to the database.

Skill used: UNIX, PERL and Mercury Interactive test tools, SQL.

Cybersoftec Inc. SAP BW consultant Oct. 2003-Oct. 2004

Experienced in modeling, extracting, transforming, and loading (ETL) data into data targets for reporting.

Found the gap between SAP Business Content and business requirement.

Enhanced SAP Business Content to meet business requirement.

Developed Transfer Rule, Update Rule and User Exit with ABAP language.

Designed, developed and tested queries based on infoProvider with Bex.

Generated and analyzed sales reports and financial reports.

Verified sales data and financial data through SQL.

Telcordia System Analyst Feb. 2000–May 2002

Worked with NMA system for monitoring NE (Network Element) with different interfaces CMISE/CMIP, SNMP and TL1.

Worked with Configuration Mangement of NE. Designed testing tool to build CMISE/SNMP request message sent to NE through ELC (Element Communicator connected to NE through TCP/IP or OSI stack) and parse CMISE/SNMP response message received from NE through ELC and stored it in the database for analysis.

Worked with Fault Management of NE. Designed testing tool to parsed CMISE event/SNMP trap message from ELC and then stored it as NE alarm or NE ticket in the database for analysis.

Compiled, built and managed CMISE MIB (gdmo files and asn files) and SNMP MIB (asn files) on UNIX.

Skills used include C/C++, PERL, SQL, ORACLE and UNIX SHELL.

Lucent System Engineer Mar. 1999 - Feb. 2000

Worked on a 3-tier client-server GUI-based project SNC which is an EMS (Element Management System) running on Solaris OS.

The EMS includes Configuration Management Subsystem, Fault Management Subsystem, Performance Management Subsystem and Security Management Subsystem.

Every subsystem includes JAVA client and MFA (Main Function Area) done by C/C++ and INFORMIX ESQL/C.

The communication between JAVA client and MFA is through CORBA. The inter-process communication in MFA is through UNIX IPC.

Tested functionalities related to Configuration Management Subsystem, Fault management subsystem and Security management subsystem through GUI.

Tested MFA through application interface.

Skills used: UNIX SHELL, JAVA and SQL.

Opencon Systems Inc. Software Engineer Sep. 1996 – Mar. 1999

Worked on a network management application (TA)--Electronic Bonding Manager Gateway. Middleware TUXEDO was used for transaction and messaging. CCM was used for source control.

Implemented OSS simulator and M/T simulator for generating CMISE messages from INFORMIX database, sending to Manager Gateway, and receiving CMISE responses.

Wrote PERL/CGI script to parse user input from browser, run queries, add data to database, read/write info from flat file or database.

Skills used: C/C++, YACC/LEX, PERL, SQL and UNIX SHELL.

EDUCATION:

Department of Computer Science, Tianjin University, Tianjin, P.R.China. Degree: B.Sc.

TRAINING & SELF LEARNING:

SAP BW training and accounting software training of Peachtree with accounting principal.

SAS BASE self online learning and practicing.

Advanced SAS training in Avtech computer school.

Contact this candidate