Sr. Sql Server Developer Resume
Largo, MD
OBJECTIVE:
To obtain a challenging position in the Confidential field as a SQL Developer that will utilize my diverse computer skills and my strong analytical abilities, also seeking a position that offers opportunity for rapid advancement.
SUMMARY:
- My background includes over 20 years of software and database development with in - depth knowledge, diverse skills sets and strong analytical abilities.
- I am a dedicated and driven professional that offer particular expertise in the high tech sector by developing and implementing software products that are on the cutting-edge of technology.
TECHNICAL SKILLS:
OPERATING SYSTEMS: Windows XP/Vista/7/8/10
RDBMS: SQL Server 2016, 2014, 2008, 2005…. and MS-Excel 7.0.
LANGUAGES: SQL, PL/SQL, Transact SQL, Visual Basic, C# .Net
SOFTWARE/ APPLICATIONS/ TOOLS: SQL Server Management Studio, Enterprise Manager, SQL Profiler, SSIS, SSRS, Business Intelligence Development Studio and Data Transformation Services (DTS), Team Foundation Server, GIT Source Control, SVN Source Control
WEB TOOLS: HTML, XML
Data Warehousing: OLAP, OLTP, Snow Flake Schema Modeling, FACT and Dimension Tables.
EXPERIENCE:
Sr. SQL Server Developer
Confidential, Largo, MD
Responsibilities:
- Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
- Worked on contract, operations and procurement conversion projects from Legacy systems with backend as SQL Server Database.
- Creating and analyzing existing high level ETL design documents and data mapping documents.
- Developing complex T - SQL queries, common table expressions (CTE), stored procedures and functions used for designing SSIS packages.
- Loading CSV data files into SQL Server staging tables using BCP commands.
- As part of conversion, loading data into staging tables to operational tables and validation of data through
- Integrity check Errors generated as part of the application.
- Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to
- Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
- Designing Enterprise reports using SQL Server Reporting Services (SSRS 2012) which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
- Using SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.
- Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
- Worked on performance of reports using SQL Profiler.
- Developed Package configurations for Integration, Test and Production environments and execution of SSIS packages automatically.
- Designing and testing many test cases while converting legacy data into Guide wire application as process of conversion.
- Assisted in building a company specific Data Mart for related data.
- Development of different types of reports like Parameterized reports, Drill down reports, Ad- hoc reportsSnapshot reports and Sub reports on data mart database.
Environment: SQL Server 2008 R2/ 2012/2014, Visual Studio 2005/2008/2010/2012 , MS Access, MS- Excel, SQL Server Integration Services, SQL Server Reporting Services, SharePoint, VB Script, C#.
Sr. SQL Server Developer
Confidential, Falls Church, VA
Responsibilities:
- Involved in installing and maintaining MS SQL Server 2008/2012/2014.
- Design and develop various SSIS package, using script task, data flow task, conditional split, execute sql task.
- Developed SSIS packages which has header and footer with increment sequence number.
- Design and developed SSIS package to extract data for members and providers from SQL server to flat files. Modified packages from old version 2008 to 2012.
- Modified SSIS package to load millions of rows by breaking one flat file into multiple small flat file.
- Defined logging and dynamic configuration of the package using SQL server 2012 data tools.
- Create various SSIS catalog and SQL server agent job script in order to deploy package into SQL server 2012 SSIS server.
- Created various Implementation plans which involve step by step process of deploying various project.
- Fixed old stored procedure by improving performance and applying new logic to it.
- Design and develop History table in order to get daily extract.
- Created numerous ordinary to complex queries involving multi - table joins, Union, Correlated.
- Tuned and optimized queries by altering database design, analyzing different query options and Indexing strategies.
- Wrote database triggers in T-SQL to check the referential integrity of the database.
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
- Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
- Created reports from various migrated data sources into simple dashboards for easy reviewing.
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Developed, deployed, and monitored SSIS Packages.
Environment: SQL server 2014, SQL server 2012, SQL server data tools 2010, SQL Server Management Studio, SSIS, SSRS, Microsoft Visual studio 2013
Sr. Database Developer
Confidential, Alexandra, VA
Responsibilities:
- Created Stored Procedures, Views, Triggers, User defined Functions and scripting Complex T - SQL logics for business logics.
- Importing file exception reports after the missing data is recovered by the data entry team.
- Re-processing the complex T-SQL scripts to update the data in Staging Purchase History table and Purchase History table.
- Validation of the scripts and to check in the scripts like tables, views and stored procedures in to TFS.
- Created stored procedures, Functions, Triggers, Cursors and SQL scripts Using SSMS.
- Optimizing the T-SQL script using the estimated execution plan based on the cost of the steps and indexes.
- Cleaning, fixing the data which is incomplete and identifying the various exceptions in the received data.
- Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
- Expertise in Backup configuration, monitoring and tuning.
- Worked on File integrity validation, Data integrity validation and Data quality analysis.
- Created SSIS packages with which data resources such as Flat files, Excel files, were loaded daily to create and maintain a centralized data warehouse.
- Created Complex SSIS packages using various transformations provided by SSIS such as data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
- Created different types of Reports such as Cross-Tab, Drill-down, Summary, OLAP, Sub reports and formatting those using SSRS.
- Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates.
- Assisting the data entry team when needed and pulling the required data from various tables using complex T-SQL queries.
- Worked on the completeness check, roll back check in fixing and cleaning of the data.
Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2008 OLAP.
SQL / BI Developer
Confidential, Crystal City, VA
Responsibilities:
- Created complex SQL codes using Views, temporary tables, triggers and stored Procedures.
- Expertise in tuning T - SQL procedures, triggers and other database objects.
- Developed T-SQL and C# stored procedures, functions, triggers, and views.
- Designed, debugging, and optimized T-SQL and MDX queries, T-SQL and CLR stored procedures, functions, views and dynamic queries for SQL Server, OLAP Server.
- Expertise in designing DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
- Designed and developed DTS packages for transferring data from flat files and Access files.
- Experienced in various stages of SDLC, which includes requirement gathering, analysis, design, development, Implementation.
- Upgrade enhancements, maintenance, support and bug fixing for the product.
- Involved in converting SQL Server 2000 DTS packages to SQL Server 2008 SSIS packages.
- Created various packages for performing ETL process using SSIS.
- Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2003.
- Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2005.
- Created database objects for improving the performance.
- Fine-tuned Procedures, Functions and Triggers for optimum performance.
- Involved in creating SQL reports.
- Created cubes and dimensions using SSAS.
- Maintained all SQL documents including installation and data conversion Procedures, standard security documents, etc.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
Environment: T-SQL, SQL Server 2005, Windows 2000 Server, Query Analyzer, MS Access 2000, Oracle, DTS, OLAP Services.
SQL Developer
Confidential, Clifton, VA
Responsibilities:
- Involved in Waterfall model of SDLC and gathered business requirements from business people.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T - SQL code and SQL joins for applications.
- Created reports on SQL server reporting services.
- Built reports through Report Builder and Report Designer.
- Created reports using Report Model and applying row level security filters.
- Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart.
- Integrated SQL Server 2008 Reporting Services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point Portal (SSRS).
- Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
- Enhanced and deployed the SSIS Packages from development server to production server.
- Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
Environment: MS SQL Server Management Studio, Microsoft Share point Portal Server, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
SQL Developer
Confidential, Washington, DC
Responsibilities:
- Involved in installing, configuration and maintaining MS SQL Server 05/08 and Clients.
- Design and create SQL Database, and SQL objects like tables, indexes, and views based on user requirements.
- Implemented Domain and Referential integrity constraints like Primary Key, Foreign Keys check and Not Null/Null
- Created indexes and implemented optimizer fill factor for all tables.
- Created Tables, Views, Triggers, Stored Procedures, User Defined Functions and another T - SQL TSQL DDL/DML
- Create and Modify User Defined Functions, Stored Procedures, Triggers, Views according to the business requirements.
- Performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
- Worked with the developers and provide necessary SQL Scripts using T-SQL.
- Design of ETL processes to transfer customer related data from MS Access, Excel to SQL Server.
- Prepare documentation related to database design, objects security and rules.
- Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
Environment: MS SQL Server, Windows 2000/NT, Enterprise Manager, Query Analyzer, SQL Profiler, MS Access.