SUMMARY

• Around 5 years of IT experience in Database Development and Business Intelligence Technologies with expertise on ETL process, Integration, Reporting and Analysis using MS SQLServer as a MS SQL Server Application Developer.
• Extensive experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Experienced in developing database scripts (DML/DDL), stored procedures and other database objects necessary to accomplish project objectives
• Substantial knowledge throughout Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server.
• Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option.
• Substantial practical knowledge in scripting T-SQL queries, complex stored procedures, User Defined Functions (UDF), Database triggers.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes and Dashboard Reports to support end users using SSAS.
• Good experience in Data Analysis and Data Modeling.
• Knowledge on creating dashboards using Cosmos.
• Experience in analyzing and understanding data using SQL and Excel skills
• Experience throughout developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
• Experience in Agile methodologies.
• Good experience in Programming language/ Structural query language (PL/SQL).
• Experience in building crystal report, dashboards, scorecards and KPI’s.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Good knowledge on Micro-Strategy and Tableau.

TECHNICAL SKILLS

RDBMS: MSSQLServer 2008/R2/2012/2014

Language: MSSQL, T-SQLServer

Tools: SQLServer Management Studio (SSMS), Visual Studio

SQLServer: Business Intelligence Development Studio (BIDS)

ETL Tools: SSIS

Reporting Tools: SSRS

PROFESSIONAL EXPERIENCE

Confidential - NC

SQL BI/SSRS Developer

Responsibilities:

• Worked closely with the business Analyst for understanding the requirement and also involved in planning and designing data based on business requirements.
• Developed ETL packages with different data sources (SQLServer, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQLServer Integration Services (SSIS).
• Created and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension, Data Conversion, OLE DB command, Union All, Flat file Source, Flat file Destination, Conditional Split and more. Performed ETL mappings using MS SQLServer Integration Services.
• Created C#.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQLqueries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Created package dependencies by calling Child packages within Parent.
• Configured SQLmail agent for sending automatic emails when SSIS packages are failed or succeed.
• Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and Parameterized reports using SSRS.
• Generated SSRS Report through SSIS Package using script component as per business requirement.
• Participated in requirement gathering of the cube design using SSAS.
• Used Analyzing Services to build the data cubes using SSAS.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created jobs using SQLServer Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.
• Documented all the project work in support for maintenance.

Environment: MS-Access, SQLServer 2008/2012, SQLServer Business Intelligence Development Studio (SSIS, SSRS, SSAS), MS SQLProfiler, SQLQuery Analyzer, SQLServer Index, Microsoft Visual Studio, Micro-Strategy, SQL BI Suite (SSIS, SSRS, SSAS) TFS-2008, SQL Server Management Studio, Windows Server 2007, T SQL.

Confidential - Dallas, TX

SQL BI Developer

Responsibilities:

• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Created Tables, Stored procedures and defined functions.
• Created SQL scripts for tuning and scheduling.
• Fine-tuning of Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Performed design/code reviews to make sure that the design/code adheres to customer's standards and meet industry's best practices.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2012 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Used SSISto create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Identified and added the report parameters.
• Developed various operational, drill-through and drill-down reports using SSRS.
• Gathered requirements and design of data warehouse and data mart entities.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.

Environment: SQL Server 2008/2012, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, T-SQL, MDX, Windows 2007, XML, MS Excel and MS Access.

Confidential

SQL BI Developer

Responsibilities:

• Designed and analyzed theSQLServer database and involved in gathering the user-requirements.
• Involved in physical / logical design of database, creating and managing the database and all the database objects.
• Involved in the Normalization process to improve performance. Created Databases, Tables, Cluster/Non-Cluster Index as well as Unique/Check Constraints.
• Assisted in writing and optimizing complexSQLqueries usingSQLStored Procedures and Triggers also involved in writing T-SQLprogramming to implement Stored Procedures, Views and Functions for different tasks.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
• Created and designed ETL packages dealing with different data sources (SQLServer, Flat Files, excel etc.) and loaded the data into target data destination by performing different types of transformations using SSIS tools.
• UsedSQLServer Package Configuration technique to make Dynamic configurations.
• Used Text Files/SQLServer Logging for all SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user.
• Transferred data from various sources like MS Excel, Flat File andSQLServer using SSIS and then by using this data created reports in SSRS.
• Generated the weekly, monthly, and quarterly report by usingSQLServer Reporting Services (SSRS) for the managers.
• Created parameterized, drill down reports, matrix reports and table formatted reports to changed old reports as per requirements using SSRS.
• Created report and dashboards simply using Cosmos.
• Used expressions to Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2012.
• Verified business requirements and functional specifications.

Environment: SQLServer2008, Enterprise, BIDS, MSMS, SSRS, SSIS, SSAS, Enterprise Manager, Microsoft Visual Studio, Relational DBMS, Client-Server Architecture, Clustering, MS Office 2010.

Confidential

SQL Developer

Responsibilities:

• Performed creation, manipulation and support for SQLServer databases.
• Involved in creation of tables, indexes, sequences, constraints, functions, triggers, views and joins.
• Helped in integration of the front end with the SQL server backend.
• Created triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL server, and also wrote stored procedures for application developers.
• Planned the complete backing up of database and restored the database from disaster recovery.
• Designed logical and physical data models using Erwin.
• Involved in migration of data (Import & Export of data) from one server to other servers using tools like data transformation services (DTS).
• Written complex T-SQLstatements (Queries) for retrieval of data and involved in performance tuning of TSQL queries.
• According to the business requirements made the documentation of the performed tasks.
• Extensively used SQLprofiler for troubleshooting, monitoring, and optimization of SQLServer and non-production database code as well as T-SQLcode from developersand QA.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQLProfiler, Erwin, XML, T-SQL.