| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SANJAYA POKHRELphone: PHONE NUMBER AVAILABLEemail: EMAIL AVAILABLEaddress: Fort Worth, TX Street Address
SummaryA Data Enthusiast with 5+ years of experience in building data intensive applications, tackling challenging architectural and scalability problems, managing data report for efficient visualization for wide range of requirements.End to end experience in diverse business and technical environments with main area of focus in design, development, implementation and support of relational databases, data analysis, business intelligence, ETL, and data visualization using RDBMS databases and various reporting and visualization tools.Strongly experienced on SQL Server as a Developer, experience includes Database Design and Development, Confidential BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SSAS, SSIS, SSRS and TSQL.Well versed with Azure cloud services API programming to perform synchronous (fire and wait) and asynchronous (fire and forget) post methods to achieve required conditional precedence in pipeline flow(s).Well experienced on Server less Azure Data Factory Author and Monitor features in order to build Cost efficient pipelines to port data from multiple sources.Proficient in Azure TCO calculator to define cost of ONPREM workloads, Pricing Calculator and defining parameters impact on utilization like DIU and DTU in case of Azure Data Factory and Azure SQL Database PaaS mode.Implemented Azure Data Factory Integration Runtime to execute SSIS packages, collecting On PREM data scenarios, Parametrized Linked Services and re used existing Data Sets across most of the activities in a Pipeline.Conversant with Data Distribution algorithms like Round Robin, ASCII and Replicator, implemented Data Partitioning using Round Robin in Data Warehouse built using Azure SQL PaaS service.Experienced in executing activities related to end - to-end project management, including project plans and estimates, scoping, and requirements through implementation, Requirement Gathering, Requirement analysis, Application environment Setup, Preparing Test Scripts, Project Status reporting, bug fixing and deployment.Experienced on PaaS Services for Data ingestion, transformation, and storage of data from ONPREM to Cloud and vice versa, worked on Cost Optimization by porting live reporting data to ONPREM from Cloud storage partitioned based on time series.Strong experience in T-SQL programming proven, scalable code using stored procedures, various types of joins, subqueries, user defined function, analytical functions, aggregate function, cross/outer apply, group by, over partition by, cursors, merge, try/catch, dynamically generated scripts, triggers, common table expressions, scalar/table valued functions, create/alter tables/columns, views, primary/foreign key constraints, and indexes.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.EducationTribhuwan University, Kathmandu Nepal 2008Bachelors of Computer EngineeringTechnical SkillsLanguagesSQL, T-SQL, C#, Python, 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 DatabasesData FormatsStructured, JSON, YAML and XMLVersion ControlGIT and Azure ReposOperating SystemsWindows Server 2016 and 2022Work ExperienceSQL / ETL Developer (Jun 2023 to Current)Becton Dickinson, Franklin Lakes, NJPrimary presence in interpreting business requirements and technical discussion with Business Analysts and Solution Architects in order to minimize technical debts and improve quality of deliverables.Prepared the documentation for high level design of defined solutions, low level design and documentation of each and every changing / new entities, engineering release memos, impact analysis and build acceptance.Designed and developed Azure Data Factory Pipelines to copy data files from network Shared Folders into Azure Storage Blobs, utilized Copy Activity, For Each Activity and Get Meta Data Activity.Developed Parent Child Pipelines to cater nested For Each Looping activity while loading data from Blob storage to Azure SQL databases, applied expressions for dynamic mappings using metadata obtained from Lookup activity.Handling batch data processing through Data Lake system, batched into chunk of data and sent into the Azure SQL Databases as a staging layer.Handled POWERBI dataset refresh through Azure Data Factory pipelines and Rest APIs.Developed Power BI Dashboards by implementing multi source data integration, Utilized DAX language to define Measures, Slicers and Filters etc.Developed Flyway DB scripts to deploy ARM templates and Azure SQL database schema.Developed Power BI Dashboards by implementing multi source data integration, Utilized DAX language to define Measures, Slicers and Filters etc.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.Administering SQL Server security, SQL Server automatic email notification.Environment: MS SQL Server 2022/2019, Azure Data Factory, Azure SQL Database, BI (SSAS, SSIS, SSRS), JSON, Power BI, Team Foundation Server(On PREM Code) and GIT Hub ( Cloud code)Candidate's Name (Sep 2022 to May 2023)TRUIST Bank, Richmond, VACollaborated with business users for gathering requirements and conducting a weekly meeting for BI team. Worked with Data modelers to create physical and logical models by using ERWIN.Responsible for developing high level and low-level technical specification documents, change request and defect report documents.Involved in gathering requirements for Database creation, scheduling status review meetings, documents, and code review.Involved in complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.Involved in programming and solving the issues in the complex SQL statements and performing the query optimization.Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources. Extensively used SSIS Import/Export Wizard, for performing the ETL operations.Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Extensively used Control Flow elements like For Each Loop, Sequence Container, Execute SQL Task, execute package Task, Script Task, File System Task, Send mail Task and process Task.Responsible for implementation of data viewers, Logging, error configurations for error handling the packages.Created and maintained data flow diagrams for existing and future ETL processes.Developed Parameterized Queries, generated Tabular reports, sub reports, Cross Tabs, drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports.Designed, deployed, and maintained complex canned reports using SQL Server Reporting Services (SSRS).Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.Environment: SQL Server 2019, Windows Server 2022, SSIS, SSRS, XML, T-SQL, MS Excel, MS Access, C#.SQL Database Developer (Jan 2022 to Aug 2022)Amdocs/AT&T, Plano TXGathered user requirements from the users to develop the business logic and analyzed and designed software and database solutions and involved in cresting TDD (Technical Design Documents), FSD (Functional Specification Document).Defined and Designed databases based on business requirement and provided documentation.Developed database objects i.e., stored procedures, functions, tables, views, triggers as per the business use cases.Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTEs), User Functions, Indexes, User Profiles, Relational Database Models, Data Dictionaries, triggers, cursors, tables, and views and other SQL joins and statements for applications.Designed and implemented stored procedures and Triggers (DDL & DML) for automating tasks.Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.Developed SSIS package to load data from XML Files, Flat files, Ftp server, Sybase, and SQL Server to SQL Server by using Lookup, Derived Columns, Condition Split, OLEDB Command, ODBC Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task, SQL Server Destination and Slowly Changing Dimension.Developed Validation Plans for SSIS packages for checking the functionality of each component and code.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.Implemented the Master Child Package Model in the EDW and Data-Mart for easier maintenance and better performance of SSIS Packages review.Worked in setting up auditing, logging environment to track the status of the events like error raise, task fail.Designed tool to automatically add derived column, parameter, and configuration value to the package.Worked on ETL SSIS Deployment created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis using SQL Server Agent.Worked on solving performance issue with loading data into the Data Warehouse.Involved in programming of MDX queries and performance optimization of the SSAS cubes.Developed reports to retrieve data using function, views, multidimensional cube, and stored procedures using parameters.Configured the report viewing security for various users at various levels using Report Manager.Environment: SQL Server 2017, SSIS, SSRS, T-SQL, Data Import and Export Wizard, MS-Office, MS-TFS., Windows Server 2016SQL/SSIS/SSRS Developer (Nov 2020 to Dec 2021)Claim Care, Irving, TXWorked closely with business analyst as a senior SQL developer to understand and translate business requirements into technical documentation such as high level and low-level design specification documents, database schema and mapping documents.Responsible for database design and development, which includes developing Stored Procedures, functions using SQLInvolved in complete SDLC life cycle during requirement collection, analysis, design, and development of BI solutions.Participated in all the agile planning, daily standup meetings and gave the updates.Worked in creating and managing conceptual, physical, and logical data models.Created data mapping and sourcing documents for various sources to Data Warehouse and Data Mart.Involved in designing and implementing relational database RDBMS model as per business needs.Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.Defined check constraints, rules, indexes, and views based on business requirement.Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.Involved in several ETL processes such data cleaning, data validation, data aggregation, data transformation and Data Loading.Used efficient optimization techniques to design ETL Scripts.Worked on ETL Design for developing optimized ETL scripts, used change data capture CDC to simplify ETL in data warehouse applications.Used various Data Flow Transformations, like Lookup, Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.configuration in XML .DTSCONFIG file and used them to deploy packages into SQL serverDeveloped very complex SSIS Packages with considering all the best practices like error handling, logging, configurations, deployments, maintenance.Deployed SSIS packages to various environments like Dev, QA, UAT, PT and production using indirect XML and SQL server configurations.Deployed the packages in the Production server and schedule the packages according to the requirements.Unit tested the developed ETL scripts, created test SQLs, and handled UAT issueScheduled and executed SSIS Packages using SQL Server AgentRolled out documentation for the ETL Process, Early Data Inventory, and Data ProfilingImplemented Copy activity, Custom Azure Data Factory Pipeline ActivitiesPrimarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS and PowerShell scripting.Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loadsAssisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)Extensively worked on OLAP cubes using SSAS.Created and Managed OLAP Cubes using SSASCreated various SSRS Reports involving variety of features like Graphs, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters using MS SQL Server) as a source systemPerforms System testing for all the modules and helps business in User Acceptance Testing.Developed on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.Coordinating with offshore team for on time delivery of products and query resolution activities.Environment: MS SQL Server 2016, Team Foundation Server, Microsoft SharePoint Server, (SSIS) SQL Server Integration Services, (SSAS) SQL Server Analysis Services, (SSRS)SQL Server Reporting Services, Visual Studio 2013, Windows XP, T-SQL, Windows Server 2016Database/BI Developer (Jan 2020 to Oct 2020)American Express Financial, Phoenix, AZInvolved in gathering user requirements from the users to develop the business logic and analyzed and designed software and database solutions and involved in creating TDD (Technical Design Documents), FSD (Functional Specification Document).Involved in enhancements of existing databases based on business requirement and provided documentation.Involved in Using SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joins.Involved in development of SSIS packages for transforming data from warehouse to mart, to import data from source systems, or transfer data from one server to another.Developed, monitored and deployed SSIS packages.Designed SSIS packages to efficiently handle data from various external sources by using various Data Flow and Control Flow transformations like Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, Bulk Insert, send email and FTP Task etc. and loading the data at the desired location and in the desired formCreated 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.Successfully migrated data between different heterogeneous sources such as flat file,Developed Regenerated, Junk, and Time Dimension and Role-Playing dimensions on OLAP Cubes using SSAS.Defined cardinality of dimension and granularity of facts / measure groupsDeveloped relationship between dimension and facts in Dimension Usage Tab of SSAS multidimensional Cube.Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.Created different Power BI reports utilizing the desktop and the online service and schedule refresh.Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.Used various sources to pull data into Power BI such as SQL Server, oracle.Involved in installation of Power BI Report Server.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, crosstab, conditional, drill-down, Sub reports also parameterized reports for existing databases.Responsible for scheduling the subscription reports with the subscription report wizard.Deployed the generated reports directly on the clients workstation.Environment: Microsoft SQL Server 2014, T-SQL, SSIS, SSRS, SSAS, Microsoft Visual studio 2013, Windows Server 2012 R2.Jr. SQL Developer (Feb 2019 to Dec 2019)Charter Communication, Charlotte, NCPrepared and updated documentations (Data Analysis Forms, Data Mapping File, Business RequirementDescription, Procedure Documentations File, Population Files, Data validation form, etc.), to ensure all procedures and knowledge are traceable in future cycles.Analyzing different user requirements and coming up with specifications for the various database applicationsHave successfully delivered 40 data sample reports on time in all 2-month delivery cycles.Developed Advanced SQL queries and stored procedures to generate data reports. Dug into database details to ensure appropriate data filters, randomizations, and stratifications are applied based on business requirements.Developed Database objects including Tables, Triggers, Views, Stored Procedures, Data Modeling, Indexes and Rule.Programmed T-SQL statements using DML and DDL for retrieval of the data from source system in full and incremental manner.Developed complex stored procedures, triggers, and cursors as per given business requirements in SQL Server.Extensively Involved in Designing (Logical and Physical) of Databases.Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.Created & managed the Database Users, Login Ids and Security.Design and implementation of database maintenance planPerform database consistency checks at regular intervals.Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS)Set Database access privileges for different Users and User Groups.Pulled data across multiple database servers (Oracle, DB2, SQL Server, Sybase, and Access etc.). Connected data sources by Business Intelligence tools (SSIS etc.), linked database objects (linked server, database link etc.), and inline queries (OPENDATASOURCE, OPENROWSET, OPENQUERY etc.).Built extract, transform, and load (ETL) process to migrate data from multiple types of data sources (SQL Server, DB2, Oracle, Sybase, Excel, Flat files, SharePoint, Email Boxes, etc.) to destination database server by using SSIS packages, VBA, and Export/ Import wizard.Generated Parameterized/Drilldown, Drill Through, Sub Reports, Linked reports using SSRS and deployed reports to Report Server and Report Manager.Monitor SQL Server activity through profiler.Presented excellent work attitude and communication skills with multiple teams/ departments.Developing database applications which are automatedPlanning and implementing capacity expansion to ensure that the companys databases are scalableIdentifying issues with the database and resolving themInstalling and configuring the necessary components to ensure that the database is accessibleDiagnosing and resolving database access and checking on performance issues.Environment: SQL Server 2012, SSIS, SSRS, SSAS, Power BI, Visual Studio 2013, Team foundation Server, MS SharePoint, C#, Windows Server 2012 |
