Senior SAS Consultant - AxionConnect Infosolutions Pvt Limited (2017 September 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.• Solid experience in analytical programming (SAS and SQL), Data Cleansing, ETL and Data Warehousing with large datasets.• Translating user requirements and functional specifications into technical designs and implementing SAS ETL code for Data warehouse build.• Experience in creating data marts using ETL's (DI Jobs) i.e. Policy mart, Claim mart, IBNR, 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 company level performance report to analyze business growth.• 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.• Doing the Root cause of any failures and review the same.• 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.• Use of Putty to execute SAS codes and monitoring work space.• Appreciated with ‘Certificate of Excellence’ from Client.

Executed various different client projects and involved in phases of data Analysis. Interacted with Offshore clients on projects.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.

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.• Got Partnership and Quarterly Awards.

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.• Appreciated with ‘spot award’ and ‘Excellence in Project Execution’.