SUMMARY

• Microsoft SQL Database developer with 7 years of experience in Software Development, Developing Applications using Database Management systems such as MS - SQL Server/SSIS/SSAS/SSRS.
• Extensive experience in RDBMS data modeling concepts
• Having good Knowledge in HRMS Modules on Corporate, Banking and Medical industries.
• Good in creating Report Query, Correlated sub queries, Performance Tuning, Query Optimization for SQL Server.
• Experience in writing Stored procedures, functions and views.
• Experience in writing and tuning complex sub queries, SQL, Stored procedures, functions, and Joins.
• Excellent in creating SSIS Packages for integrating data using ADO dotnet connection and heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all.
• Experience in creating SSIS Package with OLE DB source and destinations, Table difference, Lookup and Sorting.
• Documenting teh new incident scenarios for Team usage and documenting User stories of each sprint.
• Modified teh existing ETLs using SSIS
• Experience in Database performance optimization, debugging and tuning using teh Query Analyzer and SQL Profiler.
• Hands of experience in creating Jobs, Database Mail, and scheduling SSIS Packages.
• Excellent code reviews and code debugging skills.
• Ability to work excellently as an individual and as a proactive team member with minimum amount of supervision.
• Excellent written and verbal communication skills.
• Experience in requirement analysis, coding and Peer reviewing teh software development life cycle.
• Proficient in SQL Server, SSIS
• Good Experience in handling large volume of data
• Good experience in T-SQL and ETL scripting, User Defined Functions and Query Optimization.
• Strong analytical skills with proficiency in debugging and problem solving
• Working directly with business users to define QlikView Dashboards applications.
• Designing, developing, Unit testing, debugging, and implementing QlikView solutions based upon specified requirement.
• Maintenance of data in form of QlikView data files, pulling teh data from teh relevant database.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS
• Experience in generating reports using SQL Server Reporting Services
• Created Parameterized reports, Drill down reports using SSRS.
• Good Knowledge in Star Schema Modeling, Snow-Flake Modeling for Fact and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using MDX queries, Perspectives and roles
• Knowledge in writing MDX queries using Tuples and sets
• Experience in SSAS Cube Partitions
• Knowledge in Processing Cube Data
• Experience in Automating teh Cubes using SQL Server Agents
• Deployment activities in Stage, UAT and Production Servers of both ETLs, Views and Qlik files using Azure Pipelines.
• Providing support to teh team members for all teh tasks and by fixes teh complex issues.
• Knowledge in writing DAX queries for summarizing data using filters

TECHNICAL SKILLS

Database Technologies: Microsoft SQL Server

Programming Tools/Skills: SQL Programming

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: Qlik Reports, SQL Server Reporting Services (SSRS)

Analytical Tools: Microsoft SQL Server Analysis Services (SSAS)

Cloud Technologies: Azure DevOps, Azure Pipelines

Other Skills: Scrum, Waterfall, GitHub

Modules: HRMS, ERP

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

SQL & MSBI Developer

Responsibilities:

• Writing SQL views with respect to teh expected frequency run to generate end data for business report.
• Creating complex ETL Logic which run on daily, weekly and monthly basis to pull data of Confidential employee's Journey
• Develop SSIS packages for fetching data from different server, in spite of any formats and columns client provide.
• Worked in SSIS Task as Table difference, lookup, variables, Merge and union.
• Handled performance improvement by adding index, tuning SQL joins Logic, improving statistics time/IO.
• Analyzing teh performance on teh execution plans.
• Involved in data visualization and Analytics through Qlik
• Maintaining TFS for each deliverables post every Sprint deployment in Azure.
• Designing, developing, testing, debugging and implementing teh QlikView solutions based upon specified requirement.
• Peer reviewing teh scripts and SSIS packages from teh team.
• Debugging teh Issues in teh ETL logics and providing teh detailed reports on teh business calls
• Worked on Star Schema Modeling, Snow-Flake Modeling for fact and Dimensions Tables using Analysis Services for teh employee roles that are created
• Developed Cubes using SSAS and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX)
• Performed named Queries for teh fact Table data of teh Roles as per teh snapshot dates
• Involved in Deploying Activities of teh cubes
• Generating reports using SQL Server Reporting Services with Data source and Data set for chart controls
• Created Tablix and Matrix report for teh Fact attributes
• Created SSRS reports using groups and drill down reports for teh Roles opened and created
• Working on Reports by sorting teh data using snapshot dates
• Involved in all teh calls with teh clients and given KT to teh team members
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views
• Agile development software to report bugs and to track teh status of User Stories and participated in Scrum calls every day
• Various clustered/non-clustered indexes, triggers, check constraints and functions
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation

Environment: MS SQL 2016/2019, SSIS 2016/2019,SSAS 2016,SSRS 2017

Confidential

Software Engineer

Responsibilities:

• Develop packages for importing data to DB, in spite of any formats and columns client provide.
• Involved in creating SSIS packages and writing Query’s to pull data and display data for mailing houses for processing teh label issues
• Designed and Implemented Tables, Functions, Stored Procedures and Views.
• Has worked on SSIS package to migrating data from all type of subscription order to our system.
• Customizing teh Stored procedures and package as per time being bespoke issues
• Performance tuning of existing stored procedures.
• Writing SQL stored procedures, functions and triggers to implement business rules of a product.
• Scheduling SSIS packages in SQL Server agent.
• Analysis & implementation of better performance strategies.
• Experience in Scheduling teh jobs in SQL Server Agent
• Develop SQL scripts, T-SQL, Indexes, and complex queries.
• Peer reviewing teh scripts and SSIS packages from teh team
• Involved in usage of various SSIS components like Slowly Changing Dimension, Conditional Split, Merge, Merge Join, Multicast, Union All, Sort, Derived column, SQL execution task, Variables, and Error Handling before loading data into teh Data warehouse.
• Used various SSIS tasks such as Data Conversion, Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
• Deployment using XMLA scripts
• Created Tabular models using related Tables
• Knowledge in writing MDX queries with members and measures, Tuples and sets
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all

Environment: SQL Server 2016, SSIS 2016,SSAS 2016

Confidential

SQL Developer

Responsibilities:

• Wrote stored Procedures for Travel request screen
• Sequel scripts for calculating Reimbursement eligibility .
• Analyzing teh requirements and developed teh code within teh stimulated time
• Wrote Stored Procedures For payroll, Workflow with all logic functions and mathematical calculation.
• Handled logic rule using all T-SQL,SQL query like joins, function, Index, sub query, loops, cursor .
• Handled dead lock issue and performance by tuning teh query with indexes.
• Handled DB mailer logic using SQL script for absent employees
• Trigger logic for Employee travel request
• Perform normalization of database.
• Performance tuning of existing stored procedures.
• Worked on teh payroll system, Created Stored Proc Logic and Calculations for Each pay elements
• Developed ETL Package with different Data sources (Flat file, Excel source etc) and loaded teh data into teh Target Tables by performing different kinds of transformations using SSIS
• Experience in Error Handling using event handler in SSIS Packages
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.
• Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all

Environment: SQL Server 2012, SSIS 2012

Confidential

SQL Developer

Responsibilities:

• Wrote Procedures in Leave Management, Workflow Approval, Payroll per Base logic of Ramco Systems
• Handled stored procedures for logic rule for Leave Entitlements, and leave carry forward logic. work flow logic for leave Routing Claim amount Routing logic are handled.
• Handled teh Scheduler logic for leave pending Approval.
• Handled stored procedures for Absconding employees and Schedulers logic.
• Handled automatic DB mailer logic for teh employees who were absconded
• Develop T-SQL, and complex queries.
• Perform quality assurance and testing of SQL server environment.
• Responsible for development of stored procedures, functions and database Triggers.
• Created indexes and analyzed its role for optimizations
• Created complex report scripts using correlated sub queries.
• Using ETL Tool generated Flat file using ADO.net connection
• Involved in Extracting teh Excel and csv files from specific source using ETL

Environment: SQL Server 2012, SSIS 2012

Confidential

Project Trainee/Report Developer

Responsibilities:

• Developed views, stored procedures and triggers.
• Proficient in writing T-SQL scripts
• Involved in writing scripts with DDL, DML statements in MS SQL database.
• Proficient in writing stored procedures with all SQL developing scripts like joins, function, looping, CTE, cursors, sub queries, views.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Has Tuned teh Stored procedures with proper Index & constraints and resolved teh deadlock issue by deadlock graph using profiler traces.
• Has Ability to debug teh issue by statement level traces.
• Has worked in IEDK Reports and iREPORTS.
• Designed and developed critical screens and Reports as per Requirements of customer.
• Has provided teh core user training and gave technical support till teh end of teh sign off.
• Done testing and prepared Test Case results for teh Change request and released teh same as per teh agreed schedules.
• Using DW developed teh Reports for Customers invoices, and handled teh Sp’s logics
• Using IEDK TOOL has customized teh screen as per teh customers’ Requirements
• Scheduling teh stored procedures in SQL Server Agent Jobs
• Handled User defined functions for teh purchase request

Environment: SQL Server 2008, IEDK Reports tool, DW EPORTS