NAME: KRISHA MAHARJAN

EMAIL ADDRESS: adyo30@r.postjobfree.com

PHONE NUMBER: 619-***-****

LOCATION: LA MESA, CA 91942

SUMMARY

Have more than 5 years of IT experience as database development, design, analysis and support various applications using MS SQL Servers 2016, 2014 and 2012 versions.

Experienced in Software Development Life Cycle (SDLC), Agile, Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.

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 in SQL Server with design and development of Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.

Proficient in T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.

Developed T-SQL queries, Views, Complex Stored Procedures, User Defined Functions UDF, Database Triggers, Indexes, and various constraints.

Implemented several Sub-Query constructs, Common Table Expressions, and different types of Joins, Rollups, Cubes, Set Operators to simplify complex queries involving multiple tables.

Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. Hands on experience in creating and managing fragmentation of Indexes to achieve better query performance.

Proficient in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

Worked with new data quality services DQS in SQL Server as part of creating rules for data mapping and data cleansing.

Experienced in Query Tuning by Using Execution Plan, DMVs, query analyzer and tuning advisor.

Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.

Experience in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.

Proficient in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).

Developed SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.

Implemented Star Schema, Snowflake Schema models in Data Warehouses and Data Marts. Designed different types of Fact & Dimensions tables along with their ETL packages.

Experienced in design and development of SSAS Multidimensional - Dimensions, Measure Groups and their relationships in Dimension Usage Tab, Partitions, Cube Processing mechanism using SSIS package and XMLA scripts for deployment of SSAS Databases.

Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.

Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.

Good knowledge on 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.

Solid working experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.

Experience in Object Oriented Analysis concept implementation, design, and programming technical skills.

TECHNICAL SKILLS

SQL Server Tools

Microsoft Visual Studio 2013/2017, SQL server Management Studio

Database

Microsoft SQL 2016/2014/2012, Oracle 11g/Oracle 10g, Oracle 9i, MS Access

Programming Language

SQL, T-SQL, PL/SQL, C#.Net

Operating Systems

Windows, Windows Server 2016/ 2012 R2/ 2012, UNIX

Tools

Erwin, Microsoft Visual Studio 2008/2005, Share Point Server 2007, Microsoft Project Server 2007, ProClarity

Architecture

Relational DBMS, Client-Server Architecture, OLAP, OLTP

Business Intelligence

Power BI, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Crystal Reports

ETL Tools

SSIS (SQL Server Integration Services), DTS

PROFESSIONAL EXPERIENCE:

SQL/ETL Developer

Company: Bank of the West

Location: San Francisco, CA

Duration: June 2022 - Present

Responsibilities:

Collaborated 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.

Involved in requirements gathering, analysis, design, development, change management, deployment.

Developed and maintained new documentation in the process of bug fixing and Enhancements to all the applications that are part of support responsibilities.

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.

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 fragmentations.

Worked closely with Solution Architect and gave significant input on Normalization/De-Normalization of database tables and built Referential Integrity for RDBMS.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server

Designed and developed ETL data flows using SSIS; workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.

Modified SSIS ETL packages for updated business requirements to load data from different source files to SQL Server tables in data warehouse.

Deployed SSIS packages in SSIS Catalog in database server through ISPAC file.

Analyzed and enhanced the existing ETL strategies to populate the existing data warehouse with facts and dimensions based on new requirements in a multi-application environment.

Designed SSIS packages to migrate the data from SQL Server to the staging area.

Created SSIS Packages for ETL process to transform and load data from flat files to the data warehouse.

Developed master and child packages, using package configurations (SQL Server) and SSIS logging.

Created Jobs, SQL database Mail stored procedures, Alerts and scheduled SSIS Packages.

Utilized various Transformations in SSIS Control Flow and Dataflow using for loop Containers and Fuzzy Lookups etc.

Developed SSIS packages, Store Procedures, XML configuration files, tables, views, functions and to implement best practices to maintain optimal performance.

Design packages which utilize tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.

Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.

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.

Implemented Error and Event Handling using Precedence Constraints, Break Points, Check Points and Logging.

Designed and developed Cubes along with Dimensions and Measure groups with different Architectures and Data Sources for Business Intelligence, Programmed MDX Scripts as per business reporting requirements.

Developed Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.

Created Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.

Designed reports based on new requirements for Design and Project Planning with SQL report service (SSRS).

Developed Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.

Been part of team as Flexible, enthusiastic, and project-oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Environment: SQL Server 2014/16/17/19, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SharePoint, TFS, JIRA, Visual Studio, C#, Windows Server 2016

SQL/BI Developer

Company: Cigna Healthcare

Location: Bloomfield, CT

Duration: Apr 2021 – May 2022

Responsibilities:

Involved 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.

Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.

Involved in project planning, organizing, monitoring, and controlling projects using appropriate tools and techniques

Designed, monitored, and extended data warehouse and analytics architecture to meet company business analysis and reporting needs.

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.

Programmed store procedures to generate account statements for different types of accounts to cater complex business rules. Developed T-SQL code to create custom user defined Tables, Views, and triggers and stored procedures to handle meta data and custom logging.

Developed ETL and data warehousing solutions using Microsoft SQL Server and Microsoft SQL Server Integration services.

Modeled the requirements and developed the appropriate Dimension tables and Fact tables

Decided data granularity and slowly changing for the dimensions and facts required based on the analysis requirements, Designed, and developed the junk dimensions, Shared dimensions, and time dimensions i.e., role playing dimensions.

Performed Data modeling and mapping which involved identifying the source data fields, identifying target entities and their lookup table ids and translation rules.

Implemented Slowly Changing Dimension Type 1 and Type 2 using SSIS Slowly changing dimension task as well as implemented using SHA-5 hashing using HASHBYTES T-SQL function.

Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different sources using SQL Enterprise Manager/SSMS on SQL Server environment and deploy the data; scheduled the jobs to do these tasks periodically.

Developed Data mart and different SSIS packages to load staging, fact, dimension, and metric data into data mart.

Designed and documented the error-handling strategy in the ETL load process. Prepared the complete ETL specification document for all the ETL flows.

Implemented the logging, Breakpoints, handled errors especially foreach loop and continued execution logging previous iteration error(s).

Implemented OLAP (Online Analytical Processing) data warehouses (star and snowflake Schemas) and business intelligence reporting systems.

Helped design and implement processes for deploying, upgrading, managing, archiving, and extracting data for reporting.

Deployed end-to-end Business Intelligence solutions including SQL Scripts, SSIS packages (ISPACs and DACPACs).

Implemented C# script task to load the data from nested XML tagged files using XSD document, files.

Environment: SQL Server 2016, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, TFS, Windows 10, Windows Server 2016, Visual studio 2017, TFS, Git Hub, Point Services 2010, Microsoft office, T-SQL,Power BI

SQL/SSIS/SSRS Developer

Company: Leapfrog

Location: Kathmandu, Nepal

Duration: Dec 2019 – Mar 2021

Responsibilities:

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

Closely worked with Business analyst for gathering requirement 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

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.

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.

Utilized Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub-queries with JOINS to enhance the performance of Databases.

Decided data granularity and slowly changing for the dimensions and facts required based on the analysis requirements, Designed, and developed the junk dimensions, Shared dimensions, and time dimensions i.e., role playing dimensions.

Performed Data modelling and mapping which involved identifying the source data fields, identifying target entities and their lookup table ids and translation rules.

Implemented Slowly Changing Dimension Type 1 and Type 2 using SSIS Slowly changing dimension task as well as implemented using SHA-5 hashing using HASHBYTES T-SQL function.

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.

Developed SSIS packages to Push and Pull data using Rest APIs and other different sources and vendors.

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.

Created Package Configurations, Event Handlers for On Error/Warning/Task Events.

Implemented the logging, Breakpoints, handled errors especially foreach loop and continued execution logging previous iteration error(s).

Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.

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

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 the deployment of the cube.

Programmed MDX queries to retrieve data from the multidimensional cube and use it as the source for multiple SSRS reports.

eployed end-to-end Business Intelligence solutions including SQL Scripts, SSIS packages (ISPACs and DACPACs).

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.

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.

Used different types of files like XML, JSON to load the data into sql database using ZappySys .

Provide support to junior co-workers and work with offshore resources for knowledge share.

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

Environment: MS SQL Server 2014/16, Windows 2000 Server, Windows NT Server, T-SQL, BIDS, Microsoft SSMS Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2017, XML, OLAP, OLTP, Microsoft Office, Windows Server 2016, SQL profiler, MS Visio-SQL.

Jr. SQL Developer

Company: World Link Communication

Location: Kathmandu Nepal

Duration: Jan 2018 - Nov 2019

Responsibilities:

Interact with clients to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.

Programmed complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.

Responsible for creating schema objects like tables, views, and indexes.

Programmed Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), create and maintain Physical Structures.

Utilized Dynamic Management Views, System Views for Indexing and other Performance Problems

Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.

Involved development of 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.

Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.

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.

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.

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.

Responsible for creating reports based on the requirements using SSRS and Defined the report layout and identified datasets for the report generation.

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.

Developed different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.

Worked with DBAs, QA and systems support personnel in elevating and automating successful code to production.

Environment: MS SQL Server 2012, SQL server Integration Services, SQL Server Reporting Services, VSS visual source safe, .NET Framework, Microsoft Visual Studio 2013, SQL Server Management Studio, MS Excel, T-SQL,ERWIN, Windows Server 2012.

EDUCATION:

Bachelor

Contact this candidate