Amruta More
Power BI Developer
Pune
Summary
Experienced development professional with a strong background in extraction, transformation, and loading management. Skilled in optimizing performance and eliminating bottlenecks through effective critical thinking, troubleshooting, and problem-solving abilities. Demonstrated expertise in Power BI, Informatica PowerCenter, IICS, Oracle, BIRT, GIT, and Autosys as a developer for 5 years.
Overview
7
7
years of professional experience
Work History
Power BI Developer
Tata Consultancy Services
01.2024 - Current
- Designed different types of reports with functionalities like Drill Down, Drill Through, Line Chart, Bookmarks and buttons.
- Used Power query to extract data from external sources and modify data to certain format as required in Excel.
- Experienced in creating DAX expressions such as Date & time, Aggression, string.
- Experience with large data sets, reporting and data visualizations.
- Used Table, Matrix, trend lines, bar chart, Slicers and custom visualizations.
- Worked on filters, calculated columns, measures , relationships , transformations using power query.
- Extensively worked on creating Rich Visuals for the reports and Visuals enhancement .
- Scheduled data refresh for the reports as per the client requirements.
- Ensure timely delivery and quality of delivery by adhering to quality process.
Software Engineer
Tata Consultancy Services
01.2023 - 01.2024
- Designed and built ETL jobs to extract data from Oracle and load the data in data warehouse using informatica Powercenter 10.2 and IICS
- Involved in enhancements and maintenance activities of informatica jobs
- Developed and tested mappings based on the specification by creating unit testing documents
- Used Control-m to schedule informatica jobs and load the data
- Created Deployments tickets to migrate informatica mappings and sessions in other environments
Programmer
Cognizant
07.2021 - 06.2022
- ETL Development to satisfy business requirements for large, complex projects using informatica PowerCenter 10.2
- Conduct code reviews and make sure quality solutions are built and best practices/standards have been followed
- Responsible for on-time delivery for high-quality code
- Worked with other team members including DBA's, ETL Team, Technical Architects, QA Team and Business Analysts to define best solution
- Engagement in client interactions, agile workshops, unit testing, peer review, deployment and hyper care
- Reviewed and analyzed data objects and models to improve data management and data access
- Designed, constructed, tested and implemented extraction and transformation programs, processes and cycles for historical and current source data
- Wrote custom SQL queries using oracle SQL developer to temporarily override existing Informatica workflows on ad-hoc basis
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance
Programmer Analyst
Cognizant
06.2018 - 06.2021
- Understand the customers requirements and existing system, coordinate with Business analyst/Technical lead and implement the customized reports using BIRT tool
- Trouble shoot and provide resolution to production and non-production issue by fixing performance issues
- Developed BIRT reports using Oracle database
- Responsible for deployment Reporting Framework and features in different environments
- Managed service now RFCs and Incidents for deployments for all regions
Education
Master of Computer Applications -
IICMR College
04.2001 -
Bachelor of Computer Applications -
ATSS College
04.2001 -
Skills
Power BI
Informatica PowerCenter
IICS
Oracle
Control-m
Putty
undefinedWebsites
Awards
- Cognizant Cheers Certificate of Appreciation, For excellent contribution in project and demonstrating the value.
- Cognizant Cheers Certificate of Appreciation, For stellar performance and demonstrating the value in Project.
ACADEMIC PROJECTS
ONLINE GROCERY SHOPPING WEBSITE (MINI PROJECT)
IICMR COLLEGE
Used Java,HTML,CSS,MYSQL (PhpMyAdmin), Visual Studio to develop this grocery e-commerce website.
This will provide solutions for multi-store online grocery shopping.
HOSPITAL MANAGEMENT SYSTEM WEBSITE (MINI PROJECT)
IICMR COLLEGE
Used HTML,CSS,JAVASCRIPT and PHP to develop this online hospital management website which will provide solution for online management of work and tasks related to hospital.
EMPLOYEE GRIVENCES MANAGEMENT SYSTEM (MINI PROJECT)
IICMR COLLEGE
Used HTML, CSS, MYSQL (PhpMyAdmin) to develop employee grievances management website which intends to explore the management of employee grievances.
FRANCHISEE MANAGEMENT APPLICATION (MINI PROJECT)
IICMR COLLEGE
Used XML, Android studio, Java,firebase to develop Franchise management application to bring down the workload with the increased
efficiency and to speed up the activities within multiple franchisees.
Timeline
Power BI Developer
Tata Consultancy Services
01.2024 - Current
Software Engineer
Tata Consultancy Services
01.2023 - 01.2024
Programmer
Cognizant
07.2021 - 06.2022
Programmer Analyst
Cognizant
06.2018 - 06.2021
Master of Computer Applications -
IICMR College
04.2001 -
Bachelor of Computer Applications -
ATSS College
04.2001 -
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Vaibhav SuryawanshiVaibhav Suryawanshi
UI Developer at Xcaliber Infotech Private LimitedUI Developer at Xcaliber Infotech Private Limited