Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
AccountManager
Shally Batra

Shally Batra

Software Engineer
Noida,Utter Pradesh

Summary

To work in a creative and challenging environment where I can consistently learn and successfully deliver efficient solutions. I am confident that I can add immense value to the project and organization.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Data Scientist/Analyst

DXC Technology
Noida
05.2016 - Current
  • Developed machine learning algorithms to predict customer churn rates.
  • Collected, tracked and reviewed data to evaluate business and market trends.
  • Collaborated with IT and business process owners to enhance system requirements for analytical purposes.
  • Performed data entry, data cleaning, and data coding for analysis.
  • Utilized statistical techniques to interpret data and analyze results, providing actionable insights to stakeholders.
  • Utilized predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
  • Worked with internal teams to understand business needs and changing strategies.
  • Implemented new data analysis methodologies and data visualization techniques.
  • Provided technical support for existing reports, dashboards or other tools.
  • Developed dashboards with Tableau and Power BI to monitor key performance indicators.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Maintained documentation of all the processes related to Data Analysis.
  • Generated reports and obtained data to develop analytics on key performance and operational metrics.
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.
  • Provided data-driven solutions to support decision making.
  • Translated raw data into meaningful information using statistical techniques.
  • Built visualizations that enabled users to quickly interpret results from complex analyses.

Database Administrator

Deutsche Bank Gmbh
Germany
04.2015 - 03.2016
  • Assisted in disaster recovery planning by testing various backup strategies and scenarios.
  • Installed, configured, and maintained Oracle 11g and 12c databases on Linux servers.
  • Ensured that all the stored procedures are optimized for better performance of the system.
  • Provided technical support for developers by creating views and indexes as per their requirements.
  • Migrated existing databases from one platform to another with minimal downtime.
  • Configured user accounts, privileges, roles, profiles. in the database server.
  • Implemented data replication between two different databases using DataGuard feature of Oracle Database Server.
  • Managed multiple databases running on different platforms including Windows, Linux and UNIX systems.
  • Performed regular health checks on all databases to ensure optimal performance levels are maintained.
  • Analyzed system logs regularly to identify any potential problems or suspicious activities.
  • Monitored performance of queries and tuned them as needed using Explain Plan tool.
  • Collaborated with stakeholders to gather business requirements for enhancements and change requests.
  • Managed user access and privileges to secure sensitive data effectively.
  • Performed daily backups of the databases using RMAN utility.
  • Solved complex analytical problems using statistical models from data.
  • Optimized storage and archiving practices to manage database size and performance.
  • Supported end users in selecting, procuring and using software applications.
  • Provided technical support and training to end-users and junior DBAs.

Senior Database Administrator

Xchanging Technology India Pvt Ltd
Gurgaon
08.2010 - 03.2015
  • Wrote scripts and processes for data integration and bug fixes.
  • Detected and resolved data quality issues and discrepancies for integrity and quality control.
  • Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
  • Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
  • Created and monitored performance metrics to keep databases functioning at optimal capacity.
  • Evaluated and recommended new database technologies and tools to enhance productivity.
  • Led database migration and upgrade projects to ensure smooth transitions.
  • Managed database security, backup, and recovery procedures to safeguard information.
  • Automated routine database tasks to improve system reliability and reduce manual errors.
  • Monitored database performance and implemented changes to improve response times.
  • Collaborated with IT team to integrate databases with other applications.
  • Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.

Education

Post Graduate Diploma in Data Science and Business Analytics -

University of Texas

Masters in Computer Applications -

Kurukshetra University

Post Graduate Diploma in in Computer Applications -

Kurukshetra University

Bachelor of Arts (Hons) -

Kurukshetra University

Skills

  • Machine Learning
  • Classification/Regression/Clustering
  • Statistical Methods/Predictive Analysis
  • Basket Analysis/Text and sentiments Analytics/Natural Language Processing
  • R/Python
  • SQL/PL/SQL
  • Shell Scripting
  • SAP BODS/ Microsoft SSIS for data transformation
  • ETL development via Visual studio
  • Chabot development
  • Data Reporting tools like Tableau/Qlik view/SSRS/Power BI
  • Linux/Windows/AIX servers Administration
  • Oracle 9i/10/11g/12c/AS400/DB2 servers Management
  • Microsoft SQL servers management 2005/2008/2011/2013/2016
  • Cloud Computing with AWS services

Certification

  • Certified AWS cloud Practitioner
  • Red Hat Certified Engineer
  • Oracle Certified Professional
  • Microsoft Certified Engineer
  • ITIL v03 Certified

Languages

Hindi
First Language
English
Proficient (C2)
C2
German
Beginner
A1
Punjabi
Intermediate (B1)
B1

Timeline

Data Scientist/Analyst

DXC Technology
05.2016 - Current

Database Administrator

Deutsche Bank Gmbh
04.2015 - 03.2016

Senior Database Administrator

Xchanging Technology India Pvt Ltd
08.2010 - 03.2015

Post Graduate Diploma in Data Science and Business Analytics -

University of Texas

Masters in Computer Applications -

Kurukshetra University

Post Graduate Diploma in in Computer Applications -

Kurukshetra University

Bachelor of Arts (Hons) -

Kurukshetra University
Shally BatraSoftware Engineer