We provide IT Staff Augmentation Services!

Technical Etl /bi & Testing Consultant Resume

CAREER SUMMARY:

  • I have more than Fourteen years o f total IT experience out of which Eight years in Production, Staging, Development Environments in Enterprise Edition MS SQL Server 2016/2012 / 2008R 2/2008/2005/2000 Database with MSBI ETL - SSIS , SSRS & SSAS (BIDS), Data warehouse, Data Modeling , Data Analysis , cleansing, Data Mart , Designing , Testing , Data mapping, End to End Implementation, Business Intelligence , OLTP (Batch Processing, Online Processing), OLAP, POWER BI with DAX, Tableau Report, ERWIN Data Modeler Tool, N ormalization, Monitoring Jobs, Schedule Task, SQL Profiler (Trace), SQL Query Optimization, Performance / Database Tuning Advisor (DTA), Analysis Query Execution plan, Indexes, Message Queue (MSMQ), Specialist in T -SQL Programming .
  • I am experienced in Physical, Logical design, Patch Release, Deployment, Intermediate in Talend ETL Data Integration Tool, and SQL Azure Cloud Service on development.
  • Over 3+ years experience in SAP HANA - BI / BODS 4.0 & BO Design Studio on Development with SAP Lumira (Visual Intelligence Tool) and knowledge in SAP BASIS and S4/HANA
  • Over 6+ years of experience as an ORACLE DBA activities & Creating Database objects, PL/SQL and Data Analysis, Database Design, Migration, Views, Constraints, Index, Stored Procedures, Functions, Packages and Triggers.
  • 1 year experience in SYBASE T-SQL, MySql T-SQL Programs, Web site Configuration of IIS
  • Specialist in Crystal Report Designer in different projects.
  • Involved Database on SQL Server, Oracle, Sybase, MySQL, SAP Hana DB, MS-Access
  • Involved in Production / Development support on MSBI /ETL/Data Warehouse with Power BI for existing multiple application projects at the client place Confidential Bank - BAHRAIN, Confidential Technologies - Saudi Arabia & NBO - Oman
  • Area of Specialization is MS- SQL Server, Oracle, Sybase, MySql, SAP HANA, MS-Access, Cloud Server, Data Warehouse
  • Proficiency in Database design, Coding, Debugging, Testing, Deployment, Huge data migrations, Data Warehouse, Bulk Copy Program (BCP), Support and Maintenance of business applications using SQL Server 2016/2014/2012/ 2008/2005/2000 , DTS, SSIS,SSRS,SSAS
  • Expert in creating objects such as T-SQL Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs), temp Tables, DDL/DML/DCL and Complex Queries osn MS SQL Server
  • Expertise in Performance tuning, Optimization, Data Integrity, Statistics and monitor through SQL Profiler to solve dead locks / long running query issues
  • Experience in Index Fragmentation, DBCC checks, Query Tuning, SQL Error & Event Handling and creating Jobs, SQL Mail Agent, Alerts and Scheduled
  • ITIL - Involved Handling of more than 30 tickets daily basis of Production, development and QA team request on different databases and different environments across 1500 SQL Server Instances
  • Interacted with the existing database developers and understand the existing schema
  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation
  • Developed data mapping documentation to establish relationships between source and target tables including transformation processes
  • Configure Message Queue used through Service Broker on the Database for application Projects
  • Extensive experience in Installation, Configuration and Updates of MS SQL Server 2008 / 2012/ 2014/ 2016
  • Migrating SQL Server to SQL Azure
  • Involved Scrum Call & Agile / Water Fall method
  • Used SQL queries for data validation and backend testing
  • Work in support of the development of company products and services
  • Strong in SQL preparation in SQL Server,Oracle,SAP/RDBMS
  • Used to DB tools Toad, T-SQL and PL/SQL Dev
  • Involved in BI report validation developed using SSRS & BI
  • Perform data analytical testing for the BI systems
  • Checked/Validate of data transformations and perform End-to-End data validation for ETL & BI systems
  • Validate /Reviewed database functional requirements and mapping transformations
  • Involved Unit testing, SIT & UAT and send to Project Lead
  • Extensively used SSIS Package in different Control Flow, Data flow Tasks for Data transformations such as lookup, merge, derived column, data conversion, conditional split, aggregate with Checkpoints
  • Involved in migration of SSIS Packages from 2005/2008 to 2012
  • Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
  • Experienced in client requirement Analysis, Logical, Physical design, development using Erwin and also used other Traditional Databases for Data Modeling & Data Architect
  • Involved of Data Marts, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services/Erwin.
  • Create Users and assign permissions based on the level of database access the user would need
  • Effective Change Management of around 500 GB Size Database across Testing, Development and Production Environments
  • Experience in maintaining one to many and many to one relationships while moving data between two databases
  • Involved data migration from Oracle PL/SQL to SQL Server T-SQL
  • Strong expertise in performance tuning and data warehouse database design
  • Experienced in Talend ETL Create Jobs, writing expressions with in tfileinputExcel, tReplicate, tFilterRow, tmysqlConnection, tmysqlfile, tmysqlrow, tmysqlInput, tmysqkcommit, tmysqlclose, tprejob, tpostjob, tOracleInput, tMSsqlinput, tfileInputXml, tXmlmap, tmap, tLogRow as per the business need and also handled insert and update Strategy using tmap
  • Specialist in Designed Complicated Seagate Crystal reports (Cross Tab Reports/Pivot, Sub reports, Dynamic reports Creation)
  • Developed Tableau visualizations and dashboards using Tableau Desktop
  • Design Dashboards using Filters, Parameters and Action Filters
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
  • Expert in creating and developing Dashboards in to rich look and writing complex DAX functions in Power BI, Power Pivot, Power Query, Power View
  • Experience working with Tabular Model, DAX and SSAS
  • Solid Experience in MSBI skills including, T-SQL skills like writing complex queries, dynamic queries and stored procedures, creating indexes, partitions
  • Expert in creating, developing & writing complex DAX expressions like Filters, Aggregate, Mathematical etc in Power BI Dashboards and Published/shared the reports by creating Content Pack/Sharing the pbix file.
  • Involved Create Different type of visualization Chart, Cross Filter Slicer & Dashboard Analyze reports in Power BI
  • Involved Tableau visualizations and dashboards using Tableau Desktop and multiple data sources using Data Blending
  • Creation of Attribute View, Analytical view and Calculated view
  • Created ETL Jobs in BODS and Specialist in Crystal Reports Designer
  • Involved on SLT & SDA - Extraction Structure/Unstructured Data from Different Source Systems into HANA DB
  • Load Data from SAP ECC (ERP Central Component) to SAP HANA using SAP BODS
  • Expert in SQL Script, Function, Procedure Calls, Designing tables and Data loads
  • Extract the data from MS SQL Server Database into HANA Database using BODS
  • Analyzed the existing queries for real time reporting requirements
  • SAP Lumira - Created data visualizations and stories from multiple data sources
  • Having Good Knowledge and Experience in RDBMS Concepts, ORACLE and SQL SERVER Database
  • Involved Unit Test & Integration Testing and Batch Update1
  • Involved in deploying the changes to QA, Staging and Prod environments
  • Implementation and release of database changes according to agreed timescales and costs
  • Exposure in SQL Azure Cloud Service and Intermediate in Microstrategy Business Intelligence Development - Creation of Custom Groups, Attributes, Consolidations, Facts, Filters, Attributes and Metrics, Prompts
  • Intermediate in Azure SQL Cloud Connection & Database Access & IBM InfoSphere DataStage Tool - Used Pallet Tools like Databases, Files and Processing for pull the Data from Source and push it into Destination File/DB
  • Coordinating with offshore Development team, Support Calls and client coordinator Directly
  • Involved Unit Test & Integration Testing and Batch Update
  • Involved Agile Environment Project
  • Knowledge in IBM Cognos BI and QlikView, QlikSense & Basic knowledge in SAP LSMW (Legacy System Migration Workbench) and BDC Batch Data Communication)
  • Team Lead and involved with other groups to resolve database related issues

IT FORTE:

  • DOS, LAN,Unix
  • Windows NT/2003
  • MS SQL Server 2016/2008/2000
  • SSIS,SSRS,SSAS (BI / ETL)
  • Oracle, Sybase, MySQL
  • SAP HANA - BODS/BI 4.0, BO Design Studio 1.6,Lumira
  • Erwin Data Modeler Tool 9.x
  • Power BI,
  • Tableau 9.x
  • IBM InfoSphere DataStage Tool
  • Talend 9.x
  • Sql Compare Tool
  • SQL Lite Speed
  • Eclipse,
  • TOAD
  • ER Studio,Biztools
  • IIS, MTS, Event Control Server
  • Crystal Report
  • Visual Basic,VisualFoxpro
  • Interactive SQL 11.0
  • Event Control Server 5.5
  • PC Anywhere 10.5
  • Install Shield
  • Atomate 5.5
  • Biztools, ER Studio 7.5,
  • Farpoint Spread Control
  • Web Sphere Application Server Ver.5
  • TFS (Team Foundation Server)
  • Visual Paradigm Standard Tool

CORE COMPETENCIES:

  • Team Work
  • Training and Development
  • Decision Making
  • Work Standards
  • Testing - Load
  • Problem Solving Solutioning
  • Database Designing
  • Reporting
  • Migration
  • Upgrading
  • Optimization

DOMAIN:

  • Health Care
  • Insurance
  • Hospitality
  • Confidential Bank - Bahrain
  • Retirement System
  • Textiles
  • Material (ERP) System
  • Maintenance System
  • Material Catalogue
  • Payroll & Finance
  • VISA Processing - Riyadh, Saudi Arabia
  • NBO - Muscat, Oman

WORK EXPERIENCE;

Technical ETL /BI & Testing Consultant

Confidential

Handled Databases : SAP HANA, Oracle, SQL Server

Responsibilities:

  • Created and Designed & Tested Data Mart mapping for Fact and Dimensional tables relationship in Oracle
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
  • Created new Package & Procedure in Oracle for Data Transformation from Source to Target System
  • Managed Database Tables procedures and Indexes
  • Used Remote Server Database Access
  • Discussed with User for Business requirements and Designed Data Mart Mapping in Oracle & Sql Server Databases with SAP Tables

Environment: Windows Server 2012, SAP, SQL Server 2016, Oracle, Oracle SQL Developer Tool, Talend, SAP BO

Technical DWH - ETL/BI & Testing Consultant

Confidential

Applications: Musaned, Ajeer, MOL

Responsibilities:

  • Handled Databases SAP HANA , MySQL, SQL Server - MSBI - SSIS, SSAS with Power BI Visualization Reports
  • Created and Designed, Tested Data Warehouse for which is Fact and Dimensional tables relationship mapping
  • Created / Designed & Tested New ETL multiple packages for Data Transformation from Source to Target DWH System
  • Involved on logical and physical data base modeling with ERWIN tool
  • Important Transaction Data’s Moved through BODS from Sql Server to SAP HANA DB
  • Created new Packages & Procedure in Oracle for Data Transformation from Source to Target System
  • Designed and checked existing Power BI Visualization Reports
  • Managed Database Tables procedures, Indexes for Normalization and Scheduled Jobs
  • Designed ETL flows to extract data from MySQL Database and Stored in MS SQL Server Database - DWH
  • Create Message Queue, Contract and Service Broker used on the Database and also used message Task in SSIS
  • Used VPN Connection for Remote Server Database Access
  • Used TFS for maintaining Version Control of ETL packages

Environment: Windows Server 2012, SAP HANA , MySQL, Oracle, SQL Azure Cloud Server, SQL Server 2016 - SSIS,, SSAS , Power BI, TFS, Talend, Visual Paradigm, Erwin Data Modeler

Technical Lead - ETL /BI/DBA

Confidential

Responsibilities:

  • Handled Database SQL Server, MSBI - SSIS,SSRS, SSAS, Power BI
  • Monitoring Database Mirroring, Disk Space, Scheduled Job, Alert Email and other Production Server Issues
  • Expert in data transformation services like BCP / Bulk Loads / Bulk Insert with SSIS - ETL operations with MSBI - DQS & DQS Data Cleansing
  • Worked on logical and physical data base modeling & Tested with ERWIN tools
  • Used Citrix Server for login Remote Server Access
  • Handling of different Databases and Different Environments across 20 Servers
  • Handled ServiceNow (ITIL) Ticket Tool System (like Incident, Request, Release process)
  • User Access given to Procura application based on confirmation from superior
  • Created/Modified of Power BI Visualizations and SSRS Reports
  • Used ETL- SSIS process for Data Transfer from Server to DB Instances and also handled existing ETL process
  • Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
  • Message Queue Task used in SSIS
  • Developed visualizations and dashboards Reports using Power BI Desktop
  • Based on business requirement Created different kinds of T-SQL Script and given output in the Excel format

Environment: Windows Server 2012, SQL Server 2016 / 2012 - SSIS,SSRS,SSAS , SQL Profiler, Oracle , Power BI, Talend, Procura, Citrix Server, .Net

Confidential

Technical Lead - ETL /BI/DBA

Responsibilities:

  • Handled Databases SQL Server/ Oracle/ SAP HANA
  • Involved Development Activity in ETL /Enterprise Data Warehouse / Data Analysis , Data Modeling,
  • Data Architect and MS Business Intelligence - SSIS,SSRS,SSAS and Power BI
  • Expert on Creating, Build and Deploying for Different type of Packages in SSRS
  • Expert in creating and developing Power BI Dashboards on Custom Visualizations like multi slicer and Hierarchy slicer
  • Developed & Tested Tableau visualizations and dashboards using Tableau Desktop
  • Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations in Power BI
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Developed & Tested Cross Filter Relationship in Power BI
  • Involved Tableau visualizations and dashboards using Tableau Desktop
  • Involved Tableau workbooks from multiple data sources using Data Blending
  • Created scripts to create new tables, views, queries for new enhancement in the application using Oracle - TOAD
  • Configured SAP HANA Database Schema in SQL Server via Linked Server and get the their Objects details
  • Creation of Attribute View , Analytical view and Calculated view and Tested in SAP HANA
  • SAP Lumira - Created & Tested data visualizations and stories from multiple data sources
  • Used DDL/DML commands and Cod e revi e wed and Tested as pe r Insurance standards
  • Involved Testing, Data Quality, Data Profiling, Data Processing and Data Warehouse Monitoring in BODS
  • Involved DB constraints checking and find out which is not have Primary keys and Foreign Keys relation tables
  • Involved Project related Discussion with QA and Development Team

Environment: Windows Server 2008, MS SQL Server 2012 / 2008R2 – SSIS,SSRS,SSAS, SQL Azure Cloud Service, SQL Profiler, Dot Net, SQL Compare Tool, Crystal Report , Oracle, SAP - HANA 1 .0 / BODS 4.0, Power BI, Tableau, Talend

Sr.Software Lead – ETL /BI/DBA

Confidential

Responsibilities:

  • Involved Databases SQL Server, Oracle, MySQL, SAP - HANA with Testing, Data Modeling & MSBI- ETL /Data Warehouse
  • Performed Database Refresh tasks from production to Development and Staging Servers
  • Involved in Testing, Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology
  • Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
  • ETL Create d & Tested for multiple packages mappin g an d script s fo r different Resorts
  • Involved on MSBI Development, Testing and SQL Server Database Objects Import into SAP HANA
  • Integrated Custom Visuals based on business requirements using Power BI desktop
  • Expert in creating and developing & Testing Power BI Dashboard Reports and Cross Filter Direction - Relationship
  • Published reports and dashboards using Power BIs
  • Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week
  • PL/SQL and T-SQL Handling of different Development / Production Databases in Different Environments across 20 Servers
  • Implementation and release of database changes according to agreed timescales and costs

Environment: Windows Server 2008, MS SQL Server 2012 / 2008 – SSRS, SSIS, SSAS, SQL Profiler, ORACLE, MySQL, Toad, SQL Loader, Dot Net. Crystal Report, SQL Compare, SAP- HANA, BODS 4.0, Power BI, Tableau

Senior Technical Lead – ETL /BI/DBA

Confidential

Responsibilities:

  • Databases: MS SQL Server and Oracle , Sybase, SAP HANA
  • DBA and Development Support in MS SQL Server with ETL/DW, Oracle, Sybase, SAP - HANA
  • Effective Change Management of around 500 GB Size Database across Test, Development and Production Environments
  • Handled Oracle SQ L Loader - Movin g dat a fro m external file s into the Oracle Database
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Involved Interface with MS SQL / Oracle Databases
  • Imported data from SQL Server DB and Oracle to Power BI to generate reports
  • Generated computed tables in Power BI by using Dax.
  • Troubleshooting and problem solving of Databases , PL/SQL and T-SQL development issues
  • Migration, Performance Tuning, Analyzing Indexes and Existing / Creation of new T-SQL Store Procedures, Views, Functions , Triggers and Packages
  • Released of Application of DB Script / Package Deployed on Production Databases
  • Written SSIS packages in 2005 and did conversion of DTS packages from 2005 to 2008
  • Utilized T-SQL on a daily basis in creating customs view for data and business analysis
  • Created parameterized reports, Drill down and Drill through reports using SSRS
  • Resolved complex issues and Error Handling in SSIS
  • Handled on MSBI Development and Data Export from M S SQL Server Databases into SAP-HANA Database
  • Creation of Attribute View , Analytical view and Calculated view in SAP HANA
  • Created Schedule job in SAP HANA
  • Handled ETL / SSIS multiple packages mapping, scripts and Data process & Transferred to Report Server
  • SQL Loader - Moving data from external files into the Oracle Database
  • Single point of contact with team and onsite client coordinator

Environment: Windows Server 2003, UNIX, Java, MS SQL Server 2008 / 2005 – SSIS,SSRS,SSAS, Sybase, Oracle, SQL Loader, Toad, Eclipse, SQL Litespeed, Crystal Report , SAP – HANA

Senior Engineer – DBA / ETL

Confidential

Responsibilities:

  • Involved Databases SQL Server/Oracle
  • Planning and Maintaining Database Backups using Scheduled Jobs, Alerts and SQL Mail.
  • Change Management across different Test, Development and Production Databases
  • Creating of Login and restricting the permissions to them
  • Handling of more than 30 tickets daily basis of development and QA team request on different Databases and different environments across 1500 SQL Servers Instances
  • Production Server - Monitoring Jobs & Scheduled Task
  • DTS/SSIS packages Tool to Import/Export the data Text/Excel file and Server to Server
  • Created complex stored procedures, Triggers and user defined functions using joins and cursors
  • Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional/ Dimensional Databases
  • Analyze user requirements, functional and technical specifications, preparing test plans.
  • Execution of batch file Build & Deployment and hosting of Web Application Servers
  • Execution of Oracle Trigger through FTP
  • Involved Migration, Performance Tuning, Analyzing Indexes, Store Procedures, Views and User defined Functions
  • Code review as per Client standards

Environment: Windows 2003, Unix, IBM WSAD5.0, Sql Server 2000 / 2005 - SSIS, Oracle, Toad, ECS (Event Controller Server) for Batch operations, PCAnywhere, PVCS Merant Tracker for Bug tracking, Perforce - Version Control Tool, WebSphere Application Server Ver. 5, Biztools, ER Studio 7.5, Atomate 5.5

Hire Now