Data Sql Server

Role

SQL/ETL Developer

Years of Experience

* *****

Education

Bachelor of Information Technology

Technical Skills

Confluence

Dozer

Jaspersoft

Eclipse

Enterprise Architect

Jenkins

JIRA

MS Internet Information Server

MS Office

MS SharePoint

MS SQL Integration Services 2012 /2010

MS SQL Reporting Service 2008

MS SQL Server 2014/2012 /2008R2/2008

MS Windows 2008 and Server 2012

SQL Server Management Studio

Subversion (SVN)

Tableau

Unified Functional Testing

TFS

Erwin

MS Visio

Teradata

DB2

Data Stage

Certifications

Implementing Data Warehouse with Microsoft SQL Server 2012/2014

Administering Microsoft SQL Server 2012/2014 Databases

Querying Microsoft SQL Server 2012/2014

Database Fundamentals

Microsoft SQL Server Implementation and

Maintenance

Summary of Qualifications

Over 8 years of in-depth experience in database Design, Modeling, development, administration and maintenance of SQL Server 2014/2012/2008R2 large scale databases.

Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.

Experience in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.

Proficiency with T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and working knowledge of Analysis Services (SSAS).

Assisted in development of ETL architectural standards and provided guidance and conducted trainings to Architects.

Crystal Reports development focusing on website/email tracking, database queries and accounting.

Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.

Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.

Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.

Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2005.

Highly experienced in database server performance tuning and optimization of Complex SQL queries.

Launching the report builder for adhoc reports.

Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.

Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.

Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.

Implemented different Replication Models like Snapshot, Merge, Transactional and Database Mirroring.

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML, MDX and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.

Good Knowledge in designing Database Models using UML, MS Visio and Erwin.

Ability and willingness to learn new technology and deliver results in a timely manner.

A well-organized, goal-oriented, highly motivated effective team member.

Project Summary

Deloitte, Washington DC Nov 2017 – Present

MS BI Developer/ SQL Developer

Responsibilities:

Involving in Query Optimization to increase the performance of the Report.

Developing Reports for business end users using Report Builder with updating Statistics.

Creating charts and pivot tables in Excel.

Creating pivot tables and charts in Excel using data sources (SQL Server, Access) and power pivot.

Establishing ETL design practices for optimization and performance of packages and Parameterized SSIS.

Updating functional specification and technical design documents.

Developing reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.

Designing an OLAP system with the help of ERWIN to visualize data structure.

Extracting data from heterogeneous sources and transferring to OLAP using SQL Server Integration Services (SSIS) .

Compile and analyze data from multiple internal and external sources

Creating low level design and ETL design doc according to requirement.

Creating SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

Creating SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Designing and developing matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Creating Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio 2010.

Problem identification, troubleshooting, resolution, and index tuning databases.

Creating Alerts for successful or unsuccessful completion of scheduled Jobs.

Working as a SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Gathering business requirements from users and translating them as technical specs and design docs for development.

Actively involving in requirements gathering/analysis meetings with Business and provide description about the analysis and approach.

Creating and developing SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.

Extensively using SSIS to move data from text files to SQL Server.

Creating Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.

Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)

Creating logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

Creating SSIS/DTS packages to copy tables, schemas, views to extract data from Excel.

Designing ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loading the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Creating complex DTS Packages in SSIS for Data load from CSV/Excel Sheets with more than 200 columns and with different file layouts to SQL Server database.

Developing Stored Procedures and Functions used for inserting, updating, or transforming data.

Developing complex T- SQL queries used for data investigation.

Creating table indexes and constraints to ensure data integrity and enhance query processing.

Sourcing data from various types of relational databases, flat files, excel files.

Developing SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task.

Capital One, Mclean VA Feb 2014 – Oct 2017

MS SQL Server SSIS / SSRS Developer

Responsibilities:

Requirements gathering, Analysis and Design of all the client requirements.

Performed Data Modeling and Developed logical and physical model using Erwin and implementing them to SQL server.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data.

Used Crystal Reports to tracked logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.

Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.

Designed, coded and implemented ad hoc reports using existing report models in SSRS.

Identified the Data Source and defined them to build the Data Source Views.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.

Managed Alerts for successful or unsuccessful completion of scheduled Jobs.

Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Involved in testing, bug fixing and documentation for the project.

GEICO Bethesda, MD Feb 2011–Jan 2014

BI Developer/SSRS Developer

Responsibilities:

Gathered requirements about the project which was used to create the SSIS 2008 packages.

Wide knowledge of ETL architecture, data schemas and SSIS packages

Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).

Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.

Used Package configurations, Variables and Expressions while creating the SSIS packages.

Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.

Analyze, evaluate, logically interpret, and summarize a wide variety of data to provide timely, relevant, and accurate information to a broad range of internal and external audiences

Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.

Used SQL server agent to automate the SSIS package execution.

Responsible to create test cases and performed system testing for the SSIS packages using SSIS 2008.

Made various report parameters and query parameters to create parameterized reports using SSRS 2008.

Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.

Implemented caching of reports and managed the report history in the Report Manager.

Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.

Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.

Created stylish reports and implemented conditional formatting using SSRS 2008.

Deployed and managed the reports in the Report Manager using SSRS 2008.

Wrote complex stored procedure, views using T SQL in Management Studio

Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Contact this candidate