Experience

AxionConnect Infosolutions Pvt Ltd

• India
• Information Technology & Services
• 1 - 100 Employee

• SAS Consultant

  • Feb 2019 - Present

  SAS Consultant - AxionConnect Infosolutions Pvt Limited (2019 February to Present) Responsible for the design, documentation, business report creation and implementation of ETL processes in SAS DI Studio for ICICI Lombard General Insurance Clients/User. • Experience in analytical programming (SAS and SQL), Data Cleansing, ETL and Data Warehousing with large datasets. • Experience in creating data marts using ETL's (DI Jobs) i.e. Policy mart, Re-insurance etc. • Creating Loss ratio report for Motor, Health, Travel and also checking for trends against loss at Vertical / Sub-Vertical / Product level. • Creating internal level report to check performance within teams which is circulated on daily basis. • Make changes into existing SAS DI Jobs as per the business requirements. • To get involved in technical enhancements and new requirement as and when required. • Being this a maintenance project a lot of inter communication is required across many different teams to get the issue resolved. Full business flow understanding and roles of layers of teams is understood and well communicated in case of any issues. • Involved in several Code re-engineering, automations and job schedules. • Registering Metadata for Tables/Libraries etc. Scheduling or Batch running of SAS DI Jobs through SAS SMC. • Process Flow Manager (LSF) monitoring and Production Support Activities. • Monitoring LSF Flow's daily for DI Jobs. Show less



Ugam

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Sr. Data Analyst

  • Jul 2018 - Jan 2019

  I was responsible for exploratory data analysis using software’s like IBM SPSS, Dimension and Excel. Work typically included: • Working on ad-hoc reports from the clients. • Attending client calls for project briefs and clarifications. • Requirement Analysis and gathering problem definition. • Preparing reports, Data manipulation and Data Validation. • Data Merging, Data Sub setting, Importing and Exporting data files. • Exporting data (SAS, verbatim CSV & excel format), Preparing reports and looking into the data queries as per client needs. Show less



Datamatics

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data Analyst

  • May 2016 - Jul 2018

  I was responsible for exploratory data analysis using software’s like IBM SPSS, Dimension and Excel.Work typically included:• Validating analysis specification, checking data requirements and interacting with clients on analysis plans.• Worked with various business clients in the process of understanding various work cultures.• Using statistical tools like SAS, SPSS and office tools like MS-excel for performing the analysis and reporting.• Performing data manipulation like Handling Missing Values, data editing, Reading Raw Data files, merging data sets, creating Data Structures, handling Programming Errors, Accessing & Managing Data.• Business Intelligence in SAS Proc Reporting, table generation and regulatory reporting Show less

• Trainee

  • May 2015 - Apr 2016

  Trained on concepts and procedures of Survey Analytics; understand the client demands and procedures.Work typically included:• Primary responsibilities included handling projects, processing several analysis in SPSS, Dimension and excel with minimal support.• Data processing, Table generation and Data merging in SPSS and Dimension.• Convert data from text and excel files into SAS files for analysis and metrics reporting.