Data Analyst Engineer

Aakash Deep Singh

+1-573-***-****/ **.******@*****.*** / Work Authorization/Visa Status: H1B (I-140 approved ) Cross-functional information technology professional responsible for Database Administration, Data scientist, Data Analyst, Database designing and modeling. 10+ years experience & excellent reputation for managing databases & deploying fraud rules, tactical designs, fast delivery, automation for various e-governance and mission critical projects across USA & INDIA. Expertise in python programing language & implementing AI and deep learning technologies on GPUs using both Tensorflow and pytorch.

SKILLS/ TOOLS

Database Administration

Database Modeling and Architecture

Database Capacity Planning & Performance Tuning

High availability and Disaster Recovery

Data Cleansing & Profiling

Data Visualization & Analytics

Data Migration and ETL

IBM DB2 & Oracle

EDUCATION/CERTIFICATION

Certified IBM Big Data Architect

Certified IBM DBA(DB2 UDB )

Masters of Technology (Computer Science) - Kurukshetra EMPLOYMENT DETAILS

TATA CONSULTANCY SERVICES (INDIA/USA, May 2010 - Present) Database Administrator - Data Scientist - Data Analyst - Data Migration Expert - Site Reliability Database Engineer - DevOps MOST RECENT PROJECTS

CLIENT: Department of Labor and Industrial relations, Missouri (Nov 2014- Present) PROJECT: Unemployment Insurance Modernization

TEAM SIZE: 12

ROLE: Lead Database Administrator - Data Scientist - Data Analyst - DataBase Migration Expert - Site Reliability Engineer - Dev Ops

• Building automated pipeline using Deep Learning to help calculating fraud scores while filing the claims.

• Automated the process of semantic segmentation of various documents.

• Implemented multiple deep learning/machine learning models & classification models.

• Creating interactive data dashboards by analyzing complex data elements.

• Ability to work with large data sets and to translate data into meaningful value

• Installing database servers and creating databases on different environments.

• High level design of database table spaces, buffer pools and schema creation.

• Physical and logical data modeling of data objects, data reconciliation and profiling.

• Migrating data from legacy non-relational systems to relational databases.

• Ensuring business continuity by performing & implementing data maintenance, backup planning and recovery, data reorganization and updating database statistics.

• Integrating transactional databases to data warehouse and operational data store.

• Performing feasibility study, requirement analysis and impact analysis for database changes for new/existing changes or enhancements.

• Collaborating in design of deployment solution in coordination with dev-ops team.

• Database monitoring and performance optimization, SQL analysis, database tuning and managing configurations.

• Monitoring table space growth using standard scripts and Handling file system space issues. Data Archival and Purging

Machine Learning

Deep Learning

Classification Models

Pattern Detection

Predictive Modeling

Statistical Data Analysis

Clustering

Tableau

Linux/Unix Shell Scripting

PL/SQL/ETL

Azure/AWS/Windows

Agile

Python

Jira/ALM

SVN/ Git

• Implementing and managing database row and column access control.

• Tuning database manager and database configuration parameters.

• Extensive capacity planning, monitoring and space management.

• Expertise in database upgrades and migrations.

• Managing database privileges and authorization for different roles and user groups.

• Expert in automating & monitoring database related activities.

• Data Security implementation with SSL, data encryption and data masking.

• Creating interactive data dashboards by analyzing complex data elements.

• Implementing data archival and purging rules

• Provide expert level technical guidance and directions to peers, peer groups, and client in all areas of database technologies. SECONDARY PROJECTS

CLIENT: WASHINGTON, OHIO, OREGON, KENTUCKY - Department of Labor (Jan 2017- Present) PROJECT: Unemployment Insurance Modernization

ROLE: Lead Database Architect / Migration Expert

• Documenting and representing TCS as Database Lead Architect & Migration Expert during initial bidding process and RFP

(Request for Proposal) submission

CLIENT: New York, Department of Labor (Dec 2017- Present) PROJECT: Unemployment Insurance Modernization

ROLE: Lead Database Architect / Migration Expert

• Documenting Database related information in response to Newyork state RFP (Request for Proposal) submission

• Database architect/ Migration Lead to represent TCS during initial bidding and demonstrations of product to Department of labor

• Designing project development plan, database system configurations and infrastructure

• Oversee database integration issues and co-ordinate with different teams to ensure stability

• Assisting project managers in the development of database related plans including detailed project estimates

• Mentoring less experienced personnel by organizing trainings and providing work guidance

• Ensuring data governance, standard procedures and guidelines are followed during migration

• Documented Database related information in response to Wyoming state RFP (Request for Proposal)

• Provided leadership on project deliverables and initiatives related to Database Operations and work across teams on delivering solutions to complex database performance problems, standard methodologies, conducting and developing configuration and compliance audits.

• Made recommendations on how to reduce complexity/improve operational agility and efficiency

• Provided consultative assistance to core DB teams regarding project deadlines, POCs and/or troubleshooting exercises. CLIENT: MISSISSIPPI, Department of Workforce Services (Dec 2015 - Present) PROJECT: Unemployment Insurance Modernization

ROLE: Lead Database Architect / Migration Expert

• Conducting interviews for hiring new DB resources and scheduling knowledge transfer trainings

• Assisting with critical performance & stability related issues and ensuring system consistency with ongoing need.

• Capable of quickly restoring service during system outages, provide troubleshooting support to team members, perform proactive problem prevention

PREVIOUS PROJECTS

CLIENT: Wyoming, Department of Workforce Services (Dec 2015 - Dec 2017) TEAM SIZE: 8 PROJECT: Unemployment Insurance Modernization

ROLE: Lead Database Architect / Migration Expert

• 24x7 Production Support in mission critical OLTP environment

• Involved in database installation/up gradation and migration in HACMP and Q-replication configured environment

• High water mark reduction using db2dart or object movement to reclaimable storage tablespaces

• Monitored DB2 UDB databases along with HADR and Q-Replication

• Database performance monitoring and tuning

• Planned and implemented Database maintenance activities involving coordination with other teams

• Enabled Tables and Index compression for sql optimization and storage management

• Scheduled various maintenance activities such as reorg, runstats, log purging as per requirements CLIENT: Ministry of External Affairs (May 2010- Oct 2014) TEAM SIZE: 11 PROJECT: Passport Seva Project

ROLE: Database Administrator

Contact this candidate