Sql Server Software Engineer

SQL& MSBIDEVELOPER

Jhansi Y

CAREEROBJECTIVE

Willing to work under challenging and professional environment with exposure to new Technologies as an SQL and MSBI developer in the area of SQL SERVER 2012/2016 with Enterprise Portal and where there is Ample scope for Organizational growth as well as individual growth.

EXPERIENCESUMMARY

Overall experience of about 5 years on Microsoft SQL Server Business Intelligencedevelopmentand implementation.

Experience in creating of Primary key and foreign key relationships and all kind ofConstraints.

ExpertinUsingSetOperatorsandJoins.

Having strong Experience in using String functions, Aggregate functions, Rank Datefunctions.

Good Experience in the creating different kind of Indexes like Clustered Index,Non-clustered Indexandimprovethe performanceof queries.

HavinggoodExperienceincreatingofTemporaryTablesandTableVariablesandCTE.

HavinggoodknowledgeonbackupandrestoringtheDatabase.

ExpertiseincreatingSimpleandcomplexviews.

GoodexperienceincreatingStoredProcedureanduserdefinedfunction.

GoodexperienceinTuningthequeriesandqueryoptimizationinstored procedure.

GoodexperienceincreatingSQLjobsusingServerAzureandalsousingSQLProfiler.

Goodincreatingandmaintainingviews,SynonymsandTriggers.

GoodExperienceinExtraction,TransformationandLoading(ETL)usingSSIStool.

Designed and developed SSIS Packages to extract data from various data sources Suchas Access database and flat files into SQL server 2012/16 for further Reporting by usingmultiple transformations provided by SSIS such as For loop Container, For Each loopcontainer,DataFlowTask,FTPtask,ExecuteSQLTaskinDesigningpackages.

I have used many Transformations to manipulate the datalike Lookup, Fuzzy lookup,Conditional Split, Derived Column, Union All, Merge, Merge join, SCD, DataconversionsandOLEDBCommandstoloadData intoSQLServerdestinations.

ExperienceinusingSSISloggings,Checkpoints,Breakpoints,andPackageconfiguration.

Good experience in deploying the Packages and Scheduling through SQL server. Toautomatethe process.

Expert in creating tables and Matrix reports and perform groupings and expressions onthereport.

I have experience in developing Drill Down, Drill Through, Cascading, Sub report,Parameterizedreports.

Handsonexperienceindeployingthe ReportServerandcreatingreportslike

Snapshot,Cache,LinkedReportsinReportManager.

WorkedonSubscriptionstoschedulethedaily,monthlyandyearlyreports.

WORKEXPERIENCE

Working as a Senior Software Engineer at Aparajita Consultancy Services since 2020 to till date

EDUCATIONALPROFILE: Bsc computer science (Vikram Simhapuri Univercity)

ITSKILLS

Databases :SQLServer2012,2016.

ETL Tool :SQLServer2015IntegrationServices.

Reporting Tool :SQLServer2015ReportingServices.

Languages :SQLandT-SQL

OperatingSystems:WindowsXP,10

PROJECT#1:DETAILS

Role :SQL,SSISandSSRSDeveloper

Environment : Windows 2007 platform with Microsoft Business Intelligence Tools,SQLServer 2016,2019.

Description: ThoughtFocus is a US-based privately held company. Funded by Blackstone.ThoughtFocus serves a range of Industries including financial services and Manufacturing. Thecompany’s innovation services division also caters for clients in higher education, the non-profitsectorandprofessionalservices.

Responsibilities:

Involved in modifying existing SQL Server objects like tables, Views, Functions, storedproceduresandalsocreatednewSQLobjects.

Used joins, temp tables, table variables, CTE for the complex queries involving multipletables and generated stored procedures which load data from multiple tables to singletableindatamart.

InvolvedindebuggingofcomplexT-SQLproceduresanddevelopedvarioustables,

views,storedprocedures,functions whichareusedforspatialreporting.

Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL)Packages.

CreationofnewReportsusingSSRS.

GeneratedtheDrilldownReports,DrillthroughreportsandSubreports.

Investigatingtheerrorandtrytosolveissuesonexistingreports.

Workedonproductionsupportforreports.

PROJECT#2:DETAILS

Role :AssociateSoftwareEngineer

Environment : Windows 2007 platform with Microsoft Business Intelligence Tools,SQLServer 2016,2019.

Description: ITC infotech is a leading global technology services and solutions provider, lead bybusiness and technology consulting. ITC Infotech provides business-friendly solutions to helpclients succeed and be future-ready by seamlessly bringing together digital expertise, strongindustry specific alliances and the unique ability to leverage deep domain expertise from ITCgroup business. The company provides technology solutions and services to enterprises acrossindustries such as Banking and Financial services, Healthcare, Manufacturing, consumer goods.Travel and hospitality, through a combination of traditional and newer business models, as along-termsustainablepartner.

Responsibilities:

Created complex packages to import the data and cleaning the data beforemanipulatingusingSQLserver integratingservices (SSIS).

Collecting data from different stores in different formats like Excel, Flat files andimportingto tables.

Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL)Packages.

Manipulating the data using Views, Ranking Function, Date Functions and some UserDefinedfunctions.

CreationofnewReportsusingSSRS.

AsperrequirementdevelopedthereportsintheformofMatrix,TableusingSSRS.

Used joins, temp tables, table variables, CTE for the complex queries involving multipletables and generated stored procedures which load data from multiple tables to singletableindata mart.

InvolvedindebuggingofcomplexT-SQLproceduresanddevelopedvarioustables,

views,storedprocedures,functionswhichareusedforspatialreporting.

Investigatingtheerrorandtryto solveissuesonexistingreports.

Workedonproductionsupportforreports.

SchedulingtheSSISpackagesandjobs.

Performed the task of data transfer from files in remote server to folders in anotherserverusingFTP.

Contact this candidate