Professional Summary:

• Around 8 Years of IT experience as a MS SQL Server 2012/2008R2/2008/2005 Developer in various industries like Finance, Insurance, and Health Care.
• Good Experience in installing MS SQL SERVER 2000, 2005, 2008, 2008R2 and 2012 updating with the hot fix and service packs.
• Skilled developer in Creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors etc.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
• Install and configure database software, associated database tools and performance monitoring software.
• Experienced in up gradation from MS SQL Server 2000 to MS SQL Server 2005 and MS SQL Server 2005 to MS SQL Server 2008 R2 and MS SQL Server 2012.
• Expert in designing Enterprise reports using SQL Server Reporting Services SSRS 2008/2008R2/2012 generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in Developing Reports for business end users using Report Builder with updating Statistics.
• Experience in migrating Crystal Reports 8.5 to SQL Server Reporting Services
• Expertise in Designing SQL Server SSIS packages to import and transform data between databases and external sources.
• Experienced in using Normalization and De-Normalization techniques.
• Experience in Query Optimization, Performance Tuning, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics.
• Experience in using DMV and dynamic management functions DMF Of Tables, Triggers, Store Procedure etc. for finding out long running queries.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services SSAS 2005/2008/2208R2.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services SSAS .
• Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow changing dimensions SCD etc and created various user roles SSAS .
• Experienced in working with Star Schema, Snow Flake Schema, Bus schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008 Analysis Services
• Experience in Extraction Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP Bulk Insert utilities.
• Experience in writing complex logical algorithms in Macros using VBA.
• Experience serving industrial segments like, e-commerce and Insurance, Sales and Marketing domains in business related to implementation of ERP/CRM and BI Solutions.
• Experience in SAP R/3, BI/BW ERP, and ECC systems.
• Experience in Developing SAP Cubes, Multi-Providers, DSO's on SAP BW and BI.
• Experience in creating reports like Dashboards, Webi, Crystal Reports, Widgets
• Etc. using SAP reporting Business Objects BO and BOBJ BEX Analyzer .
• Experience in developing web applications using C , VB.Net and ASP.Net.
• Experience in deploying and debugging of SSIS packages for import, export and bulk insert data with transformations from various data sources.

Technical Skills:

• Operating Systems : Windows NT/98/2000/XP/7, Server 2003, Server2008.
• ETL Tools : SQL Server Integration Services SSIS , Analysis Services SSAS ,
• Reporting Services SSRS , Data Transformation services DTS .
• Development Skills : T-SQL, PL/SQL, HTML, XML, ASP.Net etc.
• Programming : VB.Net, T-SQL, C , VBA, XML, C, C etc.
• Languages
• Databases : MS SQL Server 2012/ 2008R2/2008/2005/2000, MYSQL, Oracle.
• Applications : MS-Word 97/98/00/XP , MS-Excel 97/98/00/XP , MS-Access,
• Power Point, Visio etc.

Professional Experience:

Confidential

Data Warehouse BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Designing the ETL architecture for incremental load to keep old and new applications in sync.
• Created complex Stored Procedures, Nested Stored Procedures, Triggers, UDF's, Views and Indexes to perform ever necessary.
• Extensively used Dynamic SQL in creating SQL Objects.
• Designed and developed staging, landing and archive layers to bridge the gap between applications and improve performance for incremental load.
• Involved in writing Complex SQL queries and store procedures to perform data transformations as per mapping documentation.
• Created SSIS packages from scratch to perform ETL process and loaded the data into destination table.
• Validating and Looping through various file sources and loading dynamically into the database using SSIS tasks like Script Task, For Each Loop Container, ForLoop Container,
• File System Task, FTP task, Sequence Container, ExecuteSQL etc.
• Implemented Error Handling, Isolation Levels, Precedence Constraints, and Expressions in SSIS packages.
• Worked with Change Data Capture CDC tasks in SSIS packages to achieve incremental loads.
• Extensively used SSIS transformations like Data Conversion, Lookup, Fuzzy Lookup, Merge, Conditional Split, Derived Column, OLEDB command, Union All, Cache etc.
• Infrastructural design to create a testing environment along with replication implementation to separate read and write operations.
• Performed regular backups and restores of databases to refresh seed data in other environments.
• Extensively worked on SQL queries performance tuning for existing store procedures in seed/full data loads.
• Involved in Technical Design Specification Documentations and Data Dictionaries.
• Created various SSRS reports including, drilldown, drill through, Matrix Parameterized reports and DashBoard's using report builder 2.0

Hardware/Software:

MS SQL Server 2012, SQL Server Data Tools SSDT , SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, JIRA, PowerPivot, PowerView, ER/Studio, Visual Studio 2010, Team Foundation Server TFS

Confidential

SQL Developer SSIS/ETL

Responsibilities:

• Involved in Database design Development, Data Modeling, Database Creation, Normalization, Troubleshooting, Performance Tuning and Monitoring.
• Involved in creating tables, User-Defined functions, Complex Stored Procedures, Triggers, Views and Indexes etc.
• Writing complex SQL statements using joins, sub queries, correlated sub queries, Dynamic SQL, CTE, Table Variables, UDF's etc .
• Involved in developing/modifying SQL Server 2000 DTS packages and Converting Migration SQL Server 2000 DTS packages to SQL Server 2008R2 SSIS packages.
• Validating and Looping through various file sources and loading dynamically into the database using SSIS tasks like Script Task, For Each Loop Container, ForLoop Container, Bulk Insert Task, Execute SqlTask, File System task and various Data Flow Tasks.
• Optimized the performance of queries with modification of T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Writing complex Nesting Stored procedures to retrieve the data and convert into Excel Spreadsheet, CSV and PGP files by calling the DTS/SSIS packages using command line utilities DTEXEC/DTUTIL.
• Extensively used various SSIS control flow tasks like Loop Containers, Execute SQL Task, Script Task, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join , Multicast, Union all, data conversion, Multicast etc.
• Created complex SSIS Incremental Load packages to load the data on daily basis from various sources. OLEDB, Flat File, and Excel Sources
• Involved in creating various SSRS reports like Drill Down, Matrix, Parameterized, Table, Linked, Sub reports and Ad-Hoc Reports etc.
• Created Complex stored procedures/SSIS packages to audit the log information of jobs scheduled on the SQL server agent.
• Experience in developing Database Schemas / Stored Procedures / Data Dictionary.
• Experience and knowledge in designing and developing data visualization strategies.
• Experience and advanced knowledge of Kimball Methodology for Data Warehousing.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Worked on building Dashboards in SSRS.
• Experienced in Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building , testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Environment: Windows 7 Enterprise, SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server 2008R2, SSIS, SSRS, MS Excel, VB Script, C etc.

Confidential

MS SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement.
• Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Designed and implemented ETL processes with SSIS packages using Heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files, Text files, etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join , Multicast, Union all, data conversion etc.
• Worked on Huge Data Transfers from to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc and used configuration files and Environment variables for production deployment.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Implemented Server and Client side validations using ASP.NET validation controls and JavaScript.
• Used Dataset, Data Table, Data Adapter, Data Reader etc. for ADO.NET connectivity controls.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events On Warning, On Pre and Post Execution, On Task Failed etc.
• Worked on Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Worked on both Star and snow flake schemas to build cubes using the fact and dimension tables, perform processing and deployed the cubes to SQL server analysis services database.
• Generated multiple Enterprise reports using SSRS and Report Builder 2.0 from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default queried and non-queried parameters .
• Worked on all types of report types like tables, matrix, charts, sub reports, Dashboards, Linked Reports etc.
• Optimized the performance of Dashboard Reports.
• Create ad-hoc SQL queries for customer reports, executive management reports.
• Evaluated database performance and performed tuning, backup, restoration and disaster recovery.

Environment: MS SQL Server 2012 and 2008, T-SQL, MDX, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS 2008 , SQL Server Analysis Services SSAS , ETL, Business Intelligence Development Studio BIDS , MS Excel, Advanced Windows 2005 Server, VB Script, Oracle 10g/9i, XML.

Confidential

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Normalized the database into small tables by applying rules of Normalization, defined Check Constraints and applied Business Rules.
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Monitored Scheduled jobs and alerts.
• Imported various Sources, Targets, and Transformations using SSIS packages.
• Responsible for transferring the data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Analyzed reports and fixed bugs in stored procedures
• Created SQL Server Reports using SSRS 2005.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client's workstation.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Erwin 4.1, Windows Server 2003.

Confidential

BI/SQL Developer SQL/SSRS

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation e.g., file descriptions and definitions, entity relationships and attributes .
• Deploying new Database objects in production environment.
• Designed new SSIS packages and deployed them.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Writing Stored Procedures, Triggers, cursors and creating indexes.
• Fixing Bugs and Automating jobs.
• Testing and loading the data on Development and Production.
• Created DTS Package designs for Import/Export from different servers like oracle to SQL Server.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created user defined data types and added them to model database for future purpose.
• Worked on Authoring Reports and managing reporting services.
• Logical and physical database design using Erwin Tool.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Performing query plans and making sure each and every query is using appropriate indexes.
• Provided on - call 24/7 provide support.
• Provided support for in-house and off-shore Development Team.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL, ERWIN 4.0, XML, MS PowerPoint, MS Project Windows 2003 server