EXECUTIVE SUMMARY:

• Experienced Database and Data Warehouse Developer with more than nine years of database development experience, well versed in Microsoft BI Stack including Integration (SSIS), Analysis (SSAS), Reporting (SSRS), and coding of T - SQL stored procedure, views, triggers, and user-defined functions.
• I have worked in multiple upstream clients to develop Data warehouses and integrated different sources for accounting, production, and land.
• I have experience working with all phases of SDLC throughout the project life cycle environment with hands-on experience in business process tools such as Microsoft Office suite and MS Visio.

TECHNICAL SKILLS:

• SSRS Report Builder
• Power BI
• Telerik Reporting Tool
• Spotfire
• Tableau
• Power View
• Excel & Excel Services 2016

• SQL Server Management Studio
• SQL Server Business Intelligence Development Studio (BIDS)
• SQL Server Data Tools (2016)
• Visual Studio 2017
• Azure Data Factory

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Responsibilities:

• Manage Product issues along with managing smart source projects for multiple clients
• Analyze and fix Database, MDM and Data Warehouse issues.
• Develop PowerBI queries and relations using best practices, and maintained mapping documentations for all queries.
• Developed Power BI Reports involving complex DAX, and Role playing Dimensions.
• Update existing Power BI reports to add measures, including editing relations as needed.
• Manage existing reports in SSRS and create new ones on demand.
• Managed Database projects for clients.
• Managed Project Team and provided weekly and monthly reports.

Confidential

Responsibilities:

• Analysis of data requirements to move the AFE Cost and budget information from quorum to Wellview and Siteview.
• Created the mapping document between the source and destination.
• Created SSIS Packages to pick up the data from different custom data sources.
• Schedule jobs to run the SSIS Packages based on the client requirements.

Confidential

Responsibilities:

• Set up the ADF connections and resource groups for the loader.
• Created ADF pipelines to move data to the Azure SQL server.
• Schedule jobs to run the pipelines to pull the live data from multiple tables to the Client Database tables.

Confidential

Responsibilities:

• Analysis of the requirements to add new attributes to the Financial, Production and LOS cubes.
• Created SSIS Packages to load the additional data needed for the new attributes.
• Load the data to the dimension and fact tables and views to feed the cube
• Adding to the data source views and set up the relationship as needed.
• Added new attributes to the Confidential MDM tool and writeback to Generwell.

Confidential

Responsibilities:

• Created SSIS Packages to pick up the Excel spreadsheets from different custom data sources and load it to doorstep tables.
• Analyze the data in the doorstep tables and generate exception if they are not as per the requirements.
• Load accurate data into the respective tables and archive the excel files in reserved locations.
• Created the master packages to control the flow of data from folders where excel sheets would be dropped to notifying the users the status of the file.
• Schedule jobs to run the SSIS Packages based on the client requirements.

Confidential

Responsibilities:

• Working closely with the Land team and collecting the required information for analyzing the requirements for creating the dimensions and facts.
• Created the various dimensions and facts for Land cube.
• Integrated the multiple dimensions from the production and accounting cube for ease of access.
• Created shared dimensions to be shared across multiple cubes

Confidential

Responsibilities:

• Analyzing attribute requirements for MDM Confidential .
• Configuring Master Data Management system using the Confidential MDM tool.
• Setup the source for each attribute and the secondary publishers as per requirements.
• Developed the Golden Record table in SQL from the MDM for reporting and cube use.
• Developed the various Data quality checks to keep MDM data pristine.

Confidential

Responsibilities:

• Worked closely with the data management team to identify the issues and resolve them
• Analyzing multiple sources including Kingdom, well hub and Open Confidential to define rules
• Defined Data Quality rules for multiple sources for different departments
• Solved various issues due to data latency in different sources.
• Implementing best practices through Data Quality Rules

Confidential

Responsibilities:

• Worked on the development of their central data warehouse, which collects the data from different sources.
• Analyzed the data to be used in the Dashboard to help the senior management in making decisions about making appeals to the right donors based on their past giving levels.
• Developed and published multiple Power BI reports from varied sources.
• Developing Elastic cubes using sisense Elasticubes and dashboards in the JCA (third party tool)
• Created the SSIS Packages to load the data from different sources like from Raiser’s Edge, PUMPS into the data warehouse.
• Schedule jobs to run the SSIS Packages based on the client requirements.
• Created the loader packages for loading the data from different formats, including excel, access files.

Confidential

Responsibilities:

• Working closely with the Wellview team to design the required and conditional rules for data quality.
• Configuring and managing the quality of the well view data in 9.0 using a third party Data quality tool.
• Analysis of the data to be migrated and writing scripts to move the data to respective fields as needed by Confidential Asset Team

Confidential

Responsibilities:

• Working on the development of the Confidential, a product developed to load data from different sources using Custom Loaders
• Configuring and managing the Master Data Management Tool (Naveego)
• Building custom Stored Procedures and Views for loaders and Data warehouse
• Involved in the architecture of the product development
• Design and develop reports using SSRS and Spotfire

Confidential

Responsibilities:

• Worked on the development of their central data warehouse, which collects the data from different sources.
• Developed SSIS Packages to load the data for the MDM using the Master Data Services.
• Created the SSIS Packages to load the data from different sources like from Enertia, Procount, Wellview into the data warehouse to adhere to the PPDM Standards.
• Designed the SSIS Packages to handle the nulls and blanks using project parameters and derived columns which allows changes at one place for all the packages in the solution.
• Created the master package for the whole solution and designed it to run all the Dim’s and Fact’s efficiently in the allocated time window.
• Schedule jobs to run the SSIS Packages based on the client requirements and send the results as required.
• Created the loader packages for loading the data during acquisition which can be in different formats including Excel, CSV dumps.
• Worked on loading the data for the EMK3 using the SSIS packages and Stored Procedures from EMK3.
• Created the Template standard for all reports and Complex reports using SSRS.
• Worked on the Management Reporting System (SSAS) in pulling the data from different systems and used SSIS to create the dimensions and facts for the cube.
• Worked on writebacks for the Master Data Management where the sources determined as master and the other sources act as subscribers and when data in master changes the same is reflected in other sources to have a single source of truth.

Confidential

Database and Data Warehouse Developer

Responsibilities:

• Analysis of Rimbase and well core data
• Created Stored Procedures to move the data to Open Confidential
• Reverse engineered the data movements
• Developed SSIS Packages to Load Stage Tables with Production well data
• Created Stored Procedures to Populate the EMK3 Import Tables with Well data from the stage tables
• Scheduled the jobs and alerts

Confidential

Responsibilities:

• Created SSIS Packages for extracting data from the different sources
• Created Stored Procedures to add slowly changing dimension logic for the Dimensions
• Packages to Load Dim and Fact Well information and scheduling the job and mail update
• Developed SSIS Packages to Load Aries Tables with Production well data

Confidential

Responsibilities:

• Interviewed client subject matter experts to capture requirements and desired design components related to operational and financial metrics.
• Created and modified views to add logic and reformat retrieved data
• Created Excel Services cubes for consolidation
• Used SSRS reports creating the Account and Contact Dashboard
• Designed and created PowerPivot Reports using Pivot table, Slicers, and Filters