Experience

• 

  Igc.technology

  Jun 2015 - May 2017

  • Created SSIS packages to export and import data from CSV files, Text files, and an Excel spreadsheet.• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.• Developed different type of reports including Sales Report, Client Contact Report, Billing report and other reports by using SSRS and SQL Server 2008/2012.• Created and maintained Analysis services objects such as cubes, dimensions, measures.• Analyzed data and re-mapping fields based on business requirements.• Used Store procedures, User-defined functions, Views, T-SQL scripting for complex business logic.• Generated various Monthly, Quarterly, Yearly reports by different type of visualization tools using Cognos, Power BI, Tableau. Show less • Developed SQL databases and writing applications to interface with SQL databases.• Responsible for developing of T-SQL Common Table Expression, Procedures, Functionsand database Triggers.• Extensively used joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzed data and re-mapping fields based on business requirements.• Analyzed existing SQL queries for performance improvement.• Assist with reviewing and interpreting ongoing business requirements.• Developed procedures and scripts for data migration.• Developed Dynamic search queries and results with manipulated data.• Responsible to record all the Minutes for the Meeting and convert into suitable technical specifications.• Experience working in Relational Databases. Show less

  • ETL Developer

    Apr 2016 - May 2017

  • SQL Developer

    Jun 2015 - Mar 2016
• 

  York risk services group

  Feb 2019 - Nov 2019

  Sql developer ii

  • Responsible for conducting troubleshooting on databases and applications which includes data validation and extensive testing to ensure that the database systems and access programs meet the end-user's specifications.• Develop SQL databases and work with the team to maintain and enhance the existing solutions.• Write SQL queries to store, sort, and retrieve data which ranges from basic commands like read, write, create, and update to complex commands that fetch and manage data across multiple tables with the ability to write and optimize these codes.• Gather requirements and specifications from the end-users.• Constantly work with team to enhance and improve systems and better handle data and increase system efficiency.• Assist in the ongoing development of technical best practices for data movement, data transformations, data quality, data cleansing and other ETL-related activities. Show less

• 

  Jetblue

  Jul 2021 - now

  Sql developer