Duration: 09/2017 – Till Date

Client: Santander Global Technologies 

Projects Description:

As part of GDPR, collecting Accounts and customers information from all instruments to confirm the Bank is GDPR compliance. There are several sub projects involved to complete the process in all divisions.

Responsibilities:

• Involved in code developments for Banking Regulatory projects (Basel II, GDPR)
• Involved in discussion with Business to understand end user requirements.
• Automating the process where and when is possible while code development.
• Creating the code packages and deploy in various environments.
• Documenting the entire process, approvals as per the organization standard
• Testing the technical integration and sense check the results.
• Creating test sets and test cases in HPALM and documenting the results.
• Working on GitHub for development, check in and deployment process.
• Providing ad-hoc reports on data audits.
• SAS/Base, SAS/Macros, SAS/EM, HPALM, GitHub, Windows and Linux

Intelligent Hiring Process Automation Product (Human Resource)

Duration: 01/2016 – 08/2017

Client: TalentSteps GmbH & Co. KG

Projects Description:

Intelligent Hiring Process Automation Product is objected to provide the solution in Hiring Industry with the right profile for the right position. Widely utilized the predictive Analytics algorithm draws on power of AI and Big data to engage the active and passive profiles either for Hiring or upgrading to Hiring level with suggested trainings.

Responsibilities:

• Actively involved in Data design, analysis and cleansing methods
• Involved in designing the word patterns as key words to match the right profiles
• Involved in creating Behavior scores of profiles based on their social network activities
• Involved in report generation with visual analytics feature
• SAS/Base, SAS/Macros, SAS/VA, Windows and Linux

Customer Segmentation (Retail)

Duration: 05/2015 - 12/2015

Client: Sobeys Inc.

Project Description:

Sobeys is the biggest retail chain in Canada. To attain the highest customer satisfaction time to time they involve several data analysis practices. Out of that the most successful one is the segment-based offers to the loyal customers. As part of this different analysis patterns are defined i.e. Targeted Loyal Customer Behavior, RFC analysis and Life Event Analysis.

Responsibilities:

• Evaluating the Customer Purchase behaviour based on the RFV Analysis,
• Performing the Pivotal Product Analysis, Life Event Analysis,
• Promotional Catalogue Analysis based on the targeted loyal customer behaviour.
• SAS/ DI Studio, SAS/Base, SAS/EG, SAS/EM, MS Excel, Windows and Linux

Migration of legacy restatement Engines (Logistics)

Duration: 07/2012-04/2015

Client: Posten Norge

Project Description:

Posten is the Norwegian Postal Department. It uses SAS Platform widely for analysis and reporting in various wings of the department. The platform is well established. It requires the maintenance for day to day operations and for the new developments. As a platform administrator as well, experience SAS developer should maintain the all environments run seamless. Also develop and deploy against the new requirements.

Responsibilities:

• Migration of legacy applications to SAS Grid Platform
• Monitoring the SAS Production, quality and development environments
• Ensuring the data loads are done from OLTP systems without any fail, before the nightly batch start
• Liaison with peers i.e. team from OS and Citrix in major changes and Hotfixes.
• Preparation of Ad hoc reports on demand from the end user
• Working the incident, problem and change tickets aligned to ITIL standards
• Responsible documentation for internal and external audits in regular time period
• Mentoring the new members in to the environments
• SAS/EG, SAS/DI Studio, SAS VA, Stored procedures, SAS/Management Console, IDP, WRS, DB2,
• Teradata, MS-SQL, MS Access and AIX

Client: Reliance Communications

Projects Description:

Reliance is one of the major telecom providers in India. Customer churning the biggest issue ever the telecom Industry is facing. As a competitive and sensitive market, the providers must know the reasons why the churnings are high in frequency and huge in volume. This will lead to success in retain the customers for the log time and predict the business trends.

Responsibilities:

• Predictive analytics in understanding the customer churning
• Finding out the customer satisfaction rate using the sentiment analysis
• Integrated the summary report on customer feedback on given product and package
• SAS/VA, SAS/Graph, SAS/ODS, SQL Server and Window

Client: ANZ Bank

Projects Description:

ANZ Bank Vietnam first time started their MIS reports on Liability management. Part of that developed the applications based on the BRD (Business Requirements document) provided by the Bank.

Also developed Credit Risk Analysis models.

Responsibilities:

• Part of creating Management Information System (MIS), segmented the portfolios
• Involved in execution of a data warehouse model and created reporting dashboards for the same.
• Extensively worked on data cleansing part while creating the data marts from the raw datasets to converting the analysis datasets.
• Worked closely with portfolio managers to understand the requirements, validating the results for its accuracy
• Effectively involved in automating the models, creation of snippets, technical and functional testing
• Widely involved in creating the test cases, rectified with code anomalies
• Timely and fairly documented the entire process and maintained the coding standards for its unanimity
• Make sure every step is complained to the standards, guidelines and bind to regularities and ready for audits.
• SAS/Base, SAS/SQL, SAS/Macro, SAS/EG

Client: ANZ Bank

• Preparation & maintenance of Customer master data
• Make sure to keep the master data is integrated with demographic data and is often up-to-date.
• Projecting the score cards to find the financial health, and repayment history using DPDs
• Working on various KPIs to find out Probability of Default, Value at Risk
• SAS/Base, SAS/SQL, SAS/Macro, SAS/EG, MS-Excel

Client: PAREXEL International Corp.

Phase II, III of clinical trial studies in therapeutic areas Immunology, Microbiology etc.,

• Worked as contributing programmer for the different studies and involved in assigning the programming tasks within the study and reviewing the deliverables done by the programmers.
• Involved in keeping the track of the programming deliverables and estimating the time required for completion of each tasks.
• Interacting with statisticians and external stake holders involved with the project during the project execution.
• Involved in testing and verification of accuracy of raw data using Edit check programming and also performing data extraction of the data coming from external vendors.
• Documentation programming/validation details for final documentation of the project.
• Responsible for creating and maintaining the programming tracking sheet for clinical studies to track the progress/status of SAS Programming tasks.
• Worked closely with Data Managers and Statisticians to resolve programming issues of TLFs and ADaM datasets.
• Performed CRF-Annotation with respect to various study protocol designs.
• Extensive use of Import/Export procedures to convert SAS data into CSV and Excel data and to convert Excel data into SAS data
• Provided extensive SAS programming support to the Data Management department for data cleaning, edit checks and data validation.
• SAS/Base, SAS/SQL, SAS/Macro, SAS/EG, MS-Excel, SAS/ODS, SAS/STAT, SAS/Graph, SAS/Access, SAS/Connect