Waseem Ahmed Email & Phone Number

Gurugram, Hr, In

Gurugram

KEY RESPONSIBILITIES: • To develop and lead well-written, efficient database solution using Oracle 11g, SQL Server , ETL solutions to business functional requirements to be part of a project development team including Project Managers, Business Analysts, Front End Developers, Testers and Business representatives.• Managing database development requirements for the application spread across the locations (India, Singapore, New York and London).• Leading all the database analysis, coding and implementation and support tasks.• Build and support critical applications using Oracle 11g RDBMS and PL/SQL• Single point of contact for database architecture and design.• Troubleshoot and resolve, in conjunction with Operational DBAs, database application issues across production, test and development environments.• Take care of all database performance related issues.• Provide support to application group, testing, support and operations teams.• Single point of contact for any replication issue. Oracle stream is being used as the Replication solution for Databases at 3 centres (HKG, NYK, and LON).• Lead the analysis around Oracle 11g to 12c database migration.• Taking care of capacity planning of the infrastructure.• Involved with business for Archiving and purging activities to develop robust strategy.• Taking many initiatives around Code Simplification, Performance Improvements, Process Automation, Database Space compression, Unit Testing Automation using utPLSQL, Data Archiving and Data Purging etc.KEY SKILLS: -> knowledgeable of Hadoop/Pig/Hive/Sqoop -> Python Programming Proficiency. -> Exposure to Tableau. -> Analytical mindset with logical reasoning to incorporate appropriate business rules. -> Proficiency in Excel Data manipulation. -> Knowledge on Data Mining Models. -> Oracle and SQL Server database expertise. -> Expert in database performance tuning. -> Proficiency in using ETL tools for migration.

Gurgaon, India

KEY RESPONSIBILITIES: Ownership of Multiple Development modules. Coordination with front end design team providing necessary insight into the data regarding production environment. Implementation of optimal database design/objects coding for report generation. Performing extensive integrated Testing with multiple Components.ACCOMPLISHMENTS: Implemented Oracle, SQL Server, ETL modules for Bulk Data loading. Ad-Hoc involvement in running models on data such as Random Forest/PCA analysis. Implemented hive tables connecting with HBase thus providing DML features to hive components.KEY SKILLS: In Depth SQL, PL/SQL experience with performance tuning knowledge. Proficiency on HBase/Pig/Sqoop. Proficiency in Unix command/Shell scripting knowledge Hands on for python packages like pandas.

Gurgaon, India

Worked as Database developer.Responsibilities :1. Requirement gathering, Analyse , design and develop the code in database technologies like Oracle and SQL Server.2. Provide Technical Support to all application developers.3. Overall ownership in designing, developing , deployment and support database project.4. Data migration and preparing testing env. using ETO tools like Informatica.5. Create reports using OBI for business.6. Performance tuning.7. Coordination with DBA's for capacity planning, system performance and stability.

Post Graduate Program , Business Analytics, Business Analytics

Master Of Computer Applications - Mca, Computer Science, First