SUMMARY

• 5+ years of IT experience in database design, development and support of Microsoft SQL Server for Production/Development environments.
• Deal with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Design and develop Data, Data Marts using multi - dimensional data models such as Star Schemas and Snowflake Schema.
• Good knowledge of Database Administration operations like Backup, Restore and excellent knowledge in Transact-SQL (DDL, DML, DCL).
• Strong in T-SQL scripts, dynamic SQL, creating indexed views, cursors, indexes, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Expertise in transforming complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Manage indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans.
• Good in code migration, database change management and data management through the various stages of the development life cycle.
• Develop complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Develop rich Interactive reports and dashboards integrating various reporting components from multiple sources and Tableau servers for maintaining DB schemas.
• Well versed with Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Transform in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Good in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Work with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services project
• Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Strong in writing MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS).
• In-depth knowledge of working and implementation of SSRS Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports.
• Strong in strategic and complex reports development using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, t).
• Enhance the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services (SSAS).
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources. Experience with R Integration in Tableau to identify patterns, build practical models for a deep statistical analysis and accomplish forecasting of those statistical models.
• Work on Power BI service by publishing the Power BI reports onto Power BI server and collaborated team using Power BI service to create the dashboards.
• Configure security, organizational content packs, Data Gateways, refresh schedules for Power BI service.
• Good in creating aggregates, hierarchies, charts, filters, quick filters, table calculations with Power BI.
• Experience working in Agile and Waterfall model working methodologies.

TECHNICAL SKILLS

Databases: MS SQL Server 2016/2014/2012/2008 R2 MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 , Oracle Azure SQL DB, CosmosDB

Database Tools: Business Intelligence Development Studio, SQL Server Integration

SQL Server: Analysis Service, SQL Server Management Studio.

ETL Tools: SQL Server Integration Service (SSIS), DTS

Programming Languages: C, Java, HTML, MDX, T-SQL,PL/SQL,C#

Reporting Tools: SQL Server Reporting Service (SSRS), Power BI, Tableau

Application Tools: MS Office Suite(MS WORD, MS EXCEL, MS VISIO, MS Power Point), SharePoint

Operating Systems: Windows XP /Vista /7 /8 /10, Windows NT Server, Windows 2003 /2008R2 /2012 Servers.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

MSBI Developer

Responsibilities:

• Created SSIS packages for data integration from various data sources like Access, and SQL Server 2012 into the operational SQL Server and deployed them by using configuration tools.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Creating SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Developing reports and dashboards using Power BI stack, Power Pivot, Power View, Power Query.
• Using various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created/modified complex store procedures to fit to changing requirements and enhance performance and developed custom functions, indexes to ensure accuracy, quality and consistency of the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Written complex stored procedures to get data from different servers and generated reports on that data.
• Built the report models, created a wide variety of interactive reports for business users in SSRS and deployed the reports in various formats depending on the user requirements.
• Worked on Power BI on how to import, shape (info graphics) and transform data for business intelligence (BI), Visualize data, and author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.

Environment: MS SQL Server 2012, Git, MS SQL Server Reporting Services 2015, MS SQL Server Analysis Services 2015, T-SQL, MS SQL Server Integration Services, Visual Studio 2015,T-SQL, Agile Methodology.

Confidential

SSIS/SSRS Developer

Responsibilities:

• Automated SSIS Packages using SQL Server Agent Jobs. Created an ETL summary report which consists of the summary information for all the loading activities done each day and month. Rewriting and optimizing Queries, Preparing Documentation and specification.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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.
• 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 Database.
• Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI Functionality of SQL Server.
• Expertise in creating Perspectives, partitions and design aggregations in cubes using SSAS.
• Involved in design implementation and modifying the python code and MYSQL database schema on the back end.
• Wrote and executed various MYSQL database queries from Python-MYSQL connector and MYSQL db. Package.
• Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Worked on formatting SSRS reports using global variables and expressions.
• Experience in using SQL Profiler, SQL Server Agent and database Engine Tuning Advisor.
• Used SQL Server Profiler to monitor and record database activities of users and applications

Environment: MS SQL SERVER 2008, Python 2.7, T-SQL, Microsoft Visual Studio 2008, SQL Server integration services (SSIS), SQL Server Analysis services (SSAS), SQL Server Reporting services (SSRS), MS Excel, SQL Server Profiler.

Confidential

SQL Developer

Responsibilities:

• Installed and configured SQL Server 2008 for Development Purpose.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Created DTS packages to transfer the data from Oracle to SQL Server 2008.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Designed and developed MS SQL server stored procedures using T-SQL statements from scratch.
• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.
• Involved in performance tuning of the database and T-SQL queries using Explain plan.
• Developed triggers on views to populate these tables.
• Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.
• Handled database objects with Enterprise Manager.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote complex SQLqueries to perform Data Validation and Data Integrity testing. Used TOAD against Database.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.

Environment: MS SQL SERVER 2008, PL/SQL, TOAD, T-SQL, Dynamic SQL, SSMS, SQL Profiler, Query Analyzer, Enterprise Manager, Windows XP.