Bhola Mainali Email & Phone Number

Southlake, Texas, United States

• Worked in wide range of technologies, including Oracle Database, CRM, ERP, SQL Server, and various Azure services.• Demonstrated ability to develop and implement effective solutions for complex business problems through excellent analytical, conceptual, and problem-solving abilities.• Worked in different services like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).• Experienced in Power BI report development and management.

Richardson, Tx

• Coordinated with the Back end and API team to provide them with the necessary functions, packages and insight into the data.• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse.• Maintained and managed database/stored procedures using SQL server tools like Performance Tuner and SQL Profiler• Extensively used bulk collection in SQL objects for improving the performing. • Developed foreign data wrappers, bulk loading EDW files using copy, search path, performance tuning complex alarm queries, Postgres functions.

Grapevine, Texas, United States

• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.• Worked on SQL Loader to load data from flat files obtained from various facilities every day.

Red Oak, Texas, United States

• Involved in Design and Development phase meetings for Business Analysis and requirement gathering.• Developed Database application to meet business needs using Oracle SQL features. Created Packages, Procedures, Functions and Triggers.• Involved in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.

Lawton, Oklahoma, United States

•Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.•Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.•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.