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.

TECHNICAL SKILLS:

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 EXPERIENCE:

Confidential

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

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 Confidential .
• 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

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

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

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