Summary

• *+ years of experience in database administration, production support, design, development, and implementation using MS SQL Server.

• Good experience in the Software Development Life Cycle (SDLC) methodologies like Agile.

• Actively used Joint Application Development (JAD) and Rapid Application Development (RAD) sessions with Business users, SME’s and Stake holders alike in gathering requirements and analyzing them to identify the real business need and facilitating the development of a customized solution which delivers maximum cost and usability benefit to the client and company.

• Having good knowledge of configuring Grid OEM and Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.

• Knowledge of Designing Dashboards, Data Visualization and reports using Ms Power BI, and Tableau.

• Good knowledge of maintaining database roles, users using security compliance auditing, expertise in loading data from flat files using SQL loader, and external table.

• Relevant exposure to business process data modeling, business analytics, including data warehousing and business intelligence tool and technology.

• Good knowledge of Data modelling skills including Star Schema and Snow - Flake models, Fact Tables, Dimensional Tables and E-R modelling, Dimensional modelling.

• Experience with Data Analytics, Data Reporting, Ad-hoc Reporting, Graphs, Scales, PivotTables and OLAP reporting.

• Experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau and other BI technologies.

• Involved in Data modeling, logical and physical database designs, and worked as an on-call support team member for administering OLTP production databases.

• Used TOAD for ERWIN as tools to manage databases.

• Good knowledge in Tuning SQL queries, T-SQL, and PL/SQL queries & improving the performance of the Database.

• Prepared flow charts, database ER diagrams using diagramming tools like Microsoft Visio.

• Planned and implemented Oracle and Standby Databases Data Guard for High Availability and Disaster Recovery DR.

• Good knowledge of upgrading the database from oracle and migration of the databases using a transportable database, tablespaces export/import, data pump utilities.

• Knowledge of creating DB links across databases and performed advanced replications using Oracle Streams and Golden Gate.

• Designed and implemented centralized backups and recovery strategies using recovery manager RMAN.

• Working knowledge in Reporting Services (SSRS) and Integration Services (SSIS).

• As part of the project wih the team I was involved in integrating Salesforce system with back-office system to support Orders and Payments processing.

• Good knowledge in Creating Salesforce accounts for new clients who were being on boarded into the company.

• Knowledge in Migrating portals with Hr. benefit documents into Salesforce.

• Knowledge in Configured and managed various AWS Services including EC2, Redshift, and S3.

• Good Knowledge in developing different Statistical, Text Analytics, Data Mining solutions to various business generating and problem data visualizations using Python and Tableau Design and development of Data warehouse for Business Intelligence data marts and reporting.

• Proficient in developing different Statistical, Text Analytics, Data Mining solutions to various business generating and problem data visualizations using Python, R, and Tableau.

• Working knowledge on several python packages like NumPy, pandas, and PyTables Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions for the company.

Siddhesh Sawant

Data Analyst/Database Administrator

Phone

504-***-****

Email

adjwoi@r.postjobfree.com

Address

MD, 21227

• Hands-on experience using various Operating Systems like Windows and Linux.

• Good knowledge of MS office (MS Excel, MS Word).

• Good communicative, interpersonal, intuitive, analysis, leadership skills, a quick starter with the ability to master and apply new concepts.

Skills

MS SQL Server, AWS, EC2, S3, Redshift, SQL, PL/SQL, T-SQL, RMAN, Oracle, SQL, MySQL, Grid Control, DB, Oracle Grid control, Golden Gate, OEM,Tableau, Power BI, SQL Loader, OLAP, OLTP, TOAD, Erwin, MS Visio, MS Word, MS Excel, SSRS, SSIS, Windows, Linux, Python

Education

Master of Science in Information Systems

University of Maryland, Baltimore County

Professional Experience

Progressive Corporation, MD Jan 2020 - Current

Roles: Data Analyst

Responsibilities:

• Configured, Installed, and Maintained SQL Server in development, test, and production environment.

• Created monitoring scripts to send alerts in case standby is out of sync.

• Worked with Developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.

• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.

• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.

• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures, and User-Defined Functions depending on the Requirements Using T-SQL.

• Developed data visualizations and dashboards using Power BI and Tableau.

• Created Star Schemas for BI applications.

• Day to day troubleshooting like adding space in data files, rebuilding indexes, check the alert log file, and monitoring the system.

• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.

• Designed and implemented data models and reports in Power BI to help clients analyze data to identify market trends, competition and customer behavior.

• Data wrangling to clean, transform, and reshape the data utilizing NumPy and Pandas library.

• Handled Logical Data and Index partitioning for large tables in SQL Server.

• Migrated MySQL databases to SQL Server.

• Well worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

• Ability to write and optimize diverse SQL queries, working knowledge of RDBMS like SQL Server, PostgreSQL, and MySQL.

• Good Knowledge of Salesforce to Create Roles, Profiles, Email Templates, Page Layouts, Workflows, Workflow Actions and Approval Process.

• Imported the customer data into Python using Pandas libraries and performed various data analysis- found patterns in data which helped in key decisions for the company.

• Designed and implement the data loading ETL and publishing processes within the Data Warehouse/BI environment.

• Translated project requirements into functional and non-functional specifications for BI reports and applications.

• Designing and developing data warehouse and RedShift BI based solutions.

• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export, or export of just the structure of schema objects.

• Utilized Tableau and custom SQL features to create dashboards and identify correlation.

• Used JIRA and Git for version control in the project management.

• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views.

• Implemented hot backups and recovery procedures using recovery manager.

• Creating logical and physical database design as per application requirement with E/R models and normalization using Erwin Data Modeler.

• Installed the application on AWS EC2 instances and configured the storage on S3 buckets.

• Responsible for setting and managing User Management, Space management Granting required privileges to users.

• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements.

Environment: T-SQL, SQL Server, MySQL, Erwin, Power BI, Tableau, ETL, SSIS, SSRS, AWS, EC2, S3, RedShift. Draxo Infotech, India May 2016 – Dec 2018

Roles: Database Administrator

Responsibilities:

• Worked with application teams in preparing database design using TOAD Data Modeler.

• Involved in Configuration and maintenance of Standby databases for High availability using Oracle Data Guard for one of the critical applications at the Enterprise level.

• Scheduled Automatic refresh and scheduling refresh in Power BI services.

• Routine Database Administration tasks such as Space Management, User Creation and Maintenance, Upgrades, and Patches.

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line and Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.

• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

• Worked in Oracle 10g/11g RAC environment and troubleshooting for RAC issues.

• Assisted Supply chain analysts with automating reporting functionality using Power BI tools, Power BI reporting, Dashboards & Scorecards (KPI), and MySQL & Data warehouse data sources.

• Developed Data Migration and Cleansing rules for the Integration Architecture.

• Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation.

• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.

• Writing T-SQL code for stored procedures, managing tasks and meeting deadlines in response to ad-hoc requests.

• Defined and implemented the required business transformation rules and logic (ETL development).

• Develop database Backup and Recovery and Disaster recovery strategies scheduling full and incremental backups using RMAN.

• Defined environment variables and tuned parameters for fine - tuning of ETL jobs.

• Performed database migration from DB2 to Oracle database.

• Generate high-level test scenarios for testing each phase and then wrote descriptive test cases for each phase and logged defects in JIRA.

• Providing DBA support for the Production environment, which involves Database tuning such as Oracle Stored Procedures/Functions/Packages optimization using advanced PL/SQL features and dynamic SQL.

• Deliver Enterprise Data Governance, Data Quality, Metadata, and ETL solution.

• Implement, Maintain, and test backup and recovery strategies and extensively used Oracle Enterprise Manager

(OEM) for various maintenance tasks like a backup of databases, restoration, and recovery of the database, troubleshooting performance-related issues.

• Database management by creating schemas, tablespaces, partitions, indexes, and coding in PL/SQL and T-SQL packages, procedures, functions, and triggers.

• Performed Data Modeling using Erwin tool, Designed and implemented logical and physical database.

• Exported the data required information to RDBMS using database to make the data available for the claims processing team to assist in processing a claim based on the data. Environment: Oracle, TOAD, RAC, Oracle Data Pump, RMAN, Oracle Data Guard, ETL, Power BI, Tableau, SQL, PL/SQL, T-SQL, RDBMS, DB2.

Contact this candidate