| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
BISHWO BHATTARAIPhone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEAddress: Round Rock, TX, Street Address
Professional SummaryAn IT Professional having more than 5 years of practical experience in building new or enhancing existing reporting Data Warehouse in both On Premise and Cloud environments.Proficient in Software development Life Cycle phases, including application Analysis, Reverse Engineering, Design, Development, Testing, troubleshooting and Implementation of Data Warehouse projects and applications.In Depth knowledge of Data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages into the system.Well versed with Microsoft SQL Server- On Premise RDBMS, initiated with On Premise Data Warehouse, Integration, Analytics and reporting Services along with database developmentStudied Cloud Concepts and Services offered by Microsoft Azure, involved in the process of efficiently reducing capital expenditure and promoting minimum operational expenditure of overall IT assets and infrastructure.Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Data Cleansing, Data Scrubbing and Data MigrationStrongly experienced in Data Modeling, Data Normalization up to 3rd NF and Dimension Modeling using Star and Snowflake Schemes.Expertise in database programming and performance tuning of Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, Sub-queries, Joins, CTEs and Batch Scripts using T-SQL.Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all etc.Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2 and Oracle.Implemented Full, Incremental and Remigration ETL workflow and data pipelines for Staging, Data mart and Data Warehouse databases.Experienced in handling late arriving dimension and late arriving facts scenarios in a Data Warehouse.Hands on experienced in creating cubes and dimensions, handling multi-dimensional reports.Experience in report development using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.Experienced in developing Azure Data Factory Pipelines, Integration runtimes, Linked Services and Data Sets using Data Factory Studio, JSON templates and C# APIs.Implemented reusable data flows (mapping and wrangling data flow activities) after identifying commonalities between tables and datasets.Copying files and tables from On Premise to Azure BLOB storage and Azure SQL Databases with Hot and Cold access tiers depending on the timely Partitions.Collaborated with DevOps Engineers to prepare automated CI / CD pipelines using Azure ARM templates as per deployment strategies.Education: BachelorsTechnical skills:LanguagesSQL, T-SQL, C#, JavaScript and Bash scriptingETL ToolsSSIS (SQL Server Integration Services), Data Import Export WizardReporting ToolsSQL Server Reporting Service (SSRS)Analytical ToolsSQL Server Analysis Services, Power BIDatabase toolsSQL Server Management StudioCloud PlatformAzure Data Factory v2, Azure SQL Databases, AWS, GCPData FormatsStructured, JSON, YAML and XMLVersion ControlGIT and Azure ReposOperating SystemsDatabaseWindows Server 2022,2016 and 2022Microsoft SQL Server, Oracle DatabaseProjects SummarySQL Developer (SSRS/SSIS/SSAS)Client: The Lighthouse of the BlindLocation: San Antonio, TXDuration: October 2023 to presentResponsibilities:Generated detailed studies on potential third party data handling solutions, verifying compliance with internal needs and stakeholder requirements.Collaborated on ETL design and development maintaining Data integrity across On premise and Azure Data Lake storage.Developed Azure Data Factory pipelines to orchestrate the entire On Premise to Cloud Data movement along with Power BI Workspace refresh at specified time of interval.Handling real time data censoring through event messaging system, batched into group of data and sent into the Azure SQL Databases as a staging layer.Worked on building SQL queries for Data manipulation and for also creating DQL objects like tables, triggers, stored procedures, views and more.Worked on creating Common Table Expressions to identify the duplicates and dynamically clear them as part data validation.Worked on adding more data integrity check to the existing database and for the newly added SQL objects.Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.Optimized the long running Stored Procedures by rewriting the script, created temp table and indexes, recompiled stored procedure, updated statistics and make the process simpler and faster.Created and managed Clustered Indexes, Non-Clustered Indexes, and Index fragmentation.Worked closely with DBA, Solution Architect and gave significant input on Normalization/De-Normalization of database tables and built Referential Integrity for RDBMS.Developed SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).Involved in designing and developing Data Warehouses, Data Marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using SSRS.Implementing various SSIS packages having different tasks and transformations, developed Incremental Load using Lookup and scheduled SSIS packages.Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting ServerDesigned and developed dashboards and reports using Microsoft Excel and SSRS on a daily, week-to-date, month-to-date, quarter-to-date, and year-to-date basis to track loans given out.Managed new report generation and report enhancement based on the change requests.Worked with DBAs, QA and systems support personnel in elevating and automating successful code to production.Migrated data from MySQL Database to SQL Server database using different kind of tools like SSMA (SQL Server Migration Assistance)Environment: SQL Server 2019 Azure Data Factory, Azure SQL Database, BI (SSAS, SSIS, SSRS), JSON, Power BISQL Developer (SSRS/SSIS/SSAS)Client: Wells FargoLocation: Phoenix, AZDuration: April 2022 to September 2023Responsibilities:Participated in Planning, Defining and Designing database based on business requirements and provided documentation.Translated requirements, designs and functional specs into use case document, test plans and test cases documents.Developed complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.Optimized stored procedures and long running scripts using execution plan, temp tables, and code rewriting and indexing strategies to increase speed and reduce run time. Programmed SQL statements which includes joins and functions.Worked extensively on SQL System Defined Functions and User Defined Functions.Worked closely with Senior DBA on Normalization of database tables, developed (DDL) and (DML) and built Referential Integrity for RDBMSDesigned and implemented stored procedures and triggers for automating tasks.Implemented complicated transactions for the existing tables.Utilized Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reportsResponsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution.Involved in the troubleshooting of Database performance issues and implementing necessary DB changes.Designed and developed Packages on SSIS by using Different Transformations like Derived Column, Lookup, Sort and OLEDB command to Load Data into Destination.Developed SSIS packages, to retrieve data from various sources like OLEDB, Excel, Flat files and used data transformation.Loaded data from various sources to SQL Server database using SSIS packages.Worked on various work flows like Data flow Task, Script Task, Execute SQL Task, Containers and File System Task.Implemented the logging, Breakpoints, handled errors especially foreach loop and continued execution logging previous iteration error(s).Developed data import from Excel, Flat file to MS SQL Server by using BCP utility.Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development. Extracted data from star schema DSS data warehouse by creating and maintaining complex SSIS.Involved in building an extensive OLAP data warehouse on SSAS (Cubes, star schema)Developed cubes and dimensions and measures and calculated measures according to the business requirements.Developed customized reports and ad hoc reports as per the business requirements.Developed different data validation scripts for the Data analysts for verification of reports.Utilized Pivot tables to provide structure to Reports in proper format like months etc.Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.Involved in developing and modifying XML reports for exporting the reports to web application.Responsible for creating Test Cases, Test Plans and Release Notes.Developed, tested, and implemented robust Disaster Recovery Plan.Environment: SQL Server 2016, Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BISQL Developer (SSRS/SSIS/SSAS)Client: Chavez Insurance GroupLocation: Round Rock, TXDuration: Aug 2020 to March 2022Responsibilities:Involved in Planning, Defining and Designing database based on business requirements and provided documentation.Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.Developed logical and physical data models for schemas using MS Visio.Defined check constraints, rules, indexes, and views based on business requirement.Developed the Stored Procedures, Views, User Define Functions and Complex Queries.Created Temporary Table and Common Table Expression (CTE) for query Optimization.Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to Staging database in SQL Server using Business Intelligence Development Studio.Designed ETL packages for extracting the data and load into the appropriate Dimension and Fact tables in the Data Warehouse and Data Mart databases using SQL Server Integration Services (SSIS).Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data into the Data Warehouse.Involved in development of Incremental Load Process using SSIS Packages and various Transformation and data cleansing activities using various Control Flow and Data Flow tasks in SSIS packages during data migration.Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.Involved in Unit testing in SSIS Packages, Query verification in SSRS and Stored Procedures.Scheduled jobs to run the SSIS packages on daily basis using SQL Server Agent.Setting up alerting system by using performance counters for monitoring system performance.Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.Managing of users including creation/alteration, grant of system/db. Roles and permission on various Database objects.Extensively used Joins and sub queries to simplify complex queries involving multiple tables.Extensively Developed SQL scripts for maintaining administration tasks.Responsible for automation of maintenance jobs, locks and indexes configurations.Administering SQL Server security, SQL Server automatic email notification.Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handle lock scenarios.Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports Developed OLAP Cubes by using SQL ServerEnvironment: MS SQL Server 2016, SSIS, SSRS, Visual Studio 2013.Jr. SQL DeveloperClient: Texas bank and TrustLocation: Longview, TexasDuration: March 2019 to July 2020Responsibilities:Worked on modifying the SQL stored procedures, SQL scripts based on the defects & issue raised by client in existing system.Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).Involved in error handling of SSIS packages by evaluating error logs.Successfully extracted transformed and load data into data warehouse. Created reports using SSRS from OLTP and OLAP data sources and deployed on report serverPerformed Database Search and Query Strategy design, implementation, testing, and optimization.Extensively used SSIS 2008 transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.Documentation of test reports and defect reports.Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.Created queries for generating drill down reports in SSRS.Lead the offshore Team and involved in Team tracking activities.Expertise in prepares Integration Test Plan that was used by functional team as well as development team.Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.Create nested, conditional subgroups and formatting features in reports.Visualized transformed data by using Tableau Desktop dashboards containing histogram, trend lines, pie charts and statisticsEnvironment: MS SQL 2016, Windows Server 2016, C#, SQL Server Integration Services (SSIS), SQL Reports using SQL Server Reporting Services (SSRS) |
