SQL server, power bi, Advanced excel
Ankita Jhamb
Senior Data Analyst
Noida
Summary
I'm a Data Analyst & Business Intelligence Developer with over seven plus years of experience working in the tech industry, providing valuable expertise to the organizations. I've worked with various types of projects and have mastered multiple Data Visualization tools like Power BI, Data Preparation tools like languages like SQL and MS EXCEL. Worked to support consulting projects in SQL Server and Microsoft Business Intelligence tool reporting services - POWER BI. Seeking a challenging role in the field of Business Visualization as Power BI developer, where my IT expertise, technical, logical, and Analytical skills can help in the mutual growth and success of the Organization.
Overview
8
8
years of professional experience
7
7
years of post-secondary education
1
1
Language
Work History
Senior Data Analyst
Fifthnote
03.2021 - Current
- Analyze business requirements into technical requirements for report visualizations, review technical specifications derived from business requirements.
- Create and review/ approve technical solutions on change requests and assignments within a project while maintaining a level of high quality for the end user experience.
- Deploy and Validate BI solutions ensuring changes follow appropriate Change and Release Management processes.
- Provide consultancy to business units on recommendations on the best BI solution to solve their business needs.
- Work with technical peers and architects to implement new standards, new technology, and tactical solutions driving the business strategy forward.
- Lead projects from discovery to delivery, driving initiatives that impact the larger team of engineers, Engineering Managers, and Product Managers.
- Perform team reviews and mentor less experienced BI Analysts on solution approaches and ensuring conformity to standards, quality, and performance.
- Drive product roadmap and initiatives and participate in technical design for new or existing reports/ dashboards. Lead/ Supervise other Power BI Developers.
- Build a diverse team while encouraging a collaborative, inclusive, and transparent environment.
Data Analyst
Nextgen Technologies
09.2019 - 03.2021
- Develop reporting for business consumption using a variety of Power BI techniques.
- Perform data analytics and generate insights as per business requirements.
- Attend client meetings for understanding the business requirement to implement it in efficient manner.
- Use statistical techniques for hypothesis testing to validate data and interpretations.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Participated in requirements meetings to understand business needs.
- Developed tables, views and materialized views using SQL.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Documented effective and replicable methods for extracting data and organizing data sources.
Business Analyst
Slide team Ltd
Chandigarh
12.2017 - 08.2019
- Building end to end solutions to automate the processes and report generation
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Drafted reports on company financial metrics to assess successes and account for deficiencies.
- Assessed business requirements to forecast annual budgetary operational costs.
- Performed competitor bench-marking analysis to identify manufacturing savings opportunities and potential product enhancements.
- Working for continuous improvement, optimizing processesruntime,reducingoverallsystemloadand fine tuning the dashboards
Reporting Data Analyst
Scintillations And Research Analytics, Mohali
02.2015 - 10.2017
- Creating new reports/dashboards Fixing the bugs in the production environment
- Managingthedaily Database data upload jobs and check with Date team for requirements.
- Continuously assessed current reporting techniques and developed improvements to boost accuracy.
- Enhanced data integrity by applying meticulous attention to detail when reviewing and analyzing data maintenance processes.
- Assessed sales reports, identified business standing and reported to executives.
- Prepared monthly ad hoc reporting in alignment with client needs.
- Maintained ongoing schedule and documentation for all reporting procedures.
- Used pivot tables to update AR aging reports on weekly basis.
- Coordinated monthly meetings to discuss resolutions for exception reporting.
- Served as subject matter expert on call center performance metrics analysis, design, development.
Education
M.tech - Electronics And Communication
AMITY UNIVERSITY
05.2011 - 04.2014
B.TECH - Electrical, Electronics And Communications Engineering
Kurukshetra University
Karnal 06.2006 - 07.2010
Skills
Developed Model Monitoring Dashboard based on the salesAnalyze of the segment Movementand other insight and
Business Insight Dashboards
Power Bi Usage Dashboard For Health care InsuranceVisualization tool Power BILeverage theSQL skills and developed thePL/SQL packagesPower BI Monitoring dashboards Charge Capture andHL7 AnalysisDeveloped dashboard using Power BI desktop capabilities andFully automatedthe process by bring the data directlyfrom theCustomer KPIsOperations analysis
Data Mapping
Business process mapping
Technical Writing
Business planning
Needs assessments
Competitive analysis
Gap analysis
Problem-Solving
Dependable and Responsible
Software
Interests
Reading, Writing, Listening Music, Yoga
Timeline
Senior Data Analyst
Fifthnote
03.2021 - Current
Data Analyst
Nextgen Technologies
09.2019 - 03.2021
Business Analyst
Slide team Ltd
12.2017 - 08.2019
Reporting Data Analyst
Scintillations And Research Analytics, Mohali
02.2015 - 10.2017
M.tech - Electronics And Communication
AMITY UNIVERSITY
05.2011 - 04.2014
B.TECH - Electrical, Electronics And Communications Engineering
Kurukshetra University
06.2006 - 07.2010