Continuous Integration and Continuous Delivery (CI/CD),Star Schema and dimensional modelling ,Entity-Relationship Concept, Facts & Dimensions Tables and Slowly Changing Dimensions (SCD), ETL, Data Quality Management (DQM) covering Data Profiling, Data Cleansing and GitHub. AB Job , Air Flow ,Amazon S3 · Microsoft SQL Server, Data Engineering · AWS Data bricks ·Amazon Web Services (AWS)

•Mining data on social network website in phase like Collecting Data, Text Pre-processing, Term Frequencies, Data Visualization, Sentiment Analysis, Geo location and Interactive Maps.•Used different Algorithm Logistic Regression, Decision trees, Logistic Regression & SVM for data analysis.•Used different Python packages in project NumPy, Pandas, Matplotlib, SciKit-Learn, Scrapy.•Extensive knowledge of Tableau in various reporting objects like attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters.

•Incorporated many rich, user friendly, responsive features in the application using SSIS, SSRS, SQL, ETL, Data Quality Management (DQM) covering Data Profiling, Data Cleansing, GitHub and Tableau.•Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.•Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL).•Worked with project lead and business users to understand fraud processes, gathered and documented requirements and translated them into ETL Design Specifications.•Worked with project lead and business users to understand fraud processes, gathered and documented requirements and translated them into ETL Design Specifications.•Extensive knowledge of Tableau in various reporting objects like attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters.•Optimized existing Store Procedure by monitoring through SQL Profiler, and Query Analyzer.•Used the transformations such as Merge, Data Conversion, Conditional Split and Multicast to distribute and manipulate data to the destination in SSIS.•Redesign the existing design to build a better performing ETL, job automation and reporting solution.•Optimizing the database by creating various Clustered, Non-clustered indexes.

Online Bookstore, a Web-based bookseller projects that acts as a central database containing various books in stock along with their title, author and cost.The SQL database stores various book related details. By use of store procedure, trigger, cursor, T-Sql, use recursive query, Logs error information in the dbo.ErrorLog and written nested query.

Exploring Organizational Needs for Improved User Authentication Systems, Password Alternative in real world.Used Python, Machine Learning & SQL as data source to analysis alternative of password on different age group.

Permits and InspectionsProject descriptionCapture Permits and Inspections is designed to assist with office procedures for issuing, filing, and tracking permits as well as requesting and completing inspections. Capture allows office staff, inspectors, and chief examiners to share the same body of knowledge, reduce data entry, and provide better service to their customers. Notifications of all types can be sent within and outside of the office for improved communication. Capture is unique in that it is completely Web-based, allowing users to retrieve and update information from the office, at home, on site, or on the road.

Project: Customer Relationship Management• Testing the applications and websites on different web browsers to ensure a standard user experience for the clients across all platforms.• Developed core functionality with the ASP.NET Implementation of client-side validations using ASP.NET Validation Controls.