I take care of design and development of our Data Warehouse, directing the creation of ETL processes to seamlessly integrate diverse data sources like structured human-provided, IoT, and unstructured data. My role is pivotal in ensuring uninterrupted data availability for intricate cross-platform analytics, facilitating well-informed decision-making.Leveraging AWS, Postgres 10.5, Pentaho, and Python 3.0, I also mentor team members to enhance their proficiency in data engineering and database modelling, encompassing E-R model, Star Schema, and Snowflake. This guidance empowers our team to adeptly manage and optimize data structures, ensuring the efficiency of our analytical processes and system scalability.

As The Database Architect I was responsible for designing application databases for multiple projects and guiding teams in creating stored procedures and implementing business logic. They performed performance tuning, bug fixing, and fine-tuning of applications. Additionally, I designed BI reporting solutions and was also involved in data modelling, ETL flow design, data analytics, and analytical reporting.Technologies used included Power BI, Azure Synapse, Azure Stream Analytics, Azure Analysis Services, MariaDB 10.5 (Galera Cluster), Maxscale, and AWS.

Engaged in client interaction, analyzed existing DWH and BI reports to prepare the migration plan, and guided the team in step-by-step execution and data migration validation. Led migration of on-premise DWH (Oracle) to Amazon Redshift using Informatica 9.x, focusing on data modeling, ETL flow design, and analytics, leveraging Oracle 10G, Informatica 9.x, and Amazon Redshift.

End to End development, deployment and support of multiple Retail BI systems across the globe using BI (OLAP) technologiesGlobal delivery to support 6 retailers across North and South America, Europe and AsiaHigh volume support tickets/CRF managementLed a project team (25+) comprising of technical engineers to fulfill service enhancement requests from initiation to close adhering to business needs Business requirements capture, prioritizing business requirements and facilitating requirements sign offCommunicate with the client on functional clarifications on regular basisMonitor and track the progress of the project deliverables. Manage client escalations and resolve issues Operations/ Production support. Support for system/platform upgrade initiatives Performance improvement initiatives, Risk management for the project Chair team meetings for status updates and issue resolutionsResponsible for preparing monthly status reports for Senior Management & Client.Stakeholder management/accelerated engagementAmendments to SOW and work orders- extensions of projectsPreparing monthly operational metricsOnsite experience (USA & Poland) of business requirement analysis and client interactionsWorked in Cognos Business Intelligence Suite – Cognos 8.x/10.x Proficient in creation of layers (Database, Application and Presentation) in Framework ManagerHaving experience in other BI suite for retail – ARC (Manthan’s product) Have exposure in star schema and snow flake schema and Cognos architecture Proficient with People Management Skills providing direction, mentoring and developing people and enjoy teamwork.

As a Senior Database Engineer, responsibilities include creating and designing workflows, data modelling, and query performance tuning. Additionally, configuring the EIM Check Fraud module and Collaborating with Technical Architects in Poland on the design and configuration of check fraud functionality are key tasks. This role requires expertise in database management and collaboration with cross-functional teams to optimize system performance and functionality.

Designing/Development of Reports as per the business requirement Designing Data warehousing and ETL process for the project. Creating various SSIS packages and data flow for the ETL process.Performance tuning for various modules. ETL design & development using SSIS (Microsoft ETL framework).Design of Data Mart (Dimension modelling) for additional modules Creation of Reporting and ETL solution for Merchandising and Assortment Analytics, Category Management Analytics, Customer Analytics, Marketing and Promotions Analytics, Product Affinity and Market Basket Analytics, Planning and Budgeting Analytics are just some of the many applications featured in ARC.

LNPCIS provides Telstra the capability to transfer a customer’s Full National Number (FNN) toother carriers’ The LNPCIS application system manages and processes of porting requests andadvice, which are received from and sent to other carriers.I was involved in the development of PL/SQL Stored Procedures,Functions and Packages.

InterCall Online portal has been developed to provide the facility to arrange video and audioconferencing by making appointments online and managing through this portal.