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.
