SUMMARY

• 9+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance, Health Care Services.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience with T - SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience in Using multiple join statements to retrieve data from multiple tables
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
• Experience in different phase of Software Development Life Cycle (SDLC) of development of applications.
• Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning and had experience in Microsoft Office Performance Point server and power pivot.
• Experienced in upgrading SQL Server 20 /2012 and data migration among versions.
• Created ETL packages usingSSISto move data from various heterogeneous data sources.
• Implemented error handling and roll back process inETLload.
• ConfiguredSSISpackages usingPackageconfigurationwizard to allow packages run on different environments.
• Worked with Financial companies for application related pricing and security applications
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Proficient in buildingCubes,definingReferenced Relationshipsand creating Hierarchies in SSAS.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expertise in.NET frameworkwith great proficiency in creating applications usingWin Forms, Web Forms, Entity Framework, ASP.NET, C#/VB.NET, ASP.NET MVC, ADO.NET, XML, AJAX toolkit, Cascading Style Sheets (CSS), JavaScript, WCF, WPF,IIS7.0, SQL Server 7.0/2000/, LINQ and Visual Studio.NET.
• Experienced working with different Source and Version Controlling Systems such as Visual SourceSafe (VSS), SVN and Team Foundation Server (TFS).
• Microsoft Certified Technology Specialist.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Operating Systems: Windows server 2012R2/2012/ 2008R2/2008/2003 Advanced Server, Windows 10/8.1/8/7/ XP/2000, UNIX, Linux.

Databases: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g/10g/9i, DB2, MS Access 2013/2010/2007 , My SQL.

Database Technologies: SQL Server Enterprise Manager, Data Transformation Services (DTS), DTA, SQL Server Activity Monitor, SQL Server Logs, SQL Server Agent - Jobs, Alerts DB Mail and SQL Mail, SQL Server Management Studio, SSIS, SSAS, SSRS, DBCC, BCP, BIDS - SQL Server Data Tools. SQL Query Analyzer, SQL Profiler, PL/SQL, T-SQL, Power BI, Excel.

Reporting Tool: SQL Server Reporting Services (SSRS), Crystal Reports, BO.

Languages: Java, C, C++, C#, HTML, XML/XSLT, .Net, VB.

Other Tools: Erwin, Microsoft Visio 2003/2000, Microsoft Project/Office 2013/2, ER Studio, Share Point, Web services.

PROFESSIONAL EXPERIENCE

Confidential, Downers Grove, IL

SQL BI Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse Involved in installing and maintaining MS SQL Server 2008R 2 /2012/2014.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T- SQL.
• Create the clustered/non-clustered indexes on tables; Trace out for any table required any indexes and determine the type of index on it.
• Involved in database designing using Normalization.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, Oracle to MS SQL Server and vice versa and schedule the jobs.
• Responsible for maintaining and updating databases.
• Good SQL Server Administration skills including Backups, Restore, database maintenance, user authorizations and Database creation.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
• Optimized indexes to improve queries and analysed database performance with SQL Profiler.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008R2/2012.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Developed many cubes for reporting based on the business requirements using SSAS.
• Involved in development & deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Used TFS (Team foundation server) for deployments of database changes, SSIS packages & SSRS reports.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Created script tasks and components C#.Net in SSIS as part of ETL load.
• Responsible for unit testing and integration testing complex queries.

Environment: SQL Server 2008R2/2012/2014, T-SQL, SSIS, SSRS, SSAS, Team Foundation Server (TFS), Windows Server 2008R2/2012, C#.Net, SharePoint 2010, Crystal Reports 9.0.

Confidential. MN

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for gathering project requirements from the users for designing and developing data warehouse as needed.
• Responsible for managing BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Responsible for creating Databases, Tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Performed backup/restore database objects such as tables, procedures, triggers, constraints, indexes and views.
• Migrated SQL server 2008R2 to 2012.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, and charts and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2/2012.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS
• Responsible for creating and executing Test cases, performing UAT and documenting the results.
• Integrating and managing SSRS reports in SharePoint environment.
• Responsible to create and deploy Data sources, data sets, reports to the SharePoint document library.
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Worked with SQL Server Analysis Services (SSAS) that delivers Online Analytical Processing (OLAP) and data mining functionality for business intelligence applications.
• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS 2008/2012.
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS 2008/2012 and in adding calculations using MDX.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Designed and deployed SSAS cube for reporting P&L's in an effective and efficient way to users and to overcome the drawbacks of excel pivots.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Performance tuning the existing reports.
• Worked on Team foundation server (TFS), created team projects and builds to deploy databases, ETL Packages, SQL jobs.
• Created script tasks and components with VB in SSIS as part of ETL load.
• Worked in an Agile Scrum model and collaborating with Scrum Master, QA, Product and Development Teams using Agile.

Environment: SQL Server 2008R2/2012, SSIS, T-SQL, SSRS, SSAS, Team Foundation Server(TFS), Windows Server 2003/2008R2/2012, VB.Net.

Confidential - Farmington Hills, MI

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Developed, monitored, deployed, scheduling jobs, alerting and maintaining SSIS packages.
• Set up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Involved in database development by creating oracle PL/SQL Functions, Procedures, Triggers, and Packages.
• Deploying SSRS Reports across multiple environments including Test, Production and supporting environments including Reporting Services Report Manager.
• Involved in development & deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
• Configured Transactional replication on migrated server.
• Created Tabular, Charts, graphs and sub reports etc as per customer requirements using SSRS.
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using oracle tools like PL/SQL Developer, SQL* Plus, Toad.
• Identified and Defined Key Performance Indicators in SSAS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created and Modified Triggers and Dynamic Cursors in T-SQL for maintaining SQL server databases and assigned permissions to a role for Stored Procedures for Application Developers.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Used VB.Net to create user define functions in SSRS.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Developed cubes for reporting based on the business requirements using SSAS 2008
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.

Environment: TSQL, MS SQL Server 2008R2/2008, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Confidential

MS SQL Server Developer

Responsibilities:

• Managed Enterprise and Distributed Data Warehouses in Developmental and Production Environments using SQL 2005.
• Build and maintain complex SQL queries using T SQL for data analysis, data mining and data manipulation.
• Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
• Created/designed reports using SQL Server Reporting Services according to user requirements.
• Responsible for writing SQL queries, Procedures, Functions and Database triggers.
• Good Experience in Tuning and Optimization of T- SQL stored procedures.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Deployed and Scheduled the Reports in Report Manager.
• Extensively used the SSIS package to write the data from the flat files into tables.
• Extensively used Explain Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Different database triggers were created and stored in the database and fired off when contents of database were changed.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Develop documentation of database architecture, system processes and procedures.
• Create, review and produce migration scripts of database objects from development to production environments.

Environment: MS SQL Server 2005/2000, MS SQL SSRS, SSIS, T-SQL, PL/SQL, Windows 2003 Server.

Confidential

Junior SQL Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic for Upload download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle, Visual Basic, Excel.