AMITH R
Software Engineer
Having around * Years of Experience in IT industry in different technologies involved. Design optimized data models for the applications & Manage end to end Projects from Requirements gathering to final delivery. Summary and Accomplishments
• Design optimized data models for the applications & Manage end to end Projects from Requirements gathering to final delivery.
• Worked with different data sources like SQL Server, Flat files, Excel Files etc.
• Good Knowledge of DAX, Creating Calculated Columns, Measures and Calculated Tables.
• Expertise in data modelling and be able to write complex DAX expressions.
• Good knowledge in Power Bi Licensing like premium and Pro.
• Knowledge in installing and configuring Gateway connections.
• Knowledge in Embedded power Bi and paginated reports.
• Optimize the performance of these reports in terms of time to refresh and size of the reports.
• Knowledge on Schemas like Star and Snowflake.
• Good in writing SQL statements like using Joins, Sub queries, CTE’s, Inserts, Updates & Delete statements.
• Good knowledge on SSRS reports building.
• Worked on building Paginated Reports.
• Strong understanding of the Microsoft technology stacks (SQL Server, SQL Server Integration Services, Analysis Services, and Tabular Reporting Services etc.)
• Good knowledge on MS Excel and analysing data on it. Experience
Nov’20
20 –
Apr’202
1
Software Engineer
BIXWARE Technologies Pvt Ltd.
Nov’18
- Jun’20
Software Engineer
IT RIDGE Technologies Pvt Ltd – Johannesburg, SA.
Feb’16
- Sep’18
Software Engineer
Agnes Softech Pvt Ltd – Hyderabad, India.
Academics
Jun’05
–
Jan’’11
B.E in Computer Science and Engineering
Page 1
Personal Information
adnzt2@r.postjobfree.com
Phone
Technical Skills
Power BI Desktop
Advanced
Microsoft SQL Server
Advanced
Power BI Report Builder
Advanced
HTML, CSS
Advanced
Excel
Advanced
Soft Skills
Problem Solving, Critical Thinking
Advanced
Creative and Interpersonal Skills
Advanced
AMITH R
Software Engineer
Projects Annexure
Nov’18 to
Jun’20 Project : MFLBI
Client : Aditya Birla Fashion And Retail Limited.
Environment : Power BI Desktop, Power BI Report Builder, Microsoft Sql Server.
Project Description: Aditya Birla Fashion and Retail Ltd. (ABFRL) emerged after the consolidation of the branded apparel businesses of Aditya Birla Group comprising ABNL's Madura Fashion division and ABNL's subsidiaries Pantaloons Fashion and Retail (PFRL) and Madura Fashion & Lifestyle (MFL) in May 2015. Post the consolidation, PFRL was renamed Aditya Birla Fashion and Retail Ltd.
Roles&Responsibilties:
• Gathered Business Requirements, interacted with Business Developers, Sales Managers and Admission team to get a better understanding of the Business Processes.
• Understanding existing excel reports and business logic.
• Created Data Model and Power BI reports.
• Resolved performance issues of the Reports.
• Extensively worked on Dax Calculations part and used extensively power query.
• Worked on Paginated Reports using Power BI Report Builder. Nov’18 to
Jun’20
Project : SHUTEIS
Client : SASOL, South Africa.
Environment : Power BI, Microsoft Sql Server.
Project Description: Sasol is an international integrated chemicals and energy company that leverages technologies and the expertise of our 31 270 people working in 31 countries. We develop and commercialize technologies and build and operate world-scale facilities to produce a range of high-value product stream, including liquid fuels, chemicals and low-carbon electricity.
Roles&Responsibilties:
• Gathered Business Requirements, interacted with Business Developers, Sales Managers and Admission team to get a better understanding of the Business Processes.
• Understanding existing excel reports and business logic and working with TOP Level Management.
• Created Data Model and Power BI reports.
• Resolved performance issues of the Reports.
• Extensively worked on Dax Calculations part and used extensively power query.
• Integrating Power BI reports into Asp.net web application.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
Page 2
Interests
Gardening
Travelling and exploring
Languages
English
Advanced
Hindi, Kannada
Advanced
AMITH R
Software Engineer
Projects Annexure
May’17 to
Sep’18
Project : Green Park, Sarovar
Client: Green Park, Sarovar
Environment : Power BI, Microsoft Sql Server.
Project Description: Green Park is a Four-Star Hotels at Hyderabad, Visakhapatnam and Chennai. Green Park offer online booking reservation of hotels Green Park in all the properties. Green Park which provides Hospitality solutions and to manage the daily activities of the hospitality industry like Reservation, Check In Guests, Posting revenues, Checkout guests and maintaining guest History. F&B Management, Financial Management, Material Management, HR & Payroll etc. With different interfaces integration.
The data warehouse covers all the domain of the business and captures data from their Transactional Database maintained under Client/Server Architecture.
Roles&Responsibilties:
• Gathered Business Requirements, interacted with Business Developers, Sales Managers and Admission team to get a better understanding of the Business Processes.
• Develop YoY, MoM Performance Charts, Targets & Funnels, 6 months trajectories.
• Resolved the performance issues of the Reports.
• Extensively worked on Dax Calculations part and used extensively power query.
• To ensure higher management about the Project Progress on Weekly Basis.
Feb’16 to
Apr’17
Project : National Academy Foundation
Client: National Academy Foundation
Environment : Power BI, Microsoft Sql Server.
Project Description: Beginning in 2008, NAF partnered with West Ed, to develop a comprehensive student assessment and certification system for NAF Career Academies. A leader in the movement to prepare young people for college and career success with a proven educational model including industry-focused curriculum, work-based learning experiences, and partner expertise, NAF developed a “next-generation” assessment system designed to model real-world demands, including the integrated application of academic, career-technical, and workforce readiness skills
– Student Certification Assessment System (SCAS).
Designed to bridge the gap among high school career-technical programs, post-secondary course articulation efforts, admission policies, and workforce readiness initiatives, SCAS represents a multi-method approach to assessing a broad range of content and skills through rigorous end-of-course exams, evidence-based portfolios combined with supervisor and teacher feedback. Benefiting students, colleges, and industry, SCAS signals students’ readiness to pursue a postsecondary degree or certificate as well as entry into the career field of their academy theme.
Roles&Responsibilties:
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Involved in Proof of Concepts to work on Power Bi.
• Involved in Technical Specification Document (TSD) and understanding the User requirements
• Develop and design interactive dashboards.
• Resolved the performance issues of the Reports.
• Extensively worked on Dax Calculations part.
Page 2
Other details
Marital Status:
Single.
Address:
#20,BEML Layout 6th Stage,
ITPL Road,
Bengaluru – 560066.