SUMMARY:

• SAS lead over 9+ years of experience in Base and Advanced SAS, SAS DI, SAS BI and SAS Platform Administration.
• Experience in the areas of Enterprise Application/Data Integration and reporting tools.
• Worked extensively in Data Modeling, Data warehouse architecture, DWH/BI, Dimensional modeling, Star, Snowflake schema, OLAP Cube, Source Target mapping, Logical and Physical modeling using ERWin, cleansing, Sorting, Merging, Data joins, Data Transformation.
• Experience in comprehending and maintaining complex enterprise IT architecture with wide variety of applications.
• Experience in Financial Services and Insurance (Banking and Automobile Sinister) domains.
• Experience in SAS/BASE, SAS/SQL, SAS/ODS, SAS/ACCESS, SAS Enterprise Guide, SAS Data Integration, SAS Web Report Studio, SAS Information Maps, SAS Studio, SAS Portal, SAS Dataflux.
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Ability to handle multiple tasks individually as well as in a team.
• Proven skills in Data Cleansing, Data Management, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS on UNIX, Windows and Linux.
• Excellent analytical and problem-solving skills focused on the needs of business requirements.
• Problem Management, Issue resolution, System fixes and enhancements.
• Possess strong ability to quickly adapt to new applications and platforms.
• Experience in SAS Administration activities, also in Installation activities.
• Coordination with various functional and technical - onsite and offshore teams.
• Extensively used PROC SQL in extracting data from relational databases like Oracle, DB2, Informix, SQL Server and Sybase.
• Wrote new SAS programs from scratch, automated and fine tuned existing SAS code using SAS Macro, SQL Pass-thru, SQL Tuning and generated HTML/PDF/RTF Reports, listings Graphs/Charts.
• Data mapping, data profiling of the data models, validate the metadata, improve data quality and data integrations and create data marts to be used further in data visualization and reports generation.
• Data Preparation from extracting data from multiple sources, flat files, tables, validate data types, cleaning, data transformation using metadata, SQL queries and Joins/Filters in the transformations and load tables into data marts and generate customized reports used by data warehouse team.
• Extensive hands on expertise in leading projects from Requirement Analysis, Design, Planning, Estimation, Coding, Code Reviews, Test Plan Preparation, Debugging, Unit/System/Integration/Regression Testing, UAT, Implementation and Production Support.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/Macros, SAS/Access, SAS/SQL, SAS Enterprise Guide, SAS Data Integration, SAS Web Report Studio, SAS Information Maps, SAS OLAP Cube Studio, SAS Management Console, SAS Studio, SAS Dataflux.

Tools: TOAD 7.2, Notepad++, Sublime, SQL Developer, Putty, WinSCP, Aqua Data Studio, ERWin

Programming: SAS, Visual Basic, PL/SQL, MySQL, HTML, Unix Shell Scripting, PHP

DBMS: Oracle 11g/10g/9i, SQL Server, Microsoft Access, Informix, Sybase, Netezza, DB2

Operating Systems: Unix, Windows /XP/7/8/9/10, Windows Server 2012 R2, Windows Server 2008 R2, MacOSX, Linux Red Hat.

MS Office suite: MS word, MS PowerPoint, MS Excel, MS Access

PROFESSIONAL EXPERIENCE:

Confidential,Minneapolis,MN

SAS Technical Lead / SAS Administrator

• Coordination of Canadians Development Teams.
• Responsible for advance analysis of non-commercial customer’s enrollment data, product data, banking data, credit card transactions data, and demographic data to identify the potential risks and create a detailed list reports.
• Performed forecasted results for credit card holders on demographical basis, analysis of competitor, customer, risk and pricing.
• Development of Processes for data quality assessment
• Evaluation of suitability of data elements as identifying attributes for matching and linkage.
• Developed application for measuring financial performance of newly acquired accounts: Forecast vs. Actual and developed SAS programs for generating reports on Key financials, Income Statements, and Balance Sheet.
• Involved in the creation and conversion of SAS datasets from tables and flat files, analyzing the dataset and generating reports by employing complex data manipulation.
• Performed Data analysis mainly using Regression (Proc Reg) and ANOVA (Proc Anova) and other SAS statistical procedures like (PROC GLM, PROC UNIVARIATE, PROC MEANS, PROC FREQ)
• Transformed the SAS datasets as per the business model requirements using various SAS data step techniques and procedures.
• Worked on SAS Enterprise Guide to perform data analysis and develop stored processes to distribute the reports in a secure manner
• Interpretation of documents issued by the National Banking and Securities Commission, for changes to the systems involved in the reserve calculation process.
• Preparation of manuals for installation and operation of developed solutions.
• Analysis, development and implementation of data masking methods by virtue of complying with national customer data protection standards.
• Follow-up to simultaneous work plans
• Decision Management using SAS BI.
• Project Estimation and Administration.
• Change control for the integration of new developments into the production environment.
• Preparation of work plans, test plans, as well as plans in case of contingency by mistake in the start-up in the productive environment.
• Visual Basic development for creating screens for interaction between the Front End and Back End in SAS.
• Analysis, creation and modification of ETL scripts using Basel Method.
• SQL development for creation of Regulatory Reports. (Informix, Sybase, SQL Server, SAS)
• Administration of SAS Environments. (Dev., Testing & Production, SAS 9.1, 9.2 & SAS 9.4)
• Analysis, design and implementation of regulatory reports.
• Status Reporting
• Analysis, creation and release of stored process
• Convert business needs into technical requirements.
• Analysis, creation and implementation of the technical solution to the business needs.

Environment: SAS V9.1 Upgraded to Version 9.4 - Management Console, SAS BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/IML, SAS/EG, SAS/ODS, SAS/ACCESS and SAS/CONNECT, SAS Dataflux, Sybase, Aqua Data Studio, Informix, Windows server 2012, SAS 9.4 Tools (Banking Analytics Architecture), IPSwitch, PVCS, Reflection, Supper Putty, WinSQL, SQL Studio, SQL Server Management Studio, TERADATA, DB2, SQL Server 2008, Windows XP, Unix Sun Solaris.

Confidential,OH

SAS Project Lead

• Upgrade SAS 9.1 Business Intelligence Architecture to SAS 9.4 Banking Analytics Architecture.
• Coordination of development teams.
• Installation of SAS 9.4 on Production Environment, (Metadata Server, Work Space Server, & Web Server) Layered Installation.
• Analysis of total storage of the platform.
• Performance analysis for all areas using SAS.
• Analysis and creation of profiles in metadata for the administration of the platform.
• SAS Integration with LDAP Authentication.
• SAS Projects leader.
• Preparation of manuals for installation and operation of developed solutions.
• Analysis, development and implementation of data masking methods by virtue of complying with national customer data protection standards.
• Follow-up to simultaneous work plans
• Project Estimation and Administration.
• Change control for the integration of new developments into the production environment.
• Preparation of work plans, test plans, as well as plans in case of contingency by mistake in the start-up in the productive environment.
• Administration of SAS Environments. (Dev., Testing & Production, SAS 9.1, 9.2 & SAS 9.4)
• Status Reporting
• Convert business needs into technical requirements.
• Analysis, creation and implementation of the technical solution to the business needs.

Environment: SAS Version 9.4 - SAS Enterprise Guide 7, Management Console, Base and Advanced SAS, SAS EG, Sybase, Aqua Data Studio, Informix, Windows server 2012 ., SAS 9.4 Tools (Banking Analytics Architecture).

Confidential

Senior SAS Consultant

• Process Automation with SAS Scripts
• Shell Developing.
• Active Directory Integration between SAS and Windows.
• SAS Server Administration.
• Teamwork and progress tracking.
• Information Meetings
• Delete files, using as input a plain text file.
• Creation of profiles with access control to server routes
• Allocation of pre assigned libraries with control access for bank areas using SAS
• Space monitoring to avoid disk space contingencies

Environment: SAS V9.4 running under Linux Red Hat x64- SAS Enterprise Guide, Linux Red Hat x64.

Confidential

SAS DI and SAS Developer

Responsibilities:

• SAS DI and SAS Developer role.
• Analysis, creation and modification of ETL processes using Basel Method.
• Extensively used DATA Step, Formats, Functions, Macros, SORT, MERGE, PROC SQL, TRANSPOSE, TABULATE, COMPARE, REPORT, GRAPH etc. in Data transformation and Manipulation processes.
• Data cleaning for portfolio: Companies and large corporate.
• Delivering varies type of reports using Base & Advanced SAS oracle and DB2.
• SAS code Optimization using best practices.
• Modification of existing Reports, development of new Reports and testing using Base and Advanced SAS.
• Generating SAS datasets from tables in Database using SAS/Access, set, infile (flat files), merge.
• Using procs like print, sort, means, transpose, export and etc.
• Extract data from oracle Data access using implicit and explicit pass-through SQL.
• Production support issues Analysis and Fix.
• Customer Communication.
• Status Reporting.
• Project Management and technical architect.
• Review of architectural documents.
• Team Development: individual goal setting, mentoring, performance measurement
• Translating customer requirements into technical requirements.
• Working with Linux shell programs to execute SAS programs.

Environment: SAS V9.4 running under Linux Red Hat x64- SAS Enterprise Guide, SAS Management Console, SAS Base and Advanced SAS, Oracle 11G, Toad, DB2, SQL Server 2012.

Confidential

Manager of SAS Teams

Responsibilities:

• Manager of SAS Teams working from Mexico
• Analysis, development and optimization of ETL's in SAS Data Integration and SAS Enterprise Guide.
• Creating reports using SAS Web Report Studio and SAS Information Maps SAS OLAP Cube Studio.
• On demand modification to Data Marts, to apply changes to the SAS Credit Scoring Detailed Data Store (DDS), using Landing Data Tables and Staging Phases.
• Data Analysis such as forecasting, correlation, or fit lines exploring in-memory tables (VA Explorer) from the SAS LASR Analytic Server.
• Design, Development and Visualizations of Reports and Dashboards (VA Designer)
• Created macros and extensively used existing macros and developed SAS.
• Generated summary reports, listing and graphs using procedures like PRINT, REPORT, CONTENTS, FORMAT, MEANS, FREQ, TABULATE, SQL,
• Analysis and Estimation Proposal for SAS type developments under the scheme of a Software Factory
• Production support in regulatory reports to the Super Administration of Banks of the Dominican Republic.
• Creating scripts running on AIX 6.0
• SAS management tools for SAS BI team in Dominican Republic.
• Creation and maintenance of reports using SAS BI Platform and Oracle 11g.
• Use of SQL Scripting with SQL Developer for ORACLE and SAS Web Report Studio for the creation of Web Reports for Auto Claims area.
• Creation of Reports on SAS Information
• Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports.
• Trouble Ticket analysis and resolution.
• Supports the migration activities (deployment instructions).
• Analyzing Business requirements and developing SAS DI Jobs.
• Creation of Promotional document and Operational guide.

Environment: SAS V9.2- SAS Enterprise Guide, Management Console, Base and Advanced SAS, SAS EG, SAS DI, AIX, Putty, WinSCP, SAS OLAP Cube Studio

Confidential

Manager of SAS Teams

Responsibilities:

• Analysis, development and optimization of ETL's in SAS Data Integration and SAS Enterprise Guide.
• Creating reports using SAS Web Report Studio and SAS Information Maps SAS OLAP Cube Studio.
• Created macros and extensively used existing macros and developed SAS.
• Generated summary reports, listing and graphs using procedures like PRINT, REPORT, CONTENTS, FORMAT, MEANS, FREQ, TABULATE, SQL,.
• Validation of figures with accounting methods with business areas.
• Creating scripts running on AIX 6.0
• SAS management tools for SAS BI team in Mexico City (@axa).
• Creation and maintenance of reports using SAS BI Platform and Oracle 11g.
• Use of SQL Scripting with SQL Developer for ORACLE and SAS Web Report Studio for the creation of Web Reports for Auto Claims area.
• Creation of Reports on SAS Information
• Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports.
• Trouble Ticket analysis and resolution.
• Supports the migration activities (deployment instructions).
• Analyzing Business requirements and developing SAS DI Jobs.
• Creation of Promotional document and Operational guide.

Environment: SAS V9.2- SAS Enterprise Guide, Management Console, Base and Advanced SAS, SAS EG, SAS DI, AIX, Putty, WinSCP, SAS OLAP Cube Studio