SUMMARY

• 8+ years of experience as a Business Intelligence Developer/Data Engineer wif expertise in Microsoft BI Technologies and tools wif rigorous experience implementing solutions for various business situations
• I has worked and implemented BI solutions for various business domains including Healthcare and Banking as a Business Intelligence Developer
• Worked in both ad - hoc and structured software development environment and followed procedures and processes per software development life cycle (SDLC) in both Agile and Waterfall methodologies
• Experienced migrating SQL Database to Azure Data Lake, Azure SQL Database, Azure Data Bricks and Azure Synapse Analytics
• Experienced in developing and designing Dashboards using Power BI
• Created SSIS ETL packages to extract data from different source systems and loaded variety of large volume data into data warehouse
• Experienced in implementing optimized package control flow by using Event Handlers notification triggers using control flow task such as Send Mail Task and Logging of package information at runtime
• Extensive experience in deploying SSIS Packages from development server along wif configuration files to QA server and Production server using SSIS project deployment model
• Experienced in implementing debugging techniques to resolve SSIS package issues
• Experienced in implementing advanced features creating complex reports using Power BI by extracting data from OLTP systems and OLAP data sources and publishing processed reports on teh Power BI service.
• Experienced in developing, implementing and supporting Business applications and Database applications using various versions of MS SQL Server and tools
• Experienced in developing database objects using T-SQL
• Experienced in creating and improving TSQL queries for performance tuning and query optimization
• Experienced implementing data warehouse concepts and developing multidimensional cubes using SQL Server Analytical Services (SSAS)
• Developed web pages and integrated data from a web-based interface to back-end databases.

TECHNICAL SKILLS

• Azure Data Lake
• Azure Data Factory
• Azure Databricks
• Azure SQL Database
• Azure Synapse Analytics
• Data Visualization
• Data Migration
• SQL Server 2012
• SQL Server 2008/2012 Integration Services
• SQL Server 2012 Reporting Services
• SQL Server 2012 Analysis Services
• Microsoft Word
• PowerPoint
• Excel
• Power Query
• Java
• Machine Learning
• Python
• C#
• Hadoop
• PL/SQL
• Aqua Data Studio
• SQL Server Management Studio
• SQL Server Data Studio
• Power Pivot
• DAX Formula
• Tableau
• HTML
• XML
• CSS
• Power BI
• Oracle
• SQL
• T-SQL

PROFESSIONAL EXPERIENCE

Confidential

AZURE DATA ENGINEER/BUSINESS INTELLIGENCE DATA WAREHOUSE DEVELOPER MANAGER

Responsibilities:

• Created and developed data models
• Created star schema data models, performed ETLs and validated results based on business requirements
• Prepared and implemented plans for all Extract Transform and Load (ETL) procedures and architectures
• Experienced performing ETL process from source systems to Azure Data Storage using combination of Azure Data Factory, Spark SQL, Azure Databricks, Azure Synapse Analytics
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline to Extract, Transform and Load data form different sources
• Validated results and created business reports using Power BI reporting services
• Monitored and tuned data loads and queries
• Administered all requirements and designed various functional specifications for data
• Monitored data warehouse work and provided subject matter expertise
• Supported and implemented BI solutions by monitoring and tuning queries, performing data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
• Collaborated wif business and technology stakeholders in ensuring data warehouse architecture development and utilization
• Facilitated requirements gathering using expert listening skills and develop unique simple solutions to meet teh immediate and long-term needs of business customer
• Supported teh development and validation required through teh lifecycle of teh DWH and Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouse
• Developed SSIS packages to extract data from various sources including SQL Server, Excel, Flat file, CSV, transformed teh data and loaded into teh target FTP server
• Configured packages and deployed SSIS packages along wif configuration files to make it dynamic to execute it into various environments

Confidential

SQL BI DEVELOPER

Responsibilities:

• Represent all information in database as tables
• Developed SSIS packages to extract data from various sources including SQL Server, Excel, Flat file, CSV, transformed teh data and loaded into teh target data warehouse
• Implemented SSIS transformations such as Lookup, Multicast, Derived Column, Conditional Split, Data Conversion
• Configured packages and deployed SSIS packages along wif configuration files to make it dynamic to execute it into various environments
• Implemented package control using Event Handlers, Breakpoints, Check points, and loggings for debugging
• Keep logical representation of data independent from its physical storage characteristics
• Use one high-level language for structuring, querying, and changing info in teh database
• Support teh main relational operations
• Support alternate ways of looking at data in tables
• Provide a method for differentiating between unknown values and nulls (zero or blank)
• Support Mechanisms for integrity, authorization, transactions, and recovery

Confidential, DANVERS MA

SQLMSBI DEVELOPER(SSIS/SSRS)

Responsibilities:

• Reviewed Business Requirement Document (BRD) and confirmed specifications wif Business Analysts and other team members as appropriate
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding teh functional workflow of information from source systems to destination systems
• Integrated data from various source systems using SQL Server Integration Services (SSIS) and performed ETL related operations
• Worked wif different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments
• Scheduled SSIS jobs using SQL server agent for daily, weekly and monthly loads
• Developed and designed Dashboards using Power BI
• Deployed different SSIS packages along wif configuration files on QA and Production servers using Project Deployment Model
• Developed various types of reports like Drill down, Drill through and parameterized reports
• Performed configuration and deployment of various reports using SQL Server Reporting Services (SSRS) on teh report server
• Extensive knowledge using DDL and DML for writing triggers, functions, stored procedures, views, indexes
• Optimized teh T-SQL query performance wif modifications in TSQL queries, removing unnecessary columns and establishing necessary joins

Confidential

SQLMSBI DEVELOPER(SSIS/SSRS)

Responsibilities:

• Involved in extracting data from OLTP Systems to OLAP Data warehouse using SSIS
• Migrated packages from SQL using SSIS designer
• Developed and deployed SSIS packages and upgraded DTS packages to SSIS. Also modified teh existing SSIS Packages
• Used proper Control flow and Data Flow Items for designing ETL Packages
• Used various transformations such as Derived Colum, Lookup, Conditional Split and Multicast while implementing teh business logics and loading teh data to destination using SSIS
• Transferred data from various heterogenous sources like MS Excel, SQL Server using SSIS
• Created Linked reports, Ad-hoc reports (using Report Builder) based on teh requirement
• Created/ Modified SSRS based reports based on T-SQL and Stored Procedure wif Input parameters
• Implemented data analysis by designing SSAS cubes for business intelligence applications
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Created stored procedures and functions to support efficient data storage and manipulation
• Created check constraints to maintain data integrity

Confidential 

SQL DEVELOPER(SQL)

Responsibilities:

• Provide database administration and development (functions, procedures, triggers, views, indexes) on Oracle and SQL database servers
• Responsible for software development activities as assigned by Project Manager
• Responsible for daily maintenance and debug of teh client databases and data sources
• Software development activities and daily maintenance to debug databases and data sources
• Interacted wif users for requirements development and refinement as well as demonstration of database and software features
• Assisted in daily administration activities including monitoring, support, and maintenance of SQL databases
• Import and export data in various formats
• Assisted application and web developers wif application troubleshooting and tuning SQL performance