shaik mussarathulla

Project Summary
Fraud attempts have seen a drastic increase in recent years, making fraud detection more important than ever. Despite efforts on the part of the affected organization, hundreds of millions of dollars are lost to customers every year.

The project goal is to protect valuable customer data and accounts from disclosure and misuse through tools, systems, agents, processes and other areas within the CSS domain. The main aim of the project to find the fraudulent activities where an agent involves in providing the valuable information like “Coupon code, Five-by-Five tokes, Subscription Keys, Promo-Codes, Credit-Card Info etc.” to Customers without any proper Incident mapped to each request. The system is having many tools where an Agent have access to assist customers with their issues.

The source data coming from “Cosmos” (Microsoft's internal Bigdata Analysis Platform) and “On-Premise” servers. Post process data from each tool will go to “XIN (XBOX Investigation)” Team which will monitor the Fraudulent Data and takes necessary actions accordingly which interns takes help of FBI

Project Summary
The objective of this project is to design and build a data warehouse for the company. The job is to develop, implement and maintain all databases including stored procedures and complex queries, which include the administration of various databases production environments for different clients.

Epsilon digital marketing data helps brands understand customers and connect with them on a deeper level. Epsilon help brands use MARKETING data to understand their customers' lifestyles, behaviors, so they can connect with them on a deeper level.
The data includes in the source files are subscribers and non-subscribers on particular date and also with different activities like open, click, forward, delete, bounce back, sent, non-deliver, sub/un sub for the campaigns etc. There will be multiple deployments of campaign mailings to the subscribed users for their respective brands. The system has different level of subscribers like client level, site level, campaign, task level. As per the subscription level the subscribers will be mailed.
Epsilon includes building SSIS packages for Data staging, by getting data from huge sized flat files (Comma separated files) from multiple clients into Sql Database and Data transformation is done after getting data into database according to Client requirements like Conversation of data types, removing duplicates

SQL Server 2008, SSIS, SSRS Developer
Responsibilities

•Responsible for Monitoring and Audit issues as per Standards.
•Handling the SQL Server Jobs and working on the failure Jobs.
•Designed SSIS packages to extract the data from flat files which are zipped to SQL Server 2008.
•Handling the ftp server and Sftp servers to load and to pull the flat files.
•Experienced in programming tasks-Stored Procedures, Cursors, CTE using SQL Server 2008 with T-SQL.
•Scheduling and monitoring the ETL packages for daily load in Sql Server job Agent.
•To develop audit process for each ETL package which stores all the package information like On Error, Execution date, Parent package, start date, end date.
•Resolving incoming tickets, including extensive troubleshooting and debugging, with responsibilities covering multiple product lines in all applications.
•Altering the Sql scripts, modify the SSIS Packages and SSRS Report’s logics for the change requests raised by User(s) or Client(s).
•Involved in preparing the Risk and Impact documentation and writing the test cases for the further references when we are providing the solutions for the change requests

SQL Server 2008, SSIS, SSRS
Responsibilities

•Involved in designing & implementing the complete database on SQL Server 2008.
•Written Procedures, Queries, Functions based on the requirement.
•Designed SSIS packages to extract the data from MySQL to SQL Server 2008.
•Integrated the Logging & Error Handling architecture in the Packages Reporting management
•Created different types of SSRS reports in the project i.e., (matrix, tablix, graphical etc) with different interactive features like (drill down, drill through, actions, sub reports etc).
•Involved in creating the linked reports in report manager

Fraud Detection BI

Expert in creating scalable, fault-tolerant data pipeline that cleans, transforms and aggregates unorganized messy data from heterogeneous sources to Data Warehouse.
•Worked in creation of ETL mappings and Transformation to reflect business rules using SQL Server Integration Services to move data from multiple sources into target area.
•Strong Technical experience in SQL SERVER (T-SQL), SSIS, SSRS, SSAS and Data warehousing concepts.
•Experience in Azure Data Tools and Microsoft Power BI.
•Excellent problem solving, analytical, interpersonal skills and ability to perform independently and as part of a team.
•Experience in Requirement Analysis, Development, Testing and Implementation phases of Data Warehousing using Microsoft Business Intelligence.
•Experience in creating/maintaining various documents like Data Dictionary, Functional Specification, ETL Data Mapping, ETL Data Process, Unit Test Case, DQ (Data Quality) Check List Documents for each ETL/Report in the project.
•Worked on Big Data Analytic with Petabyte data volumes on Microsoft\’s Big Data platform COSMOS & SCOPE Scripting.
•Good knowledge in loading the Cosmos files to SQL Server tables using SQLizer Tool.
•Knowledge in using Cloud based managed services for data warehousing/analytics in Microsoft Azure (Data Lake Analytics, Storage, Tables, U-SQL).
•Knowledge on different third-party reporting tools i.e Panapticon Reporting Tool and Qlikview.

•Expertise in SQL Server 2008 /2008 R2/ 2012 / 2016
•Implemented SQL Server Stretch DB Concept to store the Cold Data into Azure Sql Server in 2016 Version.
•Implemented System Versioned Memory-Optimized Temporal Tables.
•Optimized the SQL Server Objects in the projects.
•Create database objects such as tables, views, User Defined Functions, stored procedures.
•Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
•Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.

•Expertise in SQL Server Integration Services 2008 /2008 R2 / 2014
•Used SSIS (SQL Server Integration Services) as ETL Tool for loading the data into data warehouse / Staging areas / Work Table from various source systems including Cosmos as Source.
•Defined Logging Configuration Architecture at data level.
•Implemented Error Handling mechanism and Transaction in SSIS Packages.
•Expertise in Designing the CDC architecture in projects.
•Implemented Configurations to save the sensitive data of the package.
•Expertise in improve the performance of SSIS Package.
•Expertise in optimizing the poor performing ETLS.

•Expertise in SQL Server Reporting Services 2008/2008 R2/ 2014
•Created complex analytical/interactive reports and dashboards.
•Implemented in creating interactive Matrix, Tablix reports in 2008 and 2008 R2
•Good knowledge in Report Model Creations.
•Knowledge on Data Driven Subscription in projects.
•Good knowledge in Report Manager Components.

•Expertise in SQL Server SSAS 2016 Azure Tabular Model
•Implemented dimensional modeling of Star Schema, Snow Flake Schema by the identified Fact and dimension Tables.
•Extensive use of DAX Expressions in Tabular Model as per business requirements.
•Worked on creating the cubes and modifying the cubes by adding the hierarchies, calculated columns, measures and measure groups.
•Created complex SSAS cubes with multiple Data Partitions to selectively refresh smaller subsets of data to save on processing time in terms of heavy transactional data.
•Worked on creating Schemas and Relationships.
•Worked on Hierarchies, Attribute Relationships, Dimension Usage.

•Power BI
•Implemented Power BI in various areas like Visualization Parts, DAX, Data Acquisition & Administration Part.
•Configure power bi gateway to get the incremental data from the source systems.
•Sending Alerts on Missing Dates for source system data using Microsoft Flow.
•Data Pulls using Direct Query and Import Query methods.
•Implemented Role Based Security
•Extensive use of DAX expression in Power BI model as per requirement.
•Experience in using Tabular Model as source data set to Power BI Reports/Dashboards.
•Implemented filters on objects like Visual Level, Page Level, Report Level, Drill Through.
•Query Parameter - set parameter to a column in model and allow user to select one value and create template
•Implemented Many to Many relationships in Power BI Model.

•Qlikview
•Having knowledge on optimizing the Queries and converting these queries into Qlikview script i.e QVD files.
•Connect Qlikview to multiple data sources including MS Sql server, text files.
•Implemented Qlikview Objects like Pivot Table, Straight Table, BarChart, ComboChart, LineChart, Multibox and Container.
•Implemented set analysis, what if analysis, star schema, snow flake schema.
•Getting data from Sql Server objects like views, tables.