Amzad A Syed (Green Card) Power BI Developer

Amzad A Syed

(Green Card)

Power BI Developer

amzadali16@gmail.com

609-787-5056

Profile Summary:

  • 13 + Years of experience as Business Intelligence Developer MS-BI and Architect.
  • 5 + 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 Cloudinstalling, 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 ActiveDirectory(Azure AD) instanceIntegrate 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 apppermissions, Simulate a table relationship in DAX.
  • Involved in migration of SSISPackages 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, Also involved in MS Power BI connection types including ODI
  • Implemented MS SQL Cluster (Active/Passive), Multi Node Clusterup 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 reportsin 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

NBC Universal / Xfinity brand advocates for Insurance for leading Internet service. Marketing, technology and sales capabilities combine to create a vital source of revenue. Work across all digital and offline marketing channels allows maximizing ROI for our partners while protecting their brands. Create email campaigns for branded partners that provide high quality leads and are continuously audited for brands

Responsibilities:

  • Creating PBIX model from DirectQuery/live connection relationship on underlying columns. DirectQuery 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 work space, 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 centres 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 also involved in MS Power BI connection types including ODI.
  • Created Infographics with Geo-Fence infographic for students route data, created tailoring chart custom visual provides on both columns and additional shape layers or text elements.
  • 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

DOE is Student transport system for both Public and Non-Public Schools located within the five boroughs in New York City.

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.
  • 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: Sr Power BI Developer /BI Developer / SQL DBA

Little Caesars is third largest pizza Retail Chain in North America with 4000+ store around USA & Mexico.

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 forVM’sinstallingSQL 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: Sr Power BI Developer /BI Developer / SQL DBA

Xerox, Document Transaction Processing Services streamline business and document management processes to drive growth, reduce costs and give sustainable competitive advantage. Automate back-office functions by managing incoming documents, digitising, indexing, and routing their information to electronic document management and storage services. Xerox’s Document Transaction Processing Services help companies digitise documents and transform business and document management processes to improve efficiency while reducing costs.

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 TuningAdvisor (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.

Technical snapshot: 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

GroupM Entertainment, an operating unit of GroupM Worldwide, is engaged in the business of creating, financing and distributing intellectual property to create advantages for its clients and generate new sources of revenue for its agencies. GroupM Entertainment provides financial, business and legal support to the Agency Entertainment teams at Mindshare, MEC, MediaCom and Maxus. In addition, best practice creative support is provided to insure that the Agency Entertainment offerings provide best in class Entertainment Marketing solutions to clients.

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 TabularPowerPivot.
  • Developed custom reports and deployed them on to server using SQL Server Reporting Services (SSRS)involved in DMX dynamicallyfor 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, SSDTtransform 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.

Technical Summary: 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)

IAC Group is a supplier of automotive interior, exterior systems and components. It is a global automotive technology consulting firm with over 8,000 employees, working in Germany and the UK. Contracted to provide BI solutions and information management support for the UK team of 6 members, MS-BI, ETL process using SSIS, SAP-BW activities and post go live support for IAC implementation, end user training and programming in intelligence reporting.

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.

Technical snapshot: 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

Network Mobile is one of the largest mobile service companies in the UK, with £430 million revenue, mobile connection plans and more than 5 million individuals served through its subsidiaries.Designed and implemented reporting architecture to support telephonic analytical needs for Network mobile customer facing lines of business, servicing over 5,000 staff and management at Network mobile. Worked with team of 15 Business analysts and Qilkview BI developers. Provided Network mobile QilkViewBusiness analysis and design enhancements for voice self-service IVR (870-075-0011).

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 QlikViewapplications.
  • 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 DashboardSU 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.
  • Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
  • Writing SQL Scripts to load the relevant Data in QlikViewApplications.

Technical snapshot: ETL, MySQL, EDI-tool, Qlikview, Business Intelligence (SSIS, SSRS), SAS/Graph, SAS/SQL, SAS/Macros, SAS/ Access VM ware, Flash, Photoshop CS2, Macromedia Flash, 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 Developerto 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 centre, 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/ DBAtasks 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 phonestatistics 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 MicroStratergy.

 

Leave a Comment

%d bloggers like this: