jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary possesses extensive proficiency highlyskilled sqlssisssrspower bi developer 6 years industry experience demonstrates strong command sql server 2012201420162019 database design development consistently delivering robust scalable solutions exhibits exceptional expertise tsql scripting proficiently crafting stored procedures functions triggers accommodate intricate business logic displays exceptional aptitude query optimization performance tuning ensuring expeditious efficient data retrieval processes demonstrates advanced proficiency implementing data modeling techniques expertly applying normalization denormalization strategies tailored specific use cases possesses handson experience sql server integration services ssis adeptly developing etl processes streamline data integration workflows showcases expertlevel proficiency ssis package deployment management ensuring flawless execution etl processes utilizes comprehensive knowledge ssis components data transformation cleansing maintaining impeccable data quality accuracy displays high level competence sql server reporting services ssrs report creation management enabling timely accurate delivery insights demonstrates extensive experience designing parameterized drilldown ad hoc reports customized meet specific business requirements proficiently integrates power bi interactive data visualization facilitating intuitive data exploration analysis possesses advanced knowledge sql server analysis services ssas multidimensional tabular data modeling elevating analytical capabilities exhibits expertise utilizing mdx dax query languages advanced data analysis reporting establishes proficiency implementing managing sql server always availability groups ensuring high availability fault tolerance displays adeptness sql server security management safeguarding data integrity robust user role permission management practices possesses extensive knowledge database backup recovery disaster recovery planning mitigating risks minimizing downtime utilizes sql server data tools ssdt efficient database project management collaborative endeavors demonstrates handson experience azure sql database azure synapse analytics effectively leveraging cloudbased solutions enhance scalability performance familiarity sql server linux containerization using docker enabling support diverse deployment scenarios proficiently utilizes git visual studio team services vsts version control facilitating effective collaboration streamlining development workflows skills database technologies sql server mysql oracle azure sql database amazon rds query languages tsql plsql etl tools sql server integration services ssis reporting tools sql server reporting services ssrs power bi data analysis sql server analysis services ssas dax expressions data governance sql server master data services mds data quality services dqs performance tuning sql server profiler execution plans indexing strategies experience sql developer 122019 current louisiana state university baton rouge la database security user authentication rolebased access control data encryption high availability log shipping always availability groups replication version control git svn project management jira trello confluence agile methodologies scrum kanban operating systems windows linux cloud platforms microsoft azure amazon web services aws designing developing implementing endtoend business intelligence solutions using msbi suites including sql server integration services ssis sql server analysis services ssas sql server reporting services ssrs creating enhancing various reports ssrs drilldown drill subreports list tabular matrix navigation reports standard parameter cascading parameter multivalue parameters performing database development tasks including schema development creating stored procedures utilized different windows services implementing dynamicity flexibility using ssis variables parameters expressions create adaptable master etl packages connection managers tasks containers send mail row count script tasks etc monitoring maintaining existing etl packages reports troubleshooting resolving issues bugs required managing maintaining data warehouse creating etl jobs developing new database objects designing ssis packages writing maintaining sql scripts creation database objects designing implementing etl packages load data files databases performing various transformations using ssis participating design dashboards including data warehouse table design source target etl logic dashboard development writing tsql programming code implement stored procedures functions triggers different tasks ensuring data referential integrity writing optimizing tsql queries batch scripts stored procedures improved performance including tuning query optimization conducting performance tuning optimization procedures queries existing database objects utilizing tsql development techniques joins subqueries ranking functions derived tables common table expressions ctes stored procedures views constraints database triggers connecting integrating different data sources like sql db sql query tabular model dax query web trends power bi generate reports various visualizations participating code reviews contributing preparation unit test cases generating custom etl scripts using ssis developing conducting unit tests ssis load processes ensure performance creating scheduling ssis packages jobs automatic execution cube processing data loading extracting transforming loading etl data homogeneous heterogeneous systems using sql tools like ssis data transformation services dts bulk insert bcp xml utilizing sql server reporting services ssrs extensive reporting tasks automating tasks operations using azure relevant operational tools creating data models module current oltp system actively participating brainstorming sessions address design challenges conducting unit system testing troubleshooting resolving issues performing bug fixing development qa environments utilizing team foundation server tfs task management version control ssis developer 092017 112020 cognizant technology solutions sacramento ca developed maintained tsqlbased database structures tables stored procedures indexes business rules designed implemented ssis packages seamless data import export across different systems created dynamic reports including drill drill sub reports matrixtabular reports charts graphs collaborated microsoft team foundation server tfs agile task management feature development executed comprehensive extract transform load etl operations using ssis diverse data sources destinations demonstrated expertise working sql server oracle excel files flat files developed complex ssas cubes multiple fact measure groups dimension hierarchies olap reporting led endtoend creation power bi reports delivering impactful visualizations scratch optimized database performance finetuning queries refining database design implementing effective indexing strategies gathered analyzed business requirements ensuring successful solution delivery managed entire ssis lifecycle including package creation building deployment execution participated peer review testing ensure solution quality reliability improved sql script performance optimization techniques query tuning developed complex calculated measures using expressive dax language configured managed sql server analysis services components including data sources data source views cubes dimensions roles hierarchies utilized variety ssis transformations ensure seamless data integration collaborated clients implement requested changes power bi reports dashboards provided expert advice query optimization analysis execution plans orchestrated data migration teradata sql server using bcp ssis sql developer 012015 082017 louisiana state university baton rouge la developing maintaining complex sql queries support business requirements optimizing database performance finetuning sql queries indexing database configuration writing maintaining database documentation including data dictionaries schema diagrams user manuals creating maintaining automated data integration processes different systems databases providing technical support endusers troubleshooting issues identifying solutions developing maintaining data warehousing solutions support business intelligence reporting needs creating maintaining database backups disaster recovery plans ensure business continuity staying uptodate emerging trends technologies database development management optimized query performance eliminating unnecessary columns removing redundant inconsistent data normalizing tables establishing joins creating clusterednonclustered indexes appropriate implemented business rules creating triggers functions indexes tables views sql joins tsql codes conducted performance tuning query optimization using sql profiler resolved realtime deadlock issues databases servers collaborated business analysts identify design implement data extraction integration solutions databases data marts utilizing ssrs data extraction reporting purposes integrated data various sources homogeneous heterogeneous legacy systems sql db2 excel sql server databases generated performancebased reports using ssrs showcasing holdings based measures like time area price range managers utilized ssis tsql stored procedures transfer data oltp databases staging areas subsequently data warehouses developed custom scripts data grids facilitate display data tailored manner established sql server integration service ssis packages transfer data enterprise databases thirdparty data sources performed data migration heterogeneous data sources legacy systems db2 access excel centralized sql server databases designed developed modified enhanced database structures objects updated existing business objects universes accommodate new requirements including addition new universe classes objects newly introduced database entities attributes education training bachelors management information systems 052014 university texas arlington tx