SUMMARY

• Over 6+ years of professional experience in analyzing, designing and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS, creating mappings/ workflows to extract data from SQL Server Excel file, Flat File sources and load into various Business Entities Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Excellent Knowledge of SDLC, RDBMS, Data Warehouse & Data Modeling concepts.
• Skilled in creating T - SQL objects, working with DDL/DML, perform most of theSQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches
• Expert in writing Distributed Queries between SQL Servers.
• Experience in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Knowledge in Performance Tuning and Query Optimization
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS).
• Skilled at Transforming and validating data using SQL Server Integration Service (SSIS) Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Well versed in Using MDX (Multi-Dimensional Expressions) Queries to retrieve data from Multi-dimensional SSAS Cubes.
• Experience in designing complex reports including sub reports, parametric, drill down, drill through, cascading and formulas with complex logic usingSQL Server Reporting Services (SSRS).
• Skilled in creating scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using Reporting services (SSRS).
• Excellent report creation skills using Confidential Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Excellent communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

Database Servers: MS-SQL Server 2005, 2008 / R2, 2012 and 2014

SQL Editors: SSMS, SQL Server Agent

ETL Tools: BIDS - SSIS, SQL Server Data Tools

Ticketing and KB Tools: ITSM-eServiceDesk Tool, Primus, Techease

Reporting Tools: SSRS

Operating System: Windows Server 2003, 2008, 2008R2, Windows Server 2012

PROFESSIONAL EXPERIENCE

Confidential, New Jersey, NJ

SQL BI Developer

Environment: SQL Server 2012, SSIS, SSRS, SSMS

Responsibilities:

• Primarily responsible for developing applications in SSIS as per Business Rules and features of the tool.
• Developed highly optimized Stored Procedures, Functions, and Database Views to implement the business logic and also created clustered and Non-clustered indexes.
• Good knowledge and well use the Condition Split, Data conversion, Derived column, multicast transformations in the project.
• Created SSIS Packages using Fuzzy Lookup, Pivot Transformation, Aggregate, Data Flow Task, Execute SQL Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed various T-SQL queries and created/modified tables for data extraction, data load and transformations.
• Designed, deployed, and maintained complex reports using SQL Server 2012 Reporting Services (SSRS).
• Creating the reports as per client’s requirements in the form of table, matrix, Chart and List..
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of operations
• Created SSRS reports which contain Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from the first task.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the Errors during data moving and Sequencing the task as per requirements

Confidential, Redmond, WA

SQL DBA

Responsibilities:

• Installation & configuration 2008/2008 R2/2012 Enterprise and Express Editions.
• Working as an MS SQL Server 2012/2008R2/2008/2005 Administrator and responsible for installation, configuration and provided 24 X 7 dedicated support to all production Servers.
• Designing the database according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• SQL Database Mirroring setup between two different or same landscape servers and witness server built configurations.
• Security issues related to logins database users, application roles and linked Servers.
• Migrated SQL data from SQL Server 2000, 2005 and . Resolved the issues after migration of the Database.
• In-place and side-by-side Migration from SQL Server 2005, 2008 and 2008R2 to 2012
• Rebuilding the indexes at regular intervals for better performance.
• Efficiently carried out DBA responsibilities in planning SQL DB migration activities, in migration phases and in performing post migration tasks.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Planning for manual failover and Automatic failover for checking the failover test.
• Ensuring that the backups are running fine for various databases on different servers.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Performed advanced troubleshooting of physical/virtual hardware (VMware).
• Extensive experience in implementing High Availability Solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Performance tuning and optimization of Query of SQL server.
• Creating and maintaining user’s logins and Roles.
• Created Database Maintenance Plan for the Performance of SQL Server this includes Database Integrity Checks, Update Statistics and Re-indexing.
• Worked on Client/Server tools like SQL Server enterprise manager and Query Analyzer to administrate the SQL server.
• Taking Database full Backup, Transaction log backup & differential backup as per backup strategy daily/Weekly Routine.
• Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
• Maintained the database consistency with DBCC commands at regular intervals.
• Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Databases.
• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Insert, BCP, Mirroring and Replication.
• Extensively work experience on SSIS and SSRS.
• Extensive experience in utilities and tools used for database monitoring (SQL traces, online performance monitors, reports and catalog queries).
• Excellent Communication, Strong troubleshooting and Problem Solving Skills. Able to work with all type of people and Organizational skills.

Confidential

System Engineer-SQL Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, Crystal Report 8.5, T-SQL, SQL Server Management Studio 2008, Business Intelligent Development, Visio, Excel 2003, SharePoint

Responsibilities:

• Created SSIS packages and transferred them to the appropriate destinations.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
• Responsible for creating reports based on the requirements using SSRS 2005.
• Identified the database tables for defining queries for the reports.
• Developed reports using SSRS 2005. Used table control, matrix control for cross tab reports.
• Defined the report layout and identified Datasets for the report generation.
• Built drill down reports, and also parameterized reports using SSRS.
• Created different type of reports including Cross-tab, Conditional, Drill-down and Sub reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report Templates, Bar graphs and Pie charts based on the financial data.
• Developed and implemented Stored Procedures, Triggers, and Functions.
• Designed, developed, modified and enhanced the Database structures and Database objects.
• Created Stored Procedures, views in SQL Server using T-SQL to collect data.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data.

Confidential

SQL Server Developer

Environment: MS SQL Server 2005, DTS, SSIS 2005, SSRS 2005, Crystal reports 10, Oracle 8i, T-SQL, PL/SQL, Access, and Excel.

Responsibilities:

• Generated SQL Scripts for copying/migrating databases and database objects.
• Gathered data for validation and populate them into tables using stored procedures.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Extensive use of Stored procedures, Writing new stored procedures and modifying existing ones and tune them such that they perform well
• Involved in designing various reports to flat files generated by the database script.
• Create Stored Procedures, Triggers, Views, joins and Functions for the Application
• Create, debug, and execute T-SQL scripts and stored procedures
• Extensively involved in error handling stored procedures
• Imported various Sources, Targets and Transformations using Transact-SQL Server.
• Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.
• Actively involved Normalization & De-normalization of database
• Extensive Testing on the Performance of the Stored Procedures.
• Worked closely with Application Developers and Business Analysts to produce all required documentation
• Identified, tested and resolved database performance issues to ensure database optimization.
• Created complex views, partition views for the application to increase the performance and reduce server load.
• Write complex T-SQL statements for retrieval of data.
• Testing the Performance of the database and fine-tuning is also done for complicated queries that take time to carry out, Analyzing and creation of appropriate indexes to optimize application performance
• Create joins and sub-queries for complex queries involving multiple tables.
• Design and create SQL Database, tables, indexes