add photo
Biju
bdangol725@gmail.com
855-310-3335
Brownsville, TX 78526
9 years experience W2
0
Recommendations
Average rating
154
Profile views
Summary

  • More than 5 years of strong experience in the IT industry as a Microsoft SQL Server Developer including experience in design, development, deployment, and administration of database systems using MS
  • SQL Server 2016/ 2014/2012 versions along with OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical, and manufacturing. Have impeccable communication and interpersonal skills and an exceptional team player.
  • Complete understanding of Software Development Lifecycle and core area of experience in validating end-to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS/SSAS.
  • Good exposure to entire Software Life Cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
  • Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
  • Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
  • Proficient in creating and using joins, Stored Procedure, Views, Triggers, schemas and Complex queries on SQL Server Management Studio (SSMS).
  • Expert on installing and configuring MS SQL Server 2012\2014\2016\2019
  • Extensive knowledge in ER Diagram & logical & physical data modeling using Oracle Data modeler.
  • Hands on experience in designing de-normalized data warehouse using Star & Snowflake Schema.
  • Experience in creating Index, Views, complex Stored Procedures, appropriate user-defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.
  • Extensive experience with writing T-SQL scripts, stored procedures, triggers, and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
  • Strong experience with server/database/scripts Performance tuning and optimization.
  • Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
  • Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, creating databases / file groups/files/transaction logs.
  • Responsible for rebuilding the indexes and tables as part of performance tuning
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
  • Expert on Configuring MS SQL Integration Service (SSIS) Catalogs
  • Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.
  • Extensive experience in implementing event driven Error handlings, package logs.
  • Hands on Experience on SSIS package development, deployment and scheduling.
  • Having strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS. the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services, Bulk Insert, and Bulk Copy Program (BCP).
  • Implemented Slowly changing dimensions (Type1 and Type 2) Factless facts and other fact types with defined granularity, defined relationship between dimension and facts based on Surrogate keys.
  • Worked on Dimension hierarchies, cardinality, usage and member types during development of SSAS multi-dimensional cube.
  • Deployed cube database using xaml and developed SSIS job to process cube at specific interval of time after business hours.
  • Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
  • Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2016/2014//2012.
  • Hands-on in development of Drill down Reports in SSRS and Generated daily, weekly and monthly reports for the manager.
  • Developed Sub Reports, Matrix Reports, and Charts using SQL Server Reporting Services (SSRS).
  • Extensive experience and solid hands-on experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server in Development, Testing and Production environments.
  • Responsible for 24X7 production support on a callout rotation basis for all SQL databases.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills
  • Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
  • Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance and can work in demanding project schedules.
  • Strong Subject

Experience
Education
not provided
not provided
Skills
Data Warehousing
2021
4
Erwin Data Modler
2021
4
Microsoft Excel
2021
4
OLTP
2021
4
SQL
2021
4
SQL Server
2021
4
SSIS
2021
4
SSRS
2021
4
Stored Procedure
2021
4
Triggers
2021
4
Windows
2021
4
BTEQ
2019
2
Business Analysis
2021
2
Business Intelligence
2021
2
C#
2019
2
Data Migration
2021
2
Data Mining
2021
2
ETL
2021
2
ETL Developer
2021
2
MS SharePoint
2021
2
Oracle
2021
2
Production Support
2021
2
SQL Developer
2019
2
SSAS
2021
2
SSAS CUbe
2021
2
Teradata
2019
2