TECHNICAL SKILLS:

• SAS 9x, SAS Macros, SAS Graph, HTML, Proc SQL, SAS Management Console, ETL process, SAS/Access, SAS Enterprise Guide(EG), Special training on company site: Metadata extraction, SAS DI Studio, data quality, SAS - Teradata operation, SAS Oracle, DB2, SQL Developer, BTEQ
• DOS, Windows XP and UNIX with KORN SHELL scripting, VI. AWK, SED. EXCEED
• MS Office (EXCEL, Power Point, Word), Dreamweaver. VISIO, SFTP
• SAS/Access to DB2 and ORACLE, SQLPLUS, TOAD, SQL developer
• SAS on PC, UNIX and IBM mainframe (JCL, TSO, ISPF) platforms, Putty, Cman

PROFESSIONAL EXPERIENCE:

Confidential, Illinois

TCS/SAS Developer / Data Management

Responsibilities:

• Dashboards project developer, process different data from different countries, process it and load into LASR server for UK pre-production of Confidential, support SAS Visual Analytics dashboard, comparing opening and ending balance of NNM summary, income validation, market impact correction, Year to date summary, different financial products and segments query and analysis.
• Hive table query to get data, SAS - Hadoop process data, SPDE engine, building connectivity with Hadoop/hive, read Hadoop table into SAS, proc HDMD.
• SAS programming to get data from Hive- Hadoop data (through SAS EG), connect to hive-Hadoop data, using library, and configuration file. Base SAS data step, SAS proc summary, proc means, data step, proc sql, SAS Macros, proc datasets to process data.
• Moving data in hive directory, verifying data load in SAS VA, table registering in metadata.
• Attending group meeting, communicating on/off-shore team, technical documentation(NNM run book)

Environment: Linux, Enterprise Guide, Metadata, SAS DI Studio, SAS Management Console, SAS Visual Analytics 7.3, SAS proc: proc Hadoop, Hadoop hdfs, proc hdmd, beeline, proc mean, proc datasets, freq, contents, print, data null, data step, merge, sort, SAS macros.

Confidential, Renton, WA

Data Analyst, manager

Responsibilities:

• Upload products into Amazon site(AWS), ensure quality of data. Generate sale report, analysis of sale trend, summarize, Analyze (proc freq, contents, mean, aggregation summary, list, reporting, enhancement) and interpret results using standard statistical tools and techniques
• Identify new opportunities for process improvement
• Communicate with customer and solving the problem
• SAS, proc sql, SAS Macros for data automation and improvement

Confidential, Baltimore, MD

Consultant from TCS /SAS Developer / Data Management

Responsibilities:

• BI production data support, US, Canada and Puerto Rico scorecard programs modification, maintenance, BI SAS report development for US, Canada and Puerto Rico thin file (mainframe data step, proc sql, SAS macros, raw data read into SAS file, JCL), by base SAS, SAS Macros, Proc SQL, data null .
• Support of Basel monthly, weekly and daily SAS programs and process, generate reports of loan, rejection, delinquency and risk.
• Secure data transfer between mainframe and network share, data management, delete unused data from mainframe, archive programs. Support Risk management team, attending project meeting.
• Writing, reviewing project technical specification document and present in project meeting,

Environment: UNIX AIX SAS9.3, Enterprise Guide, Tectia interface, Z/OS SAS9.1.3 with Attachmate Reflection; JCL, ISPF, mainframe data management tool: Cman, web data management Tool: Informan (Virtual change); Service Now, SAS proc: proc mean, proc datasets, freq, contents, print, data null, merge, sort, SAS macros.

Confidential, Manhattan, NY

Consultant from Tata Consultancy Service /SAS Developer / Data Analyst

Responsibilities:

• Supporting data and analytics in Risk management, Key Risk Index (kRI) calculation, coordinate with business analyst to identify KRI related issues through monitoring action plans for risk related issues along with corporate line of business, Federal regulation, pull data and develop SAS code, analysis and implementation; Analysis of Issue level and action Plan level, developing and supporting production reports system.
• Develop SAS program to pull data, process and analyzing data, and run reports weekly
• Base SAS data step, data null, sort, merge, do loop, condition handling
• SAS Macros, automate large and repeated program sections, macro variable generation, parameter feeding.
• Proc SQL, build connectivity, data manipulation (selection, group, case, join)
• Proc SGPLOT to generate bubble charts with scatter statement to spread labels. Visualization of analyticalSubjects and charts annotation.
• Linear regression to generate charts to predict trend from historical data.
• Attending project meeting, collecting requirement from different group and translated to SAS code

Environment: SAS 9.3 in SAS-Unix, Putty, Base SAS data step, Proc sort, merge, Proc SQL, ODS, SAS-Macros, Proc means, SGPLOT(SAS9.4), SAS-Enterprise Guide, Unix Cron job setting Unix Korn Shell Script, Display Manager and Batch Mode, SSH (secure shell file transfer), Vi, MS Office Suite, PC File server convert excel to Unix SAS file, WinScp, FTP

Confidential, Tukwila, WA

SAS Developer/Business analyst

Responsibilities:

• SAS 9.2 programmer for business performance data management generates charts for sale market performance, inventory management (MAS200).
• Provide frequency data tables to support region sale activities research, summarize data, sort and merge data output data in different format (flat text, MS Office).
• SAS/ Macros coding and debug, generate tables, lists according business division’s requirements.
• Support MS Office, EXCEL
• Generate Bar Code file for client such as Amazon.com, provide accurate tracking.
• Liaison for company and manufacture in China, provide freight information, production improvement and order planning
• Providing regional sale and forecast report and analysis

Environment: SAS 9.1.3, Base SAS data step, Proc Report, SAS Macros, SAS-MAS 200 for small business, Proc SQL, Crystal Report, MS Excel, Macro, VBA, Proc means, Proc GLM, Univariate, PC SAS coding, and Display Manager Mode

Confidential, Bellevue, WA

SAS Programmer; Statistics & Decision support

Responsibilities:

• SAS programming/SAS MACROS design as part of AGILE development. Generated SAS graphs and reports for organizations according to their business requirements, Interpret and summarize analyses
• SAS data and program migration from SAS 8 to SAS 9; documentation and program verification.
• Responsible for daily SAS (UNIX Platform/Teradata/PC) query extract and load data, generate and manage large dataset by sort, merge and summarize regular ETL process.
• Documentation of modified/newly designed SAS programs, algorithms, macros.
• Interfaced SAS with ORACLE, MS SQL Server, SAS-SQL data dictionary inquiring to generate tables, lists, required SAS datasets (Print; Summary; Sort; Tabulate; Data step functions including drop/keep, Null; Transpose filtering logic).
• Linear regression and time series testing.
• Modify SAS programs to maintain data quality to rectify data inconsistencies and anomalies and set alert for exceptions.
• Automated processes to extract data from several thousand servers, and generated daily SAS graphs and customer required datasets (SAS-OLE ODBC).
• Developing web page and put in the SAS-Intranet, build user interface, create server directory
• Updated ORACLE tables by SQL plus.
• Wrote KORN SHELL script coordinate with system and datasets.
• UNIX administration (File management, add and remove servers)
• Maintain data security for all collected data and processed.
• Attended weekly group meetings, providing input on technical issues and project progress discussions. Provided data and reports for conference presentations (SCRUM-UPS).

Environment: SAS Macros, SAS Graph (Annotate), SAS Teradata, SAS Oracle, DB2, Proc report, Proc means, merge, sort, data null, Proc contents, Proc dataset, Proc tabulate, SAS Unix, SAS PC, SAS mainframe, Dreamwaver, Pearl, HTML, MS SQL Server, SAS intranet, SAS BI, CUBE, OLAP, OLTP, Unix Korn shell script, Oracle SQLplus.