SUMMARY

• 8+ Years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2008.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• I have experience in DBA.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Developing reports on SSRS on SQL Server (2012/2008 R2/2008/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in SQL Server 2012 Self Service BI tools like Power view, BISM Tabular models and SQL Server Data tools.
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Performance Tuning and Query Optimization.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Strong technical experience in Web technologies like C# and ASP.NET.
• Experience in JAVA Web services and Scripting languages (HTML, Java Scripts and JQuery).
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Experience in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

TECHNICAL SKILLS

SQL Server Tools: SSDT, SSMS, BIDS, Report Builder, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools: Lite Speed, Spotlight, SCOM, SQL secure

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel 2013, Power View, PowerPivot, PPS, Tableau

Databases: SQL Server 2014/2012/2008 R2/2008/2005, Oracle 9i,10g, Teradata, SAP

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, JAVA, C#, VB

Operating System: Windows 95/98, NT, Windows XP/2003/2000, Unix, MS-DOS

Web technologies: Angular JS, HTML, XML, VBScript, SharePoint 2010, C#, ASP.NET, VB, .NET

Tools: Erwin, VS 2008/2005, Visio, TFS, Visual Source Safe, Sub Version

PROFESSIONAL EXPERIENCE

Confidential

SQL/BI Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’ Confidential ), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and UnPivot as per the client requirement.
• Worked in Object Oriented Analysis and Design in C#.
• Created Configuration Files for Packages and SSIS logging on XML Files.
• Developed different kind of reports such aDashboards, Sub Reports,Charts,Matrix reports,Linked Reports Using SSRS.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2008 R2.
• Scheduled SSRS 2012 Data alerts on mission critical reports to send alerts based on business rules.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.
• Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2.
• Setup and monitored jobs for loading and processing SSAS Cubes.
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Created ETL technical specification documents describing ETL design and load strategies to populate operational data store and DataMart’ Confidential .
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Participated in code-review sessions on existing SSRS report’ Confidential performance and Dataset query tuning.
• Designed and createdCrystal Reportsbased on technical specifications provided.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Created script tasks and components with C++.C# and VB.NET in SSIS as part of ETL load.
• Developed power view reports using Tabular Models in SQL Server Data Tools.
• Installed SQL 2012, TFS 2012. Migrated all the scripts and objects from SQL 2008 to SQL 2012
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Involved inData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Environment: SQL Server 2014/2012/2008 R2/2008, Teradata, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, BIDS, Tabular, Excel 2013, XL-Cubed, Power view, TFS, Power pivot, Performance Point, MDX, Report Builder 3.0, Crystal Report 8.0, DTS, C#, C++, VB.NET, Erwin 4.0, XML, SVN, Rally, Windows Server 2008, NET 3.5.

Confidential

SQL/BI Developer

Responsibilities:

• Design and develop Business Intelligence solutions using MSBI tools (SSIS, SSRS, SSAS).
• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’ Confidential, Views, Joins and Triggers.
• Write and debug T-SQL Queries, SSRS Reports, SSIS Packages and Stored Procedures.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Worked as Data Base Administrator (DBA).
• Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups.
• Created SSIS packages to capture the Incremental changes for the Data warehouse.
• Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse using C#.NET.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle database, DB2 and Teradata database, Excel, Flat files into the SQL 2012 Server target staging database.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Developed Dashboards, Gauges, Tabular, Matrix, Charts, Crystal reports Parameterized and Sub-reports in SSRS 2012/2008 R2.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Using SSRS creating well-formed reports and web-based reports for health related applications and transactions.
• Worked in Object Oriented Analysis and Design in C#.
• Worked on JSON objects in Web API REST Services and SOAP.
• Supported, modified and maintainedCrystal Report currently in the production environment.
• Developed complex formulas inCrystal Report for reporting calculations and metrics.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Involved in performance tuning the slow running reports and stored procedures by creating appropriate indexes and analyzing execution plans.
• Created data-driven subscriptions in SSRS using windows file share as well as Email subscriptions
• Used complex queries and Stored Procedures for generating real-time operational SSRS reports.
• Used Excel Pivot tables to manipulate data in order to perform data analysis.
• Used angular JS framework and integrated with SQL Server DB.
• Developed reports with cascaded parameters from SSAS Cubes using MDX queries and Calculated Members.
• Developed SSAS Cubes using Star Schema with partitions, aggregations, hierarchies and perspectives.
• Developed SSRS and Excel Power pivot table based on OLAP Cubes.
• Used Subversion (SVN) for source control, to deploy the code from Dev to QA, QA to Prod.
• By using ADO.NET Extracted data from database.
• Working on LINQ for query the data objects in C++, C#, VB.net.
• Responsible for Servers in SharePoint. Installed and configured SharePoint2010, maintenance of Web Front End Servers, Indexing Servers, and maintaining Database servers.
• Participated in Data modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Participated in SQL Server 2014 installation, Violin Flash Memory and POC on new features.
• Troubleshoot and resolve issues reported by business users.
• Develop and direct software system testing and validation procedures, programming, and documentation.
• Used Team Foundation Server (TFS) for central repository as a versioning control.

Environment: SQL Server 2014/2012/2008 R2/2008, Oracle 11g, Teradata, SAP, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, SQL Server BIDS, Tabular, Excel 2013, Power view, TFS, Power pivot, Performance Point, MDX, Tableau, Report Builder 3.0, Crystal Report 8.0, DTS, C++, C#, VB.NET,JSON, Erwin 4.0,XML, Violin Flash Memory, Windows Server 2008,.NET 3.5

Confidential, Tennessee

SQL Server BI Developer/SSIS/SSRS.

Responsibilities:

• Created database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.
• Involved in Testing and Debugging Stored Procedures and functions, database tuning.
• Created jobs and monitored job history for maximum availability of data and to ensure consistency of the databases.
• Designed new databases according to Business requirements like logical design and physical design.
• Migrated Multi Terabytes databases and users, logins, stored procedures and tables using DTS/SSIS packages from MS SQL Server 2000 to MS SQL Server 2005.
• Created SQL Server Integration Service packages (SSIS) and used it to Extract, Transform and Load (ETL) into Database tables.
• Import / Export Financial data from text file & Excel Spread sheet using SSIS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Deployed SSIS packages and Reports to Production Servers.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Experienced in ETL using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-average duration using SSRS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created report snapshots to improve the performance of SSRS.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2008, Visual Studio 2005, Visual Team Foundation Server.

Confidential

SQL Server BI Developer

Responsibilities:

• Ensured project requirement and delivery with active interactions with end users.
• Redesigned and tuned Stored Procedures, Triggers, Tables, UDF, Views, Recursive CTE and Indexes and able to increase performance of queries.
• Created complex Store Procedures for data profiling process needed to define structure of pre staging and staging area.
• Developed DTS packages to extract, transform and load into campaign database from OLTP database.
• Used SSIS control flow task, analysis service processing task to individually process partitions and dimensions and updating cube as changes occurs in underlying Data Warehouse.
• Designed ETL data flows using SSIS and created mappings/workflows to extract data from SQL Server and data migration and transformation from Oracle/Access/Excel Sheets using SSIS.
• Involved in all phases of report life cycle (authoring, managing and delivering).
• Created adhoc reports and complex enterprise reports (drill down, drill through reports, parameterized reports and cascading report) using SQL Server Reporting Services and Report Manager.
• Created linked reports using Report Builder.
• Used notification services to generate error messages and send them to user through e-mails.

Environment: MS SQL Server 2005, T-SQL, DTS, Windows XP, MS Visio 2000 and MS Projects 2000.

Confidential

Junior SQL Developer

Responsibilities:

• Conducted performance tuning/MS SQL Server development - SQL Profiler, SQL scripts, Stored Procedures, Triggers, Functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed Stored Procedures and Triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, advanced queries, views, indices and functions for databases.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server.