BI Manager / Solution Architect
Capgemini India Limited
Total years of experience :18 years, 9 Months
• 13 years of extensive experience in data/analytics related Projects in a wide range of roles and responsibilities which include Project Manager - BI and Reporting Innovation, Enterprise data Architect, Senior Consultant, Senior Data Analyst and Solution/Data Architect with customers as T-Mobile, TeliaSverige, Lowes Retail, Frontier Communication, FairPoint Communication, GE Healthcare etc.
• Having around 5 years of extensive working experience in Onsite including US and Sweden and directly working clients with actively involved in stakeholder’s management.
• Maintain and execute proper communication with different stakeholder to ensure brand engagement and strong relationship
• Expertise in design, development and project management with experience in design and implementation of data warehousing Architecture and Methodologies.
• Exhaustive experience designing and implementing solutions with various DWH/BI tools and applications. Experience in designing scalable & cost-effective enterprise DWH/BI architecture for some clients.
• Lead other BI/Solution Architects in working with various business and management teams to define vision for the Sourcing and storing data strategies, Implementation of ETL, Reporting and Analytic solutions.
• Expert in understanding the data and designing/Implementing the enterprise platforms like Hadoop Data lake and Huge Data warehouses.
• Solution Design: Studying various existing business process to recommend the best solution architecture. Design to meet the business needs with optimal use of resources and retaining/retiring some of old processes.
• Business Analysis/Requirement Gathering: Meeting with business user to freeze the requirements, analyzing the business with technical feasibility and impact analysis on a change request.
• ETL Architecture: Architected the ETL framework and have made specification for various mappings, simple and complex to transform business know-how into technical.
• BI /Reporting Architecture using SAP BO: Universe design & implementation including standard as well as ad-hoc universes & linked universes out of relational data sources. Managing security.
• Designed Tableau and Power BI Reports and Dashboards.
• Have hands on experience as Hadoop Architect with good exposure on Hadoop Technologies like HDFS, Map Reduce, Hive, Hbase, Sqoop and Pig.
• Well versed with BIG Data environment checking the data in Hadoop File systems (HDFS) and experience in writing HIVE queries and Informatica BIG Data Edition (BDE)
• Expertise in Data Modeling including Conceptual, Logical Data Modelling, Industrial Teradata Data Modelling which includes Communication Logical Data Modeling (CLDM), Data Quality and Data Governance
• Implemented POC’s in BIG DATA using Informatica BDE, Hive, Pig and Sqoop
• Experience in leading large size team and project management and execution.
• Apply financial discipline in managing project budget, keeping costs under control at all times
• Understanding and analyzing the requirements of customers and Business Model.
• Designing the ETL process using Informatica tool Power Connect to load data from the SAP Interface source table to target schema.
• Developing Mappings to load the data in fact and dimension tables.
• Scheduled Sessions to update the target data (on Daily/weekly load frequency) using Redwood Cronacle Scheduling Tool.
• Created Bteq scripts to load data into specific columns of Facts and Dimension tables.
• Developed MLoad and FastLoad utilities to establish connections for Informatica.
• Created List (drill through) and Cross-Tab reports using Report Studio.
• Preparing Design Document, ETL specifications, Unit Test Cases and Migration Documents MD, Collect Statistics Document etc.
• Configured and Scheduled the Sessions to effective load.
• Involve in solving the issues raised during the enhancement.
Selected Achievements
i. Successfully implemented Data Mart for Supply Chain Management (Planning Sub Module) involved SAP sources from MM, SD and FICO module.
ii. Self learnt Informatica Power Connect and later became SME for data sourcing through SAP different modules
from