Experience

• 

  Zensar technologies

  Oct 2017 - Jan 2020

  Sql developer

  - Accumulated significant experience in data-related operations within the Supply Chain domain, specifically for Adidas, during my tenure at Zensar Technologies.- Independently managed the migration of over 70 complex SQL and PL/SQL queries, showcasing proficiency in database migration and ensuring a seamless transition.- Independently migrated more than 80 Cognos reports, meticulously testing each feature individually to guarantee functionality and reliability.- Authored new SQL and PL/SQL queries from scratch, addressing diverse needs such as reporting, ETL processes, and quality assurance, underscoring a versatile skill set.- Utilized Cognos Framework Manager to create Cognos packages, enhancing the efficiency of data utilization in reports and ensuring streamlined reporting.- Created reports with advanced features like drill-down, rendering and prompts in IBM Cognos Analytics and SSRS, elevating the quality and functionality of the reports.- Played a pivotal role in designing and implementing Data Flow and Control Flow, crafting SSIS packages for efficient ETL processes, highlighting proficiency in SSIS.- Integrated data seamlessly with Tableau, leveraging its visualization capabilities to enhance data representation and analysis in reports.- Incorporated Power BI for enhanced visualizations, contributing to more interactive and insightful reporting solutions.- Contributed to the holistic reporting ecosystem by combining expertise in SQL, PL/SQL, Cognos, SSIS, Tableau, and Power BI, ensuring a comprehensive and technologically diverse approach to data management and reporting. Show less

• 

  Sapiens

  Jan 2020 - Sept 2020

  Sql developer

  In response to recent business transformations, I actively engaged in adapting the data model to align with evolving requirements. This involved meticulous adjustments to existing structures and the creation of new elements. Employing agile methodologies, I collaborated with offshore teams, ensuring swift and effective solutions to meet dynamic business demands.- Successfully adapted the existing data models to accommodate recent business changes, demonstrating flexibility and agility.-Developed new queries, procedures, functions, and triggers to align the data model with the updated business needs, showcasing advanced SQL and T-SQL proficiency.- Collaborated efficiently with internal and external stakeholders, adopting an agile methodology to provide timely and effective solutions.- Utilized SSRS to create visually appealing dashboards, enhancing data visualization and facilitating informed decision-making.- Created over 40 complex reports in IBM Cognos 11, showcasing a high level of expertise in leveraging the platform for comprehensive and insightful data reporting.- Developed robust ETL pipelines using SSIS and IBM DataStage, ensuring the seamless extraction, transformation, and loading of data to meet the organization's evolving requirements.- Managed the end-to-end process of creating and scheduling jobs for loading raw tables from daily data feeds.- Implemented automated job processes to load data marts from raw tables on a daily basis, ensuring the availability of up-to-date information for analytical purposes, and leveraging SSIS for streamlined ETL.- Leveraged Power BI alongside Data Analysis Expressions (DAX) to craft interactive and insightful visualizations. This integration enhanced data comprehension, providing stakeholders with dynamic reports and dashboards. Show less

• 

  Wipro

  Feb 2022 - Aug 2022

  Sql/cognos developer

  - Created/modified SSIS packages, showcasing expertise in orchestrating seamless data flow within complex ETL processes.- Authored over 40 SQL scripts, demonstrating a deep understanding of database, data modelling and employing best practices to enhance query performance.- Responsively addressed and fulfilled ad-hoc requests from report users. by promptly writing SQL.- Showcased advanced T-SQL skills by developing and fine-tuned stored procedures, playing a pivotal role in improving data processing efficiency while maintaining data integrity.- Hands-on involvement in testing SQL queries and reports in Cognos/SSRS, ensuring precision and reliability before each deployment, contributing to a robust and error-free data environment.- Implemented performance tuning techniques, optimizing SQL queries to improve response times and overall system efficiency, with a focus on delivering high-performance data solutions.- Maintained detailed documentation for SSIS packages, SQL Queries, ensuring transparency and facilitating knowledge sharing for seamless future maintenance and updates.- Worked on integration of on-premises SQL solutions with Azure SQL, leveraging cloud advantages for scalability and performance optimization.- Implemented rigorous quality assurance measures for SSIS packages and SQL scripts within Azure Data Factory, ensuring data accuracy and reliability in a cloud environment.- Skillfully utilized IBM DataStage as the ETL tool to manage daily data feeds received through FTP, showcasing expertise in seamless integration of data from external sources to populate raw tables within the organization's data. Show less

• 

  Ebrd

  Apr 2024 - now

  Associate software developer, people d&a