SQL Developer
Resume:
Bhola Mainali
****************@*****.***
SUMMARY:
Over 8 years of IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2017, 2016, 2014, 2012, 2008in Production, Testing and Development.
Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
Experience with 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.
Experience in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models, Cursors and data integrity, SQL joins and writing Sub Queries.
Well versed in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, performance tuning and optimization of SQL scripts and SQL queries.
Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages.
Experience working with Data Cleansing technique, different types Dirty Data from different sources.
Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
Strong knowledge in designing Extraction, Transforming and Loading(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.
Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks
Hands on experience in creating and migrating AOL objects such as Concurrent programs, Value sets, Menus, functions.
Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management using SSIS (SQL Server Integration Services).
Expert in creating various types of reports like complex drill down reports & drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Excellent communication skills with capability to form and maintain positive and productive working environment as an individual or a team player.
Educational Details:
Bachelor’s in business studies (May2007), Tribhuvan University.
Kathmandu, Nepal.
TECHNICAL TOOLS:
Operating systems
Windows 98/NT/2000/XP/Vista/Windows7/8
Databases
MS SQL Server 2005/2008,2012/2014, MS Access
Database Tools
SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)
ETL Tools
DTS, SQL Server Integration Services, SQL Server Analysis
Reporting Tools
SSRS, R studio, Crystal Reports, Congo's, Micro Strategy
Development Skills
Transact SQL (T SQL), PL/SQL, Azure Databrick, NoSQL databases
Languages
C, C++, HTML, XML, VB.Net, Asp.Net (C#)
Application Packages
Microsoft Office Suite
PROFESSIONAL EXPERIENCE:
Data Engineer
CBRE Investment Management
Richardson, Texas
November 2021- Current
ROLES AND RESPONSIBILITIES:
Mainly focus on performance enhancement of the functions in Postgres and store procedure in MS-SQL.
Developed new features like stacking plan, custom view, rent-roll view based on future leases, vacancies etc. in GO-Analytics application.
Coordinated with the Back end and API team to provide them with the necessary functions, packages and the necessary insight into the data.
Worked as a support team member for daily data refresh/copy job in different environment likes; Dev, Test, Staging and Prod.
Participated in the design, implementation, and maintenance of systems.
Designed, coded, tested and documented software programs of moderate complexity as per the requirement specifications.
Assisted in preparation of requirement specifications. Analyzing the data, design, and develop data driven applications including documenting and revising user procedures and/or manuals.
Analyzed, reviewed, and altered program to increase operating efficiency or adapt to new requirements.
Written documentation to describe program development, logic, coding, and corrections.
Environment: SQL Server 2019 Enterprise Edition, Postgres using DBeaver, Lymbic in-house ETL job, Jenkins, Azure for code check-in, Agile methodology, MS Project, Windows 2003 Server, .NET, C#, ASP.NET, SSIS.
SSIS/SQL Developer
SMS InfoComm Corp.
Grapevine, Texas
March 2020 - October 2021
ROLES AND RESPONSIBILITIES:
Responsible and active in the analysis, design, implementation and deployment of full Software Development Lifecycle (SDLC) of the project.
Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Created database objects like tables views, materialized views, procedures and packages using oracle tools like SQL Developer.
Created SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Worked on SQLLoader to load data from flat files obtained from various facilities every day.
Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
Migrated data between different heterogeneous sources such as Flat file, Excel using SSIS.
Partitioned the fact tables and materialized views to enhance the performance.
Extensively used bulk collection in SQL objects for improving the performing.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Worked extensively in various kinds of queries, Sub- Queries, Correlated Sub-Queries, Dynamic SQL, and Union Queries.
Used SQL hints and indexes to improve SQL performance and analyzed the schema tables to get the better performance.
Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
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.
Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
Generated reports that can handle dynamic grouping and dynamic sorting for efficient and clear viewing of the reports.
Developed Sub Reports, Matrix Reports, Charts, and Drill Down Reports, using SQL Server Reporting Services (SSRS).
Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
Performed Server level tuning, performance monitoring, Index Tuning, Query Tuning.
Environment : SQL Server 2012/2016 Enterprise Edition, Enterprise Manager, JavaScript, DAX, ERWIN, UML, MS Project, Windows 2003 Server, .NET, C#, ASP.NET, SSIS, SSRS, SSAS.
MSBI Developer
Red Oak Shamrock
Red Oak, TX
Aug 2018- Feb 2020
ROLES AND RESPONSIBILITIES:
Involved in Design and Development phase meetings for Business Analysis and requirement gathering.
Developed Database application to meet business need using Oracle SQL features. Created Packages, Procedures, Functions and Triggers.
Implemented parallel processing using DBMS SCHEDULER, DBMS JOBS and SQL Hint. Created parallel pipelined Table functions.
Fixed dead lock occurred in existing application due to un-indexed foreign keys. Modified logic in existing application to ensure strict ordering of updates are performed.
Tuned SQL packages and views to optimize performance and resolve bottlenecks, problems and space utilizations in acceptable time frame
Tuned queries doing repeated PL/SQL function calls, used scalar sub-queries instead. Created views embedding function logic into SQL.
Assisted with Troubleshooting and corrections for availability and performance of database objects such as views and packages
Removed unwanted fields from query to use index, modified code to replace aggregates with analytical functions.
Wrote script to find unused index in overly indexed environment. Monitored environment for a week and dropped unused index, performed index rebuild as required after data archival.
Tuned queries using nested views and analytic functions. Wrote pagination queries for generating different reports.
Involved in Dimension Modeling, Star Schema, designing Dimensions, facts for Data Warehousing, ETL and OLAP Cubes.
Preparedly Architectural Documents, Process flow diagrams and Mapping Documents.
Involved in Regression Testing, Throughput Testing and Performance Testing during Oracle 11g Upgrade. Tuned some of the long running queries and applications to use Oracle 11g features.
Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
Environment: SQL Server 2010, Visual Studio-2010, SSRS, SSAS, SSIS, T- SQL, and TFS, MS SQL Server 2005/2008, Visual Studio-2006, T-SQL, MS-Office, MS-Excel, VSS
ETL Developer
Goodyear,
Lawton, OK
Aug 2016- July 2018
ROLES AND RESPONSIBILITIES:
Played role in design of scalable, reusable, and low maintenance SSIS templates.
Build efficient SSIS packages for processing fact and dimension tables with complex transforms such as Lookup, Fuzzy grouping and Row Count Transformations and type 1 and type 2 slowly changing dimensions.
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.
Created SSIS packages for application that would transfer data among servers and perform other data transformations.
Scheduled SSIS packages by creating the jobs using job scheduler.
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.
Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
Generated parameterized reports to enable/disable the parameters based on user selection in SSRS.
Worked on performance tuning, writing stored procedures and creating indexes.
Implemented complex stored procedures and automated them using SQL Server Agent.
Created triggers (Instead Of and after) for auditing purposes.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Proficient in creating and tuning database, developing views and having good exposure of C# and .NET Framework.
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.
Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.
Environment: MS SQL Server, T-SQL, PL/SQL, SSIS, SSRS, SSAS, SQL Server BIDS, MS- Visual Studio, ASP.Net, C#.Net, ADO.Net, XML, MsVisio2003/2007, MS Project.
SQL Developer
Century Commercial Bank
Nepal
July 2013– May 2016
RESPONSIBILITIES:
Extracting, Transforming and Loading of tourist related data obtained from different sources like immigration offices, Hotel Association, Tourism Department, Travel and Trekking Associations, and other field surveys etc. in different formats (Flat File, Excel, XML files tables etc.) into SQL database.
Involved in the publication of Tourism Statistics.
Involved in reviewing the Investments application and interacting with business users to understand the user requirements and involved in all phases of SDLC.
Created and maintained database mapping document which mapped the old tables to the new ones.
Developed stored procedures, user-defined functions, triggers, indexes and views.
Involved in query optimization for faster processing of queries.
Created allocation and other reports using SQL Server Reporting Services (SSRS).
Designed and tested (Unit and Integration) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
Loaded flat files into SQL Server tables and vice versa using SSIS.
Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, and Expression.
Created XML configuration files to dynamically alter package properties.
Developed error handling routines for packages using both script tasks as well as in the error handling tab.
Developed Unit Test Plans for SSIS packages.
Responsible for allocating responsibilities and coordinating ETL efforts among team members to ensure best practices are used.
Involved in regular code inspections to ensure business and system requirements are met.
Scheduled package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
Documented ETL processes and prepared project status report updates/audit reports/ list of issue items that need to be reviewed.
Involved in project scope, schedule planning and project impact assessments.
Contact this candidate