PROFESSIONALSUMMARY:

• 7+yearsofITexperienceinDatabaseAdministration,Design,Development&SupportofMSSQLSevers2008,2005,2000andBI,DatabaseDevelopment,Design(DTS,SSIS,SSRS,SSAS)withvariousbusinessdomainslikebanking,insurance,manufacturingandhealthcare.
• RelationalDatabaseManagementSystem(RDMS),DataWarehouseConcepts,OLTP&OLAPandexperiencewithMSSQLServerinwritingT-SQL.
• ExtensiveworkingexperienceinNormalizationandDe-NormalizationtechniquesforbothOLTPandOLAPsystemsincreatingDatabaseObjectsliketables,Constraints(Primarykey,ForeignKey,Unique,Default),Indexes.
• ExtensiveexperiencewithSQLServerandT-SQLinconstructingtables,views,triggers(DDL/DML),indexes,joins,constraints(keys)withtheirintegrity,functions,storedprocedures,userprofiles,relationaldatabasemodels,anddatadictionary.

• ProficientinwritingT-SQLQueries,sub-queriesandcomplexjoinsforgeneratingComplexStoredProcedures,Triggers,User-definedFunctions,ViewsandCursors.
• ExperienceinusingrecursiveCTEs,CTE,temptablesandeffectiveDDL/DMLTriggerstofacilitateefficientdatamanipulationanddataconsistencyaswellastosupporttheexistingapplications.
• ExperienceinDataExtraction,TransformingandLoading(ETL)usingvarioustoolssuchasSQLServerIntegrationServices(SSIS2005/2008),DTS,BulkInsertandBulkCopyProgramutility.
• Experienceincreatingjobs,EmailAlerts,SQLMailAgent,andScheduleSSIS/DTSPackages.
• WorkedwithFlatfile,Excelfile,andSQLserverOLEDBdestinationsforloadingdata.
• CreatedmanycomplexSSISpackageswithcomplicatedtransformationslikeLookup,DerivedColumn,ConditionSplit,Multicast,Sort,UnionAll,CacheTransform,andConditionalSplitetc
• ThoroughKnowledgeofvariousSSISObjectssuchasDataflowComponents,ControlFlowElements,ConnectionManagers,RuntimeEvents,LogProvidersetc
• ProficientindesigningDataMartandDataWarehouseusingStarandSnowflakeSchemas
• ExperienceincreatingOLAPcubes,identifyingdimensions,attributes,hierarchiesandcalculatingmeasuresanddimensionmembersinSQLServerAnalysisServices
• StrongExperienceincreatingAdHoc,parameterizedreports,Linkedreports,Snapshots,DrilldownandDrillthroughreportsusingSQLSSRS2005/2008
• CreatedvariousSSRSReportsinvolvingvarietyoffeatureslikeReports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valuedparametersetc

EDUCATION:
BachelorofTechnology,Confidential,University,India
TECHNICALSKILLS:

MicrosoftSQLServer2008,2005,2000,7.0,MS-Access

ProgrammingLanguages

C,C++,C#,SQL,T-SQL,VB.NET

ReportingTools

SQLServerReportingServices(2000,2005,2008),CrystalReports

DataModelingTools

Erwin4.0,Vision2002

OperatingSystem

WindowsXP/NT/2000/2003/Vista.

Tools

SQLServerManagementStudio,BusinessIntelligenceDevelopmentStudio,SQLServerProfiler,QueryAnalyzer

BITools

SQLServerIntegrationServices(SSIS),SQLServerReportingServices(SSRS),SQLServerAnalysisService(SSAS),CrystalReporting

PROFESSIONALEXPERIENCE

Confidential,SanDiego,CANov2011-TillDateSQLServerDeveloper

Responsibilities:

• ImplementedComplexbusinesslogicwithUser-Defined-Functions,Index,ViewsandalsocreatedUserDefinedDatatype,Clustered&Non-clusteredIndexes.
• Analysis,DesignanddatamodelingofLogicalandPhysicaldatabaseusingE-Rdiagrams.
• InvolvedindatabaseSchemadesignanddevelopment.
• Design/BuildExtractTransformLoadproceduresinSQLServer2000/2005/2008usingDTSpackagestoimport/exportdatafeedsto/fromdatawarehouseandclaimsystems.
• CreatednewdatabaseobjectslikeProcedures,Functions,Packages,Triggers,IndexesandViewsusingT-SQLinDevelopmentandProductionenvironmentforSQLServer2000/2005/2008.
• Analyze,tuningandoptimizingforSQLServerApplicationsbyusingperformancemonitor.
• ExperienceintuningofStoredProceduresandqueryoptimizationtoimprovetheperformanceandeliminatethedeadlocksituationsandhang-upsonserver.
• WorkedincreatingcomplexStoredProcedures,triggers,cursors,tables,views,joinsandstatementsforapplications.DevelopedcomplexT-SQLcodefortheapplication.
• CreatedSSISpackagestopulldatafromtextfiles,XMLfiles,SQLserverandexcelandexportedtoexcelspreadsheets,flatfilesandviceversa.
• DevelopedSubReports,MatrixReports,Charts,andDrilldownreports,AdHocreportsusingSQLServerReportingServices(SSRS).
• Highlyinvolvedincreating,structuring,formattingusingReportDesignerandReportBuilder.
• Workedonqueryingdataandcreatingon-demandreportsusingReportBuilderinSSRSreportsandsendthereportsviaemail.
• DesignedandcreatedReporttemplates,bargraphsandpiechartsbasedonthefinancialdata.
• Createdcascading(collapsed)parameterstoareport,andaddedreportparametersthatcanbeusedinuser-definedfunction.
• Developeddifferenttypesoftabularreports,matrixreports(crosstaborpivot)reports,chartandgraphs,reportsthataggregatedatausingSQLServerReportingServices.
• CreatedSSISPackagesusingPivotTransformation,FuzzyLookup,DerivedColumns,ConditionSplit,Termextraction,Aggregate,ExecuteSQLTask,DataFlowTask,ExecutePackageTasketctogenerateunderlyingdataforthereportsandtoexportcleaneddatafromExcelSpreadsheets,Textfile,MSAccessandCSVfilestodatawarehouse.
• WorkedonerrorhandlingusingtryandcatchblocksandperformancetuningusingcountersinSSIS.
• Developed,deployedandmonitoredSSISPackagesincludingupgradingDTStoSSIS.
• DatabaseandLogBackupsandrestoration,backupstrategies,schedulingbackups.

Environment:SQLServer2005/2008,MSAccess,EXCEL,VBScript,C#,HTML,XML,Visio,WindowsServer2000/2003,ASP.NET,VB.NET,BIDS.

Confidential,Boston,MAJun2010-Oct2011SQLServerDeveloper

Responsibilities:

• Involvedinrequirementsgathering,analysis,design,developmentanddeployment
• Createdvariousdatabaseobjects(tables,indexes,views,storedprocedures,SQLjoinsandtriggers),andimplementedintegrityconstraintsforenforcingdataintegrity
• CreatedSSISpackagestomigrateslowlychangingdimensions
• DesignedSSISPackagestotransferdatafromflatfilestoSQLServerusingBusinessIntelligenceDevelopmentStudio
• Responsibleforlogicalandphysicaldatamodeling,dataanalysis,programming,documentationandimplementation.
• IndexeswerereorganizedorrecreatedandSQLqueriesweremodifiedforfineperformancetuning.
• DevelopedSSISpackageswithdifferentdatasources(SQLserver,flatfiles,andexcelsourcefiles)andloadedthedataintotargettables.
• ExtensivelyusedSSIStransformationssuchasLookup,Derivedcolumn,Dataconversion,Aggregate,Conditionalsplit,SQLtask,ScripttaskandSendMailtasketc
• WorkingknowledgeinDatamodeling,creatingstarandsnowflakeschemasinSSAS
• Developedcomplexcalculatedmembers,NamedSetsusingMDXexpressionsforspecificOLAPreportingrequirements
• Optimizedcubesforbetterqueryperformance
• GeneratedsomereportsusingSSRS(SQLServerReportingServices)2005/2008fromOLTPandOLAPdatasources.
• DesignedanddeployedreportwithDrillDown,DrillThrough,Dropdownmenuoption,ParameterizedandLinkedreportsusingSSRS
• UsedExecutionPlan,SQLProfilerandDatabaseEngineTuningAdvisortooptimizequeriesandenhancetheperformanceofdatabases

Environment:MSSQLServer2005/2008,SQLServerIntegrationservices(SSIS),SQLServerReportingServices(SSRS),BIDS,VisualStudio2005/2008,andWindows2003.

Confidential,PAApr2009-May2010SSISandSSRSDeveloper

Responsibilities:

• Responsiblefordevelopingprocesses,automationofmaintenancejobs,tuningSQLServer,locksandindexesconfigurations,administeringSQLServersecurity,SQLServerautomatice-mailnotificationandSQLServerbackupstrategyandautomation
• HighlyusedT-SQLfordevelopingcomplexStoredProcedures,TriggersandUserDefinedFunctions,Views,Indexes.
• UsedSQLProfiler,SystemMonitor,QueryAnalyzerforTroubleshooting,Monitoring,OptimizationandTuningofSQLServer.
• MigratedDTS2000packagestoSQLServerIntegrationServices(SSIS)packagesandalsomodifiedthepackagesaccordinglyusingthenewfeaturesofSQLServerIntegrationServices.
• ExtensivelyinvolvedindesigningtheSSISpackagestoexportdataofheterogeneousdata(likeXML,Excel,CSV,PGP,Flatfile)sourcetostagingtablesinSQLServerDatabase.
• CreatedSSISpackagesusingvariousTransformationsforexportdatafromdifferentdatasourcesandTransformeddataandloadittoSQLServer2005.
• UsedSSISpackageConfiguration,changingthevariablesdynamicallyandSSISlogging.
• ResponsibleforDeploying,Schedulingjobs,AlertingandMaintainingSSISpackages.
• CreatedandConfiguredOLAPCubes(StarSchemaandSnowflakeSchema)UsingSQLServerAnalysisServices.
• ResponsibleforFullReportcycleincludingAuthoring,Managing,SecurityandGenerationofreports.
• DevelopedQueryforgeneratingdrilldown,drillthrough,parameterized,cascadedreportsinSSRS2005.
• Backingup,Restoringsystem&otherdatabasesasperrequirements,andalsoscheduledthosebackups.
• Managingthesecurityoftheservers,creatingthenewloginsandusers,changingtherolesoftheusers.

Environment:MSSQLServer2005,MSSQLServer2000,MSSQLServerIntegrationServices(SSIS),MSSQLServerAnalysisServices(SSAS),MSSQLServerReportingServices(SSRS),MSAccess,WindowsXP,VB,C#,Oracle,T-SQL,QueryAnalyzer.

Confidential,ChicagoAug2008-Mar2009BIDeveloper(SSIS,SSRS,SSAS

Responsibilities:

• Gatheredbusinessrequirements,definitionanddesignofthedatasourcinganddataflows,dataqualityanalysis
• Responsibleforcreatingdatabases,tables,cluster/non-clusterindex,unique/checkconstraints,views,storedprocedures,triggers,rulesanddefaults.
• UsedSQLProfilerandQueryAnalyzertooptimizequeriesandstoredprocedures
• DevelopedSSISpackagestoloaddatafromExcelfiletoSQLServerDatabase
• Usedcustomloggingtohavemoredetailedinformationoftheworkflow
• Monitoringandoptimizingtheperformanceofdatabaseviaindextuningwizard,performancemonitorandSQLprofiler.
• ExtensivelyusedScriptComponenttodorowbyrowprocessing,performvalidationsaspertherequirement
• DeployedSSISpackagesandReportstoProductionServers
• Involvedinlogicalandphysicaldesignofdatabase.
• ScheduledCubeProcessingfromStagingDatabaseTablesusingSQLServerAgentinSSAS
• WorkingknowledgeinDatamodeling,creatingstarandsnowflakeschemasinSSAS
• DesigningandimplementingavarietyofSSRSreportssuchasParameterized,Drilldown,AdhocandSub-reportsusingReportDesignerandReportBuilderbasedontherequirements
• DeployingandschedulingReportsusingSSRStogeneratealldaily,weekly,monthlyandquarterlyReportsincludingcurrentstatus
• Involvedindocumentationofwholeprojectmajorlywhichhelpsthesupportingteam

Environment:MSSQLServer2005,SSAS2005,SSRS2005,SSIS2005,T-SQL,Visualstudio2005,DTS,DataAnalyzer,SQLServerBusinessIntelligenceDevelopmentStudio,MSAccess,Excel,SQLProfiler,WindowsXP,VSS2005

Confidential,Louisville,KYSept2007-July2008SQLServerDeveloper

Responsibilities:

• CreatednewdatabaseobjectslikeProcedures,Functions,Packages,Triggers,IndexesandViewsusingT-SQLinDevelopmentandProductionenvironmentforSQLServer.
• DevelopedDatabaseTriggerstoenforceDataintegrityandadditionalReferentialIntegrity.
• WroteDDL,DMLstatementsforprocessingofdailyactivities.
• DevelopedSQLQueriestofetchcomplexdatafromdifferenttablesinremotedatabasesusingjoins,databaselinksandformattedtheresultsintoreportsandkeptlogs.
• ResponsibleforupgradingandmigratingofvariousapplicationsinAccesstoSQLServer7.0.
• SQLServerAdministrationinvolvingplanningandimplementingBackupandRecoveryStrategies
• Configuringthestandbyserversandsettingguidelinestoautomaterecoveryscenarios
• ImplementationofdatatransferthroughDTS
• MonitoringandfinetuningofSQLServerperformanceandensuringintegrity
• InvolvedinperformancetuningandmonitoringofbothT-SQLandPL/SQLblocks.
• UsedSQLProfilerandQueryAnalyzertooptimizeDTSpackagequeriesandstoredprocedures
• WroteT-SQLprocedurestogenerateDMLscriptsthatmodifieddatabaseobjectsdynamicallybasedonuserinputs
• CreatedStoredProcedurestotransformthedataandworkedextensivelyinT-SQLforvariousneedsofthetransformationswhileloadingthedata
• Involvedperformancetuningusingindexing(ClusterIndex,NonCluster)tables.

Environment:T-SQL,SQLServer2000,OLAPServices,Windows2000Server,BusinessIntelligenceSuite,SSIS,SSRS,SSAS,QueryAnalyzer,DTS,MSAccess2000,VB.net2003,ErwinDataModeler