SUMMARY

• Microsoft certified Technology Specialist with over 17 years of IT experience with more than 16+ years in SQL Server Database Developer that includes System Analysis and Design, Development & Support of MS - SQL 2005/2008R2/2012/2017and Business Intelligence including SSIS/SSRS.
• Extensive experience and detailed knowledge of in Healthcare, Insurance, Telecom, Immigration and Shipping industries.
• Extensive experience in Database design and development of applications using SQL Server 2005/2008R2/2012/2017, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Fact and Dimension Tables.
• Experience in Power BI Analytical tool
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Published reports and dashboards using Power BI.
• Experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Proficient in Job Scheduling, Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Worked on administration tasks such as Creating Databases, upgrades, Data loading/unloading, Batch Jobs, Backup & Recovery, User and Application Table Management.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).

TECHNICAL SKILLS

Databases: MS SQL server 2000/2005/2008 R2/2012/2017 and T-SQL

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data Tools, SQL Server Business Intelligence Development Studio (BIDS), SQL Server DTS, Visual Studio, Crystal Reports and Knowledge in SQL Server Analysis Services (SSAS)

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console

Reporting tools: Analytical Tool

SQL Server reports 2008/2012/2017. : Power BI.

Version control tools: Microsoft VSS, Share point, TFS

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Team Lead, Sr. SQL Server/ Power BI Developer

Responsibilities:

• Create Stored Procedures and Triggers involving complicated Queries, T-SQL Scripts and Functions, Jobs.
• Designing Logical and Physical databases and schemas.
• Trouble shooting database problems.
• Designed high level ETL architecture for overall data transfer from the various source to MS SQL Server with the help of MS SSIS.
• Successfully handled all ETL related issues raised in the production environment.
• Create SQL Server Integration Services (SSIS) Packages.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Analysing reports from different technologies and preparing document to track information about implementation feasibility of reports.
• Developing SSRS Reports and deploy Shared Data Sources, Shared Datasets and Reports in Share Point environment.
• Experience in Data Migration/ ETL
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

Environment: SQL Server 2017, SQL Server Integration Services and Power BI.

Confidential, Alpharetta, GA

Sr. SQL Developer/BI Developer

Responsibilities:

• Involved in developing the design, development and implementation strategy by working on deliverables such as Database Aggregation Design, Database Logical and Physical Architecture and Process Architecture.
• Create Stored Procedures and Triggers involving complicated Queries with Joins, T-SQL Scripts and Functions, Jobs.
• Designing Logical and Physical databases and schemas.
• Trouble shooting database problems.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the various source to MS SQL Server with the help of MS SSIS.
• Successfully handled all ETL related issues raised in the production environment.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Experience in Data Migration/ ETL
• Analysing reports from different technologies and preparing document to track information about implementation feasibility of reports.
• Developing SSRS Reports and deploy Shared Data Sources, Shared Datasets and Reports in Share Point environment.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Reports review and data validation against existing environments and make necessary changes.
• Designed and developed various reports which include Tabular, Summary, Matrix, Graph, Drill down reports, Drill through repots and Cascaded Parameterized reports.
• Subscribed reports through scheduled Email subscriptions.

Environment: SQL Server 2017/2014/2012/2008 R2, SQL Server Integration Services, SQL Server Reporting Services, TFS and Power BI.

Confidential

Sr. SQL Developer

Responsibilities:

• Participated in data warehouse design and architecture sessions with the program management team.
• Worked with the Program Architect and Technical Architect in design sessions to develop high level solutions architecture for SQL Server Reporting Services.
• Create Tables, Views and Triggers.
• Designing Logical and Physical databases and schemas.
• Trouble shooting database problems.
• Create SQL Server Integration Services (SSIS) Packages.
• Extract data from various data sources, Transform and Load data to Destination data base (ETL).
• Design OLAP Cube using SQL Server Analysis Services (SSAS).
• Design Reports Using SQL Server Reporting Services (SSRS).
• Participated in developing the design, development and implementation strategy by working on deliverables such as Database Aggregation Design, Database Logical and Physical Architecture and Process Architecture.
• Responsible for delivery of design deliverables including the solutions conceptual design and business process presentations.
• Data Base Tuning and Normalization.
• Query Optimization and Indexes.

Environment: MySQL, SQL Server 2005, T-SQL, Erwin 4.1.4, ETL, SSIS and SSRS

Confidential, Omaha, NE

SQL Server/ BI Developer

Responsibilities:

• Create database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.
• Configuring Cluster Server Environments.
• Configuring Snapshot Replication, Transactional Replication and merge Replication.
• Designing Logical and Physical databases and schemas.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Migrate Data from Oracle 10g Data Base to SQL Server 2005 Data Base
• Create and Maintenance of Clustered and Non-clustered indexes in 2005.
• Create SQL Server Integration Services (SSIS) Packages.
• Design Reports using SQL Server Reporting Services (SSRS).
• Perform Database consistency checks Confidential regular intervals.
• Develop Backup & Restore scripts.

Environment: SQL Server 2005, T-SQL, Oracle 10g, Toad, Crystal Reports, SSIS and SSRS