Rupesh Patro
DW & BI Architect, Data Architect, Data Specialist, Data Engineer, Data Modeler, Data Analyst
- Role
- Solutions Designer at Tech Mahindra
- Location
- Mumbai, IN
- LinkedIn followers
- 500 followers
About Rupesh Patro
PROFILE SUMMARY • · A competent professional having 18 plus years of experience in IT in analysis, design, development, testing, implementation and maintenance of Data Warehousing, Business Intelligence and Analytics, Data Engineering, Data Management, Data Architect and Data modeling roles and projects. · Experience in Data Warehousing & Data management, ETL, Data Integration, Data Migration, Data Analysis, Data Modeling, BI Design, Data analytics and Visualization, ELT, MDM, EDW, Data Lake, OLAP, RDBMS concepts, Programming and SQL Queries, also in system maintenance, administration, and optimization. · Experience in functional, data, requirements and system analysis and discovery. Experience in Design, technical architecture, Solutioning and Problem Solving also including Projects Planning, Estimation and Presales support. · Has got aptitude and analytical skills in understanding business processes, requirements and problem solving. Excellent communication, analytical and articulation skills. · Domain knowledge in Banking, Financial Service, Insurance, FMCG, Manufacturing, Digital Social Platforms, Web Analytics and GL and Accounting. TECHNICAL SKILLS · Data Modelling using Erwin; translating functional/information requirements into conceptual,logical, physical data models. Designed Normalized 3NF as well as Dimensional Models. Have knowledge of BDW and FSLDM industry models. · ETL: Has worked on ETL using SSIS, Stored Procedures, SQL and Scripts. And also have good knowledge in Informatica and scripting. · RDBMS: Has worked on SQL server 2005/2008 also worked on Oracle and other databases such as Vertica and Netezza. Have knowledge of NoSql databases such as MongoDB. · BI & Reporting: Has extensively worked on Business Objects XI R2/3.1 and 4.X, using Universe Designer/IDT, BI reporting using DESKI and WEBI. Also has worked MSBI tools such as SSAS and SSRS and data visualization using AWS Redash and PowerBI. · Cloud Services: Also got experience AWS database services Redshift, RDS, as well as services such as S3, EC2.experience on Azure services such as Azure SQl, Synapse, Data Studio, Azure Analysis Services, Data Factory and knowledge in Azure Fabric and Databricks. · Eexperience in full life cycle development from requirements, ideation, analysis, system design, documentation, flowcharting, testing, troubleshooting, debugging, maintenance and support.
Experience
Solutions Designer
Mar 2025 — Present · Mumbai, IN
Education
National Institute of Science and Technology (Autonomous, NBA and NAAC Accredited)
Bachelor of Engineering (B.E.), Electrical and Electronics Engineering
2000 — 2004
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.