Professional Summary: -

• 7 years experience which includes design, development, testing and implementation of applications, reports and databases MS SQL Server 2008 R2 2012 in production environments and BI tools SSIS SSRS
• Experience in implementation of the Stored Procedures, Triggers, Functions and Packages using T-SQL and Experience in query optimization performance tuning.
• Experience with Converting data from legacy systems to new systems
• Experienced in software development life cycle SDLC involving system analysis, design development and implementation using waterfall methodology and agile methodology.
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join, OLEDB Command, and Row Count.
• Design and develop SSIS packages, stored procedures, configuration files, tables, views, functions and implement best practices to maintain optimal performance
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP, Bulk Insert, Data Transformation Services DTS and SQL Server Integration Services SSIS 2008 R2 2012 .
• Created packages using Integration Services SSIS for data extraction from Flat Files, Excel Files OLEDB etc. to Access etc.
• Experience in migration of DTS packages in to SSIS packages.
• Possesses extensive experience using Microsoft SQL Server Reporting Service SSRS with report authoring, report management, report delivery and report security.
• Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services SSRS .
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, and Drill down up, and Drill through features in using Business Intelligence Development Studio BIDS .
• Skilled in creating user interactive report dynamic parameters using Drop Down, Multi-Valued, Cascading and Expert in working with all Collections in reports like Fields, Global, User, Parameters, Variables and Report Items.

Technical Skills:

Databases

MS SQL Server 2008R 2/2008/2005/2000, Access, Share Point, Oracle10g.

Programming Languages

T-SQL, PL/SQL, JAVA, VB.NET, C .NET, ASP.NET, C, C .

Data Modeling Tools

ERWIN 7.3/7.2, Power Designer 12.5, ER Studio 8.0.1, MS Visio 14.0/12.0/11.0.

Database Tools

BIDS 2008/2005, Management Studio, Analysis Services SSAS, Visual Studio, Query Analyzer, SQL Profiler.

ETL Tools

SQL Server Integration Services SSIS, Data Transformation Services DTSImport/Export Wizard, Bulk Insert, BCP.

Reporting Tools

SQL Server Reporting Services SSRS, Business Objects, Report Builder, Crystal Reports, Excel.

Scripts

PHP, JavaScript, CSS, VBScript, HTML and XML.

Applications

Microsoft Office Excel and PowerPivot, Tortoise SVN, Team Foundation Services TFS, JIRA, Tidal.

Operating systems

WINDOWS 2008/2003/2000/ NT servers.

Experience:-

Confidential

SSIS/SSRS /SSAS DEVELOPER

Responsibilities:

• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse. Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Involved in Analyzing, designing, building, testing of OLAP cubes with SSAS 2012.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.

Environment: MS SQL Server2008, SSIS, SSRS, MS Office, Oracle 10g,MS Office 2007/2010, Microsoft Visio 2010, SQL Server Management Studio 2008 and 2012.

Confidential

SSIS/SSRS DEVELOPER

Responsibilities:-

• Developed different types of tabular reports, matrix reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services
• Embedded the reports on to application using MS Report Viewer in Visual Studio 2010 .SQL query optimization in SSRS by designing required indexes partitions after analysis using SQL profiler and examining execution plans in SQL server Management studio
• Designed Complex SSIS ETL packages to load the data from different sources like OLEDB, EXCEL, FLAT Files, RAW Files and DB2 into various Servers and Databases.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data
• Scheduling and running jobs in the background, taking regular backups of the systems and recover data during failures and Created packages in SSIS with error handling
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the Database on Daily basis
• Worked on SSIS script task, look up transformations and data flow tasks using T-SQL and Visual Basic VB scripts
• Planned the complete backup with the suitable recovery model of various Databases
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures
• Performance tuning of the stored procedures, user defined functions and long running queries
• Responsible for keeping system and databases up-to-date by making necessary changes
• Worked with DBA to manage Login and User: Adding Logins, Roles, and Groups to the Window NT and MS SQL Server and Maintaining proper security procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

Environment: MS SQL Server 2008 R2, BIDS SSIS, SSRS, SSAS, Excel PowerPivot, PowerView, Business Objects, Agile/scrum environment, TFS, Dundas charts, Source Safe, Visual Studio 2010, C .Net 2008 and Window 7.

Confidential

SSIS DEVELOPER

Responsibilities:

• Designing, managing and Publishing various Dash boards, score cards using SQL Server Reporting Services.
• Data migration from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integration in SSIS
• Developed Query for generating drill down reports in SSRS 2008 and Prepared AD HOC reports through report builders.
• Data migration using SQL Server Integration Services SSIS across different databases like Oracle, MS access flat files.
• Created stored procedures, triggers, indexes, rules, integrity constraints, cursors, views and Ad-hoc queries for the business logic.
• Created SSIS packages to transfer data between OLTP and OLAP databases.
• Wrote parameterized queries for generating Sub reports, Matrix reports using Expressions, and functions, sorting the data, defining the data source and Subtotals for reports using SSRS 2008
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL
• Created SQL joins, sub queries, tracing and performance tuning for better running of queries
• Creating SSIS packages for archiving data and Data Migration
• ER diagrams and mapping the data into database objects.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Wrote Distributed Queries for Linked Servers.
• Working Experience Designing and Validation Crystal Reports.
• Designed and analyzed a few databases Payments and follow up . Login and User Management.
• Involved in Analyzing, designing, building, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX

Environment: -SQL, PL/SQL, MS SQL Server2008, Oracle 10g, SQL Developer, SQL Navigator, SQL LOADER, ERWIN, HP UNIX, FileZilla, Putty.

Confidential

SSIS/SSRS DEVELOPER

Responsibilities:-

• Created DTS packages to Copy Tables, Schemas and Views and Extract data from Excel and Oracle using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers maintaining Referential Integrity.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies. Developed reports using SSRS 2005. Used Table control, Matrix control for cross tab reports.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports. Responsible for scheduling the Subscription Reports with the subscription report wizard.
• Created different Chart Reports helped in analyzing perform counters using SSRS 2005.
• Troubleshooting performance issues with Fragmentation using Profiler, System Monitor and DMVs.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008/2005, BIDS SSRS,SSAS,SSIS, T-SQL, DB2, MS Visio 2007/2003, Windows 2003/2000 Advanced Server, TFS, ERwin 7.2, C .Net 2005.

Confidential

SQL DEVELOPER

Responsibilities:-

• Designed and developed SSIS package to load data to data warehouse.
• Implemented Slowly Changing Dimensions to maintain historical data in Data Warehouse.
• Used various tasks like Data Conversion, Look Up, Merge Join, Conditional split etc. in SSIS.
• Loaded data in Dimension Tables in SQL Server using SSIS Packages.
• Transferred Flat files from different sources using BCP.
• Unit testing and Integration testing for various modules.
• Created reports from Data Warehouse using SQL Server Reporting Services SSRS .
• Created complex stored procedures to generate reports using SSRS.
• Embedded reports into web pages using ASP.NET Report Viewer Web Control.
• Creating Database Tables, Indexes, Stored Procedures and Triggers.
• Troubleshooting DB performance issue and implementing necessary DB changes and implemented processes to ensure Optimal Query Performance.
• Created views and indexed views to reduce database complexities for the end users.

Environment: SQL Server 2005/2000, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server.