Lata Pokhrel Bidary

Involved in gathering requirements for Database creation, scheduling status review meetings, documents, and code review.
Conducting a meeting with BSA to gathering more information on workflow for data migration and to understand new terminology for new application.
Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
Good exposure in creating and managing conceptual, physical, and logical data models.
Created data mapping and sourcing documents for various sources to NPS New App.
Involved in designing and implementing relational database RDBMS model as per business needs.
Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using SQL Server integration services.
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
Extracting data from IMS/DB2, MS Access, SQL Server for migration and performing various transformations in SSIS ETL per business rules.
Designed Data flows, Workflows, and jobs to load data from source to target in BO Data Integrator.
Enhancing and deploying the SSIS packages from development server to production server.
Designed and developed the OLAP systems for data mart applications using SQL Server Analysis Services.
Designed and built OLAP cubes to meet reporting needs.
Created Time Dimensions on OLAP Cubes using SSAS.
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.
Implemented process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Configured integration services and reporting services for developing new environment for NPS systems New Application.
Converted existing DTS packages to SSIS ETL and tune the connections pointing towards new applications.
Used change data capture CDC to simplify ETL in data warehouse applications.
sDeveloped complex SSIS packages using transformations /tasks and designed packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.
Experience in creating jobs, alerts, SQL mail agent and schedule SSIS ETL packages.
Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.
Experience pulling data from SSAS cube and developing and maintaining cubes.
Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.
Data cleaning and data manipulation such as Concatenation, LEN, Find & Replace, Filter & Sort, Conditional Formatting, Index Match, Remove Duplicates, Logic Functions, and Short-Cut functions were done using Microsoft Excel.
Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services
Performs System testing for all the modules and helps business in User Acceptance Testing.
Worked on generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.
Utilized tools like SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.
Coordinating with offshore team for on time delivery of products and query resolution activities.

Involved in gathering requirements for Database creation, scheduling status review meetings,
documents, and code review.
Conducting a meeting with BSA to gathering more information on workflow for data migration
and to understand new terminology for new application.
Designed the functional and technical documents, report templates and reporting standards
for the developers to work on the report development
Good exposure in creating and managing conceptual, physical, and logical data models.
Created data mapping and sourcing documents for various sources to NPS New App.
Involved in designing and implementing relational database RDBMS model as per business
needs. Responsible for developing, support and maintenance for the ETL Extract, Transform
and Load processes using SQL Server integration services.
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.
Extracting data from IMS DB2, MS Access, SQL Server for migration and performing various
transformations in SSIS ETL per business rules.
Designed Data flows, Workflows, and jobs to load data from source to target in BO Data
Integrator.
Enhancing and deploying the SSIS packages from development server to production server.
Designed and developed the OLAP systems for data mart applications using SQL Server
Analysis Services.
Designed and built OLAP cubes to meet reporting needs.
Created Time Dimensions on OLAP Cubes using SSAS.
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.
Implemented process for changing and maintaining the Warehouse, Optimizing
Dimensions, Hierarchies and adding the Aggregations to the Cube.
Configured integration services and reporting services for developing new environment for
NPS systems New Application.
Converted existing DTS packages to SSIS ETL and tune the connections pointing towards new
applications.
Used change data capture CDC to simplify ETL in data warehouse applications.
Developed complex SSIS packages using transformations tasks and designed packages
with error handling and package logging that stores the logging results in SQL table and flat
files on error, on warning, on task failed event types.

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS in Business Intelligence Development Studio BIDS and SQL Server Data tools 2019/2017
Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data in data warehouse
Prepared the complex data mapping for all the migrated jobs using SSIS
Designed SSIS packages to transfer data from flat files to SQL Server Using BIDS and SQL Server Data tools
Extensively used SSIS transformation such as Lookup, Derived column, Data conversion, aggregate, condition split, SQL task, Script task and Send Mail task etc.,
Created SSIS packages using SSIS Designer for export heterogeneous data from OLEDB Source Oracle, Excel Spreadsheet to SQL Server 2019/2017
Performed operations like Data reconciliation, Validation and error handling after Extracting data into SQL Server.
Worked on SSIS package, Import/Export for transferring data from Database Oracle and Text formatted data to SQL Server
Implementation of MS SQL Server 2019/2017 Management studio to create Complex Stored Procedures, User Defined Functions UDFs views using T-SQL evaluates result for the reports.
Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services SSRS
Created SQL server Reports using SSRS
Identified the data source and defined them to build the data source views
Creating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder
Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture.
Table, chart and matrix report
Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
Applied conditional formatting in SSRS to highlight key areas in the report data
Generated SSRS report using Oracle Database
Work on projects like Healthy Blue, Medical Loss Ratio and Account Searchlight to generate the reports
Creation of the various database objects tables/views/stored procedures - in SQL Server
Performed the optimization, Tuning of the indexes and the queries
Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
Development, Stored Procedures, Views, Triggers, Index and SQL Scripts
Created reports by extracting data from cube
Generated reports using SQL Server Reporting Services from OLTP and OLAP data sources
Generated reports from A.C Cube and Medical Management
Good experience in writing the MDX queries to pull the data from the cube
Expert in creating Star schema and Snow Flex cubes using SSAS
Created Dimension and Measure for the Cube
Deployed the RDL on SharePoint.
Deployed the business documents on SharePoint
Generated the reports in SharePoint
Extensively worked in Oracle SQL, PL/SQL, SQL Plus, Query performance tuning, Created DDL scripts and Database objects like Tables, Views and Indexes.
Experience in working on conceptual, Physical and logical data models using Erwin and Visio Data Modelling
Used Waterfall methodology for the development

Gathered requirement from the end user and developing ETL workflow for various ongoing projects
Involved in designing physical and logical data models and handling data repository for data models
Implemented Database Mirroring and Log Shipping as part of Disaster Recovery.
Implemented SQL Logins, Roles and Authentication Modes as a part of Security
Designed, Developed and Tested ETL logic for moving data from sources that were updated on daily basis.
Worked with variety of file sources such as flat files, excel files and XML files.
Incorporated incremental loading into destination database.
Worked with different types of transformations such as row transformations, partially blocking transformations, fully blocking transformations and involved in performance tuning of SSIS packages.
Established logging in packages and directed the log files to the concerned authority using Send Mail Task.
Deployed SSIS packages to different environments such as production and testing in the SDLC.
Performed VB and C# scripting in script Component.
Used C# for Error Reporting.
Involved in Performance tuning, and optimization of procedures and queries.
Created complex stored procedures, functions, triggers, and other database objects for applications using T-SQL.
Created tabular and matrix reports based on custom requests from the end user.
Created reports using SSRS from OLAP and OLTP data sources and deployed on report server.
Generated ad-hoc reports using SSRS and Crystal reports.
Created custom reports using Tableau and evaluated the tool as per client request.
Constantly updated and maintained statistics for better performance.
Incorporated complex business logic into functions and stored procedures.
Created packages in SSIS with error handling.
Created SQL Server Profiler traces for optimum performance of queries.
Actively involved in Normalization (3NF) & De-normalization of database.
Rebuilt indexes on various tables as per need.
Configured and administer BPA Business Process Automation for designing ETL workflow and including multiple packages within the workflow.
Administrated the Medicare and CRM data projects and deliver the data to vendor for further analysis and development.