Divya Netha Ramdas Email & Phone Number

Vancouver, Bc, Ca

Vancouver, British Columbia, Canada

• Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.), maintaining Table spaces and CRD files• Gather and document key requirements for analytical reports and contribute to data mapping sessions to understand business needs. • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end• Develop and maintain exceptional database on SQL server • Develop, implement and optimize stored procedures and functions using T-SQL• Analyze and interpret ongoing business report requirements• Build appropriate and useful reporting deliverables• Analyze existing SQL queries for performance improvements and suggest new queries• Develop procedures and scripts for data migration• Experienced in installing and maintaining MS SQL Server 2014/2018/2019.• Involved in full database export/import, and responsible for the DBA operation• Deployed packages to SQL Server and file system in 2018/2019 and also used the new Project based Deployment introduced in 2018/2019 SQL Server Data Tools (SSDT) to deploy the 2018/2019 packages.• Created and maintained database mapping document which mapped the old tables to the new ones.• Developed stored procedures, user-defined functions, triggers, indexes and views.• Involved in query optimization for faster processing of queries.• Used Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports

India

• Study and understand the requirements of the information required by company's Procurement.• Migration of large scale databases from oracle to sql.• Troubleshooting and debugging queries. • Support handling SQL tasks by collaborating with the team members.• Designed T-SQL scripts to identify long running queries and blocking sessions. • Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions. • Data migration (import & export - BCP) from Text to SQL Server. • Error handling using Try-Catch Block. • Normalization and De-Normalization of tables.• Developed Backup and Restore scripts for SQL Server 2005. • Installed and Configured SQL Server 2005 with latest service packs. • Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions. • Written T-SQL queries for the retrieval of the data.

India

• Good working knowledge of MS-Office, Tally ERP 9.• Hands on experience in manual Vouching, Billing, Debit / Credit Entries, Cash Book, Ledgers, Bank Reconciliation, Income Tax, GST, VAT, Central Excise, Service Tax, PF, ESIC, Insurance • Experience in e-filing of their returns, Wages, Gratuity, Bonus, Trading, P and L, Balance Sheet, Inventory etc in a manufacturing unit independently.• Knowledge of Tally Receipt entries, Payment Entries.• Handling day to day transactions• Taking care of Purchase , sales and journal entries• Working on daily bank Reconcilations.• Handling of bank and cash payments.• Perform E- invoicing and E- waybill (Inward and Outward)• Maintaining the day to day Records/ filing.• Weekly and monthly reporting.• Calculation of GST, online payment & return filing• Good knowledge and experience in Tally ERP 9.0 and MS Office(Specially Excel).• Assist senior accountants in the preparation of monthly/yearly closings