We provide IT Staff Augmentation Services!

Senior Azure/ Bi Engineer Resume

4.00/5 (Submit Your Rating)

Redmond, WA

SUMMARY

  • Over 8 Years of experience on Client - Server & Business Intelligence applications using Data warehousing, Data modeling, Data integration, Data Migration, ETL process, Business Intelligence, Analytical Reporting and Dashboardscomponents.
  • Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, SSRS) applications.
  • Hands - on experience in Azure Cloud Services (PaaS & IaaS) and components likeAzure Synapse Analytics,Azure Data Factory, Azure Monitoring, Key Vault, Azure Data Lake, Cosmos DB.
  • Experienced in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
  • Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using teh latest features to optimize performance (Merge, Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
  • Extensive experience in developing UNIX Shell scripts for automating batch programs.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
  • Sound noledge on SQL Server and Database Monitoring & Tuning for better performance using different tools like Database Tuning Advisor, Performance Monitor, SQL Profiler.
  • Good noledge of Data Marts, Data warehousing, OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake, FACT and Dimensions Tables.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML).
  • Good understanding and hands-on experience wif Analysis Services (SSAS).
  • Experience in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
  • Hands on working noledge wif various AWS services like EC2, S3, VPC,DynamoDB.
  • Experienced in working wifSQL Query Analyzer,SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs wifSQL Server Agent,SQL Server Storage Structures, Index and Security ArchitectureandSQL Profiler.
  • Proficient in writing complex MDX and DAX expressions and queries
  • Very Good Experience in building Analytical dashboards using Excel, SSRS, Power BI, Qlik Sense, Tableau.
  • Good Experience in embedding PowerBI reports, dashboards, visuals into an application and applying row level security to datasets.
  • Experience wif Big data Architecture using Hadoop, Hive, Spark, Sqoop to store data in a data lake approach for ELT/ETL.
  • Good understanding of SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
  • Experienced working in full-cycle project implementations and all aspects ofSDLCviz., Requirement Analysis, Design, Development, Testing and Maintenance in Agile environment.
  • Proficient in analyzing business requirements and preparing relevant technical project documentation.
  • Experience inUnit Testing, System Testing and User Acceptance Testing and creating test cases.
  • Target oriented individual wif Excellent Communication and Interpersonal skills.
  • Good team player, quick learner, self-motivated and possesses teh ability to work independently.

TECHNICAL SKILLS

Operating System: Unix, Linux, Win XP/2000/VISTA, Win NT/5.0/4.0, Win 9x

Languages: SQL, TSQL, PLSQL, Python, Core Java,R, C#, .NET

Database: MS SQL Server 2008/2012/2014/2016/2019 , Oracle 11g/10g/9x/8x, PostgreSQL

Database Tools: Confidential SSMS, SSRS, SSIS, SSAS multidimensional, SSAS tabular, Informatica ETL, Power BI, DTS

Big Data Tools: Hive, Hadoop, Spark, Sqoop, Kafka, Hue

Reporting Tools: SSRS, Power BI, Qlik Sense, Tableau

Data Modeling Tools: Confidential Visio 2000/20003

IDEs: Confidential Visual Studios, VS code, Eclipse

Version Control: SVN, CVS, TFS, Azure DevOps, Git, Clear Case, Share Point

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Senior Azure/ BI Engineer

Responsibilities:

  • As part of Data Platform team, was responsible for developing and optimizing standard data operations related to Office 365 and other Confidential services.
  • Created and Modified SQL Server stored procedures, views, ad-hoc queries for handling business logic.
  • Involved in migrating existing SSRS reports to PBI for Partner business teams, to provide visible data for reporting.
  • Actively worked on auditing and back tacking existing data flow related to FastTrack Services in production databases to make teh flow more dynamic.
  • Identified unused objects in production databases and moved them to back up schema before deleting them, which halped mitigate space constraint.
  • Worked on POC and implementationof a new process related new Office 365 sub metrics, to automate data loading process in a database, wif teh halp of metadata table.
  • Monitored, produced and consumed various datasets of Azure Data Factory for various transformational activities.
  • Created Triggers, linked services and Integration runtimes related to ADF pipelines.
  • Interactively analyzed logs using Kusto in Log Analytics workspace.
  • Performed optimization analysis and created a process to identify teh unused objects from various databases. This job runs daily to capture updated metrics of teh objects and teh results aredisplayed using a PBI dashboard.
  • Created staging objects required to load FY21 Office Metrics.

Environment: T-SQL, Azure Data Factory, Cosmos DB, Azure SQL, Azure Synapse Analytics, Blob Storage, Azure Data Lake, PolyBase, Log Analytics, Visual Studio, SSMS, TFS, Power BI, SSRS.

Confidential, Phoenix, AZ

SQL/BI Developer

Responsibilities:

  • Involved in collecting requirements, transforming them into logical and physical database designs.
  • Design, Implement and maintain Database Schema, Entity Relationship Diagrams, Data modeling, Tables, Stored procedures, Functions, Triggers, Constraints, Indexes, Functions, Views and complex SQL statements.
  • Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
  • Designed Table, matrix, sub reports and linked reports by using SQL server reporting services (SSRS) and deployed in production server.
  • Generated reports from teh cubes by connecting to Analysis server from SSRS.
  • Createdad-hocreports in QlikView and supported teh users wif teh adhoc reporting queries
  • Gatheird functional requirements & developedQlikViewdashboards.
  • Analyzed data & definedKPIs; created tasks and set dependencies using QlikViewPublisher.
  • Works wif data modelers to prepare logical and physical data models, adds and deletes necessary fields using Erwin.
  • Created packages dat transfers databases from one SQL Server instance to another instance and scheduled teh SSIS package for migration of data from old system to MS SQL 2016.
  • Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Automated and enhanced daily administrative tasks, including space management, backup and Recovery and performance monitoring.
  • Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
  • Performed ETL operations to support teh data loads and transformations using SSIS and used SSRS for generating reports to end-users.
  • Assisting Analytics team wif various Data Modeling tasks
  • Developed Database Triggers to enforce Data integrity.
  • Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
  • Worked on all teh new updated features Conditional formatting, multi-select data points across multiple pages in Power BI.
  • Developed custom calculated measures using DAX in Power BI to satisfy business needs.

Environment: SQL Server 2016, Power BI, Excel, Power Pivot, T-SQL, SSIS, SSAS, SSRS, Visual Studio,Data lake, Data Factory, Git, Azure Devops, Big Query, Power BI, Linux, Oracle 10g/11g, SSIS, SSRS, SSAS, MDX, Tableau, MTM, TOAD, BIDS, Data tools, MDS.

Confidential, Chicago

T-SQL/MSBI Developer

Responsibilities:

  • Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
  • Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Worked wif SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations
  • Worked wif various SSIS packages which involve Transactions, restart ability and roll back techniques.
  • Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into teh oracle database.
  • Excellent report creation skills using Confidential SQL Server 2016/2012 Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder and MS SharePoint.
  • Created calculated fields and Key Performance Indicators (KPIs), perspectives and partitions wif existing SSAS cube objects for better analysis.
  • Implemented report manager to set up roles, security, and subscripts (data driven/standard) on teh existing SSRS reports.
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard utilizing PowerBI.
  • Created Power BI Report which involves Schema Import, Implementing teh business logic by customization.
  • Developed Complex Stored Procedures, Views and Temporary Tables as per teh requirement.
  • Created complex reports which involve a greater number of groupings and multi-value parameters.
  • Experience in understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Created multiple reports wif drop down menu option having complex groupings wifin teh report.

Environment: MS SQL Server- 2016/2012/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, SQL Profile, Power BI, Erwin, OLAP, OLTP, Erwin, C#.NET, MS SharePoint, Visual Studio.

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

  • Worked wif Technical Architects and Database analysts for teh Design of Summary tables required for efficient Report Design.
  • Designed teh functional and technical documents, report templates and reporting standards for teh developers to work on teh report development.
  • Created cubes and dimensions and measures and calculated measures according to teh business requirements.
  • Developed teh SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to teh database.
  • Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
  • Developed various reports using SSRS, which included writing complex stored procedures for datasets.
  • Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for several types of reports.
  • Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing teh cube for analysis and validation of teh data. Processing teh cubes and dimensions daily using teh SSIS tasks
  • Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
  • Extracting teh data from teh various sources (CSV files, oracle, and MS SQL 2000) and stored teh data into teh intermediate Staging Database using teh SSIS ETL tool.
  • Scheduled teh Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
  • Prepared teh reports for teh day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2014/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), MS SharePoint, T SQL, Erwin, TFS, Oracle 10g, MS Excel.

Confidential, Philadelphia, PA

SQL Developer (SSAS SSIS SSRS)

Responsibilities:

  • Analyzing and Establishing security features in SQL Server Reporting 2012 Environment.
  • Worked on full life cycle development (SDLC) involving in all stages of development.
  • Involved in system study, analyze teh requirements by meeting teh client and designing teh complete system.
  • Involved in designing technical specifications for building Data Warehouse.
  • Involved in project cycle plan for teh data warehouse, analyzing teh source data, deciding teh exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
  • Developing reports using SQL Server Reporting Services in SSRS 2012. Creating various value sections in Parameter’s list, designing cascading parameters, matrix dynamics, and more features in Reporting Service.
  • Used advanced features ofT-SQLto design and tune T-SQL to interface wif teh Database and other applications in teh most efficient manner and createdstored Proceduresfor teh business logic using T-SQL.
  • Worked on SQL Profiler, Tuning Advisor in SQL 2012 to increase teh performance of teh reports.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule teh same as jobs using SQL, Server Agent.
  • Worked wif report subscriptions and snapshots in SSRS 2012 to send teh weekly run automated reports to end-users.
  • Develop complex MDX, Created Database Objects - Schemas, Tables, Indexes, Views, User-defined functions, Cursors, Triggers, Stored Procedure, Constraints, and Roles.
  • Designed and developed OLAP using MS SQL ServerAnalysis.
  • Use DAX (Data Analysis Expressions) functions for teh creation of calculations and measures in teh Tabular Models.
  • Scheduling daily, weekly, monthly Reports in crystal Enterprise to run at a particular time. Creating users, groups and giving them required permission.
  • Scheduling of someReportsbased on event server.
  • DistributingReportsby e-mail, FTP, or via web access.
  • Designed Web-basedCrystal Reportsuser interface, Security System Interface, Parameterized Reporting.
  • Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
  • Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
  • Created Grouping, sorting columns, and writing expressions per teh business requirements.
  • Extensively worked wif SSIS tool suite, designed, and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast, and Lookup.
  • Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in teh SSIS packages and SQL scripts.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Developed tabular queries for efficient analysis of reports using Pivot/Unpivot in T-SQL.
  • Involved in developing Data Access Components to access teh SQL Server Database using ADO.NET.
  • Created Crosstab, Drill-down, Drill-through, and Sub drill-down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including status.
  • Used Reporting Services (SSRS) to schedule reports being generated at a predetermined time.
  • Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL Server Reporting Services (SSRS) 2012
  • Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
  • Created Data Warehouse Cubes inSQL Server Analysis Service (SSAS).
  • Implemented cell-level security in cubes using MDX expressions to restrict users of one region from seeing data of another region using SSAS.
  • Involved inTabular Data warehouseandDAXoperations for SSAS 2012 and 2008 OLAP databases.
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: SQL Server Integration Services 2012/2008 (SSIS),SQL Server Reporting Services (SSRS),SQL Server Analysis Services(SSAS), SQL Server Management Studio 2012,MS Visual Studio 2012, TFS, GIT, SVN, Rally, and Windows 2012 Server.

Confidential

SQL Developer

Responsibilities:

  • Developed User Defined Functions for giving Scores and views for teh application.
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
  • Performed Full load & Incremental load wif several Dataflow tasks and Control Flow Tasks using SSIS.
  • Wrote various Stored Procedures for application development.
  • Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
  • Worked on replication of data (Transactional method used)
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
  • Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder
  • Formatted teh reports using teh Global variables and expressions.
  • Performed job scheduling and alerts.
  • Designed and implemented user log in and security.
  • Resolved any deadlocks issues wif teh databases/servers on a real-time basis.

Environment: SQL Server 2008 R2, SSIS, SSRS, Management Studio, DTS, MS Excel, T-SQL, Power Point

We'd love your feedback!