DatagrazpDirector / Project Manager
May. 2018 - Jan. 2020Bengaluru Area, IndiaProject & Delivery Management
1. Successfully managed end-to-end delivery of Application and BI Development projects across BFSI (Payments) and Healthcare (Clinical & Insurance) domains.
2. Led projects using a hybrid (Waterfall + Agile) approach to optimize flexibility and structure.
3. Directed a team of nine (Business Analysts, Developers), overseeing task allocation, resource management, and performance tracking.
4. Provided executive updates to senior leadership and stakeholders on project progress, risks, and achievements. Cloud & Data Engineering
1. Architected and deployed cloud-based solutions across AWS, Azure, and GCP, leveraging: A. Azure Synapse Analytics, Data Factory, SQL Azure, Data Lake B. PaaS/IaaS, Azure Analysis Services, Key Vault, Application Insights
2. Designed and optimized ETL pipelines for ODS layer development, ensuring seamless data integration from multiple sources (flat files, Excel, XML, SAP ECC).
3. Implemented Slowly Changing Dimensions (SCD Type I & II) for historical data tracking.
4. Automated SSIS jobs for importing/exporting data from CSV, Excel, and text files. BI Development & Analytics
1. Expert in BI stack (SSIS, SSAS, SSRS) and data visualization (Power BI, Tableau).
2. Applied performance tuning techniques to enhance data throughput and processing efficiency.
3. Developed Excel Macros and SQL scripts (using TOAD, SQL Developer, MS SQL Server Mgmt Studio) for data analysis and reporting.
4. Utilized Data Integrator transforms, variables, and functions for complex ETL workflows. DevOps & Best Practices
1. Championed DevOps adoption (CI/CD pipelines via Jenkins/Puppet) to streamline deployments.
2. Ensured data governance and compliance while handling sensitive financial and clinical datasets.
3. Collaborated with Scrum Masters & Dev Teams to support monthly releases and troubleshoot issues.