SUMMARY

• 9 years of IT Experience in Development and Support of Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
• Experience in Data Schema Design, and Table Design.
• 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.
• Worked in SDLC (Systems Development Life Cycle) for developing systems/Software.
• Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning.
• Experience in MSBI tools like SQL Server Integration Services, Analysis Services and Reporting Services.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP experience with experience on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Worked with T-SQL, DDL, and DML Scripts and established Relationships between tables using
• Proven ability in Performance Tuning, Query Optimization and Running Database.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages.
• Used DTS/Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2008 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Deployed and shared the reports with rules and permissions defined on the report manager for data driven subscriptions.
• Used SSISto implement the slowly changing transformation to, maintain historical data in data warehouse.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Created SSRS dashboards using charts, gauges, indicators and data bars.
• SSAS administration including configuration, trouble shooting and monitoring processes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Involved in designing Aggregations and pre-calculations in SSAS.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), SQL Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts & SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DBCC, BCP, SQL Server Profiler.

ETL: DTS, SSIS

Reporting Tool: SSRS, Crystal Reports, Business Objects

Programming Languages: T-SQL, C, C++, .Net, JAVA

Databases: MS SQL Server 2005/2008 R2/2012/2014, Oracle 9i/10g/11g, SQL & MS Access

Data Modeling Tool: Erwin, Microsoft Visio, performance point server, Power Pivot.

Operating System: Microsoft Windows 95/98/2000/2002/ Vista/Windows 7/Windows 8/ Mac OS X

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL BI Developer

Responsibilities:

• Involved in full software development life cycle for analysis, design, development, documentation, testing, delivering projects on Time.
• Created various database objects tables, indexes, views, stored procedures and triggers, Co-related sub queries, Dynamic SQL queries and implemented referential integrity constraints for enforcing data integrity and business rules.
• Experience in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Experience in Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all and experience in Incremental data loading.
• Worked on Control Flow items like Bulk Insert Task, Execute SQL Task, Script Task, Containers, Send Mail Task, FTP tasks and Execute Process Task.
• Worked with SSIS packages involving Fuzzy Lookup, Fuzzy Grouping, Aggregate, Conditional Split, Derived Column, Merge, Merge join, Sort, Pivot and Unpivot Data Flow Transformations.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various users
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Deployed and shared the reports with rules and permissions defined on the report manager for data driven subscriptions.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models using SQL Server Reporting Services (SSRS) based on client requirement.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.
• Created SSRS dashboards using charts, gauges, indicators and data bars.
• SSAS administration including configuration, trouble shooting and monitoring processes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Involved in designing Aggregations and pre-calculations in SSAS.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Extensive used Team Foundation Server to implement version control for MSBI (SSIS/SSRS/SSAS) projects.
• Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.
• Worked on enterprise solutions development with rapid SDLC Agile Methodologies, SCRUM.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Involved in designing Aggregations and pre-calculations in SSAS.

Environment: Windows 2008, SQL Server 2014, MS SQL Server 2102/2008 R2, T-SQL, MS Office, Visual Studio, TFS, VB.Net, SQL Server Management Studio, SSIS, SSRS, SSAS.

Confidential, MN

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse Involved in installing and maintaining MS SQL Server 2008R2 /2012.
• Experience in designing Database Models using Erwin.
• Involved in designing the Logical and Physical data models for the data warehouse.
• 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.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• 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.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• 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.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Responsible for maintaining and updating databases.
• Migrated databases from SQL Server 2008R2 to SQL Server 2012.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• 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.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• 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 2008R2.
• Created dimensions, levels and hierarchies.
• Responsible for unit testing and integration testing complex queries.
• Created SSRS dashboards using charts, gauges, indicators and data bars.
• SSAS administration including configuration, trouble shooting and monitoring processes.

Environment: SQL Server 2008/2008R2/2012 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003/2008R2/2012, SharePoint 2010.

Confidential, Farmington Hills, MI

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Had an experience on Microsoft Office PerformancePoint Serverand power pivot for planning and budgeting component directly integrated with Excel.
• 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 2008.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Developed a High level dashboard using SSRS 2008. .
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules usingT-SQL
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, Microsoft office Performance Point Server and Power Pivot, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in requirements gathering, designing, development, testing and documentation of the ETL process as well as custom reports.
• Implemented logical and physical modeling using Ervin data modeler.
• Responsible for modifying and maintaining ETL (SSIS) framework Documentation.
• Created and modified SSIS Packages to extract data from heterogeneous sources to staging tables and from staging tables to data warehouse.
• Used SSIS for data cleaning, data scrubbing, and data migration.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard.
• Responsible for scheduling and Maintaining SSIS Package using SQL server agent.
• Created various Database Objects - Tables, Indexes, Views, store procedures etc.
• Improved Performance by creating Clustered and Non-clustered Indexes by optimizing the T-SQL statements using SQL profiler and database engine tuning.
• Designed and developed different type of reports including: Tabular, Matrix (cross Tab report), Conditional, List items, Charts, Sub reports, and Drill down reports.
• Created SSRS reports.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports.

Environment: s: MS SQL Server 2008, Enterprise Edition, MS SSRS 2008, MS SSIS 2008, T-SQL, VB Script, Windows Server 2003, Erwin 7.1.

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.