SUMMARY

• 9 years of professional experience with increasing responsibilities and successful record of achievements in application design, project management, data analysis, forecasting and statistical analysis.
• Experience on working with SAS under platforms such as Windows (XP, Vista) & UNIX.
• Possess expertise in tailoring project methodologies, determining system requirements and specifications for complex application development projects.
• Experience in managing and training associates on statistical analyses, validating models, time management and problem solving, offering them guidance in their day to day business activities.
• Excellent written and verbal communication skills.
• Experience in Base SAS, SAS/STAT (Bivariate & Multivariate analysis) SAS/ETS, SAS SQL & SAS Macros.
• Experience working with different databases (RDBMS) like MS Excel, Oracle, SQL.
• Experience in analysis of data for statistical analysis and reporting.
• Experience in producing external files and reports employing various SAS procedures.
• Ability to handle Statistical Reports.
• Proficient in Database Management - Preparation of Data for analysis including rolling up of data, standardization of relevant fields, de-duplication.
• Organizing data in an optimized format to allow fast, easy access and to do analysis on that.
• Strong exposure in Business and Data analysis, design and training of users.
• Experience on working with Excel, PowerPoint and ODS HTML formatted files to produce ad hoc reports to the Users and Business Partners for Presentation and further Analysis.
• Experience in SAS with Oracle / Access connectivity.
• Export / import data from databases and perform migration of data using Upload, Download.
• Experience on working with SAS Data Warehousing and OLAP.

TECHNICAL SKILLS

Statistical Tools proficient with: SAS, SQL, SPSS, Excel.

Proficient at Microsoft Office: Excel (Solver, tables), Word, PowerPoint.

Programming languages known: SAS, knowledge of C/C++.

Analytical knowledge: Statistics, Data Mining (data discovery), Forecasting, Credit Scoring, Fraud Detection, Time Series, Linear and Logistic Regression, and more.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Senior SAS Consultant

Responsibilities:

• Responsible for supporting the Risk MI team in the definition, implementation monitoring and optimization of the portfolio credit policy and strategies for the brand producing standard and ad-hoc analyses.
• Providing advice and support to a team of Senior Analysts during the development of their projects.
• Determining key priorities and provide analytical and technical guidance to analysts to drive project completion.
• Developing asset quality monitoring.
• Identifying business trends based on economic and portfolio conditions.
• Executing strategic enhancements.
• Conducting weekly Flash Calls to update the weekly recovery numbers with all business partners.
• Communicating business trends, creating financial assessments and interpreting analytics.
• Work with and across functional project teams to ensure timely and accurate delivery of credit strategy and business projects.
• Load several xls, txt or csv files into SAS.
• Develop daily, weekly and monthly reports with SAS Macro Language.
• Analyze differences between portfolios from different areas.
• Translation of SQL code into SAS language.
• Translate business rules into technical language.
• SAS Support and documentation.

Environment: Base SAS v9.4, SAS Stat, SAS/Access, SAS/GRAPH, SAS/ODS, SAS Enterprise Guide, SAS Enterprise Miner, SAS Macros, Excel, Teradata, Windows, UNIX.

Confidential

SAS Developer Analyst

Responsibilities:

• Dividing the customer base into segments - Average Spend, Active Spend, Attrition, etc.
• Presenting the senior management about the key findings and proposals to increase Active Spend and reduce Attrition.
• Contributing to the decision-making processes and in driving strategies regarding sales force performance.
• Developing forecast models for plan the next financial year.
• Analyzing data and deciding on the variables to include in models and optimizing them.
• Development of multiple forecast scenarios based on statistical analysis of economic variables and potential forecast drivers.
• Participating in driving strategies with Strategies team by providing inputs and contributing to decision-making processes.
• Setting goals for business owners and tracking in-month progress.
• Training team members to help them learn Statistical Analytical processes and Data Base techniques using SAS, used for developing, optimizing and improving the models and daily processes.
• Assisting in the Vendor Goal Setting process for the Sales Strategies Team.
• Development of several daily, weekly and monthly reports into SAS.
• Development of the CGF methodology using transactional data from Teradata.
• Generate Downstream Performance report by channel, region and product with SAS.
• Develop a forecast methodology to calculate the BBA-V and BBA-C.
• Develop the Dashboard report using SAS.
• Responsible for the Daily Spend report.
• Development of several Ad-Hoc analysis and reports.
• Work remotely from Buenos Aires, Argentina and Bogota, Colombia.

Environment: Base SAS v9.4, SAS Macro Language, SAS Stat, SAS/Access, SAS/GRAPH, SAS/ODS, SAS/DDE, SAS Enterprise Guide, SAS Data Mining, PL/SQL, Oracle, UNIX, Teradata.

Confidential

Senior SAS Developer Analyst

Responsibilities:

• Responsible for Planning Quality and Reporting for analysis, programming and related technical and user liaison tasks.
• Perform requirements gathering and interpretation and develop technical design specifications through effective consultation with stakeholders and clients.
• Perform data analysis, programming, querying, reporting and ETL and job schedule configuration and testing.
• Provide professional advice and assistance to colleagues in the use of the management information system.
• Provide advice on schedule estimates, communicate project and task progress and give early notification of issues that may impact your efforts.

Environment: Base SAS v9.3, SAS/Access, SAS/GRAPH, SAS Enterprise Guide, SAS Data Integration, SAS Enterprise Miner, SAS Macro Language, Excel, Teradata, Windows, UNIX.

Confidential

Senior SAS Developer

Responsibilities:

• Work closely with business users to review, analyze and optimize various processes in the SDF department.
• Ensure accuracy of all SDF analytics using SAS Data Miner and SAS EGuide.
• Run Pre-forecasting and Forecasting analytics.
• Predict 10 and 25 years forecast for all electrical substation levels.
• Generate executive reports and ad-hoc reports.

Environment: SAS Enterprise guide 6.1, Base SAS V9.3, SAS Management Console, SAS Data Miner, SAS Macro Language, SAS/Access, SAS/GRAPH, SAS/STAT, SAS DDE, SAS/ODS, Oracle, UNIX.

Confidential

Senior SAS Developer

Responsibilities:

• Work closely with business users to review, analyze and optimize various processes in the SDF department.
• Data manipulation and transformation into SAS E Guide for the SDF department.
• Develop a Data Mining process to detect 15 minutes spikes, abnormal switching and fill data gaps with SAS Data Miner.
• Develop and accuracy of all SDF analytics using SAS.
• Generate web reports to visualize pre forecasting results.
• Data base redesign.
• Develop a user interface to generate the pre forecasting results.
• Develop of all the analytics to calculate the Rate of Grow (ROG) for each zone.
• Develop a model to predict Weather data and the POE50 loads (Probability of Exceedance).
• Predict 10 and 25 years forecast loads at the transformer level and zone-substation level using linear regression and time series.
• Generate executive reports and ad-hoc reports.
• Develop statistical studies to improve the forecast accuracy.
• Detection of Abnormal Switching, 15 minutes spikes and filling data gaps using Data Mining and statistical algorithms.
• Generation of ROG and Forecast Detail reports using SAS DDE.
• Generation of Weather data and Weather Corrected Load using the Montecarlo methodology with random numbers.
• 10 and 25 years forecast at the transformer and zone-substation level.
• Significant reduction of processing time.
• Increased time for analyze results.
• Flexibility to produce different forecast types.

Environment: SAS Enterprise guide 6.1, Base SAS V9.3, SAS Management Console, SAS Data Miner, SAS Macro Language, SAS/Access, SAS/GRAPH, SAS/STAT, SAS DDE, SAS/ODS, Oracle, UNIX.

Confidential

SAS Consultant

Responsibilities:

• Provide support in SAS Enterprise Guide, SAS Data Integration and SAS Forecast Server.
• Create reports with SAS Web Report Studio.
• Develop ad-hoc forecast with SAS Forecast Server.
• Develop What-if scenarios.
• Documentation.

Environment: Base SAS V9.3, SAS Enterprise guide 6.1, SAS Forecast Server, SAS Data Integration, SAS Macro Language, SAS/Access, SAS/GRAPH, SAS/STATAccenture (Consulting), Mexico.

Confidential

Responsibilities:

• Engaged with various stakeholders from different areas of the business to get an understanding of their processes and interpret their needs, often expressed in non-technical terms, and provided analysis and hands-on expertise in the construction of a Data Mart for the CRM department.
• Extraction Transformation and Loading from DB2 to UNIX Server using SAS Enterprise Guide process in the CRM area with SAS for a Data Mart.
• Collaborated with business users, managers and stakeholders to provide on-going business process re-engineering and optimization using SAS macro language.
• Responsible for the creation of datasets with unique Customer and Account of different credits.
• In charge of creating slow changing Dimension datasets
• Worked closely with stakeholders to review business needs, analyze data, and develop a suit of reports needed to provide business intelligence and MIS for the CRM department.
• Creation of reports for CRM area.
• Provided on-going support in SAS Enterprise Guide.
• Creation of a dataset with unique Costumer and Account for different credits.
• Implemented optimization tools which resulted in a considerable reduction of processing time.

Environment: Base SAS v9.1, SAS Enterprise Guide, SAS Macro Language, SAS/ACCESS, SAS/STAT, SAS/SQL, SAS Data Miner, ORACLE, Oracle Business Intelligence EE, Oracle Data Miner, PL/SQL, TOAD, MySQL, MS-OFFICE, Windows XP professional, Access, Excel, UNIX, DB2, Teradata, Fox Pro.

Confidential

Responsibilities:

• Responsible for data extraction, manipulation and transformation from SQL Server/FOX and for mapping and loading data into Base SAS for the Risk department.
• In charge of reviewing, re-engineering and integration of the business process for sending sensitive credit information of Confidential ’s customers.
• Monitored data integrity by ensuring customer information was up to date and accurate, and conducting on-going data audits and cleansing tasks.
• Worked closely with business users to review, analyze and optimize various processes within the organization, including optimization of the Monthly Update and Adviser Process using SAS macro language.
• Responsible for the migration of the Monthly Update Process from the Base SAS to SAS Enterprise Guide on IBM Server.
• Developed a Daily Updated Process based on the Monthly process already utilized in the business.
• Produced a number of complex reports for the MIS department.
• Provided support in Base SAS and SAS Enterprise Guide.
• Through the optimization of the Monthly Update and the Adviser process, the business experienced a considerable reduction in processing time for the information delivery in a timely manner.
• Conducted a project which involved on-going data audits used to ensure data integrity and accuracy, which resulted in the recovery of $4 million for the business.

Environment: Base SAS v9.1, SAS Enterprise Guide, SAS Macro Language, SAS/ACCESS, SAS/STAT, SAS/SQL, SAS Data Miner, ORACLE, MySQL, MS-OFFICE, Windows XP professional, Access, Excel, UNIX, DB2, Fox Pro.

Confidential

Responsibilities:

• Responsible for data cleansing, mapping and migration during a server upgrade.
• Extraction of information from database systems through specialized report development using the Oracle Intelligence Tool.
• Provided in-depth data analysis and forecast to give the business an insight into client behavior and trends based on various factors such as socio-economic status, most popular hour of the day, day of the week, and week of the month for banking.
• Market Basket with SAS Miner and with Oracle Miner.
• Designed and implemented a set of Association Rules which allowed the business to determine the success of particular campaigns in a timely manner.
• Provided process streamlining and optimization of the OBI system which resulted in a reduction of time accessing information needed for decision making and corporate reporting.

Environment: SAS Macro Language, SAS/STAT, SAS Data Miner, ORACLE, Oracle Business Intelligence EE, Oracle Data Miner, PL/SQL, TOAD.

Confidential

Junior Consultant

Responsibilities:

• Promoted in July 2007 due to the work that I did as a scholarship holder in January 2007.
• Responsible for the ongoing update and monitoring of executive information
• Provided on-demand analysis and reporting on executive information
• On-going provision of data integrity and system maintenance to ensure optimal performance and data quality.
• Provided analysis and process streamlining of the Bank's Granting Credit Portfolio, using Oracle and SPSS.
• Queried the database and provided data mining and analysis for on-demand custom mailing campaigns.
• Provided data modeling to compile the profile of clients who owned a credit card.
• Optimized the client selection process through the use of stored procedures in Oracle, which resulted in a better campaigns planning.

Environment: SAS Enterprise Guide, SAS/ACCESS, SAS/STAT, SAS/SQL, SPSS, ORACLE, Oracle Business Intelligence EE, Oracle Data Miner, PL/SQL, Windows XP professional, Access, Excel, UNIX.