Ass. Technology Specialist - SYNECHRON TECHNOLOGIES
(2009-05 - 2026-06)
Ass. Technology Specialist - SYNECHRON TECHNOLOGIES - Japan
(2021-03 - 2026-05)
PROJECT 1: Asurion -Japan | Team Size 12
- Designed, developed, and deployed 40+ interactive Power BI dashboards and reports for Insurance Operations.
- Developed complex DAX measures, calculated columns and tables to implement business logic and generate KPIs and metrics.
- Integrated data from SQL Server, Oracle, Excel, SharePoint, REST APIs, and other enterprises into Power BI reports.
- Built reusable and optimized Power Query (M) transformations for data cleansing, shaping, and integration from multiple heterogeneous data sources.
- Published, managed, and maintained reports, dashboards etc. supported by MS-copilot & AI powered claude tool within Power BI Service following governance standards.
- Implemented Row-Level (RLS) and workspace-level access controls to ensure secure, role-based access to business-critical data.
- Accomplished delivery of end-to-end data solutions from ingestion to reporting for enterprise operations, improving data availability and business consumption efficiency, by designing and implementing scalable ETL and reporting.
- Improved data reliability and SLA compliance across business-critical pipelines by collaborating with business owners and data providers to define and enforce operational SLAs.
- Managed 700+ daily ETL batch jobs with high availability and SLA adherence by leveraging Airflow, ActiveBatch, and Denodo frameworks and reliability metrics for proactive issue tracking.
- Reduced production downtime and incident impact through proactive alerting and monitoring configurations using ActiveBatch Monitoring tools.
- Reduced incident resolution time and improved production stability by providing L2/L3 support with proactive monitoring and root cause analysis.
- Enhanced ETL performance and data accuracy by tuning complex SQL queries for validation, transformation, and optimization.
- Improved operational resilience and disaster recovery readiness by implementing SOPs, backup strategies, failover and cutovers.
Ass. Technology Specialist - SYNECHRON TECHNOLOGIES - Atlanta, USA
(2019-12 - 2021-04)
PROJECT 2: Riskconnect (Atlanta, USA) | Team Size: 6
- Developed interactive operational and management dashboards using Power BI Desktop to support business reporting requirements.
- Designed, developed, and maintained SQL Server Stored Procedures, Views, Functions, and complex T-SQL queries for reporting and data extraction.
- Created optimized SQL queries involving complex joins, CTEs, window functions, temporary tables, and performance tuning techniques.
- Developed Power Query transformations to clean, merge, and prepare data from multiple business systems.
- Published reports to Power BI Service and managed scheduled refreshes, workspaces, and user access.
- Worked closely with business users to understand reporting requirements and translate them into effective BI solutions.
- Performed report enhancements, defect resolution, and production support while ensuring compliance with SLA commitments.
- Reduced onboarding time for new team members by conducting structured knowledge transfer and technical training sessions.
Team Lead - SYNECHRON TECHNOLOGIES - US
(2016-01 - 2019-12)
PROJECT 3: Marsh ClearSight (US) | Team Size 15
- Improved enterprise data integration efficiency by implementing ETL processes to ingest and transform data from CSV, Excel, SQL Server, and Analysis Services sources.
- Delivered accurate client data loads within strict project timelines by executing controlled ETL deployments and coordinating cross-functional communication.
- Look over 80+ jobs daily and provide supports on these issue resolution turnarounds by collaborating with functional and technical teams on defect fixes and enhancement requests.
- Reduced recurring production issues by troubleshooting critical customer-reported defects and driving end-to-end resolution ownership.
Software Engineer - SYNECHRON TECHNOLOGIES
(2009-06 - 2015-12)
PROJECT 4: CS STARS | Team Size 12
- Improved reporting accuracy and downstream analytics quality by transforming, cleansing, and standardizing raw enterprise datasets.
- Enhanced business decision-making by creating and delivering analytical reports for internal users and external clients.
- Improved application stability and data quality by performing validation, bug fixes, enhancements, and production data delivery activities.
- Validating data populated in various table through data conversion process, applying business logic to various fields and making the data ready to load in client database.
- Increased production system reliability by providing L2/L3 support and resolving critical operational issues within SLA timelines.
- Enhanced ETL reliability and reduced processing failures by debugging and optimizing PL/SQL modules.
Ass. Support Engineer - S|ONE SERVICES INDIA PVT. LTD.
(2007-02 - 2009-02)
PROJECT: FRR PARAM | Team Size 20
- Managed end-to-end ownership of FRR PARAM operations and support for Luxembourg and Canada, ensuring timely and accurate financial reporting jobs.
- Improved operational efficiency and reporting accuracy by managing data capture, validation, allocation, delivery, and enhancement activities across financial reporting systems.
- Improved issue resolution effectiveness and customer communication by coordinating with cross-functional teams to address defects, enhancements, and change requests.
- Provided support via ticketing tool and resolving critical operational issues within SLA timelines.
- Did documentation for repeated issue, solution and root cause analysis to avoid future issues and trouble shoot.
