SUMMARY:

• 12 Years of experience in Microsoft database development
• Experience in working with following industriesMortgage NATIONAL CITY MORTGAGEBanking CALICUT SERVICE CO - OPERATIVE BANKHealth Care BUPAHospital HOLY SPRIT HOSPITAL and ‘Big 4’ Accounting Firm KPMG
• Expertise in creating and modifying database objects such as Tables, Views, Stores Procedures, Functions, Triggers, Jobs, Indexes, Temporary Tables, SQL Queries, PL/SQL, SSIS, SSRS, SAS, MS Access, Crystal reports and Oracle.

TECHNICAL SKILLS:

• RDBMS SQL Server, Oracle
• SSIS, SSRS, SSAS, SAS
• C#, VB.NET
• Crystal Reports
• Azure Data Bricks, Python, SPARK, Azure SQL, ADF, Azure Synapse and Azure Data Lake, Power BI

PROFESSIONAL EXPERIENCE:

Confidential

Business & Integration Arch Specialist

Responsibilities:

• Develop framework level pipelines
• Involved in ADB 2.0 changes and create and optimize the clusters
• Develop and deploy ADF pipelines linked service and datasets
• Develop notebook using azure data bricks and deploy in varies environments
• Work with ETL migration team to understand their Environment setup requirements
• Ensure access is available and provisioned correctly on each SRZ entities, Synapse pools, ADB, ADF and SQL DB and work with Team1 to provision the environment setup across all environments
• Deploy required ADB FW version on ADB workspaces for Enterprise and LOB curated zone tenants
• Create PR and Release link for FW version TAG needed by tenant projects for their PAT/PROD deployments
• Deploy ADB External Libraries on ADB clusters for Enterprise and LOB curated zone tenants
• Do initial configuration setup of folders/files for new synapse pools
• Do Synapse deployment whenever there are any schema/folder additions happened
• Do SQL DB deployment whenever there are any schema/folder additions happened

Confidential

Manager

Responsibilities:

• Used Azure Data Factory (ADF) to perform Incremental Loads from Azure SQL DB to Azure Synapse.
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics.
• Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
• Optimized Azure Data Factory (ADF) Pipelines with Various Partitioning Techniques
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse.
• Prepared the completedata mappingfor all the migrated jobs using SSIS.
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Databases.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing
• Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.
• Performed operations like Datareconciliation, validation, and error handling after Extracting data into SQL Server.
• Designed reports, Graphs and deployed reports to powerBI.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Perform fundamental tasks related to the design, construction, monitoring, and maintenance of Microsoft SQL databases.
• Performance tuning of SQL queries and stored procedures.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis andextraction.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Working with Power BI Report Server for Paginated Reports and Using Report BuilderTool.
• Created complex Adhoc reports for the different levels of the management
• Created and scheduled ongoing reports
• Created crystal reports

Confidential

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures, functions and views.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Physical design and implementation SQL Server databases.
• Created complex Adhoc reports for the different levels of the management
• Created and scheduled ongoing reports
• Created crystal reports
• Supported the migration team by providing data points from old system based on the requirements
• MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
• Created quality check and compare reports for cross checking data between old KRISK and CEAC system with new NGGC system
• Tested the Client and Engagement End User Reports
• Worked together with the development team and migration team in an Agile environment to ensure the tight deadlines are met
• Anonymization and Deanonymization of data and confidential information using c#
• Scheduled the SSIS packages to run at different intervals to load the data.
• Experience in creating complexSSIS packagesusing proper control and data flow elements with error handling
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination