jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary around 7 years extensive experience microsoft sql server 2008r22012201420162019 developer creating business intelligence solutions like ssis ssas ssrs expertise designing implementing relational database model per business needs different domains like manufacturing banking finance healthcare extensive knowledge experience dealing relational database management systems including stored procedures constraints querying joins keys indexes data importexport cursors good understanding normalizing denormalizing tables maintaining referential integrity using triggers primary foreign keys wellorganized goaloriented highly motivated effective team leadermember excellent analytical troubleshooting problemsolving skill projectoriented team player skills technical skills sql server tools sql server management studio ssis ssrs ssas database ms sql server 2019201620142012 oracle language c tsql vbnet operating system windows 1087 sql server 2008r2201220162019 work history 102021 current sr etl developer two95 international inc newark nj tools microsoft visual studio 2016201920132012 share point server microsoft project server 2007 apex sql architecture relational dbms olap oltp reporting tools ssrs sql server reporting services crystal reports powerbi etl tools ssis sql server integration services area project project provides services insurance companies ease data communication home host clients project designed perform etl home host clients upon business validations data transformation per requirement providers host client able raise request information receive response home clients responsibilities working agile environment perform steps sdlc cycle collaborate coordinate team members work source control code repository responsible creating etl process load heterogenous data sources database creating managing schema objects tables views indexes stored procedures triggers maintaining referential integrity created clustered nonclustered indexes tables performance optimization complex stored procedures implemented error handling custom error handling sql server ssis packages using try catch blocks raise error functions stored procedures user defined functions event handlers ssis created ssis packages data various data sources following etl framework architecture experience performance tuning debugging ssis packages also schedule jobs ssis packages run specific routine used various ssis tasks conditional split derived column merge join union union data validation checks staging loading data data warehouse configured ssis packages using parent child configurations allow packages run called parent package parent package configurations worked metadata driven ssis packages pull data various sources load data mart used shared connection managers project parameters project level connection managers designed developed matrix chart tabular reports drill drill dropdown menu ssrs generated consolidated monthly reports budget analysis drive forecast production plan ssrs powerpivot developed complex ssrs reports using multiple data providers global variables expressions user defined objects aggregate aware objects charts synchronized queries made us various tools like tfs github gitbash version control code environment ms sql server 20192016 ssisssrs 2019 ssms team foundation server c net github bitbucket bamboo 032020 102021 sr sql server sql developer virginia retirement system city state investment db restructure etl data restructure project recreate legacy etl jobs ssis packages loading data files external vendors ids datamart creating etl framework implementing data loads within framework writing stored procedures perform data transformations enhancing existing processes better performance responsibilities worked agile environment requirement gathering scrum meeting stand ups iteration planning worked closely stake holders understand business requirements data analysis identifying final deliverables designing etl architecture data integration vendors database system responsible developing maintaining supporting sql applications exporting structured data reports web pages created databases schemas tables clusternoncluster indexes stored procedure views functions various database objects perform data transformation integration according business requirements involved source data analysis design creation data mappings extracting data heterogeneous sources like flat files excel oledb odbc data sources creating complex etl packages following vrs etl framework using ssis extract data staging tables partitioned tables incremental load generate outbound files several formats created parent child packages part framework used ept task configure parent child relationship extensive use ssis components loop container loop container execute sql task dataflow task data transformers lookup fuzzy lookup conditional split merge join union others validate data migrate per requirement performed event handling ssis logging process file logging database logging using events pre execute postexecute failure usage c net attain custom approaches delayed time lookup inbound file call database objects ssis using script task worked development data mart different ssis packages load staging fact dimension metric data data mart automated etl processes using sql server agent job sending email alerts different environments success failures job maintained sql objects ssis packages versions deployed test prod environment package project deployments configured ssis packages using package configurations environment variables provided requirements workflow test cases sourcetotarget mapping testing documentation etl process involved design deployment report models generating adhoc reports per client requirements using sql server reporting services ssrs delivering enterprise webenabled reporting create reports draw content variety data sources created reports ssrs different type properties like chart controls filters interactive sorting sql parameters etc performed unit testing worked closely testing team fix bugs minimal duration prepared documentation unit testing process flow made use various apex sql tool features part development activities better standards environment ms sql server 20192016 ssisssrs 2019 ssms apex sql team foundation server c net 112017 022020 sql server ssis sql developer santander bank city state argus exit project main focus project rebuild argus process generating contributor files fry processing santander environment argus one major vendors process raw data pr miami using monthly quarterly fed reporting golden source consistency goal project perform data comparison different environments send reports guide users maintain data consistency across sources ldm rdm ccmis fmis enhancements working several projects ad hoc existing applications responsibilities gathered functional requirements business requirements wrote technical specifications building highly efficient system involved dailyweekly meetings work collaboratively team members meet deliverables review input files pr miami understand logics create layouts raw data extensively involved code review applying changes existing manual process generating outbound files automatically responsible creating modifying tables stored procedures database objects load validate transform extract data per project requirements involved designing framework validating data consistency among different source environments across organization designed ssis packages transfer data servers load data database archive data file various sources using sql enterprise managerssms sql automated manual data processing generic processes rerun historical data created sql logging table capturing error success logs along sending email notification based run sql server agent job implemented error handling sql server trycatch blocks raise error functions stored procedures user defined functions built ssis packages etl process used different data flow elements like flat file oledb excel sources destinations data flow transformations like data conversion conditional split derived column etc implemented event handlers error handling ssis packages notified process results various user environments performed unit testing effectively fixed bugs prepared detail documentation data mapping process flow running jobs environment ms sql server 20142008r2 ssms ssis ssrs tsql xp cmdshell tortoise svn microsoft office 092015 102017 server ssisssrstsql developer qualcare inc cigna city state qualcare inc health insurance provider new jersey providing healthcare small groups businesses associations large corporations qualcare integration project part data team responsible building ssis sql objects required perform data integration qualcare cigna inc data comprises structure members memberships claims insurance policies responsibilities involved project financial hub responsible build etl scratch generate data extracts multiple tables databases retrieved data frontend application stores groups members claims confidential insurance data insured members database tables performed multiple ddl dml tsql queries stored procedures user defined functions udfs ctes database triggers schemas tables clusternoncluster indexes exception handlers meet business requirements integrate data end clients worked data different databases time using linked server concepts creating complex etl packages using ssis import claims data external sources process multiple files time perform business validation load data database designed etl process payment processing claims generate extracts different banks custom formats validations designed dynamic ssis packages transfer data crossing different platforms validate data data clearing loading archived data files different dbms created script tasks check existence source files specified amount time worked event handlers ssis logging process file logging database logging using events preexecute postexecute failure deployed ssis packages test servers prod servers using tfs automated processes respective servers sing ssis package configurations work development data mart different ssis packages load staging fact dimension metric data data mart eliminating redundancy data organize data efficiently perform error handling processing inbound files generate error summary files transformation performed worked data marts data warehousing operational data store ods olap data modeling like dimensional data modeling star schema modeling snowflake modeling fact dimensions tables using analysis services performed unit testing worked closely testing team fix bugs minimal duration also prepared documentation unit testing process flow using ms visio environment ms sql server 20142012 ssisssrs 2012 tsql advanced server ssms vbnet c windows 2007 team foundation server education 082015 master science mechanical engineering fairfield university fairfield ct 052013 bachelor technology mechanical engineering jawaharlal nehru technological university hyderabad additional information experience using cte recursive ctes temp tables dynamic sql pivot un pivot bcp bulk load facilitate efficient data loading manipulation consistency worked sql profiler perform tuning operation resolve deadlocks improve performance long running queries worked activities related development implementation administration support etl processes largescale data warehouses using ssis 20192016201220082008r2 designed elevated level etl architecture overall data transfer source server enterprise services warehouse encompasses server name database name accounts tables direction data flow data dictionary metadata using ssis experience using several ssis components foreach loop container sequence container vb script task expressions execute sql task variables send mail task package execution task experience performing data manipulation per requirements using look data conversion merge join union derived column conditional split aggregate transformations ssis package data flow experienced data modeling techniques logical physical database design experienced designing prominent level etl architecture creating configuring fine tuning etl workflows overall data transfer oltp olap help ssis experience creating jobs alerts sql mail agent database mail scheduled dts ssis packages expert designing enterprise reports using sql server reporting services ssrs 2012 use multiple value selection parameters pick list cascading prompts matrix dynamics reports features reporting services experience writing expressions ssrs expert fine tuning reports created many drill drill reports using ssrs usage global variables expressions functions reports immense experience handling sub reports ssrs experience designing building dimensions cubes star schema using sql server analysis services ssas created sophisticated calculated members using mdx queries designed created aggregations speed queries improve performance ssas deployed processed ssas cube weekly update information using sql server agent capable forming maintaining positive productive working relationships internal external team environments