Vikram Pawar Email & Phone Number

Navi Mumbai, Maharashtra, India

Baloise -The project involves migration of insurance data to enhances the company’s efficiency, effectiveness and profitability whole delivering better services and value to user. Talbot - Talbot operates within the Lloyd's Insurance Market through Syndicate 1183 which writes a diversified portfolio and develops tailored insurance solutions that address clients' evolving and often unique needs like Financial Calculations, various quarterly, monthly and ad-hoc requests.Planned and analyzed the business requirements for migration along with Business analyst.Decided the database structure and normalization using MSSQL and SSIS packages.Identified and corrected inconsistency in data to ensure data migrated accurately.From the mapping created by BA, completed the transformation of data usingMSSQL, SSIS, SSRS and SSAS.Tested the migrated data and ensured the business requirements was achieved.Reconciled the migrated data and reported the same in recon report using SSRS.Automated the process using utilities, SQL server agent and deployment pipelines.Transformed and loaded ad-hoc, monthly and quarterly requirements in Power BI bycreating MDX, DAX, Merge, append queries and developed the reports and drillthrough reports using visualization like Bar chart, matrix, slicers tables etc.Knowledge of creating calculated members in data model using MDX and definedthe row level security.Worked on all types of transformations and scheduled Automatic refresh andscheduling refresh in power bi service.Developed analysis reports and visualization using DAX functions like table function,aggregation function and iteration functions.

Pune Area, India

Project: Personalization Services - CertonaClient: KIBODuration: August 2019 – Till DateDomain: E-CommerceSoftware: Operating System : Windows 10Database: MSSQL Server 2018Defect tracking Tool: JIRATools: SQL Server Integration Services 2016, Microsoft Power BI DesktopLanguages: T-SQLProject Synopsis: KIBO is a part of e-commerce domain whose Personalization powered by Certona has vision of delivering end to end personalization across every customer touchpoint, which is the best approach to modern and Omni channel commerce.Responsibilities: • Took internal and onsite training virtually for understanding e-commerce domain and project work.• Creating stored procedures and functions for importing feed data.• Managing metadata using SQL queries.• Created SSIS packages to import feed/raw data into the database.• Developed and updated technical documentation.• Conducted unit testing and troubleshooting.• Translated business needs to technical specifications.• Designed, built and deployed BI solutions.• Extracted JIRA API data, transformed and loaded in PowerBI reports.• Created visualizations and reports for requested projects.• Developed and executed database queries and conduct analyses.• Abilities to take initiative and be innovative.• Analytical mind with a problem-solving aptitude.• Coordinated with Onsite Team member and monitor incidents raised by Clients.• Participated in different scrum ceremonies like weekly status meeting, Daily standup meeting, Sprint grooming, Sprint planning, Sprint Retrospective meetings.Highlights: Ability to lead the team as associate lead and work across onsite team smoothly virtually. Simultaneously working on several projects and ensuring quality product delivery with excellent time management.

Pune, Maharashtra, India

Project: Store Performance ReportClient: TelstraDuration: March 2018 – July 2019Domain: TelecomSoftware: Operating System : Windows 10Database: MSSQL Server 2016Defect tracking Tool: JIRATools: SQL Server Integration Services 2012, Alteryx, TableauLanguages: T-SQLProject Synopsis:Scope of the project includes developing store performance dashboard using Tableau, SQL database and SSIS for largest Australian Telecom provider for their Supply chain Analytics.Responsibility:• Engaged with Onsite Team for preparing forecast and scenario modeling for business decisions, developing management reports, variance analysis and converting financial data into database which leads in tableau.• Managing end to end process execution which includes Client Interaction, Understanding Current Framework, Designing and presenting the wireframe for new dashboard along with Tableau team for the dashboard development.• Involved in validation, presenting and taking through the final dashboard to end users.• Designed, Implemented and tested insightful reports using Tableau.• Created several reports like Line chart, Pie chart, Table Chart.• Prepared of weekly and monthly status reports.• Ensure the data quality and integrity in databases• Take regular database backup Crafting table indexes in order to help in improving the database’s performance.• Automating existing manual SQL process using SSIS for reducing FTE efforts and manual intervention.• Creating database prompts for computerization, e.g., instant email notifications etc.• Coordinated with Onsite Team member and monitor incidents raised by Clients.• Participated in different scrum ceremonies like weekly status meeting, Daily standup meeting, Sprint grooming, Sprint planning, Sprint Retrospective meetings.Highlights: Ability to work across teams, cater to project needs and successfully delivering the bug free project leads to get new assignment from existing client.

Pune, Maharashtra, India

Pune Area, India

Client : American Society of Clinical Oncology (ASCO) Project: Quality Oncology Practice Initiative (QOPI)Project Overview • Registries built for Practices in USA are used to fetch clinical data from their EHR. This data is then stored and various measure checks are carried out. Once the data quality is confirmed reports are generated based on this data. These reports are used by the Providers for PQRS submission, from which they are granted incentives based on their performance which is delivered through those reports.Responsibilities • Involved in the Analyzing requirements of the project. • Participation in preparing Design document • Designed, Implemented and tested BI reports using SSRS. • Created several reports such as drill down reports, parameterized reports, sub reports and Chart reports using SQL Server Reporting Services. • Written and maintained multiple stored procedures which were used by the reports to get the data Environment SQL Server 2012, T-SQL,SQL Server Reporting Services 2012

Pune Area, India

Project #1Client : IRISProject: AAO (American Academy of ophthalmology)Pune, IndiaSoftware Engineer (May 2015 - July 2017)Project OverviewAmerican Academy of ophthalmology is part of Health Care corporate strategy, it requires the capability of establishing relationships with providers via offering data accumulation, reporting. PDIT Development is an application majorly involves Extract, Transform and Load data. It fetches data from SQL database or source flat files perform operation and load data into database or generate output files. Also generate various report depends on requirement.Responsibilities • Understanding basic work flow of ETL process and used SSIS to develop jobs for extracting, transforming, loading data and generate output files into flat files. • Written SQL scripts and procedures for read and write operations • Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views etc. for the Live database • Designed, Implemented and tested BI Dashboards using SSRS. • Responsible for timely and quality deliverable. • Participation in preparing Design document • Incident and Defect fixing occurred during development phaseEnvironmentSQL Server 2012, T-SQL, SQL Server Integration Services 2012,SQL Server Reporting Services 2012