Sr SQL Developer
Ph No: 908-***-****
Email Id: email@example.com
MS SQL Server Developer with 7 years of strong experience in Health Care, Insurance, Retail, Finance and Banking domains.
Highly proficient in operating MS SQL Server 2012/2008 R2/2008/2005/2000 suite of products like SSIS, SSRS and SSAS.
Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation.
Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
Conversant in working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server databases.
Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
Expert in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages. Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
Highly experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
Good knowledge in developing Cubes and Dimensions using SQL Server Analysis Services.
Experience in writing MDX queries to work with cube data. Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
Working knowledge in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, Drill-Down, Parameterized and for the end user requirement Ad Hoc Reports using SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
Strong leadership, communication, problem-solving and multi-tasking abilities.
Bachelors in Computer Science Engineer from Mallareddy Institute of Technology & Sciences, India.
Master in Computer Science from New England College, New Hampshire, USA.
SQL Server (2000, 2005, 2008, 2008R2, 2012, 2014, 2016), MS-Access, Oracle, Teradata, MYDB.
SQL, T-SQL, Shell Program, Power Shell program, HTML, XML, C, C++
Business Intelligence Tools
MSBI (SSIS, SSRS & SSAS).
MS Visual Studio 2012/2008/2005/2000, SSMS, SQL Agent
MS Office Suite (Word, Power Point, Visio), OLAP, OLTP, Erwin and Power Designer, TFS, SVN.
Microsoft Windows 98/2000/2003 Server/XP/7/8/2008 Server/2012 Server
Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)
SQL Server Reporting Services (2012/2008/2005/2000), Power Pivots, Power Bi, Microsoft Access 2013, Excel
Money Solver, Jacksonville, FL Oct 2017 – Present
SSRS/SSIS Report Developer
Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2005).
Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
Involved in database Schema design and development.
Migrated Database from SQL Server 2005 to 2008.
Experience in using SQL Server 2012.
Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
Expert in SSIS Deploying and Scheduling.
Identified and Defined Key Performance Indicators in SSAS 2005/2008.
Defined report layouts for formatting the report design as per the need.
Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
Administrated the created Reports by assigning permission to the valid user for executing the reports.
Environment: MS SQL Server 2008 R2/20012, SQL server Reporting Services, SQL Server Integration Services (SSIS), VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin7.2, SQL Server Profiler, Database Engine Tuning Advisor.
ADP, Parsippany NJ Dec 2015 – Sep 2017
MS SQL Server Developer
Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
Extracted the data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS (SQL Server 2008).
Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
Handled slowly changing dimensions to maintain the history of the data.
Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
Involved in Designing and deploying cubes in SSAS environment using Snowflake Schema Designs for the operational data
Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services, SQL Server Analysis Services, MS Visual Studio2008, Windows 2008 and T-SQL, SQL Server Profiler.
Accenture, India Jul 2013 – Nov 2014
MS SQL Server/SSIS/SSRS Developer
Installed SQL Server 2008 and configured the database.
Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop)
Created SQL Server Reports using SSRS 2008.
Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.
Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports.
Identified the Data Source and defining them to build the Data Source Views.
Developed Query for generating drill down reports in SSRS 2008.
Designed and implemented stylish report layouts.
Generated Reports using Global Variables, Expressions and Functions for the reports.
Identified and worked with Parameters for parameterized reports in SSRS 2008.
Environment: MSSQL Server 2008/2005, SQL Server Integration Service, SQL Server Reporting Services, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard), Windows XP, MS Access, MS Word.
Virtusa, India Apr 2012 – Jun 2013
Jr. SQL Server Developer
Created and maintained database objects.
Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic using TSQL.
Created various reports using MS Reporting Services.
Assisted in writing and optimizing complex SQL Queries.
Analyzed the existing application programs and tuned SQL queries using SQL Profiler.
Involved in writing scripts for the programs.
Loading data from various data sources using MS Data Transformation Services.
Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
SQL performance tuning by modifying SQL or adding/changing indexes.
Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML etc.
Wrote and integrated stored procedures to generate the reports.
Provided on-call support for various projects.
Environment: SQL Server 2000, Sybase, DTS, Excel, MS Access 2000, ASP, MS SQL Reporting Services.