SUMMARY * Experienced in Database technologies like SQL Server, MySQL and Oracle. * Experienced as BI developer/analyst on designing, developing and implementing reporting systems using tools like SSRS, Power BI and Tableau. * Worked with end users and business analysts to understand business requirements, recommended technical solutions and documented functional requirements. * Worked on various Microsoft technologies tools and different third party tools for reporting. * Experienced in creating DAX Expressions and implement partitions in Tabular Models for Power BI. * Experienced in publishing Power BI Reports of dashboards in Power BI Server and Scheduling the dataset to refresh for upcoming data in Power BI Server. * Experienced in create reports in Power BI Desktop and Service utilizing the connectors and content pack. * Experienced importing data from different data source to create Power BI reports and dashboards. Experienced with the SDLC process - performing detailed analysis, collecting business requirements, Design, Development & implementation. Experienced with DDL and DML Scripts, Joins and established relationships between tables using Primary Keys and Foreign Keys for T-SQL and PL/SQL. * Knowledge of Data warehouse, Data modeling with Star schema and Snowflake schema. * In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. * Experienced in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables. * Knowledge of Database Recovery models, Performance tuning, Database backup and disaster recovery procedures. * Expert in creating Databases, Tables, Stored Procedure, Triggers, Views, User defined data types, Cursors and Indexes using T-SQL. * Knowledge in analyzing Data warehouse by building and deploying cubes using SQL Server Analysis Services. * Knowledge of Devops process and data modeling - OLAP & OLTP * Ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision. * An excellent Inter-personal skill with ability to develop creative solutions for challenging client needs using design pattern. Experienced with Dynamic SQL, Composite data types & Global Temporary Tables * Developed various operational Drill-through and Drill-down reports using different reporting tools. * Published the Weekly Status report to the customer on Test Status and highlighting the issues to address immediately. * Good experience in conducting Triage Meetings with Business, Development and Test Teams. * Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation. Esferasoft Solutions [Mohali, India] SQL /BI Developer Jan 2013 - Dec 2014 * Experienced in BI solutions using T-SQL, SSRS and Programming using DDL, DML, DCL commands and stored procedures for various business applications. * Establish and maintain backup and recovery policies and scheduling of SQL jobs. * Developed SQL scripts, indexes, and complex queries. * Experienced in Optimizing and performance tuning database activities. * Experience in Database Normalization, Designing, Creating Indexes, Developed Queries in MS SQL. * Using all kinds of SQL Server Constraints like Primary Keys, Foreign Keys, Defaults, Check, Unique. * Creating and Managing users, roles and assigning necessary permissions. * Worked in Creating Tables, Views, and Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T-SQL statements for various applications. * Experienced in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). * Experienced in building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, excel files, legacy systems and loading into SQL Server. * Experienced in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports. * 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. * Deployed and Subscribe Reports using SSRS to generate all daily, weekly, and monthly Reports. * Created ad-hoc reports using SQL server 2008, 2008 R2, 2012 Reporting Services (SSRS). * Worked on creating SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets. * Have hands on experience and proven track record of expertise with performance tuning. * Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins. * Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services. * Integrated databases with other information systems like Enterprise Resource Planning and Customer Relationship Management systems, including cloud-based services. * Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server. * Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box. * Developed various types of complex reports like Tabular, Matrix, Drill Down, Drill through, Cross tab reports, Sub-Reports, parameterized reports and charts using Tableau. * Involved in scheduling, creating snapshots and subscriptions for the reports using Tableau. NEC Technologies India Pvt.Ltd. [Delhi, India] SQL Database Developer/Tester Feb 2011 - Dec 2012 * Part of database support team as a contract employee, job included from creation of SQL objects to business intelligence with SSIS and SSRS. * Writing T-SQL Code, SSIS Packages and managing SQL Server Jobs on daily basis. * Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application. * Writing complex SQL code and testing long running procedures to minimize run time. * SSRS web based report writing, review of reports and deploying reports to different environments. * Documentation of incident management and reporting. * Good Knowledge in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger. * Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures, Reporting and Tracking the defects. * Maintained close collaboration with Clients to ensure timely support whenever necessary. * Extensively developed complex PL/SQL packages for Invoice Processing. * Designed tables, views, various SQL queries, stored procedures, and functions. * Involved in T-SQL code review and modification for the development of new requirements. * Worked with Dynamic SQL, Composite data types & Global Temporary Tables and involved in partitioning of very large tables. Used list and range partitioning. * Performed Cross Browser testing using different browsers like IE 8, Firefox, Safari and Chrome. * Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated. * Experienced in reviewing/reporting, tracking and maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, Clear QUEST, Bugzilla, and Email. AcmeMinds [Panchkula, India] Jr. Database Developer Jan 2010 - Dec 2010 * Experienced on querying and debugging SQL scripts including DDL, DML and DCL commands. * Experienced in creating stored procedures, table valued functions, triggers and views using base tables. * Worked on transactional queries and prevented dirty reads, non-repeatable reads, phantom reads and deadlocks using isolation levels. * Experienced in database integrity checks using DB utilities and maintenance plan configuration wizard. * Used ALTER statements to check and manage database consistency, statistics, index fragmentation. * Updated the Error Logs and documented the resolutions. * Moved files between the File Groups and partitioned the tables to improve the performance. * Monitored SQL server performance using profiler to find performance. * Implemented different types of constraints on tables and monitored Scheduled jobs and alerts. * Development and implementation of backup and recovery strategies. * Performed database consistency checks at regular intervals. * Worked on modifying existing database by adding tables and relationships * Used SQL Indexes for improving query performance, lower storage and maintenance. * Created Jobs for database maintenance Index fragmentation, database statistics. * Database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications. * Involved in Functional, System, Regression and smoke testing. * Extensively used Defect Management tool for Defect Reporting & Tracking using HP Quality Center. * Generating Test Summary and Sign off Reports.

Highlights:

• Microsoft SQL Server
• Stored Procedures
• Structured Query Language
• Management
• Query
• T-SQL
• Triggers
• Business Intelligence
• Data Definition Language
• Dcl