SUMMARY

• 8 years of experience in Database Design, Development and Implementation of MSSQLSERVER … with Business Intelligence tools MSSQLServer Reporting Services (SSRS), MSSQLServer Integration Services (SSIS) and MSSQLServer Analysis Services (SSAS).
• Experience in Installing, Upgrading, Managing, Configuring, Migrating and Troubleshooting of MSSQLServer and Database.
• Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Strong technical knowledge in creatingSQL Scripts, Complex stored procedures, Triggers, Indexes, Cursors, various constraints, Views and functions.
• Expert in developing T - SQL(DDL, DML) statements, Data Integrity (constraints), Rules, Performing Tuning, Query Optimization and Data Validation issues.
• Tremendous experience in using tools like Database engine tuning advisor,SQLProfiler, Windows Performance Monitor for Monitoring and Tuning MSSQLServer Performance and also experience in reviewing and fixing issues with database backups and other common faults.
• Experience in Data Extraction, Transformation and Loading (ETL) processes using (SSIS), DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Good experience in designing and building the Dimensions, cubes with star and snow flake schema usingSQLServer Analysis Services (SSAS) for analyzing purpose.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Parameterized reports, Cascaded reports, Matrix reports, Pagination reports, Sub reports and Charts usingSQLServer Reporting Services (SSRS) based on Relational and OLAP databases.
• Good experience in creating dashboards and reports inTableauand created report schedules onTableauserver.
• Experience in developingBIdata mapping andBIobjects (dashboards, reports, analyses, visualizations, metrics, security) design documents usingPowerBI.
• Good knowledge on C, C++, C #, ASP.net, VB.net, IIS, HTML, VBScript, JavaScript, XML.
• Exceptional leader with excellent interpersonal skill, communication finesse and Team management skill with strong expertise in analyzing the requirements and preparing the specifications document based on the requirements.

TECHNICAL SKILLS

Operating Systems: Windows …, UNIX, LINUX.

Languages: T-SQL, PL/SQL, C#, .Net, VB.Net, ASP.Net, XML, HTML, Java Script.

Tools: /Utilities: SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio(BIDS), DTS, Analysis Manager, Enterprise Manager, SQL Profiler, Visual Studio, SQL * Plus, Toad, Erwin, Power BI.

Databases: MS SQL Server 2016/2014/2012/2008/2005 , Oracle11g/10g/9i, MS Access.

Data Modeling Tools: Microsoft Visio, UML, Erwin, Oracle Enterprise Management (OEM).

Software: MS Office, DTS X Change, Adobe Photoshop, MS Excel, MS-Project.

Reporting Services: SQL Server Reporting Services, Crystal Reports, Excel, Business Objects, Tableau.

PROFESSIONAL EXPERIENCE

SQL BI Developer

Confidential, MD

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/Data Models, Requirement documents and ETL Specifications.
• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQLin Development and Production environment.
• Identified, tested, resolved database performance issues (monitoring and tuning) to ensure database Optimization and Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning forSQL databases.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SQL Server Integration Services(SSIS).
• Used various Transformation such as Conditional Split, Derived Column, lookup, merge, pivot, SCD, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created and modified different types of ad-hoc reports including parameterized, linked, drilldown, drill-through, sub-report, matrix, tabular, and dashboard reports as well as reports with complex join Queries in SSRS.
• Designed rich dashboards withPowerBIand prepared user stories to create compelling dashboards to deliver actionable insights.

SQL DBA/ BI Developer

Confidential, Ohio

Responsibilities:

• Worked on T-SQLskills in creating stored procedures, functions, views, triggers and various database objects such as tables, indexes and views based on the requirement.
• Involved in Performance Tuning, maintenance, troubleshooting, Query optimization and monitoring backup jobs daily and run the jobs manually in case of failure.
• CreatedSQLalerts, Mail and linked servers for accessing data from remote servers using jobs.
• Worked on different transformations like Script task, Fuzzy Lookup, Derived column, Conditional split, Multicast transformation, pivot etc., usingSSIS.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs using SSRS, Reports such as Parameterized, Cascading, Drill through/Drill down, Charts and Sub Reports using Relational data warehouse and OLAP Cubes.
• Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX.
• Combined views and reports into interactive dashboards inTableauDesktop which were presented to Business Users and End Users.

SQL BI Developer

Confidential, NJ

Responsibilities:

• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQLin Development and Production environment forSQLserver 2012.
• Designed and developedSSISPackages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files intoSQLserver for further Data Analysis and reporting by using multiple transformations provided bySSISsuch as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Created the structure of model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Wrote MDX scripts for KPIs and Calculated members based on business requirements in SSAS.
• Designed, developed and deployed Tabular and Matrix Type List, linked and Sub-Reports with Charts and Document maps usingSSRS.
• Evaluated database performance and maintenance duties such as Backup, Restoration are performed by scheduling jobs usingSQLServer Job Agent.

SQL Developer

Confidential

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQLin Development and Production environment forSQLServer 2008.
• UsedSQLProfiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• DevelopedSQLQueries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Generated Sub-Reports, drill down reports, drill through reports and Parameterized reports with custom code in VB.Net as well as dashboards using SSRS.
• Extracted the data from files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Involved in performance tuning and monitoring of both T-SQLand PL/SQLblocks.

SQL Developer

Confidential

Responsibilities:

• Written Stored Procedures andSQLscripts both inSQLServer and Oracle to implement business Rules for various clients.
• Designed dynamicSSISPackages to transfer data crossing different platforms, validated data during transferring and archived data files for different DBMS.
• Generated database monitoring and data validation reports in ProClarity andSQLServer Reporting Service (SSRS).
• Created Complex SSAS Cubes with multiple fact measure groups, and multiple hierarchies based on the OLAP reporting needs.
• Worked on Migration of packages from DTS usingSQLServer Reporting Service (SSIS).
• Performed DBA functions, installing, configuring and supporting database systems.