SQL Developer Resume Profile

SUMMARY

Over 7 years of experience in database administration, design, development, testing and implementation of applications, reports and databases MS SQL Server 2005/2008/2008R2/2012 in production environments and BI tools SSIS SSRS SSAS .
Expertise in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server 2012/2008 R2/2008/2005/2000.
Experience with T-SQL in writing triggers, indexes, tables, views, data integrity, user defined functions and relational database models.
Expert in performing various SSIS data transformation tasks like Derived Column, Data conversion, Merge, Bulk Insert, Data Mining, Look-ups, Fuzzy Look-ups, OLEDB Command and Conditional Split.
Hands on experience in deployment of SQL Server applications.
Experience in Creating, Testing and deploying SSIS Packages.
Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Experience with ETL framework standards including error processing, validation and data reconciliation.
Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, OLAP, Sub reports and formatting them using SSRS 2005/2008/2012.
Created stored procedures for generating reports using SQL Server Reporting Services SSRS .
Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF.
Experience in Designing and Building the Dimensions and cubes with star schema using SSAS 2012/2008/2005.
Experience working on Data Aggregation and Storage design of cubes in SSAS.
Write documentation describing end to end business flow, data flow among different applications, program modification, automation processes for maintenance and to support business users.
Extensive experience in dimensional modeling, creating star and snowflake schema.
Strong knowledge of OLAP, data warehouse design.
Excellent understanding of Relational Database Systems, Normalization.
Strong background in a disciplined software development life cycle SDLC .
Excellent communication, analytical and interpersonal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities.
Had experience in working in different environments and also with the process flows in AGILE as well as Waterfall methodologies.

TECHNICAL SKILLS

Languages	: C, C , T-SQL, PL/SQL, JavaScript, C , .NET.
RDBMS	: SQL Server 2012/2008 R2/2008/2005/2000, 7.0, MS-Access, Oracle Database 11g/10g/9i, DB2, MySQL, and Teradata V2RX.
Web Technologies	: HTML, XML, JavaScript, PHP.
Version Controlling Tools	: Visual Source Safe, Sub version.
SQL Server Tools	: SQL Server Management Studio SSMS , Enterprise Manager, Query Analyzer, SQL Profiler, Database Engine Tuning Advisor Business Intelligence Development Studio BIDS ,SQL Server Data Tools, SSIS, SSAS, SSRS, Data Transformation Services.
Web Server Technologies	: IIS 5.1/6.0.
Data Modeling Tool	: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007.
Operating System	: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7/8, Unix
Methodologies	: Logical and Physical Database Design, Star Schema, Snowflakes schema.

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer SSIS/SSRS

Roles and Responsibilities:

Created Complex SSIS packages using various transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
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.
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.
Working on different types of exceptions like missing Invoice ID's, Unidentified Manufacturer ID's, Missing UOM's, Catalog mismatch and Erroneous future invoice dates.
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 in order to create and maintain a centralized data warehouse.
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 2012, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , Visual Studio 2008/2010 OLAP, TFS, XML, C , ASP.Net, DTS, MS Visio.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship