MOHAMMED AZEEMUDDIN

Phone:-224-***-****

E-Mail: ac7yji@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 7 years of extensive experience working with MSBI/Power BI and T-SQL using SQL Server 2008R2/2012/2014/2016.

Worked in different domains like HealthCare, Insurance and Banking Organizations developing IT applications. Experienced working with agile methodology involving in Analysis, Design and Development of MSBI solutions.

Expert in Understanding the Technical Specification and creating and modifying the SSIS packages according to the Business requirements. Experienced working with Database Architecture for Design and Development of Data models and Data warehouse

Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.

Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.

Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R2/2012

Developed and maintained SSIS packages to integrate with different type of sources such as SQL Servers, Oracle, flat files, and non-SQL sources.

Good Knowledge of Normalization, Performance Tuning, Development Life Cycle and Version Control tools while Design and Development of Data warehouse

Developed and maintained tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax.

Worked on different C# scripts to Automate SSIS packages to load the data directly to the staging data base.

Configured Check Points, Break points, Event Handlers and Logging to the SSIS packages.

Proficient in creating Stored Procedures, Views, Functions and Triggers in T-SQL for designing and Developing SSIS packages.

Worked on change requests, identifying the defects and working on resolution, processing on SSIS Packages.

Experience in Developing and Extending SSAS Cubes, Building the Dimensions, Deploying, Processing SSAS objects, Cubes with Snow Flake Schemas and Star Schema using SQL Server Analysis Services (SSAS)

Dimensions and Calculated Measures, Partitioning and building MDX queries.

Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.

Highly skilled in developing OLAP cubes using SSAS measures, measure groups and dimension members in SQL Server Analysis Services using Dynamic Analysis expression (DAX), mathematical formulae, and user-defined functions.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS. Developed the SSAS 2012 Tabular model reports from Data warehouse using SSDT.

Excellent hands on experience in creating groups and measures, KPIs.

Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.

Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Responsible for building reports in Power BI from the Scratch.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Experience on publishing Power BI reports on dashboards in Power BI server.

Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.

Worked with both live and import data in to Power BI for creating reports.

Managed relationship between tables in Power BI using star schema.

Used different type of slicers available in Power BI for creating reports.

Education:

Bachelors in science, Osmania University, India, 2010

Technical Skills:

Data Warehousing & BI

SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools

SSRS 2014/2012/2008/, Excel, Tableau, Power BI.

Database

MS SQL Server 2014/2008/2005, MS-ACCESS.

Programming

C, C++, TSQL.

IT Processes

Software Development Life Cycle (SDLC), Project Management

Productivity Applications

MS Word, MS Excel, MS Access, MS Project, Visio

Operating System

Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers

Microsoft IIS 6.0/5.0/4.0, Apache.

Professional Experience:

American Automobile Association (AAA) -Mount Laurel, NJ March 2018 to till date

SQL/SSAS/Power BI Developer

Responsibilities

Designed and developed stored procedures, queries and views as necessary. Extensively use joints and sub-queries for complex queries which were involving multiple tables from different databases.

Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop

Developed and implemented several types of Financial Reports by using SSRS. Validated reports and resolve issues in a timely manner.

Scheduled Automatic refresh and scheduling refresh in Power BI service.

Created Credit Risk Financial Models.

Worked on analyzing Charge Backs to decrease costs and increase efficiency using Power BI .

Migrated existing self-service reports and ad-hoc reports to Power BI.

Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using SSRS.

Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques

Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization.

Identified various parameters to improve the existing data models for approving credit cards and line increases to individuals.

Environment: SQL Server 2012, Power BI, MS SQL Server Management Studio, SSRS, T-SQL, Visual Studio, Angoss, Excel.

InVentiv Health, Princeton, NJ March 2017 to Feb2018

SQL/SSAS/Power BI Developer

InVentiv Health Incorporated is an American multinational, and one of the largest contract research organization (CRO), based in Burlington, Massachusetts. It is a wholly owned subsidiary of Inventive Holdings Group based in Somerset, New Jersey. The company provides services to the pharmaceutical, biotechnology and medical device industries, including consulting, clinical studies and market launch.

Responsibilities:

Having Experience on Microsoft Power BI (Desktop, Service, Mobile)

Database performance tuning Built and published customized interactive dashboards utilizing Power BI.

Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.

Developed and rendered monthly, weekly and Daily reports as per the requirement and gave Roles, user access with respect to security in report manager

Created OLAP cubes, facts and dimensions for the analysis of sales in different locations and Process data from data mart using SSAS.

Involved in building the dimensions, cubes with star schema and snow flake schema using SSAS.

Developed Tabular Model infrastructure in SSAS for various Lines of Business and created over different interactive Dashboards using various visualizations in Power BI Desktop.

Created multiple dimensions, perspectives, hierarchies, and dynamic measures (DAX) to analyze performances of each KPI.

Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS Database.

Used MDX to create custom groupings, parameters, named sets, main reports and sub-reports. Also for creating reports with line and pie charts included.

Experienced in developing power BI Reports and Dashboards from multiple data sources using Data Blending.

Explore data in a Variety of ways and across multiple visualizations using Power BI.

Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.

Created new measures and new calculated columns for reports and dashboard analysis.

Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).

Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) In Power BI according to the requirements

Published reports and dashboards to the Power BI service through the Office 365 integration.

Shared the dashboards among multiple users in the group.

Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).

Used agile development Methodology.

Implemented dashboards and scorecards with power pivot for executive management for data insights as per Business requirements.

Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.

Environment: MS SQL Server 2016/2014/2012/2008R2, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7

ADVANCED HEALTH MEDIA, New Providence, NJ March 2016 to February 2017

MSBI Developer

ADVANCED HEALTH MEDIA healthcare system based in New Jersey that serves more than two million people each year from throughout the Greater New York Area, metro area and beyond. The project involved the creation of SSIS packages, modification of existing packages and developing dashboard/reports requested. This involves creation of data mart from different data sources and development of reports on top of it.

Responsibilities:

•Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.

•Worked with Business Analysts in gathering requirements and translating them to technical specifications.

•Developed Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.

•Optimized the database by creating various clustered, non-clustered indexes and indexed views.

•Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

•Used Joins, CTE's, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and Stored Procedures and enforced business rules via checks and constraints.

•Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration services (SSIS)

•Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

•Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SSIS.

•Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.

•Developed SSAS OLAP Cubes and Partitioning Cubes.

•Wrote DAX queries to retrieve data from OLAP (SSAS) cubes.

•Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

•Created jobs for automatically running Stored Procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports.

•Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.

•Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.

•Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

•Designed SSRS reports with dynamic sorting, defining data source and subtotals for the report.

•Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and formatting them using both SSRS.

Environment: Windows 2003 Server/XP, SQL Server 2012/2008/2005, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008/2005, Team foundation Server, Tableau, VB.NET, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

State Farm Insurance, Bloomington IL May 2015 to February 2016

SSIS/SSRS Developer

This project deals with the integration of large sets of data related to Property and Causality Insurance. It deals with consumer’s data and frame data warehouse to provide reports on financial calculations according to client requirements.

Responsibilities:

Worked with Development Teams, Business community, Project stakeholders and Managers to understand analyze end-to- end business application needs.

Designed SSIS flow to pull source data into staging to perform data quality and cleansing before pushing into target database.

Worked with different transformations like fuzzy grouping, fuzzy lookup and row count Transformations for cleansing the customer data.

Created SSIS packages to validate, extract, transform and load data from Excel and other sources and legacy systems to the required IEV format.

Used Execute SQL Task for processing SQL statements for cleaning the data and inserting the new data to the ODS.

Validating and comparing the data in the source file and ODS file before storing to the data warehouse.

Implemented Stored Procedures, variables, parameters and Connection Managers in SSIS package.

Performed ETL Operations Event Handlers, Check points, Break points and Transactions to SSIS Package.

Created and managed operations to support the incremental, historical data loads and transformations using SSIS.

Developed various types of Reports like Tabular Reports and Drill Down reports using SSRS.

Developed Cascading, Parameterized and Sub reports using variables and expressions for the business users.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.

Created Dashboards using Tableau Dashboard and prepared user stories to create compelling Dashboards to deliver actionable insights.

Environment: MS SQL server 2014, Microsoft SQL Server Management Studio (SSMS), T-SQL, SQL Server Data Tools (SSDT), Microsoft Visual Studio 2010 for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), Tableau and MS Excel

BANK OF AMERICA, DALLAS, TX November 2012 to April 2015

SQL/BI Developer

Responsibilities:

Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).

Defined the report layout in SSRS. Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.

Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.

Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).

Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.

Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.

Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.

Generated daily, weekly and monthly reports for the managers.

Designed and created OLAP cubes on data warehouse.

Designed a partitioning strategy to refresh cubes effectively.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.

Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.

Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.

Involved in extracting the data using SSIS from OLTP to OLAP.

Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.

Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.

Design web based resource areas in collaboration with IT guidelines.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, TFS, T-SQL, XML, MS Excel, Erwin, Visual Studio.

Axis Bank, India July 2010 to August 2012

MS SQL Server Developer

Responsibilities:

Worked as a developer on databases like MS SQL Server 2005, MS Access.

Tested to optimize the Stored Procedures and Triggers to be used in production.

Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.

Designed and implemented the Logical and Physical model of the database using Erwin.

Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.

Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.

Worked in Enterprise Manager for job scheduling and batch queries.

Installed and maintained MS SQL Server 2005.

Monitored performance and optimized SQL queries for maximum efficiency.

Created Custom ETL packages using SSIS 2005 and develops and unit test SSIS load processes for performance check.

Created and scheduled SQL jobs to run SSIS packages daily.

Involved in usage of various SSIS components and features like For loop, For Each loop, Lookup Transformation, Variables, Error Handling and Package Configurations.

Developed Query for generating drill down reports in SSRS 2005.

Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Maintained the consistency of the client’s Database using DBCC.

Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2000/2005, MS Access, Query Analyzer, DTS, SQL Profiler, Import & Export Data, Windows 2000 Server.

Contact this candidate