NAME: JAMUNA SHRESTHA

PHONE: 201-***-****

EMAIL: adxou8@r.postjobfree.com

LOCATION: LIVINGSTON, NEW JERSEY, 07039

PROFILE SUMMARY

Having more than 5 years of IT experience in SQL Programming, OLTP, ETL, Business Intelligence and Data warehousing.

Extensively worked on MS SQL Server 2016/2014/2012 MSBI Technologies (SSIS, SSAS and SSRS), C# and .NET. Expertise in various phases of project life cycles (Design, Analyzing, Implementation and testing).

Have experience in developing data warehouse, data marts in multiple business domains -. Banking, Insurance and Healthcare.

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

Competent in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.

Highly adept in designing, developing, and analyzing SQL server and to extract, transform and load data using Microsoft Business Intelligence (BI) tools

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.

Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, stored procedures, and triggers using SQL Servers.

Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. Expertise in optimizing the queries by creating Index views, clustered and non-clustered indexed views.

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

Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load ETL solutions for data warehousing using SQL Server Integration Services SSIS.

Experienced in creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleansed data.

Have worked in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

Competently worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Dimension, Attributes, Measure Groups, Hierarchies.

Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SQL Server 2016/2014/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.

Implemented ETL Workflows to handle late arriving dimensions and late arriving facts using Surrogate Key Pipelining concept.

Implemented Slowly Changing Dimensions up to Type 3 using SSIS Slowly Changing Dimension Wizard and Hashing mechanism.

Experienced in Designing, Developing, and processing of cubes using SSAS. Developed and Configured Data Sources and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s, Hierarchies and calculated measures for OLAP cubes.

Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studios BIDS .

Experience in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.

Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services SSRS .

Experience working in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of seven days) called "sprints".

TECHNICAL SKILLS

SQL Server and Database Tools: Business Intelligence Development Studio (BIDS), Enterprise Manager, Profiler, Query Analyzer, Storage, Data Mining Models, Bulk Insert and BCP, Export & Import (DTS), SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2012/2014/2016, MS Access

ETL Tools: SSIS (SQL Server Integration Services), DTS

Languages: Transact - SQL, Procedural-SQL, MDX/DMX, HTML, DHTML, XML, VB.Net, C and C++

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

Analytical Tools: SSAS – multidimensional and tabular model

Programming Languages: C#, ASP.NET, T-SQL, PL/SQL, MDX, and DAX.

Web Technologies: HTML, CSS,JAVASCRIPT

Cloud Technologies: Azure SQL Database

Methodologies: Agile, Scrum, Waterfall

Other Tools: TFS (Team Foundation Server), Visual Studio 2013, 2016, GitHub, and JIRA (JQL queries)

WORK EXPERIENCE

SQL/ETL Developer

Client: BronxCare Health System

Location: Bronx, NY

Duration: (Nov 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 the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.

Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.

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

Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

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

Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.

Utilized various ETL tools like SSIS/Import Export Wizard for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

Developed the SQL Server Integration Services (SSIS) packages to transform data from one server to another server as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Developed 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 Slowly Changing Dimensions transformation for Type 1 and Type 2 change of attribute values identification.

Enhancing and deploying the SSIS packages from development server to production server.

Designed Cubes with Star Schema using SQL Server Analysis Services. Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services.

Experienced in performed OLAP partitioning of cubes as well as cube optimization in order to increase the performance of cubes in SSAS.

Implemented process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Migrated DTS packages from legacy SQL Server to SQL Server 2016 as legacy SSIS Packages Migration assignment.

Performed Documentation for all kinds of reports and SSIS packages.

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.

Environment: MS SQL Server 2016, Windows Server 2016, MS SQL Server Integration Services SSIS, MS SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin.

SQL/SSIS/SSRS Developer

Client: Broadridge Financial Solutions

Location: Newark, New Jersey

Duration: (May 2021- Oct 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.

Actively participated in daily calls with Client and Client Team.

Performed various activities with team of technical staff and business managers and practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project.

Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting.

Developed logical and physical data models for schemas using MS Visio.

Defined check constraints, rules, indexes, and views based on business requirements.

Worked closely with Senior DBA on Normalization of database tables, developed (DDL) and (DML) and built Referential Integrity for RDBMS

Developed the Stored Procedures, Views, User Define Functions and Complex Queries.

Created Temporary Table and Common Table Expression (CTE) for query Optimization.

Designed and optimized indexes, views, stored procedures, and functions using T-SQL.

Programmed Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Developed SSIS packages to load slowly changing dimension tables (for Type 2 and Type3 loads).

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.

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

Worked with testing team to understand test cases and created processes (using stored procedures and SSIS packages) to automate ETL and SSRS testing.

Develop code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.

Worked on to generate on-demand/daily reports using COMPASS POINT software used by the Traders in the Mortgage Industry.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Environment: MS SQL Server 2014, Windows Server 2012 R2, MS SQL Server Integration Services SSIS, MS SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin.

SQL/SSIS Developer

Client: InfoDevelopers Pvt.Ltd

Location: Lalitpur, Nepal

Duration: (Sep 2019- Apr 2021)

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.

Involved in SDLC phases, from analysis to production implementation, with emphasis on identifying the source and source data validation, implementing business logic and used transformations as per the requirement in developing mappings and loading the data into the target.

Logicalized and created the table schema and stored procedures that used in Data Centre.

Used Joins and sub-queries for complex queries involving multiple tables from different databases.

Created and managed Clustered Indexes, Non-Clustered Indexes and Index fragmentations.

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

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).

Built SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Used SSIS to unite data from existing system and performed transformations on MS SQL 2012.

Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services (SSIS)

Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.

Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.

Developed Aggregations, partitions, and calculated members for cube as per business requirements.

Assisted in production OLAP cubes, wrote queries to build reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)

Built Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart, and matrix report).

Developed several drill down and drill through reports using SSRS.

Used Performance Point Server to create reports, scorecards, and dashboards.

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

Jr. SQL Developer

Client: Global IME Bank Ltd

Location: Kathmandu Nepal

Duration: (Mar 2018- Aug 2019)

Responsibilities:

Worked as a Subject Matter Expert for couple of AITs of Mortgage and Vehicle Service Operation Technology.

Worked as a key developer and poc of two different AITs for support and maintenace.

Building and Maintaining SQL Scripts, Indexes, Store procedures, Views and Functions and cursors.

Worked on Data Mapping and Data Dictionary to create New CRM interface with Wholesale Line of Business.

Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modeling.

Developed Stored Procedures, User defined Functions, Triggers, Custom Views and T-SQL Scripts in SQL server database.

Analyzed and optimized existing stored procedures and functions leading to performance improvement and faster payment processing.

Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.

Implemented SSIS data transformation scripts, created maintenance procedures, and provided data integrity strategies.

Developed Dimension and Fact tables based on the requirements and specifications. Involved in Loading Data into Dimension Tables and Fact table using SSIS Packages.

Developed SSIS packages to migrate data from legacy systems to the Data Warehouse environment, also to create reports in various formats like Excel, CSV, Text and XML.

Worked on SSIS Package, Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Implemented Extracting, Transformation, and Load (ETL), Import, Export Activities using SSIS Package.

Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.

Modifying existing SSIS packages and Stored-Procedures which are used in revenue data ETL process.

Efficiently implemented Error handling in SSIS.

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.

Upgrading around 150 complex existing SSIS Packages and stores procedures of vehicle & Mortgage Service.

Involved in programming of Multidimensional Expressions MDX to retrieve data from SSAS cubes.

Developed new process to pull the data from Hadoop and Teradata into SSIS and provide report to LoB.

Troubleshooted and monitored daily execution and implementing enhancement on existing SSIS packges.

Worked on Debugging and Fixing of failed SSIS jobs.

Scheduled SSIS Packages as SQL Jobs using SQL Server Agent.

Implemented an interface to organize SSRS reports, sort data sources, schedule report executions, and track report history.

Deployed multiple types of reports on Share Point and utilized dashboards with SSRS.

Environment: SQL Server 2012/2008, SSIS, SSRS, SSAS, Power BI, MS Access, EXCEL, HTML, Windows Server 2012, Visual Studio 2013.

EDUCATION

Master

Contact this candidate