We provide IT Staff Augmentation Services!

Senior Msbi Azure Cloud Solution Engineer/architect Resume

5.00/5 (Submit Your Rating)

OBJECTIVE:

Seeking MSBI Azure Cloud Solution Engineer/Architect position for a progressive company open for relocation; Desire to build client satisfaction using both emerging technologies and proven methods in innovative ways

SUMMARY:

  • More than 10 years of experience in IT
  • Strong Azure MSBI Architect/Develop Experience (ADL, Manage Instance, Azure SQL Server, Azure DW, Integration Runtime, Azure Analysis Service etc)
  • Expert in transforming Data - > Information -> Knowledge - > Business Decisions
  • Strong desire in learning new technologies and methodologies
  • Proficient with Talend and Informatica
  • Proficient with MS BI stack including Analysis Services, Integration Services, Reporting Services
  • Strong Hadoop Ecosystem Architect experience (HDP, CDH(Cloudera))
  • 10 years’ development experience across all phases of the SDLC (systems development life cycle) from project initiation to post-implementation
  • Extensive data warehouse and OLAP/Cube, Tabular Model/Cube design experience using Kimball Method Best Practices.
  • Extensive Dashboard design using Power BI and Tableau
  • Exceptional problem solving and team skills

SKILLS & LANGUAGES:

ETL Tools: Microsoft Integration Service(SSIS), Talend(6.1.1), Informatica, Data Factory

Reporting Tools: SSRS,Power BI,Tableau, Congos, Crystal Report, Business Object Strong Hadoop Architect and Developing experience with HDP(Hortonworks) and CDH(Cloudera), Experience in HDFS, ZooKeeper, Ambari, Hive, Pig, Map Reduce, Spark, Flume, Sqoop, HBASE, Experience in ELK (Elastic Search, Logstash, Kibana), Solr, Splunk

Other Business Intelligence Tools: SQL Server Analysis Services (Both Multidimensional Model and Tabular Model) 2016, 2008 R2, Reporting Service (SSRS) 2008 R2, DTS (SQL2000)

Programming/web: JAVA, VB.Net, C#.Net & ASP.Net, SQL, MDX, DAX, M Query,HTML, XHTML, XML, Web Services

Database: SQL Server 2017,2015, 2012 & 2008 (design & development), azure sql database, azure sql data warehouse, Oracle, Teradata, General knowledge with MySQL, and Oracle

Networking: TCP/IP, MS Exchange 2003, SMTP, DNS, FTP, HTTP/s

Other Tools: SharePoint, Visual Source Safe, MS Project, MS Office, Quality center

OS: Windows 2000, XP, 2003, Vista, Linux and MAC OS X.

WORKING EXPERIENCE:

Confidential

Senior MSBI Azure Cloud Solution Engineer/Architect

Responsibilities:

  • Gather Requirement, Data Warehouse Design, Semantic Layer (Multidimensional model and Tabular model) Design based on Requirement
  • Participate in Azure migration for existing Data Warehouse from on premise to Iaas VM in Azure Cloud
  • Setup/Configure Integration Runtime for Azure Data Factory, Enable SSISDB for Management Instance in Azure, created gateway between Data Factory and on premise database, Using Azure Data Factory to upload SSIS package to transfer data, initial setup for Converting SSIS from Azure Iaas to Paas
  • Using azure data factory to design logic app for processing analysis service cubes
  • Design and Developed excelABRATE SSAS Tabular model and deployed to Azure Cloud
  • Design Function App, Logic App to scale up and scale down Azure Data Warehouse/SQL DB/Azure Tabular Model automatically etc.
  • Merged Web Cube, Web Metric, WebMetrics Multidimensional Cubes to one single Web Tabular Model and deployed to Azure Cloud, defined all time related Metrics and dynamic role in tabular model.
  • Architecture Design using Power BI to connect to various data set (hive,csv,excel) through azure data lake to create ad-hoc report
  • Converted existing multidimensional cubes to tabular model, recreated all existing measures using DAX and release to azure cloud analysis service
  • Converted existing tableau sales and finance reports to SSRS, Power bi dashboard/Report.
  • Converted Haley Report (Web Metrics) for Power BI solution
  • Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset
  • Created role based security for sales person in SSAS tabular model for Excelebrate project
  • Help to decide Power BI license strategy, setup and roadmap
  • Trained fulltime employee on tabular model, DAX and Power BI
  • Adding package configuration, Logging, Auditing for existing SSIS template
  • Design and Develop ETL SSIS packages for Loading data from azure data warehouse to sql server data mart

Confidential

Senior Business Intelligence Azure Solution Engineer/Architect

Responsibilities:

  • Data Warehouse migration from on premise to Azure cloud
  • SSIS Migration from on premise to Azure Iaas server
  • Performance Tuning on existing SSIS ETL packages, SSAS cube
  • Design Dashboard, Reports using Power BI Desktop.
  • Developed First Financial Tabular Model SSAS Cube, Using DAX to develop calculated member, KPI, Dynamic security etc.,
  • Designed and Developed the BI Archive Project for 140 dimensions and 50 fact tables
  • Designed Dashboard, Report using SSRS
  • Data Warehouse design, Data modeling using Kimball
  • Built tabular model for Labor and Finance Cube
  • Design all Calculated member, KPI, Function in Cube

Confidential

Data Warehouse Team Lead

Responsibilities:

  • Designed and Developed the Data Mart for Confidential
  • Designed and Developed the First SSAS Cube for Confidential
  • Using SSRS to design report for service department
  • Multiple ETL Design based on customer request(Talend,SSIS)
  • Using Excel Pivot table to design Dashboard for sales and service
  • Lead offshore SSAS Team, conduct weekly meeting, Assign work load
  • Design ETL Framework, Templates for the company
  • Design all Calculated member, KPI, Function in Cube
  • Overall Architect for Finance Data Warehouse Migration from on-premise to Azure, including database migration, ssis migration and ssas migration

Confidential

ETL Consultant

Responsibilities:

  • Provide Architect Level Consultant for BI solution
  • Design ETL Framework, Templates for the company
  • Redesign the fact and dimension loading package for data mart
  • Design the SSIS Package to replace core biztalk server security functionality
  • SSAS Cube Design and Writing complex mdx query for calculated member, KPI etc.
  • Using SSRS to design reports based on business request
  • Leverage Share point, performance point to design Dashboard, Publish SSRS report to share point and integrate reports with Dashboard
  • Performance Tuning the existing Cubes
  • Data Warehouse design, Data modeling using Kimball
  • Built the first tabular model for the company and create excel report on top of the model using SQL SEVER 2012
  • Redesign Hermes system 2.0 using the latest technology
  • Perform DBA duty when needed, Performance Tuning, backup restore BI related database
  • Database Design, Store Procedure Design as needed

Confidential

Business Intelligence Consultant

Responsibilities:

  • Second phase Data warehouse implementation
  • Create Power Pivot solution which include adding new attributes into power pivot and creating new calculated member using DAX
  • Customer Profile Dashboard Design using 2010 performance point/ share point, include contents like KPI, Score Card, Reports etc
  • Using SSRS create different reports and integrated with share point dashboard
  • Created new Sales Order detail fact table and Sales order detail cube
  • Redesign and optimize the existing Cube which include creating a new proper time dimension, create hierarchy in time dimension, performance tuning etc
  • Created Pivot table solution by adding new calculate member into Cube, and design pivot report using 2010 excel
  • Built new calculated members, KPI in existing cube using MDX
  • Performance Tuning the existing cube, re-architect the existing SSAS server using latest synchronization technology
  • Established SSAS security in the cube using dynamic fact table
  • Created SSAS store procedure to achieve different functionalities in the cube
  • Store Procedure, Function Design as needed
  • Perform DBA function when as needed, backup restore BI related database, Performance Tuning

Confidential

Business Intelligence Consultant

Responsibilities:

  • Work as Lead Consultant, Collect Requirement from the Business User, assign work to off shore team member
  • Provide BI Architect Level Consultant
  • Building SSIS Framework using best practice
  • Merge HUB 4.0 with HUB 4.1 into HUB 5.0
  • Provide mentor and training to the Junior team member
  • Work with the business user, Optimize the UC MGA ETL packages, add new features like Roll back, and Combine Regular Logging with meta data Logging into one consolidated view
  • Support Recon project in multiple phase, optimize old ETL solution, provide support to the business team

Confidential

Business Intelligence Architect/Developer

Responsibilities:

  • Gather requirements. Analyze related business processes to identify Dimensions, attributes, hierarchies and relationships.
  • Work with DBA to identify, profile and extract sources data from multiple systems
  • Data Warehouse design based on business requirement, SSIS loading Data warehouse, SSAS cube analysis
  • Using SSRS make multiple reports for Job Usage and RDB Usage
  • Using document map, sub report, Tool tip, action, etc different technology building complex reports based on customer requirement
  • Building web part, deploy SSRS report to share point server
  • Import solution from production, and make dimension or measure group changes on cube
  • SSIS package design, incremental extract and load, slowly changing dimension load, using multiple lookup to load fact table
  • Performance tuning existing store procedures, using execution plan etc
  • Using SSAS to design cube solution from data mart, define relationship for existing dimension attributes, using named query to replace existing tables and view
  • Optimize existing SSIS package by redesign the control flow and data flow, or adjust the buffer size or max rows for existing data flow
  • Building Dashboard, KPI, Filters, Score Card through Share Point/ Performance Point 2010 (MDX)
  • Implement Cube security using SSAS Store procedure
  • Performance Tuning the existing Cube using usage based optimization
  • Optimize the existing SSAS architecture using process and query analysis server methodology

Confidential

Business Intelligence Developer

Responsibilities:

  • Implement Business Intelligence Solutions using SSIS, SSAS, SSRS
  • Gather require Document, working with business user, identify dimension, attributes, hierarchies and relationships
  • Based on Business Require document, Writing Technique Require Document, which will clarify data mart relationship, ETL process, Measures group etc
  • Data Mart design and implementation, Database modeling, Design Fact and Dimension tables
  • ETL Design, incremental extracting, Dimension and Fact Loading, Error handling design for ETL
  • Dimension hierarchy, Attribute relationship, Drill through action design, Cube design, using MDX design measure group, calculated member, time intelligence YTD, MTD, WTD function design
  • Using Proclarity define KPI and released to share point 2007
  • Debug for the existing Cube, which involved bring production cube to local solution, fix then release back to production
  • Work with DBA to identify, profile and extract sources data from different system
  • Design and develop reporting solutions base on customer request, including drill-down, drill-thorough and subscriptions

Confidential

Developer (Application and Database)

Responsibilities:

  • Database development (SQL Server 2000)
  • Developed Functions, View, Stored procedures and DML triggers
  • Participated in database upgrading from SQL 7 to 2000
  • Used different tools to perform data transformation, and building reports

Confidential

Senior QA Analyst

Responsibilities:

  • Used SQL perform data validation check
  • Developed test scenarios and test scripts based on requirements and design documents.
  • Involved in querying and updating records and validated database records as expected.
  • Worked with user to define user acceptance test cases. Involved in UAT testing (User Acceptance Testing) and implementation.
  • Updated test cases designed from use-case analysis to Test Director.
  • Managed Test Cases, Automated Test Scripts, Test Inputs and Test Suites in Test Director.
  • Used Test Director to track bugs.
  • Designed and executed QA test plans according to business functional requirements and software design specifications to verify software/application functionalities (Windows and UNIX environment)
  • Troubleshot and identified application problems by analyzing codes and test results, worked closely with developers in isolating and reproducing defects

Confidential, Nashville, TN

BIG DATA TALEND ETL Consultant

Responsibilities:

  • Migrated more than 50 SSIS Packages to Talend ETL JOBS
  • Using Talend to Pull data from Oracle into Hadoop HDFS System
  • Using Sqoop to transfer data between Hadoop system and traditional database
  • Pulling data from HDFS into Hive tables using Talend
  • Transfer data between Hadoop cluser and AWS Redshift
  • Design DW Loading process using Talend for Confidential EDW system
  • Data migration from HDFS into ELK system
  • Data migration from HDFS to Redshift using Talend studio
  • Designed Historical Loading process and CDC features for incremental loading using Talend Studio
  • Designed and developed technical specifications using Hadoop technology

Confidential

Big Data ETL Architect

Responsibilities:

  • Helped client companies set up Hadoop eco system, Built ETL to load data into Hadoop(Talend), Built query and Front end dashboard to visualize Hadoop data
  • Designed and developed technical specifications using Hadoop technology.
  • Migrated all log files generated from various sources to HDFS for further processing using Flume.
  • Using Sqoop to transfer data between Hadoop system and traditional database
  • Written MapReduce tasks and PIG scripts to process data in HDFS.
  • Created Hive tables to store the processed results in a tabular format and create dashboard for tabular model.
  • Monitored Hadoop scripts which take the input from HDFS and load the data into Hive.
  • Experimented Apache Spark for better performance.
  • Experience in ELK (ElasticSearch, Logstash, Kibana), Solr, Banana

Confidential

Business Intelligence Developer

Responsibilities:

  • Data Extract, Transform, Loading using Microsoft SSIS and Talend tool
  • Dimensional Model database design for First Confidential data warehouse
  • ETL Package design for dimension table and fact table
  • SSAS Cube Design for Confidential
  • Dashboard Design using Excel through SSAS database

We'd love your feedback!