Amzad Syed A

adixqe@r.postjobfree.com

Amzad Syed Power BI Finance report

Amzad Syed Power BI Report

https://public.tableau.com/profile/amzadsyed#!/

·10 Years of experience as Business Intelligence Developer MS-BI and Architect.

·4 + Year Power BI, ETL, SSIS, SSRS, SQL Server 2014, SQL Server 2008 R2, 2014/16, Azure SQL Server, Azure Cloud, Oracle EBS, Power BI Premium.

·Strong Communication & Management skills Excellent Role-playing capabilities, Embedding Power BI Reports to SharePoint or any web base portal.

·Used Power BI to visualize SQL data and bring in additional data sources, connecting multiple platforms often. Used Power BI (Power BI Pro) reports within the Organization for 150 Users, Security (Implementing Basic Security) on PBIX, working on Use Relationship creating Role-Playing Dimensions. consume content that is embedded from an app workspace (group).

·Database Architect on Azure Cloud& Optimization (PTO) engagement to improve the operations of production databases of the next generation web API’s.

·Experience in Azure Cloud installing, configuring and administering both Clustered and Standalone Systems with different editions and versions of SQL Servers on Cloud servers.

·Creating BI Solutions Architect for LOB and Vertical Industries – Drove the creation of new BI solutions focused on specific LOB vertical industry needs based on Incremental Data load.

·Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS, SSAS.

·Power BI and Power BI pro reports that contains the report to embed An Azure Active Directory (Azure AD) instance.

·Integrate a dashboard into an app for organization, migrate Power BI Workspace Collection content to Power BI Embedded, register an app within Azure AD and O365 grant app permissions, Simulate a table relationship in DAX.

·Involved in migration of SSIS Packages 2012 CU5 and troubleshoot migration issues.

·Visual provides on both columns and additional shape layers or text elements. Using both Power BI Embedded and the Power BI service, using both Power BI &Power BI Pro.

·Created Power BI visualizing Key Performance Indicators, DAX queries, advanced DAX to retrieve data defined by a table expression from the in-memory analytics SSAS engine.

·Requested refreshes pre or post restore activities (e.g. data loads) Expertise in generating reports using Connecting from Power BI to SSRS reports, Crystal Reports, SSAS and MS Excel spreadsheets.

·Implemented MS SQL Cluster (Active/Passive), Multi Node Cluster up to 8 Node.

·Knowledge in Job Scheduling, Replication, Performance Tuning, Normalization/De-normalization concepts, database design

·Expert in generating formatted Oracle Database, Oracle EBS, SQL server Reports and skilled in

handling sub reports in SSRS 2005/2008.

·Ability to work independently with a high degree of personal initiative.

·Effectively maintained positive and productive working relationships in internal/external and team environments.

Education:

Master -2011 (International Business management) –Edinburgh (UK) Napier University.

Bachelors–Electronic & communication -2007 VTU (India)

TECHNICAL SKILLS

Databases:

MS SQL SERVER 2014/12,Tera Data SQL, MS-ASQL, Oracle EBS

Data Visualization:

SSRS, Tableau 10.0, Power BI, DAX, SSIS (ETL)

Operating System:

Windows 2008/2012 R2 Advanced Server, NT & Windows 9x, Linux

Languages / Tools:

T-SQL, My SQL,Backup Utility, SQL LiteSpeed, Java

DBA:

database administration of MS SQL Server 2012,2008, 2005

NBC Universal / Xfinity 2018 Jan – Till date

Role: Sr Power BI Developer /BI Developer

(Power BI Developer + Admin+ Gateway Service)

New Jersey / Philly: - NBC Universal / Xfinity

Responsibilities:

·Creating PBIX model from Direct Query live connection relationship on underlying columns. Direct Query, M-Query, optimize the resulting SQL code and M Query. DAX Calculations and Time Intelligence (Rolling 12 Months Total) set up gateway data refresh.

·Scheduling reports in app workspace, publish from Excel, Data gateway, creating content Pack, simulate a table relationship in DAX, users can consume content that is embedded from an app workspace (group)

·Creating most of DAX expression, working on DirectQuery model for PBIX Report.

·Projects and new ideas triggered by real customer demand, Database Architect on Azure Cloud such as Lean Manufacturing BI Scorecard and CRM analytics.

·Migrating SQL Server database into MongoDB for GPS data load Table level Actions Creating Index, Oracle EBS including active/active data centers and global data distribution.

·Integrate a dashboard into an app for organization, from Oracle PL/ SQL database, migrate Power BI Workspace Collection content to Power BI Embedded, register an app within Azure AD and O365 grant app permissions.

·Design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Pie-Charts, Heat Maps, Bubble Charts and Geographic Visualization according to the end user requirement.

·Sample Azure Cloud Instances for VM’s installing SQL 2016 Configured Replication and databases mirroring.

·Security (Implementing Basic Security) on PBIX, working on Use Relationship creating Role-Playing Dimensions

·Created Power BI Premium Reports to Integrating into VMS Project for 150 Users.

·App workspaces to provide better isolation PBIX app in servicing multiple customers. Dashboards and reports sharing isolated between customers.

·Created DAX formulas provide calculate month-over-month growth compared to Business.

·Self-learning on data modelling in live connection of SSAS Cubes to scope the Power BI Reports to create measures and metadata.

·Create Data Warehouse schema to deploy facts and dimensions tables and defined referenced relationships with the measure groups.

·Perform SQL Server database Backup/Recovery and OLAP cube replication to production environments.

·Built DAX expression that returns a single scalar value for reporting in Power BI.

·Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.

·Visualized Microsoft Azure Data with Power BI, for quick analysis of Enterprise data.

Environment: SQL Server 2014, Azure SQL 2012, 2008R2, Azure cloud, Power BI, Power BI pro, Windows 2012, Python, MySQL, BizTalk, Oracle EBS, DAX, Power BI Premium SQL Query Analyzer, SQL Profiler.

Department of Education (OPT), DOE-NYC 2016 Jan – 2018 Jan

Role: Sr BI Developer / Power BI Architect

Responsibilities:

·Built Ad-Hoc Power BI reports depending on business requirements was one of the major responsibilities. Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.

·Projects and new ideas triggered by real customer demand, Database Architect on Azure Cloud such as Lean Manufacturing BI Scorecard and CRM analytics.

·Migrating SQL Server database into Hadoop, DI-centre for GPS data load Table level Actions Creating Index, Deployment scenarios including active/active data centres and global data distribution.

·Created DAX formulas provide calculate month-over-month growth compared to Business.

·Self-learning on data modelling in live connection of SSAS Cubes to scope the Power BI Reports to create measures and metadata.

·Create Data Warehouse schema to deploy facts and dimensions tables and defined referenced relationships with the measure groups.

·Perform SQL Server database Backup/Recovery and OLAP cube replication to production environments.

·Created Power BI visualizing Key Performance Indicators, DAX queries, advanced DAX to retrieve data defined by a table expression from the in-memory analytics SSAS engine.

·Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.

·Analyze long running slow queries and tune the same to optimize application and system performance.

·Reorg/Rebuilding the indexes at regular intervals for better performance. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server 2014, 2012, Oracle EBS, Azure cloud, Power BI, Power BI pro, Windows 2012, MySQL, BizTalk, Python, Visio. Enterprise Manager, DAX, Power BI Premium SQL Query Analyzer, SQL Profiler.

Little Caesars, Detroit, MI 2015 May—2015 Dec

Role: BI Developer / SQL DBA

Responsibilities:

·Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

·Azure Cloud Instances for VM’s installing SQL 2014 Configured Replication and databases mirroring.

·Data warehouse migration 2TB, with all Linked Servers, Parameterized, Cascaded, Linked, and drill-through and drill-down reports. Recommending best practices for SDLC.

·Upgraded SQL server databases from to 2012 /2014.

·Experience in working and troubleshooting2TB Very Large databases (VLDB) in OLTP Environment.

·Designed ETL packages on Oracle EBS, Web Services dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

·Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

·Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.

·Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.

·Analyze long running slow queries and tune the same to optimize application and system performance.

·Reorg/Rebuilding the indexes at regular intervals for better performance. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

·Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.

·Configuring and deploying SSIS packages and SSRS reports.

·Documenting procedures in run books.

Environment: SQL Server 2014, 2012, 2008R2, Power BI Windows 2012, MySQL, BizTalk, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Xerox, Corporation UK Aug 2014 – April2015

Role: BI Developer (SQL, SSIS, ETL)

Responsibilities:

·Involved in the Requirements gathering (gathering, analyzing, and documenting business requirements and data specifications).

·Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

·Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

·Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse, DMExpress performance connectivity to virtually to source Destination, including all major RDBMS systems.

·Set up security and access profiles and procedures for database system administrators.

·Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

·DMX is the only data integration tool with a Smart ETL Optimizer. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

·RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

·Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

·Analysis Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimension.

·Log Shipping for Automated Process for backing up, restoring, copying the transaction logs and synchronizing the database for distributed database server application which can improve the application performance and availability of database.

Environment: ETL, MySQL, MS SQL Server 2008/2012, SSIS, SSRS, XML, ASP.net, VM ware, Flash, Flash, SSRS, SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, DMX Data Integration, SFTP, Microsoft Reporting Services.

GroupM (WPP) Media, UK, NYC (Off shore UK) Nov 2013 - JUL 2014

Sr.BI-Developer/ Tableau 8.0

Responsibilities:

·Deployed those reports to the report manager and configured subscription in report manager for scheduling of the reports on SSRS. Responsible for scheduling the subscription reports with the subscription report wizard.

· Creating SSRS reports from scratch ETL process design and implementation using SSIS. Extracting Data from RiO into trust's electronic patient records system of GDC server.

· Creating OLAP, SSRS Data Warehouse design and implementation SSAS Tabular PowerPivot.

·Developed custom reports and deployed them on to server using SQL Server Reporting Services (SSRS)involved in DMX dynamically for efficient algorithms based on the data structures and system.

·Installed Tableau Server in Dev, QA, UAT and Prod environments.

·Create parameterized Reports using Charts Cross-Tab and Sub-report types. Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).

·Served as a SSRS 2008R2 Reports Developer and SQL Server Developer in support of Service Management System

·Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.

·Extensively used data blending, embed functionalities in Tableau.

·Installed Tableau Server in Dev, QA, UAT and Prod environments.

·Unit Testing the SSIS packages with respect to its flow and performance issues.

·Extensively worked on DBCC commands and Dynamic Management Objects.

·Performed DMExpress (Standard ETL product), SSIS, SSDT transform and load data into the data warehouse, developed a multi-dimensional OLAP cube in SSAS using the data warehouse schema and implemented multi-level hierarchies for rolling up data.

Environment: Tableau BI, Hadoop, SQL Server 2012, JavaScript, DMExpress 6, SQL Server Data Tools(SSDT) Oracle10i, Microsoft CRM, Tabular model, TeraData SQL.

IAC, Group Limited UK ~ Birmingham Sep 2012 –Aug 2013

Business Intelligence Developer (T-SQL)

Responsibilities:

·SQL Server Management Studio was used to make changes in code to large and complex transact (T)-SQL stored procedures. Used Visual Studio 2010 to make changes in SSIS to create ETL packages to validate, extract, transform and load data to data mart databases and then into data warehouse database.

·Created a Power Pivot excel file to import data and define Business Intelligence Semantic Model (BISM).

·Created a solution in SQL Server Data tools to import model from Power Pivot file.

·Performance indicators using SQL scripts, on multiple projects, giving expert guidance on governance, reporting techniques, and project management, performance improvement.

·Enhancement to SQL scripts for performance indicator, ACOF data warehouse using external and internal resources.

·Implemented complex SQL Server 2005 / 2008 / 2012 stored procedures and SQL server jobs to support operational report suite.

·Used Gauge2D, 3D, Dimensions, chart for reporting services SSRS to develop complex graphical reports with the ability to drill down for detailed information.

·Integration SQL Development contracted to provide a range of BI consultancy and development services aiming at the strengthening and automation of Enhanced Client Reporting (ECR) process and improvement of client portfolio analysis data.

·Responsible for all aspects of IT operational, controlling infrastructure, systems & support services. Appointed integration SQL server, infrastructure and equipment, aligned to business Database Consolidation expansion.

·Worked with senior level technical Architect and Microsoft Business Intelligence Developer creating a joining reports and upgrade of data base with the SQL data base.

·This project required to manipulate and to create a new database for end user to create different data structures. Gather report requirement for customer meetings ad hoc requests.

·Designing and developing storage process and views necessary supports using SSRS and SSIS.

Environment: ETL,T-SQL MySQL, SAP-BI/BO,SAP-ABAP, VM ware, Flash, Photoshop CS2, Teradata, Tableau Mapping / GIS, SSRS, Oracle 9i, SAS/Stat, SAS/Graph, SAS/SQL,SAS/Macros, SAS/ Access, MS-Excel,PowerPivot, Macromedia Dreamweaver.

Network Mobile, UK JAN 2011 – May 2012

Business Intelligence Developer

Responsibilities:

·Designed Qlikview comprehensive platform providing, understanding customer calling time behavior, upgraded voice IVR reporting suite to analyses more complex customer behavior, improving customer satisfaction index.

·Developed routine SAS macros to create tables, graphs and listings for inclusion in Sales study reports. Worked on time to event data to generate the required results for the comparator sales and the marketing events and reviewed large macro codes for running the programs.

·Involved in requirement gathering & designing QlikView applications.

·Allowed senior managers unprecedented real-time visibility on IVR customer behavior by creating near-real time Qlikview IVR dashboard.

·Implemented quarterly as well as yearly sales, order generation for all the dashboards

·Creating QlikView dashboards of call handing forecasting, call rate, call waiting time, and call forward, average call time QlikViews.

·Maintained and enhanced territory operating Dashboard SU application.

·Implemented a new dashboard called "Opportunities Bridge" in the existing application with a set of macro functions.

·Worked with business partners and Server Side BI engineers to rigorously define, implement and further develop metrics and key performance indicators.

·Assisted in resolving issues raised by the users for this application.

·Maintained production Server scheduled jobs running at regular intervals

·Gathered data sources such as QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.

·Developed user interactive sheets & reports as business needs.

·Writing SQL Scripts to load the relevant Data in QlikView Applications.

Environment: ETL, MySQL, EDI-tool, Qlikview, Business Intelligence (SSIS, SSRS), SAS/Graph, SAS/SQL, SAS/Macros, SAS/ Access VM ware, Flash, Photoshop CS2, Macromedia Dreamweaver.

Collabera PLC (US) Mar 2008 – JAN 2010

Off shore (B’lore India)

Jr. BI Developer

Collabera An IT services and consulting firm with more than 200 clients worldwide, and over 15,000 employees, Hired as a Business Intelligence Developer to provide a range of Information Analysis and BI consultancy services to improve and streamline current business processes and applications on the following projects:

Responsibilities:

Deutsche Post DHL(DP DHL) - Financial Reporting BI Analyst, IT Service Management,

·Global Business Services is a global shared services center, with over 13,000 professionals. DHL Express is a global market leader in international express and logistics, with more than 136,000 professionals.

·Provided Deutsche Post DHL Global Business Services and its worldwide business units with reporting solutions. Responsible for reporting architecture and analysis of 220 IT services; supporting IT Service Management (ITSM) and 1,100 IT services professionals.

·Created reporting portal for financial service, performance reports, allowing IT management access to all metrics and KPI’s in one place.

·Designed and implemented the underlying extract-transform-load (ETL) structure in SSIS to support the new IT services reporting.

·Working with financial system creating Quarterly reports (e.g. sales, Budget, quantity sold) inventory analysis.

·Partnered with European and Asian colleagues to establish IT service reporting process using IT Infrastructure Library version 3 (ITIL v3) standards. Created standard metrics, governance, and data modeled the architecture for a global data warehouse.

Technical snapshot: Visual Studio, Data warehouse, SAP-BI/BO, Business Intelligence (SSAS, SSIS, SSRS), ETL, SQL Server, T-SQL, MS Access, Excel, DOM, GP Vision Application

Hess Co-operate, Inc. Houston, TX. April2007- Feb 2008

Collabera PLC

Off shore (B’lore India)

BI Reporting Analyst, Retail Group Customer Care

Hess Co-operate provides Oil &Gas -related products to 1.8 million customers. Hess Gas &Energy’s retail group includes 1,100 professionals.

Responsibilities:

·Daily routine Developer/ DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs. Off-shore Business Intelligent Support (based in India)

·Created Documentation for steps to be taken while upgrading the SQL server 2000 to SQL server 2005.

·Implemented suite of 20BOBJ Crystal Reports giving enhanced visibility to Avaya CMS phone statistics and staff forecasting, SQL Server 2008.

·Modeled reporting data mart, and automated ETL processes, to ensure accurate storage and presentation of data.

·Automated all reports and implemented real-time reports, financial reporting, and enabling staff to sustain a 70% increase in service level agreements.

Technical snapshot: SAP BI/BO, SSIS, T-SQL, SAP ABAP MicroStrategy Data Cloud, SAP-HANA, Financial systems, Mobile-BI Financial, DATA-management, TargIT, Risk Assessment management using Micro Stratergy.

Contact this candidate