Vikram Pawar Email and Phone Number
Vikram Pawar work email
- Valid
- Valid
Vikram Pawar personal email
With 9 years of dedicated experience, I am a seasoned Senior Software Engineer and Team Lead proficient in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications. My expertise spans various segments of the project life cycle, focusing on domains such as e-commerce, healthcare, supply-chain, and telecom.My core strengths lie in Microsoft SQL Server, SQL Server Integration (SSIS), SSRS, SSAS, and Power BI. I bring a wealth of knowledge in core SSIS concepts, including the intricacies of Slowly Changing Dimensions and incremental load processes. My proficiency extends to the design and development of SSIS packages utilizing transformations like SCD, Multicast, Merge join, Merge Lookup, Conditional Split, Derived column, Sort, Union, and Data Conversion Transformation. I am adept at handling diverse sources and targets, ranging from SQL databases to CSV, flat files, and text formats.In the realm of RDBMS, I showcase excellent skills in constructing SQL objects – creating Tables, Stored Procedures, Views, Indexes, Triggers, and User Defined Functions. My experience includes comprehensive knowledge of tuning T-SQL queries (DDL and DML) to enhance database performance and availability.I have a proven track record in creating jobs, SQL Mail, Alerts, and scheduling SSIS Packages using SQL Server Agent. My proficiency extends to Microsoft Power BI, where I excel in creating MDX, DAX, Merge, Append queries, and developing reports with visualizations like Bar charts, matrices, slicers tables, and more. Additionally, I have hands-on experience in crafting dashboards using Tableau.My skills are grounded in industry-standard methodologies such as Agile Scrum and SDLC (Software Development Life Cycle). As a well-organized, goal-oriented, and highly motivated team member, I contribute effectively to collaborative efforts. I possess excellent analytical, troubleshooting, and problem-solving skills, making me a valuable asset in dynamic and challenging environments.Throughout my professional journey, I have consistently demonstrated a commitment to excellence and a passion for staying at the forefront of emerging technologies. I am eager to bring my extensive skill set and proactive mindset to contribute to innovative projects and drive success in future endeavors.
Hexaware Technologies
View- Website:
- hexaware.com
- Employees:
- 15868
-
System AnalystHexaware Technologies Feb 2022 - PresentNavi Mumbai, Maharashtra, IndiaBaloise -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.
-
Senior Software EngineerUst Blueconch Technologies Aug 2019 - Feb 2022Pune Area, IndiaProject: 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. -
Analyst- Knowledge ServicesInfosys Mar 2018 - Jul 2019Pune, Maharashtra, IndiaProject: 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. -
Analyst - Knowlegde ServicesInfosys Mar 2018 - Feb 2019Pune, Maharashtra, India
-
Associate Software EngineerFigmd, Inc. Nov 2017 - Mar 2018Pune Area, IndiaClient : 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 -
Junior Software EngineerFigmd, Inc. May 2015 - Oct 2017Pune Area, IndiaProject #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
Vikram Pawar Skills
Vikram Pawar Education Details
-
First Class
Frequently Asked Questions about Vikram Pawar
What company does Vikram Pawar work for?
Vikram Pawar works for Hexaware Technologies
What is Vikram Pawar's role at the current company?
Vikram Pawar's current role is Innovative Senior Software Developer and Team Leader Transforming Data: Mastery in BI | MSBI | SQL | ETL | SSIS | PowerBI | Data Analytics Unleashed!.
What is Vikram Pawar's email address?
Vikram Pawar's email address is vi****@****t.co.in
What schools did Vikram Pawar attend?
Vikram Pawar attended Savitribai Phule Pune University.
What are some of Vikram Pawar's interests?
Vikram Pawar has interest in Listening To Music, Travelling, Trekking, Playing Cricket, Writing Poems.
What skills is Vikram Pawar known for?
Vikram Pawar has skills like Mysql, Windows, Databases, Programming, Management, Microsoft Excel, Leadership, Teamwork, Sql, Adaptive Learning, Positive Behavior Support, Visual Communication.
Who are Vikram Pawar's colleagues?
Vikram Pawar's colleagues are Rohini Tamilarasan, Ganesh J, Hanuman Adabala, Shyam P, Arun Kumar, Bharathi Kannan Kumarasamy, Balaji Bala.
Not the Vikram Pawar you were looking for?
-
Vikram Pawar
Pune -
-
2gmail.com, symboinsurance.com -
Vikram Pawar
Mumbai -
Vikram Pawar
Pune
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial