Professional Summary:

• Technology Consultant with Eleven years of experience in various SAS Business Intelligence Analytics Tools , SAS Administration, problem-solving, leadership, implementation and management of complex software systems.
• Experience in SAS Administration 9.2, 9.3, 9.4 and BI Architecture.
• Installing and configuring SAS products on Server, Client and managing Metadata Repositories.
• Disaster recovery and performance tuning of the SAS applications.
• Maintaining SAS user/groups privileges, managing software licenses.
• Given SAS and SAS EBI tools training to team members.
• Expertise in handling complex Processes using Base SAS, SAS/Macros, SAS/Access, SAS/Connect and SAS EBI Tools.
• Experience in Integration of various Data Sources like MS-Access, Excel, Flat and CSV Files.
• Good experience in extracting tables from Oracle and Teradata using SAS.
• Experience in various SAS Solutions as SAS Integrated Profitability Management Solution IPM , Activity Basied Management ABM , SAS Anti Money Laundering Solution AML and SAS Metadata Server.
• Involved in Pre-sales, POC projects, RFI and RFP.
• Well versed with Data Warehousing Concepts.
• Worked on various projects involving data warehousing platforms like ETL.
• Received corporate Training in Basel II.
• Attentive in understanding and providing quality solutions to customer reported problems.
• Experience in quality reviews to ensure that best quality output has been shared with the clients.
• Analyzed business requirements from customers in a detailed way and proposed solutions which were very effective and user friendly.
• Built good working relationship with the team members and provided guidance in coordinating and completing shared tasks.
• Motivated the team members in a way that led to positive results within the team.
• Knowledge
• Technologies: SAS 9.1.3, 9.2 and 9.3 SAS Base, SAS Macros, SAS Connect, SAS Access and SAS BI Tools - SAS DI Studio, SAS OLAP Cube Studio, Management Console, Stored Process, SAS Enterprise Guide, SAS Information Map Studio, SAS Web Report Studio and SAS Information Delivery Portal , UNIX, Windows 2000/XP/2003 Server, Mainframe and SQL.

SAS Solutions: SAS Integrated Profitability Management IPM and ABM and SAS Anti Money Laundering AML .

Industry Expertise: Banking, Insurance, Retail and Market Research.

Professional Summary:

Confidential

SAS Integrated Profitability Management Solution Technology Consultant

Responsibilities:

• Installing and configuring SAS products on Server and Client ABM PM .
• Monitoring servers, deploying patches and hotfixes.
• Disaster recovery and performance tuning of the SAS applications.
• Maintaining SAS user/groups privileges and managing software licenses.
• Re-architecture the existing Integrated Profitability Management project, due to the performance issues.
• Involved in Data Warehouse Architecture design for ABM Solution.
• Worked as an Technology Consultant to assist in technical support to offshore and on-site team members.

Technologies: SAS Activity Based Management and Profitability Management solutions SAS BI Tools SAS ABM Server Client, SAS PM, SAS DI, OLAP Cube Studio, Information Map Studio and Web Report Studio, Windows.

Confidential

Solvency II Project

Project Lead

Responsibilities:

• Worked as an Onsite Project lead to manage the offshore and onsite team members.
• Conducting weekly meetings with offshore and onsite team for work assignments, status
• reviews and clarifications.
• Assisting in building a technical foundation for AG insurance.
• Involved in Data mart design.
• Developed complex ETL jobs using SAS DI Studio.

Technologies: SAS BI Tools SAS DI, OLAP Cube Studio, Windows and Mainframes.

Confidential

Data One Project

Project Lead

Responsibilities:

• Involved in Data Warehouse Architecture design for Data One project.
• Installing and configuring SAS products on Server and Client.
• Developed ETL jobs using SAS DI Studio.
• Built the Metadata Index comparison tool with SAS Store processes.
• Following the SDLC methodology for the development of SAS ETL jobs.
• Involved in QC operations and data analysis responsibilities to make sure that the data delivered is accurate.
• Conducting weekly meetings with team for technical work assignments, status reviews and clarifications.

Technologies: SAS EBI Tools, SMC, SAS DI, SAS Connect, SAS Access, Control-M, Winris, E2Klist, Windows and Mainframes.

Confidential

EB Migration Project

Project Lead

Responsibilities:

• Migrated the SAS programs from Mianframe environment to Windows environment using SAS migration procedures.
• Sheduling SAS programs through Control-M and Winris tools.
• Involved in Testing and Debugging of SAS code.
• Improved the performance of existing processes.

Technologies: SAS Macros, SAS connect, SAS Access, Windows, Control-M, Winris, Mainframes and VMS.

Confidential

Project Lead

Responsibilities:

• Involved in the complete SDLC process for the build of a DWH common data store layer , UDS User data store layer and the Information Portal reporting layer
• Understanding the CDM model and developed the Physical data model in DB2 Mainframe. Also based on the CDM model of UDS layer, develop the SAS based model in the UNIX environment for reporting.
• Developed XML reports using SAS XML Mapper.
• Performed Data validations/integrity checks before delivering to Business Customers.
• The detailed flows of each automated process are documented accordingly for future reference.

Technologies: SAS Macros, SAS Connect, SAS Access, SAS XML Mapper, Windows and UNIX.

Confidential

Project Lead

Responsibilities:

• Involved in project management and the impact analysis meetings.
• Involved in requirements gathering and in designing phase.
• Migrated existing SQL programs in Mainframe platforms into SAS programs in Windows platform.
• Sheduling SAS programs through Control-M.
• Involved in Testing and Debugging of SAS code.
• Improved the performance of existing processes.

Technologies: SAS Macros, SAS Connect, SAS Access, Windows, Control-M, and Mainframes.

Confidential

Credit Risk MIS Reporting

Responsibilities:

• Developed ETL jobs using SAS DI Studio.
• Creating semantric layer with SAS Information map studio, which is using for adchoc reporting for super users.
• Create various combinations of Information maps and OLAP cubes to generate reports.
• Given SAS BI training to team members.

Technologies: SAS Macros, SAS Connect, SAS Access, SAS BI Tools SAS DI, OLAP Cube Studio, Information Map Studio and Web Report Studio, Windows and UNIX.

Confidential

SAS Senior Analyst

Responsibilities:

• Tracking of the response and booking rate to generate valid data for former decisions.
• Execute some stat analysis and weekly tests and null test.
• Selection of affine Address for different WM Products.
• Execute different tests to be prepared for the new legal base in Germany new data Protection Act
• Ex-Post analysis of model performance, model stability, fact finding analysis
• Campaign selection from the prospect database.
• Data testing and database management.

Confidential

SAS Consultant

Responsibilities:

• Involved in Data cleaning using SAS DI Studio.
• Developed ETL jobs using SAS DI Studio.
• Data Mappings between databases to Core system.
• Created Scenarios and Risk factors for Knowledge systems.
• Involved in Testing and Debugging.
• Scenario Administration, Customization and Tuning.
• Scheduling of ETL Codes, Report Generation through Autosys.

Technologies: SAS Connect, SAS Access, SAS BI Tools - SAS DI Studio and SAS AML Solution.

Confidential

Sr. Software Engineer

Responsibilities:

• Analyze the requirements.
• Involved in Data cleaning with SAS programs.
• Develop SAS scripts to update the detailed datasets.
• Develop custom SAS macros and UNIX scripts.
• Involved in Testing and Debugging SAS code.

Technologies: SAS Base, SAS Macros, SAS Connect, SAS Access and Windows 2003, UNIX

Confidential

SAS Consultant

Responsibilities:

• Involved in ETL development and testing using with SAS DI.
• Develop SAS scripts to update the detailed datasets.
• Create various combinations of Information maps and OLAP cubes to generate reports.
• Involved in Testing and Debugging SAS code.

Technologies: SAS BI Tools - SAS DI Studio, SAS OLAP Cube Studio, Management Console, Stored Process, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal and Windows 2003 Server.

Confidential

SAS Analyst

Responsibilities:

• Involved in Data cleaning using base SAS datasets.
• Involved in analyzing the data using base SAS.
• Coordinated with the team for various enhancements during the process.
• Prepared various reports using SAS Base.
• Involved in Testing and Debugging of SAS code.
• Involved in rolling the data to client's requirement.

Technologies: SAS Base, SAS Macros, Oracle 8i and Windows 2003 Server.

Confidential

SAS Analyst

Responsibilities:

• Creation of list delivery reports using base SAS and SAS macros.
• Closely worked with the Acquisitions team to generate a list of Consumer details for a particular Marketing Campaign.
• Preparation of reports using SAS.
• Involved in Testing and debugging of code.

Technologies: SAS Base, SAS Macros, SAS Connect, SAS Access.