SUMMARY:

• 9+ years of experience in IT as MS SQL Server Database Developer in Design, Analysis, Development Modeling, implementation and Decision Support System using SQL Server 2005/2008/2008 R2/2012 Services and BI tools (SSIS, SSRS).
• Experience in Microsoft SQL Server 2012/2008/2008 R2/2005 with Business Intelligence like SSIS and SSRS.
• Designed, Developed and Deployed ETL process using SSIS to load data from various sources like Oracle, MS Access and DB2 into SQL Server 2008 R2/2005 databases.
• Worked on Control Flow Tasks like For Each Loop, Execute Process Tasks, Execute Package Tasks, Script Tasks and Data Flow Tasks like Data Conversion, Derived Column, Look Up, Merge, Script, Union and Union All.
• Expert in creating Complex packages with Error handling, Notifications and Package Configurations.
• Created Audits/Logging for SSIS Packages on task level and package level.
• Used SSIS Checkpoints, Property expressions and variables to customize data processing.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Hands on experience in developing Custom Reports and different types of Tabular reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Hands on Experience of Scheduling SSRS Reports with General and Data Driven Subscriptions.
• Experience in handling Report Manager Security, User Access, setting up Data Sources and managing Report folders.
• Worked on T - SQL, DDL, DML, Primary Keys and Foreign Keys.
• Experience in creating Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes, Temp tables, Dynamic SQL, SQL Commands.
• Experience in using Try Catch block and Created and Executed the Stored Procedures and Complex Queries for Reports.
• Using SQL server hints, DMVs and DBCC commands whenever necessary.
• Solid knowledge of Relational Database Management Systems and Data Warehouse Concepts.
• Hands on experience with Database development in OLTP and OLAP.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from Relational databases.
• Hands on Experience in Installing, Configuring, Monitoring and Troubleshooting SQL Server 2008R2/2012 on Windows 7/8, Windows Server 2008/2008R2/2012 environments.
• Extensive experience in Administration Tasks like setting up Batch jobs, Configuring IIS, Data Uploading, Backup and Recovery, Database mirroring, Log shipping, SQL Server Agent Jobs and monitoring day-day database activities.
• Proven ability in Performance Tuning and Query Optimization.
• Experience in client interaction while providing technical support and knowledge transfer.

TECHNICAL SKILLS:

Database Tools: SQL Server Management Studio, SQL Enterprises Manager, SQL Profiler, Query Analyzer, Data Base Engine Tuning Advisor, SSIS, SSRS, SSAS, SQL Developer, MS Access

ETL Tools: Data Transformation Services (DTS), SQL Server 2008/2008R2/2012 Integration Services (SSIS), Import Export Data, Bulk Insert, BCP.

Data Modeling Tools: MS Visio 6.0.

Programming Language: T-SQL, PL/SQL, DB2, C#, VB 6.0, HTML Script, XML

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9/10, MS Excel.

Databases: SQL Server 2014/2012/2008 R2/2008/2005, Oracle 8i /9i, MS Access.

Operating Systems: Windows XP/7/8, Windows Sever 2005/2008/2008 R2/2012/2012R2

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server BI Developer (SSRS/SSIS)

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2008 R2.
• Continuously interacted with users to gather the business requirements.
• Created design specification documents for the new reports developed through SSRS.
• Published reports through Report Manager.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Data Driven Subscription both Email and Windows File Sharing.
• Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Created Complicated reports like Parameter based Reports, Graphical Reports, Excel Reports, Drill-Down Reports, Matrix Reports, Chart and Tabular Reports using SSRS 2008.
• Fine-tuned existing reports by running execution plan on queries and identifying tables that need indexes
• Designed and Created databases, tables, views, stored procedures and triggers.
• Modified existing database by adding tables and relationships.
• Creating Star and Snow Flake Schema design using Visio, defining relations between tables (Primary keys, Foreign keys).
• Integrated Database Snapshots into SSIS and used Transactions in SSIS.
• Designed, modified and troubleshoot SSIS packages.
• Control Flows, which include tasks and containers that execute when the package runs. Organized tasks in sequences and in loops during creation of package in SSIS.
• Utilized SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Created ETL in DTS packages by using Data Transform Task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2005
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column, look up, merge etc.
• Created notifications, alerts to let support team know in case there are any failures.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Worked on SVN to manage code.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points,
• Created Unit Test Cases and Performed Unit Testing.
• Logging, TRY and CATCH Blocks.

Environment: MS SQL Server 2012/2008 R2, SSRS, SSIS, Crystal Reports, DTS, Data Modeling, OLAP, Data warehousing, T-SQL, PL/SQL, DB2, SQL Profiler.

MS SQL Developer/SSIS/SSRS/DBA/MS Access

Responsibilities:

• Performed Reverse Engineering and Modified Store procedures, SSIS Packages and Agent Jobs which are related to SSRS Reports
• Designed SSIS packages to replicate the data from DB2, flat files and excel documents to the Staging Area in SQL server 2012
• Created the Load packages for loading the Text files, CSV files and flat files from various networks into SQL Server using SSIS 2012
• Used various Data Flow Transformations, like Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages
• Used Event Handlers for Error Handling and Alert Operations
• Maintaining and modifying existing Reports related stored procedures, view and SSIS Packages.
• Scheduled Packages using SQL Server Agent Jobs. Monitoring nightly jobs
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task
• Created package configuration in XML and used them to deploy packages into SQL server
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output

Environment: T-SQL, PL/SQL, MS SQL Server 2005, 2008R2/2008 and 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, MS Access, Visual Source Safe (VSS), Windows XP.

Senior SQL BI Developer (SSIS, SSRS)

Responsibilities:

• Migrated the DTS packages into SSIS and created new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Removed the DTS package references from stored procedures and created as SSIS packages and embedded those procs in the SSIS package to retain the load functionality of the system.
• Worked entirely on SSIS script task, look up transformations and data flow tasks using T-SQL.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Used Vb.net to design script task for SSIS packages and converted VB script code to VB.net code while migrating packages from DTS to SSIS versions.
• Migrated data from MS SQL source databases to destination database in SQL Server 2008 database using SSIS.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created and used extended stored procedure in SSAS.
• Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle, text files and Excel files.
• Experience in ETL tools like SSIS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper data mapping and data cleansing.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Writing SSIS packages for loading the data from source to target as per the requirement.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Successfully implemented and monitored Transactional replication with update subscribers, snapshot replication on production environment with publisher, distributor and subscriber topology.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Created weekly, monthly and quarterly based financial reports using SQL Server 2005 Reporting services.
• Used the Default logging as well as Custom Log to keep track of the package.
• Migrated several databases from SQL Server 7.0 into SQL Server 2000.
• Performed data Backup, Recovery, and Transfer operations.
• Created report models for ad hoc reports and deployed on report server using SSRS.
• Configured Log shipping from one production server to the reporting server.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Tested the Integration of different modules.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.

Environment: SQL Server 2000 and 2008 management studio, Business intelligence development studio, DTS, SSIS, SSRS, T-SQL, Report manager, Report Configuration manager, SQL Enterprise manager, SQL profiler, Microsoft Visual Studio 2008R2 and Windows 2003 professional server.

.Net/SQL/SSIS/SSRS Developer

Responsibilities:

• Front end and Backend Developer.
• Gathering Requirements and implementing the same.
• Coding and Unit Testing.
• Coding in ASP 3.0, Asp.net, C#.net
• Involved in SQL Server Database Design.
• Created/developed/maintained the Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, Constraints and Roles.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Analyzing the requirements, preparation of strategic plan for development.
• Involved in the design database in SQL SERVER. Design, development and implementation
• Extensively used Themes and Skins for styling the ASP
• Involved in developing user interface
• Involved in Coding for forms
• Writing stored procedures
• Performed user acceptance testing
• Involved in preparation of Technical Specification Document.
• Designing the Required User Interface.
• Creation of Web User Controls.
• Performed validations using validation controls and regular expressions.

Environment: MS SQL Server 2000, ASP 3.0, ASP.net,C#.net,ADO.net and VSS 6.0