Subbaiah Ramanathan
Manor Lakes
Summary
Focused, committed and results-oriented IT professional with 4.5 years of overall experience. The recent 3 years accounts to Business Intelligence Analyst (Reporting) experience demonstrating strong prioritization skills and analytical ability to unlock the critical intelligence hidden within the company’s own data and initial 1.5 years accounts to front end web developer experience.
Overview
9
9
years of professional experience
Work History
Business Intelligence Analyst (Reporting)
TATA Consultancy Service
2021.11 - Current
- Created end to end fully automated daily, weekly, monthly and KPI reports using Power BI, Excel
- Strong expertise in connecting several data sources to PBI, PBI data modelling, creating complex DAX, M query transformations and Visuals
- Hands on experience in providing end to end BI solution (starting from facilitating workshops with stakeholders for gathering business requirement, converting them to functional requirements, developing insightful visuals and dashboards, Testing and Maintenance of developed dashboard/report) in Agile methodology
- Facilitate meetings with the business and vendors to address any gap/issue in the solution/requirement
- Hands on experience in creating live dashboards using PBI by fetching data from the Amazon S3 bucket
- Played a key role in integrating data from different sources and creating meaningful dashboards for storytelling
- Hands-on experience in ETL and data modelling (Fact and Dimension table model) using kimball methodology
- Strong experience in creating complex joins, subqueries, stored procedure, functions, and views using SQL, T-SQL
- Extensively involved in preparing the Master Reporting Requirement document which contains all the attributes of reports along with their business description and functional calculations, this document will be used as a reference to perform Source system analysis.
Front End Web Developer
Isys technologies
2016.01 - 2017.05
- Acted as the key point of contact between stakeholders and the internal team in analysing and addressing the key issues related to project ensuring client satisfaction
- Created visuals/dashboards that focused on the performance metrics and sales metrics for the client’s ecommerce website using Power BI
- Maintained database performance by troubleshooting problems
- Develop complex SQL queries to check & verify the data migration and mapping of historical data, checking the data from the views to tables and fetching the data for analysis and other testing operations
- Involved in creating mappings with the help of functional specification document and its relevant business requirement
- Performed Complex SQL queries to identify the “Uncategorized Transactions” and implemented aggregation of transaction code as a key business rule for the Categorization Engine
- Developed responsive web pages using HTML5, CSS3, and JavaScript following modern design principles
- Participated in code reviews, improving code quality and learning best practices in development
- Built custom components using Bootstrap and SASS, ensuring cross-browser compatibility and optimal performance.
Education
Master of Information Systems -
Central Queensland University
07.2020
Skills
- Data Visualization & Reporting
- Extract Transform and Load (ETL)
- AWS
- Exceptional Analytical Skills
- SQL Programming
- Stakeholder Management
Timeline
Business Intelligence Analyst (Reporting)
TATA Consultancy Service
2021.11 - Current
Front End Web Developer
Isys technologies
2016.01 - 2017.05
Master of Information Systems -
Central Queensland University
Similar Profiles
Upasana DasUpasana Das
Delivery Manager at Tata Consultancy ServiceDelivery Manager at Tata Consultancy Service
SIVARAMAN SIVAGURUNATHANSIVARAMAN SIVAGURUNATHAN
Test and Support Engineer at Tata Consultancy ServiceTest and Support Engineer at Tata Consultancy Service
Vimal Kumar MVimal Kumar M
Process Associate at TATA CONSULTANCY SERVICE PVT LTDProcess Associate at TATA CONSULTANCY SERVICE PVT LTD