SUMMARY

• 7+ years of IT experience in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of SQL BI in domains like Finance, Insurance, health, Logistics.
• Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources (Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server.
• Extensive experience in MS SQL Server 2008/2012 with Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Proficient in logical and physical data modeling, Forward and Reverse engineering using ERwin, Normalization, de - normalization and building Referential Integrity Constraints.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Expert in monitoring SQL Server Performance, troubleshooting using Execution Plan, SQL Profiler and Index Tuning Wizard.
• Extensive experience in creating various reports using Reporting Services (SSRS 2008 R2/ 2012) and Deploying and managing reports on Report Server and SharePoint Server.
• Experience in ETL process using Integration Services (SSIS) SSIS Import Export Data, Bulk Insert, BCP and DTS/SSIS Packages and deploying and automate SSIS Packages and SSRS reports.
• Scheduled and monitored all maintenance activities of SQL Server to meet business requirement activities including database consistency check.
• Experience in business intelligence/data warehousing practices and tools (including SSAS).
• Knowledge in developing SSAS Cubes using Visual studio 2008 R2/ 2012. Creating Reports from Cubes using MDX.
• Familiar in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Experience in C#.NET, ASP.NET, ADO.NET, JQuery, JavaScript, HTML, CSS
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Database Management System: Microsoft SQL Server2012/ 2008 R2/2005/2000, MS AccessOracle 10g

Database Utilities: SQL Enterprise Manager, Query Analyzer, SQL Profiler, SQL Server Management Studio, Business Intelligence Development Studio(BIDS), SSDT, Database Tuning Advisor

ETL Tools: SQL Server integration services (SSIS), Data Transformation Services (DTS)

Reporting Tools: MS SQL Server Reporting Services(SSRS), Crystal Reports

Programming Language: TSQL, PL/SQL, C#, VB.NET, ASP.NET, ADO.NET, HTML, XML, JavaScript, CSS

Operating Systems: WIN 2008/2003/XP/NT/7, UNIX, LINUX

Servers: IIS 5.1/6.0/7.0/7.5

Utility Tools: MS Office, Visual Source Safe 6.0, TFS, Erwin

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL BI Developer

Responsibilities:

• Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.
• Responsible for performance tuning and optimization of SQL queries and indexes.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2008.
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services 2012.
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS 2012 with various complex transformations.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, Charts and Sub reports
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: MS SQL Server 2005/ 2008/ 2012 , T-SQL, MS SQL Integration Services 2008/2012, MS SQL reporting Services2005/ 2008 R2/ 2012, ASP.NET, C#.

Confidential, Bloomington, IL

MS SQL Server Developer/BI Developer

Responsibilities:

• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly and Created crystal reports and hosting it in the web for the users.
• Developed complex T-SQL code for the application. Worked in Reporting Manager for job scheduling and batch queries. Planned Backup strategy based on projects requirements
• Monitored performance and optimized SQL queries for maximum efficiency.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-downreports and ad-hoc reports using SQL Server 2008 R2 Reporting Services.
• Designed and created reports and distributed reports in multiple formats such as Excel, PDF, XML, HTML, TIFF and CSV using SQL Server 2008R2 Reporting Services.
• Configured and Deployed different reports in the Servers using SQL Server 2008 R2 Reporting Services.
• Developed different types of ad-hoc reports using Report Model and Report Builder tools of SQL Server 2008 R2Reporting Services.
• Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.
• Created Cascade and parameterized reports.
• Responsible for deploying the generated reports on the production environment after validating them in the QA environment and Debug the reports using Stored Procedures
• Reviewed and analyzed technical and application related problems. Identified the data source and defining them to build the data source views.
• Involved with DBA for the maintenance of database and implementation Snapshot Replication. Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Scheduled Job and alerts. Designed and implemented user log in and security.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services 2008S, MS SQL Server Integrtion Services 2008, Crystal Reports, Oracle 10g, Windows XP.

Confidential, IL

MS SQL Server Developer/BI Developer

Responsibilities:

• Developed T-SQL queries, stored procedures, functions and triggers for this complex integration. Actively involved in different stages of Project Life Cycle.
• Generated reports (using SQL Server Reporting Services) based on the user requirements to produce detailed summary for analysis.
• Developed complex Stored Procedures, triggers, cursors, tables, constraints, views and other SQL joins and statements for applications.
• Using all kinds of SQL ServerConstraints(Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• Writing ComplexT-SQLQueries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Scheduled Jobs on various stored procedures and packages to automate processes.
• Created SQL server Reports using SSRS 2008. Created drill down reports, drill through reports, charts report and parameterized Reports in SSRS 2008.
• Identified the data source and defining them to build the data source views. Generated Reports using global variables, expressions and functions for the reports.
• Responsible for deploying and managing reports on Report Server.
• Responsible for creating various kinds of Subscriptions like Email subscriptions and File Share Subscriptions.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling worked with different methods of logging in SSIS.
• Experienced in critical problem solving, building tools to integrate and manage large sets of data.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: SQL Server 2008, 2012, SSRS 2008 R2, SSIS, .Net Frame Work, ADO.Net, ASP.Net 4.0, XML, Java Script, C#

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated reports using Expressions and Functions using SSRS.
• Generated various reports like Matrix reports, Tabular reports, and Chart reports, link Reports, Drill down reports, parameterized.
• Involved to optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Implemented failure alerts using email in SSIS.
• Snapshot Replication was being used to synchronize the data between their Different Stores.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically.
• Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through MSXL using crystal reports.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.

Environment: SQL Server 2005, 2008, 2012, SSRS/ SSIS/SSAS 2008 R2, .Net Frame Work, ADO.Net, ASP.Net 4.0, XML, Java Script, C#

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Involved in gathering business requirements from the Product owners.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Fixed the bugs present in already existing reports
• Converted Crystal reports to SSRS reports.
• Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports
• Deployed the generated reports directly on the client’s workstation
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.

Environment: MS SQL Server 2008, T-SQL, SSRS, SSIS, Crystal Reports10.0, Visual Studio 2008, win NT /2000/ 2003, MS Office 2007/2003.