Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ashish Sharma

Pune

Summary

SAS CI 360 Campaign Developer/ Technology Lead at Infosys limited

Having 8 years of experience as SAS DI and BI Consultant.

· Expert in development of ETL Jobs Using SAS Base/Macro,SAS Management Console, SAS Enterprise Guide.

. Have worked almost 2 year as a SAS CI 360 Campaign Developer.

. Have worked on SAS CI 360, Campaigns like SMS, Email, Mobile Bank, E-Bank, Chatbot.

. Creating Direct Marketing tasks and External task with appropriate creatives to communicate with customers.

· Familiar with Agile & DevOps process and have used JIRA tool for end-to-end process delivery. · Experience with major RDBMS system like Oracle, Microsoft SQL and DB2 Server.

· Experience using Azure DevOps Tool to deliver end to end deployment process.

· Experience with handling large data, performance tuning, complex jobs.

· Developed application using SAS DI, SAS CI360, SAS SQL, SAS STP.

· Used advanced level programming using macros, macro quoting functions, Arrays, merging techniques using data step, Hash tables, parallel processing, pass through facility, SAS auto call macro library etc.

· Used extract, Table loader, Loop, SCD Type 2, Surrogate key generator, look up, SQL join, Data validation, file reader transformation.

· Responsible for trouble shooting jobs, improving performance of job by running in multithreading.

· Worked on Insurance, Banking and Healthcare domain.· Good logical thinking power, quick learner, good communication skills. Individual contributor, open to share knowledge.

· Center of Excellence for SAS technology in internal team.

· Got trained on different SAS Technology as well as trained to juniors and colleagues.

· Produced high-volume orders to effectively meet customer demand.

· Demonstrated consistent hard work and dedication to achieve results and improve operations. · Maximized customer engagement and satisfaction by delivering excellent customer service.

· Promoted safe working environment by implementing regulatory standards, policies and guidelines.

Overview

8
8
years of professional experience
1
1
Certification

Work History

SAS CI 360 Campaign Developer / Technology Lead

Infosys limited
05.2023 - Current

SAS LEAD Developer, 05/2023 - Current Infosys limited

May 2023 - Current

SAS Lead Developer (Technology Lead)

Infosys limited (Pune)

Client : Danske Bank

Role: SAS Consultant/ SAS CI360 Campaign Developer/Azure DevOps

Platform: SAS 9.4, SAS EG 7.1, SAS DI, IBM DB2, SAS CI360, Microsoft SQL, Azure DevOps, GITHub, Openshift, Unix. JIRA Tool

Project Details: Danske Bank is a Danish multinational banking and financial services corporation. Headquartered in Copenhagen, it is the largest bank in Denmark and a major retail bank in the northern European region with over 5 million retail customers. The Danske Bank group operates a number of local banks around the Nordic region (Denmark, Norway, Sweden, and Finland) as well as across Ireland.

Responsibility: While Working AS Lead SAS DI Developer responsible for-

· Develop the campaign based on requirements like email campaign to targeted customer, SMS campaign, Email, Mobile Bank and Customer Feedback campaign.

· Using Azure DevOps tool to manage the Development and end to end deployment process.

· Have worked on Microsoft SQL for all customer data and to maintain the daily execution.

. Driving monthly retrospective scrum call and discuss the overall delivery and challenges with business.

· Validating Models to check if the requirement meets as per business requirement.

· Familiar with advance data modeling concepts like fact and dimension tables, RDBMS concepts etc.

· Familiar with new deployment method by using Azure DevOps updating NFR's/CI-CD Pipeline.

· Responsible for deploying jobs using Airflow, troubleshooting, debugging job in case of any issue occur.

· Have worked on Grafana Tool to create dashboard for SAS and SQL jobs so Team can use the dashboard to check Batch job health.

· Communicate with Onshore team, send daily status of work, in some instances keep note of meetings. Versatile software engineer works well both as part of team and independently. Highly educated with capability to deliver on key project milestones. Seeking to secure an engineering role with internationally astute firm involved in Banking and Financial Services.

Senior Software Engineer/ Team Lead

Accenture
02.2017 - 05.2023
  • Senior Software Engineer, 02/2017 - 05/2023 Accenture, Pune
  • Feb 2017 - May-2023
  • RISK Management/Credit Ratings/Credit Scoring/ Accenture, Pune
  • Client: OP Financial
  • Role: SAS Consultant/Risk Management (Application Development Team Lead) AM Support Platform: SAS 9.4, SAS EG 7.1, SAS DI, IBM DB2, Unix. JIRA Tool
  • Project Details: The company provides a range of financial services like corporate financing, insurance, and online banking in Europe. Project involved in Development and Support both AD/AM related task. I have worked in Risk Management Area (Credit Ratings, Credit Scoring Application).
  • Responsibility: While Working AS Senior SAS Developer responsible for- · Creating Source and target libraries, metadata for libraries, registering metadata for tables using SAS Management console.
  • · Creating user, user group, roles in management console, providing appropriate authentications. · Creating DI jobs using different transformations like table loader, SQL, Loop, Extract, Data Validation, Splitter, SCD type 2, User code written transformation, look up etc.
  • . Driving monthly retrospective scrum call and discuss the overall delivery and challenges with business.
  • · Used check points, used different performance improvement techniques like used indexes, look up transformation, used parallel processing used multi treading option while sorting data, used bulk load option while loading data into oracle data warehouse etc.
  • · Familiar with advance data modeling concepts like fact and dimension tables, RDBMS concepts etc.
  • · Familiar with new deployment method by using JIRA tool updating NFR's/Test Suits/Test cases/Change ticket.
  • · Responsible for deploying jobs using management console, Control-M, troubleshooting, debugging job in case of any issue occur.
  • · Communicate with Onshore team, send daily status of work, in some instances keep note of meetings. As a versatile software engineer works well both as part of team and independently. Highly educated with capability to deliver on key project milestones. Seeking to secure an engineering role with internationally astute firm involved in Banking and Financial Services.

Education

Bachelor of Computer Application - Computer Science

MODI INSTITUTE OF MANAGEMENT & TECHNOLOGY
Kota Rajasthan
2013

Skills

  • BASE SAS/MACRO
  • SAS Enterprise Guide (EG)
  • SAS Data Integration Studio (DIS)
  • SAS CI 360
  • SAS Management Console
  • SQL/PROC SQL
  • JIRA Tool /Agile
  • AWS Cloud
  • DevOps
  • Airflow,
  • Openshift
  • Microsoft SQL Server
  • Power BI, Grafana
  • UNIX
  • MYSQL/Oracle/DB2/Teradata
  • Power BI (Dashboard Reporting)
  • UNIX
  • MYSQL/Oracle/DB2/Teradata

Certification

  • AWS Cloud Practitioner

Timeline

SAS CI 360 Campaign Developer / Technology Lead

Infosys limited
05.2023 - Current

Senior Software Engineer/ Team Lead

Accenture
02.2017 - 05.2023
  • AWS Cloud Practitioner

Bachelor of Computer Application - Computer Science

MODI INSTITUTE OF MANAGEMENT & TECHNOLOGY
Ashish Sharma