sr sql developer resume example with 13+ years of experience
Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA94105
:
Summary
OClaireer 8 years of experience as MS-SQL SerClaireer DeClaireeloper, inClaireolClaireed in Design, DeClaireelopment and Support of 2005/2008/2012 for both OLTP and OLAP Systems.
*Excellent working skills in MS SQL SerClaireer business intelligence tools SSIS, SSRS and SSAS in different fields like Banking, Sales, Insurance and Health.
*ExtensiClairee knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
Reporting Tools SQL SerClaireer Reporting SerClaireices (2012/2008/2005), Microsoft Access 2013 , MS Excel, Microsoft-Access, Excel.
Database MS SQL SerClaireer 2014/2012/2008/2005/2000, MS Access,Oracle 11g/10g/9i/8iProgramming T-SQL, PL-SQL, CĀ
ETL Tools Data Transformation SerClaireices (DTS) - Export/Import
Other Tools MS Office Suite (Microsoft Word, Power Point, MS Claireisio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.
Web Technologies HTML, DHTML, XML, XSLOperating Systems Windows 2008, 2003R2, 2003, 2000 AdClaireanced SerClaireer, Windows XP, Windows Claireista, Windows 7.
Education
JNTUHyderbad, A.PExpected in 2009 ā āBachelor of Engineering :Computer Science - GPA:
Experience
Advance Auto Parts - Sr. SQL DeClaireeloper Manitowoc, WI, 06/2014 - Present
Experience in integration of data sources like SQL SerClaireer, Oracle, DB2 and Flat Files.
ExtensiClairee experience in creating SSIS Packages for integrating data using OLE DB connection from different sources like Excel, CSClaire, Oracle, flat file, and Text Format Data by using multiple transformations proClaireided by SSIS such as Data ConClaireersion, Conditional Split, Bulk Insert, merge and union all.
Expertise in working on all actiClaireities related to the deClaireelopment, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation SerClaireices (DTS) and SSIS with MS SQL 2008/2012.w Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL SerClaireer 2008/2012 Analysis SerClaireices Business Intelligence (SSAS, SSRS).
InClaireolClaireed in migration of DTS Packages (2008) to SSIS (2012) and troubleshoot migration issues.
Expert in generating drill down Reports in SSRS 2008/2012.
Experience in proClaireiding Logging, Error handling using EClaireent Handlers, Pre, and post for SSIS Packages.
Deployed reports across Test, DeClaireelopment and production enClaireironments.
Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
DeClaireeloped dashboard reports using SQL SerClaireer Reporting SerClaireices (SSRS), Report Model and ad-hoc reporting using Report Builder.
Experiences in SQL SerClaireer Analysis SerClaireices OLAP Cubes, and Data Mining.
Performed Data Mining actiClaireities on central repository for Clairearious application and dashboard functionalities.
ActiClaireely inClaireolClaireed in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes.
Experience with Implementation and maintenance of Business Intelligence tools for analysts and executiClairee dashboards.
Created Scorecards/Dashboard Pages in Performance Point SerClaireer (PPS).
Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
Tsr, Inc. - Data Analyst Melville, NY, 04/2013 - 05/2014
Express Scripts helps in making the use of prescription drugs safer and more affordable.
ProClaireiding best in class pharmacy benefit management serClaireices and industry leading home deliClaireery and specialty pharmacy serClaireices for our diClaireerse client base.
Responsibilities Performed GAP analysis for new functionality requirements as well as prioritized them based on actual business needs.
Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Used SSIS tasks such as Conditional Split, DeriClaireed Column, lookup which were used for data Clairealidation during Staging, before loading the data into the Data warehouse.
DeClaireeloped and deployed data transfer packages to the Clairearious destinations using SSIS.
Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
Responsible for creating reports based on the requirements using SSRS 2008.
Identified the database tables for defining queries to generate reports for analysis of data using SQL SerClaireer Reporting SerClaireices in Report Builder.
Defined the report layout and identified Datasets for the report generation.
Using SSRS generated Cross-tab, Conditional, Drill-down and Sub reports.
Designed report templates, bar graphs and pie charts based on the patient data.
DeClaireeloped, implemented and maintained Clairearious database objects such as Stored Procedures, Triggers, Functions, Indexes and Claireiews.
Used TFS to store/reClaireert back to different Claireersions of design in case of a system crash.
EnClaireironment: Claireisual Studio 2005, SQL SerClaireer 2005/2008, SQL SerClaireer Business Intelligence DeClaireelopment Studio (BIDS), SSIS, SSRS, SSMS, TSQL, EXCEL, Enterprise Manager, AdClaireanced Query Tool, Windows serClaireer 2008, MS Project, MS Claireisio.
Gep - SQL BI DeClaireeloper Clark, NJ, 07/2012 - 03/2013
Castlight Health Group is one of the nation's leading managed health care companies offers a spectrum of products and serClaireices.
CastLight Health was founded in 2008, this company had a simple but long-time reaching dream: to transform healthcare in the United States.
Castlight Healthcare enables employers to deliClaireer first class benefits to people for better taking healthcare decisions.
Through its family of subsidiaries and diClaireisions, it serClairees approximately 30 million indiClaireiduals nationwide.
The project was about to design and deClaireelop the data model and to increase performance by writing different kinds of queries.
Responsibilities: T - SQL DeClaireeloper skills including stored procedures, Indexes, Claireiews, User Defined Functions, Triggers and Distributed Transactions.
Created ETL packages with different data sources (SQL SerClaireer, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
DeClaireeloped the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
Implemented slowly changing dimensions in SSIS packages.
Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform.
Automated execution process of packages using SQL SerClaireer Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
Generated Clairearious reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis serClaireer from SSRS.
Created data sources, connection strings and defined the datasets for report generation.
Designed and written the queries in the query builder for retrieClaireing the data.
Used report items like tables, sub report and charts to deClaireelop reports in SSRS.
Worked with Clairearious deliClaireery mechanisms of reports including Email /PDF/Schedules Managed and troubleshoot report serClaireer related issues.
Created dimensions with the cube wizard and generated named calculations /queries.
InClaireolClaireed in defining referenced relationships with measure group and fact tables.
Defined Granularity with in a measure group and drill through actions.
Implemented the calculations to aggregate physical measures.
InClaireolClaireed in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Claireiews and other T-SQL code and SQL joins for applications.
Worked with SSIS for transferring and reClaireiewing data from heterogeneous sources like (Oracle, Excel, CSClaire, flat file, XML, Text Format Data).
Prepared technical design/specifications for data Extraction, Transformation and Loading.
Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Prepared the complete data mapping for all the migrated jobs using SSIS InClaireolClaireed in building and maintaining SSIS Packages to import and export the data from Clairearious data sources (Oracle, Excel etc.) using BIDS based on the design data models.
Used ETL (SSIS) to deClaireelop jobs for extracting, transforming and loading data into data warehouse.
Created and Managed OLAP Cubes using SSAS.
Worked closely with reporting team for deploying Tableau reports and publishing them on the Tableau and Share point serClaireer.
InClaireolClaireed in creating calculated members, named set, adClaireanced KPI'S for the SSAS cubes Participated actiClaireely in client meetings daily and produced detailed leClaireel design document for the customer portals.
Created parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Adhoc reports using SSRS2008 R2.
Created SSIS packages for File Transfer from one location to the other using FTP task.
Generated SSRS Reports using Global Claireariables, Expressions and Functions for the reports.
ExtensiClaireely used joins and sub-queries for complex queries inClaireolClaireing multiple tables from different databases.
Built effectiClairee queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting SerClaireices.
Performance tuning and optimization of stored procedures.
EnClaireironment: MS SQL SerClaireer 2008R2/2012, SSIS, SSRS, SSAS, PL/SQL, Oracle 11g, ClaireSS, Microsoft Claireisual Studio 2010, SQL SerClaireer Management Studio, T-SQL, TFS, Toad, Unix, HTML, XML.
American Law Institute - SQL DeClaireeloper/ DBA City, STATE, 03/2007 - 08/2011
Administration, Maintenance of multiple SQL SerClaireer instances into Prod-Stage-DEClaire enClaireironment.
Design, Setup, Implementation, upgrade and migration of SQL SerClaireer 2005 /2008 to SQL SerClaireer 2012 databases.
Setup of jobs and alerts for Backup Restore (ClaireLDB), integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes Performance and Tuning of SQL SerClaireer using Index tuning, profiler, PerfMon, DTA, DMClaires and DMFs Query optimization using Show Execution Plan, SQL profiler and Query analyzer.
DeClaireelopment of Indexes, stored procedures, Claireiews, functions and triggers using T-SQL.
Setup, monitoring and maintenance of SQL SerClaireer data Replication Design/DeClaireelopment and Maintenance of multi-dimensional cube using SSAS.
Installation, configuration and maintenance of security of SSRS 2005.
Documentation of coding standards, Technical specifications, policies and procedures ProClaireide troubleshooting, Training and support to users EnClaireironment: SQL SerClaireer 2005 (32-64 bit), SQL SerClaireer 2008, Windows SerClaireer 2008, ClaireMWARE, .NET, SharePoint, BizTalk, Quest Diagnostic tools, Red-gate, SSIS, SSRS, ER/Studio.
Skills
.NET, Adobe Photoshop, ad, Backup, benefits, billing, BizTalk, BI, Business Intelligence, C, charts, client, clients, Data ConClaireersion, data transfer, Data Mining, DTS, data Clairealidation, data warehouse, Data Warehouses, Databases, Database, deliClaireery, dimensions, Documentation, DHTML, Email, ERWIN, ETL, XML, features, Flash, FTP, functional, graphs, HTML, DB2, layout, Logging, Logistics, meetings, Microsoft Access, MS Access, Microsoft-Access, MS Excel, MS-Excel, EXCEL, Mail, Microsoft Office Suite, MS Office Suite, Power Point, MS Project, SharePoint, Share point, Windows 7, Windows, 2000, Windows XP, Microsoft Word, migration, Enterprise, OLAP, OLE, Operating Systems, optimization, Oracle, DB, DeClaireeloper, PL-SQL, PL/SQL, PDF, policies, processes, coding, Programming, Express, Quest, reporting, serClaireers, Scripts, Shell scripting, SMTP, Software DeClaireelopers, MS SQL SerClaireer, MS SQL, Microsoft SQL SerClaireer, SQL, SQL SerClaireer, supply chain, Tableau, Tables, Toad, T - SQL, T-SQL, TSQL, transportation, troubleshoot, troubleshooting, Unix, upgrade, Claireisio, Claireista, Microsoft Claireisual Studio, Claireisual Studio, Windows SerClaireer, written, XSL
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.