SUMMARY:

• Skilled software professional over 8 years of IT industry experience with Microsoft SQL Server, Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) environments.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
• Experienced using T - SQL in SQL Server platform.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL.
• Efficient in using Inner, Outer and Cross Joins, sub-queries for complex queries involving multiple tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environments and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Hands on experience in performance tuning, query optimization, and database optimization.
• Expertise in solving dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Experience in using Try Catch block introduced in SQL Server 2005.
• Good knowledge in using system tables such as sys indexes, sys processes, and sys objects and sys comment in various queries and using Database Console Commands (DBCC).
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server databases.
• Migration experience with DTS to SSIS 2005.
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, Send mail task, For loop container, For each loop container, Sequence container) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge, Multi cast, Derived column, Character map, Union all, Sort, Row count, OLEDB command).
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
• Experience in enhancing and deploying SSIS Packages from development server to production server.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Created Crystal Reports on daily, weekly and monthly basis for manager’s review.
• Strong experience in developing parameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS 2005/2008 using data from a variety of sources.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in Designing and Building the Dimensions and cubes with star and Snowflake schemas using SQL Server Analysis Services (SSAS).
• Experience in creating the MDX queries to access cubes and dimensions (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008/2005/2000/7.0, Oracle, MS-Access 2000/2003

Programming Language: T-SQL, C, C++,C#, PL/SQL, XML,HTML, VB .NET, Visual Basic 6.0

Operating Systems: Windows Server 2003, Windows XP/ 2000/ 95/ NT, Linux, UNIX

SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Import & Export, Visual Studio Net, Toad, Quality Center (QC).

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services(DTS), Informatica

OLAP/ Reporting Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting services (SSRS), Crystal Reports, Tableau Desktop Reporting, Ex-cell, Power BI, R.

Data Modeling Tools: E-R Diagrams, Fact and Dimension Tables, Erwin, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue WA

SQL BI Developer

Responsibilities:

• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2014 and MS SQL Server 2008 respectively.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008/2013 (SSRS).
• Worked on Data Extraction, Transformation and Loading (ETL) between different Databases like SQL Server, Oracle, and Hadoop.
• Involved in data migration projects.
• Worked on data migration from Oracle databases to Hadoop clustered.
• Modified existing Packages as per new Hadoop environment and tested those packages in QA server before deploying to production servers.
• Strong experience in Stored Procedure/TSQL coding, Performance tuning, and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL join.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2013.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters and cascaded parameters in the reports using T-SQL.
• Improved Report Performance and performed unit testing.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Build Reports based on Power BI.
• 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.
• Modified existing reports according to requirements of the end users.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Created Reports and Dashboard Reports using Tableau.
• Modified existing SSRS Report to Tableau Reports as per business requirement.
• Worked with the tools in Hadoop Ecosystem including Pig, Hive, HDFS, MapReduce, and Spark.
• Experience in using JIRA and Quality Center Ticketing Tools to track the user requests .
• Involved in Business Analyst roles also like gathering requirements from Customers and Vendors and documenting that requirement details.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.

Environment: Microsoft SQL Server 2014, Microsoft SQL Server 2008/2008R2,Visual Studio 2013, Visual Studio 2010, Visual Studio 2008,T-SQL, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Team Foundation Server(TFS), Visual Source Safe and Share point 2010 MS Word, Ex-cell, Tableau Desktop Reporting, Hadoop.

SQL SSRS/SSIS Developer/QA

Responsibilities:

• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Experience in using T-SQL in SQL Server 2000/2005/2008 and 2012 platforms.
• Created dataflow and its relational models in MS Visio
• Experience in Performance Tuning and Query Optimization.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Created many Drill through and Drill-Down reports using SSRS.
• Designed and developed various custom defined reports using SQL Server Reporting Services (SSRS) and deployed them on SharePoint 2010 Portal.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Developed reports using VB.Net and C# Scripts.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the Reporting.
• Involved in full life cycle development of data mart and supported the existing BI platform for populating the data warehouse.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: Microsoft SQL Server 2008R2, Microsoft SQL Server 2012,Visual Studio 2012, Visual Studio 2010, Visual Studio 2008,T-SQL, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Team Foundation Server(TFS), Visual Source Safe and Share point 2010 MS Word, Ex-cell.

SQL SSRS/SSIS Developer

Responsibilities:

• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2008R2.
• Configured SSIS packages using Package configuration wizard to allow Packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created usage based aggregations in cube to minimize time for query retrieval.
• Create Different types of reports based on customer Request.
• Create Sub Reports and Drill-Through Reports and developer them to share Point Server.
• Working on performance tuning to Test the Query Execution.
• Created Ad-hoc Reports, Sub Reports, Drill-Through and Drill-Down Reports.
• Data migration using DTS services across different databases like Oracle, MS access 2003 and Flat Files and have experience in creating forms and templates. Involved on designing, developing, deploying, and operating Kimball Method data warehouse/business intelligence system on the Microsoft BI platform
• Involved in Designing moderately complex ETL and incremental updates supporting both OLTP and Data Mart environments.
• Involved in Oracle Technologies including Oracle Extract data
• Involved in designing, developing, deploying, and operating Kimball Method data warehouse/business intelligence system on the Microsoft BI platform.
• Created perspectives, partitions, drill through actions and KPIs to enhance Cube’s utilization.
• Have experience in Teradata and Teradata load utilities in SQL and in Oracle.
• Helped the tester in pay roll related data in data to decisions project.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.
• Worked with Walkthrough to Debugging a Batch that Runs on the AOS.
• Created Datasets in T -SQL, stored procedures for SSRS.
• Worked on Converting Congo’s Report into SSRS Reports.
• Worked on Power View and Power Pivot and Share point 2010.
• Have knowledge on Unix-shell commands and basic knowledge on scripting (shell and Perl).
• Performed tests to identify and resolve performance related bugs.
• Involved with Query performance tuning by using SQL Profiler and Execution Plan.
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Involved with Delaware housing and Data mart, Cube creations.
• Reviewed the Business Requirements document with the business and development teams to understand the architecture and functionality of the application.

Environment: Microsoft SQL Server 2008R2, Microsoft SQL Server 2012,Visual Studio 2008, Visual Studio 2010, T-SQL, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Team Foundation Server(TFS), Visual Source Safe and Share point 2010 MS Word, Ex-cell, cogon’s Repots.

SQL Server BI Developer

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business users.
• Created database objects like tables, views, stored procedures, functions, joins, indexes and triggers in T-SQL based upon the functional specifications.
• Worked on Performance Tuning and Query Optimization.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code and optimized.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
• Involved in Data migration and legacy data cleansing validation.
• Involved in Building and unit testing production deployment packages and implementation plans for scheduled systems enhancements.
• Involved in development of Business Intelligence Solutions using Informatica and SSIS.
• Excellent skills in overall Defect Management/Problem solving including tracking bugs and reporting using Test Director.
• Created documentation for SSRS reports and codes, and tested SSRS reports developed by other developers.
• Involved in Data Integration by identifying the information needs within and across functional areas worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Deployed SSIS package on the server and scheduled the packages using SQL Server Agent Services.
• Involved in populating data on various systems like Sybase Adaptive Server in linked server.
• Involved in populating data on various systems, generating data reports using Reporting Services (SSRS) and deploying them on the server.
• Worked on Power Pivot and Share point 2010.
• Designed and developed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS.
• Expertise in developing Ad-Hoc, Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in the design, implementation, and support of a Kimball method data warehouse on SQL Server and Oracle as per customer requirement.
• Worked on Cogon’s Reports, Business Objects Reports.
• Worked on VBA with Ex-cell and MS Access.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Reporting Services (SSRS), Windows 2003, MS Access, Report builder3.0, EXCEL,SQL Server Profiler, DTS, ASP.NET., VBA with Ex-cell.

MS SQL Server Developer

Responsibilities:

• Installed and configured SQL Server7.0 Servers and clients.
• Designed and developed the databases.
• Created a logical design and physical design of the data warehouse using star schema.
• Configured the DTS packages to run in periodic intervals.
• Database Design (Relational and Dimensional models) using Erwin
• Extensively worked with DTS to load the data from source systems.
• Writing stored procedures and triggers extensively and working very closely with developers, Business Analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Created FTP connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Creating Logins and Roles with appropriate permissions.

Environment: Windows XP, SQL Server Business Intelligence, SSRS, T-SQL, MS Visual Studio 2005, Report builder.