Email: ad0wlg@r.postjobfree.com

Phone: 805-***-****

PROFESSIONAL SUMMARY:

●Around 4 years of Strong experience as a Data Engineer & Business Intelligence Developer

●Having work experience on designing and developing database applications with a expertise background in Database Architecture, Design, Development and Administration

●Expertise on ETL process, Reporting and Tabular data modelling using SQL Server 2017/2016/2014/2012, SSIS, SSRS, SSAS, Power BI and Tableau

●Worked on Data cleansing and Data Harmonization. Developed Hive scripts DDL and DMLs of the entire flow.

●Experience in Power BI, Data Warehousing and Business Intelligence applications design, development, Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Azure (Azure Synapse, Data Lake, Data Factory)

●Experience on Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardising data loaded into OLTP and OLAP databases using SSIS.

●Extensive experience in working with T-SQL queries (DDL and DML) and writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.

●Experienced in creating and using CTE, Cursors, Functions, Triggers, and complex Stored Procedures.

●Migrating the end to end environment includes Windows server, SQL databases and applications hosted on that database from on premise to cloud (AWS, Azure cloud) and Cloud to on premise.

●Involved in the designing and creating Migration plan with High level documentation with clients and project team.

●Collaborating with the end clients on planning and execution of the Migrations for their applications/Databases along with down time.

●Analysed the sensitive data and applied encryption algorithms to protect the user privacy which includes differential privacy and design the privacy data

●Worked on providing row level securities using power bi and dynamic row level security with SSAS Tabular model to restrict data access for various users.

●Created reports using visualisations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.

● Experience in Tableau visualisations and dashboards using Tableau Desktop.

● Created complex measures, calculated columns, calculated tables using Data Analysis Expressions (DAX)

●Experience in Tabular Modelling, DAX, and Worked on Data modelling, creating star schemas in SSAS.

●Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.

● Extensive experience performing various SSIS data transformation tasks like Lookups, Fuzzy Lookups, Conditional Splits and Event Handlers, Error Handlers etc.

●Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

●Experience in developing Custom Reports and different types of reports like Tabular Reports, Matrix Reports, Ad hoc reports, Drill Down, Drill Through and distributed reports using SQL Server Reporting Services (SSRS).

●Hands on experience in Tabular Modelling, Multi-Dimensional Cubes, DAX and MDX (SSAS) and Worked on Data modelling, creating star schemas in SSAS.

● Version control of migration scripts and database scripts in a Git repository using source tree and Bitbucket

● Strong analytical and problem-solving skills coupled with excellent documentation, PowerPoint, MS Office, verbal and inter- personnel communication skills, good team player and ability to acquaint to fast changing skills.

TECHNICAL SKILLS:

Database Tools

SQL SSMS, SSRS, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS, Oracle DB, MySQL workbench, Mongo DB, SQL Server Business Intelligence Development Studio.

Database

SQL Server, My SQL, Oracle

Reporting Tools/OLAP

SSRS, Power BI, Tableau, Report Studio, Report builder, Excel

Cloud

AWS, Azure.

ETL

Informatica, Data-Stage, Informatica Metadata Manager, SQL SSAS, SSIS, Data Transformation Service (DTS).

Languages

SQL, PL/SQL, T-SQL, Shell scripting

Version control

Bitbucket

Ticketing Tool

JIRA

PROFESSIONAL EXPERIENCE:

Role: SQL Server DBA, Oct 2021 – Present

Client: BMO

Responsibilities:

●Worked on writing SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, User Defined Functions, and constraints to implement the database consistency and integrity as per business functionalities.

●Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.

●Implemented Proof of concepts for APIs

●Worked on automating patching on SQL Servers using python and Jenkin jobs

●Experienced in building AOA 3 node cluster and HADR

●REST APIs to retrieve analytics data from different data feeds.

●Implemented maintenance jobs for Index management and database consistency checks using olla Halen scripts

●Collaborate with data architect / engineers to establish data governance / cataloguing for MDM/ security (key vault, network security schema level row level), resource groups, integration runtime setting, integration patterns, aggregated functions for data bricks development.

●Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

●Migrated on-premise SQL Server on azure sql vm’s and MI instance and Azure sql db’s

●Experienced in access provisioning and maintaining compliance on sql serves

●Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analysing transforming the data to uncover insights into the customer usage patterns.

●Expertise in Creating, Debugging, Scheduling and Monitoring jobs using Airflow and Oozie.

●Created data bricks notebooks using Python (PySpark), Scala and Spark SQL for transforming the data that is stored in Azure Data Lake stored Gen2 from Raw to Stage and Curated zones.

●Created and Designed SSIS packages to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services and Implemented error logging and Event Handlers on SSIS packages for troubleshooting.

●Automate the existing ETL process using C# Script to process file landing and population of the tables and continual data exchanges.

●Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad- hoc reports, drill down reports and interactive reports using SSRS as per business requirements.

●Installed On premise data gateway and scheduled daily data refresh in Power BI.

●Created many calculated columns and measures using DAX in Power BI based on report requirements.

● Involved in development of Incremental Load processes using SSIS Packages and various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.

●Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.

●Developed Key Performance Indicators (KPIs) for generating reports.

●Created reports using SSRS (Reporting services) on request of end users and created subscriptions to deliver the reports to users by email.

Environment: SQL Server 2019/2017/2016/2014, SSIS, SSRS SSAS, Visual Studio 2019/2015, C#, R, AZURE SQL, ADF (AZURE Data Factory), RStudio, Power BI (Desktop, Services, Report Server, Premium), Team foundation server 2015, SharePoint Online, ESRI ArcGIS, DAX

Role: Data consultant May 2018– April 2019

Client: CGI Information & Technologies

Responsibilities:

●As a member of BI/Database team, involved in Requirement gathering, Technical Design, Testing and implementation of BI Analytics needs.

●Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.

●Experienced in strategically implementing the indexes such as Clustered index, non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.

●Experience in Troubleshooting, Performance tuning of reports and resolving issues within Power BI Server.

● Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support and have experience in Incremental data loading.

●Involved in development of Incremental Load processes using SSIS Packages and various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.

●Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.

●Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.

●Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.

●Created SSAS Cubes (Tabular Models) as the source for Power BI and created various dashboards and visualisations and published it to POWER BI REPORT SERVER.

●Worked on providing row level securities using power bi and dynamic row level security with SSAS Tabular model to restrict data access for various users.

●Migrate existing data into the Power BI and create reports in Power BI preview portal utilising the SSAS Tabular

●Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed On premise data gateway and scheduled daily data refresh in Power BI.

●Developed the Database/Flat file/JSON/XML profiles, Mappings, Processes using with different connecters/shapes and logic shapes between the application profiles and different Trading partners using Dell Boomi.

●Worked on creating Azure Data Factory and Snowflake for moving and transforming the data.

●Involved on call production support 24/7 for Production Jobs.

●Involved as a Lead for UAT team for bug fixes and production issues.

●Involved in transforming data from dev into Stage & Prod environments.

●Participated in Sprint meetings and updating status on reports in Agile Environment.

Environment: SQL Server 2014/2012, SSIS, SSRS, SSAS, Visual Studio 2015, ASP.NET, Power BI, Team foundation server 2013

Role: Data Analyst, Database Developer Jan 2017 – May 2018

Client: Bajaj Allianz

Responsibilities:

●Actively participated in interaction with DBA’s and technical manager to design data warehouse and ETL process.

● Develop SSIS package or MS Stored Procedure for ETL Process.

●Developing SQL queries for custom reports in different databases MySQL or MS SQL Server.

●Optimising and tuning database data warehouse performance using indexes or by modifying complex queries.

●Create Job to run SSIS packages and ETL stored Procedure or custom reports daily, weekly, or monthly.

●Develop and customise CMSs (Joomla) to generate web sites for the clients.

●Designed SQL SSIS Packages to extract data from various data sources such as MySQL, Oracle, Access database, Excel spreadsheet, into SQL Server 2008/2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Environment: MS SQL Server 2008/2012/2014, MySQL, JavaScript, HTML and CSS

Environments: MS SQL Server 2008, SSIS, SSRS, MS Visual Studio 2008, Microsoft Vision.

EDUCATION:

Master’s in business management and logistics St. Clair college, Windsor, ON.

Bachelor of commerce Osmania university, Hyderabad, India.

Contact this candidate