M R DIVYA TEJ
Bangalore
Summary
To be associated with an esteemed organization that provides me with an opportunity to prove my technical skills, improve my ken with latest trends and to be a part of the team that works dynamically towards the growth and development of the organization.
Having 10 Years of IT experience in SAS Programming and Oracle SQL. Proficient in BASE SAS and SAS/MACRO. Proficient in using SAS EG and SAS DI Studio to write SAS code and developed ETL’s. Worked SAS ADMIN with minimal experience like server health checks, creating new SAS users, creating and deploying flow and scheduling jobs in LSF. Experience in analyzing, developing and implementing of various applications using SAS for Retail Domains Proficiency in Proc SQL to manipulate data and SAS programming. Good programming experience with various SAS PROCEDURES, SAS FUNCTIONS, Data manipulation. Generated different weekly, monthly & ad-hoc reports in HTML, PDF using SAS/ODS. Experience in Control -M Scheduler for scheduling & executing the ETL jobs. Successfully handled responsibilities for extracting data from external sources, data cleaning and data validation. Excellent understanding of data management principles such as joining data sets, indexing and sub setting. Exposed to analyze the requirements documents and develop the code accordingly.
Overview
10
10
years of professional experience
Work History
Lead Software Engineer
Societe Generale Global Solution Center
Bengaluru
07.2024 - Current
- Analysing the SAS Programs and prepare document about the logics implemented
- Providing SAS Access via automated process using SAS ODAS portal
- Monitoring SAS ETL’s related to Risk in Control-M scheduler
- Creating SAS VA reports related to SAS AML
- Implementing AML scenarios as per business requirements
- Generating adhoc reports upon AML reports as per requirements
- Project Name: GATS US & SAS ODAS
- Client: Societe Genrale US
- Team Size: 5
- Technologies: SAS EG, SAS Studio, SAS AML, SAS VA, Python
Development Lead
Standard Chartered Bank
Bengaluru
08.2023 - Current
- Analysing the SAS Programs and prepare document about the logics implemented
- Analyse Equivalent steps that can be implemented in DATAIKU
- Migrating all the existing SAS programs to DATAIKU flows and schedule in scheduler
- Worked on the Ad-hoc requests arise by the clients and submitted on time
- Attending the trainings on DATAIKU AI tool to use various recipes in spark, python, scala
- Understanding the wealth products that we are dealing with
- Project Name: M&M Wealth Management
- Client: Standard Chartered Bank
- Team Size: 15
- Technologies: SAS EG, DATAIKU, Python, Network O/S: MS- Windows 10
Senior Software Engineer
WIPRO Technologies
Bengaluru
08.2021 - 06.2023
- Generating reports on regular basis based on the time intervals derived
- Involved in creation of multiple reports that’s runs on Daily, Weekly and Quarterly
- Responsible for extract, transfer and loading huge amount of data to various teams across the project
- Involved in code changes and implementation the same after performing analysis and documented the changes
- Automated all these reports into LSF based on the trigger files that gets created from upstream batches
- Worked on the Adhoc requests arise by the clients and submitted on time
- Worked as SAS Admin partially which covers creation of users and scheduling the job in LSF
- Project Name: RSA Reporting Team
- Client: RSA(Royal Sun Alliance), UK
- Team Size: 2
- Technologies: Databases: DB2, SQL SERVER, Tools: PowerPoint, Internet Applications, SAS products: Base SAS, Macros, SAS/ODS, SAS/ACCESS, IBL FLOW MANAGER(LSF), SAS Grid, Network O/S: MS- Windows 7, Windows-8
Software Development Engineer-1
TESCO HSC
Bengaluru
03.2019 - 08.2021
- Debugging the issues in real time production environment and resolving the issues in a quick time
- Involved in resolving ETL failures and creating Disaster recovery scripts for the failures
- Responsible for extract, transfer and loading huge amount of data to various teams across the project
- Worked on the Ad-hoc requests arise by the clients and submitted on time
- Project Name: Enterprise Data Services(EDS)
- Client: Tesco Bank, UK
- Team Size: 3
- Technologies: Databases: Oracle, Tools: PowerPoint, Internet Applications, SAS products: Base SAS, Macros, SAS/ODS, SAS/ACCESS, SAS DI, IBL FLOW MANAGER(LSF), Network O/S: MS- Windows 7, UNIX
Deputy Manager
Vodafone India Services Pvt Ltd
Pune
09.2018 - 03.2019
- Played a vital role in the transmission process, off shoring the reports from Italy
- Documenting all the process in order to use in the future production
- Giving an accurate description and project training to the colleagues
- Simplifying the SAS code which has already defined by using advanced methods
- Transferring the extraction through SAS from DWH
- Played an important role in change implementation which we get via change requests
- Creating separate libraries for daily updating datasets for the future references
- Transferred a major part of the excel work into SAS environment
- Project Name: Business Intelligence
- Client: Vodafone
- Environment: SAS 9.4, Windows 2007
- Technologies: Databases: Oracle, Tools: PowerPoint, Internet Applications, SAS products: Base SAS, Macros, SAS/ODS, SAS/ACCESS, Network O/S: MS- Windows 7, Windows XP
Application Development Senior Analyst
Accenture Solutions Pvt Ltd
Bangalore
08.2015 - 09.2018
- SHELL-BASKIN IT A SAS based project with Royal Dutch Shell group which deals with handling the customer data
- Works on the ETL and database storage technology involving wide range of tools such as SAS DI, SAS EG etc
- We deal with multiple ETL’S which will run on daily basis which will be helpful in analyzing the data and create campaigns on top that by our third party vendors
- We also Deal with Real Time application called OMS(OFFER MANAGEMENT SYSTEM), currently implemented only in CANADA
- All these ETL’S are related to customer transactional data and few ETL’s are related to reporting which will be useful for Business
- Project Name: Shell Baskin IT
- Client: ROYAL DUTCH SHELL
- Team Size: 10
- Technologies: Databases: SQL Server, Tools: PowerPoint, Internet Applications, SAS products: Base SAS, Macros, SAS/ODS, SAS/ACCESS, Network O/S: MS- Windows 7, Windows XP
Education
Bachelor of Technology (B.Tech) - COMPUTER SCIENCE & ENGINEERING
JNTU University
Anantapur01.2012
Intermediate - M.P.C.
NARAYANA Junior College
Kadapa01.2008
Secondary School Certificate -
Keshava reddy school
Nandyal01.2006
Skills
- Windows 7
- SAS
- SQL
- Oracle
- MS SQL(SQL SERVER)
- Statistical Analysis System (SAS) Base
- SAS DI
- Macros
- SAS Enterprise Guide
- SAS WRS
- SAS OLAP CUBES
- SAS SMC
- PLSQL
- SCALA
- HIVE
- SQOOP
- HP Service manager 9
- Servicenow
- Control-M
- Windows task scheduler
- Autosys
- LSF
Disclaimer
I hereby declare that the above written particulars are true to the best of my knowledge and belief.
Projects
GATS US & SAS ODAS, Societe Generale US, 5, Lead Software Engineer, 07/01/24 to Present, SAS EG, SAS Studio, SAS AML, SAS VA, Python M&M Wealth Management, Standard Chartered Bank, 15, Development Lead, 08/01/23 to Present, SAS EG, DATAIKU, Python RSA Reporting Team, RSA (Royal Sun Alliance), UK, 2, Senior SAS Developer, 08/01/21 to 06/30/23, DB2, SQL SERVER, PowerPoint, Internet Applications, Base SAS, Macros, SAS/ODS, SAS/ACCESS, IBL FLOW MANAGER (LSF), SAS Grid Enterprise Data Services (EDS), Tesco Bank, UK, 3, SAS Analyst, 03/01/19 to 08/31/21, Oracle, PowerPoint, Internet Applications, Base SAS, Macros, SAS/ODS, SAS/ACCESS, SAS DI, IBL FLOW MANAGER (LSF) Business Intelligence, Vodafone, Deputy Manager, 09/01/18 to 03/31/19, Oracle, PowerPoint, Internet Applications, Base SAS, Macros, SAS/ODS, SAS/ACCESS Shell Baskin IT, Royal Dutch Shell, 10, SAS Support Specialist, 08/01/15 to 09/30/18, SQL Server, PowerPoint, Internet Applications, Base SAS, Macros, SAS/ODS, SAS/ACCESS Baskin Campaign Management System, Royal Dutch Shell, 10, SAS Support Specialist, 08/01/15 to 09/30/18
Personal Information
- Pan Number: BQEPM6491E
- Passport Number: K2564272
- Date of Birth: 11/08/91
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Timeline
Lead Software Engineer
Societe Generale Global Solution Center
07.2024 - Current
Development Lead
Standard Chartered Bank
08.2023 - Current
Senior Software Engineer
WIPRO Technologies
08.2021 - 06.2023
Software Development Engineer-1
TESCO HSC
03.2019 - 08.2021
Deputy Manager
Vodafone India Services Pvt Ltd
09.2018 - 03.2019
Application Development Senior Analyst
Accenture Solutions Pvt Ltd
08.2015 - 09.2018
Bachelor of Technology (B.Tech) - COMPUTER SCIENCE & ENGINEERING
JNTU University
Intermediate - M.P.C.
NARAYANA Junior College
Secondary School Certificate -
Keshava reddy school