[Show all top banners]

Danger
Replies to this thread:

More by Danger
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 ANY SAS DEVELOPERS AROUND??
[VIEWED 3908 TIMES]
SAVE! for ease of future access.
Posted on 07-26-07 11:52 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

I need some help with my storey to get a job. Can anyone help me with SAS??
Thanks
 
Posted on 07-26-07 11:59 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

what do u need?
 
Posted on 07-26-07 12:48 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

I need a storey that I can sell to the client.

No one is buying my storey. I need a storey for at least three projects and been in bench for 3 months. Something is wrong. I am getting vendor calls which go fine, but I screw up on the client interview.

I was working on a centralized scoring environment fir execution of statistical models for enterprise decision, where I was dealing with various lines of businesses. Scripts for some of these models were already there, and we were creating others with statisticians. I was participating in different phases of software development life cycle including, design, development, integration and testing.

Other then that I was involved in quality assurance and technical review activities. I also worked with management and end user groups to identify and requirements for future product enhancements.

They ask me cross questions on this and I don’t have much to say on the development side.

I know I am saying the wrong things. Can you help me to get a better storey that sells? I would rather have a reporting storey then this one.

This is what my resume says:

Performance driven SAS consultant with over five years of experience in analysis, development and implementation of statistical data models for projects in the financial industry seeks a challenging position.

PROFESSIONAL SUMMARY

• More Than Five years of consulting experience in SAS v 6.0, 8.2, and 9.1 on Windows, UNIX and mainframe platforms.
• Expertise in Base SAS, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ETL, SAS/ETS, SAS/ODS.
• Extensive knowledge of different SAS data extraction and export techniques using SAS/SQL, SAS/ACCESS, SAS/EXCEL and SAS/EVIEWS
• Experienced in preparation of SAS Datasets, Tables, Listings, Graphs, Reports and Summaries according to the requirements, Standard Operating Procedures, Statistical Analysis Plan.
• Advanced skills on data cleaning and manipulation using procedures such as PROC SUMMARY, PROC SORT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC PRINT and many SAS data steps such as ARRAY, MERGE, SET, etc.
• Good command in producing tables, listings, reports employing SAS procedure steps such as SAS ODS, DATA _NULL_, PROC REPORT, and PROC TABULATE.
• Strong background in statistical techniques such as Correlation, Regression, Multiple and Logistic Regressions; Multivariate Analysis, one way and two way ANOVA and MANOVA tests, Cluster Analysis, Time series Analysis and Business Forecasting, Factor Analysis and Panel Data.
• Developed statistical data models for sales forecasting, customer business intelligence, customer behavior, promotional analysis, targeting marketing campaigns, etc.
• Experience in creating ad hoc reports as per requirements.
• Experienced in Teradata, Oracle, DB2, SQL, and strong UNIX Shell Scripting skills.
• Exposure to data manipulation and analysis, summary of findings, develop analysis indication; communicate strategic insight.
• Experienced with working on demographics, adverse events, Meta data, pooled datasets, and messy raw data.
• Effective team player with strong communication and interpersonal skills as well as self-motivated individual with strong technical and analytical abilities.

TECHNICAL EXPERIENCE

Operating Platforms: Microsoft Windows 98/2000/NT/XP, HP-UX, UNIX, Linux, Mainframe
Databases: TeradataV2R6, Oracle 6x/7x/8i/9i, MS SQL Server 2000/7.0/6.5, MS Access 2000, DB2
Programming Languages: C, Java, VB 6.0, VBA, SQL, PL/SQL, UNIX Shell Scripting
SAS Skills: SAS v 6.0, v8.2, v9.1.3, Enterprise Guide v3.0, v4.1
Other skills: MS Office (Word, Excel, Power Point, Access, FrontPage), EVIEWS





PROFESSIONAL EXPERIENCE

Sept. 2006 – July 2007

SAS Application Developer
, Richmond, VA
is one of the largest, most analytically sophisticated financial service providers in the world. One of the growing Fortune 500 Company, it is known for giving affordable access to credit to tens of millions of customers worldwide. It also provides auto, home and business loans, plus banking and other financial services. The duties and functions can be summarized as following:
Responsibilities:
• Was responsible for creating new code, utilize existing code and maintain data in SAS.
• Worked on ways of exploring new coding techniques to retrieve data and maintain datasets.
• Performed data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and Documentation.
• Created and modified existing SAS datasets using PROC SQL, PROC DATASETS, PROC DOWNLOAD, ROC IMPORT, etc.
• Developed and analyzed key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, PROC RANK, and DATA _NULL_.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, and SAS/MACROS, for statistical analysis and data displays.
• Generated reports to communicate key findings and articulated strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN, PROC GPLOT, and PROC GCHART.
• Built summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC FREQ.
• Helped maintaining the data driven website to increase the efficiency of the programming team leading to a better deliverable product through SAS/IntrNet.
• Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and Power Point.
• Documented the purpose and methods used in each SAS program.
• Used shell scripting using Korn shell (ksh) to run the SAS programs.

Environment: Windows NT, UNIX, TeradataV2R6, SAS v.9.1, SAS/SQL, SAS/Macro, SAS/Connect, SAS/STAT, SAS/IntrNet, SAS/Graph.

Sept. 2005 – Jul. 2006
SAS Consultant/Analyst
, Minneapolis, MN
is now one of the world’s largest integrated financial services organizations with operations in 70 countries around the globe. For the year 2005, Allianz SE reported gross revenues of $125.5 billion. In 2006, the company ranked as the 16th largest corporation in the world.
Responsibilities:
• Extensively interacted with business users for requirements gathering, analysis and documentation.
• Extracted the source data from Oracle, and various flat files using data steps in SAS. Implemented using SAS/SQL pass through facility for connecting to various data sources.
• Used Base SAS to develop SAS extracts for transformation and loading of data.
• Developed reusable code using SAS MACROS to direct the program to look for the table names in a driver program.
• Performed data analysis and built statistical models incorporating various factors including customer demographics, peak season, market conditions, etc. to create a data model to predict customer behavior. These data models were used to target future marketing programs.
• Formulated recommendations to marketing managers regarding customer segmentation, acquisition and cross-selling using SAS/STAT.
• Used statistical techniques such as regression and time-series analysis.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools such as SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/SQL, and SAS/CONNECT.
• Developed HTML scripts using SAS/IntrNet to collect view and information from the end customers.
• Extensively used SET, UPDATE and MERGE statements for creating, updating and merging various SAS datasets.
• Used PROC SUMMARY and PROC REPORT to document the results and presented them using MS Power Point.

Environment: Windows NT, Oracle9i, SAS v8.2, SAS/ODS, SAS/SQL, SAS/Macro, SAS/Connect, SAS/IntrNet, SAS/STAT, SAS/Graph.

Jan. 2005 – July. 2005
SAS Application Developer/ Support
, Eagan, MN
The philanthropic arm of Blue Cross and Blue Shield of Minnesota, provide the opportunity to address significant influences on health that are beyond the traditional reach of the health care system. Through their work, Blue Cross furthers its social investment as a nonprofit health plan with a unique charter to improve the health of all Minnesotans.
Responsibilities:
• Worked as part of the Healthcare Informatics team for SAS application called ‘Reports at Hand’ – R@H
• Coordinated among the technical and the business team.
• Supervisory responsibilities for the level 2 R@H Support.
• Handled various SAS based client issues regarding the R@H application.
• Used SAS functions and procedures (Statistical as well as non-Statistical) to create reports in .pdf and .rtf formats.
• Extracted data from databases and loaded then to databases such as oracle, using PROC SQL. Apart, converted data from various databases and handled merging of datasets using SQL join.
• Created ad hoc reports as per requirements of the end users.
• Worked in the Development, Testing and Production phase environments for the R@H Application.
• Gained extensive Knowledge of pre-set MACROS and PROC SQL.

Environment: AIX 5.2, UNIX, DB2, SAS v8.2, SAS/ODS, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Graph.

Jan. 2004 – Dec. 2004
SAS Consultant/Analyst
Associated Banc-Corp, WI
Associated Banc-Corp, headquartered in Green Bay, Wis., is a diversified bank holding company with total assets of $21 billion. Associated has more than 315 banking offices serving more than 180 communities in Wisconsin, Illinois, and Minnesota.
Responsibilities:
• Provided ad-hoc data analysis and reporting support for Sales and Marketing using Base SAS programming.
• Performed ad hoc quantitative analysis utilizing methods such as ratios, shares, time series analysis, frequencies, and cross-tabs on the sales data.
• Interacted with IT to help ensure that the Sales and Marketing data environment is both dynamic and efficient.
• Developed SAS/MACRO to standardize the report and chart generation for re-use with PROC TABULATE, PROC REPORT, PROC APPEND PROC GPLOT, and PROC GCHART etc.
• Created reports with multiple graphs and chart displays into a single Excel spreadsheet for reporting purposes.
• Created individual rtf files for summarizing the results and also to document the metadata.
• Performed data manipulations on data stored in Oracle using SQL Assistant and PROC SQL.

Environment: Windows NT, UNIX, Oracle9i, SAS v8.2/9.1, SAS/ODS, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Graph.

Apr. 2003 – Nov. 2003
SAS Analyst / Programmer
NorthWestern Energy, Sioux Falls, S.D.
NorthWestern Energy, headquartered is an investor-owned utility that provides electricity and natural gas in the northwest quadrant of the United States. They serve electricity and natural gas in Montana, South Dakota and Nebraska.
Responsibilities:
• Extracted data from Oracle and converted into SAS data sets.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS datasets.
• Extensively used SAS/STAT, SAS/MACROS for regression analysis and time series forecasting.
• Developed customized reports in various dimensions for better analysis and comparison of different portfolios.
• Established a framework to capture risk factors and relationships and developed programs using simple regression, multiple regression, multivariate analyses and time series forecasting.
• Responsible for the system study, analysis, design, development, coding, generation of reports using SQL, PL/SQL, MS-Access, testing and documentation.
• Used JAVA applets for simulating the pricing model.
• Created PROC TEMPLATE for customizing the presentation of output using SAS/ODS.
• Involved in data extraction from the data warehouse, validation, modeling and processing.
• Delivered several customer specific presentations of processes using MS Power Point, MS Project.

Environment: Base SASv8.2, SAS/Connect, SAS/SQL, SAS/ODS, SAS/MACROS, UNIX.

Jan. 2002 – Mar. 2003
SAS Consultant/Programmer
TCF Corporation, Minneapolis, MN
TCF Corporation is a Minnesota-based national financial holding company with $14.7 billion in total assets. It has banking offices in Minnesota, Illinois, Michigan, Colorado, Wisconsin, Indiana and Arizona. It is now the 13th largest U.S. Visa® Classic debit card issuer ranked by sales volume.
Responsibilities:
• Was responsible for requirement based data extraction and analysis of large data sets from individual credit card clients.
• Worked with huge datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS, and PROC TABULATE for creating a list of targeted customers.
• Worked closely with the business analysts to sift out the nest campaign strategy amongst possible alternatives.
• Responsible for developing SAS MACROS and SAS GRAPH for creating tables, graphs and listings.
• Synchronized the extracted data with the SAS OLAP server in order for the business analysts to make quick decisions.
• Worked with the development of a module for identifying risk factors to achieve a higher response rate for target-specific offers thereby reducing marketing costs.
•
Environment: UNIX, Oracle9i, Base SAS v8.2/v6.0, SAS/SQL, SAS/Macro, SAS/STAT.
 
Posted on 07-26-07 4:23 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

hey danger, are the work experiences you mentioned above real?
 
Posted on 07-26-07 4:40 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

If it is not created by dhoti consultant, then you should be like a hot cake. I know SAS has excellent job market.
 
Posted on 07-26-07 6:01 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

You may need an help on how to face an interview specially one who knows SAS. You may be missing something while facing the client. You may not be knowing but they will catch it and you can avoid those.
GOOD LUCK.
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 60 days
Recommended Popular Threads Controvertial Threads
शीर्षक जे पनि हुन सक्छ।
NRN card pros and cons?
What are your first memories of when Nepal Television Began?
Basnet or Basnyat ??
nrn citizenship
Sajha has turned into MAGATs nest
Nas and The Bokas: Coming to a Night Club near you
डीभी परेन भने खुसि हुनु होस् ! अमेरिकामाधेरै का श्रीमती अर्कैसँग पोइला गएका छन् !
3 most corrupt politicians in the world
if you are in USA illegally and ask for asylum it is legal
Top 10 Anti-vaxxers Who Got Owned by COVID
निगुरो थाहा छ ??
Travelling to Nepal - TPS AP- PASSPORT
Poonam pandey - death or suicide?
ढ्याउ गर्दा दसैँको खसी गनाउच
Doctors dying suddenly or unexpectedly since the rollout of COVID-19 vaccines
काेराेना सङ्क्रमणबाट बच्न Immunity बढाउन के के खाने ?How to increase immunity against COVID - 19?
TPS Work Permit/How long your took?
How long does Citizenship take?
Will MAGA really start shooting people?
Nas and The Bokas: Coming to a Night Club near you
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters