SUMMARY

• Over 16 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2016, 2012, 2008R2, 2005 and 2000 in Production, QA and Development Environments.
• Designed and developed Cubes in SQL server analysis services.
• Strong experience in developing Sub Reports, Matrix Reports, Charts, Drill down reports, using SQL Server Reporting Services
• Experience is creating Power BI Dashboards, Power Query, Power View and Power Pivot.
• Extensive experience in Financial, Manufacturing and Health care industry.
• Strong Experience in Data migration using SSIS services across different databases like Oracle, MS access, AS400, SAP and flat files.
• Experience in working with Oracle, SQL Server, SAP and AS400.
• Extensive experience in writing Complex Stored procedures, analyzing and debugging existing complex stored procedures.
• Experience with Database Backup and Recovery procedures
• Expertise in report analysis and automated report generation.
• Good understanding knowledge in designing and implementing data warehouses and MS SQL OLAP services.
• Well versed with Agile with Scrum, Waterfall Model and Test - driven Development (TOD) methodologies.
• Design and document Logical and Physical data models
• Automating the Database Maintenance tasks by creating Jobs and Alerts.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2016, 2012, 2008 & 2005
• Excellent problem solving & decision making skills and proven record of accomplishment in analyzing situations and offering innovative cost effective solutions.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2000, 2005,2008,2012,2016 & Oracle 10g and 19c

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

Database Utilities: MSEnterpriseManager,SQLProfiler,SQLQueryAnalyzer, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SSRS (SQL Server Reporting Services).

Data Modeling: Visio 5.0

Reporting Tools: SQL Server Reporting Services, IdashBoards, Power BI

Cloud Technologies: Azure Data Bricks, Azure Data Factory, Azure Datalake Analytics, Azure SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Lead Analyst

Responsibilities:

• Responsible for requirements analysis, design, development, testing, and implementation of data warehouse solutions using the Microsoft SQL Server suite of products including Reporting Services (SSRS), Analysis Services (SSAS) and Integration Services (SSIS) and Power BI.
• Worked with business/functional analysts to determine reports and analytical requirements.
• Designed, Developed and Deployed SQL Server Reports
• Developed Sub Reports, Matrix Reports, Charts, Drill down reports, using SQL Server Reporting Services
• Created Subscriptions and data driven subscriptions to generate automated reports to the users.
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and Azure Data Lake Analytics
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse
• Generated Customers reports, business reports, client reports using SSRS
• Developed KPI’s and Dashboards in Power BI
• Experience is managing On premise and Cloud Power BI solution
• Established Gateway to Power BI Service
• Designed and developed Cubes using SSAS
• Developed ad-hoc SQL,MDX and XMLA queries to support requests
• Created SSIS packages to load data from different data sources to Oracle and SQL server databases.
• Created Fact and Dimension tables and loaded data to stage tables and loaded data to fact and dimension tables using SSIS and SQL.
• Developed procedures and functions for business & data transactions with error handling.
• Implemented and managed database backup and recovery strategies
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Generated database SQL scripts and deployed databases including installation and configuration
• Created SSIS packages to load data from SAP, JDE, SQL Server and Oracle to create a single source of reporting.
• Written VBA code to support requirements in excel.
• Worked in Agile scrum methodology
• Managed the complete cycle of software development from specification writing through Software development, unit, and integration testing
• Documenting technical and functional processes, including issue documents

Environment: SQL Server 2016, SQL server 2012, SAP, JDE, Oracle, SSRS, SSIS, Transact- SQL, Power BI, Excel, Office 2013, Azure DW, Azure Data Lake, Azure Data factory, TFS, Active X, VBScript, SQL Enterprise Manager

Confidential, Richmond, VA

BI Developer

Responsibilities:

• Responsible for requirements analysis, design, development, testing, and implementation of data warehouse solutions using the Microsoft SQL Server suite of products including Reporting Services (SSRS), Analysis Services (SSAS) and Integration Services (SSIS).
• Creating tables, relationships, triggers and indexes for enforcing business rules
• Created SSIS packages to load data from different data sources to Oracle GDW
• Worked with business/functional analysts to determine reports and analytical requirements.
• Designed, Developed and Deployed SQL Server Reports using SSRS
• Maintained versions Using Visual Source Safe, TFS.
• Development of ad-hoc reports using stored procedures, functions
• Developed Sub Reports, Matrix Reports, Charts, Drill down reports, using SQL Server Reporting Services
• Developed user documentation for all reports, managed and supported the reports.
• Involved in Report query optimization, Index design and Planning, Index analysis and tuning.
• Developed SSIS packages to load data from different sources to SQL server and Oracle databases.
• Designed Cubes using SSAS
• Developed ad-hoc SQL and MDX queries to support requests
• Developed procedures and functions for business & data transactions with error handling.
• Implemented and managed database backup and recovery strategies
• Generated database SQL scripts and deployed databases including installation and configuration
• Designing and building data load procedures, using MS SQL Server
• Upgraded SQL server bit to 64 bit in the year 2009.
• Upgraded SQL server R2 in the year 2012.
• Documenting technical and functional processes, including issue documents and MD60 and RD60 templates.

Environment: SQL Server 2005,SQL server 2008R2, Oracle, SSRS, SSIS, Transact-SQL, Excel,, VBScript, SQL Enterprise Manager, Windows 2000/NT/XP, Windows Server 2003,2008.

Confidential, Piscataway, NJ

SQL Server Developer

Responsibilities:

• Responsible for requirements analysis, design, development, testing, and implementation of data warehouse solutions using the Microsoft SQL Server suite of products including Reporting Services (SSRS), Analysis Services (SSAS) and Integration Services (SSIS).
• Creating tables, relationships, triggers and indexes for enforcing business rules
• Created SSIS packages to load data from different data sources to Oracle GDW
• Designed Cubes using SSAS
• Worked with business/functional analysts to determine reports and analytical requirements.
• Designed, Developed and Deployed SQL Server Reports using SSRS.
• Involved in Report query optimization, Index design and Planning, Index analysis and tuning.

Environment: SQL Server 2005, Oracle, SSRS, SSIS, Transact-SQL, Excel, VBScript, SQL Enterprise Manager, Windows Server 2003.

Confidential

SQL Server Database Developer/DBA

Responsibilities:

• Worked with business/functional analysts to determine reports and analytical requirements.
• Designed, Developed and Deployed SQL Server Reports using SSRS
• Maintained versions Using Visual Source Safe.
• Developed Sub Reports, Matrix Reports, Charts, Drill down reports, using SSRS
• Involved in creating Technical Specification Document (TSD) for the project.

Environment: SQL Server 2005, SSRS, SSIS, SSAS, Transact-SQL, Excel, SQL Enterprise Manager, Oracle, Windows 2000/NT/XP, Windows Server 2003.