Harmandeep Singh Email & Phone Number

Gurugram, Haryana, India

Working in Advance Customer Services (CSS) division on multiple Customer projects with primary focus on Performance Optimization, Database Design in live production environments.Architecting Database Solutions: Designing and implementing efficient, scalable, and high-performance database architectures that support complex applications.SQL & NoSQL.

Worked as Database and Solution Architect in centralized Architect team, helping the teams in CIB LOB during the cloud migration journey from in premise to cloud for all kind of databases- Migrating across database flavors like from Sybase to Postgresql, Sybase to SQL Server, Vertica to Redshift, Oracle to Postgresql etc.- Helping the teams understand.

Noida, Uttar Pradesh, India

Worked in Risk and Finance Team (RFT) LOB and helped the team in cloud migration to AWS from on-premise, database design, development and performance optimization of existing applications. All applications belonged to GRC(Governance, Risk and Compliance) domain which acts as golden source of all Control’s information for Bank- Successful Cloud migration of.

India

• Worked in Application Service Delivery(ASD) team as SME for applications and databases on Production and Development Systems
• PostgreSQL Performance Optimization for custom applications by adding partitions, indexes, implementing optimal object models/schema and managing large datasets using Sharding
• Upgrade of Demantra applications from oracle version 11.2.0.4 to 12.2.0.2. Performance got improved by more than 40% by implementing partitioning, indexing and code refactoring
• Upgrade of Amdocs applications from v7 to v10. Improved performance of web application and OLAP queries
• Working on performance of both Production and Dev servers for Oracle Apps, Demantra, Amdocs, Tableau and Datawarehouse systems
• Performed capacity planning for database growth.

Noida Area, India

• Worked in Advanced Customer Support (ACS) team as on-premises Database Consultant for Production environments of Indian clients(~25) which include Oracle Applications, PeopleSoft, Siebel, E-Commerce, Custom.
• Solved the issues by working with multiple business and technical teams of customers and Oracle
• Involved in database and application upgrades of Oracle Applications 11.5.10, R12.x, Peoplesoft
• Resolved pre and post go-live performance issues for Siebel, Oracle Apps
• Performance optimization of existing and new applications to help customer to meet SLA’s
• Involved in discussions on scalability of applications

Gurgaon, India

• Worked on multiple Rolta products and customer projects.
• MySQL, PostgreSQL for RoltaOne view Product
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
• Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
• Reducing various application level logging
• Datawarehouse performance testing, tuning and Performance Benchmarking

Bengaluru Area, India

• Worked for various Production environments of hosted clients which include Oracle Applications, PeopleSoft and E-Commerce applications.
• Database Performance tuning – Includes resizing Memory parameters, analyzing various logs and AWR/ADDM reports, setting various init.ora parameters,
• SQL and PL/SQL Tuning- Analyzing tkprofs, tuning by changing/optimizing code, adding hints
• OS Monitoring- Analyzing and monitoring CPU loads and memory consumption, reading logsEnvironment: Oracle 11g, 10g, PL/SQL, UNIX Shell Scripting, Linux & UNIX, Oracle Applications (11.5.10, R12), PeopleSoft 8.9/9.1

Singapore

• Worked on the migration project form Oracle 9i to 11g Responsibilities:
• Identifying and fixing the existing Oracle performance and scalability issues in the Night Batch process, Intra-day messaging system, Online Reports of intra-day applicaiton as part of 11g migration exercise
• Installation, Configuration and Administration of Oracle Weblogic Server 11g and Oracle Forms & Reports 11g on Solaris and Windows environment
• Migration of Oracle Forms and Reports from 10g to 11gEnvironment: Oracle 11g, 9i PL/SQL, Pro*C, UNIX Shell Scripting, Sun Solaris 5.10, Linux, Weblogic Server 11g, Oracle Forms and Reports 10g & 11g

Gurgaon, India

• FDM (Financial Data Mart) is backend data warehouse which gets data from the upstream systems and is used for reporting purposes for the end users.
• Suggested and implemented couple of design level changes in PL/SQL and SQL
• Developed diagrams for Data Structure Entity Relationship and Data Flow.
• Improved the timings of many OWB mappings and reports by tuning the underlying queries
• Providing level 2 production support for batch jobs and other online applications
• Recommending solutions and guiding other development team members about the new features like Partitioning, PL/SQL bulk

• Worked as Member of Oracle Application Performance group for Ebusiness Application Suite (Oracle Apps 11.5.10, R12)
• Worked with Oracle Apps Product development teams and External Oracle Apps Customers to provide design and performance solutions and recommendations for high priority and escalated Customer Performance Issues.
• Analyzed and provided numerous performance improvements to the Oracle Apps products. Drastically improved the runtime of many critical batch jobs and Oracle Apps concurrent programs. Performance fixes typically reduced.
• Advised designers/product managers on proper database performance optimization techniques
• Advised designers on proper partitioning techniques and performance bottlenecks
• Recommended and implemented partitioning adjustments, materialized views, summary tables, Oracle parallelism, indexing improvements, as well as improved SQL techniques.

Singapore

• Client: Essilor
• Gathered client requirements and understood project architecture during visit in Paris, France
• Designed and Implemented data loading method for downstream production data (text files) into Oracle database using SQL Loader and UNIX Shell Scripts
• Writing bulk operations code with the help of collections, ref-cursors, bulk loading and bulk fetching
• Developed packages, stored procedures, views, functions, triggers, tables, synonyms
• Designed and Developed DTS package to create tables, procedures, integrity constraints, users & roles and automating data migration process across Oracle to SQL Server platform

Pune, Chandigarh

• Project Name: SBCASSET and Provide IPClient: SBC, USA and British Telecom, London
• Provided design solutions, Proof of Concepts (POC) for new client requirements on database
• Database development in MySQL using Workbench 6.2 client
• Write data load scripts to pull the data from multiple data sources like SQL Server database, spreadsheets uploaded on a SFTP etc.
• Develop stored procedure to support database operations of application and generate Confidential complex reports
• Developed and Delivered the UNIX scripts for production deploymentsEnvironment: Shell Scripting, MySQL 5.X, SQL Server

Chandigarh Area, India

• Developed packages, stored procedures, views, functions, triggers, tables, synonyms
• Developed Packaging scripts for production deployments
• Gave training sessions on SQL Server and Oracle

Kapurthala, Punjab

As part of Industrial Training worked as Trainee for six months. Worked on Hardware Maintenance Project that was later put into Production. Environment:- Oracle 8i, Oracle Forms and Reports 6, PL/SQL

Bachelor Of Technology (B.Tech.), Computer Science

Senior Secondary