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 Performance Tuning: Leading the optimization of SQL and NoSQL queries, fine-tuning database performance to reduce latency and improve processing times.Data Modeling & Design: Creating and refining logical and physical data models to ensure data consistency, scalability, and optimal performance.Query Optimization: Analyzing and optimizing complex SQL queries and execution plans to improve database response times.Troubleshooting & Diagnostics: Conducting in-depth performance diagnostics and resolving bottlenecks across diverse database systems.#DatabaseOptimization, #SQLTuning, #NoSQL, #PerformanceTuning

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 various aspects of Risk and Controls related to Banking system- Giving performance tuning recommendations to multiple internal customers

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 Core OLTP application of RFT from on premise Oracle 12c to AWS RDS (Oracle) . - Resolved more than 2 year pending production issue of Oracle PGA memory leaks ( caused by Java leaks) for vendor application without increasing hardware as demanded by vendor, thus saving more than 50K per year.- Successfully lead team of 5 members following Agile Methodologies- Successful migration of RFT’s strategic datawarehouse and reporting system from Oracle 11g to 12c -Used new features like In-memory and partitioning . - Improved the datawarehouse SCD type-2 design which lead to reduction of overall size#DatabaseOptimization # DatabasePerformance # MySQLOptimization #FreelanceJobs #DatabaseManagement #IndependentContractor

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.• Database Performance tuning which includes CPU and Memory resizing, SQL and PL/SQL Tuning#QueryOptimization #DatabaseOptimization #freelancer #GigEconomy #FreelanceJobs #DatabaseScalability

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 applications for large sized customers across private and Public Sector in India with database size in Terabytes and concurrency of more than 500 people. •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•Database Performance tuning, SQL and PL/SQL Tuning- Analyzing tkprofs, tuning by changing/optimizing code , adding hints•Database design and Code reviews#DatabaseManagement #SQLPerformance #OraclePerformance #NoSQLPerformance #freelancer #GigEconomy #DatabaseExpert #QueryOptimization

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• Give presentations on Architecture and Tuning to internal teams• OS Monitoring- Analyzing and monitoring CPU loads and memory consumption, reading logsEnvironment: MySQL, PostgreSQL 10, Linux 2.6

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 • Created the scripts in PL/SQL, SQL and Unix ShellEnvironment: OWB 10g, Oracle 10g, PostgreSQL, PL/SQL, UNIX Shell Scripting, Oracle Enterprise Manager

• 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 batch runtime by hours• 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.• Tracked down the source of troublesome locking problems.• Devised and implemented a unique multi-threading technique based on Oracle parallelism that allowed a wider range of scaling than typically possible using parallelism• Attending the Customer conference calls and providing solutions during the calls• Analyzing and recommending solutions to Database performance issues based on Statspack and AWR report results by using Explain Plans, Raw traces• Tuning the PL/SQL packages by PL/SQL profiler package• Involved in the Benchmark Projects to tune the product modules (AR) Environment: Oracle Apps 11.5.10, R12, Oracle9i, 10g, PL/SQL, UNIX Shell Scripting

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 • Designed and Created 5 batch Jobs in DTS to integrate data from text files into database and to send data from SQL Server to text files for further processing in SAS modules. • Oracle9i Administration – tablespace creation, Users and privileges creation• Worked on Oracle’s built in HTP package, XML packages, UTL_FILE and Oracle WorkflowEnvironment: HP-UNIX, Shell Scripting, Oracle 9i, PostgreSQL, PL/SQL, SQL Server 2000, Transact SQL, DTS

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