SUMMARY

• Around 5 years of strong IT experience MS SQL Server 2008/2012, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Service), SSAS (SQL Server Analysis Service).
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Strong in monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor.
• Strong experience in SQL database architecture, design & development data modeling (logical, physical and conceptual) using SQL server enterprise manager & Visual Studio.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Efficient in upgrade and migration from SQL Server 2005/2008 to SQL Server 2012.
• Great Experience of Cube development and deploying, that includes working with mid-size to large Cubes.
• Great experience of building Data warehouse and data mart.
• Strong experience in designing complex reports like Sub reports, Drill down and Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SSRS based on requirement.
• Hands-on experience with OLAP tuning and partitioning.
• Experience with physical implementation of moderately complex logical. OLAP designs.
• Teamwork spirits in multicultural environment, Quick learner and eager to learn new technology and deliver results in appropriate manner.

TECHNICAL SKILLS

Data Warehouse Tools: COSMOS, ScopeFor Big Data MS SQL Server 2005/2008/2012 Analysis Services, Data Mining Tools, Integration Services

Business Intelligence Tools: SQL Server 2008/2012 Business Intelligence Development Studio, MS Data Tools

Reporting Tools: MS-Access Reports, SQL Server 2005/2008/2012 Reporting Services, MS- Excel 2010/2013, Power BI, Tableau

Languages: T-SQL, C#, XML, HTML, XHTML, CSS, ASP.Net, Scope

Development Environment: Visual Studio.Net 2013/12/10/08/05 , TFS

Data Modeling Tools: Microsoft Visio 2010/2013

Operating Systems: Windows 8.1/8/7, Vista, 2003/XP/2002 Server/2000/Me/NT/98/95

XML Technologies: X path

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server/ BI Developer

Responsibilities:

• Installed and configured MS SQL Server 2012 along with Visual Studio.
• Migrated database from SQL server 2008 to SQL server 2012 using SSIS packages.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Developed SSIS Packages for Incremental and Slow Changing Dimension.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, T-SQL Scripting.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to create complex reports and Prepare the List Report to Manager and finance dept. for drivers’ commission purpose. Extensive use of T-SQL in DDL and DML commands for various applications.
• Great Experience in creating database in 3rd NF.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Extracted data from heterogeneous sources with ETL and populate dimension and fact tables.
• Using MDX Query, developed, tuning, partitioning and deploying cubes.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Developed Cross-Tabbed and Sub-Reports in SSRS and Designed and developed matrix and tabular format drill down, Linked reports with drop down menu option using SSRS.
• Prepare Ad hoc reports with Power Bi.
• Data visualize and prepare with Power View and Power Pivot.
• Generated the various kinds of reports and automated reports for daily, weekly, monthly for executives.

Environment: MS SQL Server 2012 Enterprise Edition, T-SQL, SQL Server Reporting Services (SSRS) 2012, SQL Server Integration Services (SSIS) 2012, SQL Server Analysis Services (SSAS) 2012, SSDT, SQL Profile, Database Engine Tuning Advisor, Visio Studio.

Confidential

BI Developer

Responsibilities:

• Create database in 3rd NF and optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Build, develop, and manage a SQL Server relational database using data warehousing best practices.
• Provide development including responsibility for the day-to-day performance, maintenance, and monitoring of the Data Warehouse system and its technical interfaces.
• Design architecture, map business rules and processes into technical solutions.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Developed Cross-Tabbed and Sub-Reports in SSRS and Designed and developed matrix and tabular format drill down, Drill through and Linked reports with drop down menu option using SSRS.
• Hands-on ETL development.

Environment: MS SQL Server 2008, SQL Server Integration Services 2008, SQL Server Reporting Services 2008, BIDS, Visual Studio 2010/12, C#

Confidential

QA Engineer

Responsibilities:

• Created test plans, set acceptance criteria and test scenarios
• Collaborated with software developers to create detailed test strategies, test plans and test cases.
• Preparing test report
• Writing and modifying test cases
• Execute Manual Test cases
• Created Bug and verify bug fixes
• Discussion of the reports and bug resolution with development team, team members and QA Leads
• Developed test matrix and test cases for different browsers vs platforms

Environment: SQL Server 2008, Visual Studio, TFS, C#