Apr 2022 – Jun 2024 · 2 yrs 2 mos · Bengaluru, Karnataka, India · Remote

Jun 2021 – Apr 2022 · 10 mos

• Handing end to end daily and monthly process from offshore team.
• Responsible for understanding the business specs, preparing SQL scripts, and creating ETL SSIS Packages for loading these data into data warehouse.
• Developing customized Power Bi reports and Dashboards based on the client requirements.
• Creating jobs for scheduling the SSIS packages.
• Contributor to Visual Studio 2017 Azure DevOps server (TFS) for defect prevention and source control and managing the Tasks Tickets.
• Addressing and supporting real time users of the application with the help of with their incidents and tasks that are raised with respect to applications

Aug 2019 – Jun 2021 · 1 yr 10 mos

• My first project after joining Accenture was OTPP (Ontario Teachers’ Pension Plan) which was a Canadian based FS insurance Project.
• Responsibilities
• My role in this team as a Primary Power Bi developer was to develop detailed Power Bi reports as per the business requirements and also to create dynamic Oracle PL\SQL procedures and packages using Oracle as a data source to aggregate the data that is required for creating the dataset for the power Bi report.

Sep 2018 – Jul 2019 · 10 mos · Chennai, Tamil Nadu, India

• ABCO India Private Limited (An Optum Company) is a product-based company which provides many SAS products for US health care domain. They provide several analytics products as well as workflow products.
• CMR: Crimson Medical Referrals in short CMR is one of the workflow products that offers sending medical referrals from PCP (primary care physician) to any specialist in any hospital in US.
• HP: Health post in short HP is also a workflow product that provides services to customers to book appointments to the providers/practitioners.
• iRound: iRound is also another workflow product which provides a service to collect feedback from the patients regarding the treatment and the hospitality they have provided.
• Responsibilities:
• Develop and Provide integration support from member EHR to CMR.
• Provided tier 2 support in case of any issue in the product workflow.
• Upload, maintain and cleanup the current member data provided by the member on a regular basis by analyzing the failed referrals and updating the member accordingly.

Nov 2014 – Aug 2018 · 3 yrs 9 mos · Chennai Area, India

• Company: Aegis Info Business Solutions.
• Aegis as a vendor for Microsoft has their offshore facility at Chennai which operates on complete MSBI domain.
• Profile :
• Joined as a Software trainee and initially was allocated to production support operations were I was supposed to monitor several SSIS Packages and SSAS jobs as a daily process.
• It also includes bug fixing in case of any failures. Later extended support for performing maintenance tasks of DB's and servers such as performing server and services restarts, DB and cubes backup and restores, etc. T
• Learned COSMOS and allocated as a SME of COSMOS tasks which newly emerged from Microsoft were we perform several ETL operations from COSMOS to SQLSERVER on a daily basis.
• Later, moved to full time development were my roles and responsibilities are:
• Responsible for Coding, Creating various SSIS packages, performing several ETL operations between COSMOS, OLAP Cubes and SQL Server.
• Also worked on Power BI application which was latest reporting tool. Migrated several reports to Power BI by replicating it from excel reports.
• Technologies/ Application Worked:
• MS SQL SERVER, COSMOS, SSIS, SSAS, Power BI, Microsoft Excel Power Pivots.
• My Last Project : Worked as primary code developer on Cosmos for "Bing Experiences" Team in Microsoft for "Bing" Search Engine Analytics