Designed and implemented end-to-end BI solutions leveraging Azure Synapse, Databricks, Fabric, Data Lake, AWS S3, Oracle Exadata, and MS SQL Server.Led the creation of dimensional data models (Star, Snowflake, Data Vault) for Retail, Telco, and Government sectors. Optimized data structuring using MS Visio and Oracle SQL Data Modeler.Orchestrated the management, design, and development of robust Database and ETL architectures. Used tools like Azure Data Factory, MS SSIS, and Informatica.Proficient in SQL, PL/SQL, T-SQL, Python, PySpark, and SparkSQL. Utilized these languages in diverse databases and big data environments.Built and optimized data pipelines using Python, PySpark, and SparkSQL on Databricks/Microsoft Fabric to process and transform large-scale data.Developed and implemented ETL processes to extract/ingest parquet-formatted data to/from Azure Gen2 and AWS S3 storage.Drove the design and development of cutting-edge reporting and dashboarding solutions. Used MicroStrategy and PowerBI to deliver actionable insights.Monitored and fine-tuned database queries, stored procedures, and ETL processes to enhance efficiency and responsiveness.Implemented Data Governance processes on MS Purview, ensuring data quality and security.Provided leadership and guidance to teams, ensuring timely delivery of solutions and instilling best practices.Documented requirements, technical designs, and data management processes to foster streamlined execution.Implemented robust security protocols for databases and reporting tools, safeguarding sensitive information.Conducted rigorous testing processes to validate solution integrity and functionality.Kept abreast of BI and Data Management trends and identified advancements to enhance project deliverables.Facilitated technical training and knowledge transfer to empower teams with the requisite skills and expertise.Actively participated in POC initiatives and provided support in proposal processes to drive innovation.

Gathered business requirements and documented deliverables, including technical designs, development, deployment, and training processes.Managed full project lifecycles, from development through SIT, UAT, and deployment, ensuring quality and risk mitigation.Led POCs for migrating on-prem EDW solutions to cloud platforms (AWS/Redshift, Oracle Autonomous DW), aligning with business needs.Executed large-scale EDW/BI projects, driving outcomes aligned with organizational goals.Developed executive dashboards on MicroStrategy using EDW/ODS data on Teradata/Oracle Exadata, providing insights for stakeholders and saving resources.Utilized Tableau, QlikView, and SAP Business Objects for departmental reporting on Teradata, enhancing self-service BI.Integrated airport weather data with flight operations data on Oracle for near-real-time insights, reducing external solution reliance.Created Python scripts to parse and process EBCDIC and Hex-formatted data, improving data extraction efficiency.Used Pandas for data cleaning and transformation to prepare data for analysis.Led analytical projects with R to boost revenue and optimize flight operations, achieving a 9% annual revenue increase.Mentored team members, promoting best practices to ensure high-quality deliverables.Managed the design and development of Star/Snowflake data models for optimized data analysis using Toad Data Modeler, MS Visio, and Sybase PowerDesigner.Developed db objects and ETL processes using SQL, PL/SQL, T-SQL, IBM Infosphere Datastage, and MS SSIS across Oracle, Teradata, and MS SQL Server.Validated architectures, data models, and ETL strategies to ensure alignment with project requirements.Optimized performance by fine-tuning queries and ETL processes on Oracle, Teradata, and IBM Datastage.Developed Data Governance processes on Informatica Axon to monitor data transitions.Led a Mainframe Exit Project, transitioning legacy systems to open systems and integrating them into EDW environments.

Managed end-to-end EDW/BI projects, aligning with company objectives and priorities.Developed enterprise-level dimensional data models from scratch across domains like Flight, Ticket, and Cargo using Oracle Designer, Toad Data Modeler, and Erwin.Led EDW solutions on Oracle/Teradata and ETL architectures on Oracle Warehouse Builder/IBM Datastage, streamlining data integration.Managed ODS and near-real-time architecture development on Oracle, optimizing pipelines, tasks, and procedures for timely data processing.Designed and maintained datamarts on Oracle and Teradata, ensuring data accuracy for business units.Developed enterprise-level reports and dashboards using MicroStrategy, saving thousands of man-days and empowering decision-making.Led the creation of real-time operational dashboards for Flight and Ground Ops, saving $350K by developing in-house solutions instead of purchasing external ones.Led projects to improve flight operations, using data-driven insights for efficiency gains.Implemented data governance to ensure data quality and security with IBM Infosphere Metadata Workbench.Optimized queries on DB2, MS SQL, Oracle, Teradata, and ETL processes on IBI Copy Manager, OWB, and IBM Datastage for better performance.Managed data migration from IBM Mainframe/Adabas to RDBMS and EDW appliances, ensuring smooth transitions.Managed ETL tool migrations/upgrades, ensuring efficient data processing continuity.Supported legacy module migration from IBM Mainframe to SAP ERP and Hyperion Essbase.Participated in SIT/UAT, and Go-Live to ensure successful implementations.Conducted POCs for EDW and ETL migrations, testing Exadata, Teradata, Netezza, Informatica, and IBM Datastage.Established security rules for databases and reporting tools, using Fine-Grained Access Control.Documented requirements, designs, data dictionaries, ER diagrams, and deployment procedures.Developed and maintained MIS processes on IBM mainframe, providing reports using Natural/Adabas.

Overseen the management, design, and development of Adabas Databases running on IBM Mainframe systems, ensuring optimal performance and data integrity. Designed and developed Adabas Tables, Views (DDMs) to facilitate efficient data access and integration with other data domains. Developed and maintained programs, sub-programs, routines, and sub-routines using Natural/Adabas programming language, enabling seamless integration with other data domains and facilitating the generation of batch and online reports. Developed and maintained batch processes using Job Control Language (JCL) in the IBM Mainframe TSO environment, ensuring timely execution and accurate processing of batch jobs. Regularly monitored running batch processes and took necessary actions to ensure smooth operation, optimize performance and efficiency, and meet business requirements.

Vigilantly Monitored Branch Automation Systems to ensure uninterrupted service and maintain branch online availability and reliability. Monitored assets utilized by branches, including local servers, workstations, ATM machines, and line printers, ensuring their proper functioning and availability. Ensured the Branch Automation System running on CTOS was kept up-to-date and operational across branches, implementing necessary updates and patches to maintain system integrity. Provided timely support to branches in the event of issues or disruptions related to the Branch Automation System, troubleshooting and resolving issues efficiently to minimize downtime and impact on operations.