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 -
Professional 2 Networks at DXC Technology (Was transitioned from AT&T to DXC)Professional 2 Networks at DXC Technology (Was transitioned from AT&T to DXC)