o Created Database in Microsoft Access by using blank database and created tables and entered dataset manually and Data Types, performed ER Diagram and Basic SQL Queries on that database.o Microsoft Excel used for formatting data as a table, visualization and analyzing data by using certain methods like Conditional Formatting, Remove Duplicates, Pivot and Unpivot tables, Created Charts and Sort and Filter Data Seto Used SQL and SQL Server for writing simple and complex queries like finding Distinct Values and Unique Values in a Data set.o Wrote application code to do SQL queries in MySQL to organize useful information based on the business requirements.o Applied concepts of probability, distribution and statistical inference on given dataset to unearth interesting findings through use of comparison, T-test, F-test, R-squared, P-value etc.o Performed Statistical Analysis and Hypothesis Testing in Excel by using Data Analysis Tool.o Analyzed the partitioned and bucketed data and computed various metrics for reporting.o Integrated data from disparate sources, mined large data sets to identify patterns using predictive and prescriptive analytics.o Conducted intermediate and advanced statistical analysis, such as linear regression, time-series analysis, classification models, and forecasting future sales.o Created Entity Relationship Diagrams and Data mapping for better understanding of dataset.o Data Gathering and analyzing data, creates intelligent reports.o Interacted with the other departments to understand and identify data needs and requirements and work with other members of the IT organization to deliver data visualization and reporting solutions to address those needs

o All phases of the Project Development from Project Kickoffs, requirements gathering (Functional and Database), Testing (System and UAT) for new projects and existing projects.o Gathered, documented, and communicated business requirements into systems design documentation using Business-Modeling concepts.o Database maintenance, checking the database for any flaws and cleaning the database and help maintaining the correct data.o Identified requirements of data Projects, including defining the Database requirements, defining table structure, database relationships.o Gathered data from different servers using the PYTHON and made them easily readable.o Conducted meetings for the initial project kickoff.o Closely worked with Business users in gathering requirements, acceptance criteria and helped business users in setting up the environment for UAT testing.o Used JAVA for writing complex scripts in order to make the clients work easy and fast.o Expertise in maintaining Agile tools like JIRA, RALLY and making sure the user stories move.o Closely working with Team members and leading them in Sprint Planning and efficiently breaking the epics to user story level and assigning to developers based on skill set.o Take Full Backup, Transaction log backup & amp; differential backup and Restore UAT and Production databases through SQL Server Agent Job.o Scheduling SQL Server Jobs with SQL Agent.

o Created an excellent data dictionary using Excel.o Involved in Requirement Gathering, analysis of the requirements from the business owners and users.o Gathering requirements and creating User specification, Functional specification and technical specificationo Performed data mapping and mapping documents.o Performed documentation on process involved in processing of data.o Performed Data validation and testing using SQL codes on Oracle database.o Created complex charts and tables using Grafana for different products.o Analyzed data covariance, reliability by using R and created appropriate data models.o Created, Use Case diagrams for process documentations.o High level reporting on the database using excel and Hyperion.o Basic reporting using Business Objects.o Create stored procedures, functions, scripts and triggers with extensive use of T-SQL programming.o Provide data analysis on legacy client databases.o Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

o Gathered and translated Business requirements into detailed production-level technical specifications.o Resolved the revolving issues by conducting and participating in JAD sessions with Business analysts and developers.o Responsible for large business decisions by providing valid arguments and solutions for complex business problems.o Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.o Responsible for understanding design and structure of different databases. Also involved in writing ad-hoc queries for data mining.o Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.o Collaborated with Business teams in the creation of the Functional Design document and Source to Target Mapping document.o Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.