MOHAMMED KHALID

732-***-****

ac9qty@r.postjobfree.com

Professional Summary

MSBI Developer with strong experience in Design, Development and Deployment of Business Intelligence solutions. Experienced in working with development teams, Business analysts and Interacting with end-users. Experience in building Database solutions in various domains including Retail, Financial corporation, and Health care. Experience in creating, configuring and deploying various packages in SSIS for Business Intelligence Development. Expertise in developing and deploying various subscription and interactive reports using SSRS and Power BI.

Over 6+ years of experience in requirement analysis, design, and development of projects with SQL Server 2008/2008R2/2012/2014 in various phases of Business Intelligence life cycle.

Experienced in implementing Business Intelligence Solutions for Enterprise Decision support systems using Microsoft suite of products like SSIS, SSRS and SSAS and Power BI.

Microsoft Certified in visualizing data in Power BI Desktop and deploying Dashboard in Power BI Cloud.

Expert in creating different formats of reports for internal and external reporting purposes including drill down and drill through based on needs of granularity using SSRS 2005/2008/2012.

Well acquainted in working with SSAS Tabular. Working knowledge of DAX expressions.

Experienced in working as SSRS Admin in SharePoint Integrated Mode as well as Native Mode to collaborate, share reports and enforce security.

Experienced in performance testing and query optimization for faster data access.

Experience in Agent jobs, SQL Mail Agent, Alerts, and schedule DTS/SSIS Packages, Data Factory and Integration Runtime.

Well versed with Kimball’s approach in OLAP development as per business needs.

Skilled at solving challenges in a methodical manner and analysing current issues to envision creative solutions. Demonstrate intellectual curiosity thus seamlessly learn new technology.

Capable of handling responsibilities independently as well as a proactive team member. Strong Analytical skills and ability to work cross functionally.

Experienced in working in Agile environments with Offshore as well as Onsite staffs.

Experienced in working with business communities to determine the needs, scope, and evaluation of project goals.

Well versed in working cross-functionally with source SMEs, business teams, Integration specialists, Quality Assurance and Reporting teams.

Generated Ad-Hoc reports, Parameterized reports and other reports using SSRS.

Experienced in implementing Business Intelligence Solutions for Enterprise Decision support systems using Microsoft suite of products like SSIS, SSRS and SSAS and Power BI.

Expertise in writing complex T-SQL queries using advanced features of Microsoft SQL Server like CTE, Merge, Multiple Joins and Sub queries.

Good experience and knowledge in data analysis and creating SQL queries to fetch data from multiple platforms such as Oracle, SQL Server

Optimized the performance of queries with modification in T-SQL queries, removed unnecessary column, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary using tools like MS SQL Profiler, Query execution plan.

Proficient in developing various complex packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Oracle, Flat File to destination by using multiple transformations using SSIS.

Expertise in scheduling jobs and monitoring the alerts for automation of SSIS packages.

Good knowledge in RDBMS, Dimensional Modelling, ER Modelling, Data Marts, Star Schema, Snowflake Schema, Fact and Dimensional tables.

Experienced in designing and developing large number of reports in SSRS/Tableau using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

Expertise working with different SDLC methodologies like Agile Methodologies, Scrum-Waterfall Hybrid, Scrum, Kanban and Waterfall.

Participated in discussions and retrospective meetings on Risk analysis, Cost-Benefit analysis and Gap analysis and researched on new requirements compatible to the current market trends.

Expert in monitoring and facilitating the entire Testing Life Cycle including Test strategy, Test planning, Test case preparation, Test execution and Defect management.

TECHNICAL SKILLS:

Microsoft Technologies: Adept with Microsoft Office Suite, Outlook and SharePoint

Languages: T-SQL, XML, C, Python, SQL, HTML5, CSS, JAVA

SVN and Servicing Tools: GitHub, Bitbucket, Beanstalk, Apache Tomcat, AWS

Operating Systems: Windows 2000/07/08/09/10, DOS & UNIX

Business Skills: Business Process Analysis & Design, Process Improvement and

Implementation, Assessment, Requirement Gathering, Use Case

Modelling, JAD Sessions, Gap Analysis & Impact Analysis

Project Management Tools: JIRA, Asana, Redmine, InVision & MS Project

RDBMS/ Databases / Database Tools: MS SQL Server, MS Access, SQL Server Management Studio, SQL

Server Data Tools, Visual Studio, Report Builder, Oracle and

MySQL Databases, MS Azure, Teradata, IBM DB2, ERWIN

Methodologies: Scrum, Agile & Waterfall

Professional Work Experience

Sapphire Digital, NJ, USA Jan 2018 – Current

SSIS/SSRS-BI Developer

Sapphire Digital’s health care transparency and engagement platform allows consumers to search for providers, understand their cost status and evaluate quality. The scope of project is to update the data warehouse by removing extraneous and duplicate data entries and defragging tables to maintain the warehouse. Using ETL tools for extracting Dynamic data from CRM and ERP and integrate it to warehouse for centralised data.

Roles & Responsibilities:

Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.

Developed Employee scorecard reports which track all the employee metrics needed for the statistical analysis of Business.

Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems like MS SQL Server.

Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.

Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations like OLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Expertise in creating various types of reports such as complex drill-down reports, drill through reports, parameterized reports, matrix reports, Sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases.

Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.

Developed custom calculated measures using DAX for various Fact calculations for efficient data visualization in Power BI.

Implemented Power BI gateway to keep Dashboards and reports up to date with on-premise data sources.

According to client requirements, generated reports like Tabular reports, Sub reports, Matrix reports, Drill down reports and Charts using SQL Server Reporting Services (SSRS).

Worked on writing custom code expressions in SSRS.

Scheduled and executed SSIS Packages using SQL Server Agent and Development of automated daily, weekly and monthly system maintenance tasks such as database backup, Database Integrity verification, indexing and statistics updates.

Monitoring SQL server performance using SQL Profiler to find performance and Deadlocks.

Created DataMart for sales team to create Ad-hoc reports using report builder.

Extensive use of Team foundation server for code check-in/check-out and managing source code changes.

Designed Data Mapping documents, DDL scripts, Data Dictionary and Meta data of the models and maintained them.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing.

Environment: MS SQL Server 20162014/2012, SSIS, SSRS, SSAS, SSMS, Oracle 11g, Visual Studio 2012, Power pivot, T-SQL, Power BI, TFS, SharePoint, MS Excel, PowerPivot, T-SQL, JIRA, DAX.

Electri-Cable Assemblies, Shelton, CT, USA Jan 2017 – Dec 2017

ETL/ Business Intelligence Developer

ECA is a leading designer and manufacturer of power, charging, data and electrical solutions. It delivers products that elevate non-stop connection, with products that are as forward-thinking as they are flexible. The main scope of the project was to maintain existing Microsoft Access and SQL Server databases, as well as the design and implementation of new SQL based applications. I was also involved with development of related training material, data analysis, software issue resolution, and integration of data across our systems.

Roles & Responsibilities:

Stored configuration information in SQL Server table for the migration from development server to production server and used various dataflow and control flow transformations for ETL.

Involved in the logical and physical design of the Data mart using dimensional modelling and designed the SSIS Package for the transfer of data from OLTP to data mart.

Wrote Stored Procedures for the ETL functionality from ODS to Data Mart in SQL Server 2005 and developed the Slowly Changing Transformation to maintain the historic data.

Designed Usage summary and Detail reports in SSRS 2005 from the requirement document and also Created Alerts for successful or unsuccessful completion of the scheduled jobs.

Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.

Created, modified and designed Microsoft Access and SQL Server Reporting Services (SSRS) reports, MS Access data exports and imports, and SQL Server Integration Services (SSIS) packages.

Created Sub-Reports, Drill-Down reports, Ad-hoc reports, and Parameterized reports as part of the project according to business requirements using SQL Server Reporting Services (SSRS).

Created ETL/SSIS package to import and export data from Excel, CSV, XML and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.

Performed complex queries, triggers and stored procedures, views and user defined function and updated Database Statistics and Re-indexing.

Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard and improved data load performance by analyzing database design and query plans.

Responsible for the deployment of the reports on the reporting services website and created subscription for the windows file share.

Responsible for the Performance tuning and optimization with the use of the Query Analyzer and Database Engine Tuning Wizard.

Implemented three-layer securities for the reports in SSRS website and in the Intranet web application.

Environment: MS SQL Server 2008R2, SSIS, SSRS, SSAS, MS Server Integration services, T-SQL, Visual Studio 2005, Erwin 7.2, MS TFS, JIRA

PRDXN, Thane, India Jul 2014-Aug 2016

SQL(SSRS/SSIS) Developer

PRDXN is a software company providing services to various SMEs. My role with PRDXN involved with creating SSIS packages to support reporting capabilities. I was also involved in migrating old SSRS reports to interactive dashboards in power bi to deploy in Power BI service.

Roles & responsibilities

Created SQL scripts to insert/update and delete data in MS SQL database.

Created database tables, wrote stored procedures to update and clean the old data.

Design and created different ETL packages using SSIS and transformed data from Oracle sources to MS SQL

Created SSIS package to import and export data from Excel, XML and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.

Created automated stored procedures for day end operations using SQL Server Agent and modified data driven subscriptions, fine-tuning subscription execution.

Worked with the source systems SME to understand the data and properly structuring of data for Power BI reporting. Worked with Subject Matter experts to gain an understanding of the data to properly use relationship between tables and views.

Identified and worked with parameters for parameterized reports in SSRS 2005/2008 and used SSIS import/export wizard for performing the ETL operation.

Created crosstab, drill-down, drill-through and sub-report RDL (Reporting Definition Language). Promoted RDLs to reporting service server and have written queries for the drill down reports.

Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.

Performed database transfers and query tune-ups, integrity verification, data cleaning, analysis interpretation and optimization for faster retrieval of data and improved sever efficiency.

Involved in designing, building the dimensions, cubes with star schema and snowflake using SQL Server Analysis Services (SSAS) for analyzing purpose.

Created calculated members and KPI’s to enhance the functionality of the cube.

Worked on SSIS packages, import and export wizard for transferring data from heterogeneous database (DB2, text files and excel files) to SQL Server.

Configured dimensions, and measures groups using SQL Server Analysis Services.

Improved productivity of the technical teams through facilitating creativity and empowerment.

Participated in preparing Test Plans. Wrote test cases and clear bug reports for developers and ensured testers did the same. Logged defects in Defect Manager, monitoring their status and tracking them to closure using JIRA.

Assisted CRM team when working with developers and implementation partners to understand the designs and validate that the software solution will satisfy the business needs.

Ensured Change status, progress and issues are communicated to the appropriate groups.

Audits and manages the process lifecycle and reports to upper management

Performed Change related activities documented in the Change Request to ensure the Change is implemented according to plan.

Environment: MS SQL Server 2000/2005, Query Analyzer, MS Excel, Enterprise Manager, MS Visio 2005, JavaScript, Oracle 11g, Tableau, PowerBI

AL Kamar HLS, Mumbai, India Jan 2013-May 2014

IT Analyst

My Job here was to set up, test and configure networks, desktops, laptops and printers. Assisting project team in planning, troubleshooting, testing, training and understanding PC based software. Also assisting assigned departments with their information needs and escalating for resources to management.

Roles & responsibilities.

Served as the primary Microsoft network maintenance contact for operations team.

Organized sequential set-by-step shutdown of every application within the Data Centre of the Company, to help the maintenance team to conduct maintenance over the weekend.

Coordinated solutions with various Subject Matter Experts, utilizing their expertise to analyse, investigate and diagnosis root cause, as well as provide corrective actions to improve service and successfully manage risk.

Worked on HP Service Manager and collaborated with maintenance team using tools like Jira, Asana.

Conducted management meeting and ensured customer sign off prior to incident resolution. Worked on customer feedback as part of continuous process improvement.

Performed database transfers and query tune-ups, integrity verification, data cleaning, analysis interpretation and optimization for faster retrieval of data and improved sever efficiency.

Installed, repaired and maintained multi-vendor systems which includes DELL, HP and MAC

Maintained the day to day clear case environment, including monitoring all system logs for errors and responding to reported issues.

Reviewed test results to ensure application comply with system requirements and successfully deployed the finished product.

Hands on Mobile Device configuration and deployment

Windows 7 Desktop Deployment using pre-built images and bring up systems from scratch

Configured and maintained all Wi-Fi Access Points and Routers

Environment: ServiceNow, JIRA, HP service manager, Asana, WireShark, Putty, Remedy

Education: Master’s in computer science from University of Bridgeport

Contact this candidate