Experience

• 

  Dentaquest

  Nov 2019 - Apr 2022

  Sql/ssis/ssrs developer

  Extracting data from various sources like flat files delimited, fixed width, Siebel CRM, Teradata, Oracle 11g, SQL 2008R2 and loading it to SQL database for further process.

• 

  Cvs health

  May 2022 - Apr 2023

  Sql/bi developer

  Gathered & analyzed requirements; understood business requirements & specifications from a business and technical perspective; redesigned the ETL process from the existing legacy DTS packages into SSIS Packages.Developed and maintained EDI transactions and claims processing systems and implemented solutions using Quevera to optimize data integration and workflow efficiency.Interact with clients to analyze business needs.Provide software product design and develop a technical roadmap for solutions through the project lifecycle.Worked with various SSIS tasks, including Transform Data Task, Execute SQL Task, FTP Task, For Each Loop containers, etc.Created SSIS packages for Uploading different formats of files (Excel, Access) and databases (SQL server, Flat files) into SQL Server data warehouse using SQL Server Integration Services (SSIS).Database / ETL Performance Tuning: Broad Experience in Database Development, including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions.Performance Tuning of Informatica Mapping and workflow.Troubleshoot failed jobs on the server, which involved stored procedures/SSIS packages.Scheduled SSIS packages to run at different intervals to load data.Responsible for creating schema objects like tables, views, and indexes.Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.Created stored procedures to be used by front-end report development.Work with DBAs, QA, and systems support personnel in elevating and automating successful code to production.Used TFS for version control.Created documentation as required for operational support. Show less

• 

  Us bank

  Jun 2023 - now

  Sql/database administrator

  Managed and administered SQL Server databases for critical banking applications, ensuring high availability and data integrity.