RESUME

Sayed
Email: sayed76.sas@gmail.com
sayed@madgws.com
Mobile: +91 7798907029
_______________________________________________________________________________

PROFESSIONAL SUMMARY:

 Having 8+ years of experience in SAS in Analysis, Design and Development particularly in the
areas of banking, Insurance & Retail domains.
 Around 2.6 years of experience in Mainframes
 Worked on SAS/Base, SAS/ MACRO,SAS /FORMATS, SAS/Access ,SAS DI studio, IM Studio, OLAP,
Web Report Studio, Stored process, SAS EG, SAS Management Console.
 Worked on various procedures Proc Import, Proc export. Proc datasets, Proc means, Proc sort.
 Possess strong ability to quickly adapt to new applications and platforms.
 Worked on operating systems like windows, UNIX and ZOS.
 Having onsite work experience at various client locations in US, UK, Denmark, Germany,
Sweden & Finland.
 Hands-on experience in Business Requirements Gathering, creating High level & Low level design
documentation.
 Complex coding in SAS for diverse Client Engagements and Deployments.
 Work collaboratively with team members to achieve common goals while maintaining
responsibilities and commitments to achieve client expectations.
 Good team leader with strong analytical and communication skills.

IT WORK EXPERIENCE:

 Working as a senior consultant in Allianz Managed Operational Services., Pune from Feb’14 to
till date.
 Worked as a Senior consultant in Capgemini Consulting India Pvt. Ltd., Mumbai from Dec’06 to
Feb’14.
 Worked as a Senior Software Engineer in US TECHNOLOGY, Chennai from Aug’06 to Dec’06.
 Worked as a Project Engineer in Wipro Technologies, Pune from Nov’04 to Aug’06.
 Worked as a Consultant in US Software, Trivandrum from Jun’04 to Oct’04

NON IT WORK EXPERIENCE:

 Worked as a Lecturer in Immaculate Degree College, Kanchikacherla from Aug’01 to May ’03.

EDUCATION:

 Master of Computer Applications from Osmania University, Hyderabad

CERTIFICATIONS :

 BaseSAS certified Professional

Domain Experience : Banking, Insurance & Retail

Resume of Sayed Page 1 of 7

TECHNICAL SKILLS

Operating Systems : Windows, UNIX, MVS/ESA, OS/390

Environment : BASE SAS, MACROS, SAS/CONNECT, SAS/ACCESS,
SAS/SQL, SASDI,SAS SMC, SAS EG
Languages : SAS, COBOL, JCL, SQL
Databases : DB2
Scheduling tools : Control-M, OPC
Testing Tools : Mercury QC, Clear Case & Clear Quest Tools
Utilities : QMF, SPUFI, Xming, Winscp, File-Aid, Changeman, Endevor
Projects Details:-

Project #1
Title : France FM( Financial Management)
Client : Allianz Insurance, France
Role : Team Lead.
Organization : Allianz Managed Operational Services ,Pune
Environment : Windows and SAS 9.2 Enterprise BI Server.
Tools : SAS BI and SAS DI, Winscp, Putty

France SAS FM :

SAS FM is a comprehensive solution that provides a consistent approach to an organization’s budgeting

and financial management needs.

Roles & Responsibilities:

 Creating DI Jobs using Various Transformations in SAS DI Studio.

 Scheduling the DI Studio Jobs.
 Writing Stored Process using SAS Enterprise Guide.
 Creating STP and adding to Information Delivery Portal .
 Creating and Administering the Users and User groups, services in the SAS Management Console
 Load Facts and Dimensions using IDP portal into FM
 Providing a batch job support.
 Running the Batch Jobs manually if required
 Maintaining the Service Level Agreement (SLA).
 Restarting services when they’re down
 Identifying problem caused by various settings within the solution.
 Interacting with the business users, analyzing and resolving the auto and user support tickets.
 Used SAS Data Integration Studio extensively to develop SAS ETL and summary jobs.
 Extensively worked on SAS stored processes and SAS EG to create various Reports
 Deploying the Stored Process to Web Services.

Resume of Sayed Page 2 of 7

Project #2
Title : ENNOPT (Retail Price Optimization)
Client : S-Group, Finland
Role : Team Lead.
Organization : Capgemini Consulting India Pvt. Ltd.,
Environment : Windows and SAS 9.2 Enterprise BI Server.
Tools : SAS DI , SAS EG, SAS SMC,X-Ming, Winscp, Putty

Retail Price Optimization:

SAS Regular Price Optimization, a regular price schedule that increases revenue. To produce these price
schedules, the back-end data flows use historical factors (data) to create demand models. These demand
models are used to create baseline forecasts and marketing mix effects, such as price or promotion effects. A
solution user can then create plans and optimize or evaluate these plans to create forecasts based on the
demand models and baseline forecasts.

Roles & Responsibilities:

 Creating DI Jobs using Various Transformations in SAS DI Studio.

 Creating and Administering the Users and User groups, services in the SAS Management Console
 Scheduling the DI Studio Jobs.
 Providing a batch job support.
 Maintaining the Service Level Agreement (SLA).
 Restarting services when they’re down
 Confirming that the back-end processes result in working forecasts for all model groups
 Rerunning back-end processes if needed
 Identifying problem caused by various settings within the solution.
 Creating SAS tracks if any bugs in RPO application and updating status to business
 Interacting with the business users, analyzing and resolving the auto and user support tickets.
 Acting as a change Manager for changes created by users
 Used SAS Data Integration Studio extensively to develop SAS ETL and summary jobs.
 Extensively worked on SAS stored processes and SAS EG to create various Reports
 Writing Stored Process using SAS Enterprise Guide.
 Deploying the Stored Process to Web Services.
.
Project #3
Title : Management Reporting
Client : Nordea, Denmark.
Role : Team Member.
Organization : Capgemini Consulting India Pvt. Ltd.,
Environment : Windows and SAS 9.2 Enterprise BI Server.
Tools : SAS DI , SAS EG, SAS IDP, OLAP Cube, SAS IMS,SAS WRS, SAS SMC

Management Reporting: The Management Reporting area maintains all Denmark data monitoring the
performance of each branch which includes profit and loss, direct expenses, Employees details and Nordic KPI’s

Resume of Sayed Page 3 of 7

for Denmark. Applications under this area will maintain all business data of Denmark and Nordic KPI’s data. This
plays a crucial role to business team for understanding the growth of each branch. Monthly data will be
uploaded to Intranet pages through SAS intranet which are called business overview reports where all braches
can view and KPI data sent to head quarters in Sweden.

Responsibilities:

 Primarily responsible for enhancements of the system, analyzing coding and testing the programs and
documentation of final changes delivered.
 Estimations for the requirements.
 Interacting with the business users, analyzing and resolving the auto and user support tickets.
 Maintaining the Service Level Agreement (SLA).
 Calculating KPI’s for braches to set targets
 Analysis the data on region and branch level
 Providing a batch job support.
 Maintaining quality objectives in team by playing the role of PQL for team
 Generate reports either in HTML, PDF or RTF formats according to the client specifications
 Involved in the Development and Enhancements for KPI reports
 Used SAS Data Integration Studio extensively to develop SAS ETL and summary jobs.
 Analyzing the existing development, documented the changes to the new requirements.
 Creating DI Jobs using Various Transformations in SAS DI Studio.
 Writing Stored Process using SAS Enterprise Guide.
 Deploying the Stored Process to Web Services.
 Scheduling the DI Studio Jobs.
 Creating and Administering the Users and User groups, services in the SAS Management Console.

Project #4
Title : CREAM
Client : Nordea, Sweden
Role : Team Member.
Organization : Capgemini Consulting India Pvt. Ltd.
Technologies : SAS EDI Suite, SAS EBI Suite, SAP R/3, UNIX, & Mainframes
Description:

The new CREAM solution is aimed to support in-depth analysis of the customer base and follow up of Nordea’s
customer strategies and concepts and provide income and balance break down on customer segments at a
Nordic level (SE,NO,FI,DK). It is meant to replace the current CSR2 solution based on MS Access & Excel that
has been developed and implemented by FSS in co-ordination with GPC for customer segment reporting for all
4 countries involved. The objective is also to install a solution that future on also supports the Management
reporting area due to possible synergies in the sourcing for Customer Segment Reporting and Management
Reporting.

Due to capacity limitations in current CSR2, data is delivered more at an aggregate level thus restricting the
solution to implement new business requirements. In order to meet such requirements both on vertical level
(read increased granularity) and horizontal level (read new variables and entities) the new CREAM solution
based on SAS Standard Software is proposed. It is supposed to be user friendly, quick & easy to understand for

Resume of Sayed Page 4 of 7

business and reliable software for the above purpose. The solution defined for CREAM is based on the SAS
standard products SAS Enterprise Data Integration Server and SAS Enterprise Business Intelligence Server and
their components.

Responsibilities:

 Acquiring knowledge on Nordea’s business rules and functionality involved for each country and
gathering requirements for CREAM.
 Understanding four countries (SE, NO, FI, DK) source systems & the technical architecture of their data
warehouses and documenting the possible enhancements needed.
 Preparing Functional specifications for the new requirements in sourcing for each country
 Involved in designing the data model for CREAM using SAS n-tier architecture.
 Participating in technical & business discussions with client and providing better solutions.
 Designing ETL flows for data capture from source levels upto the data marts using SAS tools.
Project #5
Title : NSPS
Client : Nordea, Denmark.
Role : Team Member.
Organization : Capgemini Consulting India Pvt. Ltd.,
Technologies : BASE SAS, SAS MCARO, JCL
Description:
The New Shipping Portfolio System (NSPS) is designed to replace the current portfolio management
system, which is almost entirely based on manual input and can only produce portfolio management
quarterly and also the new system can make as much of the data sourcing as possible automatic.

Responsibilities:

 Wrote new SAS programs in order to convert old data to the new data.
 Worked on NSPS project using SAS on Mainframe.
 Creating SAS Programs to pull the data from the DB2.
 Created SAS Data sets from External files.
 Created and maintained SAS Data sets that are extracted from an Oracle Database.
 Pulling the raw data from Mainframes (MVS) using JCL Coding and creating SAS Data sets.
 Extracting, Transforming and loading source data into the SAS environment from multiple sources including major
RDBMS and application system transaction files, third party software packages and spreadsheet applications.
 Created SAS Data sets from text files and Excel Files.
 Extensively worked on Data manipulation, Merging and Concatenation of SAS Data sets in different environments
(MVS, Windows and UNIX).
 Pulling the huge data containing millions of SAS Observations and lot of SAS variables from MVS using
 Extensively worked on Data manipulation, Merging and Concatenation of SAS Data sets.

Project #6
Title : AIS (Ahold Information Systems)
Client : AHOLD, USA.
Role : Team Member.

Resume of Sayed Page 5 of 7

Organization : USTECHNOLOGY, Chennai.
Technologies : JCL, COBOL, VSAM, File-Aid, Control-M, Endeavor.

Description:

Ahold Information Services is a leading provider of quality IT solutions to Ahold’s successful retail
operating companies and foodservice providers located throughout the world. Company’s headquarters are
located in Greenville South Carolina..
Millennium Applications – AIS using GEAC developed millennium applications for Account Receivables,
Fixed assets, Capital Project applications.
General Ledger/Store Inventory and Bank ReconNET applications – The primary purposes of General
Ledger, Store Inventory applications is to serve the Ahold‘s business for Balance accounting, payments,
Adjustments, and the information are updated across the operating companies.
Responsibilities:
 Customer and Vendor support
 Root cause analysis & working with regular requests
 Preparation of test plans.
 Testing and quality implementation.

Project #7

Title : Creditor Insurance

Client : Aviva ,UK
Role : Team Member.
Organization : Wipro Technologies
Technologies : Cobol,JCL ,DB2 & Control-M
Description:
Creditor Insurance is an insurance cover design to mitigate the risk involved for the creditor in case of the
death of the debtor disability /during the period of unemployment. It rests on the premise that legally
creditor has a insurable interest on the debtor’s life. A creditor provides loan to the debtor by getting the
life of the debtor insured for the amount of the loan for the period equal to the tenure of the loan. During
this period it the debtor dies, becomes disable or is unemployed, the benefit is paid to the creditor who
adjusts it against the outstanding loan.
Responsibilities:
 Coding the programs as per client requirements
 Involved in Unit Testing.
 Participated in peer reviews.

Project #8

Project Title : Sunrise 2005

Client : Safeway
Period : Jun’04 – Oct’04
Languages : COBOL, DB2, and JCL
Position : Team Member
Work Location : US Software, Trivandrum.

Description:
Safeway is one of the largest food and drug retailers in North America. At year-end, the company

Resume of Sayed Page 6 of 7

operated 1800 stores in the western, southwestern, Rocky Mountain, and Mid-Atlantic regions of the
United States and in western Canada.
2005 Sunrise is a mandate issued by the Uniform Code Council (UCC) that requires U.S. and Canadian
companies to scan and process at the Point-Of-Sale 8-digit EAN-8 and 13-digit EAN-13 symbols (in
addition to the 12-digit U.P.C) by January 1, 2005

Trainings:
 Attended the Capgemini university program for Banking Stage 1
 Attended the Training on finance for non finance in Capgemini

Award: Project star award from Capgemini in 2009.

Resume of Sayed Page 7 of 7