Technology Manager

• Jul 2022 - Present

SQL Developer

• Apr 2021 - Mar 2022

• Experienced in Designing and managing SQL Server Database and Table, Constraints, Views, Indexes and referential integrity depending on the requirements and converting them into technical specifications. • Experienced in programming Stored Procedures, Triggers and Cursors using SQL Server to assist efficient data manipulation and data consistency. • Experienced in writing queries which involves Multiple If,Joins, Case, Row_Number, Partition By, Over, Rank, Dense_Rank, Common Table Expression(CTE), Pivot and Unpivot. • Transferred data from various data sources including MS Excel, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc. • Created SSIS Control Flow such as using Execute Sql Task, File System Task, Script Task, Foreach loop Container and Execute package task. • Created SSIS Data Flow which involved a variety of transformations such as Slowly Changing Dimension, lookup, Aggregate, Sort, Data conversion, Derived Column, Row Count, Conditional Split, Multicast, Union All, Merge, Merge Join, Variables, and Error Handling before loading data into the Data warehouse. • Knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions. • Experience in banking, Finance domain. • Excellent team player with the strong interpersonal communication, analytical skills, ability to work on multiple tasks. • Followed Agile methodology in releasing deliverables in each Sprint and actively participated in sprint planning meetings and led the Stand-up calls. Also Gained experience on Waterfall Methodologies.

ETL Developer

• Apr 2014 - Mar 2020

• Extensively working on ETL Tool, SQL Server 2008, 2012, 2016. • Extensive experience in developing stored procedure, functions, views, Complex queries using SQL Server. • Having basic knowledge about Oracle packages. • Experience in Package creation in MSBI (SSIS). • Strong Knowledge and thoroughly exposed to MSBI. • Experience in resolving on-going maintenance issues and Backup. • Followed Waterfall Methodologies. • Experience in preparation of Test Cases & experience in Unit & Smoke testing. • Strong working Knowledge of healthcare domain.

Intern

• Dec 2012 - Apr 2013

Title : Online Personal Payments; Team Size : 4; Java (Jsp,Spring(IOC),Struts2),MySql5 Platform : Windows Seven Server : Tomcat Server 6.0 Scope : This project is web based application for banking sector, it is small Amount transaction between two people without sharing bank details With each other. Role : I have designed and developed applications. Writing BRD and DSTD. Writing use cases and flow diagrams. 2) BCS Project Title : eDigiworld; Team Size : 2; Java (Servlet, jsp) Platform : Windows Scope : eDigiWorld.com is a online shopping cart service for those people who want to know the purchasing details of the electronic products. Role : I have worked in team where I have designed and developed applications