Bimal

KC SQL/ETL Developer

PROFILE SUMMARY

More than 5 years of experience in SDLC methodologies, in Analysis, Design, Development, Testing, and Implementation of client - server based applications. Proficient in Database Administration, Design and Development using MSSQL 2022/2019/2017 for both OLTP

(Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS). Expertise in database programming in writing and tuning Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, Sub-queries, Joins, CTEs and Batch Scripts using T-SQL.

Experienced in creating complex T-SQL queries for data analysis and data manipulation. Organize analytical data, ensure data quality though data profiling, and aggregate data for strategic reporting, performance optimization on database solutions. Build data visualizations and reports from DW and OLAP cubes using SSRS and Power BI. Agile Program management, change management, User Management JIRA Agile, Scrum, Bug Cycle management, SDLC Design advice using JIRA. Experienced working in the Agile methodology using Scrum which has its primary focus on the management part of software development, dividing the whole development period into small iterations (of seven days) called "sprints". Implemented Full, Incremental and Remigration ETL workflow and data pipelines for Staging, Data mart and Data Warehouse databases.

Good knowledge of parallel processing used it for faster query processing and loading data Experience working with Visual Studio 2022, 2019 and 2017. Involved in the design of logical and physical design models of relational database using Erwin Data Modeling tool.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Experience in Data Extraction, Transforming and loading ETL using various tools such as SQL Server Integration Services SSIS.

Good knowledge on multiple clouds which includes AWS, and Azure. Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.

Experienced in performance tuning of SSIS packages, Query optimization and database consistency checks. Very good skills of documenting different kinds of metadata. Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures. 510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 Bimal

KC SQL/ETL Developer

Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2 and Oracle.

Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.

Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join. Experienced in handling late arriving dimension and late arriving facts scenarios in a Data Warehouse.

Developed SSAS Cubes (Dimensions, Hierarchies, Dimension Usage Relationships and Measure Groups), Also developed Cube deployment strategy through XMLA file, Processing through SSIS package and SQL Agent Job. Experienced in implementing Key Performance Indicators (KPIs) Objects in SSAS. Expertise working with SQL Server tools such as Management Studio, Query Analyzer, SQL Profiler, SQL Server Agent.

Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services.

Experienced in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services. Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub- Reports, Drilldown, Drill-Through, Multi-valued parameters. Developed rich visualized reports and dashboards using Microsoft Power BI Having experience in implementing the security by using RLS, Power BI reports scheduling, subscriptions, PBI Report Builder and Optimizations. Experienced in creating test data and unit test cases. Writing test cases and system plans to ensure successful data loading process.

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 Bimal

KC SQL/ETL Developer

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 TECHNICAL SKILLS

SQL Server and Database Tools: Enterprise Manager, Profiler, Query Analyzer, Storage, Data Mining Models, Bulk Insert and BCP, Data Import Export Wizard, SSIS, SSRS, SSAS. RDBMS: MS SQL Server 2022/2019/2017, MS Access

ETL Tools: SSIS (SQL Server Integration Services), DTS Languages: Transact - SQL, PL-SQL

Reporting Packages: SSRS (SQL Server Reporting Services), Import Export Data, MS Excel, Power BI.

Analytical Tools: SSAS – multidimensional and tabular model Programming Languages: C#, ASP.NET, T-SQL, PL/SQL, MDX, and DAX. Cloud Technologies: Azure SQL Database

Methodologies: Agile, Scrum, Waterfall

Other Tools: TFS (Team Foundation Server), Visual Studio 2022/2019/2017, GitHub, and JIRA

(JQL queries)

Bachelor's degree

EDUCATION

TECHNICAL SKILLS

Aug 2022- Present

SQL/ETL Developer

Summit Bank Emeryville, CA

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. Involved in the analysis, design, development, testing, deployment, and user training of analytical and transactional reporting system

Involved in Change/Release Management process for deployment of change on Prod Environment and server maintenance and patching regularly. Responsibilities:

Bimal

KC SQL/ETL Developer

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency. Performed the logical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements. Ensured Jira Capture add-on and configure Jira capture tool for exploratory testing, easy creation of issue with browser extension by pre-filling templates.

·Research with team members and came up with a high-level design, and impact analysis document with several solutions to the problem during the implementation proposed new system.

Designed and normalized the database and created different objects like Tables, Views Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server. Developed T-SQL programs to create databases, programmed queries, sub-queries, ranking functions, derived tables, common table expressions, stored procedures, views, user-defined functions, constraints and database triggers using T-SQL. Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them. Generating SWL and PL/SQL scripts to install create and drop Database Objects including: Tables, Views, Indexes, Constraints, Packages, Sequences and Grants. 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. Used Erwin tool for dimensional modelling (Star schema) of the staging database as well as the relational data warehouse.

Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler. Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.

Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables. Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.

Utilized SSIS containers/transformations such as Sequence container, Foreach loop container, Look up transformations, merge joins, derived column with multiple Data flow task. To pull data sources like SQL server, Oracle, Excel, and Flat files Bimal

KC SQL/ETL Developer

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 Made use of batch update using SQL joins, sub queries in order to avoid asynchronous transformation and row by row operations to boost performance of SSIS packages’ data flow engine.

Designed, developed, and deployed OLAP cubes and SSIS packages to process OLAP cubes through source views having dimension and fact tables listed. Utilized XMLA file for deployment of cube.

Extensively worked with OLAP cubes to generate drill through reports in SSRS. Developed SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.

Responsible for the ad-hoc reporting, modification and regenerating on request. Exploring Azure SQL and CosmosDB for data storage and performance optimization requirements of next version of the project.

Technical Environment: SQL Server 2022/2019, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, TFS, Windows 10, Windows Server 2016, Visual studio 2017, TFS, Git Hub, Azure SQL. Dec 2021- July 2022

SQL/SSIS/SSRS Developer

Highland Hospital Oakland, CA

Involved in the Requirement Analysis, Design phase and Development phase of agile model system.

Closely worked with Business analyst for gathering requirements and Architects. Involved in providing presentation to clients and conducting group meeting with team members. Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models. Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other database objects as per the business requirements Provided technical expertise for JIRA Agile and have created and configured Scrum and Kanban boards.

Assisted on the Ad hoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.

Developed stored procedures, triggers and functions to account for some automated insertion of records in tables for wholesale lending to different merchant banks Developing Power BI report using Power Apps Entity data and other Databases. Developed SSIS packages to Push and Pull data using Rest APIs and other different sources and vendors.

Responsibilities:

Bimal

KC SQL/ETL Developer

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues. Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages. Involved in analysis, design and coding of Oracle Processes in PL/SQL to build packages. Built SSIS package to load data from different files and databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot, Slowly Changing Dimension, and other transformations from different sources.

Used different type of Transformations for Data Conversion, Sorting, and cleaning the data from different sources into Company format.

Estimated AWS costs and identified cost control mechanisms. Created Package Configurations, Event Handlers for On Error/Warning/Task Events. Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.

Troubleshot and monitored daily execution and implementing enhancement on existing SSIS packages.

Maintained the physical reports by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler. Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS Worked as Data Miner for Various Project using DB2, Oracle, SPUFI, Mainframe. Provide support to junior co-workers and work with offshore resources for knowledge share.

Doing peer/ code review of co-worker and junior developer and make necessary revision to make sure code best practice has been followed and to eliminate errors into PROD environment.

Migrates ad upgraded jira from Oracle to PostgreSQL environments. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS. Utilized Power BI (Power View) to create various analytical dashboards. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Worked on Upgrading and automating manual jobs and scripts into SSIS and scheduled in sql agent.

Technical Environment: MS SQL Server 2019 MS SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, MS SQL Server Reporting Services SSRS, T-SQL, Windows 2016, MS Office 365, Auto sys, Erwin, Microsoft Visual Studio, SQL Server Management Studio Bimal

KC SQL/ETL Developer

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 July 2020- Nov 2021

SQL Developer

Mechanics Bank El Cerrito, CA

Developed, implemented, and maintained various database objects such as stored procedures, triggers, functions, indexes, and views. Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.

Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.

Built SSIS package to load data from different files and databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot, Slowly Changing Dimension, and other transformations.

Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task. Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages. Expert in connecting multiple data sources in Power BI to implement working reports. Expert in creating multiple kind of Power BI Reports and Dashboards. Responsible for creating reports based on the requirements using SSRS and Defined the report layout and identified datasets for the report generation. Created different types of reports including financial reports, cross-tab, conditional, drill- down, sub reports also parameterized reports, ad hoc reports for existing databases. Design and created financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically. Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes. Involved in database administration principles and practices including security, permissions, and alerts.

Responsibilities:

Bimal

KC SQL/ETL Developer

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 Analyzed, identified, and implemented user roles and assigned relative database access privileges

Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.

Developing test strategies, test plans based on functional specifications, use cases, and business requirements.

Used TFS as code storage tool for multiple applications, leveraging branching, preparing folder structure and versioning of code.

Technical Environment: MS SQL Server 2019 MS SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, MS SQL Server Reporting Services SSRS, T-SQL, Windows 2016, MS Office, Erwin, Microsoft Visual Studio, SQL Server Management Studio Sep 2018- June 2020

Jr. SQL Developer

Siddhartha Bank Limited Kathmandu, Nepal

Co-ordinate with team members on resolving data migration issues using job execution history and logs.

Diligently worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.

Assisted on the Ad-hoc Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.

Programmed and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.

Developed T-SQL for maintaining, developing, and creating database and fine tune Stored Procedures and Queries to improve performance of system. Created schemas, keys and indexes considering the granularity and entities of the data. Migrating databases from legacy system to SQL server and involving in rewrite codes and validate after migration.

Worked extensively in Query analyser and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues. Worked on system objects and DMVs to handle performance issues. Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages. Responsibilities:

Bimal

KC SQL/ETL Developer

510-***-**** ad0zgt@r.postjobfree.com El Cerrito, California, 94530 Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.

Worked in Active passive cluster environment. Used log shipping for synchronization of databases. Update statistics, database integrity check and Backup operations Implemented and maintained Database mirroring as a Disaster Recovery Solution. Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Developed, monitored, and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS SQL server reporting services and SSAS.

Technical Environment: MS SQL Server 2017 MS SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, MS SQL Server Reporting Services SSRS, T-SQL, Windows 2012, MS Office, Erwin, Microsoft Visual Studio, SQL Server Management Studio.

Contact this candidate