NARENDRA PATEL

adhrb7@r.postjobfree.com, 647-***-****

HIGHLIGHTS OF QUALIFICATION

8+ years of IT experience in the field of Data Modeling/ETL/Database Developer/Data Analyst with big relational database like Oracle(PL/SQL) and MS SQL Server(T-SQL).

Experience with ADF (Azure Data Factory) for migrating on-premise databases to Azure SQL Database, on-premise databases to Azure Blob storage, Azure Blob storage to Azure SQL Database, Azure Blob storage to Azure Data Lake.

Highly proficient with writing Triggers, Views, Functions, Cursors, Complex SQL Queries (Subqueries, Co-related Subqueries), Joins (Inner, Left, Right, Cross), Stored Procedures, Windows analytical functions using T-SQL (MS SQL Server) and PL/SQL (ORACLE).

Created clustered and non-clustered Indexes for efficient data manipulation using T-SQL (MS SQL Server).

Having a good Experience in Designing and Developing the SQL Server Integration Services-SSIS Packages with different Control Flow Tasks and Data Flow Transformations, and Deploying the Packages.

Created ETL packages using Lookup, Union All, merge, Derived column, Data conversion, Conditional split and Aggregate etc. using SQL Server Integration Services (SSIS).

Strong experience of Data warehousing, Tabular Modeling and Multidimensional Modeling: Star Schema, Snow Flake Schema, and Data Cube with SQL Server Analysis Services(SSAS)

Generated ETL Packages tasks periodically using SQL Server Agent jobs.

Developed Tabular, Drill Down, Drill Through and Matrix reports and deployed them on server using SQL Server Reporting Services (SSRS).

Developed, and Published Visualization and Dashboards using Microsoft Power BI and Tableau.

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

Developed U-SQL scripts for processing data from Azure Data Lakes (ADLS) in Azure Data Lake Analytics.

Worked with different SDLC Methodologies, like Waterfall and Agile.

Good Analytical and logical thinking skills.

Ability to work independently with team on multiple projects with aggressive deadlines.

Always eager to learn new technology, deep thinker with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure Analysis Service(AAS), Azure Blob Storage.

Database: Oracle, MS SQL Server, MySQL, MS-Access

Languages: C, C++, Java, C#, Python, SQL and PL/SQL, DAX

GUI/Tools: UML, Microsoft Visio, Rational Rose, Microsoft Office

BI and Analytical Tools: SSIS, SSAS, SSRS, Cognos, Tableau, PowerBI(DAX)

Operating System: Windows 7, Windows 10, Linux/Unix

Office Applications: Microsoft Office Suite (Word, PowerPoint, Outlook, Access, Excel (V-lookup, Power Pivot, Macros), SharePoint.

EXPERIENCE

Sophic Technology Services Inc., Canada March 2020-Present

BI Developer/ADF Developer

Converted existing SSIS packages to Azure using Azure Data Factory.

Migrated data from traditional database systems to Azure SQL databases.

Extract, Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL, Azure Data Lake Analytics, Data Ingestion to one or more Azure Services:(Azure Data Lake, Azure Storage, Azure SQL, Azure Synapse Analytics)

Created Pipelines in ADF using Linked Services/Datasets/Dataflow/Activities to Extract, Transform and load data from different sources like Azure SQL Database, Blob storage, Azure Synapse Analytics.

Developed and published Dashboards reports using PowerBi.

Work within and across Agile teams to design, implement, test and support technical solutions.

Softchoice, Canada Feb 2020-Mar 2020

ETL Developer/BI Developer

Developed and maintained ETL process using PL/SQL from multiple source systems such as Oracle, SalesForce, SAP and Excel to the staging area.

Created various PL/SQL stored procedures, functions, packages for data extraction, asserting extraction issues, performing cleaning and transformation of data from source systems to SAP platform design.

Created ETL Packages using SSIS.

Worked on existing functionality of Purchase-to-Payment (PTP).

Attended semi-weekly scrum meetings to update team members.

Created and worked on JIRA tickets for Task/Bugs.

Worked on Agile methodology.

Ombura Ltd, Canada May 2019-Jan 2020

SQL Server Developer/ETL Developer

Created Database Diagrams using Microsoft SQL Server Management studio.

Created Primary key and foreign key constraints using T-SQL and SSMS.

Created and updated complex T-SQL code; use inner joins, outer joins, correlated query, subqueries and dynamic SQL.

Used windows analytical functions to calculated complex formulas using T-SQL.

Identify any issues in large dataset related to database performance and provide corrective measures.

Created ETL packages for data loading and data transformation using SSIS and T-SQL.

Assisting for scheduling ETL packages.

Estimated performance to execute stored procedures in C# and Python.

Developed Test case and analyze results.

Attended scrum meeting with scrum team(s) every day.

Printf Technologies, USA Jan 2016- Apr 2019

Database Developer/BI Developer

Involved in software development life cycle activities- from gathering user requirements to implementation.

Wrote advanced T-SQL/PL/SQL statements, stored procedures, functions, triggers, indexes and views.

Responsible for optimizing SQL queries, stored procedures to improve the performance.

Wrote SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Responsible to analyze, design, develop, test and document ETL programs.

Develops and maintains conceptual, physical and logical data models for Relational Database(OLTP) and Data Warehouse(OLAP) based on Star Schema - Facts and Dimensions.

Developed and applied Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.

Pulling data weekly from OLTP database to OLAP using the SSIS packages.

Used SSIS to create, schedule, monitor packages and send emails to communicate success or failure of session execution.

Implementation of incremental load to all dimensions and facts by taking care of performance tuning.

Using SSAS, developed cube for analytical analysis consisting of facts and dimensions.

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).

Used SQL Server Profiler, to trace the slow running queries and the server activity.

Created Power BI Visualizations and Dashboards as per the requirements.

Attended semi-weekly scrum meetings to update team members.

Worked on Agile methodology.

Buzzyfy Technologies, India Apr 2010- Dec 2015

Database Developer/BI Developer (SSIS, SSAS, SSRS)

Performed system analysis and design activities.

Created and managed structured objects like tables, views, stored procedures, views and triggers all while maintaining referential integrity.

Designed and configured SSIS packages to important data from OLTP (MS SQL Server) System to Data warehouse system.

Performed incremental load on daily basis by using timestamp-based Delta load.

Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages

Validated and tested all packages on development server.

Coding, troubleshooting and performance tuning SQL and complicated SSIS packages.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Designed and deployed reports with Drill Down, Drill Through and Matrix using SSRS.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Created dashboard reports using Power BI Desktop for stakeholders.

Determined test requirements and developed customized test plans.

Trained new users and existing users on application features, best practices, etc.

EDUCATION

Masters of Computer Application (MCA)

Canadian Equivalency: Master's degree

Bachelor of Science (Mathematics)

Canadian Equivalency: Bachelor's degree (Three years)

CERTIFICATION

Microsoft Certified: Azure Data Fundamentals

Contact this candidate