Analyst (Data Engineer)
AstraZeneca
Total years of experience :10 years, 1 Months
• Led the development and implementation of Power BI solutions for the organization, driving data-informed decision-making and optimizing operational efficiency.
• Collaborated closely with business stakeholders to gather requirements and design effective data models and visualization solutions.
• Developed interactive dashboards and reports using Power BI Desktop, incorporating advanced visualizations, filters, and drill-through functionalities.
• Conducted comprehensive data analysis, identified trends, patterns, and insights, and presented actionable recommendations to support strategic decision-making.
• Implemented robust data security measures to ensure compliance and protect sensitive information.
• Multiple data sources are extracted, transformed, and loaded in Power BI based on the requirement then created the DAX and measures.
• To develop a variety of Conceptual, Logical, and Physical Data Models. Expert in Business Intelligence and Data Visualization tools: Power BI
• Interpret problems and provides solutions to business problems using data analysis, data mining, optimization tools, and predictive techniques and statistics.
• Processing, cleansing, and verifying the integrity of data used for analysis.
• Worked on various visualization techniques in Power bi like Scatter Plots, Histogram and Heat Maps
• Perform in-depth analysis of research information for the purpose of identifying opportunities, developing proposals and recommendations for use by management
• Using in SQL (DML, DDL, and DCL) and SQL joins, aggregate functions, case manipulation functions, character manipulation functions, conversion sequences, view and set operations.
• Track project progress; mitigate risks to budget/time/cost, review budgeting of projects. Preparing the report based on the client and internal stake holder’s requirement using Excel Macro.
• Preparing the report based on the client and internal stake holder’s requirement using Excel Macro.
• Understanding and analysis of legacy data. Visualization of legacy data using Power BI to understand the distribution of LMS data. Preparing the analysis report descriptive, predictive and prescriptive reports.
• Create database objects such as tables, views, stored procedures, Triggers.
• Time series models are used for predicting and forecasting.
• Worked on ABB and United Rentals Data migration project and Report Automation using VBA and SQL. Developed Power BI workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Have a knowledge of Actions, Calculations, Parameters, Background images, Maps,
• Create PowerPoint presentations for Business Analytics & Insights for Domestic and International Markets. Perform and execute data extraction, transformation and loading using ETL tools.
• Ability to understand and debug the advanced query in SQL.
• Ability to write a query with SQL like Joins, Stored procedure, Function, Triggers, Normalization concepts.
Good knowledge in MIS report and Business analyst
Preparing the report based on the client and internal stakeholders requirement using Excel Macro.
I have good knowledge in SAP Application especially BI Module.
Using Excel Vlookup, Hlookup, Pivot Table, if, sum if, sum ifs, count, count ifs, Index, Networking days, AND, OR, chart and etc in MIS reports.
I have good Knowledge reporting in Qlik sense software.
Worked on TVS, DELL, HTC and Banking project management in SQL, MS-Access and MS-Word.
Prepares HOB (Health Of Business) dash board in the DELL and Pan India Open call report.
Good knowledge in Documentation and Billing work.
Based on the client and internal stakeholders requirement preparing ready to the various report.
Prepares special financial reports by collecting, analyzing, and summarizing account information and trends.
Using in MIS Report Vlookp, Hlookup, Pivot Table and chart using.
Maintains customer confidence and protects operations by keeping financial information confidential.Maintains financial security by following internal controls.
Worked on Airtel project management in SQL, MS-Access, MS-Excel, MS-Word.
Computer Application: • Recognized for solving complex business problems and implementing practical solutions under constraints. and for collaborative approach for leading teams, products and processes in diverse • Have good knowledge about database concepts and design • Have good knowledge in Data Gathering, Analysis and Reporting • Proficient in SQL, Power BI, presentation. • Strong communication and interpersonal skills and a committed team player. • Self-motivated, result-oriented and desire for constant learning. • Ability to quickly learn new tools and incorporate into reporting. • Ability to work in a dynamic fast paced atmosphere with sense of urgency to tasks. • Energetic and goal oriented professional with years of experience in SQL Server development and Data Warehousing. • Hands on Experience in designing report solution using Microsoft SQL Server Reporting Services.
Passed Bachelor of Computer Applications from Bharath College Of Science and Management in 2010 with 63% marks.