SUMMARY:

• Quality focused IT professional of 6+ years of database development and administration experience in SQL Server database system in OLTP environment and OLAP Data Warehousing systems.
• Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, and T - SQL Scripting.
• Experts in developed and deployedSSISpackages using proper control and data flow elements with error handling.
• Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager functionality using T-SQL Scripts and Batches.
• Analyze business and technical requirements data warehouse data models (SSIS, SSRS), to understand the detailed data management requirements.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2016/2012/2008 R2
• Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2016/2012/2008 R2.
• Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.
• Experienced in developing Custom Report and different types of Chat Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using 2016/2012/2008 R2 Reporting Services (SSRS), PowerBI.
• Proficient in Data Visualization development using Tableau to create complex and innovative dashboards
• Worked in an Agile environment.
• Excellent communication and interpersonal skills and have ability to handle multiple tasks as well as a proactive member of a team.

TECHNICAL SKILLS:

Operating Systems:: Windows Server 2014/2012/2008 R2

RDBMS:: SQL Server 2014/2012/2008 R2, MS Access

Database Tools:: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), Toad, Teradata SQL Assistance

Languages:: T-SQL, DB2, PL/SQL, VB.NET, C++, Python

Reporting Tools:: SQL Server Reporting Services (SSRS), PowerBI, Tableau

Networking:: TCP/IP, Named Pipes

ETL Tools:: SQL Server Integration Services (SSIS)

PROFESSIONAL EXPERIENCE:

Confidential, Denver,CO

SQL Developer II

Responsibilities:

• Support application of business intelligence and marketing automation solutions.
• Support the database services in the design, delivery and operation of database solutions.
• Interact with client representatives and business analyst to develop database solutions that meet business requirements
• Migrated Qulik report into PowerBI environment

Confidential

Data Engineer / Business Intelligence Developer

Responsibilities:

• Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Designed automation processes for different store procedures.
• Migrated SQLserver 2017 into Teradata environment (National Data Warehouse or NDW).
• Continuously interacted with users to gather the business requirements.
• Designed ETL process to populate the data warehouse using SSIS
• Maintain the existing data warehouses and Design subject area wise data marts / cubes to facilitate aggregation, slicing and dicing of data by reporting tools such as Micro Strategy/Power BI/Tableau
• Full understanding of business intelligence development lifecycle using a variety of technologies, including Microsoft (SQLServer, Integration Services, Reporting Services, Analysis Services) as well as other standard data warehouse and data modeling tools and techniques
• Developed logical and physical models for the functional data mart, staging area, and operational data store
• Created technical documentation (internal) using understanding of internal business areas and processes as well as working knowledge of database design, data manipulation, ETL, implementation, information storage & retrieval, and data flow & analysis.

Confidential

BI/Database Developer

Responsibilities:

• Develop reports that meet quality and performance requirements set by users
• Maintain and update reports in accordance with user’s feedback and business logic
• Implements business rules through stored procedures and other database objects.
• Writing T-SQL queries and stored procedures, creating various database objects as well as optimizing T-SQL code for faster performance.
• Query Optimization and Performance Tuning by analyzing execution plans, handling Index fragmentation and using SQL profiler and Database Tuning Advisor (DTA) tools.
• Loaded data to the interface tables from multiple data sources using OLEDB, ODBC, ADO.NET connections.
• Developed T-SQL stored procedures, user functions and views to implement the business logic for front end applications, reports as well as ETL processes.
• Wrote custom T-SQL stored procedures and scripts to provide application functionality and tuned them by creating indexes and ensuring optimized query design.
• Designed SSIS Packages to transfer data between servers, load data into database from various heterogeneous sources like SQL Server, Excel and CSV and archive data files.

SQL/BI developer

Responsibilities:

• Involved in business requirement gathering phase by working alongside the business analyst to create technical specifications.
• Extensive knowledge on data warehouse tools (Data extraction, data cleaning, data transformation, data loading, and refreshing)
• Developed T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.
• Configured SSIS packages when deploying and implemented transactions, checkpoints and event handlers in them to handler errors.
• Created report crucial stored procedures and functions to support reporting dataset manipulation
• Developed interactive and static reports, sub reports, drill through, drill-down reports using various features like Matrix, Table, Charts, Graphs and Dashboard.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps
• Prepared Ad-hoc reports through report builders and published through Report Manager
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.