-Collaborate with Internal & External stakeholders to manage data logistics - including data transfers, understanding data structures, business rules, etc. - to enable project execution.-Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Profiling & Identifying data inconsistency using complex SQL queries and Alteryx ETL workflows on various Source system.- Manage multiple projects concurrently and independently execute analytical projects and develop innovative, intuitive, and data-driven methods for measuring program effectiveness.-Translate business logic from others system like (SQL, Informatica workflows, *.csv/*.dat files etc.) into Alteryx by designing and developing ETL workflows and datasets in Alteryx.-Prepare technical specifications and documentation for Alteryx ETL workflows supporting various Tableau dashboards.-Worked on writing queries to source and load the data to SQL Server and Oracle databases using Alteryx-Experience in Alteryx Designer, Alteryx Server and the tools within Alteryx such as Data Investigation, Parsing and Transforms, Interface, Developer and Tableau tools.-Experience in building, publishing, scheduling Alteryx ETL and data validation Workflows.-Building the customized and interactive Tableau dashboards using multiple data sources and custom queries and data blending feature.-Preparing dashboards using action filters, calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.-Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.-Published Workbooks by creating user filters so that only appropriate teams can view it.- Responsible for Uploading and Executing SQL Scripts in Github (Version CR) for Dev/QA environments using basic UNIX commands.- Participate in Agile Scrum process to work projects from inception through deployment.Used various Agile Tools like: Jira ,Version one,mingle,kanban etc.

-Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards. - Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns,and eliminated redundant and inconsistent data.-Developed complex T-SQL code for the application conversions.- Involved in migration of data form SQL SERVER 2005 to SQL SERVER 2012.- Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.-Worked on Type-1 and Type-2 Stored Procedures in DW environment (Kimball Methodology) and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data. This entire process has been done in BIDS.-Developed Cubes using SQL Analysis Services (SSAS) and experience in extending OLAP cubes, Dimensions and data source views.- Thoroughly conducts QC work with end user or internal department assistance.- Provides second level support databases related to internal proprietary applications to internal and external clients.- Developing and Coding total systems including creating and modifying tables as need for both internal and external clients.- Analyzes and interprets data relating to internal and external reports.- Develops and enhances download and upload procedures.- Researches, installs and tests new software and hardware products and troubleshoots software and hardware problems

- Involved in interacting with Internal &External stakeholder for Extensive reporting requirements.- Interacted with business users for gathering requirements, then designing &development of Tableau visualization &Business Intelligence Solutions.-Analyzed requirements for various reports, dashboards, scorecards &created proof of concept / prototype the same using Tableau desktop 9.- Designed &developed various analytical reports from multiple data sources by blending &joining data on a single worksheet in Tableau Desktop.- Effectively used data blending, filters, actions, Hierarchies feature in Tableau Desktop 9.- Developed T-SQL Script &SSIS packages to migrate data from multiple sources.- Designed &developed SSIS Packages to import &export data from MS Excel, SQL Server 2005 &Flat files.- Have used BCP, BULK INSERT &SSMS to transfer data from &to SQL server database.- Developed Tableau Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field.- Developed reports in SSRS 2008 &2012 to replace the manual reports.- Developed complicated parameterized reports with cascading parameters, multi-value parameters &passing parameters to drill though reports.- Good Exposure to working with Tableau Functions &Expression Scripts &Streamlining Reporting operations of Tableau Applications- Involved in all phases of the project (Documentation, Designing, Unit testing &Defect fixing).- Develop MIS system for management, Clients &internal communication. - Made use of the aggregated tables on the most frequently queried data for Monthly &Yearly based report.- Procedural standardization &automation reduced reporting time, increased accuracy &made critical information accessible to a wider audience- Created SSIS Packages using SSIS Designer for importing data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.- Various ETL Transformation tools were used for Control Flow &Data Flow tasks.

- Designed and developed Fraud Prevention and Loss Score Card Application using extensive T-SQL, SSIS and SSRS.- Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS- Extensively used SQL Joins and sub-queries for complex queries involving multiple tables from different databases.- Automated, Scheduled and delivered reports based on the specified timetable (Daily, Weekly, Monthly) using Advanced T-SQL, SSIS, SSRS.- Providing high level strategic, analytical direction and vision across departments.- Create reports which combine data from multiple data sources.- Design, create, implement, modify, maintain and support existing reports.- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.- Work with management and subject matter experts to help define new reporting requirements.- Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.- Automated Fraud Departments Reporting structure up to 75% using extensive T_SQL, SSRS and SSIS.- Supporting LATAM Client with all their Reporting Requirements and Predictive Modelling structure using ETL and T-SQL- Co-ordinated with the Business users for the UAT testing.- Created Reports using combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports.- Worked on very tight deadlines and aggressively for the completion of the Project

- Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.- Direct contributor to launch of 39 clients on proprietary risk analysis management platform, resulting in annualized $2M prevention savings.- Design/ Developed first fraud Dashboard used for the Pre- RAMP Launches & dealer Analysis based on Model, Perils, and fulfillment method etc. based on “Trend Analysis” using Advanced SQL.- Strategic contributor of Fraud Management business requirements for fraud prevention platform within the company's newly developed claims processing software; fraud attributes and rules engine logic, workflow and notifications processes.- Improved department performance in identifying fraudulent activity by leading mentoring sessions and automating reporting structure; project resulted in over $500k in savings from fraud usage and a decreased time spent per account by 24%.- Perform forensic data analysis & data mining using T-SQL and SSIS to identify patterns of suspicious activity, outliers, anomalies &other issues that represent fraud risk- Provided data analytics that facilitated process improvements & systems upgrades to enhance performance.- Designed and developed new Logistics return Data mart which helps Fraud Team evaluate if any return was done for a claim fulfilled under Damaged, Defective type.- Worked with Various Departments like Account Management, Business Analytics/Intelligence, Billing and Logistics Department to finalize KPI's for Fraud Dashboard.- Created Negative database to serve as a repository, decreasing manual entry hours by 8 to 10 hours.- Developed reports utilizing database reporting tools, including year-to-date analysis on Claims, deductions, gap analysis- Completed & analyzed weekly reports used to determine fraud analysts’ knowledge gaps & educational needs; provided coaching and training to improve results