Vijay Nila

Dedicated Co-Head in Risk Services with over 19 years of experience in IT. Extensive experience in Data warehousing, Application management, Compliance and Governance, Agile Project Management ,Production Support and resource management.

• SAS Base programming for SAS 9
• SAS Advanced programming for SAS 9
• SAS Data Integration development for SAS 9
• SAS BI Content Development for SAS 9
• SAS Certified Platform Admin for SAS 9

• SAS Visual Analytics 6.4 with hands-on experience
• Hadoop and Big data technologies with hands-on experience
• Data modeling and Dimensional modeling

Stockholm (SWEDEN), 10 months, CREAM, MAXI, decommission projects in Nordea Bank

• Passport Number: F9549195
• Date of Birth: 06/01/79
• Gender: Male
• Nationality: Indian
• Marital Status: Married

, 8, 04/2013 - Present, SAS (Base SAS, SAS Macros), SAS Visual Analytics, SAS EG, SAS Data Integration Studio, Linux, To build a data warehouse that is used for various reporting for Risk Management of pension plans (Equities asset class)., Working as Data warehouse Designer, Understand the data and collate the portfolio, benchmark and security master data, Creating SAS DI Jobs using Various Transformations in SAS DI Studio, Scheduling the DI Studio Jobs, Creating and Administering the Users and User groups, services in the SAS Management Console, Load Facts and Dimensions for portfolio, benchmark and security master, Feasibility study and implementation of reports in SAS Visual Analytics 6.4 including OLAP drill down features , 1, 08/2012 - 03/2013, SAS (Base SAS, SAS Macros), SAS EG, SAS Data Integration Studio, HP-UX, To build a reporting solution that integrates the data and records the medical safety events from various hospitals., Technical lead for the creation and design of data warehouse, reporting system, Design and develop a data warehouse to support the creation of reports to be sold to hospitals, Develop the ETL jobs using SAS Data integration studio, Develop reports using Stored processes, ODS for creation of pdf reports, Extensively worked on SAS stored processes and deploying the Stored Process to Web Services, Providing a batch job support and running batch Jobs manually if required, Creating and Administering the Users and User groups, services in the SAS Management Console Entercard, 5, 05/2011 - 08/2012, Base SAS, SAS Macros, SAS Data Integration Studio, Windows XP, The purpose of the batch interface is to feed data to Falcon with customer, account, card, posted transactions and Payments information that is used in case management for fraud surveillance. There also exist a real time (or near real time) interface delivering authorizations data to Falcon. The data for the batch interface is read from the card management systems from Prime2 and Prime3. Files are delivered when new information is available, from several times a day to once a day. The interface is to deliver data for Sweden, Finland and Norway/Denmark. Nordea Bank, 3, 05/2009 - 05/2011, SAS (Base SAS, SAS Macros), SAS DI Studio, SAS Web Report studio, SAS Information map studio, SAS Enterprise guide, HP-UX, To build a data warehouse on customer segmentation, in which customer information was loading in CSR2 datamart using ETL jobs. In CSR2 datamart aggregated data is stored to customer segmentation reporting. Entire application is built on SAS EDIS & EBIS to store entire information in SAS Environment-traditional datasets on UNIX platform. ETL jobs running in batch process every month to load the detailed levels of STAGE data into CREAM database in specified formats with mandatory checks on records and Big file is created. Big file contains history of three years customer information., Requirements gathering and customer status meetings, Developing and modifying ETL Process flows that is extracting data from different sources and loading data in SAS data sets (DM and DB) according to the Business Requirements using change management procedure, Development of infomaps using SAS Information map studio on customer requirement for reporting purpose, Deploying and scheduling jobs in TWS scheduler, Exporting and importing SAS objects in test and production environment, Creating and Administering the Users and User groups, services in the SAS Management Console Nordea Bank, 6, 01/2007 - 05/2009, SAS (Base SAS, SAS Macros), COBOL, JCL, DB2, SAS/Intranet, Mainframe(Z/OS), Unix, The main purpose of Audit Trial is to document the transformation and aggregation processes in the accounting and reporting systems. This application has two parts, one to store data in DB2 and the other one is the Intranet part. The Intranet part is for the business users (FSS) to check the status of the deliveries. This has got interfaces with most of the systems. The system, whichever delivers data, has to pass through the Audit Trial application which in turn stores data in the DB2 as Metadata and pointers. Actual data will be stored in the SAS datasets and the Flat files. MAXI is data warehouse system in Denmark., Analyzing and interacting with Clients for requirements, Developing and modifying SAS programs & batch jobs as per requirements, Testing and Review of the SAS programs and batch jobs, Peer reviews, Preparation of Test cases and executing the Test cases, Estimations for the requirements, Given Oncall support and maintaining the Service Level Agreement (SLA) Beverly Enterprises, USA, 8, 07/2005 - 01/2007, Base SAS, SAS Macros, COBOL, JCL, DB2, Mainframe(Z/OS), The Medicaid government insurance has a lengthy pre-defined process that must be completed in advance prior to patient receiving any of the Medicaid benefits. Facilities for Beverly healthcare have a very manual business process using existing admissions programs to detect which patients need to start applying Medicaid coverage. The manual process is paper and time intensive. The new solution helped to assist the collection process as it relates to filing for Medicaid benefits that include filing initial, re-evaluation, certification, re-determination and conversion application. The developed solution involves automating the collection of needed information (Residential Information Profile), Medicaid, automating the “spend-down” calculation and automation the notification that a Medicaid application needed., Analyzing and interacting with Client for requirements, Developing and modifying applications as per requirements, Testing and Review of the programs, Preparation of Test cases and executing the Test cases as per the requirements

I hereby declare that all the information above mentioned are true to the best of my knowledge.

• Received multiple awards like Valuable Contribution (VCA), Project Star, Extra miler award in different organization.