We provide IT Staff Augmentation Services!

Data Analyst Resume

Sunrise, FL

EXPERIENCE SUMMARY:

  • I am Trained, certified and experienced with SQL Server on premise and Cloud environment. Having 12+ years of experience in Microsoft SQL Server Business Intelligence Tools (MSBI) and Azure technologies (ADF, ADL, ADW), Designing & Implementing Solutions on different database servers; ranging from GBs to TBs in size.
  • Microsoft Azure Cloud Services
  • Subscribe SQL Server Azure Cloud Services.
  • Create Database(s) on SQL Azure
  • Setting up SQL Azure Firewall
  • Create and manage Microsoft Azure Data Lake
  • Migration from On - Premise to cloud platform
  • Designing and implementing Azure and related technologies like DW, ML and HDInsight etc.
  • Create, manage SQL Server Azure Data Warehouse (DW) Databases
  • Setting up Connection Strings and connecting SQL Server Azure Databases from locally
  • Develop the Power BI desktop services and publish on PBI service (cloud)
  • Create gateways, data sources and user admin on cloud services for Power BI
  • Create external tables and load the data in Azure SQL DW tables using Polybase.
  • Analysis Services / Data warehouse Management (SSAS)
  • Excellent hands on experience deploying SSAS Objects using deployment wizard or using Synchronize database wizard.
  • Experience in Data Marts, Data warehousing, OLAP using the Dimensional Modeling techniques such as Star schema and Snow flake schema, FACT and Dimension Tables using MS Analysis Services (SSAS).
  • Extensive Experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
  • Excellent hand on experience in creating report model on SSAS cubes, as well as changing default configuration on existing cubes.
  • Good experience in Designing Aggregations and pre-calculating in SSAS 2008 and 20012.
  • Experience in writing MDX Scripting and MDX Queries. Experience in Building Cubes and Dimensions.
  • Integration Services / Data warehouse Management (SSIS)
  • Extensively involved in data extraction and loading using .dtsx in MS SQL Server 2005 using SSIS in MS SQL Server 2005/2008/2012.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
  • Strong experience in database Backup, Restore and Recovery procedures using SSIS Packages.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions, Performance Tuning and Query Optimization.
  • Reporting Services / Data warehouse Management (SSRS)
  • Created SSRS Reports to meet Ad hoc and operational business requirement
  • Publishing / Deploying Report on multiple Report Servers
  • Managing Shared Data sources and permissions
  • Configured Reports Snapshots, Report Caching for reporting performance
  • Assigning report level permissions to Secure business information
  • Created Data Driven Subscription for Reports

TECHNICAL SKILLS:

Technologies: Microsoft Business Intelligence Tools (SSIS, SSAS, SSRS)

Operating Systems: Windows 2003 / NT / XP

Languages: C, C++, Java, VB 6.0, T - SQL, Python, U-SQL

Statistical Tools: Machine Learning with R (CRAN)

OLAP Tools: SQL Server Analysis Services

Databases: Greenplum, Oracle 9i, SQL Server 2005 / 2008 R2 / 2012 / 2016

Packages: MS Office 2010, MS Visio, Visual studio, MOSS 2012

Reporting Tools: SQL Server 2012 Reporting Services, Qlikview, Tableau, Power BI

Big Data Tools: Hive, HBase, Sqoop, Pig, Spark with Python.

Cloud Platform: Microsoft Azure ADF, ADL, ADW, HDInsight and Storage etc..

EMPLOYMENT DETAILS:

Confidential, Sunrise, FL

Data Analyst

Responsibilities:

  • Responsible for ensuring project estimates and schedules are created.
  • Providing project status reports to RM and stakeholders.
  • Create Database(s) on SQL Azure platform.
  • Create and manage Microsoft Azure Storage.
  • Migration from On-Premise to cloud platform for Data Lake database like ADL, SQL DW
  • Designed and developed Azure Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
  • Develop the Power BI desktop services and Manage, Publish on PBI service (cloud) using Direct Query, Import and Live Connection methods.
  • Create gateways, licensing, setup data sources and user admin on cloud services for Power BI

Environment: SSDT 2016, ADF, ADL, Azure Synapse Analytics (formerly SQL DW) and Power BI service.

Confidential, Boca Raton, FL

Power BI Developer

Responsibilities:

  • Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS tools and technologies.
  • Involve in requirement gathering & write low-level and high-level specifications. Analysis, design, development, testing, implementation, and production support.
  • Designed and developed Tabular Analysis Services (SSAS) databases and OLAP cubes used in automated reporting.
  • Develop the Power BI desktop services and Manage, Publish the PBI service (cloud)
  • Create gateways, data sources and user admin on cloud services for Power BI.
  • Provided training to end users and co developers.

Environment: SSIS 2012, SSAS 2012, SSRS 2016, ADF, Azure SQL server and Power BI service.

Confidential, FL

SOLUTION ARCHITECT

Responsibilities:

  • Managing the team with onsite/client communication, technical practices, ensuring tasks/sprints are completed on time and removing impediments and attend team meetings with Customers and Co-Ordination with different vendors.
  • Responsible for ensuring project estimates and schedules are created.
  • Providing project status reports to RM and stakeholders.
  • Create Database(s) on SQL Azure platform.
  • Create and manage Microsoft Azure Storage.
  • Migration from On-Premise to cloud platform for Data Lake database like SQL DW and HBase to HDInsight
  • Designed and developed Multi-Dimensional Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
  • Successfully implemented Data Integrate POC’s between Data Lake tables to BI Layers.
  • Develop the Power BI desktop services and Manage, Publish on PBI service (cloud)
  • Create gateways, licensing, setup data sources and user admin on cloud services for Power BI
  • Create external tables and load the data in Azure SQL DW tables using SSIS.
  • Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS and Azure tools and technologies.
  • Involve in requirement gathering & write low-level and high-level specifications. Analysis, design, development, testing, implementation, and production support.

Environment: Azure cloud (Azure DW, ADF, ADL), A-SSAS, SSRS 2016 and Power BI service.

Confidential, FL

BI ARCHITECT

Responsibilities:

  • Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS and Azure tools and technologies.
  • Involve in requirement gathering & write low-level and high-level specifications. Analysis, design, development, testing, implementation, and production support.
  • Managing the team with onsite/client communication, technical practices, ensuring tasks/sprints are completed on time and removing impediments and attend team meetings with Customers and Co-Ordination with Offshore.
  • Responsible for ensuring project estimates and schedules are created.
  • Providing project status reports to RM and stakeholders.
  • Designed and developed Multi-Dimensional Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
  • Successfully implemented Data Integrate POC’s between Data Lake tables to BI Layers.
  • Develop the Power BI desktop services and Manage, Publish the PBI service (cloud)
  • Create gateways, data sources and user admin on cloud services for Power BI
  • Create external tables and load the data in Azure SQL DW tables using Polybase.

Environment: Azure cloud, SSIS 2012, SSAS 2012, SSRS 2016 and Power BI service.

Confidential, FL

BI ARCHITECT

Responsibilities:

  • Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS and SQL server tools and technologies.
  • Developing technology specifications and ensuring that new technology solutions are designed for optimal access and usefulness, and leveraging existing technologies when possible
  • Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability
  • Identifying the technologies to employ based on price, performance, service agreements and organization constraints
  • Designs, implements and supports data warehousing and also building Data marts for each department.
  • Pull the Data through ETL process from multiple systems like Oracle ERP, PeopleSoft, Work Brain and Footprints into Data ware house.
  • Dimensional Data Modelling using Star and Snow Flake Schemas.
  • Developed complex store procedures for business requirements.
  • Developed SSAS cubes for each department like Finance, accounts, HR, PeopleSoft and Service desk.
  • Designed very complicated Security setup using MDX So that when user’s login they will see only their divisions data.
  • Designed and developed Multi-Dimensional Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
  • Good Understanding on SSAS cube MOLAP, ROLAP, HOLAP storage modes.
  • Designed and developed dynamic partitions in SSAS (Multi-Dimensional) cubes.
  • Designed and developed Multi-Dimensional Analysis Services cube XMLA scripts for dynamic cube processing and Backup/Restore.
  • Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
  • Developing multiple SSRS reports like parameterized, sub report, cascading and dynamic.
  • End to End testing on all development activities to retain data accuracy and performance related issues.
  • Managing Off shore team of 10 resources and providing production support to developed marts.

Environment: SQL Server 2012, SSIS 2012, SSAS 2012, SSRS 2012, Qlikview and Tableau SQL Server 2008 R2, SSIS 2008 R2, SSAS 2008 R2 and SSRS 2008 R2.

Confidential

BI ARCHITECT

Responsibilities:

  • Gathered the requirements from the client and translated the business design into Technical Design.
  • Responsible for data warehouse modeling, ETL design and development, and performance tuning.
  • Designed and implemented the ETL architecture for the whole project using SSIS.
  • Implemented Performance improvements in T-sql scripts and handled data efficiently.
  • Effectively solved ongoing issues in the Test, QA Environment.
  • Implemented Performance improvements in T-sql scripts and handled data efficiently.
  • Design overall ETL solution and templates and guide team for development.
  • Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
  • Implement performance tuning on T-SQL / ETL.

Environment: SQL Server 2008 R2, SSIS, SSRS, MOSS.

Confidential

ETL ARCHITECT

Responsibilities:

  • Designed and implemented the ETL architecture for the whole project using SSIS.
  • Designed and developed multi-dimensional Cube databases using SSAS.
  • Implemented Performance improvements in T-sql scripts and handled data efficiently.
  • Performing Health checks for Sql Servers and performing Warehouse keeping activities.
  • Responsible to monitor all support activities, tickets tracking, providing necessary support to associates Etc.
  • Effectively solved ongoing issues in the production Environment.
  • Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
  • Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
  • Implemented Performance improvements in T-sql scripts and handled data efficiently.
  • Design overall ETL solution and templates and guide team for development.
  • Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
  • Implement performance tuning on Reports and ETL.

Environment: SQL Server 2008, SSIS, SSAS and SSRS.

Confidential

BI PROJECT LEAD

Responsibilities:

  • Gathered the requirements from the client and translated the business design into Technical Design.
  • Responsible for data warehouse modeling, ETL design and development, and performance tuning.
  • Designed and implemented the ETL architecture for the whole project using SSIS.
  • Implemented Performance improvements in T-sql scripts and handled data efficiently.
  • Design overall ETL solution and templates and guide team for development.
  • Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
  • Implement performance tuning on Reports and ETL.
  • Ensure smooth deployment on all development and testing environments.
  • Co - ordinate with production team for issue analysis and resolution.

Environment: Oracle, Netezza, SSIS, SSRS, UNIX

Hire Now