SUMMARY

• Microsoft SQL Server Database developer with 9+ years of experience in Software Development and 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 the new incident scenarios for Team usage and documenting User stories of each sprint.
• Modified the existing ETLs using SSIS
• Experience in Database performance optimization, debugging and tuning using the 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 the 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 the data from the 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 the 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 the team members for all the tasks and by fixes the complex issues.
• Knowledge in writing DAX queries for summarizing data using filters
• Knowledge in running Control M SSIS Jobs

TECHNICAL SKILLS

Database Technologies: SQL Server 2008/2012/2016/2019

Development Languages: MS SQL, MDX,DAX queries

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, Control M Jobs

Domain Knowledge: HRMS, ERP, Subscriptions

Source control: TFS, Source Safe, GIT

Server: SQL, SSIS Server, SSAS Server

Additional Tool: Service now

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior SQL Server & MSBI Developer

Responsibilities:

• Writing SQL views with respect to the 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 the performance on the 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 the QlikView solutions based upon specified requirement.
• Peer reviewing the scripts and SSIS packages from the team.
• Debugging the Issues in the ETL logics and providing the detailed reports on the business calls
• Worked on Star Schema Modeling, Snow-Flake Modeling for fact and Dimensions Tables using Analysis Services for the 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 the fact Table data of the Roles as per the snapshot dates
• Involved in Deploying Activities of the cubes
• Generating reports using SQL Server Reporting Services with Data source and Data set for chart controls
• Created Tablix and Matrix report for the Fact attributes
• Created SSRS reports using groups and drill down reports for the Roles opened and created
• Working on Reports by sorting the data using snapshot dates
• Involved in all the calls with the clients and given KT to the 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 the 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 the label issues
• Designed and Implemented Tables, Functions, Stored Procedures and Views.
• Have worked on SSIS package to migrating data from all type of subscription order to our system.
• Customizing the 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 the jobs in SQL Server Agent
• Develop SQL scripts, T-SQL, Indexes, and complex queries.
• Peer reviewing the scripts and SSIS packages from the 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 the 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 the data into the 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 the requirements and developed the code within the 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 the 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 the 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 the data into the 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 the Scheduler logic for leave pending Approval.
• Handled stored procedures for Absconding employees and Schedulers logic.
• Handled automatic DB mailer logic for the 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 the Excel and csv files from specific source using ETL
• Handled expressions using ADO connection string

Environment: SQL Server 2012, Profiler,SSIS 2012

Confidential

Programmer/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.
• Have Tuned the Stored procedures with proper Index & constraints and resolved the deadlock issue by deadlock graph using profiler traces.
• Have Ability to debug the issue by statement level traces.
• Have worked in IEDK Reports and iREPORTS.
• Designed and developed critical screens and Reports as per Requirements of customer.
• Have provided the core user training and gave technical support till the end of the sign off.
• Done testing and prepared Test Case results for the Change request and released the same as per the agreed schedules.
• Using DW developed the Reports for Customers invoices, and handled the Sp’s logics
• Using IEDK TOOL have customized the screen as per the customers’ Requirements
• Scheduling the stored procedures in SQL Server Agent Jobs
• Handled User defined functions for the purchase request

Environment: SQL Server 2008, Profiler,DW EPORTS

Confidential

Programmer

Responsibilities:

• Developed views, stored procedures.
• Developing Index to the Tables
• Involved in writing SQL Functions for Calculating stocks.
• Developed Scripts using Joins, Subquery
• Created Scheduler Jobs using SQL Server Agent to pull the total Stock for the period
• Involved in writing CTE Scripts and designing databases objects

Environment: SQL Server 2008, SQL Server Agent Jobs