• Over 7 years of experience in all phases of Software Development Life Cycle SDLC of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation using Microsoft Technologies.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services SSIS , Reporting solutions using Microsoft SQL Server Reporting Services SSRS , DTS, Performance tuning, Designing logical/physical databases and Troubleshooting.
• Expert T-SQL development skills in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, Correlated sub-queries, Cursors and Triggers using SQL Server 2000/2005/2008R2/2012
• Experience in report writing using SQL Server Reporting Services and creating various types of reports like Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS 2008.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services SSRS , Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Excellent in High Level Design of DTS and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like 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 in using Fuzzy Lookup and Fuzzy grouping transformations for data cleansing.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Experience in defining logging for packages to record the error records, updated records, and inserted records.
• Experience in creating jobs, Alerts and schedule SSIS Packages using SQL Agent.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

Experience

SQL/SSIS Developer, Confidential

Responsibilities:

• Closely worked with business users and business analyst to gather user requirements and generate high level BRD's and Report Mockups for the Report Development.
• Actively participated in design, development discussions with DBA, team lead and project manager and performed impact analysis.
• Performed detail Data Analysis and Reconciliation of the projects and provided better approach to the system.

• Created SSIS packages to extract data from different data sources SQL Server, Oracle, Access, Flat files, Excel files and loaded them into OLAP system by performing different kind of transformations to fulfill business needs.
• Created Tablix, Drill-down, Drill-through, Matrix, Tabular, Multi Parameterized, Linked, Chart and data driven reports using SSRS 2012/2005.
• Highly involved in performing Unit Test, Regression Test, Functional Test, Integration Test, and Stored Procedure Performance Test on Test server and preparing combined Developer Testing document.
• Created Report level security and assign user permissions on Report Manager.
• Created the subscription and scheduled the published reports from Report Manager.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2012.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Increased query performance, necessary for statistical reporting by more than 25 after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Created SSIS Packages by using advance transformations i.e. Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.

Environment:

SQL Server 2012/2005, Oracle 9i, Management Studio, Microsoft SQL Server Integration Services SSIS , C , ado.net, Windows 2012 Server/2003 server, SQL Server Reporting Services SSRS , Microsoft Visual studio 2012/2005, SQL Server Profiler.

SQL Server BI Developer, Confidential

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Created complex Stored Procedures, triggers, cursors, tables, views and SQL joins and statements for applications by using T-SQL.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server 2008 from different environments
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Environment:

MS SQL Server 2008, SSIS, SSRS, OLAP, OLTP, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, Performance Point Server, ASP.Net, C , IIS 4.0, Visio 2000, SQL Server Query Analyzer, SQL Profiler, MS Access.

MSSQL Server Developer, Confidential

Responsibilities:

• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Developed Stored Procedures, Functions, Tables, Views, Triggers, Cursors, User Defined Functions, other T-SQL code and SQL joins for applications to handle large amount of data manipulation.
• Errors handling using TRY and CATCH blocks and performance-tuning the SQL Code.
• Creating ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Responsible for transferring the data using SSIS packages from excel/flat file sources to database.
• Published migrated data using SSIS SQL Server Integration Services Tool through data flow tasks, look up transformations and script tasks.
• Creating Logging and Error Handling in SSIS Packages
• Responsible for deploying/scheduling SSIS packages as per schedule.
• Monitoring, Identifying and troubleshooting SQL Server performance issues using SQL Server Performance monitor, profiler and Performance dashboards
• Responsible for creating a trace to identify and analyze the Poorly Performing Queries Identified by Profiler in SQL Server 2008 R2.
• Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Developing Cascading Reports for Analytics Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services SSRS 2008 R2
• Creating and deploying various Reports like Drill Down, Drill Through, Chart, Linked and Parameterized reports using SSRS
• Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services SSRS .
• Performing Unit and Regression tests for Developed Reports and Deployed into the Server
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users.

Environment:

Microsoft SQL Server 2008 R2, Business Intelligence Development Studio BIDS 2008 R2 , Management Studio, Visual Studio 2010/2008, .NET Framework, Windows Server 2003.

SQL Server/BI Developer, Confidential

Responsibilities:

• Involved in complete Software Development Life Cycle SDLC process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Involved in business requirement gathering, technical design documents and data mapping.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads Full Incremental into Staging, troubleshooting process, issues and errors using SQL Server Integration Services SSIS .
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments Development and Production .
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation..
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user reporting requirements.
• Used various Transformations in SSIS Data flow, Control Flow using for loop Containers, and Lookups etc.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services SSRS .
• Developed a High level dashboard using SSRS 2005
• Created copies of operational Databases using the Import/Export Wizard.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005
• Involved in creating report models and applying row level security filters for report model.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Environment:

SQL Server 2000/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS , .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

SQL Server Developer, Confidential

Responsibilities:

• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Implemented batch processing using Jobs and DTS.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Rules, and Indexes.
• Migrated data from Flat files to SQL server 2000 using DTS Import and Export Wizard .
• Scheduled Jobs using SQL Server Agent.
• Used SQL Server System Catalog to find Stored Procedures, UDF, Triggers, Tables, indexes and constraints on existing databases.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Used various levels of triggers and procedures to validate the data at each level.
• Extensively involved in writing stored procedures, triggers, functions and packages based on the client requirements.
• Created database tables with complex constraints applicable to the business rules.
• Analyzed requirement of client and worked on developing and designing reports.

Environment:

SQL Server 2000, Crystal Reports, MS Access, Excel, MS Word and Windows NT